Listing all records

Displaying records 1801 through 1900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548006 Med Surg Tele Des Moines IOWA 12 Hour Days
548007 Med Surg Tele Des Moines IOWA 12 Hour Days
548033 Med Surg Tele Des Moines IOWA 12 Hour Days
548034 ICU Newton IOWA 12 Hour Nights
544202 RAD Tech Dubuque IOWA 8 Hour Days
544204 Med Surg Sioux City IOWA 12 Hour Days
544217 Med Surg Pella IOWA 12 Hour Nights
545252 GI Lab Mason City IOWA 8 Hour Days
544435 ER IOWA CITY IOWA 12 Hour Nights
544436 ER IOWA CITY IOWA 12 Hour Nights
544437 ER IOWA CITY IOWA 12 Hour Days
544449 Med Surg Tele Des Moines IOWA 12 Hour Nights
544450 Med Surg Tele Des Moines IOWA 12 Hour Nights
544531 ER Des Moines IOWA 12 Hour Nights
544598 MLT Des Moines IOWA 8 Hour Days
544705 ER Des Moines IOWA 12 Hour Nights
544706 NICU Des Moines IOWA 12 Hour Days
544889 MLT Mason City IOWA 8 Hour Days
545205 Med Surg Des Moines IOWA 12 Hour Nights
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
540351 Cath Lab Waterloo IOWA 8 Hour Days
540582 Med Surg Des Moines IOWA 12 Hour Nights
540583 Orthopedics Des Moines IOWA 12 Hour Nights
540626 OR Mason City IOWA 8 Hour Days
540627 OR Mason City IOWA 8 Hour Days
540628 OR Mason City IOWA 8 Hour Days
540972 MLT Des Moines IOWA 10 Hour Nights
541071 Med Surg Tele Des Moines IOWA 12 Hour Nights
541072 Orthopedics Des Moines IOWA 12 Hour Nights
541076 Med Surg Des Moines IOWA 12 Hour Nights
541078 Oncology Des Moines IOWA 12 Hour Nights
541108 Ultrasound Tech Sioux City IOWA 8 Hour Days
543024 Interventional Radiology Des Moines IOWA 10 Hour Days
542387 Med Surg Des Moines IOWA 12 Hour Days
542423 OR IOWA CITY IOWA 10 Hour Days
542424 PT Norwalk IOWA Days
542466 Neurology Des Moines IOWA 12 Hour Nights
542642 Cath Lab Mason City IOWA 8 Hour Days
544434 Telemetry IOWA CITY IOWA 12 Hour Nights
543122 ER Primghar IOWA 12 Hour Nights
543123 ER Primghar IOWA 12 Hour Nights
543126 Cath Lab Mason City IOWA 8 Hour Days
543729 OR Pella IOWA 10 Hour Varied
544530 Med Surg Waterloo IOWA 12 Hour Nights
478398 PT Centerville IOWA Days
480893 PT Toledo IOWA Days
548263 CNA Hampton IOWA 12 Hour Evenings CNA/Certified Nursing Assistant
518165 Endoscopy IOWA CITY IOWA Days
541798 L&D Newton IOWA 12 Hour Nights
524678 Cath Lab Dubuque IOWA 10 Hour Days
525066 PT Mason City IOWA 8 Hour Days
525077 LPN/LVN Mason City IOWA 12 Hour Days
525078 LPN/LVN Mason City IOWA 12 Hour Nights
526396 Therapy Rehab Cedar Falls IOWA Days
528026 Med Surg Mason City IOWA 12 Hour Nights
528028 Med Surg Mason City IOWA 12 Hour Nights
528477 Respiratory Therapist Mason City IOWA 12 Hour Days
530228 CVOR Sioux City IOWA 10 Hour Days
531580 ICU Dubuque IOWA 12 Hour Days
531884 PTA Avoca IOWA Days
532546 MRI Tech Mason City IOWA 12 Hour Days
532907 Ultrasound Tech Mason City IOWA 8 Hour Days
533009 Cath Lab Mason City IOWA 8 Hour Days
533010 Cath Lab Mason City IOWA 8 Hour Days
533011 Respiratory Therapist Mason City IOWA 12 Hour Days
533012 Respiratory Therapist Mason City IOWA 12 Hour Days
533013 Respiratory Therapist Mason City IOWA 12 Hour Nights
533014 Respiratory Therapist Mason City IOWA 12 Hour Nights
533260 RAD Tech Des Moines IOWA 10 Hour Days
534167 Surgical Tech Centerville IOWA 8 Hour Days
534242 Med Surg Tele Des Moines IOWA 12 Hour Nights
534799 Sonographer Mason City IOWA 12 Hour Days
535227 Orthopedics Des Moines IOWA 12 Hour Nights
535231 Cath Lab Sioux City IOWA 8 Hour Days
535387 Rehab Clive IOWA 12 Hour Nights
535418 Respiratory Therapist Mason City IOWA 12 Hour Days
535463 ICU Sioux City IOWA 12 Hour Nights
535651 COTA Rock Rapids IOWA Days
539199 Med Surg Dyersville IOWA 12 Hour Nights
536650 Med Surg IOWA CITY IOWA 12 Hour Nights
537419 Med Surg Tele Des Moines IOWA 12 Hour Nights
537420 Med Surg Tele Des Moines IOWA 12 Hour Nights
537423 Neurology Des Moines IOWA 12 Hour Nights
537424 Neurology Des Moines IOWA 12 Hour Nights
537431 Med Surg Des Moines IOWA 12 Hour Nights
537432 Med Surg Des Moines IOWA 12 Hour Nights
540912 Med Surg Dubuque IOWA 12 Hour Nights
538136 Echo Mason City IOWA 12 Hour Days
537922 Neuro Med Surg/Tele Des Moines IOWA 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.6561 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 asc limit 1800,100 in 1.6501 seconds