Listing all records

Displaying records 2801 through 2900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546198 Med Surg Bristol TENNESSEE 12 Hour Days
546251 CNA TOWNSHEND VERMONT 12 Hour Days
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
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
547557 CT Tech Akron OHIO 12 Hour Days
546317 CT Tech ODESSA TEXAS 12 Hour Days
546331 ER Centerville IOWA 12 Hour Days
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
546354 Cardiology Fountain Valley CALIFORNIA 12 Hour Days
547446 Rehab Seguin TEXAS 12 Hour Days
547603 ICU Issaquah WASHINGTON 12 Hour Days
546368 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547574 Med Surg Lewiston MAINE 12 Hour Days
546412 Med Surg Springfield VERMONT 12 Hour Days
547621 PICU Santa Clara CALIFORNIA 12 Hour Days
547620 PICU Santa Clara CALIFORNIA 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
546448 Nuclear Med Technician Santa Monica CALIFORNIA 12 Hour Days
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
547573 Med Surg Chillicothe OHIO 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
547659 PCU Omaha NEBRASKA 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
548194 OR Norman OKLAHOMA 12 Hour Days RN/Registered Nurse
548193 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
547656 Rehab Omaha NEBRASKA 12 Hour Days
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
547673 CVOR Falls Church VIRGINIA 12 Hour Days
547677 Med Surg Lowville NEW YORK 12 Hour Days
548082 PCU Torrance CALIFORNIA 12 Hour Days RN/Registered Nurse
547672 CVOR Falls Church VIRGINIA 12 Hour Days
546801 PICU Walnut Creek CALIFORNIA 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
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
547711 ER New York NEW YORK 12 Hour Days
546912 ER Goldendale WASHINGTON 12 Hour Days
546913 ER Des Moines IOWA 12 Hour Days
546985 Med Surg Tele Syracuse NEW YORK 12 Hour Days
547636 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
547570 Med Surg Per Diem/Local Contract Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548202 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
547000 Med Surg Dubuque IOWA 12 Hour Days
547002 Med Surg Dubuque IOWA 12 Hour Days
547013 Med Surg Tele Cleveland OHIO 12 Hour Days
547014 Med Surg Tele Cleveland OHIO 12 Hour Days
547015 Med Surg Tele Cleveland OHIO 12 Hour Days
547016 Med Surg Tele Cleveland OHIO 12 Hour Days
547021 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547022 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
547755 OR Albany NEW YORK 12 Hour Days
547754 Med Surg Queens NEW YORK 12 Hour Days
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
547729 PCU Mesa ARIZONA 12 Hour Days
547070 PICU Walnut Creek CALIFORNIA 12 Hour Days
547071 PICU Walnut Creek CALIFORNIA 12 Hour Days
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
547073 NICU Walnut Creek CALIFORNIA 12 Hour Days
547717 L&D Bronx NEW YORK 12 Hour Days
547759 Med Surg Sun City West ARIZONA 12 Hour Days
547126 ER Des Moines IOWA 12 Hour Days
547185 Med Surg Brooklyn NEW YORK 12 Hour Days
547186 Med Surg Brooklyn NEW YORK 12 Hour Days
548208 CVICU Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
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.5499 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 2800,100 in 1.7217 seconds