Listing all records

Displaying records 1101 through 1200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546987 Echo Osage Beach MISSOURI 8 Hour Days
538557 PT Orwigsburg PENNSYLVANIA Days
544562 OR Oregon City OREGON 10 Hour Day/Night Rotate
545091 Med Surg Oregon City OREGON 12 Hour Nights
546236 Dialysis Oregon OHIO 8 Hour Days
526359 Step Down Orangeburg SOUTH CAROLINA 12 Hour Varied
543709 Laboratory Orange CALIFORNIA 8 Hour Days
547320 First Assist Opelika ALABAMA 8 Hour Days
547039 Supervisor Oneonta NEW YORK 8 Hour Nights
542442 Med Surg Oneonta NEW YORK 12 Hour Days
542085 PT Oneonta NEW YORK 8 Hour Days
543186 Med Surg Oneonta NEW YORK 12 Hour Days
547973 Med Surg Oneonta NEW YORK 12 Hour Days
548205 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
548206 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
548301 ER Oneonta NEW YORK 12 Hour Days RN/Registered Nurse
548328 LPN/LVN Oneonta NEW YORK 12 Hour Days LPN/Licensed Practical Nurse
541809 Med Surg Oneonta NEW YORK 12 Hour Nights
541810 Med Surg Oneonta NEW YORK 12 Hour Nights
534169 Med Surg Oneonta NEW YORK 12 Hour Nights
545985 Long Term Care Oneonta NEW YORK 8 Hour Nights
544995 PCU Omaha NEBRASKA 12 Hour Nights
544996 CT Tech Omaha NEBRASKA 12 Hour Nights
545262 PCU Omaha NEBRASKA 12 Hour Nights
547656 Rehab Omaha NEBRASKA 12 Hour Days
547657 PCU Omaha NEBRASKA 12 Hour Nights
547658 PCU Omaha NEBRASKA 12 Hour Nights
547659 PCU Omaha NEBRASKA 12 Hour Days
547662 Surgical Tech Omaha NEBRASKA 8 Hour Days
543991 OR Omaha NEBRASKA 10 Hour Days
538194 CT Tech Omaha NEBRASKA 12 Hour Nights
538195 CT Tech Omaha NEBRASKA 12 Hour Days
546717 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546720 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546722 Med Surg Olympia WASHINGTON 12 Hour Nights
547436 CT Tech Olympia WASHINGTON 12 Hour Nights
547643 Med Surg Olympia WASHINGTON 12 Hour Nights
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 12 Hour Nights
546259 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546260 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546270 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546271 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546781 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
547702 RAD Tech Oklahoma City OKLAHOMA 12 Hour Nights
520665 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521322 ICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521323 Step Down Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521324 CVICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521325 Oncology Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521326 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521327 Step Down Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521337 Med Surg Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521340 Med Surg Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521341 Oncology Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521981 Step Down Oklahoma City OKLAHOMA 12 Hour Days
521994 Step Down Oklahoma City OKLAHOMA 12 Hour Days
540725 Step Down Oklahoma City OKLAHOMA 12 Hour Nights
543955 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543957 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543958 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543959 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
546410 ICU Ogdensburg NEW YORK 12 Hour Nights
546411 ICU Ogdensburg NEW YORK 12 Hour Nights
546833 Med Surg Ogdensburg NEW YORK 12 Hour Nights
531138 ICU Ogdensburg NEW YORK 12 Hour Nights
535266 Med Surg Ogdensburg NEW YORK 12 Hour Nights
537141 ICU Ogdensburg NEW YORK 12 Hour Nights
537792 L&D Ogdensburg NEW YORK 12 Hour Nights
543428 ICU Ogdensburg NEW YORK 12 Hour Nights
538261 ICU Ogdensburg NEW YORK 12 Hour Nights
532338 PT Ogden UTAH Days
548094 ER ODESSA TEXAS 12 Hour Nights RN/Registered Nurse
544768 OR ODESSA TEXAS 12 Hour Days
546317 CT Tech ODESSA TEXAS 12 Hour Days
547409 Postpartum ODESSA TEXAS 12 Hour Days
546692 Med Surg Oceanside CALIFORNIA 12 Hour Days
546693 Telemetry Oceanside CALIFORNIA 12 Hour Evenings
546694 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
546695 ER Oceanside CALIFORNIA 12 Hour Nights
547664 ICU Oceanside CALIFORNIA 12 Hour Nights
547665 Oncology Oceanside CALIFORNIA 12 Hour Nights
547932 Telemetry - Per Diem Oceanside CALIFORNIA 12 Hour Nights
548274 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
548359 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
540423 Case Manager Oceanside CALIFORNIA 8 Hour Days
540425 CT Tech Oceanside CALIFORNIA 8 Hour Evenings
542846 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
543005 CT Tech Oceanside CALIFORNIA 10 Hour Days
543006 CVOR Oceanside CALIFORNIA 8 Hour Days
543790 RAD Tech Oceanside CALIFORNIA 8 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
544012 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
517294 Surgical Tech Oceanside CALIFORNIA 10 Hour Days
517474 Ortho Tech Oceanside CALIFORNIA 8 Hour Days
520291 CT Tech Oceanside CALIFORNIA 10 Hour Days
541765 CVOR Oceanside CALIFORNIA 8 Hour Nights
524582 ICU - Per Diem Oceanside CALIFORNIA 12 Hour Days RN/Registered Nurse
524588 ICU - Per Diem Oceanside CALIFORNIA 12 Hour Days RN/Registered Nurse
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.7166 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 z.city desc limit 1100,100 in 1.7056 seconds