Listing all records

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

ID Job Specialty City State Shift Title
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
543881 Cath Lab Philadelphia PENNSYLVANIA 10 Hour Days
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
543884 ICU Philadelphia PENNSYLVANIA 12 Hour Days
541536 Cath Lab Portland OREGON 10 Hour Days
541543 Case Manager Portland OREGON 8 Hour Days
541613 Ultrasound Tech Portland OREGON 8 Hour Days
542103 Medical Assistant Portland OREGON 12 Hour Nights
542104 Medical Assistant Portland OREGON 12 Hour Nights
542803 Med Surg Newberg OREGON 12 Hour Nights
543245 Clinic Newport OREGON 8 Hour Days
543901 Med Surg Tele The Dalles OREGON Days
544031 Telemetry Portland OREGON 12 Hour Nights
544303 Ultrasound Tech Portland OREGON 10 Hour Days
544562 OR Oregon City OREGON 10 Hour Day/Night Rotate
544565 Outpatient Clinic Portland OREGON 8 Hour Days
544566 Med Surg Portland OREGON 12 Hour Nights
544876 Med Surg Tele Portland OREGON 12 Hour Nights
544877 Med Surg Tele Portland OREGON 12 Hour Nights
545066 PT Newport OREGON 8 Hour Days
545083 Cath Lab Corvallis OREGON 8 Hour Day/Night Rotate
545091 Med Surg Oregon City OREGON 12 Hour Nights
545092 ER Portland OREGON 12 Hour Nights
545098 Long Term Care Portland OREGON 12 Hour Days
545111 PT Salem OREGON Days
545112 PT Salem OREGON Days
545140 PCU Coos Bay OREGON 12 Hour Nights
545243 Scrub Tech The Dalles OREGON 12 Hour Day/Night Rotate
545257 CT Tech Roseburg OREGON 10 Hour Nights
545328 CNA Salem OREGON 12 Hour Nights
545389 Cardiology Coos Bay OREGON 8 Hour Days
546129 Med Surg Portland OREGON 12 Hour Days
546165 ER Portland OREGON 12 Hour Nights
546277 RAD Tech Albany OREGON 12 Hour Day/Night Rotate
546474 CVOR Corvallis OREGON 12 Hour Day/Night Rotate
546736 Outpatient Clinic Portland OREGON 8 Hour Days
547127 Med Surg Coos Bay OREGON 12 Hour Nights
547084 ICU Pendleton OREGON 12 Hour Nights
547085 ICU Pendleton OREGON 12 Hour Nights
547086 Med Surg Pendleton OREGON 12 Hour Nights
547087 Med Surg Pendleton OREGON 12 Hour Nights
547089 Med Surg Portland OREGON 12 Hour Nights
547257 L&D Portland OREGON 12 Hour Nights
547258 ICU Portland OREGON 12 Hour Nights
547259 ICU Portland OREGON 12 Hour Nights
547260 ICU Portland OREGON 12 Hour Nights
547295 Oncology Coos Bay OREGON 10 Hour Days
547324 Telemetry Portland OREGON 12 Hour Nights
547339 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547340 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
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
547512 Med Surg Coos Bay OREGON 12 Hour Nights
547540 PCU Coos Bay OREGON 12 Hour Days
547582 SLP Lincoln City OREGON 8 Hour Days
547592 Histology Technician Corvallis OREGON 8 Hour Days
547594 Urgent Care Corvallis OREGON 8 Hour Days
547623 ER Albany OREGON 12 Hour Day/Night Rotate
547642 Ambulatory Portland OREGON 8 Hour Days
547646 L&D Seaside OREGON 12 Hour Day/Night Rotate
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
547845 Med Surg Portland OREGON 12 Hour Nights
547848 CNA Portland OREGON 12 Hour Nights
547895 OR Coos Bay OREGON 10 Hour Days
516937 SLP Roseburg OREGON Days
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
541785 CNA The Dalles OREGON Nights
541786 ICU The Dalles OREGON 12 Hour Day/Night Rotate
524667 CT Tech Baker City OREGON 8 Hour Nights
529591 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
529597 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
533177 CT Tech Roseburg OREGON 8 Hour Days
536752 CT Tech Roseburg OREGON 12 Hour Nights
537514 CT Tech The Dalles OREGON 12 Hour Day/Night Rotate
539310 Speech Language Roseburg OREGON Days
547984 Home Health Portland OREGON 8 Hour Days
547985 Home Health Portland OREGON 8 Hour Days
548168 Certified Surgical Tech Coos Bay OREGON 10 Hour Days RN/Registered Nurse
548019 CNA Corvallis OREGON 12 Hour Day/Night Rotate
548025 ICU Portland OREGON 12 Hour Nights
548042 ER Pendleton OREGON 12 Hour Varied RN/Registered Nurse
548155 OR Coos Bay OREGON 10 Hour Days RN/Registered Nurse
548371 Med Surg Coos Bay OREGON 12 Hour Nights RN/Registered Nurse
548389 Cardiac Cath Lab Clackamas OREGON 12 Hour Days Advanced Practice
548390 Cardiac Cath Lab Clackamas OREGON 10 Hour Days Advanced Practice
548194 OR Norman OKLAHOMA 12 Hour Days RN/Registered Nurse
546259 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546260 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546270 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546271 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546781 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
547513 Surgical Tech CVOR Norman OKLAHOMA 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.3773 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 500,100 in 1.3558 seconds