Listing all records

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

ID Job Specialty City State Shift Title
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
545251 Clinic Sitka ALASKA Varied
545252 GI Lab Mason City IOWA 8 Hour Days
545257 CT Tech Roseburg OREGON 10 Hour Nights
545262 PCU Omaha NEBRASKA 12 Hour Nights
545264 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
545273 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
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
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
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
545305 Cath Lab Honolulu HAWAII Nights
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
545328 CNA Salem OREGON 12 Hour Nights
545331 PT Sumter SOUTH CAROLINA Days
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
545336 Ultrasound Tech Abingdon VIRGINIA 12 Hour Days
545338 Med Surg Tele Glens Falls NEW YORK 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
545389 Cardiology Coos Bay OREGON 8 Hour Days
545390 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
545392 CT Tech Anchorage ALASKA 12 Hour Days
545393 Surgical Tech Anchorage ALASKA 10 Hour Nights
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545411 RAD Tech Rockville MARYLAND 8 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
545414 OT Rehab San Angelo TEXAS 8 Hour Day/Night Rotate
545420 PT REDWOOD CITY CALIFORNIA 8 Hour Days
545421 RN Columbus OHIO 12 Hour Nights
545422 ER Springfield MASSACHUSETTS 8 Hour Nights
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
545427 NICU Mishawaka INDIANA 12 Hour Nights
545440 OT Rehab thermopolis WYOMING Days
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
545453 ER Lynwood CALIFORNIA 12 Hour Nights
545463 Vascular Ultrasound Tech Hettinger NORTH DAKOTA 8 Hour Days
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
545470 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
545486 RAD Tech Florence SOUTH CAROLINA 8 Hour Days
545489 MRI Tech Farmington CONNECTICUT 8 Hour Evenings
545490 CT Tech Farmington CONNECTICUT 8 Hour Nights
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
545502 Telemetry Boise IDAHO 12 Hour Nights
545503 Telemetry Boise IDAHO 12 Hour Nights
545514 L&D Arcata CALIFORNIA 12 Hour Nights
545515 L&D Arcata CALIFORNIA 12 Hour Nights
545524 Postpartum Hilo HAWAII 12 Hour Day/Night Rotate
545526 Med Surg Memphis TENNESSEE 12 Hour Days
545532 CT Tech Montrose COLORADO 12 Hour Varied
545533 CT Tech Montrose COLORADO 12 Hour Varied
545539 Interventional Radiology Tech Columbia SOUTH CAROLINA 8 Hour Days
545541 RAD Tech Columbus OHIO 8 Hour Nights
545542 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
545552 PT Wilton CONNECTICUT Varied
545553 Outpatient Clinic Greencastle INDIANA 10 Hour Days
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
545564 RAD Tech Peoria ILLINOIS 8 Hour Days
545565 Therapy Rehab Springfield MISSOURI 8 Hour Days
545566 Therapy Rehab Springfield MISSOURI 8 Hour Days
545569 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545570 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545571 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545572 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545579 ER Willoughby OHIO 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.5106 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 1900,100 in 1.6115 seconds