Listing all records

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

ID Job Specialty City State Shift Title
532921 SLP Edwardsville ILLINOIS 8 Hour Days
545284 OR El Paso TEXAS 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
546359 DOU El Paso TEXAS 12 Hour Nights
525843 PT Elizabeth WEST VIRGINIA 8 Hour Days PT/Physical Therapist
546453 Step Down Elkin NORTH CAROLINA 12 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
546187 CT Tech Emmett IDAHO 8 Hour Days
548026 PT Escondido CALIFORNIA 8 Hour Days
548027 PTA Escondido CALIFORNIA 8 Hour Days
548096 Med Surg Espanola NEW MEXICO 12 Hour Nights RN/Registered Nurse
544846 OR Espanola NEW MEXICO 10 Hour Days
545126 Med Surg Espanola NEW MEXICO Nights
535889 PTA Essex MARYLAND Days
546795 MLT Estes Park COLORADO 12 Hour Nights
547914 ER Estes Park COLORADO 12 Hour Nights
541105 PT Estes Park COLORADO 12 Hour Day/Night Rotate
540799 Med Surg Tele Euclid OHIO 12 Hour Nights
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
545316 SLP Eureka CALIFORNIA 8 Hour Days
541700 L&D Eureka CALIFORNIA 12 Hour Nights
541705 PT Eureka CALIFORNIA 8 Hour Days
542838 Case Manager Eureka CALIFORNIA 8 Hour Days
548228 EP Tech Evanston ILLINOIS 8 Hour Days Advanced Practice
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
542272 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
542273 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
547866 RRT- Respiratory Exeter NEW HAMPSHIRE 12 Hour Nights
547272 Step Down Fairmont WEST VIRGINIA 12 Hour Nights
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
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
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
547351 PT Falls City NEBRASKA 8 Hour Days
547352 PT Falls City NEBRASKA 8 Hour Days
546255 PT Falls River MASSACHUSETTS 12 Hour Day/Night Rotate
537785 SLP Fargo NORTH DAKOTA Days
541891 Telemetry Farmington CONNECTICUT 12 Hour Nights
541779 Telemetry Farmington CONNECTICUT 12 Hour Days
531151 RAD Tech Farmington CONNECTICUT 8 Hour Days Radiology Techs/Technologists
531152 Med Surg Tele Farmington CONNECTICUT 12 Hour Nights RN/Registered Nurse
532660 CMA Farmington CONNECTICUT 8 Hour Days
533986 CMA Farmington CONNECTICUT 8 Hour Days
537460 Phlebotomist Farmington CONNECTICUT 8 Hour Days
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
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.6348 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 asc limit 1100,100 in 1.4249 seconds