Listing all records

Displaying records 1901 through 2000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545079 ER Pueblo COLORADO 12 Hour Day/Night Rotate
545080 ER Pueblo COLORADO 12 Hour Nights
545082 Vascular Ultrasound Tech Artesia NEW MEXICO Days
545083 Cath Lab Corvallis OREGON 8 Hour Day/Night Rotate
545084 RAD Tech San Diego CALIFORNIA 12 Hour Days
545091 Med Surg Oregon City OREGON 12 Hour Nights
545092 ER Portland OREGON 12 Hour Nights
545096 ER Burbank CALIFORNIA 12 Hour Nights
545098 Long Term Care Portland OREGON 12 Hour Days
545103 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545104 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545111 PT Salem OREGON Days
545112 PT Salem OREGON Days
545120 Case Manager Anchorage ALASKA 8 Hour Days
546423 PT Hayward CALIFORNIA 8 Hour Days
545125 RAD Tech Gig Harbor WASHINGTON 8 Hour Day/Night Rotate
545128 Med Surg Albuquerque NEW MEXICO 12 Hour Nights
545133 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
545136 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
545140 PCU Coos Bay OREGON 12 Hour Nights
545149 Med Surg Hettinger NORTH DAKOTA 12 Hour Day/Night Rotate
545154 RAD Tech Lebanon NEW HAMPSHIRE 12 Hour Nights
545165 Telemetry Cleveland OHIO 12 Hour Nights
545752 Med Surg Gainesville FLORIDA 12 Hour Nights
545170 Infusion New York NEW YORK 8 Hour Days
545171 Med Surg Brooklyn NEW YORK 8 Hour Evenings
545173 Med Surg Brooklyn NEW YORK 12 Hour Days
545178 Med Surg Brooklyn NEW YORK 8 Hour Evenings
545749 Med Surg Gainesville FLORIDA 12 Hour Days
545185 CVOR Houston TEXAS 12 Hour Day/Night Rotate
545188 Certified Surgical Tech Paris ILLINOIS 8 Hour Varied
545190 Pharmacy Tech Mishawaka INDIANA 8 Hour Nights
545191 Surgical Tech New Albany OHIO 12 Hour Days
545192 Acute Care Bronx NEW YORK 12 Hour Nights
545196 Social Worker Concord CALIFORNIA 8 Hour Days
545205 Med Surg Des Moines IOWA 12 Hour Nights
545206 Orthopedics Des Moines IOWA 12 Hour Nights
545207 ER Des Moines IOWA 12 Hour Nights
545213 RAD Tech New Lenox ILLINOIS 10 Hour Days
545217 CT Tech York MAINE Days
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
545227 Telemetry Cleveland OHIO 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
545229 Telemetry Cleveland OHIO 12 Hour Nights
545230 Telemetry Cleveland OHIO 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
545232 Step Down Cleveland OHIO 12 Hour Nights
545233 Step Down Cleveland OHIO 12 Hour Nights
545237 Surgical Tech CVOR Reno NEVADA 10 Hour Days
545238 ER Des Moines IOWA 12 Hour Nights
545239 ER Columbus OHIO Nights
545240 ER Grove City OHIO 12 Hour Nights
545242 ICU Scottsbluff NEBRASKA 12 Hour Varied
545243 Scrub Tech The Dalles OREGON 12 Hour Day/Night Rotate
545244 Echo Technologist Tulsa OKLAHOMA 12 Hour Day/Night Rotate
546704 CT Tech Des Moines IOWA 10 Hour Days
545251 Clinic Sitka ALASKA Varied
545257 CT Tech Roseburg OREGON 10 Hour Nights
545262 PCU Omaha NEBRASKA 12 Hour Nights
545264 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
545274 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
545275 First Assist San Luis Obispo CALIFORNIA 8 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
545278 First Assist Templeton CALIFORNIA 10 Hour Days
545279 Cardiovascular Dubuque IOWA 12 Hour Days
545280 LPN/LVN SANTA MARIA CALIFORNIA 8 Hour Days
545284 OR El Paso TEXAS 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
545754 Med Surg Gainesville FLORIDA 12 Hour Days
545291 PCU Rock Hill SOUTH CAROLINA 12 Hour Nights
545292 CVICU Memphis TENNESSEE 12 Hour Nights
545299 CVICU Little Rock ARKANSAS 12 Hour Nights
545300 Med Surg Helena MONTANA 12 Hour Nights
545302 RAD Tech Farmington CONNECTICUT 8 Hour Evenings
545303 PACU Farmington CONNECTICUT 10 Hour Days
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 12 Hour Nights
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
545311 ICU Colville WASHINGTON 12 Hour Nights
545313 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
545314 Interventional Radiology SANTA ROSA CALIFORNIA Days
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
545316 SLP Eureka CALIFORNIA 8 Hour Days
545317 PT SANTA ROSA CALIFORNIA 8 Hour Days
545755 Case Manager Gainesville FLORIDA 8 Hour Days
545331 PT Sumter SOUTH CAROLINA Days
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
545338 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
545610 Med Surg HOBBS NEW MEXICO 12 Hour Nights
545339 APRN Plymouth WISCONSIN Days
545342 Home Health Rockford ILLINOIS 12 Hour Day/Night Rotate
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
545370 Step Down Cincinnati OHIO Nights
545371 Step Down Cincinnati OHIO Days
545372 Step Down Cincinnati OHIO Nights
545380 L&D Lewistown MONTANA Nights
546643 Cath Lab Cleveland OHIO 10 Hour Days
545389 Cardiology Coos Bay OREGON 8 Hour Days
545390 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
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.4424 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 asc limit 1900,100 in 1.3597 seconds