Listing all records

Displaying records 3201 through 3300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
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
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
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
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
547846 Step Down Centralia WASHINGTON 12 Hour Nights
547847 PCU Tarzana CALIFORNIA 12 Hour Nights
547848 CNA Portland OREGON 12 Hour Nights
547850 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547851 Nuclear Med Technician Liberal KANSAS 8 Hour Days
547852 Ultrasound Tech Fredericksburg VIRGINIA 8 Hour Days
547853 Med Surg Valdosta GEORGIA 12 Hour Nights
547854 Med Surg Valdosta GEORGIA 12 Hour Days
547858 RAD Tech Winter Haven FLORIDA 8 Hour Days
547860 Oncology Charlottesville VIRGINIA 10 Hour Days
547861 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547862 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547863 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
547865 Certified Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547866 RRT- Respiratory Exeter NEW HAMPSHIRE 12 Hour Nights
547867 PT Winter Park FLORIDA Days
547869 PT Savannah GEORGIA Days
547871 L&D Cincinnati OHIO Nights
547872 Med Surg Columbia MISSOURI 12 Hour Nights
547873 Endoscopy Columbia MISSOURI 8 Hour Varied
547875 Urgent Care Saratoga Springs NEW YORK 12 Hour Days
547876 RAD Tech Pontiac MICHIGAN 8 Hour Evenings
547878 Echo Technologist Abilene TEXAS 12 Hour Day/Night Rotate
547879 Med Surg Kealakekua HAWAII 12 Hour Day/Night Rotate
547881 Wound Care State College PENNSYLVANIA 8 Hour Days
547882 ICU Johnson City TENNESSEE 12 Hour Nights
547883 PTA Daly City CALIFORNIA Days
547884 Clinic State College PENNSYLVANIA Days
547886 CT Tech McCall IDAHO 12 Hour Nights
547887 CT Tech McCall IDAHO Days
547888 Cath Lab Danville KENTUCKY 10 Hour Days
547889 RRT- Respiratory Meridian IDAHO 12 Hour Nights
547890 CT Tech Knoxville TENNESSEE 12 Hour Nights
547891 Therapy Rehab Twin Falls IDAHO 10 Hour Days
547892 SLP Twin Falls IDAHO 10 Hour Days
547893 Certified Surgical Tech Lake Charles LOUISIANA 8 Hour Days
547894 Med Surg Oxford NORTH CAROLINA 12 Hour Nights
547895 OR Coos Bay OREGON 10 Hour Days
547898 Nuclear Med Technician Seattle WASHINGTON 8 Hour Days
547899 CNA Lovell WYOMING 12 Hour Days
547900 Infection Prevention Specialist Seattle WASHINGTON 12 Hour Day/Night Rotate
547902 SLP Madison WISCONSIN 8 Hour Days
547905 ICU Greeley COLORADO 12 Hour Nights
547906 ICU Sun City ARIZONA 12 Hour Nights
547909 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
547910 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547911 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547913 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Days
547914 ER Estes Park COLORADO 12 Hour Nights
548031 Cath Lab Berwyn ILLINOIS 8 Hour Days
547916 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547957 OR Mesquite TEXAS 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.8544 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 3200,100 in 1.5175 seconds