Listing all records

Displaying records 501 through 600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
542262 CVOR Charlottesville VIRGINIA 10 Hour Days
542263 CVOR Charlottesville VIRGINIA 10 Hour Days
543133 Echo Charlottesville VIRGINIA 8 Hour Days
546750 Med Surg Charlottesville VIRGINIA 12 Hour Nights
547006 CVOR Charlottesville VIRGINIA 10 Hour Days
547376 PCU Charlottesville VIRGINIA 12 Hour Nights
547634 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
547860 Oncology Charlottesville VIRGINIA 10 Hour Days
547861 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547862 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547863 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
546767 PTA Charlton MASSACHUSETTS Days
542822 Therapy Rehab Cheraw SOUTH CAROLINA Days
530909 SLP Chesnee SOUTH CAROLINA Days
541886 Rehab Chesterfield MONTANA 12 Hour Days
541649 Med Surg Chewelah WASHINGTON 12 Hour Nights
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
546672 Administration Cheyenne WYOMING Days
548375 ICU Chicago ILLINOIS 12 Hour Nights RN/Registered Nurse
548017 PACU Chico CALIFORNIA 10 Hour Days
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
548269 PCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
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
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
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
546230 RAD Tech Cincinnati OHIO 12 Hour Day/Night Rotate
546265 ER Cincinnati OHIO Nights
547871 L&D Cincinnati OHIO Nights
545370 Step Down Cincinnati OHIO Nights
545371 Step Down Cincinnati OHIO Days
545372 Step Down Cincinnati OHIO Nights
547954 L&D Cincinnati OHIO Days
543593 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
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
548389 Cardiac Cath Lab Clackamas OREGON 12 Hour Days Advanced Practice
548390 Cardiac Cath Lab Clackamas OREGON 10 Hour Days Advanced Practice
548211 RRT- Respiratory Claremont NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
545014 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Days
547027 Long Term Care Claremont NEW HAMPSHIRE 12 Hour Nights
544586 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Day/Night Rotate
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
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
547369 Interventional Radiology Tech Clearwater FLORIDA 10 Hour Days
526053 RAD Tech Clearwater FLORIDA 8 Hour Days RN/Registered Nurse
518254 PT Cleburne TEXAS Varied
502855 Paramedic Cleveland OHIO Varied
526054 RAD Tech Cleveland OHIO 8 Hour Days Radiology Techs/Technologists
534249 Oncology Cleveland OHIO 12 Hour Days
534250 Oncology Cleveland OHIO 12 Hour Nights
535045 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
536801 Med Surg Tele Cleveland OHIO 12 Hour Nights
536850 Cath Lab Cleveland OHIO 8 Hour Days
536873 Telemetry Cleveland OHIO 12 Hour Nights
537981 ICU Cleveland OHIO 12 Hour Days
538278 Telemetry Cleveland OHIO 12 Hour Nights
538382 CT Tech Cleveland OHIO 8 Hour Evenings
539629 CT Tech Cleveland OHIO 8 Hour Nights
538741 ICU Cleveland OHIO 12 Hour Day/Night Rotate
538951 Med Surg Tele Cleveland OHIO 12 Hour Nights
538956 Med Surg Tele Cleveland OHIO 12 Hour Nights
539009 Med Surg Tele Cleveland OHIO 12 Hour Nights
539277 Med Surg Tele Cleveland OHIO 12 Hour Nights
539278 Med Surg Tele Cleveland OHIO 12 Hour Nights
539856 Med Surg Tele Cleveland OHIO 12 Hour Nights
539857 Med Surg Tele Cleveland OHIO 12 Hour Nights
546186 Med Surg Tele Cleveland OHIO 12 Hour Nights
546246 Clinic Cleveland OHIO 8 Hour Days
546379 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546380 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
546737 Med Surg Tele Cleveland OHIO 12 Hour Nights
546738 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546813 Clinic Cleveland OHIO 12 Hour Nights
546898 Telemetry Cleveland OHIO 12 Hour Nights
546902 Telemetry Cleveland OHIO 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.6768 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 500,100 in 1.6311 seconds