Listing all records

Displaying records 2501 through 2600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
546337 Medical Assistant Playa Vista CALIFORNIA 8 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
547626 Certified Surgical Tech Santa Monica CALIFORNIA 12 Hour Days
546276 Pediatrics Sitka ALASKA Varied
546277 RAD Tech Albany OREGON 12 Hour Day/Night Rotate
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
546599 ER Saratoga Springs NEW YORK 12 Hour Nights
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
546903 Med Surg Tele Canton OHIO 12 Hour Nights
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
546340 Certified Surgical Tech Torrance CALIFORNIA 10 Hour Days
547118 Interventional Radiology Tech CHANDLER ARIZONA 8 Hour Days
546902 Telemetry Cleveland OHIO 12 Hour Nights
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
546904 Telemetry Cleveland OHIO 12 Hour Nights
546353 RAD Tech Turlock CALIFORNIA 8 Hour Days
546354 Cardiology Fountain Valley CALIFORNIA 12 Hour Days
546355 CVOR Lakewood CALIFORNIA 8 Hour Days
546356 CVOR Lakewood CALIFORNIA 8 Hour Days
546357 CVOR Lakewood CALIFORNIA 8 Hour Days
546358 Cardiac ICU Rock Hill SOUTH CAROLINA 12 Hour Nights
546359 DOU El Paso TEXAS 12 Hour Nights
546360 Sonographer Forest Hills NEW YORK 8 Hour Days
546361 Laboratory Manhasset NEW YORK 8 Hour Days
546362 Laboratory Manhasset NEW YORK 8 Hour Days
546366 ER Waterloo IOWA 12 Hour Nights
546367 OR Maywood ILLINOIS 10 Hour Days
546688 L&D San Antonio TEXAS 12 Hour Nights
546378 Med Surg Tele Gallipolis OHIO 12 Hour Nights
546379 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546380 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
546381 Paramedic Lewisburg PENNSYLVANIA 12 Hour Day/Night Rotate
546382 Step Down Lansing MICHIGAN 12 Hour Nights
546389 RAD Tech Greenville SOUTH CAROLINA 8 Hour Days
546392 Sterile Processing Tech Muskegon MICHIGAN Nights
546393 OR Johnson City TENNESSEE Nights
546402 CT Tech Mount Airy NORTH CAROLINA 8 Hour Nights
546403 CT Tech Mount Airy NORTH CAROLINA 12 Hour Nights
546405 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
546410 ICU Ogdensburg NEW YORK 12 Hour Nights
547907 Med Surg New York NEW YORK Nights
546412 Med Surg Springfield VERMONT 12 Hour Days
546414 Home Health Hayward CALIFORNIA 8 Hour Days
546415 Oncology York PENNSYLVANIA Varied
546474 CVOR Corvallis OREGON 12 Hour Day/Night Rotate
546421 Sterile Processing Technician Westerville OHIO 8 Hour Days
546422 Surgical Tech Columbus OHIO Days
546431 Med Surg Gainesville FLORIDA 12 Hour Days
546432 Telemetry Farmington CONNECTICUT 12 Hour Days
546461 ER Des Moines IOWA 12 Hour Days
546440 Ophthalmic Tech Beverly Hills CALIFORNIA 8 Hour Days
546448 Nuclear Med Technician Santa Monica CALIFORNIA 12 Hour Days
546451 Therapy Rehab Macon GEORGIA 8 Hour Nights
546453 Step Down Elkin NORTH CAROLINA 12 Hour Days
546455 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
546462 ER Des Moines IOWA 12 Hour Days
546464 Med Surg Bristol TENNESSEE 12 Hour Nights
546466 Med Surg Greeneville TENNESSEE 12 Hour Nights
546469 OR Louisville KENTUCKY 8 Hour Days
546470 ICU East Norriton PENNSYLVANIA 12 Hour Days
546471 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Nights
546472 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Days
546473 Cath Lab Woonsocket RHODE ISLAND 10 Hour Days
546476 Med Surg Gainesville FLORIDA 12 Hour Nights
546489 OR Brooklyn NEW YORK 8 Hour Days
546552 Dialysis Brooklyn NEW YORK 10 Hour Nights
546554 Dialysis Brooklyn NEW YORK 12 Hour Days
546687 PCU San Luis Obispo CALIFORNIA 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.5804 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 2500,100 in 1.6365 seconds