Listing all records

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

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