Listing all records

Displaying records 2501 through 2600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547188 Med Surg Brooklyn NEW YORK 12 Hour Days
543891 Psych National City CALIFORNIA 12 Hour Days
543933 Med Surg Bronx NEW YORK 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
547620 PICU Santa Clara CALIFORNIA 12 Hour Days
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
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
547636 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
547311 Telemetry Twin Falls IDAHO 12 Hour Days
544397 Med Surg Peoria ILLINOIS 12 Hour Days RN/Registered Nurse
544437 ER IOWA CITY IOWA 12 Hour Days
547290 ER Norton VIRGINIA 12 Hour Days
544526 Step Down Wailuku HAWAII 12 Hour Days
544527 Med Surg Tele Wailuku HAWAII 12 Hour Days
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
547340 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547382 L&D Seattle WASHINGTON 12 Hour Days
547377 PCU Albuquerque NEW MEXICO 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
547339 Patient Care Coordinator Hillsboro OREGON 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
547656 Rehab Omaha NEBRASKA 12 Hour Days
547650 Telemetry Hannibal MISSOURI 12 Hour Days
544890 ER Concord CALIFORNIA 12 Hour Days
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
547409 Postpartum ODESSA TEXAS 12 Hour Days
544944 PCU Johnson City TENNESSEE 12 Hour Days
544955 Telemetry Twin Falls IDAHO 12 Hour Days
547403 Med Surg Tele Kansas City MISSOURI 12 Hour Days
545084 RAD Tech San Diego CALIFORNIA 12 Hour Days
545098 Long Term Care Portland OREGON 12 Hour Days
547461 Radiology Tech Auburn NEW YORK 12 Hour Days
545169 Acute Care Bronx NEW YORK 12 Hour Days
547659 PCU Omaha NEBRASKA 12 Hour Days
545173 Med Surg Brooklyn NEW YORK 12 Hour Days
545179 Med Surg Brooklyn NEW YORK 12 Hour Days
547789 Med Surg Tele Saratoga Springs 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
547672 CVOR Falls Church VIRGINIA 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
547673 CVOR Falls Church VIRGINIA 12 Hour Days
547674 CVOR Falls Church VIRGINIA 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
547804 EEG Tech Hilo HAWAII 12 Hour Days
547717 L&D Bronx NEW YORK 12 Hour Days
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
547570 Med Surg Per Diem/Local Contract Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
546331 ER Centerville IOWA 12 Hour Days
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
546354 Cardiology Fountain Valley CALIFORNIA 12 Hour Days
546868 ER MERCED CALIFORNIA 12 Hour Days
546368 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
546827 CVOR Parkersburg WEST VIRGINIA 12 Hour Days
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
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
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.5258 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 2500,100 in 1.5772 seconds