Listing all records

Displaying records 2401 through 2500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543446 Acute Care Kingsport TENNESSEE 12 Hour Days
543872 NICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
547557 CT Tech Akron OHIO 12 Hour Days
543549 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543550 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543585 CT Tech Laconia NEW HAMPSHIRE 12 Hour Days
546858 CVOR Annapolis MARYLAND 12 Hour Days
543668 ICU Bristol TENNESSEE 12 Hour Days
543696 Oncology Bristol TENNESSEE 12 Hour Days
546868 ER MERCED CALIFORNIA 12 Hour Days
543757 CT Tech Lynwood CALIFORNIA 12 Hour Days
543758 CT Tech Lynwood CALIFORNIA 12 Hour Days
543769 CLS Lynwood CALIFORNIA 12 Hour Days
543770 CLS Lynwood CALIFORNIA 12 Hour Days
543773 RAD Tech San Diego CALIFORNIA 12 Hour Days
543774 RAD Tech San Diego CALIFORNIA 12 Hour Days
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
543786 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Days
543787 PICU Detroit MICHIGAN 12 Hour Days
543801 CT Tech Long Prairie MINNESOTA 12 Hour Days
543821 Med Surg Tele Bristol TENNESSEE 12 Hour Days
546913 ER Des Moines IOWA 12 Hour Days
543861 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543862 PICU Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543884 ICU Philadelphia PENNSYLVANIA 12 Hour Days
546912 ER Goldendale WASHINGTON 12 Hour Days
543888 RAD Tech National City CALIFORNIA 12 Hour Days
543891 Psych National City CALIFORNIA 12 Hour Days
543933 Med Surg Bronx NEW YORK 12 Hour Days
547382 L&D Seattle WASHINGTON 12 Hour Days
544043 Med Surg Tele Beachwood OHIO 12 Hour Days
544061 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
544204 Med Surg Sioux City IOWA 12 Hour Days
544218 CVOR Newark NEW JERSEY 12 Hour Days
544219 Oncology Newark NEW JERSEY 12 Hour Days
547573 Med Surg Chillicothe OHIO 12 Hour Days
544221 OR Newark NEW JERSEY 12 Hour Days
544223 Surgical Tech Passaic NEW JERSEY 12 Hour Days
544231 ER Denville NEW JERSEY 12 Hour Days
544234 Surgical Tech Denville NEW JERSEY 12 Hour Days
544240 RAD Tech Reno NEVADA 12 Hour Days
544241 RAD Tech Reno NEVADA 12 Hour Days
544263 Surgical Tech Westerville OHIO 12 Hour Days
544267 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544268 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544311 Cath Lab Charleston WEST VIRGINIA 12 Hour Days
544345 Surgical Tech Ketchum IDAHO 12 Hour Days
544768 OR ODESSA TEXAS 12 Hour Days
544397 Med Surg Peoria ILLINOIS 12 Hour Days RN/Registered Nurse
547575 ICU Lewiston MAINE 12 Hour Days
546985 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544437 ER IOWA CITY IOWA 12 Hour Days
544526 Step Down Wailuku HAWAII 12 Hour Days
544527 Med Surg Tele Wailuku HAWAII 12 Hour Days
547002 Med Surg Dubuque IOWA 12 Hour Days
547022 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
547021 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
544644 OR Silver Spring MARYLAND 12 Hour Days
544645 OR Silver Spring MARYLAND 12 Hour Days
544646 OR Silver Spring MARYLAND 12 Hour Days
544647 OR Silver Spring MARYLAND 12 Hour Days
547016 Med Surg Tele Cleveland OHIO 12 Hour Days
547595 First Assist Canton OHIO 12 Hour Days
544706 NICU Des Moines IOWA 12 Hour Days
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
544742 Med Surg Spokane WASHINGTON 12 Hour Days
544743 Med Surg Spokane WASHINGTON 12 Hour Days
547000 Med Surg Dubuque IOWA 12 Hour Days
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
544890 ER Concord CALIFORNIA 12 Hour Days
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
544944 PCU Johnson City TENNESSEE 12 Hour Days
544955 Telemetry Twin Falls IDAHO 12 Hour Days
545084 RAD Tech San Diego CALIFORNIA 12 Hour Days
545098 Long Term Care Portland OREGON 12 Hour Days
545169 Acute Care Bronx NEW YORK 12 Hour Days
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
547446 Rehab Seguin TEXAS 12 Hour Days
545173 Med Surg Brooklyn NEW YORK 12 Hour Days
545179 Med Surg Brooklyn NEW YORK 12 Hour Days
545191 Surgical Tech New Albany OHIO 12 Hour Days
545279 Cardiovascular Dubuque IOWA 12 Hour Days
545284 OR El Paso TEXAS 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
545392 CT Tech Anchorage ALASKA 12 Hour Days
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
545423 Med Surg Waterbury CONNECTICUT 12 Hour Days
545424 Med Surg Waterbury CONNECTICUT 12 Hour Days
545425 L&D Mishawaka INDIANA 12 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
547603 ICU Issaquah WASHINGTON 12 Hour Days
545498 Respiratory Therapist Des Moines IOWA 12 Hour Days
545499 Respiratory Therapist Des Moines IOWA 12 Hour Days
545500 Med Surg Tele Des Moines IOWA 12 Hour Days
545501 Med Surg Tele Des Moines IOWA 12 Hour Days
545526 Med Surg Memphis TENNESSEE 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.6721 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 2400,100 in 1.5828 seconds