Listing all records

Displaying records 3601 through 3700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547975 ER Goldendale WASHINGTON 12 Hour Nights
548018 MLT Aberdeen WASHINGTON 10 Hour Nights
548029 PT Goldendale WASHINGTON Days
548030 Sterile Processing Technician Wenatchee WASHINGTON 12 Hour Day/Night Rotate
548049 RAD Tech Centralia WASHINGTON 8 Hour Days Tech/Technologist
548083 Surgical Tech Seattle WASHINGTON 10 Hour Days Tech/Technologist
548134 Med Surg Tele Burien WASHINGTON 12 Hour Nights RN/Registered Nurse
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548151 L&D Silverdale WASHINGTON 12 Hour Days RN/Registered Nurse
548201 Medical Assistant Longview WASHINGTON 8 Hour Days Medical Assistant
548213 ICU Arlington WASHINGTON 12 Hour Days RN/Registered Nurse
548312 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548329 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548342 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
548348 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
546148 Med Surg Spokane WASHINGTON 8 Hour Evenings
544504 PT Everett WASHINGTON 8 Hour Days
544558 PCU Spokane WASHINGTON 12 Hour Nights
544742 Med Surg Spokane WASHINGTON 12 Hour Days
544743 Med Surg Spokane WASHINGTON 12 Hour Days
544750 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544751 Med Surg Tele Everett WASHINGTON 12 Hour Nights
545020 OR Clarkston WASHINGTON 10 Hour Varied
545021 OR Clarkston WASHINGTON 10 Hour Varied
545125 RAD Tech Gig Harbor WASHINGTON 8 Hour Day/Night Rotate
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 12 Hour Nights
545311 ICU Colville WASHINGTON 12 Hour Nights
545915 RAD Tech Richland WASHINGTON 12 Hour Day/Night Rotate
545944 ICU Issaquah WASHINGTON 12 Hour Days
546084 Med Surg Tele Spokane WASHINGTON 12 Hour Days
546163 L&D Seattle WASHINGTON 12 Hour Nights
544310 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
544311 Cath Lab Charleston WEST VIRGINIA 12 Hour Days
544753 Interventional Radiology Tech Charleston WEST VIRGINIA 10 Hour Days
544990 PT Buckeye WEST VIRGINIA 8 Hour Days
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
546168 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
525843 PT Elizabeth WEST VIRGINIA 8 Hour Days PT/Physical Therapist
539020 Step Down Morgantown WEST VIRGINIA 12 Hour Nights
546739 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546740 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546742 Telemetry Charleston WEST VIRGINIA 12 Hour Nights
546743 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
546744 PCU Charleston WEST VIRGINIA 12 Hour Nights
546825 Surgical Tech CVOR Parkersburg WEST VIRGINIA 10 Hour Days
546827 CVOR Parkersburg WEST VIRGINIA 12 Hour Days
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
546918 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546919 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546920 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546958 Med Surg Tele Princeton WEST VIRGINIA 12 Hour Nights
546996 Mammo Tech Morgantown WEST VIRGINIA 8 Hour Days
547272 Step Down Fairmont WEST VIRGINIA 12 Hour Nights
547394 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
547526 Med Surg Parkersburg WEST VIRGINIA 12 Hour Nights
547936 CT Tech Morgantown WEST VIRGINIA 8 Hour Evenings
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
548126 Med Surg Tele Princeton WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
548156 Med Surg Weirton WEST VIRGINIA 12 Hour Days RN/Registered Nurse
548185 Surgical Tech CVOR Morgantown WEST VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
548196 ICU Ranson WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
548209 OB South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
548210 CNA South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
547952 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547953 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547955 OR Madison WISCONSIN 10 Hour Day/Night Rotate
547962 PICU Madison WISCONSIN 12 Hour Day/Night Rotate
547967 ER Madison WISCONSIN 12 Hour Day/Night Rotate
548294 OR Madison WISCONSIN 12 Hour Days RN/Registered Nurse
526368 COTA Colfax WISCONSIN Days
531994 Physician New Lisbon WISCONSIN Days
532081 Physician Stanley WISCONSIN 8 Hour Day/Night Rotate
536307 MRI Tech Janesville WISCONSIN 8 Hour Days
544177 Surgical Tech Madison WISCONSIN 8 Hour Day/Night Rotate
538434 Nuclear Med Technician Janesville WISCONSIN 8 Hour Days
538824 Medical Assistant Madison WISCONSIN 8 Hour Evenings
538892 Med Surg Janesville WISCONSIN 12 Hour Nights
544399 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
544634 APRN Stanley WISCONSIN Days
545033 Echo Technologist Madison WISCONSIN 8 Hour Day/Night Rotate
545339 APRN Plymouth WISCONSIN Days
545990 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
545991 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
541096 Long Term Care New Lisbon WISCONSIN 8 Hour Days
542081 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
542658 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
542669 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
542670 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
543041 Oncology Janesville WISCONSIN Varied
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
546627 CVICU Madison WISCONSIN 8 Hour Day/Night Rotate
547877 APRN Portage WISCONSIN Days
546794 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
547494 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547696 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547768 Long Term Care New Lisbon WISCONSIN 8 Hour Day/Night Rotate
547902 SLP Madison WISCONSIN 8 Hour Days
546672 Administration Cheyenne WYOMING Days
547624 L&D Laramie WYOMING 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.4114 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 3600,100 in 1.4744 seconds