Listing all records

Displaying records 2901 through 3000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546368 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547719 Med Surg Queens NEW YORK 12 Hour Days
546412 Med Surg Springfield VERMONT 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
548353 Behavioral Health Modesto 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
547755 OR Albany NEW YORK 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
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
548358 Med Surg Tele Cooperstown NEW YORK 12 Hour Days RN/Registered Nurse
548356 ER - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
547811 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Days
547818 Long Term Care Lowville NEW YORK 12 Hour Days
548217 Telemetry New York NEW YORK 12 Hour Days RN/Registered Nurse
548220 CNA Camarillo CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
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
547854 Med Surg Valdosta GEORGIA 12 Hour Days
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
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
547717 L&D Bronx NEW YORK 12 Hour Days
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
548365 Med Surg BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
547060 L&D Pittsfield MASSACHUSETTS 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
547865 Certified Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
548249 Med Surg Pontiac MICHIGAN 12 Hour Days RN/Registered Nurse
547126 ER Des Moines IOWA 12 Hour Days
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 Hour Days RN/Registered Nurse
547185 Med Surg Brooklyn NEW YORK 12 Hour Days
547186 Med Surg Brooklyn NEW YORK 12 Hour Days
548369 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
547188 Med Surg Brooklyn NEW YORK 12 Hour Days
547226 L&D Brooklyn NEW YORK 12 Hour Days
547235 NICU Brooklyn NEW YORK 12 Hour Days
547931 Telemetry Brownsville TEXAS 12 Hour Days
547290 ER Norton VIRGINIA 12 Hour Days
547311 Telemetry Twin Falls IDAHO 12 Hour Days
547939 Radiation Therapy Twin Falls IDAHO 12 Hour Days
547339 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547340 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547374 PCU Albuquerque NEW MEXICO 12 Hour Days
547377 PCU Albuquerque NEW MEXICO 12 Hour Days
547381 L&D Seattle WASHINGTON 12 Hour Days
547382 L&D Seattle WASHINGTON 12 Hour Days
547403 Med Surg Tele Kansas City MISSOURI 12 Hour Days
547409 Postpartum ODESSA TEXAS 12 Hour Days
547920 ER Des Moines IOWA 12 Hour Days
547919 ER Des Moines IOWA 12 Hour Days
547446 Rehab Seguin TEXAS 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.5414 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 2900,100 in 1.2283 seconds