Listing all records

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

ID Job Specialty City State Shift Title
547697 PT Norristown PENNSYLVANIA Days
547698 ICU Saratoga Springs NEW YORK 12 Hour Nights
547699 OR Sun City ARIZONA 12 Hour Days
547700 CVOR Sun City ARIZONA 10 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
547711 ER New York NEW YORK 12 Hour Days
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
547717 L&D Bronx NEW YORK 12 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
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
547723 Med Surg Georgetown SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
547725 Med Surg Mesa ARIZONA 12 Hour Days
547727 PCU Sun City ARIZONA 12 Hour Days
547728 PCU Mesa ARIZONA 12 Hour Nights
547729 PCU Mesa ARIZONA 12 Hour Days
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
547746 Ambulatory New York NEW YORK 8 Hour 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
547756 Outpatient Clinic Cooperstown NEW YORK 8 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
547776 ER Morton WASHINGTON Nights
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
547786 CVOR North Kansas City MISSOURI 8 Hour Days
547788 RRT- Respiratory Cleveland OHIO 12 Hour Nights
547789 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
547791 Certified Surgical Tech State College PENNSYLVANIA 8 Hour Days
547792 Scrub Tech Pueblo COLORADO 12 Hour Day/Night Rotate
547793 ICU Bozeman MONTANA 12 Hour Day/Night Rotate
547794 Pediatrics Valley City NORTH DAKOTA Nights
547795 OR Tuba City ARIZONA 10 Hour Days
547796 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
547797 RAD Tech Columbus OHIO 8 Hour Days
547798 RAD Tech Columbus OHIO 8 Hour Days
547799 RAD Tech Pontiac MICHIGAN 8 Hour Nights
547800 RAD Tech Pontiac MICHIGAN 8 Hour Nights
547804 EEG Tech Hilo HAWAII 12 Hour Days
547805 ER Cleveland OHIO 12 Hour Day/Night Rotate
547806 PT Mammoth Lakes CALIFORNIA Days
547808 RAD Tech Cleveland OHIO 10 Hour Day/Night Rotate
547809 RAD Tech Cleveland OHIO 8 Hour Days
547810 Oncology Milford MASSACHUSETTS 12 Hour Nights
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
547815 Scrub Tech Yuma COLORADO 12 Hour Nights
547816 Angiography Grand Forks NORTH DAKOTA Days
547817 Respiratory Therapist Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547818 Long Term Care Lowville NEW YORK 12 Hour Days
547819 Long Term Care Lowville NEW YORK 12 Hour Days
547820 OR Laurinburg NORTH CAROLINA 8 Hour Days
547822 Interventional Radiology Tech Farmington NEW MEXICO 8 Hour Days
547824 Med Surg Tele Canton OHIO 12 Hour Nights
547825 Interventional Radiology Vero Beach FLORIDA 10 Hour Days
547832 PICU Syracuse NEW YORK Nights
547833 PT Farmington CONNECTICUT 8 Hour Days
547834 Dialysis Tech Everett WASHINGTON 10 Hour Varied
547835 Nuclear Med Technician Hilo HAWAII 8 Hour Days
547836 OR Honolulu HAWAII 8 Hour Day/Night Rotate
547837 Surgical Tech Honolulu HAWAII 8 Hour Day/Night Rotate
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
547844 CT Tech Des Moines IOWA 10 Hour Days
547845 Med Surg Portland OREGON 12 Hour 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.5218 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.id asc limit 3100,100 in 1.1652 seconds