Listing all records

Displaying records 401 through 500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546576 MICU Brooklyn NEW YORK 12 Hour Days
546577 ICU Brooklyn NEW YORK 12 Hour Nights
546578 ER Brooklyn NEW YORK 12 Hour Nights
546590 Med Surg Brooklyn NEW YORK 12 Hour Days
546591 MICU Brooklyn NEW YORK 12 Hour Days
546593 ER Brooklyn NEW YORK 12 Hour Nights
547152 OR Brooklyn NEW YORK 8 Hour Days
547183 OR Brooklyn NEW YORK 12 Hour Nights
547185 Med Surg Brooklyn NEW YORK 12 Hour Days
547186 Med Surg Brooklyn NEW YORK 12 Hour Days
547187 Med Surg Brooklyn NEW YORK 8 Hour Nights
547188 Med Surg Brooklyn NEW YORK 12 Hour Days
547189 Surgical Tech Brooklyn NEW YORK 8 Hour Nights
547226 L&D Brooklyn NEW YORK 12 Hour Days
547235 NICU Brooklyn NEW YORK 12 Hour Days
547469 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
547560 Dialysis Per Diem Brooklyn NEW YORK 10 Hour Evenings RN/Registered Nurse
547750 NICU Brooklyn NEW YORK 12 Hour Nights
547751 NICU Brooklyn NEW YORK 12 Hour Nights
547752 Med Surg Brooklyn NEW YORK Nights
547753 Med Surg Brooklyn NEW YORK Nights
545171 Med Surg Brooklyn NEW YORK 8 Hour Evenings
545173 Med Surg Brooklyn NEW YORK 12 Hour Days
545178 Med Surg Brooklyn NEW YORK 8 Hour Evenings
545179 Med Surg Brooklyn NEW YORK 12 Hour Days
547930 ER Brownsville TEXAS 12 Hour Nights
547931 Telemetry Brownsville TEXAS 12 Hour Days
548289 OR Brownwood TEXAS 8 Hour Days RN/Registered Nurse
544990 PT Buckeye WEST VIRGINIA 8 Hour Days
544557 Cath Lab Burbank CALIFORNIA 8 Hour Days
544570 ICU Burbank CALIFORNIA 12 Hour Nights
545096 ER Burbank CALIFORNIA 12 Hour Nights
546035 PT Burbank CALIFORNIA 8 Hour Days
546036 PT Burbank CALIFORNIA 8 Hour Days
548076 Case Manager Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
548287 Med Surg Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
516546 ER Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
517382 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
518108 Case Manager Burbank CALIFORNIA 8 Hour Days
523775 ICU Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
524038 ICU - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
526099 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
527184 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
548134 Med Surg Tele Burien WASHINGTON 12 Hour Nights RN/Registered Nurse
541627 PT Butte MONTANA Days
548220 CNA Camarillo CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
530562 CT Tech Camp Hill PENNSYLVANIA 10 Hour Nights
538581 Long Term Care Canton NEW YORK 12 Hour Varied
547595 First Assist Canton OHIO 12 Hour Days
546819 Med Surg Tele Canton OHIO 12 Hour Nights
546903 Med Surg Tele Canton OHIO 12 Hour Nights
547824 Med Surg Tele Canton OHIO 12 Hour Nights
547564 Echo Technologist Cape Girardeau MISSOURI Days
534941 Med Surg Cape Girardeau MISSOURI Nights
534942 Med Surg Cape Girardeau MISSOURI Nights
535638 Rehab Cape Girardeau MISSOURI Nights
540565 Cath Lab Cape Girardeau MISSOURI Days
543455 OR Cape Girardeau MISSOURI Days
548246 Med Surg Tele CARMICHAEL CALIFORNIA 12 Hour Nights RN/Registered Nurse
532052 PT Carrizo Springs TEXAS Days
494609 PCU Casa Grande ARIZONA 12 Hour Nights
548198 ER Casa Grande ARIZONA 12 Hour Nights RN/Registered Nurse
548057 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
548147 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
526396 Therapy Rehab Cedar Falls IOWA Days
478398 PT Centerville IOWA Days
534167 Surgical Tech Centerville IOWA 8 Hour Days
548162 OR Centerville IOWA 8 Hour Days RN/Registered Nurse
546331 ER Centerville IOWA 12 Hour Days
546718 PCU Centralia WASHINGTON 12 Hour Nights
547846 Step Down Centralia WASHINGTON 12 Hour Nights
548049 RAD Tech Centralia WASHINGTON 8 Hour Days Tech/Technologist
548234 Psych Centreville ILLINOIS 12 Hour Nights RN/Registered Nurse
547682 Echo Technologist Chambersburg PENNSYLVANIA Varied
540516 RRT- Respiratory Chambersburg PENNSYLVANIA 12 Hour Day/Night Rotate
541829 RAD Tech CHANDLER ARIZONA 12 Hour Day/Night Rotate
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
547118 Interventional Radiology Tech CHANDLER ARIZONA 8 Hour Days
530245 Telemetry CHANDLER ARIZONA 12 Hour Nights
548098 Med Surg Tele Chandler ARIZONA 12 Hour Day/Night Rotate RN/Registered Nurse
548332 Clinic Chandler ARIZONA 8 Hour Days LPN/Licensed Practical Nurse
548370 ER Chandler ARIZONA 12 Hour Nights RN/Registered Nurse
541026 RAD Tech Charleston SOUTH CAROLINA 12 Hour Nights
542653 Telemetry Charleston SOUTH CAROLINA 12 Hour Nights
546739 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546740 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546742 Telemetry Charleston WEST VIRGINIA 12 Hour Nights
546743 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
546744 PCU Charleston WEST VIRGINIA 12 Hour Nights
546918 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546919 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546920 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
547394 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
544310 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
544311 Cath Lab Charleston WEST VIRGINIA 12 Hour Days
544753 Interventional Radiology Tech Charleston WEST VIRGINIA 10 Hour Days
546168 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
542242 Oncology Charlottesville VIRGINIA 12 Hour Nights
542243 Oncology Charlottesville VIRGINIA 12 Hour Nights
Slow: select count(*) from joborders a left join specialties b on a.specialty=b.id left join shifts c on a.shift=c.id left join job_titles d on a.title=d.id left join hospital z on z.id=a.hospital_id left join states y on y.id=z.state where closed=0 in 1.5675 seconds
Slow: select a.id,a.id,b.name as specialty,c.name as shift,d.name as title,z.city,y.name as state from joborders a left join specialties b on a.specialty=b.id left join shifts c on a.shift=c.id left join job_titles d on a.title=d.id left join hospital z on z.id=a.hospital_id left join states y on y.id=z.state where closed=0 order by z.city asc limit 400,100 in 1.6792 seconds