Listing all records

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

ID Job Specialty City State Shift Title
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
546331 ER Centerville IOWA 12 Hour Days
546366 ER Waterloo IOWA 12 Hour Nights
546461 ER Des Moines IOWA 12 Hour Days
546462 ER Des Moines IOWA 12 Hour Days
546635 ER Des Moines IOWA 12 Hour Nights
546679 OR Waterloo IOWA 12 Hour Days
546768 Med Surg IOWA CITY IOWA 12 Hour Nights
546770 Surgical Tech IOWA CITY IOWA Days
546785 Med Surg IOWA CITY IOWA 12 Hour Day/Night Rotate
546798 Interventional Radiology Tech IOWA CITY IOWA Days
546913 ER Des Moines IOWA 12 Hour Days
546934 RAD Tech Dubuque IOWA 12 Hour Nights
546999 Rehab Sioux City IOWA 12 Hour Nights
547000 Med Surg Dubuque IOWA 12 Hour Days
547002 Med Surg Dubuque IOWA 12 Hour Days
547068 CT Tech Pella IOWA 12 Hour Nights
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
547332 SLP Garden City KANSAS Varied
547470 CT Tech Hays KANSAS 8 Hour Nights
547609 OT Garden City KANSAS 8 Hour Days
547851 Nuclear Med Technician Liberal KANSAS 8 Hour Days
542401 Surgical Tech Leavenworth KANSAS 8 Hour Days
542402 Sterile Processing Tech Leavenworth KANSAS 8 Hour Days
542697 Therapy Rehab Garden City KANSAS 8 Hour Days
544167 PT Garden City KANSAS 12 Hour Day/Night Rotate
544972 PT Garden City KANSAS Varied
546011 Surgical Tech CVOR Hays KANSAS 10 Hour Days
546012 PCU Hays KANSAS 12 Hour Nights
544508 Cath Lab Edgewood KENTUCKY 10 Hour Days
544509 Cath Lab Edgewood KENTUCKY 10 Hour Days
542573 Surgical Tech Louisville KENTUCKY 12 Hour Days
541736 OR Louisville KENTUCKY 10 Hour Days
543419 SICU Bowling Green KENTUCKY 12 Hour Nights
543952 Cath Lab Louisville KENTUCKY 8 Hour Days
547928 Cath Lab Lexington KENTUCKY 8 Hour Days
546469 OR Louisville KENTUCKY 8 Hour Days
546651 Surgical Tech Louisville KENTUCKY 8 Hour Days
546682 RAD Tech Lexington KENTUCKY 10 Hour Days
547585 RRT- Respiratory Louisville KENTUCKY 12 Hour Days
547888 Cath Lab Danville KENTUCKY 10 Hour Days
515845 MLT Louisville KENTUCKY Nights
521665 Surgical Tech Louisville KENTUCKY 12 Hour Day/Night Rotate
524484 Cath Lab Louisville KENTUCKY 12 Hour Nights
525673 Cardiology Louisville KENTUCKY 8 Hour Days
527553 Cath Lab Louisville KENTUCKY 8 Hour Days
528270 Surgical Tech Louisville KENTUCKY 12 Hour Days
531388 Cath Lab Louisville KENTUCKY 12 Hour Nights
532201 RAD Tech Louisville KENTUCKY 8 Hour Days
532202 RAD Tech Louisville KENTUCKY 8 Hour Days
532559 MRI Tech Louisville KENTUCKY 10 Hour Days
532661 MLT Louisville KENTUCKY 8 Hour Evenings
534553 Surgical Tech Louisville KENTUCKY 8 Hour Days
535030 Surgical Tech Louisville KENTUCKY 12 Hour Days
536463 ICU Lexington KENTUCKY 12 Hour Nights
537910 PCU Lexington KENTUCKY 12 Hour Nights
538869 MRI Tech Lexington KENTUCKY 8 Hour Nights
546342 Cath Lab Lexington KENTUCKY 10 Hour Days
539378 RAD Tech Louisville KENTUCKY 12 Hour Nights
539930 Surgical Tech Louisville KENTUCKY 8 Hour Days
548308 ER Deridder LOUISIANA 12 Hour Nights RN/Registered Nurse
548325 SLP Shreveport LOUISIANA 8 Hour Days SLP/Speech Language Pathologist
544772 Home Health Lake Charles LOUISIANA 8 Hour Days
547893 Certified Surgical Tech Lake Charles LOUISIANA 8 Hour Days
546604 RAD Tech Lewiston MAINE 10 Hour Days
547094 Surgical Tech CVOR Lewiston MAINE 10 Hour Days
547302 MLT York MAINE 8 Hour Day/Night Rotate
547427 ICU York MAINE 12 Hour Nights
547574 Med Surg Lewiston MAINE 12 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.5858 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 1900,100 in 1.7777 seconds