Listing all records

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

ID Job Specialty City State Shift Title
537715 OR Farmington CONNECTICUT 10 Hour Days
537716 OR Farmington CONNECTICUT 10 Hour Days
537758 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
537759 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
540002 MRI Tech Farmington CONNECTICUT 12 Hour Nights
540003 Telemetry Farmington CONNECTICUT 12 Hour Days
540005 OR Farmington CONNECTICUT 10 Hour Days
540009 MLT Farmington CONNECTICUT 8 Hour Evenings
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
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
540022 Interventional Radiology Farmington CONNECTICUT 10 Hour Days
540024 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540032 Surgical Tech CVOR Farmington CONNECTICUT 8 Hour Days
540040 Telemetry Farmington CONNECTICUT 12 Hour Days
540041 Ultrasound Tech Farmington CONNECTICUT 12 Hour Days
540043 CMA Farmington CONNECTICUT 8 Hour Days
540045 OR Farmington CONNECTICUT 10 Hour Days
540055 ICU Farmington CONNECTICUT 12 Hour Nights
540060 CT Tech Farmington CONNECTICUT 10 Hour Days
540061 OR Farmington CONNECTICUT 10 Hour Days
540062 OR Farmington CONNECTICUT 10 Hour Days
540063 Telemetry Farmington CONNECTICUT 12 Hour Nights
540065 Telemetry Farmington CONNECTICUT 12 Hour Days
540083 RAD Tech Farmington CONNECTICUT 8 Hour Days
540569 Telemetry Farmington CONNECTICUT 12 Hour Nights
540867 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
540878 Case Manager Farmington CONNECTICUT 8 Hour Evenings
540879 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
540883 ER Hartford CONNECTICUT 12 Hour Nights
540890 Surgical Tech CVOR Farmington CONNECTICUT 10 Hour Days
540891 MLT Farmington CONNECTICUT 8 Hour Days
540892 MLT Farmington CONNECTICUT 8 Hour Days
540976 Phlebotomist Farmington CONNECTICUT 8 Hour Days
541038 Phlebotomist Farmington CONNECTICUT 8 Hour Days
541117 Telemetry Farmington CONNECTICUT 12 Hour Nights
542084 RAD Tech Farmington CONNECTICUT 8 Hour Days
542595 CMA Farmington CONNECTICUT 8 Hour Days
544103 Phlebotomist Farmington CONNECTICUT 8 Hour Days
543193 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
543309 Telemetry Farmington CONNECTICUT 12 Hour Nights
543337 OR Farmington CONNECTICUT 10 Hour Days
543338 OR Farmington CONNECTICUT 10 Hour Days
543355 Phlebotomist Farmington CONNECTICUT 8 Hour Days
543630 Surgical Tech Stafford Springs CONNECTICUT 8 Hour Days
540523 L&D Lamar COLORADO 12 Hour Nights
541105 PT Estes Park COLORADO 12 Hour Day/Night Rotate
543977 Sterile Processing Tech Lamar COLORADO Days
543978 Scrub Tech Lamar COLORADO 8 Hour Day/Night Rotate
548020 MRI Tech Glenwood Springs COLORADO 12 Hour Varied
548035 Echo Pagosa Springs COLORADO 8 Hour Days
548095 ER Sterling COLORADO 12 Hour Nights RN/Registered Nurse
544144 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544145 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544215 Med Surg Tele Pueblo COLORADO 12 Hour Nights
544652 Med Surg Alamosa COLORADO 12 Hour Nights
544886 OR Aspen COLORADO 10 Hour Days
545079 ER Pueblo COLORADO 12 Hour Day/Night Rotate
545080 ER Pueblo COLORADO 12 Hour Nights
545532 CT Tech Montrose COLORADO 12 Hour Varied
545533 CT Tech Montrose COLORADO 12 Hour Varied
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
546703 CT Tech Kremmling COLORADO 12 Hour Days
546788 Long Term Care Westminster COLORADO 12 Hour Nights
546795 MLT Estes Park COLORADO 12 Hour Nights
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
547365 RAD Tech Aspen COLORADO 8 Hour Days
547431 L&D Pueblo COLORADO 12 Hour Nights
547499 Cath Lab Pueblo COLORADO 10 Hour Varied
547539 Case Manager Vail COLORADO Days
547760 Med Surg Greeley COLORADO 12 Hour Nights
547792 Scrub Tech Pueblo COLORADO 12 Hour Day/Night Rotate
547815 Scrub Tech Yuma COLORADO 12 Hour Nights
547905 ICU Greeley COLORADO 12 Hour Nights
547914 ER Estes Park COLORADO 12 Hour Nights
541769 Oncology Pueblo COLORADO 12 Hour Days
529926 SLP Grand Junction COLORADO Days
401167 Med Surg San Diego CALIFORNIA 12 Hour Nights
447084 CT Tech La Palma CALIFORNIA 12 Hour Day/Night Rotate
462914 Wound Care Los Alamitos CALIFORNIA 8 Hour Days
470815 PT Los Gatos CALIFORNIA Varied
479983 PT YUBA CITY CALIFORNIA Days
484788 PTA Merced CALIFORNIA Days
496231 COTA Oakhurst CALIFORNIA Days
497771 PT Sonora CALIFORNIA Days
497775 PT San Andreas CALIFORNIA Days
548246 Med Surg Tele CARMICHAEL CALIFORNIA 12 Hour Nights RN/Registered Nurse
548266 ICU BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
504074 Case Manager San Francisco CALIFORNIA 8 Hour Days
505339 PTA San Jose CALIFORNIA Days
505340 PT San Jose CALIFORNIA Days
505341 OT Rehab San Jose CALIFORNIA Days
505342 OT Rehab San Jose CALIFORNIA Days
507931 PT Martinez 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.6617 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 y.name desc limit 2600,100 in 1.5327 seconds