Listing all records

Displaying records 1001 through 1100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
547466 NICU Des Moines IOWA 12 Hour Nights
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
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
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
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
533260 RAD Tech Des Moines IOWA 10 Hour Days
534242 Med Surg Tele Des Moines IOWA 12 Hour Nights
535227 Orthopedics Des Moines 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
537922 Neuro Med Surg/Tele Des Moines IOWA 12 Hour Nights
538590 ER Des Moines IOWA 12 Hour Nights
539078 MLT Des Moines IOWA 8 Hour Days
539093 MLT Des Moines IOWA 12 Hour Days
539095 MLT Des Moines IOWA 8 Hour Days
539670 Med Surg Tele Des Moines IOWA 12 Hour Nights
539713 Oncology Des Moines IOWA 12 Hour Nights
539714 Oncology Des Moines IOWA 12 Hour Nights
535912 CT Tech Detroit MICHIGAN 12 Hour Nights
546348 Cardiac ICU Detroit MICHIGAN 12 Hour Nights
546349 Interventional Radiology Detroit MICHIGAN 8 Hour Days
546684 L&D Detroit MICHIGAN 12 Hour Days
546924 Cath Lab Detroit MICHIGAN 8 Hour Days
547245 Ultrasound Tech Detroit MICHIGAN 8 Hour Days
547247 Surgical Tech Detroit MICHIGAN 8 Hour Days
547779 MLT Detroit MICHIGAN 8 Hour Evenings
548315 Surgical Tech Detroit MICHIGAN 8 Hour Days Tech/Technologist
546929 Interventional Radiology Tech Detroit MICHIGAN 10 Hour Days
543787 PICU Detroit MICHIGAN 12 Hour Days
544792 Orthopedics Detroit MICHIGAN 12 Hour Nights
544937 Med Surg Detroit MICHIGAN 12 Hour Nights
543590 L&D Devils Lake NORTH DAKOTA 12 Hour Day/Night Rotate
535143 OT Rehab Devils Lake NORTH DAKOTA 8 Hour Days
545058 ER Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
543439 L&D Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
547704 Scrub Tech DILLON MONTANA 10 Hour Day/Night Rotate
547648 RAD Tech Dothan ALABAMA 8 Hour Days
546167 Med Surg Tele Dothan ALABAMA 12 Hour Nights
544224 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
544225 Med Surg Dover NEW JERSEY 12 Hour Nights
536704 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
538547 Med Surg Dover NEW JERSEY 12 Hour Days
538549 Med Surg Dover NEW JERSEY 12 Hour Nights
538550 Med Surg Dover NEW JERSEY 12 Hour Nights
538551 Med Surg Dover NEW JERSEY 12 Hour Nights
547105 Step Down Dover OHIO 12 Hour Nights
546934 RAD Tech Dubuque IOWA 12 Hour Nights
547000 Med Surg Dubuque IOWA 12 Hour Days
547002 Med Surg Dubuque IOWA 12 Hour Days
544202 RAD Tech Dubuque IOWA 8 Hour Days
545279 Cardiovascular Dubuque IOWA 12 Hour Days
524678 Cath Lab Dubuque IOWA 10 Hour Days
531580 ICU Dubuque IOWA 12 Hour Days
540912 Med Surg Dubuque IOWA 12 Hour Nights
543331 Cath Lab Dubuque IOWA 10 Hour Days
539200 Med Surg Dubuque IOWA 12 Hour Days
537821 Dosimetrist Duluth MINNESOTA Varied
539087 Oncology Duluth MINNESOTA 12 Hour Day/Night Rotate
547111 Ophthalmic Tech Duluth MINNESOTA Days
544604 Surgical Tech Duluth MINNESOTA 12 Hour Day/Night Rotate
544615 OR Duluth MINNESOTA 8 Hour Day/Night Rotate
506863 Surgical Tech Durham NORTH CAROLINA 10 Hour Days
539199 Med Surg Dyersville IOWA 12 Hour Nights
472544 PT E Lamberton MINNESOTA Days
491571 Therapy Rehab E Lamberton MINNESOTA Days
541392 OR East Norriton PENNSYLVANIA 8 Hour Days
546470 ICU East Norriton PENNSYLVANIA 12 Hour Days
546471 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Nights
546472 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Days
546698 ICU East Norriton PENNSYLVANIA 12 Hour Nights
546925 ER East Norriton PENNSYLVANIA 12 Hour Nights
544832 MLT East St Louis ILLINOIS 8 Hour Evenings
544508 Cath Lab Edgewood KENTUCKY 10 Hour Days
544509 Cath Lab Edgewood KENTUCKY 10 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 2.4956 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 1000,100 in 1.4207 seconds