Listing all records

Displaying records 2101 through 2200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545636 ICU Gainesville FLORIDA 12 Hour Nights
545637 ICU Gainesville FLORIDA 12 Hour Nights
546768 Med Surg IOWA CITY IOWA 12 Hour Nights
545639 ICU Gainesville FLORIDA 12 Hour Nights
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
546784 Pediatrics Gardner MASSACHUSETTS 12 Hour Nights
546782 CT Tech Salinas CALIFORNIA 12 Hour Nights CT/Computerized Tomography
545648 RAD Tech Gainesville FLORIDA 12 Hour Nights
545649 RAD Tech Gainesville FLORIDA 12 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
546795 MLT Estes Park COLORADO 12 Hour Nights
546802 NICU Walnut Creek CALIFORNIA 12 Hour Nights
546812 Med Surg Harrison ARKANSAS 12 Hour Nights
545662 MLT Gainesville FLORIDA 12 Hour Nights
545663 MLT Gainesville FLORIDA 12 Hour Nights
545760 ICU Gainesville FLORIDA 12 Hour Nights
546819 Med Surg Tele Canton OHIO 12 Hour Nights
546813 Clinic Cleveland OHIO 12 Hour Nights
545759 ICU Gainesville FLORIDA 12 Hour Nights
545671 Cardiology Gainesville FLORIDA 12 Hour Nights
546845 Med Surg Peoria ILLINOIS 12 Hour Nights
545673 Med Surg Gainesville FLORIDA 12 Hour Nights
545674 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545675 ICU Gainesville FLORIDA 12 Hour Nights
545676 Med Surg Gainesville FLORIDA 12 Hour Nights
545677 Med Surg Gainesville FLORIDA 12 Hour Nights
546859 Telemetry Everett WASHINGTON 12 Hour Nights
545679 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545681 Med Surg Gainesville FLORIDA 12 Hour Nights
546366 ER Waterloo IOWA 12 Hour Nights
545683 Med Surg Gainesville FLORIDA 12 Hour Nights
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
545686 Med Surg Gainesville FLORIDA 12 Hour Nights
545687 ICU Gainesville FLORIDA 12 Hour Nights
546378 Med Surg Tele Gallipolis OHIO 12 Hour Nights
545689 ICU Gainesville FLORIDA 12 Hour Nights
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
545692 PICU Gainesville FLORIDA 12 Hour Nights
545693 ICU Gainesville FLORIDA 12 Hour Nights
545694 Intermediate Care Gainesville FLORIDA 12 Hour Nights
546943 Med Surg Tele Cleveland OHIO 12 Hour Nights
545758 Med Surg Gainesville FLORIDA 12 Hour Nights
546904 Telemetry Cleveland OHIO 12 Hour Nights
546903 Med Surg Tele Canton OHIO 12 Hour Nights
545699 Med Surg Gainesville FLORIDA 12 Hour Nights
545701 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
546908 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
545703 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545705 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545706 Med Surg Gainesville FLORIDA 12 Hour Nights
546923 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
546918 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
545709 ICU Gainesville FLORIDA 12 Hour Nights
546925 ER East Norriton PENNSYLVANIA 12 Hour Nights
545711 ICU Gainesville FLORIDA 12 Hour Nights
545712 Med Surg Gainesville FLORIDA 12 Hour Nights
546915 Med Surg Hilo HAWAII 12 Hour Nights
545714 ICU Gainesville FLORIDA 12 Hour Nights
546938 ER Albany NEW YORK 12 Hour Nights
545716 ICU Gainesville FLORIDA 12 Hour Nights
545717 Intermediate Care Gainesville FLORIDA 12 Hour Nights
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
546937 ER Albany NEW YORK 12 Hour Nights
545720 ICU Gainesville FLORIDA 12 Hour Nights
546934 RAD Tech Dubuque IOWA 12 Hour Nights
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
545723 Med Surg Gainesville FLORIDA 12 Hour Nights
545724 Med Surg Gainesville FLORIDA 12 Hour Nights
546939 ER Albany NEW YORK 12 Hour Nights
545726 Med Surg Gainesville FLORIDA 12 Hour Nights
545727 Med Surg Gainesville FLORIDA 12 Hour Nights
545728 Med Surg Gainesville FLORIDA 12 Hour Nights
545729 Med Surg Gainesville FLORIDA 12 Hour Nights
545730 ICU Gainesville FLORIDA 12 Hour Nights
545731 ICU Gainesville FLORIDA 12 Hour Nights
545732 ICU Gainesville FLORIDA 12 Hour Nights
545733 Med Surg Gainesville FLORIDA 12 Hour Nights
546971 Radiology PHOENIX ARIZONA 12 Hour Nights
546984 CVICU Albany NEW YORK 12 Hour Nights
545737 ICU Gainesville FLORIDA 12 Hour Nights
545738 ICU Gainesville FLORIDA 12 Hour Nights
545740 Med Surg Gainesville FLORIDA 12 Hour Nights
545742 Med Surg Gainesville FLORIDA 12 Hour Nights
546994 Med Surg Troy NEW YORK 12 Hour Nights
546382 Step Down Lansing MICHIGAN 12 Hour Nights
546977 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
547023 Med Surg Tele Rome NEW YORK 12 Hour Nights
547035 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547034 Med Surg Tele Auburn NEW YORK 12 Hour Nights
545750 Intermediate Care Gainesville FLORIDA 12 Hour Nights
547033 Med Surg Tele Auburn NEW YORK 12 Hour Nights
545752 Med Surg Gainesville FLORIDA 12 Hour Nights
547008 Oncology Everett 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 1.391 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.shift desc limit 2100,100 in 1.4015 seconds