Listing all records

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

ID Job Specialty City State Shift Title
536307 MRI Tech Janesville WISCONSIN 8 Hour Days
525673 Cardiology Louisville KENTUCKY 8 Hour Days
537758 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
533986 CMA Farmington CONNECTICUT 8 Hour Days
532355 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
460916 PT Lawton OKLAHOMA 8 Hour Days
462914 Wound Care Los Alamitos CALIFORNIA 8 Hour Days
541860 PT Lovington NEW MEXICO 8 Hour Days
538391 Med Surg Tele Wailuku HAWAII 8 Hour Days
536758 OR Germantown MARYLAND 8 Hour Days
538542 Cath Lab Mason City IOWA 8 Hour Days
527553 Cath Lab Louisville KENTUCKY 8 Hour Days
536932 RAD Tech Maywood ILLINOIS 8 Hour Days
534713 PT Redding CALIFORNIA 8 Hour Days
534167 Surgical Tech Centerville IOWA 8 Hour Days
521068 Echo Columbia SOUTH CAROLINA 8 Hour Days
534528 Social Worker Johnston PENNSYLVANIA 8 Hour Days
539078 MLT Des Moines IOWA 8 Hour Days
538355 Cardiovascular Technologist Chino CALIFORNIA 8 Hour Days
536753 PT NORTHRIDGE CALIFORNIA 8 Hour Days
535174 PT San Francisco CALIFORNIA 8 Hour Days
525987 Supervisor New York NEW YORK 8 Hour Days
536346 CVOR Lumberton NORTH CAROLINA 8 Hour Days RN/Registered Nurse
535176 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Days
519983 PT Big Stone City SOUTH DAKOTA 8 Hour Days
535674 Cath Lab Passaic NEW JERSEY 8 Hour Days
531151 RAD Tech Farmington CONNECTICUT 8 Hour Days Radiology Techs/Technologists
519146 Med Surg Kula HAWAII 8 Hour Days
496817 Surgical Tech Peterborough NEW HAMPSHIRE 8 Hour Days
535302 MLT Pittsfield MASSACHUSETTS 8 Hour Days
538434 Nuclear Med Technician Janesville WISCONSIN 8 Hour Days
518108 Case Manager Burbank CALIFORNIA 8 Hour Days
538242 PT Lansing MICHIGAN 8 Hour Days
532660 CMA Farmington CONNECTICUT 8 Hour Days
538356 RAD Tech Chino CALIFORNIA 8 Hour Days
535556 PT Athens GEORGIA 8 Hour Days
530850 Home Health Hayward CALIFORNIA 8 Hour Days
533177 CT Tech Roseburg OREGON 8 Hour Days
538686 Laboratory New York NEW YORK 8 Hour Days
538849 Echo Honolulu HAWAII 8 Hour Days
525843 PT Elizabeth WEST VIRGINIA 8 Hour Days PT/Physical Therapist
534238 Med Surg Tele Concord CALIFORNIA 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
538087 PT Honolulu HAWAII 8 Hour Days
535178 Interventional Radiology Tech Columbus OHIO 8 Hour Days
527053 CVOR Houston TEXAS 8 Hour Days RN/Registered Nurse
532921 SLP Edwardsville ILLINOIS 8 Hour Days
537446 CNA Brooklyn NEW YORK 8 Hour Days
527789 RAD Tech Oceanside CALIFORNIA 8 Hour Days
534888 Home Health Lawton OKLAHOMA 8 Hour Days
535143 OT Rehab Devils Lake NORTH DAKOTA 8 Hour Days
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
535640 PT NORTHRIDGE CALIFORNIA 8 Hour Days
504074 Case Manager San Francisco CALIFORNIA 8 Hour Days
537089 PT Sacramento CALIFORNIA 8 Hour Days
535919 Ultrasound Tech Lawton OKLAHOMA 8 Hour Days
538182 Cath Lab San Diego CALIFORNIA 8 Hour Days
533009 Cath Lab Mason City IOWA 8 Hour Days
519987 Therapy Rehab Big Stone City SOUTH DAKOTA 8 Hour Days
521399 LPN/LVN Atlanta GEORGIA 8 Hour Days LVN
538057 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
541964 Cath Lab Whittier CALIFORNIA 8 Hour Days
531037 Nuclear Medicine Oceanside CALIFORNIA 8 Hour Days
536440 Infusion Oncology Maywood ILLINOIS 8 Hour Days
507931 PT Martinez CALIFORNIA 8 Hour Days
531958 Social Worker Falls Church VIRGINIA 8 Hour Days
532907 Ultrasound Tech Mason City IOWA 8 Hour Days
533910 PT Hayward CALIFORNIA 8 Hour Days
536728 Interventional Radiology Germantown MARYLAND 8 Hour Days
538243 PT Lansing MICHIGAN 8 Hour Days
525066 PT Mason City IOWA 8 Hour Days
512505 MRI Tech Lawton OKLAHOMA 8 Hour Days
512644 PT SUNNYVALE CALIFORNIA 8 Hour Days
532997 SLP Everett WASHINGTON 8 Hour Days
532202 RAD Tech Louisville KENTUCKY 8 Hour Days
547135 PT Lufkin TEXAS 8 Hour Days
513688 Certified Surgical Tech Hickory NORTH CAROLINA 8 Hour Days
517474 Ortho Tech Oceanside CALIFORNIA 8 Hour Days
533242 Angiography San Diego CALIFORNIA 8 Hour Days
541847 Psych Peoria ILLINOIS 8 Hour Days RN/Registered Nurse
533010 Cath Lab Mason City IOWA 8 Hour Days
525988 Supervisor New York NEW YORK 8 Hour Days
534553 Surgical Tech Louisville KENTUCKY 8 Hour Days
536850 Cath Lab Cleveland OHIO 8 Hour Days
525929 Nurse Practicioner Brooklyn NEW YORK 8 Hour Days
535231 Cath Lab Sioux City IOWA 8 Hour Days
536150 Lab Tech King Renton WASHINGTON 8 Hour Days
532201 RAD Tech Louisville KENTUCKY 8 Hour Days
542785 Case Manager Glens Falls NEW YORK 8 Hour Days
516543 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
516544 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
516546 ER Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
534655 CT Tech Syracuse NEW YORK 8 Hour Days
537278 PT Sonoma CALIFORNIA 8 Hour Days
537460 Phlebotomist Farmington CONNECTICUT 8 Hour Days
536828 Radiation Therapy Los Angeles CALIFORNIA 8 Hour Days
541840 PT SANTA MARIA CALIFORNIA 8 Hour Days
545463 Vascular Ultrasound Tech Hettinger NORTH DAKOTA 8 Hour Days
527593 PT Pinehurst NORTH CAROLINA 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.0401 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 0,100 in 1.0236 seconds