Listing all records

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

ID Job Specialty City State Shift Title
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
546432 Telemetry Farmington CONNECTICUT 12 Hour Days
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
546668 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
546844 Telemetry Farmington CONNECTICUT 12 Hour Days
546867 PTA Wilton CONNECTICUT Varied
547074 Social Worker Farmington CONNECTICUT 8 Hour Days
547075 Social Worker Farmington CONNECTICUT 8 Hour Days
547076 CT Tech Farmington CONNECTICUT 12 Hour Nights
547077 CT Tech Farmington CONNECTICUT 12 Hour Nights
547480 ER Manchester CONNECTICUT 12 Hour Nights
547481 ER Manchester CONNECTICUT 12 Hour Nights
547549 Med Surg Tele Manchester CONNECTICUT 12 Hour Nights
547550 ER Manchester CONNECTICUT 12 Hour Nights
547833 PT Farmington CONNECTICUT 8 Hour Days
547941 Med Surg Tele Vernon Rockville CONNECTICUT 12 Hour Nights
548081 ICU Hartford CONNECTICUT 12 Hour Nights RN/Registered Nurse
548203 Technician Hartford CONNECTICUT 8 Hour Days Tech/Technologist
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
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
544251 OR Farmington CONNECTICUT 10 Hour Days
545273 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
544514 CT Tech Vernon Rockville CONNECTICUT 8 Hour Nights
545264 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
545274 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
545302 RAD Tech Farmington CONNECTICUT 8 Hour Evenings
545303 PACU Farmington CONNECTICUT 10 Hour Days
545423 Med Surg Waterbury CONNECTICUT 12 Hour Days
545424 Med Surg Waterbury CONNECTICUT 12 Hour Days
545489 MRI Tech Farmington CONNECTICUT 8 Hour Evenings
545490 CT Tech Farmington CONNECTICUT 8 Hour Nights
547141 RAD Tech Farmington CONNECTICUT 8 Hour Nights
545552 PT Wilton CONNECTICUT Varied
546104 ER Stafford Springs CONNECTICUT 12 Hour Nights
546105 ER Stafford Springs CONNECTICUT 12 Hour Nights
544929 CT Tech Titusville FLORIDA 10 Hour Nights
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545617 Med Surg Gainesville FLORIDA 12 Hour Days
545618 MLT Gainesville FLORIDA 8 Hour Nights
545619 Med Surg Gainesville FLORIDA 12 Hour Nights
545620 Med Surg Gainesville FLORIDA 12 Hour Nights
545627 Cardiology Gainesville FLORIDA 12 Hour Nights
545628 Med Surg Gainesville FLORIDA 12 Hour Days
545629 ICU Gainesville FLORIDA 12 Hour Nights
545630 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545631 ICU Gainesville FLORIDA 12 Hour Nights
545632 Med Surg Gainesville FLORIDA 12 Hour Days
545633 Med Surg Gainesville FLORIDA 12 Hour Nights
545634 Med Surg Gainesville FLORIDA 12 Hour Days
545635 Med Surg Gainesville FLORIDA 12 Hour Nights
545636 ICU Gainesville FLORIDA 12 Hour Nights
545637 ICU 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.374 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 asc limit 1100,100 in 1.5084 seconds