Listing all records

Displaying records 1601 through 1700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543465 Telemetry Wailuku HAWAII 12 Hour Nights
543466 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544552 ER Newark NEW JERSEY 12 Hour Nights
543475 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
543483 Med Surg Chillicothe OHIO 12 Hour Nights
543494 Med Surg Nashua NEW HAMPSHIRE 12 Hour Nights
547059 ER Rome NEW YORK 12 Hour Nights
543535 Med Surg Spokane WASHINGTON 12 Hour Nights
543598 Rehab Twin Falls IDAHO 12 Hour Nights
543599 Telemetry Twin Falls IDAHO 12 Hour Nights
543607 Telemetry Nampa IDAHO 12 Hour Nights
543613 Telemetry Boise IDAHO 12 Hour Nights
545652 Med Surg Gainesville FLORIDA 12 Hour Nights
546403 CT Tech Mount Airy NORTH CAROLINA 12 Hour Nights
546309 ER Santa Rosa NEW MEXICO 12 Hour Nights
543644 ER Walnut Creek CALIFORNIA 12 Hour Nights
543645 ER Walnut Creek CALIFORNIA 12 Hour Nights
543646 ER Walnut Creek CALIFORNIA 12 Hour Nights
543647 ER Walnut Creek CALIFORNIA 12 Hour Nights
543648 ER Walnut Creek CALIFORNIA 12 Hour Nights
543649 ER Walnut Creek CALIFORNIA 12 Hour Nights
543650 ER Walnut Creek CALIFORNIA 12 Hour Nights
543651 ER Walnut Creek CALIFORNIA 12 Hour Nights
546304 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
543669 ICU Bristol TENNESSEE 12 Hour Nights
545654 Med Surg Gainesville FLORIDA 12 Hour Nights
545096 ER Burbank CALIFORNIA 12 Hour Nights
543730 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights
543740 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Nights
543747 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
543755 NICU Lynwood CALIFORNIA 12 Hour Nights
546348 Cardiac ICU Detroit MICHIGAN 12 Hour Nights
543759 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543760 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
546359 DOU El Paso TEXAS 12 Hour Nights
546378 Med Surg Tele Gallipolis OHIO 12 Hour Nights
545655 Med Surg Gainesville FLORIDA 12 Hour Nights
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
545136 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
546382 Step Down Lansing MICHIGAN 12 Hour Nights
546577 ICU Brooklyn NEW YORK 12 Hour Nights
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
546405 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
543807 PACU Albuquerque NEW MEXICO 12 Hour Nights
545133 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
546411 ICU Ogdensburg NEW YORK 12 Hour Nights
546575 NICU Brooklyn NEW YORK 12 Hour Nights
543824 ER Lansing MICHIGAN 12 Hour Nights
545192 Acute Care Bronx NEW YORK 12 Hour Nights
545206 Orthopedics Des Moines IOWA 12 Hour Nights
545205 Med Surg Des Moines IOWA 12 Hour Nights
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
546597 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
543886 RAD Tech National City CALIFORNIA 12 Hour Nights
543887 CT Tech National City CALIFORNIA 12 Hour Nights
546466 Med Surg Greeneville TENNESSEE 12 Hour Nights
547088 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
543890 Psych National City CALIFORNIA 12 Hour Nights
546476 Med Surg Gainesville FLORIDA 12 Hour Nights
546578 ER Brooklyn NEW YORK 12 Hour Nights
545128 Med Surg Albuquerque NEW MEXICO 12 Hour Nights
546570 ICU Brooklyn NEW YORK 12 Hour Nights
545207 ER Des Moines IOWA 12 Hour Nights
544996 CT Tech Omaha NEBRASKA 12 Hour Nights
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
544995 PCU Omaha NEBRASKA 12 Hour Nights
543974 ER Newark NEW JERSEY 12 Hour Nights
544031 Telemetry Portland OREGON 12 Hour Nights
544034 PCU Spokane WASHINGTON 12 Hour Nights
544036 Step Down Lansing MICHIGAN 12 Hour Nights
544037 Step Down Lansing MICHIGAN 12 Hour Nights
546599 ER Saratoga Springs NEW YORK 12 Hour Nights
544049 Med Surg Palm Springs CALIFORNIA 12 Hour Nights
544050 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544051 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544052 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544060 ICU Pontiac MICHIGAN 12 Hour Nights
544067 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
544530 Med Surg Waterloo IOWA 12 Hour Nights
544091 Med Surg Norman OKLAHOMA 12 Hour Nights
544116 Telemetry Cleveland OHIO 12 Hour Nights
544149 Long Term Care Moscow IDAHO 12 Hour Nights
544153 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
544158 PACU Cleveland OHIO 12 Hour Nights
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
544208 Med Surg Grove City OHIO 12 Hour Nights
544209 Med Surg Grove City OHIO 12 Hour Nights
547027 Long Term Care Claremont NEW HAMPSHIRE 12 Hour Nights
544215 Med Surg Tele Pueblo COLORADO 12 Hour Nights
544217 Med Surg Pella IOWA 12 Hour Nights
548400 ER Albany NEW YORK 12 Hour Nights RN/Registered Nurse
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
546271 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
544222 ICU Passaic NEW JERSEY 12 Hour Nights
544225 Med Surg Dover NEW JERSEY 12 Hour Nights
544230 ER Denville NEW JERSEY 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.5177 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 1600,100 in 1.4481 seconds