Listing all records

Displaying records 101 through 200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
542838 Case Manager Eureka CALIFORNIA 8 Hour Days
517474 Ortho Tech Oceanside CALIFORNIA 8 Hour Days
544103 Phlebotomist Farmington CONNECTICUT 8 Hour Days
541108 Ultrasound Tech Sioux City IOWA 8 Hour Days
542858 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
541096 Long Term Care New Lisbon WISCONSIN 8 Hour Days
540194 Case Manager Concord CALIFORNIA 8 Hour Days
542697 Therapy Rehab Garden City KANSAS 8 Hour Days
518108 Case Manager Burbank CALIFORNIA 8 Hour Days
542605 Surgical Tech Woonsocket RHODE ISLAND 8 Hour Days
541191 Echo Ann Arbor MICHIGAN 8 Hour Days
543089 OR San Dimas CALIFORNIA 8 Hour Days
540189 Peri-Operative Concord CALIFORNIA 8 Hour Days
541964 Cath Lab Whittier CALIFORNIA 8 Hour Days
543096 Oncology Newark NEW JERSEY 8 Hour Days
536728 Interventional Radiology Germantown MARYLAND 8 Hour Days
535302 MLT Pittsfield MASSACHUSETTS 8 Hour Days
536753 PT NORTHRIDGE CALIFORNIA 8 Hour Days
536758 OR Germantown MARYLAND 8 Hour Days
537460 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540351 Cath Lab Waterloo IOWA 8 Hour Days
536932 RAD Tech Maywood ILLINOIS 8 Hour Days
543006 CVOR Oceanside CALIFORNIA 8 Hour Days
541860 PT Lovington NEW MEXICO 8 Hour Days
540501 Supervisor New York NEW YORK 8 Hour Days
541847 Psych Peoria ILLINOIS 8 Hour Days RN/Registered Nurse
538057 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
542785 Case Manager Glens Falls NEW YORK 8 Hour Days
531958 Social Worker Falls Church VIRGINIA 8 Hour Days
541840 PT SANTA MARIA CALIFORNIA 8 Hour Days
532202 RAD Tech Louisville KENTUCKY 8 Hour Days
540628 OR Mason City IOWA 8 Hour Days
519146 Med Surg Kula HAWAII 8 Hour Days
532355 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
539293 Supervisor Brooklyn NEW YORK 8 Hour Days
532660 CMA Farmington CONNECTICUT 8 Hour Days
541591 RAD Tech Petaluma CALIFORNIA 8 Hour Days
538182 Cath Lab San Diego CALIFORNIA 8 Hour Days
532997 SLP Everett WASHINGTON 8 Hour Days
519983 PT Big Stone City SOUTH DAKOTA 8 Hour Days
538391 Med Surg Tele Wailuku HAWAII 8 Hour Days
533009 Cath Lab Mason City IOWA 8 Hour Days
538849 Echo Honolulu HAWAII 8 Hour Days
539875 Therapy Rehab Athens GEORGIA 8 Hour Days
519987 Therapy Rehab Big Stone City SOUTH DAKOTA 8 Hour Days
537446 CNA Brooklyn NEW YORK 8 Hour Days
542131 Echo Great Falls MONTANA 8 Hour Days
547135 PT Lufkin TEXAS 8 Hour Days
538686 Laboratory New York NEW YORK 8 Hour Days
540788 Sonographer Falls Church VIRGINIA 8 Hour Days
533910 PT Hayward CALIFORNIA 8 Hour Days
541654 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
539089 PT Fort Dodge IOWA 8 Hour Days
541543 Case Manager Portland OREGON 8 Hour Days
541705 PT Eureka CALIFORNIA 8 Hour Days
539112 Social Worker Concord CALIFORNIA 8 Hour Days
539873 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
541750 PT Union City CALIFORNIA 8 Hour Days
521399 LPN/LVN Atlanta GEORGIA 8 Hour Days LVN
542497 PT Clovis NEW MEXICO 8 Hour Days
539836 RAD Tech Seattle WASHINGTON 8 Hour Days
521068 Echo Columbia SOUTH CAROLINA 8 Hour Days
542084 RAD Tech Farmington CONNECTICUT 8 Hour Days
540018 Surgical Tech Farmington CONNECTICUT 8 Hour Days
542040 Physician PHiladelphia PENNSYLVANIA 8 Hour Days
540035 PCU Concord CALIFORNIA 8 Hour Days
540879 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
539930 Surgical Tech Louisville KENTUCKY 8 Hour Days
534528 Social Worker Johnston PENNSYLVANIA 8 Hour Days
539979 Case Manager Petoskey MICHIGAN 8 Hour Days
538355 Cardiovascular Technologist Chino CALIFORNIA 8 Hour Days
534655 CT Tech Syracuse NEW YORK 8 Hour Days
540016 Monitor Tech Farmington CONNECTICUT 8 Hour Days
540033 Med Surg Tele Concord CALIFORNIA 8 Hour Days
534888 Home Health Lawton OKLAHOMA 8 Hour Days
535174 PT San Francisco CALIFORNIA 8 Hour Days
540024 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540029 PCU Concord CALIFORNIA 8 Hour Days
540020 Phlebotomist Farmington CONNECTICUT 8 Hour Days
538434 Nuclear Med Technician Janesville WISCONSIN 8 Hour Days
526053 RAD Tech Clearwater FLORIDA 8 Hour Days RN/Registered Nurse
542401 Surgical Tech Leavenworth KANSAS 8 Hour Days
542380 PT SANTA ROSA CALIFORNIA 8 Hour Days
541392 OR East Norriton PENNSYLVANIA 8 Hour Days
542596 Interventional Radiology Tech Daytona Beach FLORIDA 8 Hour Days
540956 Interventional Therapy Grove City OHIO 8 Hour Days
540910 Social Worker Concord CALIFORNIA 8 Hour Days
537278 PT Sonoma CALIFORNIA 8 Hour Days
525929 Nurse Practicioner Brooklyn NEW YORK 8 Hour Days
540976 Phlebotomist Farmington CONNECTICUT 8 Hour Days
542701 PT Athens GEORGIA 8 Hour Days
540158 Peri-Operative Concord CALIFORNIA 8 Hour Days
535674 Cath Lab Passaic NEW JERSEY 8 Hour Days
535556 PT Athens GEORGIA 8 Hour Days
542734 PT Hayward CALIFORNIA 8 Hour Days
535640 PT NORTHRIDGE CALIFORNIA 8 Hour Days
546119 Nuclear Med Technician Whittier CALIFORNIA 8 Hour Days
540626 OR Mason City IOWA 8 Hour Days
526054 RAD Tech Cleveland OHIO 8 Hour Days Radiology Techs/Technologists
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.3438 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 100,100 in 1.4354 seconds