Listing all records

Displaying records 2001 through 2100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
541782 ICU Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547065 Med Surg Grand Forks NORTH DAKOTA Days
547448 Med Surg Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547816 Angiography Grand Forks NORTH DAKOTA Days
547817 Respiratory Therapist Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547903 Surgical Tech Grand Forks NORTH DAKOTA Evenings
546345 CT Tech Goodyear ARIZONA 10 Hour Days
547781 CT Tech Goodyear ARIZONA 10 Hour Nights
546912 ER Goldendale WASHINGTON 12 Hour Days
547975 ER Goldendale WASHINGTON 12 Hour Nights
548029 PT Goldendale WASHINGTON Days
546886 PT Globe ARIZONA Days
548020 MRI Tech Glenwood Springs COLORADO 12 Hour Varied
544144 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544145 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
545338 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
547956 Surgical Tech Glens Falls NEW YORK 10 Hour Days
547959 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
548055 ER Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
548127 ICU Glens Falls NEW YORK 12 Hour Days RN/Registered Nurse
548136 ICU Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
544067 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
547267 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
547274 Med Surg Glens Falls NEW YORK 12 Hour Nights
547916 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547917 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
542785 Case Manager Glens Falls NEW YORK 8 Hour Days
544975 CT Tech Glendive MONTANA 8 Hour Varied
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
536164 Med Surg Glendale ARIZONA 12 Hour Days
547761 CT Tech Glendale ARIZONA 8 Hour Days
547762 PCU Glendale ARIZONA 12 Hour Nights
547763 CT Tech Glendale ARIZONA 10 Hour Nights
548002 ICU Gillette WYOMING 12 Hour Day/Night Rotate
548244 Surgical Tech GILBERT ARIZONA 12 Hour Nights Tech/Technologist
548245 Surgical Tech Gilbert ARIZONA 12 Hour Nights RN/Registered Nurse
545125 RAD Tech Gig Harbor WASHINGTON 8 Hour Day/Night Rotate
544201 OR Germantown MARYLAND 8 Hour Evenings
544482 OR Germantown MARYLAND 8 Hour Days
536728 Interventional Radiology Germantown MARYLAND 8 Hour Days
536758 OR Germantown MARYLAND 8 Hour Days
538172 MRI Tech Germantown MARYLAND 10 Hour Days
547723 Med Surg Georgetown SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
542910 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
545136 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
545030 OR Gardner MASSACHUSETTS 10 Hour Days
546784 Pediatrics Gardner MASSACHUSETTS 12 Hour Nights
547332 SLP Garden City KANSAS Varied
547609 OT Garden City KANSAS 8 Hour Days
544167 PT Garden City KANSAS 12 Hour Day/Night Rotate
544972 PT Garden City KANSAS Varied
542697 Therapy Rehab Garden City KANSAS 8 Hour Days
546172 Med Surg Tele Gallipolis OHIO 12 Hour Nights
546378 Med Surg Tele Gallipolis OHIO 12 Hour Nights
546431 Med Surg Gainesville FLORIDA 12 Hour Days
546476 Med Surg Gainesville FLORIDA 12 Hour Nights
546762 Interventional Radiology Tech Gainesville FLORIDA 10 Hour Days
545617 Med Surg Gainesville FLORIDA 12 Hour Days
545618 MLT Gainesville FLORIDA 8 Hour Nights
545619 Med Surg Gainesville FLORIDA 12 Hour Nights
545620 Med Surg Gainesville FLORIDA 12 Hour Nights
545627 Cardiology Gainesville FLORIDA 12 Hour Nights
545628 Med Surg Gainesville FLORIDA 12 Hour Days
545629 ICU Gainesville FLORIDA 12 Hour Nights
545630 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545631 ICU Gainesville FLORIDA 12 Hour Nights
545632 Med Surg Gainesville FLORIDA 12 Hour Days
545633 Med Surg Gainesville FLORIDA 12 Hour Nights
545634 Med Surg Gainesville FLORIDA 12 Hour Days
545635 Med Surg Gainesville FLORIDA 12 Hour Nights
545636 ICU Gainesville FLORIDA 12 Hour Nights
545637 ICU Gainesville FLORIDA 12 Hour Nights
545638 Med Surg Gainesville FLORIDA 12 Hour Days
545639 ICU Gainesville FLORIDA 12 Hour Nights
545640 EEG Tech Gainesville FLORIDA 10 Hour Days
545641 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545642 Med Surg Gainesville FLORIDA 12 Hour Nights
545643 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545644 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545645 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545646 Med Surg Gainesville FLORIDA 12 Hour Days
545647 Med Surg Gainesville FLORIDA 12 Hour Days
545648 RAD Tech Gainesville FLORIDA 12 Hour Nights
545649 RAD Tech Gainesville FLORIDA 12 Hour Nights
545650 RAD Tech Gainesville FLORIDA 10 Hour Nights
545651 RAD Tech Gainesville FLORIDA 10 Hour Nights
545652 Med Surg Gainesville FLORIDA 12 Hour Nights
545653 Med Surg Gainesville FLORIDA 12 Hour Nights
545654 Med Surg Gainesville FLORIDA 12 Hour Nights
545655 Med Surg Gainesville FLORIDA 12 Hour Nights
545656 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545657 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545658 Med Surg Gainesville FLORIDA 12 Hour Days
545659 Med Surg Gainesville FLORIDA 12 Hour Days
545660 Med Surg Gainesville FLORIDA 12 Hour Days
545661 Med Surg Gainesville FLORIDA 12 Hour Days
545662 MLT Gainesville FLORIDA 12 Hour Nights
545663 MLT Gainesville FLORIDA 12 Hour Nights
545664 MLT Gainesville FLORIDA 8 Hour Days
545665 Surgical Tech Gainesville FLORIDA 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.5004 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 desc limit 2000,100 in 1.6459 seconds