Listing all records

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

ID Job Specialty City State Shift Title
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
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
546674 Interventional Radiology Des Moines IOWA 8 Hour Days
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
546681 PACU Hot Springs ARKANSAS 8 Hour Days
546281 Home Health Hayward CALIFORNIA 8 Hour Days
546056 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
546057 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
546800 ER Walnut Creek CALIFORNIA 12 Hour Nights
546063 Med Surg Roosevelt UTAH Nights
546067 ICU Norton VIRGINIA 12 Hour Nights
546340 Certified Surgical Tech Torrance CALIFORNIA 10 Hour Days
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
546077 ER Paulding OHIO 12 Hour Nights
546081 Case Manager Santa Monica CALIFORNIA 8 Hour Days
546084 Med Surg Tele Spokane WASHINGTON 12 Hour Days
546684 L&D Detroit MICHIGAN 12 Hour Days
546103 OR Springfield MASSACHUSETTS 8 Hour Days
546104 ER Stafford Springs CONNECTICUT 12 Hour Nights
546105 ER Stafford Springs CONNECTICUT 12 Hour Nights
546110 PTA Clovis NEW MEXICO 8 Hour Days
546127 Med Surg Oxford NORTH CAROLINA 12 Hour Days
546128 Certified Surgical Tech Florence SOUTH CAROLINA 12 Hour Days
546129 Med Surg Portland OREGON 12 Hour Days
546140 Med Surg Tele Des Moines IOWA 12 Hour Nights
546141 Med Surg Des Moines IOWA 12 Hour Days
546142 Cardiology Muskegon MICHIGAN 12 Hour Days
546143 Surgical Tech CVOR Muskegon MICHIGAN 8 Hour Days
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
546168 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
546169 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546170 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546172 Med Surg Tele Gallipolis OHIO 12 Hour Nights
546177 Medical Assistant West Branch MICHIGAN 8 Hour Days
546181 SLP Cooperstown NEW YORK 8 Hour Days
546186 Med Surg Tele Cleveland OHIO 12 Hour Nights
546187 CT Tech Emmett IDAHO 8 Hour Days
546190 Interventional Radiology Auburn NEW YORK 8 Hour Days
546191 PT Crescent City CALIFORNIA Varied
546285 Rehab Windsor VERMONT 12 Hour Nights
546196 Med Surg Bristol TENNESSEE 12 Hour Nights
546198 Med Surg Bristol TENNESSEE 12 Hour Days
546201 Registered Nurse Bristol TENNESSEE 12 Hour Nights
546205 Long Term Care Watertown NEW YORK 12 Hour Day/Night Rotate
546212 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
546213 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
546216 PCU Sun City ARIZONA 12 Hour Nights
546217 PCU Sun City ARIZONA 12 Hour Nights
546220 PT Crescent City CALIFORNIA 8 Hour Days
546221 PTA Crescent City CALIFORNIA 8 Hour Day/Night Rotate
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
546230 RAD Tech Cincinnati OHIO 12 Hour Day/Night Rotate
546233 Long Term Care Watertown NEW YORK 8 Hour Evenings
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.507 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.title asc limit 2400,100 in 1.4753 seconds