Listing all records

Displaying records 2601 through 2700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547998 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
546172 Med Surg Tele Gallipolis OHIO 12 Hour Nights
546186 Med Surg Tele Cleveland OHIO 12 Hour Nights
546903 Med Surg Tele Canton OHIO 12 Hour Nights
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
548004 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
546216 PCU Sun City ARIZONA 12 Hour Nights
546217 PCU Sun City ARIZONA 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
548005 Med Surg Tele Des Moines IOWA 12 Hour Nights
546245 Neuro Intensive Care Seattle WASHINGTON 12 Hour Nights
546264 ER Robbinsdale MINNESOTA 12 Hour Nights
546270 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546271 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546788 Long Term Care Westminster COLORADO 12 Hour Nights
546285 Rehab Windsor VERMONT 12 Hour Nights
547611 PICU Santa Clara CALIFORNIA 12 Hour Nights
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
546309 ER Santa Rosa NEW MEXICO 12 Hour Nights
546310 ER Santa Rosa NEW MEXICO 12 Hour Nights
547613 PICU Santa Clara CALIFORNIA 12 Hour Nights
547612 PICU Santa Clara CALIFORNIA 12 Hour Nights
546348 Cardiac ICU Detroit MICHIGAN 12 Hour Nights
546358 Cardiac ICU Rock Hill SOUTH CAROLINA 12 Hour Nights
546359 DOU El Paso TEXAS 12 Hour Nights
546366 ER Waterloo IOWA 12 Hour Nights
546378 Med Surg Tele Gallipolis OHIO 12 Hour Nights
548021 PCU Abilene TEXAS 12 Hour Nights
548024 Telemetry Cleveland OHIO 12 Hour Nights
548023 LPN/LVN Mullins SOUTH CAROLINA 12 Hour Nights
546382 Step Down Lansing MICHIGAN 12 Hour Nights
547386 Med Surg Seattle WASHINGTON 12 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
546411 ICU Ogdensburg NEW YORK 12 Hour Nights
547008 Oncology Everett WASHINGTON 12 Hour Nights
546464 Med Surg Bristol TENNESSEE 12 Hour Nights
546466 Med Surg Greeneville TENNESSEE 12 Hour Nights
546471 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Nights
546476 Med Surg Gainesville FLORIDA 12 Hour Nights
546565 NICU Brooklyn NEW YORK 12 Hour Nights
546569 Med Surg Brooklyn NEW YORK 12 Hour Nights
546570 ICU Brooklyn NEW YORK 12 Hour Nights
546571 MICU Brooklyn NEW YORK 12 Hour Nights
546572 Med Surg Brooklyn NEW YORK 12 Hour Nights
546575 NICU Brooklyn NEW YORK 12 Hour Nights
546577 ICU Brooklyn NEW YORK 12 Hour Nights
546578 ER Brooklyn NEW YORK 12 Hour Nights
546593 ER Brooklyn NEW YORK 12 Hour Nights
546596 Med Surg Tele Rome NEW YORK 12 Hour Nights
546597 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
546598 ER Saratoga Springs NEW YORK 12 Hour Nights
546599 ER Saratoga Springs NEW YORK 12 Hour Nights
547640 Med Surg Seattle WASHINGTON 12 Hour Nights
546620 ER Saratoga Springs NEW YORK 12 Hour Nights
546621 ER Saratoga Springs NEW YORK 12 Hour Nights
547396 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
546635 ER Des Moines IOWA 12 Hour Nights
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548400 ER Albany NEW YORK 12 Hour Nights RN/Registered Nurse
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
547032 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547031 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547024 Med Surg Tele Rome NEW YORK 12 Hour Nights
547643 Med Surg Olympia WASHINGTON 12 Hour Nights
546683 PCU Birmingham ALABAMA 12 Hour Nights
546686 PCU San Luis Obispo CALIFORNIA 12 Hour Nights
546688 L&D San Antonio TEXAS 12 Hour Nights
547654 PCU Kearney NEBRASKA 12 Hour Nights
546695 ER Oceanside CALIFORNIA 12 Hour Nights
546698 ICU East Norriton PENNSYLVANIA 12 Hour Nights
547088 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
546705 Med Surg Albany NEW YORK 12 Hour Nights
546706 Med Surg Albany NEW YORK 12 Hour Nights
546707 Med Surg Albany NEW YORK 12 Hour Nights
546708 ICU Albany NEW YORK 12 Hour Nights
546709 ER Albany NEW YORK 12 Hour Nights
546710 ER Albany NEW YORK 12 Hour Nights
546717 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546718 PCU Centralia WASHINGTON 12 Hour Nights
546720 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546722 Med Surg Olympia WASHINGTON 12 Hour Nights
546724 Oncology Everett WASHINGTON 12 Hour Nights
546725 Telemetry Everett WASHINGTON 12 Hour Nights
546727 Telemetry Everett WASHINGTON 12 Hour Nights
546728 Intermediate Care Everett WASHINGTON 12 Hour Nights
546729 Telemetry Everett WASHINGTON 12 Hour Nights
546730 Telemetry Everett WASHINGTON 12 Hour Nights
546731 Telemetry Everett WASHINGTON 12 Hour Nights
546732 Telemetry Everett WASHINGTON 12 Hour Nights
546733 Telemetry 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 2.0138 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 2600,100 in 1.4914 seconds