Listing all records

Displaying records 2401 through 2500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545842 ICU Gainesville FLORIDA 12 Hour Nights
545845 Med Surg Gainesville FLORIDA 12 Hour Nights
545846 Med Surg Gainesville FLORIDA 12 Hour Nights
545847 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545848 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545849 Med Surg Gainesville FLORIDA 12 Hour Nights
545851 ICU Gainesville FLORIDA 12 Hour Nights
545857 Med Surg Gainesville FLORIDA 12 Hour Nights
545860 Med Surg Gainesville FLORIDA 12 Hour Nights
545861 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545862 Med Surg Gainesville FLORIDA 12 Hour Nights
545864 ICU Gainesville FLORIDA 12 Hour Nights
545867 Cardiology Gainesville FLORIDA 12 Hour Nights
545869 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545871 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545877 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545879 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545881 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545883 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545885 Med Surg Gainesville FLORIDA 12 Hour Nights
545891 Med Surg Gainesville FLORIDA 12 Hour Nights
545892 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545894 ICU Gainesville FLORIDA 12 Hour Nights
545895 ICU Gainesville FLORIDA 12 Hour Nights
545897 Med Surg Gainesville FLORIDA 12 Hour Nights
545900 MLT Gainesville FLORIDA 12 Hour Nights
545903 Med Surg Gainesville FLORIDA 12 Hour Nights
545904 Med Surg Gainesville FLORIDA 12 Hour Nights
545905 Med Surg Gainesville FLORIDA 12 Hour Nights
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
547614 PICU Santa Clara CALIFORNIA 12 Hour Nights
545922 Med Surg Gainesville FLORIDA 12 Hour Nights
545923 Med Surg Gainesville FLORIDA 12 Hour Nights
545927 Med Surg Gainesville FLORIDA 12 Hour Nights
545931 Med Surg Gainesville FLORIDA 12 Hour Nights
545932 Med Surg Gainesville FLORIDA 12 Hour Nights
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
545939 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545942 Med Surg Gainesville FLORIDA 12 Hour Nights
546565 NICU Brooklyn NEW YORK 12 Hour Nights
547482 CT Tech Rockingham NORTH CAROLINA 12 Hour Nights
545963 Med Surg Gainesville FLORIDA 12 Hour Nights
545966 Pediatrics Gainesville FLORIDA 12 Hour Nights
545968 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545970 Med Surg Gainesville FLORIDA 12 Hour Nights
545972 Med Surg Gainesville FLORIDA 12 Hour Nights
545973 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545975 ICU Gainesville FLORIDA 12 Hour Nights
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
545989 Long Term Care King City CALIFORNIA 12 Hour Nights
547633 CT Tech Titusville FLORIDA 12 Hour Nights
545992 Pediatrics King City CALIFORNIA 12 Hour Nights
546010 Med Surg Prince Frederick MARYLAND 12 Hour Nights
547127 Med Surg Coos Bay OREGON 12 Hour Nights
546012 PCU Hays KANSAS 12 Hour Nights
546020 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546021 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546874 Med Surg Tele Greensboro NORTH CAROLINA 12 Hour Nights
546039 Pediatrics Hilo HAWAII 12 Hour Nights
546041 Med Surg Hilo HAWAII 12 Hour Nights
547634 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
546056 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
546800 ER Walnut Creek CALIFORNIA 12 Hour Nights
546067 ICU Norton VIRGINIA 12 Hour Nights
546077 ER Paulding OHIO 12 Hour Nights
546104 ER Stafford Springs CONNECTICUT 12 Hour Nights
546105 ER Stafford Springs CONNECTICUT 12 Hour Nights
546140 Med Surg Tele Des Moines IOWA 12 Hour Nights
546144 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546145 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546146 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546147 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546163 L&D Seattle WASHINGTON 12 Hour Nights
546165 ER Portland OREGON 12 Hour Nights
546167 Med Surg Tele Dothan ALABAMA 12 Hour Nights
547654 PCU Kearney NEBRASKA 12 Hour Nights
546172 Med Surg Tele Gallipolis OHIO 12 Hour Nights
546186 Med Surg Tele Cleveland OHIO 12 Hour Nights
546301 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
546192 ICU - Per Diem Irvine CALIFORNIA 12 Hour Nights RN/Registered Nurse
546196 Med Surg Bristol TENNESSEE 12 Hour Nights
546201 Registered Nurse Bristol TENNESSEE 12 Hour Nights
546216 PCU Sun City ARIZONA 12 Hour Nights
546217 PCU Sun City ARIZONA 12 Hour Nights
547497 Pediatrics Hilo HAWAII 12 Hour Nights
546223 ICU Ann Arbor MICHIGAN 12 Hour Nights
546224 CCU Ann Arbor MICHIGAN 12 Hour Nights
546225 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
546228 Pediatrics Concord NEW HAMPSHIRE 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.7171 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 asc limit 2400,100 in 1.8033 seconds