Listing all records

Displaying records 1901 through 2000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545206 Orthopedics Des Moines IOWA 12 Hour Nights
545207 ER Des Moines IOWA 12 Hour Nights
545238 ER Des Moines IOWA 12 Hour Nights
546704 CT Tech Des Moines IOWA 10 Hour Days
545279 Cardiovascular Dubuque IOWA 12 Hour Days
545498 Respiratory Therapist Des Moines IOWA 12 Hour Days
545499 Respiratory Therapist Des Moines IOWA 12 Hour Days
545500 Med Surg Tele Des Moines IOWA 12 Hour Days
545501 Med Surg Tele Des Moines IOWA 12 Hour Days
546674 Interventional Radiology Des Moines IOWA 8 Hour Days
546140 Med Surg Tele Des Moines IOWA 12 Hour Nights
546141 Med Surg Des Moines IOWA 12 Hour Days
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
544265 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544266 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
545190 Pharmacy Tech Mishawaka INDIANA 8 Hour Nights
545425 L&D Mishawaka INDIANA 12 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
545427 NICU Mishawaka INDIANA 12 Hour Nights
545553 Outpatient Clinic Greencastle INDIANA 10 Hour Days
548169 Interventional Radiology Tech Indianaplis INDIANA 10 Hour Nights Radiology Techs/Technologists
548108 Case Manager Indianaplis INDIANA 8 Hour Days RN/Registered Nurse
548111 Respiratory Therapist Indianapolis INDIANA 12 Hour Nights Respiratory Therapist
548139 Newborn Nursery Marion INDIANA 12 Hour Nights RN/Registered Nurse
544964 Nuclear Med Technician Mishawaka INDIANA 8 Hour Days
542615 Telemetry Terre Haute INDIANA 12 Hour Nights
546294 Administration Marion INDIANA 12 Hour Nights
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
546908 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
547444 Med Surg Bloomington INDIANA 12 Hour Nights
474328 PT North Manchester INDIANA Days
495103 SLP South Bend INDIANA Days
524675 CVOR Mishawaka INDIANA 12 Hour Days
537193 Med Surg Bloomington INDIANA 12 Hour Nights
539715 Respiratory Therapist Mishawaka INDIANA 12 Hour Days
541847 Psych Peoria ILLINOIS 8 Hour Days RN/Registered Nurse
524930 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524932 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524933 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524972 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524989 Telemetry Maywood ILLINOIS 12 Hour Nights
532921 SLP Edwardsville ILLINOIS 8 Hour Days
532473 ICU Maywood ILLINOIS 12 Hour Nights
532545 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
535604 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536227 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
536228 RAD Tech Maywood ILLINOIS 8 Hour Nights
536231 CT Tech Maywood ILLINOIS 8 Hour Evenings
536440 Infusion Oncology Maywood ILLINOIS 8 Hour Days
536499 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536500 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536501 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536502 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536503 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536504 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536505 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536506 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536507 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536508 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536932 RAD Tech Maywood ILLINOIS 8 Hour Days
545194 OR Paris ILLINOIS 8 Hour Evenings
538435 CT Tech Harvard ILLINOIS 8 Hour Evenings
540632 OR Maywood ILLINOIS 10 Hour Days
540706 Cardiac ICU Rockford ILLINOIS 12 Hour Nights
542451 ER Rockford ILLINOIS 12 Hour Nights
546182 Med Surg Peoria ILLINOIS 12 Hour Nights
544293 OR Maywood ILLINOIS 10 Hour Days
544294 OR Maywood ILLINOIS 10 Hour Days
544397 Med Surg Peoria ILLINOIS 12 Hour Days RN/Registered Nurse
544818 OR Maywood ILLINOIS 10 Hour Days
544832 MLT East St Louis ILLINOIS 8 Hour Evenings
545188 Certified Surgical Tech Paris ILLINOIS 8 Hour Varied
545213 RAD Tech New Lenox ILLINOIS 10 Hour Days
545342 Home Health Rockford ILLINOIS 12 Hour Day/Night Rotate
545564 RAD Tech Peoria ILLINOIS 8 Hour Days
545597 Med Surg Peoria ILLINOIS 12 Hour Nights
545605 ER Peoria ILLINOIS 12 Hour Nights
545960 Cath Lab Berwyn ILLINOIS 8 Hour Days
547942 PACU Sterling ILLINOIS 8 Hour Days
548022 OT Rehab Rushville ILLINOIS Varied
548214 Psych Peoria ILLINOIS 12 Hour Evenings RN/Registered Nurse
548226 CST Peoria ILLINOIS 10 Hour Days CST/Certified Surgical Technician
548228 EP Tech Evanston ILLINOIS 8 Hour Days Advanced Practice
548234 Psych Centreville ILLINOIS 12 Hour Nights RN/Registered Nurse
548375 ICU Chicago ILLINOIS 12 Hour Nights RN/Registered Nurse
548404 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
546367 OR Maywood ILLINOIS 10 Hour Days
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
546805 OR Peoria ILLINOIS Nights
546787 CT Tech Robinson ILLINOIS 8 Hour Evenings
546830 Clinic Peoria ILLINOIS 8 Hour Days
546832 Therapy Rehab Spring Valley ILLINOIS 12 Hour Day/Night Rotate
546845 Med Surg Peoria ILLINOIS 12 Hour Nights
547007 CT Tech Maryville ILLINOIS 12 Hour Nights
547143 Neuro Med Surg/Tele Peoria ILLINOIS 12 Hour Nights
547273 Certified Surgical Tech Peoria ILLINOIS 8 Hour Days
547529 Sterile Processing Tech Berwyn ILLINOIS 8 Hour Evenings
548031 Cath Lab Berwyn ILLINOIS 8 Hour Days
546187 CT Tech Emmett IDAHO 8 Hour Days
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.6209 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 y.name desc limit 1900,100 in 1.3212 seconds