Listing all records

Displaying records 1 through 100 out of a total 3,709 records. Next

ID Job Specialty City State Shift Title
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
543047 PT thermopolis WYOMING Days
548002 ICU Gillette WYOMING 12 Hour Day/Night Rotate
548057 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
546672 Administration Cheyenne WYOMING Days
547899 CNA Lovell WYOMING 12 Hour Days
548147 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
547624 L&D Laramie WYOMING Nights
534923 PT thermopolis WYOMING Days
534924 PT thermopolis WYOMING Days
545440 OT Rehab thermopolis WYOMING Days
547877 APRN Portage WISCONSIN Days
538892 Med Surg Janesville WISCONSIN 12 Hour Nights
545991 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
547768 Long Term Care New Lisbon WISCONSIN 8 Hour Day/Night Rotate
538434 Nuclear Med Technician Janesville WISCONSIN 8 Hour Days
526368 COTA Colfax WISCONSIN Days
542669 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
545990 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
542658 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
531994 Physician New Lisbon WISCONSIN Days
536307 MRI Tech Janesville WISCONSIN 8 Hour Days
547967 ER Madison WISCONSIN 12 Hour Day/Night Rotate
548294 OR Madison WISCONSIN 12 Hour Days RN/Registered Nurse
547962 PICU Madison WISCONSIN 12 Hour Day/Night Rotate
538824 Medical Assistant Madison WISCONSIN 8 Hour Evenings
547696 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
544177 Surgical Tech Madison WISCONSIN 8 Hour Day/Night Rotate
544634 APRN Stanley WISCONSIN Days
547494 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
546794 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
544399 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547952 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
546627 CVICU Madison WISCONSIN 8 Hour Day/Night Rotate
542670 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
547902 SLP Madison WISCONSIN 8 Hour Days
547953 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547955 OR Madison WISCONSIN 10 Hour Day/Night Rotate
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
545339 APRN Plymouth WISCONSIN Days
532081 Physician Stanley WISCONSIN 8 Hour Day/Night Rotate
542081 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
543041 Oncology Janesville WISCONSIN Varied
541096 Long Term Care New Lisbon WISCONSIN 8 Hour Days
545033 Echo Technologist Madison WISCONSIN 8 Hour Day/Night Rotate
546739 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
547272 Step Down Fairmont WEST VIRGINIA 12 Hour Nights
546743 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
547526 Med Surg Parkersburg WEST VIRGINIA 12 Hour Nights
546744 PCU Charleston WEST VIRGINIA 12 Hour Nights
546920 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
547936 CT Tech Morgantown WEST VIRGINIA 8 Hour Evenings
544311 Cath Lab Charleston WEST VIRGINIA 12 Hour Days
546918 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546742 Telemetry Charleston WEST VIRGINIA 12 Hour Nights
547394 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546958 Med Surg Tele Princeton WEST VIRGINIA 12 Hour Nights
548209 OB South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
548126 Med Surg Tele Princeton WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
544990 PT Buckeye WEST VIRGINIA 8 Hour Days
546168 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
546825 Surgical Tech CVOR Parkersburg WEST VIRGINIA 10 Hour Days
548156 Med Surg Weirton WEST VIRGINIA 12 Hour Days RN/Registered Nurse
544753 Interventional Radiology Tech Charleston WEST VIRGINIA 10 Hour Days
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
546740 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546919 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
539020 Step Down Morgantown WEST VIRGINIA 12 Hour Nights
544310 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
548196 ICU Ranson WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
546827 CVOR Parkersburg WEST VIRGINIA 12 Hour Days
546996 Mammo Tech Morgantown WEST VIRGINIA 8 Hour Days
548185 Surgical Tech CVOR Morgantown WEST VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
548210 CNA South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
525843 PT Elizabeth WEST VIRGINIA 8 Hour Days PT/Physical Therapist
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
541500 PCU Spokane WASHINGTON 12 Hour Nights
543535 Med Surg Spokane WASHINGTON 12 Hour Nights
541514 Med Surg Spokane WASHINGTON 12 Hour Nights
541512 Med Surg Spokane WASHINGTON 12 Hour Nights
541501 PCU Spokane WASHINGTON 12 Hour Nights
541649 Med Surg Chewelah WASHINGTON 12 Hour Nights
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
544751 Med Surg Tele Everett WASHINGTON 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 12 Hour Nights
545125 RAD Tech Gig Harbor WASHINGTON 8 Hour Day/Night Rotate
541620 Med Surg Spokane WASHINGTON 12 Hour Nights
541502 Med Surg Spokane WASHINGTON 12 Hour Nights
541527 PCU Spokane WASHINGTON 12 Hour Days
541518 PCU Spokane WASHINGTON 12 Hour Nights
541519 PCU Spokane WASHINGTON 12 Hour Nights
542500 MRI Tech Clarkston WASHINGTON Varied
543060 RAD Tech Toppenish WASHINGTON 8 Hour Days
539836 RAD Tech Seattle WASHINGTON 8 Hour Days
532997 SLP Everett WASHINGTON 8 Hour Days
541647 Med Surg Colville WASHINGTON 12 Hour Nights
541657 Med Surg Walla Walla WASHINGTON 12 Hour Nights
545021 OR Clarkston WASHINGTON 10 Hour Varied
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.7385 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 0,100 in 1.594 seconds