Listing all records

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

ID Job Specialty City State Shift Title
547120 Neurology Des Moines IOWA 12 Hour Nights
547122 Med Surg Des Moines IOWA 12 Hour Nights
547123 Med Surg Des Moines IOWA 12 Hour Nights
547124 Orthopedics Des Moines IOWA 12 Hour Nights
547125 Orthopedics Des Moines IOWA 12 Hour Nights
547126 ER Des Moines IOWA 12 Hour Days
547277 CT Tech Sioux City IOWA 10 Hour Nights
547297 Med Surg Tele Denison IOWA 12 Hour Nights
547466 NICU Des Moines IOWA 12 Hour Nights
547593 ICU Newton IOWA 12 Hour Nights
547675 OR Waterloo IOWA 12 Hour Days
547844 CT Tech Des Moines IOWA 10 Hour Days
547918 ER Des Moines IOWA 12 Hour Nights
547919 ER Des Moines IOWA 12 Hour Days
547920 ER Des Moines IOWA 12 Hour Days
548162 OR Centerville IOWA 8 Hour Days RN/Registered Nurse
548163 OR Mason City IOWA 8 Hour Days RN/Registered Nurse
548005 Med Surg Tele Des Moines IOWA 12 Hour Nights
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
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
538542 Cath Lab Mason City IOWA 8 Hour Days
538590 ER Des Moines IOWA 12 Hour Nights
538598 RAD Tech IOWA CITY IOWA Varied
538714 Respiratory Therapist Mason City IOWA 12 Hour Nights
539078 MLT Des Moines IOWA 8 Hour Days
539089 PT Fort Dodge IOWA 8 Hour Days
539093 MLT Des Moines IOWA 12 Hour Days
539095 MLT Des Moines IOWA 8 Hour Days
543331 Cath Lab Dubuque IOWA 10 Hour Days
539200 Med Surg Dubuque IOWA 12 Hour Days
539670 Med Surg Tele Des Moines IOWA 12 Hour Nights
539710 Echo Sioux City IOWA 8 Hour Days
539711 CT Tech Clinton IOWA 12 Hour Days
539712 Home Health Mason City IOWA 8 Hour Days
539713 Oncology Des Moines IOWA 12 Hour Nights
539714 Oncology Des Moines IOWA 12 Hour Nights
539734 PTA Avoca IOWA Days
541107 Ultrasound Tech Sioux City IOWA 8 Hour Days
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
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.4047 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 1800,100 in 1.4486 seconds