Listing all records

Displaying records 1601 through 1700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
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
543903 Adult Care Rockaway Park NEW YORK 8 Hour Days
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
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
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
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
544060 ICU Pontiac MICHIGAN 12 Hour Nights
544067 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
544530 Med Surg Waterloo IOWA 12 Hour Nights
544091 Med Surg Norman OKLAHOMA 12 Hour Nights
546395 CT Tech Wichita Falls TEXAS 8 Hour Evenings
544096 Cath Lab Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
544116 Telemetry Cleveland OHIO 12 Hour Nights
544121 CT Tech Avalon CALIFORNIA 8 Hour Varied
544124 Cath Lab Fort Smith ARIZONA 8 Hour Day/Night Rotate
544142 Cath Lab Cleveland OHIO 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
544144 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544149 Long Term Care Moscow IDAHO 12 Hour Nights
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
544153 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
544158 PACU Cleveland OHIO 12 Hour Nights
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
544897 CNA Breckenridge MINNESOTA 12 Hour Day/Night Rotate
544167 PT Garden City KANSAS 12 Hour Day/Night Rotate
544168 COTA Madera CALIFORNIA Days
544192 PT Wrangell ALASKA Varied
544196 Interventional Radiology Tech Arlington VIRGINIA 10 Hour Days
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
544201 OR Germantown MARYLAND 8 Hour Evenings
544202 RAD Tech Dubuque IOWA 8 Hour Days
544204 Med Surg Sioux City IOWA 12 Hour Days
544205 Ultrasound Tech Silver Spring MARYLAND 10 Hour Evenings
544208 Med Surg Grove City OHIO 12 Hour Nights
544209 Med Surg Grove City OHIO 12 Hour Nights
547027 Long Term Care Claremont NEW HAMPSHIRE 12 Hour Nights
546148 Med Surg Spokane WASHINGTON 8 Hour Evenings
544215 Med Surg Tele Pueblo COLORADO 12 Hour Nights
544217 Med Surg Pella IOWA 12 Hour Nights
544218 CVOR Newark NEW JERSEY 12 Hour Days
544219 Oncology Newark NEW JERSEY 12 Hour Days
544220 MICU Newark NEW JERSEY 8 Hour Nights
544221 OR Newark NEW JERSEY 12 Hour Days
544222 ICU Passaic NEW JERSEY 12 Hour Nights
544224 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
544226 MLT Denville NEW JERSEY 12 Hour Day/Night Rotate
544227 Nuclear Med Technician Denville NEW JERSEY 8 Hour Days
544228 CT Tech Denville NEW JERSEY 12 Hour Day/Night Rotate
544229 Dialysis Denville NEW JERSEY 12 Hour Day/Night Rotate
544230 ER Denville NEW JERSEY 12 Hour Nights
544231 ER Denville NEW JERSEY 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.71 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 1600,100 in 1.8621 seconds