Listing all records

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

ID Job Specialty City State Shift Title
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
546096 ICU Hilo HAWAII 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
546119 Nuclear Med Technician Whittier CALIFORNIA 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
546148 Med Surg Spokane WASHINGTON 8 Hour Evenings
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
546182 Med Surg Peoria ILLINOIS 12 Hour Nights
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
546192 ICU - Per Diem Irvine CALIFORNIA 12 Hour Nights RN/Registered Nurse
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
546234 PT Blountstown FLORIDA Days
546236 Dialysis Oregon OHIO 8 Hour Days
546245 Neuro Intensive Care Seattle WASHINGTON 12 Hour Nights
546246 Clinic Cleveland OHIO 8 Hour Days
546247 CT Tech Toledo OHIO 8 Hour Evenings
546251 CNA TOWNSHEND VERMONT 12 Hour Days
546255 PT Falls River MASSACHUSETTS 12 Hour Day/Night Rotate
546256 PACU Hilo HAWAII 12 Hour Day/Night Rotate
546259 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546260 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546264 ER Robbinsdale MINNESOTA 12 Hour Nights
546265 ER Cincinnati OHIO Nights
546270 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546271 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546276 Pediatrics Sitka ALASKA Varied
546277 RAD Tech Albany OREGON 12 Hour Day/Night Rotate
546281 Home Health Hayward CALIFORNIA 8 Hour Days
546282 PT Hayward CALIFORNIA 8 Hour Days
546283 PT Hayward CALIFORNIA 8 Hour Days
546285 Rehab Windsor VERMONT 12 Hour Nights
546286 PT Hayward CALIFORNIA 8 Hour Days
546287 PT Hamilton NEW JERSEY 8 Hour Days
546289 CT Tech Alexandria VIRGINIA 10 Hour Days
546294 Administration Marion INDIANA 12 Hour Nights
546301 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
546303 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546304 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546307 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546308 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546309 ER Santa Rosa NEW MEXICO 12 Hour Nights
546310 ER Santa Rosa NEW MEXICO 12 Hour Nights
546317 CT Tech ODESSA TEXAS 12 Hour Days
546321 PT Mission Hills CALIFORNIA 8 Hour Days
546326 Social Worker Ketchum IDAHO 8 Hour Days
546327 Social Worker Twin Falls IDAHO 8 Hour Days
546331 ER Centerville IOWA 12 Hour Days
546332 Sterile Processing Technician Fresno CALIFORNIA 8 Hour Days
546335 Psych Wailuku HAWAII 12 Hour Nights
546337 Medical Assistant Playa Vista CALIFORNIA 8 Hour Days
546340 Certified Surgical Tech Torrance CALIFORNIA 10 Hour Days
546342 Cath Lab Lexington KENTUCKY 10 Hour Days
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
546345 CT Tech Goodyear ARIZONA 10 Hour Days
546346 PT Nogales ARIZONA 8 Hour Days
546348 Cardiac ICU Detroit MICHIGAN 12 Hour Nights
546349 Interventional Radiology Detroit MICHIGAN 8 Hour Days
546352 CT Tech Manteca CALIFORNIA 8 Hour Days
546353 RAD Tech Turlock CALIFORNIA 8 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.5389 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 2400,100 in 1.444 seconds