Listing all records

Displaying records 2001 through 2100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545154 RAD Tech Lebanon NEW HAMPSHIRE 12 Hour Nights
545165 Telemetry Cleveland OHIO 12 Hour Nights
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
545939 Intermediate Care Gainesville FLORIDA 12 Hour Nights
546223 ICU Ann Arbor MICHIGAN 12 Hour Nights
548166 Med Surg Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
547998 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
545192 Acute Care Bronx NEW YORK 12 Hour Nights
545968 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545205 Med Surg Des Moines IOWA 12 Hour Nights
545206 Orthopedics Des Moines IOWA 12 Hour Nights
545207 ER Des Moines IOWA 12 Hour Nights
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
545227 Telemetry Cleveland OHIO 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
545229 Telemetry Cleveland OHIO 12 Hour Nights
545230 Telemetry Cleveland OHIO 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
545232 Step Down Cleveland OHIO 12 Hour Nights
545233 Step Down Cleveland OHIO 12 Hour Nights
545238 ER Des Moines IOWA 12 Hour Nights
545240 ER Grove City OHIO 12 Hour Nights
545262 PCU Omaha NEBRASKA 12 Hour Nights
546228 Pediatrics Concord NEW HAMPSHIRE 12 Hour Nights
546225 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
548123 PCU Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548024 Telemetry Cleveland OHIO 12 Hour Nights
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
545291 PCU Rock Hill SOUTH CAROLINA 12 Hour Nights
545292 CVICU Memphis TENNESSEE 12 Hour Nights
545299 CVICU Little Rock ARKANSAS 12 Hour Nights
545300 Med Surg Helena MONTANA 12 Hour Nights
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 12 Hour Nights
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
545311 ICU Colville WASHINGTON 12 Hour Nights
548040 PCU Lowell MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
547999 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
545328 CNA Salem OREGON 12 Hour Nights
545338 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
545610 Med Surg HOBBS NEW MEXICO 12 Hour Nights
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
545975 ICU Gainesville FLORIDA 12 Hour Nights
548065 Step Down SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
545973 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
548064 Respiratory Therapist Falls Church VIRGINIA 12 Hour Nights Respiratory Therapist
545970 Med Surg Gainesville FLORIDA 12 Hour Nights
545421 RN Columbus OHIO 12 Hour Nights
548084 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548087 PCU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
545427 NICU Mishawaka INDIANA 12 Hour Nights
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
545453 ER Lynwood CALIFORNIA 12 Hour Nights
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
545963 Med Surg Gainesville FLORIDA 12 Hour Nights
547904 ICU Mesa ARIZONA 12 Hour Nights
546245 Neuro Intensive Care Seattle WASHINGTON 12 Hour Nights
547981 Med Surg Tele Lewiston MAINE 12 Hour Nights
548099 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548096 Med Surg Espanola NEW MEXICO 12 Hour Nights RN/Registered Nurse
548101 PCU Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548100 PCU Pittsfield MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
545502 Telemetry Boise IDAHO 12 Hour Nights
545503 Telemetry Boise IDAHO 12 Hour Nights
545514 L&D Arcata CALIFORNIA 12 Hour Nights
545515 L&D Arcata CALIFORNIA 12 Hour Nights
548112 ER Rome NEW YORK 12 Hour Nights RN/Registered Nurse
548004 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
545897 Med Surg Gainesville FLORIDA 12 Hour Nights
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
546571 MICU Brooklyn NEW YORK 12 Hour Nights
545619 Med Surg Gainesville FLORIDA 12 Hour Nights
545620 Med Surg Gainesville FLORIDA 12 Hour Nights
545621 ER Massena NEW YORK 12 Hour Nights
546476 Med Surg Gainesville FLORIDA 12 Hour Nights
545625 Telemetry Prescott Valley ARIZONA 12 Hour Nights
545627 Cardiology Gainesville FLORIDA 12 Hour Nights
546597 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
545629 ICU Gainesville FLORIDA 12 Hour Nights
545983 Med Surg Gainesville FLORIDA 12 Hour Nights
545631 ICU Gainesville FLORIDA 12 Hour Nights
545633 Med Surg Gainesville FLORIDA 12 Hour Nights
546599 ER Saratoga Springs NEW YORK 12 Hour Nights
545635 Med Surg Gainesville FLORIDA 12 Hour Nights
545636 ICU Gainesville FLORIDA 12 Hour Nights
545637 ICU Gainesville FLORIDA 12 Hour Nights
546621 ER Saratoga Springs NEW YORK 12 Hour Nights
545639 ICU Gainesville FLORIDA 12 Hour Nights
545641 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545642 Med Surg Gainesville FLORIDA 12 Hour Nights
545643 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545644 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545645 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545648 RAD Tech Gainesville FLORIDA 12 Hour Nights
545649 RAD Tech Gainesville FLORIDA 12 Hour Nights
545652 Med Surg Gainesville FLORIDA 12 Hour Nights
545653 Med Surg Gainesville FLORIDA 12 Hour Nights
545654 Med Surg Gainesville FLORIDA 12 Hour Nights
545655 Med Surg Gainesville FLORIDA 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.5737 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 desc limit 2000,100 in 1.35 seconds