Listing all records

Displaying records 3101 through 3200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547612 PICU Santa Clara CALIFORNIA 12 Hour Nights
547613 PICU Santa Clara CALIFORNIA 12 Hour Nights
547614 PICU Santa Clara CALIFORNIA 12 Hour Nights
547616 PICU Santa Clara CALIFORNIA 12 Hour Days
547618 PICU Santa Clara CALIFORNIA 12 Hour Days
547620 PICU Santa Clara CALIFORNIA 12 Hour Days
547621 PICU Santa Clara CALIFORNIA 12 Hour Days
547624 L&D Laramie WYOMING Nights
547625 CNA Kula HAWAII 8 Hour Days
547633 CT Tech Titusville FLORIDA 12 Hour Nights
547634 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
547635 SLP San Diego CALIFORNIA 8 Hour Days
547636 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
547637 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
547638 Med Surg Tele Lansing MICHIGAN 12 Hour Nights
547640 Med Surg Seattle WASHINGTON 12 Hour Nights
547642 Ambulatory Portland OREGON 8 Hour Days
547643 Med Surg Olympia WASHINGTON 12 Hour Nights
547646 L&D Seaside OREGON 12 Hour Day/Night Rotate
547647 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
547648 RAD Tech Dothan ALABAMA 8 Hour Days
547650 Telemetry Hannibal MISSOURI 12 Hour Days
547651 Med Surg Tele Spartanburg SOUTH CAROLINA 12 Hour Nights
547652 Echo Columbia SOUTH CAROLINA 8 Hour Days
547654 PCU Kearney NEBRASKA 12 Hour Nights
547655 Med Surg Kearney NEBRASKA 12 Hour Nights
547656 Rehab Omaha NEBRASKA 12 Hour Days
547657 PCU Omaha NEBRASKA 12 Hour Nights
547658 PCU Omaha NEBRASKA 12 Hour Nights
547659 PCU Omaha NEBRASKA 12 Hour Days
547662 Surgical Tech Omaha NEBRASKA 8 Hour Days
547664 ICU Oceanside CALIFORNIA 12 Hour Nights
547665 Oncology Oceanside CALIFORNIA 12 Hour Nights
547668 ICU Laconia NEW HAMPSHIRE Nights
547669 Home Health Springfield VERMONT 8 Hour Day/Night Rotate
547670 Psych Nashua NEW HAMPSHIRE 12 Hour Nights
547671 Med Surg Chillicothe OHIO 12 Hour Nights
547673 CVOR Falls Church VIRGINIA 12 Hour Days
547674 CVOR Falls Church VIRGINIA 12 Hour Days
547908 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
547675 OR Waterloo IOWA 12 Hour Days
547676 ICU Lowville NEW YORK 12 Hour Nights
547677 Med Surg Lowville NEW YORK 12 Hour Days
547678 Med Surg Lowville NEW YORK 12 Hour Days
547680 Long Term Care Brantwood NORTH CAROLINA 12 Hour Nights
547681 Radiation Therapy Flint MICHIGAN 10 Hour Days
547682 Echo Technologist Chambersburg PENNSYLVANIA Varied
547683 OT Athens GEORGIA 8 Hour Days
547692 Ambulatory New York NEW YORK 8 Hour Days
547696 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547697 PT Norristown PENNSYLVANIA Days
547699 OR Sun City ARIZONA 12 Hour Days
547702 RAD Tech Oklahoma City OKLAHOMA 12 Hour Nights
547704 Scrub Tech DILLON MONTANA 10 Hour Day/Night Rotate
547707 ICU North Platte NEBRASKA Nights
547708 Surgical Tech CVOR Zanesville OHIO Days
547709 Pediatrics Alturas CALIFORNIA 12 Hour Day/Night Rotate
547713 Med Surg Queens NEW YORK 12 Hour Nights
547714 Med Surg Queens NEW YORK 12 Hour Nights
547715 Med Surg New York NEW YORK 12 Hour Nights
547716 Med Surg New York NEW YORK 8 Hour Days
547718 Rehab New York NEW YORK Nights
547719 Med Surg Queens NEW YORK 12 Hour Days
547720 OR Concord CALIFORNIA 8 Hour Days
547725 Med Surg Mesa ARIZONA 12 Hour Days
547727 PCU Sun City ARIZONA 12 Hour Days
547728 PCU Mesa ARIZONA 12 Hour Nights
547730 PT Bolivar MISSOURI 8 Hour Days
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
547744 CT Tech Moses Lake WASHINGTON 12 Hour Nights
547745 SLP Philadelphia PENNSYLVANIA Days
547747 Ambulatory New York NEW YORK 8 Hour Days
547748 Med Surg New York NEW YORK 8 Hour Nights
547749 Med Surg New York NEW YORK 8 Hour Nights
547750 NICU Brooklyn NEW YORK 12 Hour Nights
547751 NICU Brooklyn NEW YORK 12 Hour Nights
547752 Med Surg Brooklyn NEW YORK Nights
547753 Med Surg Brooklyn NEW YORK Nights
547754 Med Surg Queens NEW YORK 12 Hour Days
547755 OR Albany NEW YORK 12 Hour Days
547757 Outpatient Clinic Cooperstown NEW YORK 8 Hour Days
547758 PCU Phoenix ARIZONA 12 Hour Nights
547759 Med Surg Sun City West ARIZONA 12 Hour Days
547760 Med Surg Greeley COLORADO 12 Hour Nights
547761 CT Tech Glendale ARIZONA 8 Hour Days
547762 PCU Glendale ARIZONA 12 Hour Nights
547763 CT Tech Glendale ARIZONA 10 Hour Nights
547764 CT Tech Phoenix ARIZONA 10 Hour Days
547765 Med Surg Sun City West ARIZONA 12 Hour Nights
547766 Wound Care Pittsfield MASSACHUSETTS 8 Hour Days
547768 Long Term Care New Lisbon WISCONSIN 8 Hour Day/Night Rotate
547771 Med Surg Tele Rome NEW YORK 12 Hour Nights
547773 Rehab PARAMOUNT CALIFORNIA 12 Hour Days
547774 Rehab PARAMOUNT CALIFORNIA 12 Hour Nights
547775 Clinic Sitka ALASKA Varied
547777 Histology Technician State College PENNSYLVANIA Days
547779 MLT Detroit MICHIGAN 8 Hour Evenings
547780 CT Tech Sunnyvale TEXAS 12 Hour Nights
547781 CT Tech Goodyear ARIZONA 10 Hour Nights
547782 PT Indio CALIFORNIA 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.7715 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 a.title desc limit 3100,100 in 1.5457 seconds