Listing all records

Displaying records 1901 through 2000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545810 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544652 Med Surg Alamosa COLORADO 12 Hour Nights
544658 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544667 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
545812 ICU Gainesville FLORIDA 12 Hour Nights
546578 ER Brooklyn NEW YORK 12 Hour Nights
546140 Med Surg Tele Des Moines IOWA 12 Hour Nights
544705 ER Des Moines IOWA 12 Hour Nights
544750 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544751 Med Surg Tele Everett WASHINGTON 12 Hour Nights
545973 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
546593 ER Brooklyn NEW YORK 12 Hour Nights
544792 Orthopedics Detroit MICHIGAN 12 Hour Nights
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
545758 Med Surg Gainesville FLORIDA 12 Hour Nights
546597 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
545975 ICU Gainesville FLORIDA 12 Hour Nights
544819 ER Schenectady NEW YORK 12 Hour Nights
545579 ER Willoughby OHIO 12 Hour Nights
544853 Med Surg Kingsport TENNESSEE 12 Hour Nights
544870 ICU Oxford NORTH CAROLINA 12 Hour Nights
544871 ICU Oxford NORTH CAROLINA 12 Hour Nights
544876 Med Surg Tele Portland OREGON 12 Hour Nights
544877 Med Surg Tele Portland OREGON 12 Hour Nights
544894 Respiratory Therapist Newark NEW JERSEY 12 Hour Nights
546335 Psych Wailuku HAWAII 12 Hour Nights
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
545813 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544908 ER Oceanside CALIFORNIA 12 Hour Nights
545981 Med Surg Gainesville FLORIDA 12 Hour Nights
544918 Step Down Parma OHIO 12 Hour Nights
545836 ICU Gainesville FLORIDA 12 Hour Nights
544937 Med Surg Detroit MICHIGAN 12 Hour Nights
545759 ICU Gainesville FLORIDA 12 Hour Nights
544952 Med Surg Boise IDAHO 12 Hour Nights
544954 Telemetry Twin Falls IDAHO 12 Hour Nights
545582 Step Down Cleveland OHIO 12 Hour Nights
544995 PCU Omaha NEBRASKA 12 Hour Nights
544996 CT Tech Omaha NEBRASKA 12 Hour Nights
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
546620 ER Saratoga Springs NEW YORK 12 Hour Nights
545982 ICU Gainesville FLORIDA 12 Hour Nights
546144 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
545035 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545071 RRT- Respiratory Cleveland OHIO 12 Hour Nights
545080 ER Pueblo COLORADO 12 Hour Nights
545768 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
546145 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
545091 Med Surg Oregon City OREGON 12 Hour Nights
545092 ER Portland OREGON 12 Hour Nights
545096 ER Burbank CALIFORNIA 12 Hour Nights
545983 Med Surg Gainesville FLORIDA 12 Hour Nights
545984 ICU Gainesville FLORIDA 12 Hour Nights
545767 Med Surg Gainesville FLORIDA 12 Hour Nights
546146 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
545128 Med Surg Albuquerque NEW MEXICO 12 Hour Nights
545133 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
545136 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
545140 PCU Coos Bay OREGON 12 Hour Nights
545154 RAD Tech Lebanon NEW HAMPSHIRE 12 Hour Nights
545165 Telemetry Cleveland OHIO 12 Hour Nights
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
545192 Acute Care Bronx NEW YORK 12 Hour Nights
545205 Med Surg Des Moines IOWA 12 Hour Nights
545206 Orthopedics Des Moines IOWA 12 Hour Nights
545207 ER Des Moines IOWA 12 Hour Nights
545771 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
545227 Telemetry Cleveland OHIO 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
545229 Telemetry Cleveland OHIO 12 Hour Nights
545230 Telemetry Cleveland OHIO 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
545232 Step Down Cleveland OHIO 12 Hour Nights
545233 Step Down Cleveland OHIO 12 Hour Nights
545238 ER Des Moines IOWA 12 Hour Nights
545240 ER Grove City OHIO 12 Hour Nights
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
545838 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545262 PCU Omaha NEBRASKA 12 Hour Nights
545992 Pediatrics King City CALIFORNIA 12 Hour Nights
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
545291 PCU Rock Hill SOUTH CAROLINA 12 Hour Nights
545292 CVICU Memphis TENNESSEE 12 Hour Nights
545299 CVICU Little Rock ARKANSAS 12 Hour Nights
545300 Med Surg Helena MONTANA 12 Hour Nights
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 12 Hour Nights
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
545311 ICU Colville WASHINGTON 12 Hour Nights
546010 Med Surg Prince Frederick MARYLAND 12 Hour Nights
545328 CNA Salem OREGON 12 Hour Nights
545785 Med Surg Gainesville FLORIDA 12 Hour Nights
545338 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
545610 Med Surg HOBBS NEW MEXICO 12 Hour Nights
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
545778 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545819 Med Surg Gainesville FLORIDA 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.4106 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.shift asc limit 1900,100 in 1.4206 seconds