Listing all records

Displaying records 701 through 800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
539176 ICU Albany NEW YORK 12 Hour Days
539177 Cardiology Albany NEW YORK 12 Hour Nights
539178 Med Surg Troy NEW YORK 12 Hour Nights
539200 Med Surg Dubuque IOWA 12 Hour Days
539277 Med Surg Tele Cleveland OHIO 12 Hour Nights
539278 Med Surg Tele Cleveland OHIO 12 Hour Nights
539293 Supervisor Brooklyn NEW YORK 8 Hour Days
539294 Radiology Queens NEW YORK 8 Hour Days
539306 PT Sunnyvale CALIFORNIA Days
539310 Speech Language Roseburg OREGON Days
539320 Oncology York PENNSYLVANIA 12 Hour Day/Night Rotate
539378 RAD Tech Louisville KENTUCKY 12 Hour Nights
539384 Scrub Tech Newark NEW JERSEY 12 Hour Days
539391 OR Bristol TENNESSEE 12 Hour Varied
539450 Med Surg New York NEW YORK 8 Hour Evenings
539455 PT Athens GEORGIA 8 Hour Days
540106 ER Concord CALIFORNIA 12 Hour Nights
539559 Laboratory New York NEW YORK 8 Hour Evenings
539616 PCU Johnson City TENNESSEE 12 Hour Nights
539617 Pulmonary Johnson City TENNESSEE 12 Hour Nights
539618 PCU Johnson City TENNESSEE 12 Hour Days
539620 PCU Johnson City TENNESSEE 12 Hour Nights
539652 Med Surg Abingdon VIRGINIA 12 Hour Days
539836 RAD Tech Seattle WASHINGTON 8 Hour Days
539656 Med Surg Abingdon VIRGINIA 12 Hour Nights
539658 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate
539660 Long Term Care Greeneville TENNESSEE 12 Hour Nights
539670 Med Surg Tele Des Moines IOWA 12 Hour Nights
539674 Med Surg Mesa ARIZONA 12 Hour Nights
539689 Med Surg Norton VIRGINIA 12 Hour Nights
539692 CNA Marion VIRGINIA 12 Hour Days
539693 CNA Marion VIRGINIA 12 Hour Nights
539703 Long Term Care Kingsport TENNESSEE 12 Hour Nights
539708 Sterile Processing Technician Grove City OHIO 8 Hour Evenings
539710 Echo Sioux City IOWA 8 Hour Days
539711 CT Tech Clinton IOWA 12 Hour Days
539712 Home Health Mason City IOWA 8 Hour Days
539713 Oncology Des Moines IOWA 12 Hour Nights
539714 Oncology Des Moines IOWA 12 Hour Nights
539715 Respiratory Therapist Mishawaka INDIANA 12 Hour Days
539718 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
539734 PTA Avoca IOWA Days
539742 Laboratory Falls Church VIRGINIA 8 Hour Evenings
539751 Telemetry Boise IDAHO 12 Hour Nights
539754 L&D Wailuku HAWAII 8 Hour Nights
539755 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539756 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539757 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539758 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539819 Med Surg Boise IDAHO 12 Hour Nights
539856 Med Surg Tele Cleveland OHIO 12 Hour Nights
539857 Med Surg Tele Cleveland OHIO 12 Hour Nights
541236 CT Tech Petoskey MICHIGAN 12 Hour Nights
539873 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
539875 Therapy Rehab Athens GEORGIA 8 Hour Days
540446 Case Manager Napa CALIFORNIA 8 Hour Days
539896 Ultrasound Tech York PENNSYLVANIA 12 Hour Day/Night Rotate
539898 Cardiovascular York PENNSYLVANIA Nights
539903 MLT Tuba City ARIZONA 12 Hour Day/Night Rotate
541107 Ultrasound Tech Sioux City IOWA 8 Hour Days
539926 Med Surg Schenectady NEW YORK 12 Hour Days
539930 Surgical Tech Louisville KENTUCKY 8 Hour Days
539939 CNA Philipsburg PENNSYLVANIA 8 Hour Evenings
540115 ER Walnut Creek CALIFORNIA 12 Hour Nights
539974 ER Philipsburg MONTANA 12 Hour Nights
539979 Case Manager Petoskey MICHIGAN 8 Hour Days
540000 ER Walnut Creek CALIFORNIA 12 Hour Nights
540165 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540002 MRI Tech Farmington CONNECTICUT 12 Hour Nights
540003 Telemetry Farmington CONNECTICUT 12 Hour Days
540004 PACU Walnut Creek CALIFORNIA 12 Hour Days
540005 OR Farmington CONNECTICUT 10 Hour Days
540006 PCU Walnut Creek CALIFORNIA 12 Hour Nights
540007 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540008 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540009 MLT Farmington CONNECTICUT 8 Hour Evenings
540010 OR Walnut Creek CALIFORNIA 12 Hour Days
540011 Telemetry Farmington CONNECTICUT 12 Hour Nights
540012 RAD Tech Farmington CONNECTICUT 10 Hour Evenings
540013 Monitor Tech Farmington CONNECTICUT 8 Hour Evenings
540014 Surgical Tech Farmington CONNECTICUT 10 Hour Days
540015 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540016 Monitor Tech Farmington CONNECTICUT 8 Hour Days
540017 RAD Tech Farmington CONNECTICUT 10 Hour Days
540018 Surgical Tech Farmington CONNECTICUT 8 Hour Days
540019 OR Farmington CONNECTICUT 12 Hour Days
540020 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540021 L&D Walnut Creek CALIFORNIA 12 Hour Days
540022 Interventional Radiology Farmington CONNECTICUT 10 Hour Days
540023 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540024 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540025 OR Concord CALIFORNIA 10 Hour Evenings
540026 OR Concord CALIFORNIA 8 Hour Days
540027 OR Concord CALIFORNIA 12 Hour Days
540028 OR Concord CALIFORNIA 10 Hour Days
540029 PCU Concord CALIFORNIA 8 Hour Days
540030 L&D Walnut Creek CALIFORNIA 12 Hour Days
540166 NICU Walnut Creek CALIFORNIA 12 Hour Days
540032 Surgical Tech CVOR Farmington CONNECTICUT 8 Hour Days
540033 Med Surg Tele Concord CALIFORNIA 8 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.6515 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 700,100 in 1.4917 seconds