Listing all records

Displaying records 2701 through 2800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545938 Med Surg Gainesville FLORIDA 12 Hour Days
545940 Med Surg Gainesville FLORIDA 12 Hour Days
545941 Med Surg Gainesville FLORIDA 12 Hour Days
545944 ICU Issaquah WASHINGTON 12 Hour Days
545945 Med Surg Gainesville FLORIDA 12 Hour Days
545946 Med Surg Gainesville FLORIDA 12 Hour Days
545961 Med Surg Gainesville FLORIDA 12 Hour Days
545962 ICU Gainesville FLORIDA 12 Hour Days
545964 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
545965 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545969 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545971 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545974 Med Surg Gainesville FLORIDA 12 Hour Days
545976 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545977 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545978 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545988 Long Term Care King City CALIFORNIA 12 Hour Days
545997 LPN/LVN King City CALIFORNIA 12 Hour Days
546005 PCU Mesa ARIZONA 12 Hour Days
547235 NICU Brooklyn NEW YORK 12 Hour Days
546057 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
546084 Med Surg Tele Spokane WASHINGTON 12 Hour Days
546096 ICU Hilo HAWAII 12 Hour Days
546127 Med Surg Oxford NORTH CAROLINA 12 Hour Days
546128 Certified Surgical Tech Florence SOUTH CAROLINA 12 Hour Days
546129 Med Surg Portland OREGON 12 Hour Days
546141 Med Surg Des Moines IOWA 12 Hour Days
546142 Cardiology Muskegon MICHIGAN 12 Hour Days
547290 ER Norton VIRGINIA 12 Hour Days
546198 Med Surg Bristol TENNESSEE 12 Hour Days
547311 Telemetry Twin Falls IDAHO 12 Hour Days
546251 CNA TOWNSHEND VERMONT 12 Hour Days
546259 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546260 Oncology Oklahoma City OKLAHOMA 12 Hour Days
547626 Certified Surgical Tech Santa Monica CALIFORNIA 12 Hour Days
547340 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
546317 CT Tech ODESSA TEXAS 12 Hour Days
546331 ER Centerville IOWA 12 Hour Days
547374 PCU Albuquerque NEW MEXICO 12 Hour Days
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
547377 PCU Albuquerque NEW MEXICO 12 Hour Days
546354 Cardiology Fountain Valley CALIFORNIA 12 Hour Days
546368 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547931 Telemetry Brownsville TEXAS 12 Hour Days
546412 Med Surg Springfield VERMONT 12 Hour Days
547455 PCU Abilene TEXAS 12 Hour Days
546431 Med Surg Gainesville FLORIDA 12 Hour Days
546432 Telemetry Farmington CONNECTICUT 12 Hour Days
546461 ER Des Moines IOWA 12 Hour Days
547446 Rehab Seguin TEXAS 12 Hour Days
546448 Nuclear Med Technician Santa Monica CALIFORNIA 12 Hour Days
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
546453 Step Down Elkin NORTH CAROLINA 12 Hour Days
546462 ER Des Moines IOWA 12 Hour Days
546470 ICU East Norriton PENNSYLVANIA 12 Hour Days
546472 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Days
546554 Dialysis Brooklyn NEW YORK 12 Hour Days
546561 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546566 ICU Brooklyn NEW YORK 12 Hour Days
546567 ICU Brooklyn NEW YORK 12 Hour Days
546568 NICU Brooklyn NEW YORK 12 Hour Days
546573 MICU Brooklyn NEW YORK 12 Hour Days
546574 MICU Brooklyn NEW YORK 12 Hour Days
546576 MICU Brooklyn NEW YORK 12 Hour Days
546590 Med Surg Brooklyn NEW YORK 12 Hour Days
546591 MICU Brooklyn NEW YORK 12 Hour Days
546602 CT Tech Minneapolis MINNESOTA 12 Hour Days
546608 Med Surg Spokane WASHINGTON 12 Hour Days
546622 ER Saratoga Springs NEW YORK 12 Hour Days
546623 ER Saratoga Springs NEW YORK 12 Hour Days
546624 ER Saratoga Springs NEW YORK 12 Hour Days
546625 ER Saratoga Springs NEW YORK 12 Hour Days
546629 PCU Bristol TENNESSEE 12 Hour Days
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
548053 NICU New York NEW YORK 12 Hour Days RN/Registered Nurse
547939 Radiation Therapy Twin Falls IDAHO 12 Hour Days
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
546679 OR Waterloo IOWA 12 Hour Days
546684 L&D Detroit MICHIGAN 12 Hour Days
546687 PCU San Luis Obispo CALIFORNIA 12 Hour Days
546692 Med Surg Oceanside CALIFORNIA 12 Hour Days
546697 Surgical Tech Reno NEVADA 12 Hour Days
546699 Med Surg Spokane WASHINGTON 12 Hour Days
546703 CT Tech Kremmling COLORADO 12 Hour Days
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
547475 LTAC Fayetteville NORTH CAROLINA 12 Hour Days
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546801 PICU Walnut Creek CALIFORNIA 12 Hour Days
547537 Med Surg Tele Tulsa OKLAHOMA 12 Hour Days
546827 CVOR Parkersburg WEST VIRGINIA 12 Hour Days
546844 Telemetry Farmington CONNECTICUT 12 Hour Days
546858 CVOR Annapolis MARYLAND 12 Hour Days
546868 ER MERCED CALIFORNIA 12 Hour Days
547461 Radiology Tech Auburn NEW YORK 12 Hour Days
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
546912 ER Goldendale WASHINGTON 12 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.6419 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 2700,100 in 1.6415 seconds