Listing all records

Displaying records 3101 through 3200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546943 Med Surg Tele Cleveland OHIO 12 Hour Nights
547013 Med Surg Tele Cleveland OHIO 12 Hour Days
547014 Med Surg Tele Cleveland OHIO 12 Hour Days
547015 Med Surg Tele Cleveland OHIO 12 Hour Days
547016 Med Surg Tele Cleveland OHIO 12 Hour Days
547104 Med Surg Tele Cleveland OHIO 12 Hour Nights
547107 Step Down Cleveland OHIO 12 Hour Nights
547108 Clinic Cleveland OHIO 12 Hour Nights
547389 CT Tech Cleveland OHIO 8 Hour Nights
547390 CT Tech Cleveland OHIO 8 Hour Evenings
547392 Cath Lab Cleveland OHIO Days
547393 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547788 RRT- Respiratory Cleveland OHIO 12 Hour Nights
547805 ER Cleveland OHIO 12 Hour Day/Night Rotate
547808 RAD Tech Cleveland OHIO 10 Hour Day/Night Rotate
547809 RAD Tech Cleveland OHIO 8 Hour Days
547850 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
548024 Telemetry Cleveland OHIO 12 Hour Nights
548105 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
548363 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
548376 Med Surg Tele Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548380 Med Surg Tele Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548395 Telemetry Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548408 OR Cleveland OHIO 12 Hour Days RN/Registered Nurse
540931 Med Surg Tele Cleveland OHIO 12 Hour Nights
541381 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
542525 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
542526 ICU Cleveland OHIO 12 Hour Day/Night Rotate
542601 Ambulatory Cleveland OHIO 8 Hour Days
542908 ICU Cleveland OHIO 12 Hour Day/Night Rotate
543044 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
543045 Sterile Processing Tech Cleveland OHIO 8 Hour Evenings
543214 Telemetry Cleveland OHIO 12 Hour Nights
543215 Telemetry Cleveland OHIO 12 Hour Nights
543259 Step Down Cleveland OHIO 12 Hour Nights
543260 Step Down Cleveland OHIO 12 Hour Nights
543387 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
544116 Telemetry Cleveland OHIO 12 Hour Nights
518254 PT Cleburne TEXAS Varied
526053 RAD Tech Clearwater FLORIDA 8 Hour Days RN/Registered Nurse
547369 Interventional Radiology Tech Clearwater FLORIDA 10 Hour Days
547293 Radiology Clarkston WASHINGTON 8 Hour Days
542500 MRI Tech Clarkston WASHINGTON Varied
545020 OR Clarkston WASHINGTON 10 Hour Varied
545021 OR Clarkston WASHINGTON 10 Hour Varied
547027 Long Term Care Claremont NEW HAMPSHIRE 12 Hour Nights
544586 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Day/Night Rotate
545014 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Days
546670 Outpatient Clinic Claremont NEW HAMPSHIRE 8 Hour Days
547050 CNA Claremont NEW HAMPSHIRE 8 Hour Evenings
547462 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Days
547463 CNA Claremont NEW HAMPSHIRE 8 Hour Day/Night Rotate
547464 CNA Claremont NEW HAMPSHIRE 8 Hour Evenings
547465 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Evenings
548211 RRT- Respiratory Claremont NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
548389 Cardiac Cath Lab Clackamas OREGON 12 Hour Days Advanced Practice
548390 Cardiac Cath Lab Clackamas OREGON 10 Hour Days Advanced Practice
547341 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547342 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547343 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547344 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547347 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547348 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547349 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547487 Patient Care Coordinator Clackamas OREGON 8 Hour Days
546230 RAD Tech Cincinnati OHIO 12 Hour Day/Night Rotate
546265 ER Cincinnati OHIO Nights
547871 L&D Cincinnati OHIO Nights
529165 Surgical Tech CVOR Cincinnati OHIO 10 Hour Days
532256 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
535536 CNA Cincinnati OHIO Days
538304 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
543593 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
545370 Step Down Cincinnati OHIO Nights
545371 Step Down Cincinnati OHIO Days
545372 Step Down Cincinnati OHIO Nights
547954 L&D Cincinnati OHIO Days
538355 Cardiovascular Technologist Chino CALIFORNIA 8 Hour Days
537353 OR Chino CALIFORNIA 12 Hour Day/Night Rotate
538356 RAD Tech Chino CALIFORNIA 8 Hour Days
548269 PCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
548302 CCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
547500 Med Surg Chillicothe OHIO 12 Hour Nights
547530 Cardiac ICU Chillicothe OHIO 12 Hour Nights
547573 Med Surg Chillicothe OHIO 12 Hour Days
547671 Med Surg Chillicothe OHIO 12 Hour Nights
540993 Med Surg Tele Chillicothe OHIO 12 Hour Nights
542578 Outpatient Clinic Chillicothe OHIO 10 Hour Varied
543483 Med Surg Chillicothe OHIO 12 Hour Nights
548017 PACU Chico CALIFORNIA 10 Hour Days
548375 ICU Chicago ILLINOIS 12 Hour Nights RN/Registered Nurse
546672 Administration Cheyenne WYOMING Days
541649 Med Surg Chewelah WASHINGTON 12 Hour Nights
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
541886 Rehab Chesterfield MONTANA 12 Hour Days
530909 SLP Chesnee SOUTH CAROLINA Days
542822 Therapy Rehab Cheraw SOUTH CAROLINA Days
546767 PTA Charlton MASSACHUSETTS Days
546750 Med Surg Charlottesville VIRGINIA 12 Hour Nights
547006 CVOR Charlottesville VIRGINIA 10 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.8233 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 3100,100 in 1.892 seconds