Listing all records

Displaying records 801 through 900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545191 Surgical Tech New Albany OHIO 12 Hour Days
545227 Telemetry Cleveland OHIO 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
545229 Telemetry Cleveland OHIO 12 Hour Nights
545230 Telemetry Cleveland OHIO 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
545232 Step Down Cleveland OHIO 12 Hour Nights
545233 Step Down Cleveland OHIO 12 Hour Nights
545239 ER Columbus OHIO Nights
545240 ER Grove City OHIO 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
545370 Step Down Cincinnati OHIO Nights
545371 Step Down Cincinnati OHIO Days
545372 Step Down Cincinnati OHIO Nights
546643 Cath Lab Cleveland OHIO 10 Hour Days
545421 RN Columbus OHIO 12 Hour Nights
545541 RAD Tech Columbus OHIO 8 Hour Nights
545542 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
545579 ER Willoughby OHIO 12 Hour Nights
545582 Step Down Cleveland OHIO 12 Hour Nights
546020 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546021 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546047 MLT Columbus OHIO Nights
546077 ER Paulding OHIO 12 Hour Nights
546169 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546170 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546172 Med Surg Tele Gallipolis OHIO 12 Hour Nights
544680 ER Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
545058 ER Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
545149 Med Surg Hettinger NORTH DAKOTA 12 Hour Day/Night Rotate
545954 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
545955 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
546049 RAD Tech Bismarck NORTH DAKOTA 8 Hour Nights
546050 Pediatrics Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
541782 ICU Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
543590 L&D Devils Lake NORTH DAKOTA 12 Hour Day/Night Rotate
527927 PT Mandan NORTH DAKOTA 8 Hour Day/Night Rotate
535143 OT Rehab Devils Lake NORTH DAKOTA 8 Hour Days
545463 Vascular Ultrasound Tech Hettinger NORTH DAKOTA 8 Hour Days
537785 SLP Fargo NORTH DAKOTA Days
541271 PCU Bismarck NORTH DAKOTA Nights
541283 Surgical Tech CVOR Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
541391 RAD Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
542636 Oncology Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
543439 L&D Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
543454 Home Health Fargo NORTH DAKOTA 8 Hour Day/Night Rotate
543695 L&D WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
544096 Cath Lab Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
547065 Med Surg Grand Forks NORTH DAKOTA Days
547448 Med Surg Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547495 Respiratory Therapist WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
547583 Dialysis WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547794 Pediatrics Valley City NORTH DAKOTA Nights
547816 Angiography Grand Forks NORTH DAKOTA Days
547817 Respiratory Therapist Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547903 Surgical Tech Grand Forks NORTH DAKOTA Evenings
546402 CT Tech Mount Airy NORTH CAROLINA 8 Hour Nights
546403 CT Tech Mount Airy NORTH CAROLINA 12 Hour Nights
546405 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
546453 Step Down Elkin NORTH CAROLINA 12 Hour Days
546609 EP Tech Pinehurst NORTH CAROLINA 10 Hour Days
546874 Med Surg Tele Greensboro NORTH CAROLINA 12 Hour Nights
546897 Cath Lab New Bern NORTH CAROLINA 8 Hour Days
547045 Cath Lab New Bern NORTH CAROLINA 10 Hour Days
547046 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
547099 PT Laurinburg NORTH CAROLINA 8 Hour Days
547323 Med Surg Tele Raeford NORTH CAROLINA 12 Hour Nights
547474 LTAC Fayetteville NORTH CAROLINA 12 Hour Nights
547475 LTAC Fayetteville NORTH CAROLINA 12 Hour Days
547482 CT Tech Rockingham NORTH CAROLINA 12 Hour Nights
547552 Interventional Radiology Tech Winston-Salem NORTH CAROLINA 8 Hour Days
547604 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
547605 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
547680 Long Term Care Brantwood NORTH CAROLINA 12 Hour Nights
547820 OR Laurinburg NORTH CAROLINA 8 Hour Days
547894 Med Surg Oxford NORTH CAROLINA 12 Hour Nights
506863 Surgical Tech Durham NORTH CAROLINA 10 Hour Days
512894 MLT Hickory NORTH CAROLINA 12 Hour Days
513169 Phlebotomist Hickory NORTH CAROLINA 12 Hour Nights
513688 Certified Surgical Tech Hickory NORTH CAROLINA 8 Hour Days
515218 Sterile Processing Technician Hickory NORTH CAROLINA 12 Hour Nights
525839 RAD Tech Wilmington NORTH CAROLINA 12 Hour Days Radiology Techs/Technologists
527593 PT Pinehurst NORTH CAROLINA 8 Hour Days
528615 SLP Salisbury NORTH CAROLINA Days
536346 CVOR Lumberton NORTH CAROLINA 8 Hour Days RN/Registered Nurse
538047 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
548036 MLT New Bern NORTH CAROLINA 10 Hour Nights
548037 OR Laurinburg NORTH CAROLINA 8 Hour Days
548221 Social Worker Greensboro NORTH CAROLINA 8 Hour Days Social Worker
548235 ER Greensboro NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
544422 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544502 Interventional Radiology Tech Fayetteville NORTH CAROLINA 10 Hour Days
544518 PCU Fayetteville NORTH CAROLINA 12 Hour Nights
544547 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544658 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544667 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
544870 ICU Oxford NORTH CAROLINA 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.6519 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 800,100 in 1.6075 seconds