Listing all records

Displaying records 1501 through 1600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543355 Phlebotomist Farmington CONNECTICUT 8 Hour Days
543371 PACU Fresno CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
543374 PACU Fresno CALIFORNIA 12 Hour Days
543378 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
543380 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
543387 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
543406 PT Palm Springs CALIFORNIA 8 Hour Days
543407 PT Palm Springs CALIFORNIA 8 Hour Days
546929 Interventional Radiology Tech Detroit MICHIGAN 10 Hour Days
543439 L&D Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
545122 Med Surg Lancaster OHIO 12 Hour Nights
543446 Acute Care Kingsport TENNESSEE 12 Hour Days
543454 Home Health Fargo NORTH DAKOTA 8 Hour Day/Night Rotate
543455 OR Cape Girardeau MISSOURI Days
543461 Oncology Kingsport TENNESSEE 12 Hour Nights
543465 Telemetry Wailuku HAWAII 12 Hour Nights
543466 Med Surg Tele Wailuku HAWAII 12 Hour Nights
547756 Outpatient Clinic Cooperstown NEW YORK 8 Hour Days
543468 PT Athens GEORGIA 8 Hour Days
543475 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
543483 Med Surg Chillicothe OHIO 12 Hour Nights
543484 Certified Surgical Tech Abingdon VIRGINIA 8 Hour Day/Night Rotate
543486 Echo Waimea HAWAII 12 Hour Day/Night Rotate
543494 Med Surg Nashua NEW HAMPSHIRE 12 Hour Nights
543510 Ultrasound Tech Phoenix ARIZONA 12 Hour Day/Night Rotate
547059 ER Rome NEW YORK 12 Hour Nights
543519 MRI Tech Beachwood OHIO 8 Hour Nights
543527 Step Down Lansing MICHIGAN Nights
543535 Med Surg Spokane WASHINGTON 12 Hour Nights
543549 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543550 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543574 Case Manager Anchorage ALASKA 8 Hour Days
543575 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
543585 CT Tech Laconia NEW HAMPSHIRE 12 Hour Days
543592 PACU Nashua NEW HAMPSHIRE 10 Hour Days
543593 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
543598 Rehab Twin Falls IDAHO 12 Hour Nights
543599 Telemetry Twin Falls IDAHO 12 Hour Nights
543607 Telemetry Nampa IDAHO 12 Hour Nights
543613 Telemetry Boise IDAHO 12 Hour Nights
543617 Social Worker Twin Falls IDAHO 8 Hour Nights
543618 Social Worker Twin Falls IDAHO 8 Hour Nights
544375 Ultrasound Tech Silver Spring MARYLAND 10 Hour Nights
543630 Surgical Tech Stafford Springs CONNECTICUT 8 Hour Days
543633 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
543644 ER Walnut Creek CALIFORNIA 12 Hour Nights
543645 ER Walnut Creek CALIFORNIA 12 Hour Nights
543646 ER Walnut Creek CALIFORNIA 12 Hour Nights
543647 ER Walnut Creek CALIFORNIA 12 Hour Nights
543648 ER Walnut Creek CALIFORNIA 12 Hour Nights
543649 ER Walnut Creek CALIFORNIA 12 Hour Nights
543650 ER Walnut Creek CALIFORNIA 12 Hour Nights
543651 ER Walnut Creek CALIFORNIA 12 Hour Nights
543668 ICU Bristol TENNESSEE 12 Hour Days
543669 ICU Bristol TENNESSEE 12 Hour Nights
543679 RN House Supervisor Honolulu HAWAII 12 Hour Day/Night Rotate
543693 Med Surg Tele Laconia NEW HAMPSHIRE 12 Hour Day/Night Rotate
543695 L&D WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
543696 Oncology Bristol TENNESSEE 12 Hour Days
543703 RAD Tech Commerce Twp MICHIGAN 8 Hour Nights
543709 Laboratory Orange CALIFORNIA 8 Hour Days
543725 OR Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
543729 OR Pella IOWA 10 Hour Varied
543730 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights
543740 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Nights
543747 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
546032 PT San Jose CALIFORNIA 10 Hour Days
543750 CLS Reno NEVADA 12 Hour Day/Night Rotate
543751 OR Victorville CALIFORNIA 8 Hour Days
543752 PACU Victorville CALIFORNIA 8 Hour Days
543753 CLS Victorville CALIFORNIA 8 Hour Days
543755 NICU Lynwood CALIFORNIA 12 Hour Nights
543757 CT Tech Lynwood CALIFORNIA 12 Hour Days
543758 CT Tech Lynwood CALIFORNIA 12 Hour Days
543759 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543760 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
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
543777 RAD Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543778 RAD Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543779 OR Woonsocket RHODE ISLAND 8 Hour Days
543780 OR Woonsocket RHODE ISLAND 8 Hour Days
543781 OR Redding CALIFORNIA 8 Hour Days
543782 CT Tech Woonsocket RHODE ISLAND 8 Hour Nights
543783 RAD Tech Redding CALIFORNIA 8 Hour Days
543784 GI Lab Woonsocket RHODE ISLAND 8 Hour Days
543785 Scrub Tech Redding CALIFORNIA 12 Hour Day/Night Rotate
543786 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Days
543787 PICU Detroit MICHIGAN 12 Hour Days
543790 RAD Tech Oceanside CALIFORNIA 8 Hour Days
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
543801 CT Tech Long Prairie MINNESOTA 12 Hour Days
543802 Case Manager Attleboro MASSACHUSETTS 8 Hour Days
543807 PACU Albuquerque NEW MEXICO 12 Hour Nights
543808 Case Manager Anchorage ALASKA 8 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.5783 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.title desc limit 1500,100 in 1.6257 seconds