Listing all records

Displaying records 2301 through 2400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545906 Med Surg Gainesville FLORIDA 12 Hour Days
545907 Med Surg Gainesville FLORIDA 12 Hour Days
545908 Med Surg Gainesville FLORIDA 12 Hour Days
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
545915 RAD Tech Richland WASHINGTON 12 Hour Day/Night Rotate
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
545943 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
545944 ICU Issaquah WASHINGTON 12 Hour Days
545945 Med Surg Gainesville FLORIDA 12 Hour Days
545946 Med Surg Gainesville FLORIDA 12 Hour Days
545950 PT Sunnyvale CALIFORNIA Days
545951 PT Sunnyvale CALIFORNIA Days
545954 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
545955 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
545960 Cath Lab Berwyn ILLINOIS 8 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
545979 CT Tech Santa Barbara CALIFORNIA 12 Hour Day/Night Rotate
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
545985 Long Term Care Oneonta NEW YORK 8 Hour Nights
545988 Long Term Care King City CALIFORNIA 12 Hour Days
545989 Long Term Care King City CALIFORNIA 12 Hour Nights
545990 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
545991 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
545992 Pediatrics King City CALIFORNIA 12 Hour Nights
545997 LPN/LVN King City CALIFORNIA 12 Hour Days
546005 PCU Mesa ARIZONA 12 Hour Days
546010 Med Surg Prince Frederick MARYLAND 12 Hour Nights
546011 Surgical Tech CVOR Hays KANSAS 10 Hour Days
546012 PCU Hays KANSAS 12 Hour Nights
546014 PT Bolivar MISSOURI 8 Hour Days
546020 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546021 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546032 PT San Jose CALIFORNIA 10 Hour Days
546035 PT Burbank CALIFORNIA 8 Hour Days
546036 PT Burbank CALIFORNIA 8 Hour Days
546037 Pediatrics Hilo HAWAII 12 Hour Varied
546039 Pediatrics Hilo HAWAII 12 Hour Nights
546041 Med Surg Hilo HAWAII 12 Hour Nights
546045 EEG Tech Syracuse NEW YORK 8 Hour Days
546047 MLT Columbus OHIO Nights
546049 RAD Tech Bismarck NORTH DAKOTA 8 Hour Nights
546050 Pediatrics Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
546053 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
546054 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
546056 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
546057 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
546061 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
546063 Med Surg Roosevelt UTAH Nights
546067 ICU Norton VIRGINIA 12 Hour Nights
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
546072 Surgical Tech Commerce Twp MICHIGAN 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.6184 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 a.id asc limit 2300,100 in 1.0045 seconds