Listing all records

Displaying records 1 through 100 out of a total 3,709 records. Next

ID Job Specialty City State Shift Title
541840 PT SANTA MARIA CALIFORNIA 8 Hour Days
419839 Med Surg Bristol TENNESSEE 12 Hour Nights
444999 PACU Bangor MAINE 12 Hour Days
447084 CT Tech La Palma CALIFORNIA 12 Hour Day/Night Rotate
460916 PT Lawton OKLAHOMA 8 Hour Days
541810 Med Surg Oneonta NEW YORK 12 Hour Nights
464113 SLP Ballinger TEXAS Days
465120 Long Term Care Conrad MONTANA 8 Hour Evenings
470815 PT Los Gatos CALIFORNIA Varied
472544 PT E Lamberton MINNESOTA Days
472729 PT Holyoke MASSACHUSETTS Days
474328 PT North Manchester INDIANA Days
475928 PT Lewiston IDAHO Days
476614 PT Crownsville MARYLAND Days
478398 PT Centerville IOWA Days
479108 SLP Spearfish SOUTH DAKOTA Days
479983 PT YUBA CITY CALIFORNIA Days
480893 PT Toledo IOWA Days
484007 CT Tech Wolf Point MONTANA 12 Hour Day/Night Rotate
484788 PTA Merced CALIFORNIA Days
487151 Long Term Care Conrad MONTANA 12 Hour Day/Night Rotate
490405 Long Term Care Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
491571 Therapy Rehab E Lamberton MINNESOTA Days
492265 Long Term Care Scottsbluff NEBRASKA Nights
492900 PT Lancaster MASSACHUSETTS Days
494609 PCU Casa Grande ARIZONA 12 Hour Nights
495103 SLP South Bend INDIANA Days
496231 COTA Oakhurst CALIFORNIA Days
519354 Therapy Rehab Baltimore MARYLAND Days
517854 CT Tech Akron OHIO 10 Hour Days
517691 SLP Vernon CONNECTICUT Days
497771 PT Sonora CALIFORNIA Days
497775 PT San Andreas CALIFORNIA Days
499331 SLP Little Egg Harbor Township NEW JERSEY Days
501006 PTA Freehold NEW JERSEY Days
505886 MRI Tech Federal Way WASHINGTON 10 Hour Days
543820 Oncology Bristol TENNESSEE 12 Hour Nights
517913 Med Surg Tele Maui Wailuku HAWAII 12 Hour Nights
518534 COTA NEWMAN CALIFORNIA Days
518254 PT Cleburne TEXAS Varied
518165 Endoscopy IOWA CITY IOWA Days
517902 Med Surg Tele Wailuku HAWAII 8 Hour Nights
517887 CRNA Alturas CALIFORNIA 12 Hour Day/Night Rotate
541964 Cath Lab Whittier CALIFORNIA 8 Hour Days
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
541949 Med Surg Boise IDAHO 12 Hour Nights
541886 Rehab Chesterfield MONTANA 12 Hour Days
517474 Ortho Tech Oceanside CALIFORNIA 8 Hour Days
519146 Med Surg Kula HAWAII 8 Hour Days
545014 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Days
541845 NICU Walnut Creek CALIFORNIA 12 Hour Nights
502855 Paramedic Cleveland OHIO Varied
541860 PT Lovington NEW MEXICO 8 Hour Days
503607 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
541809 Med Surg Oneonta NEW YORK 12 Hour Nights
504432 PT Honolulu HAWAII Days
505339 PTA San Jose CALIFORNIA Days
505340 PT San Jose CALIFORNIA Days
505341 OT Rehab San Jose CALIFORNIA Days
505342 OT Rehab San Jose CALIFORNIA Days
506863 Surgical Tech Durham NORTH CAROLINA 10 Hour Days
507007 Administration Scobey MONTANA Varied
507014 Therapy Rehab Ballinger TEXAS Days
507079 PT Rockville MARYLAND Days
517904 Med Surg Tele Maui Wailuku HAWAII 12 Hour Nights
507931 PT Martinez CALIFORNIA 8 Hour Days
542786 Step Down Kingsport TENNESSEE 12 Hour Nights
509587 PT Freehold NEW JERSEY Days
509595 Anesthesia Tech Everett WASHINGTON 12 Hour Varied
542785 Case Manager Glens Falls NEW YORK 8 Hour Days
511666 PT Rockville MARYLAND Days
511950 Med Surg Manchester CONNECTICUT 12 Hour Nights
512505 MRI Tech Lawton OKLAHOMA 8 Hour Days
512644 PT SUNNYVALE CALIFORNIA 8 Hour Days
512894 MLT Hickory NORTH CAROLINA 12 Hour Days
513169 Phlebotomist Hickory NORTH CAROLINA 12 Hour Nights
513409 ER Manchester CONNECTICUT 12 Hour Nights
513688 Certified Surgical Tech Hickory NORTH CAROLINA 8 Hour Days
513720 PT Bessemer ALABAMA Varied
513832 Med Surg Tele Wailuku HAWAII 12 Hour Days
514085 Therapy Rehab Sparks NEVADA Days
514124 ER Manchester CONNECTICUT 12 Hour Nights
514692 SLP Spanaway WASHINGTON Days
514696 Therapy Rehab Spanaway WASHINGTON Days
515218 Sterile Processing Technician Hickory NORTH CAROLINA 12 Hour Nights
515247 PT Hanford CALIFORNIA Days
515505 PT Scranton SOUTH CAROLINA Days
515845 MLT Louisville KENTUCKY Nights
515962 Pediatrics Nome ALASKA 12 Hour Day/Night Rotate
516484 PT Hot Springs VIRGINIA Days
516543 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
516544 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
541958 CVICU Spokane WASHINGTON 12 Hour Nights
519045 Med Surg Kula HAWAII 8 Hour Nights
541891 Telemetry Farmington CONNECTICUT 12 Hour Nights
516937 SLP Roseburg OREGON Days
517267 PT Kapaau HAWAII Days
517269 PT Kapaau HAWAII Days
519153 CVICU Little Rock ARKANSAS 12 Hour Nights
542655 Long Term Care Hilo HAWAII 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.0659 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 0,100 in 1.0395 seconds