Listing all records

Displaying records 201 through 300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545280 LPN/LVN SANTA MARIA CALIFORNIA 8 Hour Days
545316 SLP Eureka CALIFORNIA 8 Hour Days
542601 Ambulatory Cleveland OHIO 8 Hour Days
545313 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
544103 Phlebotomist Farmington CONNECTICUT 8 Hour Days
542734 PT Hayward CALIFORNIA 8 Hour Days
546423 PT Hayward CALIFORNIA 8 Hour Days
543958 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
542856 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
545389 Cardiology Coos Bay OREGON 8 Hour Days
540446 Case Manager Napa CALIFORNIA 8 Hour Days
539873 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
544227 Nuclear Med Technician Denville NEW JERSEY 8 Hour Days
547135 PT Lufkin TEXAS 8 Hour Days
525066 PT Mason City IOWA 8 Hour Days
542858 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
539930 Surgical Tech Louisville KENTUCKY 8 Hour Days
543480 Therapy Rehab Athens GEORGIA 8 Hour Days
543006 CVOR Oceanside CALIFORNIA 8 Hour Days
540024 Phlebotomist Farmington CONNECTICUT 8 Hour Days
535231 Cath Lab Sioux City IOWA 8 Hour Days
545565 Therapy Rehab Springfield MISSOURI 8 Hour Days
543087 PTA Ukiah CALIFORNIA 8 Hour Days
543575 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
545564 RAD Tech Peoria ILLINOIS 8 Hour Days
545591 RAD Tech Richmond VIRGINIA 8 Hour Days
539294 Radiology Queens NEW YORK 8 Hour Days
525673 Cardiology Louisville KENTUCKY 8 Hour Days
540018 Surgical Tech Farmington CONNECTICUT 8 Hour Days
545566 Therapy Rehab Springfield MISSOURI 8 Hour Days
543183 Surgical Tech Athens GEORGIA 8 Hour Days
525843 PT Elizabeth WEST VIRGINIA 8 Hour Days PT/Physical Therapist
525929 Nurse Practicioner Brooklyn NEW YORK 8 Hour Days
534167 Surgical Tech Centerville IOWA 8 Hour Days
543193 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
525987 Supervisor New York NEW YORK 8 Hour Days
525988 Supervisor New York NEW YORK 8 Hour Days
526053 RAD Tech Clearwater FLORIDA 8 Hour Days RN/Registered Nurse
526054 RAD Tech Cleveland OHIO 8 Hour Days Radiology Techs/Technologists
545420 PT REDWOOD CITY CALIFORNIA 8 Hour Days
543285 SLP South San Francisco CALIFORNIA 8 Hour Days
545599 RAD Tech Richmond VIRGINIA 8 Hour Days
539712 Home Health Mason City IOWA 8 Hour Days
543406 PT Palm Springs CALIFORNIA 8 Hour Days
527553 Cath Lab Louisville KENTUCKY 8 Hour Days
540033 Med Surg Tele Concord CALIFORNIA 8 Hour Days
543184 Surgical Tech Athens GEORGIA 8 Hour Days
543089 OR San Dimas CALIFORNIA 8 Hour Days
533010 Cath Lab Mason City IOWA 8 Hour Days
545170 Infusion New York NEW YORK 8 Hour Days
542084 RAD Tech Farmington CONNECTICUT 8 Hour Days
542085 PT Oneonta NEW YORK 8 Hour Days
537758 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
542596 Interventional Radiology Tech Daytona Beach FLORIDA 8 Hour Days
543709 Laboratory Orange CALIFORNIA 8 Hour Days
533910 PT Hayward CALIFORNIA 8 Hour Days
535674 Cath Lab Passaic NEW JERSEY 8 Hour Days
534528 Social Worker Johnston PENNSYLVANIA 8 Hour Days
527053 CVOR Houston TEXAS 8 Hour Days RN/Registered Nurse
544905 Mammo Tech Port Jefferson NEW YORK 8 Hour Days
533177 CT Tech Roseburg OREGON 8 Hour Days
544482 OR Germantown MARYLAND 8 Hour Days
544378 Ultrasound Tech Silver Spring MARYLAND 8 Hour Days
536440 Infusion Oncology Maywood ILLINOIS 8 Hour Days
540351 Cath Lab Waterloo IOWA 8 Hour Days
540083 RAD Tech Farmington CONNECTICUT 8 Hour Days
544553 Cath Lab Passaic NEW JERSEY 8 Hour Days
534553 Surgical Tech Louisville KENTUCKY 8 Hour Days
535640 PT NORTHRIDGE CALIFORNIA 8 Hour Days
545463 Vascular Ultrasound Tech Hettinger NORTH DAKOTA 8 Hour Days
544598 MLT Des Moines IOWA 8 Hour Days
527593 PT Pinehurst NORTH CAROLINA 8 Hour Days
537278 PT Sonoma CALIFORNIA 8 Hour Days
540501 Supervisor New York NEW YORK 8 Hour Days
527789 RAD Tech Oceanside CALIFORNIA 8 Hour Days
536150 Lab Tech King Renton WASHINGTON 8 Hour Days
544793 Cath Lab Bartlett TENNESSEE 8 Hour Days
538355 Cardiovascular Technologist Chino CALIFORNIA 8 Hour Days
540892 MLT Farmington CONNECTICUT 8 Hour Days
540599 Interventional Radiology Tech Pontiac MICHIGAN 8 Hour Days
543630 Surgical Tech Stafford Springs CONNECTICUT 8 Hour Days
544504 PT Everett WASHINGTON 8 Hour Days
536728 Interventional Radiology Germantown MARYLAND 8 Hour Days
536850 Cath Lab Cleveland OHIO 8 Hour Days
544772 Home Health Lake Charles LOUISIANA 8 Hour Days
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
540637 PT Akron OHIO 8 Hour Days
531151 RAD Tech Farmington CONNECTICUT 8 Hour Days Radiology Techs/Technologists
540788 Sonographer Falls Church VIRGINIA 8 Hour Days
544848 Pharmacy Tech Cleveland OHIO 8 Hour Days
544811 Radiation Therapy Lewiston IDAHO 8 Hour Days
540812 CT Tech Denville NEW JERSEY 8 Hour Days
537089 PT Sacramento CALIFORNIA 8 Hour Days
543790 RAD Tech Oceanside CALIFORNIA 8 Hour Days
541359 Vascular Ultrasound Tech Kearney NEBRASKA 8 Hour Days
544670 RAD Tech Los Angeles CALIFORNIA 8 Hour Days
540627 OR Mason City IOWA 8 Hour Days
541635 Case Manager Woonsocket RHODE ISLAND 8 Hour Days
543802 Case Manager Attleboro MASSACHUSETTS 8 Hour Days
538182 Cath Lab San Diego CALIFORNIA 8 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.3523 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.shift asc limit 200,100 in 1.6406 seconds