Listing all records

Displaying records 1401 through 1500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545631 ICU Gainesville FLORIDA 12 Hour Nights
542063 ICU Wailuku HAWAII 12 Hour Nights
542071 Med Surg Tele Wailuku HAWAII 12 Hour Nights
545619 Med Surg Gainesville FLORIDA 12 Hour Nights
543974 ER Newark NEW JERSEY 12 Hour Nights
542103 Medical Assistant Portland OREGON 12 Hour Nights
542104 Medical Assistant Portland OREGON 12 Hour Nights
542137 Med Surg Brooklyn NEW YORK 12 Hour Nights
542138 Med Surg Brooklyn NEW YORK 12 Hour Nights
542176 ICU Boise IDAHO 12 Hour Nights
542177 ICU Boise IDAHO 12 Hour Nights
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
542242 Oncology Charlottesville VIRGINIA 12 Hour Nights
542243 Oncology Charlottesville VIRGINIA 12 Hour Nights
542272 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
542273 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
544819 ER Schenectady NEW YORK 12 Hour Nights
545645 Pediatric ER Gainesville FLORIDA 12 Hour Nights
542375 Med Surg Spokane WASHINGTON 12 Hour Nights
542390 Pediatric ER New York NEW YORK 12 Hour Nights
542451 ER Rockford ILLINOIS 12 Hour Nights
542466 Neurology Des Moines IOWA 12 Hour Nights
544037 Step Down Lansing MICHIGAN 12 Hour Nights
544529 Med Surg Kula HAWAII 12 Hour Nights
545655 Med Surg Gainesville FLORIDA 12 Hour Nights
546182 Med Surg Peoria ILLINOIS 12 Hour Nights
545662 MLT Gainesville FLORIDA 12 Hour Nights
544049 Med Surg Palm Springs CALIFORNIA 12 Hour Nights
544036 Step Down Lansing MICHIGAN 12 Hour Nights
544050 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
542615 Telemetry Terre Haute INDIANA 12 Hour Nights
542617 PCU Sun City West ARIZONA 12 Hour Nights
542653 Telemetry Charleston SOUTH CAROLINA 12 Hour Nights
542685 Postpartum Kealakekua HAWAII 12 Hour Nights
545620 Med Surg Gainesville FLORIDA 12 Hour Nights
544116 Telemetry Cleveland OHIO 12 Hour Nights
542713 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
545675 ICU Gainesville FLORIDA 12 Hour Nights
544552 ER Newark NEW JERSEY 12 Hour Nights
542740 ICU Saratoga Springs NEW YORK 12 Hour Nights
545676 Med Surg Gainesville FLORIDA 12 Hour Nights
542772 Med Surg Kingsport TENNESSEE 12 Hour Nights
542773 Med Surg Kingsport TENNESSEE 12 Hour Nights
542775 Med Surg Johnson City TENNESSEE 12 Hour Nights
542779 PCU Bristol TENNESSEE 12 Hour Nights
542781 ICU Boise IDAHO 12 Hour Nights
542782 ICU Boise IDAHO 12 Hour Nights
542790 PCU Kingsport TENNESSEE 12 Hour Nights
542803 Med Surg Newberg OREGON 12 Hour Nights
545683 Med Surg Gainesville FLORIDA 12 Hour Nights
542814 ER Bronx NEW YORK 12 Hour Nights
545699 Med Surg Gainesville FLORIDA 12 Hour Nights
542877 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
544434 Telemetry IOWA CITY IOWA 12 Hour Nights
545687 ICU Gainesville FLORIDA 12 Hour Nights
542910 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
542944 ER Concord CALIFORNIA 12 Hour Nights
542981 Med Surg Watertown NEW YORK 12 Hour Nights
543032 Long Term Care Lowville NEW YORK 12 Hour Nights
545693 ICU Gainesville FLORIDA 12 Hour Nights
544149 Long Term Care Moscow IDAHO 12 Hour Nights
545701 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544158 PACU Cleveland OHIO 12 Hour Nights
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
543090 MICU San Dimas CALIFORNIA 12 Hour Nights
543092 MICU San Dimas CALIFORNIA 12 Hour Nights
543095 Cath Lab Newark NEW JERSEY 12 Hour Nights
544153 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
548322 PICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
543097 Respiratory Therapist Newark NEW JERSEY 12 Hour Nights
543115 L&D Westerville OHIO 12 Hour Nights
543118 RN Columbus OHIO 12 Hour Nights
545711 ICU Gainesville FLORIDA 12 Hour Nights
543122 ER Primghar IOWA 12 Hour Nights
543123 ER Primghar IOWA 12 Hour Nights
545709 ICU Gainesville FLORIDA 12 Hour Nights
544060 ICU Pontiac MICHIGAN 12 Hour Nights
543147 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
545712 Med Surg Gainesville FLORIDA 12 Hour Nights
543199 ICU Newark NEW JERSEY 12 Hour Nights
545717 Intermediate Care Gainesville FLORIDA 12 Hour Nights
543214 Telemetry Cleveland OHIO 12 Hour Nights
543215 Telemetry Cleveland OHIO 12 Hour Nights
543225 PCU Johnson City TENNESSEE 12 Hour Nights
545720 ICU Gainesville FLORIDA 12 Hour Nights
544104 OR Langhorne PENNSYLVANIA 12 Hour Nights
545724 Med Surg Gainesville FLORIDA 12 Hour Nights
544052 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
543252 Telemetry Rock Hill SOUTH CAROLINA 12 Hour Nights
543259 Step Down Cleveland OHIO 12 Hour Nights
543260 Step Down Cleveland OHIO 12 Hour Nights
545726 Med Surg Gainesville FLORIDA 12 Hour Nights
545729 Med Surg Gainesville FLORIDA 12 Hour Nights
545728 Med Surg Gainesville FLORIDA 12 Hour Nights
543309 Telemetry Farmington CONNECTICUT 12 Hour Nights
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
545731 ICU Gainesville FLORIDA 12 Hour Nights
545730 ICU Gainesville FLORIDA 12 Hour Nights
545732 ICU 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.6451 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 desc limit 1400,100 in 1.5886 seconds