Listing all records

Displaying records 601 through 700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546904 Telemetry Cleveland OHIO 12 Hour Nights
546943 Med Surg Tele Cleveland OHIO 12 Hour Nights
547013 Med Surg Tele Cleveland OHIO 12 Hour Days
547014 Med Surg Tele Cleveland OHIO 12 Hour Days
547015 Med Surg Tele Cleveland OHIO 12 Hour Days
547016 Med Surg Tele Cleveland OHIO 12 Hour Days
547104 Med Surg Tele Cleveland OHIO 12 Hour Nights
547107 Step Down Cleveland OHIO 12 Hour Nights
547108 Clinic Cleveland OHIO 12 Hour Nights
547389 CT Tech Cleveland OHIO 8 Hour Nights
547390 CT Tech Cleveland OHIO 8 Hour Evenings
547392 Cath Lab Cleveland OHIO Days
547393 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547788 RRT- Respiratory Cleveland OHIO 12 Hour Nights
547805 ER Cleveland OHIO 12 Hour Day/Night Rotate
547808 RAD Tech Cleveland OHIO 10 Hour Day/Night Rotate
547809 RAD Tech Cleveland OHIO 8 Hour Days
547850 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
544142 Cath Lab Cleveland OHIO 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
544158 PACU Cleveland OHIO 12 Hour Nights
544312 BMT Cleveland OHIO 12 Hour Day/Night Rotate
544313 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
544574 ICU Cleveland OHIO 12 Hour Day/Night Rotate
544628 Psych Cleveland OHIO 12 Hour Nights
544788 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
544848 Pharmacy Tech Cleveland OHIO 8 Hour Days
545071 RRT- Respiratory Cleveland OHIO 12 Hour Nights
545103 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545104 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545165 Telemetry Cleveland OHIO 12 Hour Nights
545227 Telemetry Cleveland OHIO 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
545229 Telemetry Cleveland OHIO 12 Hour Nights
545230 Telemetry Cleveland OHIO 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
545232 Step Down Cleveland OHIO 12 Hour Nights
545233 Step Down Cleveland OHIO 12 Hour Nights
546643 Cath Lab Cleveland OHIO 10 Hour Days
545582 Step Down Cleveland OHIO 12 Hour Nights
546169 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546170 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
548024 Telemetry Cleveland OHIO 12 Hour Nights
548105 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
548363 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
548376 Med Surg Tele Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548380 Med Surg Tele Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548395 Telemetry Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548408 OR Cleveland OHIO 12 Hour Days RN/Registered Nurse
540931 Med Surg Tele Cleveland OHIO 12 Hour Nights
541381 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
542525 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
542526 ICU Cleveland OHIO 12 Hour Day/Night Rotate
542601 Ambulatory Cleveland OHIO 8 Hour Days
542908 ICU Cleveland OHIO 12 Hour Day/Night Rotate
543044 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
543045 Sterile Processing Tech Cleveland OHIO 8 Hour Evenings
543214 Telemetry Cleveland OHIO 12 Hour Nights
543215 Telemetry Cleveland OHIO 12 Hour Nights
543259 Step Down Cleveland OHIO 12 Hour Nights
543260 Step Down Cleveland OHIO 12 Hour Nights
543387 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
544116 Telemetry Cleveland OHIO 12 Hour Nights
539711 CT Tech Clinton IOWA 12 Hour Days
535387 Rehab Clive IOWA 12 Hour Nights
542497 PT Clovis NEW MEXICO 8 Hour Days
546110 PTA Clovis NEW MEXICO 8 Hour Days
548086 Ultrasound Tech Cobleskill NEW YORK 8 Hour Days Tech/Technologist
548106 ER Cobleskill NEW YORK 12 Hour Nights RN/Registered Nurse
526368 COTA Colfax WISCONSIN Days
521068 Echo Columbia SOUTH CAROLINA 8 Hour Days
538580 Echo Technologist Columbia MISSOURI Days
548091 OR Columbia SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
542718 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547021 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547022 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
547652 Echo Columbia SOUTH CAROLINA 8 Hour Days
547865 Certified Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547872 Med Surg Columbia MISSOURI 12 Hour Nights
547873 Endoscopy Columbia MISSOURI 8 Hour Varied
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
545539 Interventional Radiology Tech Columbia SOUTH CAROLINA 8 Hour Days
545239 ER Columbus OHIO Nights
545421 RN Columbus OHIO 12 Hour Nights
545541 RAD Tech Columbus OHIO 8 Hour Nights
545542 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
546047 MLT Columbus OHIO Nights
540624 Surgical Tech Columbus OHIO 12 Hour Days
543116 RN Columbus OHIO 8 Hour Days
543117 RN Columbus OHIO 10 Hour Days
543118 RN Columbus OHIO 12 Hour Nights
543119 Surgical Tech Columbus OHIO 12 Hour Days
548265 ICU Columbus OHIO 12 Hour Nights RN/Registered Nurse
525606 RAD Tech Columbus OHIO 8 Hour Evenings Radiology Techs/Technologists
534546 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
535178 Interventional Radiology Tech Columbus OHIO 8 Hour Days
535179 CT Tech Columbus OHIO 12 Hour Days
538717 Surgical Tech Columbus OHIO Days
538720 RN Columbus OHIO 12 Hour Days
548032 CT Tech Columbus OHIO 10 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.5529 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 600,100 in 1.6933 seconds