Listing all records

Displaying records 3501 through 3600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546722 Med Surg Olympia WASHINGTON 12 Hour Nights
546724 Oncology Everett WASHINGTON 12 Hour Nights
546725 Telemetry Everett WASHINGTON 12 Hour Nights
546727 Telemetry Everett WASHINGTON 12 Hour Nights
546728 Intermediate Care Everett WASHINGTON 12 Hour Nights
546729 Telemetry 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
546733 Telemetry Everett WASHINGTON 12 Hour Nights
546793 Endoscopy Mt. Vernon WASHINGTON 10 Hour Day/Night Rotate
546859 Telemetry Everett WASHINGTON 12 Hour Nights
546899 Telemetry Spokane WASHINGTON 12 Hour Nights
546912 ER Goldendale WASHINGTON 12 Hour Days
546928 Med Surg Tele Mt. Vernon WASHINGTON 12 Hour Nights
546966 CT Tech Silverdale WASHINGTON 10 Hour Nights
547008 Oncology Everett WASHINGTON 12 Hour Nights
547138 ER Arlington WASHINGTON 12 Hour Nights
547293 Radiology Clarkston WASHINGTON 8 Hour Days
547381 L&D Seattle WASHINGTON 12 Hour Days
547382 L&D Seattle WASHINGTON 12 Hour Days
547383 L&D Seattle WASHINGTON 12 Hour Nights
547386 Med Surg Seattle WASHINGTON 12 Hour Nights
547436 CT Tech Olympia WASHINGTON 12 Hour Nights
547486 MRI Tech Pierce Tacoma WASHINGTON 10 Hour Evenings
547556 CT Tech Ritzville WASHINGTON 8 Hour Days
547834 Dialysis Tech Everett WASHINGTON 10 Hour Varied
547603 ICU Issaquah WASHINGTON 12 Hour Days
547637 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
547640 Med Surg Seattle WASHINGTON 12 Hour Nights
547643 Med Surg Olympia WASHINGTON 12 Hour Nights
547744 CT Tech Moses Lake WASHINGTON 12 Hour Nights
547776 ER Morton WASHINGTON Nights
547846 Step Down Centralia WASHINGTON 12 Hour Nights
547898 Nuclear Med Technician Seattle WASHINGTON 8 Hour Days
547900 Infection Prevention Specialist Seattle WASHINGTON 12 Hour Day/Night Rotate
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
541447 Cath Lab Everett WASHINGTON 10 Hour Days
541473 CVOR Spokane WASHINGTON 10 Hour Days
541482 CVOR Spokane WASHINGTON 10 Hour Days
541483 CVOR Spokane WASHINGTON 10 Hour Days
541484 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541485 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541486 CVOR Spokane WASHINGTON 10 Hour Days
541489 Med Surg Spokane WASHINGTON 12 Hour Nights
541491 Interventional Radiology Spokane WASHINGTON 10 Hour Days
541492 Med Surg Spokane WASHINGTON 12 Hour Nights
541498 Med Surg Spokane WASHINGTON 12 Hour Nights
541499 Med Surg Spokane WASHINGTON 12 Hour Nights
541500 PCU Spokane WASHINGTON 12 Hour Nights
541501 PCU Spokane WASHINGTON 12 Hour Nights
541502 Med Surg Spokane WASHINGTON 12 Hour Nights
541503 PCU Spokane WASHINGTON 12 Hour Nights
541504 PCU Spokane WASHINGTON 12 Hour Nights
541505 PCU Spokane WASHINGTON 12 Hour Nights
541506 Med Surg Spokane WASHINGTON 12 Hour Nights
541508 Med Surg Spokane WASHINGTON 12 Hour Nights
541510 Med Surg Spokane WASHINGTON 12 Hour Nights
541511 Med Surg Spokane WASHINGTON 12 Hour Nights
541512 Med Surg Spokane WASHINGTON 12 Hour Nights
541513 Med Surg Spokane WASHINGTON 12 Hour Nights
541514 Med Surg Spokane WASHINGTON 12 Hour Nights
541518 PCU Spokane WASHINGTON 12 Hour Nights
541519 PCU Spokane WASHINGTON 12 Hour Nights
541521 PCU Spokane WASHINGTON 12 Hour Days
541522 PCU Spokane WASHINGTON 12 Hour Days
541524 PCU Spokane WASHINGTON 12 Hour Nights
541525 PCU Spokane WASHINGTON 12 Hour Days
541526 PCU Spokane WASHINGTON 12 Hour Days
541527 PCU Spokane WASHINGTON 12 Hour Days
541620 Med Surg Spokane WASHINGTON 12 Hour Nights
541647 Med Surg Colville WASHINGTON 12 Hour Nights
541649 Med Surg Chewelah WASHINGTON 12 Hour Nights
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
541657 Med Surg Walla Walla WASHINGTON 12 Hour Nights
542364 OR Spokane WASHINGTON 12 Hour Days
542375 Med Surg Spokane WASHINGTON 12 Hour Nights
542500 MRI Tech Clarkston WASHINGTON Varied
543060 RAD Tech Toppenish WASHINGTON 8 Hour Days
543535 Med Surg Spokane WASHINGTON 12 Hour Nights
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
544034 PCU Spokane WASHINGTON 12 Hour Nights
454833 Med Surg Spokane WASHINGTON 12 Hour Nights
505886 MRI Tech Federal Way WASHINGTON 10 Hour Days
548243 Surgical Tech Wenatchee WASHINGTON 12 Hour Days ORT/Operating Room Technician
509595 Anesthesia Tech Everett WASHINGTON 12 Hour Varied
514692 SLP Spanaway WASHINGTON Days
514696 Therapy Rehab Spanaway WASHINGTON Days
516790 PACU Everett WASHINGTON 12 Hour Days
541958 CVICU Spokane WASHINGTON 12 Hour Nights
527226 ER Everett WASHINGTON 12 Hour Nights
530463 PT Republic WASHINGTON Days
532997 SLP Everett WASHINGTON 8 Hour Days
535128 Management Tacoma WASHINGTON Varied
535334 SLP Pasco WASHINGTON 12 Hour Day/Night Rotate
536150 Lab Tech King Renton WASHINGTON 8 Hour Days
539836 RAD Tech Seattle WASHINGTON 8 Hour Days
547938 Acute Care Mt. Vernon WASHINGTON 12 Hour Nights
547965 SLP Spanaway WASHINGTON Days
547966 LPN/LVN Spanaway WASHINGTON 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.8784 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 asc limit 3500,100 in 1.4599 seconds