Listing all records

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

ID Job Specialty City State Shift Title
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
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
543820 Oncology Bristol TENNESSEE 12 Hour Nights
543821 Med Surg Tele Bristol TENNESSEE 12 Hour Days
543822 Certified Surgical Tech York MAINE 8 Hour Days
543824 ER Lansing MICHIGAN 12 Hour Nights
543831 Cath Lab Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
543834 Mammo Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
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
543872 NICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543881 Cath Lab Philadelphia PENNSYLVANIA 10 Hour Days
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
543884 ICU Philadelphia PENNSYLVANIA 12 Hour Days
543885 OR National City CALIFORNIA 8 Hour Days
543886 RAD Tech National City CALIFORNIA 12 Hour Nights
543887 CT Tech National City CALIFORNIA 12 Hour Nights
543888 RAD Tech National City CALIFORNIA 12 Hour Days
543889 Cath Lab National City CALIFORNIA 8 Hour Days
543890 Psych National City CALIFORNIA 12 Hour Nights
543891 Psych National City CALIFORNIA 12 Hour Days
543897 PT Naples FLORIDA Varied
543900 CT Tech Culbertson MONTANA Days
543901 Med Surg Tele The Dalles OREGON Days
543903 Adult Care Rockaway Park NEW YORK 8 Hour Days
543904 PT Crescent City CALIFORNIA 8 Hour Days
543911 COTA Hanford CALIFORNIA Days
543913 Echo Technologist Lewiston MAINE 8 Hour Days
543933 Med Surg Bronx NEW YORK 12 Hour Days
543935 Acute Care Brooklyn NEW YORK 8 Hour Days
543938 Med Surg Kingsport TENNESSEE 12 Hour Days
543944 RAD Tech Walnut Creek CALIFORNIA 10 Hour Days
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
543952 Cath Lab Louisville KENTUCKY 8 Hour Days
543955 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543957 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543958 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543959 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
543974 ER Newark NEW JERSEY 12 Hour Nights
543977 Sterile Processing Tech Lamar COLORADO Days
543978 Scrub Tech Lamar COLORADO 8 Hour Day/Night Rotate
543990 CT Tech Boise IDAHO 10 Hour Evenings
543991 OR Omaha NEBRASKA 10 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
544012 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544016 Social Worker Sitka ALASKA Varied
544031 Telemetry Portland OREGON 12 Hour Nights
544034 PCU Spokane WASHINGTON 12 Hour Nights
544036 Step Down Lansing MICHIGAN 12 Hour Nights
544037 Step Down Lansing MICHIGAN 12 Hour Nights
544043 Med Surg Tele Beachwood OHIO 12 Hour Days
544049 Med Surg Palm Springs CALIFORNIA 12 Hour Nights
544050 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544051 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544052 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
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.2731 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.id asc limit 1500,100 in 1.1406 seconds