Listing all records

Displaying records 401 through 500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547064 COTA Crescent City CALIFORNIA 8 Hour Days
545564 RAD Tech Peoria ILLINOIS 8 Hour Days
545664 MLT Gainesville FLORIDA 8 Hour Days
547083 Social Worker San Francisco CALIFORNIA 8 Hour Days
539712 Home Health Mason City IOWA 8 Hour Days
533177 CT Tech Roseburg OREGON 8 Hour Days
533242 Angiography San Diego CALIFORNIA 8 Hour Days
546181 SLP Cooperstown NEW YORK 8 Hour Days
539710 Echo Sioux City IOWA 8 Hour Days
546619 Acute Care Queens NEW YORK 8 Hour Days
547957 OR Mesquite TEXAS 8 Hour Days
545762 Histology Technician Gainesville FLORIDA 8 Hour Days
547861 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547063 SLP Athens GEORGIA 8 Hour Days
547135 PT Lufkin TEXAS 8 Hour Days
533910 PT Hayward CALIFORNIA 8 Hour Days
533986 CMA Farmington CONNECTICUT 8 Hour Days
547921 Surgical Tech CVOR Muskegon MICHIGAN 8 Hour Days
545901 MLT Gainesville FLORIDA 8 Hour Days
547245 Ultrasound Tech Detroit MICHIGAN 8 Hour Days
545874 MRI Tech Gainesville FLORIDA 8 Hour Days
545887 CT Tech Hereford TEXAS 8 Hour Days
546674 Interventional Radiology Des Moines IOWA 8 Hour Days
547314 Certified Surgical Tech Boise IDAHO 8 Hour Days
545960 Cath Lab Berwyn ILLINOIS 8 Hour Days
547273 Certified Surgical Tech Peoria ILLINOIS 8 Hour Days
546036 PT Burbank CALIFORNIA 8 Hour Days
546035 PT Burbank CALIFORNIA 8 Hour Days
546177 Medical Assistant West Branch MICHIGAN 8 Hour Days
546236 Dialysis Oregon OHIO 8 Hour Days
546103 OR Springfield MASSACHUSETTS 8 Hour Days
546081 Case Manager Santa Monica CALIFORNIA 8 Hour Days
546681 PACU Hot Springs ARKANSAS 8 Hour Days
546286 PT Hayward CALIFORNIA 8 Hour Days
546187 CT Tech Emmett IDAHO 8 Hour Days
546190 Interventional Radiology Auburn NEW YORK 8 Hour Days
546143 Surgical Tech CVOR Muskegon MICHIGAN 8 Hour Days
540812 CT Tech Denville NEW JERSEY 8 Hour Days
547947 Echo Minneapolis MINNESOTA 8 Hour Days
534167 Surgical Tech Centerville IOWA 8 Hour Days
547942 PACU Sterling ILLINOIS 8 Hour Days
534238 Med Surg Tele Concord CALIFORNIA 8 Hour Days
540501 Supervisor New York NEW YORK 8 Hour Days
546283 PT Hayward CALIFORNIA 8 Hour Days
540599 Interventional Radiology Tech Pontiac MICHIGAN 8 Hour Days
546321 PT Mission Hills CALIFORNIA 8 Hour Days
540637 PT Akron OHIO 8 Hour Days
546421 Sterile Processing Technician Westerville OHIO 8 Hour Days
540788 Sonographer Falls Church VIRGINIA 8 Hour Days
547320 First Assist Opelika ALABAMA 8 Hour Days
534528 Social Worker Johnston PENNSYLVANIA 8 Hour Days
545275 First Assist San Luis Obispo CALIFORNIA 8 Hour Days
534553 Surgical Tech Louisville KENTUCKY 8 Hour Days
538355 Cardiovascular Technologist Chino CALIFORNIA 8 Hour Days
540956 Interventional Therapy Grove City OHIO 8 Hour Days
538057 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
540628 OR Mason City IOWA 8 Hour Days
534655 CT Tech Syracuse NEW YORK 8 Hour Days
547342 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547984 Home Health Portland OREGON 8 Hour Days
538087 PT Honolulu HAWAII 8 Hour Days
546119 Nuclear Med Technician Whittier CALIFORNIA 8 Hour Days
534713 PT Redding CALIFORNIA 8 Hour Days
546361 Laboratory Manhasset NEW YORK 8 Hour Days
534888 Home Health Lawton OKLAHOMA 8 Hour Days
544964 Nuclear Med Technician Mishawaka INDIANA 8 Hour Days
546440 Ophthalmic Tech Beverly Hills CALIFORNIA 8 Hour Days
547351 PT Falls City NEBRASKA 8 Hour Days
547365 RAD Tech Aspen COLORADO 8 Hour Days
547348 Patient Care Coordinator Clackamas OREGON 8 Hour Days
546778 Ambulatory Syracuse NEW YORK 8 Hour Days RN/Registered Nurse
538182 Cath Lab San Diego CALIFORNIA 8 Hour Days
540026 OR Concord CALIFORNIA 8 Hour Days
547352 PT Falls City NEBRASKA 8 Hour Days
548162 OR Centerville IOWA 8 Hour Days RN/Registered Nurse
546753 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
541108 Ultrasound Tech Sioux City IOWA 8 Hour Days
546469 OR Louisville KENTUCKY 8 Hour Days
540892 MLT Farmington CONNECTICUT 8 Hour Days
546355 CVOR Lakewood CALIFORNIA 8 Hour Days
546641 Acute Care New York NEW YORK 8 Hour Days
547992 Case Manager Torrance CALIFORNIA 8 Hour Days
535143 OT Rehab Devils Lake NORTH DAKOTA 8 Hour Days
535174 PT San Francisco CALIFORNIA 8 Hour Days
535176 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Days
546668 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
535178 Interventional Radiology Tech Columbus OHIO 8 Hour Days
547414 NICU Bronx NEW YORK 8 Hour Days
546326 Social Worker Ketchum IDAHO 8 Hour Days
546489 OR Brooklyn NEW YORK 8 Hour Days
535231 Cath Lab Sioux City IOWA 8 Hour Days
548164 LTAC Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
539293 Supervisor Brooklyn NEW YORK 8 Hour Days
540910 Social Worker Concord CALIFORNIA 8 Hour Days
538356 RAD Tech Chino CALIFORNIA 8 Hour Days
545280 LPN/LVN SANTA MARIA CALIFORNIA 8 Hour Days
540446 Case Manager Napa CALIFORNIA 8 Hour Days
535302 MLT Pittsfield MASSACHUSETTS 8 Hour Days
539873 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
541191 Echo Ann Arbor MICHIGAN 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.4437 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 400,100 in 1.3038 seconds