Listing all records

Displaying records 2501 through 2600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
547945 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
544251 OR Farmington CONNECTICUT 10 Hour Days
545273 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
545226 Cardiac Telemetry Farmington NEW MEXICO 12 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
545489 MRI Tech Farmington CONNECTICUT 8 Hour Evenings
545490 CT Tech Farmington CONNECTICUT 8 Hour Nights
547141 RAD Tech Farmington CONNECTICUT 8 Hour Nights
537785 SLP Fargo NORTH DAKOTA Days
546255 PT Falls River MASSACHUSETTS 12 Hour Day/Night Rotate
547351 PT Falls City NEBRASKA 8 Hour Days
547352 PT Falls City NEBRASKA 8 Hour Days
546639 Cardiac ICU Falls Church VIRGINIA 12 Hour Day/Night Rotate
547036 Surgical Tech Falls Church VIRGINIA 8 Hour Day/Night Rotate
547672 CVOR Falls Church VIRGINIA 12 Hour Days
547673 CVOR Falls Church VIRGINIA 12 Hour Days
547674 CVOR Falls Church VIRGINIA 12 Hour Days
531958 Social Worker Falls Church VIRGINIA 8 Hour Days
537453 MRI Tech Falls Church VIRGINIA 12 Hour Days
538546 OR Falls Church VIRGINIA 12 Hour Nights
539742 Laboratory Falls Church VIRGINIA 8 Hour Evenings
540788 Sonographer Falls Church VIRGINIA 8 Hour Days
543243 CVOR Falls Church VIRGINIA 12 Hour Days RN/Registered Nurse
548167 ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548064 Respiratory Therapist Falls Church VIRGINIA 12 Hour Nights Respiratory Therapist
548179 Case Manager Falls Church VIRGINIA 8 Hour Days RN/Registered Nurse
548180 Pediatric ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548313 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548314 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548350 CVOR Falls Church VIRGINIA 12 Hour Day/Night Rotate RN/Registered Nurse
548352 Surgical Tech Falls Church VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
548357 Perfusionist Falls Church VIRGINIA 12 Hour Days Perfusionist
547272 Step Down Fairmont WEST VIRGINIA 12 Hour Nights
547866 RRT- Respiratory Exeter NEW HAMPSHIRE 12 Hour Nights
542272 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
542273 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
541447 Cath Lab Everett WASHINGTON 10 Hour Days
509595 Anesthesia Tech Everett WASHINGTON 12 Hour Varied
516790 PACU Everett WASHINGTON 12 Hour Days
527226 ER Everett WASHINGTON 12 Hour Nights
532997 SLP Everett WASHINGTON 8 Hour Days
544504 PT Everett WASHINGTON 8 Hour Days
544750 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544751 Med Surg Tele Everett WASHINGTON 12 Hour Nights
546724 Oncology Everett WASHINGTON 12 Hour Nights
546725 Telemetry Everett WASHINGTON 12 Hour Nights
546727 Telemetry Everett WASHINGTON 12 Hour Nights
546728 Intermediate Care Everett WASHINGTON 12 Hour Nights
546729 Telemetry Everett WASHINGTON 12 Hour Nights
546730 Telemetry Everett WASHINGTON 12 Hour Nights
546731 Telemetry Everett WASHINGTON 12 Hour Nights
546732 Telemetry Everett WASHINGTON 12 Hour Nights
546733 Telemetry Everett WASHINGTON 12 Hour Nights
546859 Telemetry Everett WASHINGTON 12 Hour Nights
547008 Oncology Everett WASHINGTON 12 Hour Nights
547834 Dialysis Tech Everett WASHINGTON 10 Hour Varied
548228 EP Tech Evanston ILLINOIS 8 Hour Days Advanced Practice
541700 L&D Eureka CALIFORNIA 12 Hour Nights
541705 PT Eureka CALIFORNIA 8 Hour Days
542838 Case Manager Eureka CALIFORNIA 8 Hour Days
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
545316 SLP Eureka CALIFORNIA 8 Hour Days
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
540799 Med Surg Tele Euclid OHIO 12 Hour Nights
541105 PT Estes Park COLORADO 12 Hour Day/Night Rotate
546795 MLT Estes Park COLORADO 12 Hour Nights
547914 ER Estes Park COLORADO 12 Hour Nights
535889 PTA Essex MARYLAND Days
545126 Med Surg Espanola NEW MEXICO Nights
548096 Med Surg Espanola NEW MEXICO 12 Hour Nights RN/Registered Nurse
544846 OR Espanola NEW MEXICO 10 Hour Days
548026 PT Escondido 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.7101 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 2500,100 in 1.7902 seconds