Listing all records

Displaying records 1501 through 1600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545847 Intermediate Care Gainesville FLORIDA 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
545883 RRT- Respiratory Gainesville FLORIDA 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
544422 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
543118 RN Columbus OHIO 12 Hour Nights
545861 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
543122 ER Primghar IOWA 12 Hour Nights
543123 ER Primghar IOWA 12 Hour Nights
545860 Med Surg Gainesville FLORIDA 12 Hour Nights
543147 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
544450 Med Surg Tele Des Moines IOWA 12 Hour Nights
545867 Cardiology Gainesville FLORIDA 12 Hour Nights
545931 Med Surg Gainesville FLORIDA 12 Hour Nights
543199 ICU Newark NEW JERSEY 12 Hour Nights
545877 RRT- Respiratory 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
545879 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544104 OR Langhorne PENNSYLVANIA 12 Hour Nights
545885 Med Surg Gainesville FLORIDA 12 Hour Nights
544524 Med Surg Tele Wailuku HAWAII 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
545891 Med Surg Gainesville FLORIDA 12 Hour Nights
545895 ICU Gainesville FLORIDA 12 Hour Nights
545894 ICU Gainesville FLORIDA 12 Hour Nights
543309 Telemetry Farmington CONNECTICUT 12 Hour Nights
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
544529 Med Surg Kula HAWAII 12 Hour Nights
545903 Med Surg Gainesville FLORIDA 12 Hour Nights
545900 MLT Gainesville FLORIDA 12 Hour Nights
545904 Med Surg Gainesville FLORIDA 12 Hour Nights
543378 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544449 Med Surg Tele Des Moines IOWA 12 Hour Nights
543419 SICU Bowling Green KENTUCKY 12 Hour Nights
545122 Med Surg Lancaster OHIO 12 Hour Nights
545909 ICU Gainesville FLORIDA 12 Hour Nights
543461 Oncology Kingsport TENNESSEE 12 Hour Nights
543465 Telemetry Wailuku HAWAII 12 Hour Nights
543466 Med Surg Tele Wailuku HAWAII 12 Hour Nights
545839 ICU Gainesville FLORIDA 12 Hour Nights
543475 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
545911 ICU Gainesville FLORIDA 12 Hour Nights
543483 Med Surg Chillicothe OHIO 12 Hour Nights
543494 Med Surg Nashua NEW HAMPSHIRE 12 Hour Nights
547059 ER Rome NEW YORK 12 Hour Nights
543535 Med Surg Spokane WASHINGTON 12 Hour Nights
545927 Med Surg Gainesville FLORIDA 12 Hour Nights
545923 Med Surg Gainesville FLORIDA 12 Hour Nights
545932 Med Surg Gainesville FLORIDA 12 Hour Nights
543598 Rehab Twin Falls IDAHO 12 Hour Nights
543599 Telemetry Twin Falls IDAHO 12 Hour Nights
543607 Telemetry Nampa IDAHO 12 Hour Nights
543613 Telemetry Boise IDAHO 12 Hour Nights
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 12 Hour Nights
544632 ER Machias MAINE 12 Hour Nights
543644 ER Walnut Creek CALIFORNIA 12 Hour Nights
543645 ER Walnut Creek CALIFORNIA 12 Hour Nights
543646 ER Walnut Creek CALIFORNIA 12 Hour Nights
543647 ER Walnut Creek CALIFORNIA 12 Hour Nights
543648 ER Walnut Creek CALIFORNIA 12 Hour Nights
543649 ER Walnut Creek CALIFORNIA 12 Hour Nights
543650 ER Walnut Creek CALIFORNIA 12 Hour Nights
543651 ER Walnut Creek CALIFORNIA 12 Hour Nights
545942 Med Surg Gainesville FLORIDA 12 Hour Nights
543669 ICU Bristol TENNESSEE 12 Hour Nights
545311 ICU Colville WASHINGTON 12 Hour Nights
543730 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights
543740 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Nights
543747 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544628 Psych Cleveland OHIO 12 Hour Nights
546012 PCU Hays KANSAS 12 Hour Nights
543755 NICU Lynwood CALIFORNIA 12 Hour Nights
545966 Pediatrics Gainesville FLORIDA 12 Hour Nights
543759 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543760 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
545968 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545973 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545975 ICU Gainesville FLORIDA 12 Hour Nights
545972 Med Surg Gainesville FLORIDA 12 Hour Nights
545992 Pediatrics King City CALIFORNIA 12 Hour Nights
544627 Med Surg Tele Akron OHIO 12 Hour Nights
545982 ICU Gainesville FLORIDA 12 Hour Nights
545984 ICU Gainesville FLORIDA 12 Hour Nights
544558 PCU Spokane WASHINGTON 12 Hour Nights
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
545989 Long Term Care King City CALIFORNIA 12 Hour Nights
544552 ER Newark NEW JERSEY 12 Hour Nights
543807 PACU Albuquerque NEW MEXICO 12 Hour Nights
544547 Med Surg Tele Fayetteville NORTH CAROLINA 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.5797 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 1500,100 in 1.4059 seconds