Listing all records

Displaying records 1601 through 1700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545909 ICU Gainesville FLORIDA 12 Hour Nights
545910 ICU Gainesville FLORIDA 12 Hour Nights
545911 ICU Gainesville FLORIDA 12 Hour Nights
545912 ICU Gainesville FLORIDA 12 Hour Nights
545913 ICU Gainesville FLORIDA 12 Hour Nights
545914 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545918 Med Surg Gainesville FLORIDA 12 Hour Days
545919 Med Surg Gainesville FLORIDA 12 Hour Days
545920 Med Surg Gainesville FLORIDA 12 Hour Days
545921 Med Surg Gainesville FLORIDA 12 Hour Days
545922 Med Surg Gainesville FLORIDA 12 Hour Nights
545923 Med Surg Gainesville FLORIDA 12 Hour Nights
545924 Med Surg Gainesville FLORIDA 12 Hour Days
545925 Med Surg Gainesville FLORIDA 12 Hour Days
545926 Med Surg Gainesville FLORIDA 12 Hour Days
545927 Med Surg Gainesville FLORIDA 12 Hour Nights
545928 Med Surg Gainesville FLORIDA 12 Hour Days
545929 Med Surg Gainesville FLORIDA 12 Hour Days
545930 Med Surg Gainesville FLORIDA 12 Hour Days
545931 Med Surg Gainesville FLORIDA 12 Hour Nights
545932 Med Surg Gainesville FLORIDA 12 Hour Nights
545933 Med Surg Gainesville FLORIDA 12 Hour Days
545934 ICU Gainesville FLORIDA 12 Hour Nights
545935 Med Surg Gainesville FLORIDA 12 Hour Nights
545936 Med Surg Gainesville FLORIDA 12 Hour Nights
545937 Med Surg Gainesville FLORIDA 12 Hour Nights
545938 Med Surg Gainesville FLORIDA 12 Hour Days
545939 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545940 Med Surg Gainesville FLORIDA 12 Hour Days
545941 Med Surg Gainesville FLORIDA 12 Hour Days
545942 Med Surg Gainesville FLORIDA 12 Hour Nights
545945 Med Surg Gainesville FLORIDA 12 Hour Days
545946 Med Surg Gainesville FLORIDA 12 Hour Days
545961 Med Surg Gainesville FLORIDA 12 Hour Days
545962 ICU Gainesville FLORIDA 12 Hour Days
545963 Med Surg Gainesville FLORIDA 12 Hour Nights
545964 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
545965 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545966 Pediatrics Gainesville FLORIDA 12 Hour Nights
545967 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
545968 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545969 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545970 Med Surg Gainesville FLORIDA 12 Hour Nights
545971 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545972 Med Surg Gainesville FLORIDA 12 Hour Nights
545973 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545974 Med Surg Gainesville FLORIDA 12 Hour Days
545975 ICU Gainesville FLORIDA 12 Hour Nights
545976 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545977 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545978 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545981 Med Surg Gainesville FLORIDA 12 Hour Nights
545982 ICU Gainesville FLORIDA 12 Hour Nights
545983 Med Surg Gainesville FLORIDA 12 Hour Nights
545984 ICU Gainesville FLORIDA 12 Hour Nights
546172 Med Surg Tele Gallipolis OHIO 12 Hour Nights
546378 Med Surg Tele Gallipolis OHIO 12 Hour Nights
547332 SLP Garden City KANSAS Varied
547609 OT Garden City 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
545030 OR Gardner MASSACHUSETTS 10 Hour Days
546784 Pediatrics Gardner MASSACHUSETTS 12 Hour Nights
545136 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
542910 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
547723 Med Surg Georgetown SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
536728 Interventional Radiology Germantown MARYLAND 8 Hour Days
536758 OR Germantown MARYLAND 8 Hour Days
538172 MRI Tech Germantown MARYLAND 10 Hour Days
544201 OR Germantown MARYLAND 8 Hour Evenings
544482 OR Germantown MARYLAND 8 Hour Days
545125 RAD Tech Gig Harbor WASHINGTON 8 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
548002 ICU Gillette WYOMING 12 Hour Day/Night Rotate
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
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
544975 CT Tech Glendive MONTANA 8 Hour Varied
545338 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
542785 Case Manager Glens Falls NEW YORK 8 Hour Days
544067 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
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
544144 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544145 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
548020 MRI Tech Glenwood Springs COLORADO 12 Hour Varied
546886 PT Globe ARIZONA Days
546912 ER Goldendale WASHINGTON 12 Hour Days
547975 ER Goldendale WASHINGTON 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 2.1014 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 1600,100 in 1.6364 seconds