Listing all records

Displaying records 101 through 200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547900 Infection Prevention Specialist Seattle WASHINGTON 12 Hour Day/Night Rotate
547603 ICU Issaquah WASHINGTON 12 Hour Days
547898 Nuclear Med Technician Seattle WASHINGTON 8 Hour Days
546727 Telemetry Everett WASHINGTON 12 Hour Nights
547834 Dialysis Tech Everett WASHINGTON 10 Hour Varied
546966 CT Tech Silverdale WASHINGTON 10 Hour Nights
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
546728 Intermediate Care Everett WASHINGTON 12 Hour Nights
547436 CT Tech Olympia WASHINGTON 12 Hour Nights
546729 Telemetry Everett WASHINGTON 12 Hour Nights
547008 Oncology Everett WASHINGTON 12 Hour Nights
546730 Telemetry Everett WASHINGTON 12 Hour Nights
546731 Telemetry Everett WASHINGTON 12 Hour Nights
546732 Telemetry Everett WASHINGTON 12 Hour Nights
546608 Med Surg Spokane WASHINGTON 12 Hour Days
546733 Telemetry Everett WASHINGTON 12 Hour Nights
547293 Radiology Clarkston WASHINGTON 8 Hour Days
547556 CT Tech Ritzville WASHINGTON 8 Hour Days
547486 MRI Tech Pierce Tacoma WASHINGTON 10 Hour Evenings
547846 Step Down Centralia WASHINGTON 12 Hour Nights
547138 ER Arlington WASHINGTON 12 Hour Nights
548213 ICU Arlington WASHINGTON 12 Hour Days RN/Registered Nurse
547938 Acute Care Mt. Vernon WASHINGTON 12 Hour Nights
548201 Medical Assistant Longview WASHINGTON 8 Hour Days Medical Assistant
547965 SLP Spanaway WASHINGTON Days
547966 LPN/LVN Spanaway WASHINGTON Days
547975 ER Goldendale WASHINGTON 12 Hour Nights
548151 L&D Silverdale WASHINGTON 12 Hour Days RN/Registered Nurse
548018 MLT Aberdeen WASHINGTON 10 Hour Nights
548348 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548029 PT Goldendale WASHINGTON Days
548030 Sterile Processing Technician Wenatchee WASHINGTON 12 Hour Day/Night Rotate
548342 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
548134 Med Surg Tele Burien WASHINGTON 12 Hour Nights RN/Registered Nurse
548049 RAD Tech Centralia WASHINGTON 8 Hour Days Tech/Technologist
548329 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548083 Surgical Tech Seattle WASHINGTON 10 Hour Days Tech/Technologist
548312 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
544034 PCU Spokane WASHINGTON 12 Hour Nights
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
543535 Med Surg Spokane WASHINGTON 12 Hour Nights
543060 RAD Tech Toppenish WASHINGTON 8 Hour Days
542500 MRI Tech Clarkston WASHINGTON Varied
542375 Med Surg Spokane WASHINGTON 12 Hour Nights
542364 OR Spokane WASHINGTON 12 Hour Days
541657 Med Surg Walla Walla WASHINGTON 12 Hour Nights
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
541649 Med Surg Chewelah WASHINGTON 12 Hour Nights
541647 Med Surg Colville WASHINGTON 12 Hour Nights
541620 Med Surg Spokane WASHINGTON 12 Hour Nights
541527 PCU Spokane WASHINGTON 12 Hour Days
541526 PCU Spokane WASHINGTON 12 Hour Days
541525 PCU Spokane WASHINGTON 12 Hour Days
541524 PCU Spokane WASHINGTON 12 Hour Nights
541522 PCU Spokane WASHINGTON 12 Hour Days
541521 PCU Spokane WASHINGTON 12 Hour Days
541519 PCU Spokane WASHINGTON 12 Hour Nights
541518 PCU Spokane WASHINGTON 12 Hour Nights
541514 Med Surg Spokane WASHINGTON 12 Hour Nights
541513 Med Surg Spokane WASHINGTON 12 Hour Nights
541512 Med Surg Spokane WASHINGTON 12 Hour Nights
541511 Med Surg Spokane WASHINGTON 12 Hour Nights
541510 Med Surg Spokane WASHINGTON 12 Hour Nights
541508 Med Surg Spokane WASHINGTON 12 Hour Nights
541506 Med Surg Spokane WASHINGTON 12 Hour Nights
541505 PCU Spokane WASHINGTON 12 Hour Nights
541504 PCU Spokane WASHINGTON 12 Hour Nights
541503 PCU Spokane WASHINGTON 12 Hour Nights
541502 Med Surg Spokane WASHINGTON 12 Hour Nights
541501 PCU Spokane WASHINGTON 12 Hour Nights
541500 PCU Spokane WASHINGTON 12 Hour Nights
541499 Med Surg Spokane WASHINGTON 12 Hour Nights
541498 Med Surg Spokane WASHINGTON 12 Hour Nights
541492 Med Surg Spokane WASHINGTON 12 Hour Nights
541491 Interventional Radiology Spokane WASHINGTON 10 Hour Days
541489 Med Surg Spokane WASHINGTON 12 Hour Nights
541486 CVOR Spokane WASHINGTON 10 Hour Days
541485 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541484 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541483 CVOR Spokane WASHINGTON 10 Hour Days
541482 CVOR Spokane WASHINGTON 10 Hour Days
541473 CVOR Spokane WASHINGTON 10 Hour Days
541447 Cath Lab Everett WASHINGTON 10 Hour Days
546084 Med Surg Tele Spokane WASHINGTON 12 Hour Days
546163 L&D Seattle WASHINGTON 12 Hour Nights
545020 OR Clarkston WASHINGTON 10 Hour Varied
545021 OR Clarkston WASHINGTON 10 Hour Varied
544751 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544750 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544743 Med Surg Spokane WASHINGTON 12 Hour Days
544742 Med Surg Spokane WASHINGTON 12 Hour Days
546148 Med Surg Spokane WASHINGTON 8 Hour Evenings
545944 ICU Issaquah WASHINGTON 12 Hour Days
545915 RAD Tech Richland WASHINGTON 12 Hour Day/Night Rotate
545125 RAD Tech Gig Harbor WASHINGTON 8 Hour Day/Night Rotate
544558 PCU Spokane WASHINGTON 12 Hour Nights
544504 PT Everett WASHINGTON 8 Hour Days
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 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.6466 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 100,100 in 1.3396 seconds