Listing all records

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

ID Job Specialty City State Shift Title
547708 Surgical Tech CVOR Zanesville OHIO Days
547815 Scrub Tech Yuma COLORADO 12 Hour Nights
479983 PT YUBA CITY CALIFORNIA Days
542049 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
536437 Cath Lab York PENNSYLVANIA 12 Hour Days
543822 Certified Surgical Tech York MAINE 8 Hour Days
547427 ICU York MAINE 12 Hour Nights
534255 Electrophysiology York PENNSYLVANIA 12 Hour Days
548195 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days CST/Certified Surgical Technician
546973 Interventional Radiology Tech York PENNSYLVANIA 8 Hour Days
539896 Ultrasound Tech York PENNSYLVANIA 12 Hour Day/Night Rotate
539898 Cardiovascular York PENNSYLVANIA Nights
546415 Oncology York PENNSYLVANIA Varied
539320 Oncology York PENNSYLVANIA 12 Hour Day/Night Rotate
545217 CT Tech York MAINE Days
547302 MLT York MAINE 8 Hour Day/Night Rotate
530585 PTA Yeadon PENNSYLVANIA Days
544192 PT Wrangell ALASKA Varied
547813 Case Manager Woonsocket RHODE ISLAND 8 Hour Days
543784 GI Lab Woonsocket RHODE ISLAND 8 Hour Days
543740 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Nights
543786 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Days
543779 OR Woonsocket RHODE ISLAND 8 Hour Days
541635 Case Manager Woonsocket RHODE ISLAND 8 Hour Days
547811 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Days
547812 ICU Woonsocket RHODE ISLAND 12 Hour Nights
543780 OR Woonsocket RHODE ISLAND 8 Hour Days
542605 Surgical Tech Woonsocket RHODE ISLAND 8 Hour Days
546473 Cath Lab Woonsocket RHODE ISLAND 10 Hour Days
543782 CT Tech Woonsocket RHODE ISLAND 8 Hour Nights
534694 Psych Woodsville NEW HAMPSHIRE 12 Hour Day/Night Rotate
526545 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
530439 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
547948 MLT Wolf Point MONTANA 8 Hour Days
484007 CT Tech Wolf Point MONTANA 12 Hour Day/Night Rotate
547867 PT Winter Park FLORIDA Days
547858 RAD Tech Winter Haven FLORIDA 8 Hour Days
547552 Interventional Radiology Tech Winston-Salem NORTH CAROLINA 8 Hour Days
542858 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
542856 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
546285 Rehab Windsor VERMONT 12 Hour Nights
546867 PTA Wilton CONNECTICUT Varied
545552 PT Wilton CONNECTICUT Varied
525839 RAD Tech Wilmington NORTH CAROLINA 12 Hour Days Radiology Techs/Technologists
544572 Step Down Willoughby OHIO 12 Hour Nights
545579 ER Willoughby OHIO 12 Hour Nights
544316 Cath Lab Willoughby OHIO 10 Hour Days
547495 Respiratory Therapist WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
543695 L&D WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547583 Dialysis WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
542462 SLP Williamstown NEW JERSEY Days
531219 PT Williamstown NEW JERSEY Days
547114 Outpatient Clinic Wichita Falls TEXAS 8 Hour Days
546395 CT Tech Wichita Falls TEXAS 8 Hour Evenings
541964 Cath Lab Whittier CALIFORNIA 8 Hour Days
546119 Nuclear Med Technician Whittier CALIFORNIA 8 Hour Days
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
546788 Long Term Care Westminster COLORADO 12 Hour Nights
548373 Med Surg Tele Westlake OHIO 12 Hour Nights RN/Registered Nurse
544263 Surgical Tech Westerville OHIO 12 Hour Days
543336 CT Tech Westerville OHIO 10 Hour Days
546421 Sterile Processing Technician Westerville OHIO 8 Hour Days
543115 L&D Westerville OHIO 12 Hour Nights
542345 MLT Westerville OHIO 8 Hour Nights
546177 Medical Assistant West Branch MICHIGAN 8 Hour Days
548243 Surgical Tech Wenatchee WASHINGTON 12 Hour Days ORT/Operating Room Technician
548030 Sterile Processing Technician Wenatchee WASHINGTON 12 Hour Day/Night Rotate
548156 Med Surg Weirton WEST VIRGINIA 12 Hour Days RN/Registered Nurse
522372 PT Weaverville CALIFORNIA Days
538176 Med Surg Waynesboro PENNSYLVANIA 12 Hour Day/Night Rotate
540589 MLT Watertown NEW YORK Days
546307 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546205 Long Term Care Watertown NEW YORK 12 Hour Day/Night Rotate
546308 ER Watertown NEW YORK 12 Hour Day/Night Rotate
542586 OR Watertown NEW YORK 8 Hour Varied
540588 MLT Watertown NEW YORK Varied
547579 MLT Watertown NEW YORK Nights
543046 Histology Technician Watertown NEW YORK Days
546233 Long Term Care Watertown NEW YORK 8 Hour Evenings
542981 Med Surg Watertown NEW YORK 12 Hour Nights
540994 Outpatient Clinic Watertown NEW YORK 8 Hour Day/Night Rotate
547566 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547576 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546679 OR Waterloo IOWA 12 Hour Days
547675 OR Waterloo IOWA 12 Hour Days
544530 Med Surg Waterloo IOWA 12 Hour Nights
540351 Cath Lab Waterloo IOWA 8 Hour Days
546366 ER Waterloo IOWA 12 Hour Nights
537493 Med Surg Tele Waterbury CONNECTICUT 12 Hour Nights
545423 Med Surg Waterbury CONNECTICUT 12 Hour Days
545424 Med Surg Waterbury CONNECTICUT 12 Hour Days
537494 Med Surg Tele Waterbury CONNECTICUT 12 Hour Nights
541323 Med Surg Tele Warrensville Heights OHIO 12 Hour Nights
547995 Med Surg Tele Warrensville Heights OHIO 12 Hour Days
547994 Med Surg Tele Warrensville Heights OHIO 12 Hour Days
540136 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540007 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540086 ICU Walnut Creek CALIFORNIA 12 Hour Nights
532657 Cath Lab Walnut Creek CALIFORNIA 10 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.5675 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 z.city desc limit 0,100 in 1.6147 seconds