Listing all records

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

ID Job Specialty City State Shift Title
547393 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547494 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547454 ICU Abilene TEXAS 12 Hour Day/Night Rotate
525386 Vascular Ultrasound Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
547817 Respiratory Therapist Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
546794 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
540152 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
547805 ER Cleveland OHIO 12 Hour Day/Night Rotate
547879 Med Surg Kealakekua HAWAII 12 Hour Day/Night Rotate
540746 Med Surg Prescott ARIZONA 12 Hour Day/Night Rotate
545524 Postpartum Hilo HAWAII 12 Hour Day/Night Rotate
540516 RRT- Respiratory Chambersburg PENNSYLVANIA 12 Hour Day/Night Rotate
545026 OR Albany NEW YORK 12 Hour Day/Night Rotate
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
540104 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
544775 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
540749 Med Surg Tele Prescott ARIZONA 12 Hour Day/Night Rotate
545915 RAD Tech Richland WASHINGTON 12 Hour Day/Night Rotate
545979 CT Tech Santa Barbara CALIFORNIA 12 Hour Day/Night Rotate
546256 PACU Hilo HAWAII 12 Hour Day/Night Rotate
532051 Long Term Care Nome ALASKA 12 Hour Day/Night Rotate
546455 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
532256 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
547623 ER Albany OREGON 12 Hour Day/Night Rotate
547448 Med Surg Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547459 PCU Abilene TEXAS 12 Hour Day/Night Rotate
547566 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547495 Respiratory Therapist WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547583 Dialysis WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
547646 L&D Seaside OREGON 12 Hour Day/Night Rotate
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
547696 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
547850 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
542156 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
534694 Psych Woodsville NEW HAMPSHIRE 12 Hour Day/Night Rotate
547878 Echo Technologist Abilene TEXAS 12 Hour Day/Night Rotate
534972 CT Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
535045 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
542171 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
542160 CT Tech Lynwood CALIFORNIA 12 Hour Day/Night Rotate
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
535334 SLP Pasco WASHINGTON 12 Hour Day/Night Rotate
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
544789 CNA Kealakekua HAWAII 12 Hour Day/Night Rotate
544574 ICU Cleveland OHIO 12 Hour Day/Night Rotate
544586 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Day/Night Rotate
544604 Surgical Tech Duluth MINNESOTA 12 Hour Day/Night Rotate
538304 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
540745 Telemetry Prescott ARIZONA 12 Hour Day/Night Rotate
538394 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
544817 OR Albany NEW YORK 12 Hour Day/Night Rotate
546205 Long Term Care Watertown NEW YORK 12 Hour Day/Night Rotate
545079 ER Pueblo COLORADO 12 Hour Day/Night Rotate
545058 ER Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
544977 Scrub Tech Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
544788 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
545185 CVOR Houston TEXAS 12 Hour Day/Night Rotate
545149 Med Surg Hettinger NORTH DAKOTA 12 Hour Day/Night Rotate
538741 ICU Cleveland OHIO 12 Hour Day/Night Rotate
545244 Echo Technologist Tulsa OKLAHOMA 12 Hour Day/Night Rotate
546277 RAD Tech Albany OREGON 12 Hour Day/Night Rotate
538917 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
545342 Home Health Rockford ILLINOIS 12 Hour Day/Night Rotate
539087 Oncology Duluth MINNESOTA 12 Hour Day/Night Rotate
546255 PT Falls River MASSACHUSETTS 12 Hour Day/Night Rotate
540802 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
545626 Telemetry Prescott Valley ARIZONA 12 Hour Day/Night Rotate
546474 CVOR Corvallis OREGON 12 Hour Day/Night Rotate
539320 Oncology York PENNSYLVANIA 12 Hour Day/Night Rotate
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
545991 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
545990 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
546050 Pediatrics Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
546054 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
546169 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546053 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
546170 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546869 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546230 RAD Tech Cincinnati OHIO 12 Hour Day/Night Rotate
546308 ER Watertown NEW YORK 12 Hour Day/Night Rotate
539718 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
546379 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546381 Paramedic Lewisburg PENNSYLVANIA 12 Hour Day/Night Rotate
546380 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
539896 Ultrasound Tech York PENNSYLVANIA 12 Hour Day/Night Rotate
539903 MLT Tuba City ARIZONA 12 Hour Day/Night Rotate
541391 RAD Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
546785 Med Surg IOWA CITY IOWA 12 Hour Day/Night Rotate
541381 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
546832 Therapy Rehab Spring Valley ILLINOIS 12 Hour Day/Night Rotate
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
546835 Registered Dietician Waimea HAWAII 12 Hour Day/Night Rotate
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.4694 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.shift desc limit 700,100 in 1.2692 seconds