Table: ambulatory_surgery_char_by_faclty_2017 , facility_name like H*

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  *

oshpd_id facility_num facility_name county_code license_type_desc county_name dba_address1 dba_city dba_zip_code control_type_desc rural_hospital_desc teaching_hospital_desc licensed_bed_size senate_district_desc assembly_district_desc mssa_name mssa_designation teach_rural sex_female sex_male sex_unknown_invalid hcount ccount license_type age_10_19 age_20_29 age_30_39 age_40_49 age_50_59 age_60_69 age_70_79 age_80_ age_01_09 age_under_1 age_unknown asian_pacific_islander black hispanic other_race unknown_race white american_indian_alaska_native acute_care against_medical_advice rehab routine sn_ic_care cah home_health_service hospice_care not_defined_elsewhere psychiatric_care
106010846 010846 HIGHLAND HOSPITAL 01 Hospital ALAMEDA 1411 EAST 31ST STREET OAKLAND 94602 City or County None Teaching 200-299 District 9 District 18 OAKLAND WEST CENTRAL Urban Teaching 2353 2330 None 1 0 Hospital 52 418 743 834 1288 1002 273 73 None None None 687 1247 2025 179 7 528 10 29 5 None 4604 12 None 3 None 9 None
106190382 190382 HOLLYWOOD PRESBYTERIAN MEDICAL CENTER 19 Hospital LOS ANGELES 1300 NORTH VERMONT AVENUE LOS ANGELES 90027 Investor - Individual None None 300-499 District 24 District 43 HOLLYWOOD SOUTH CENTRAL/INNER SUNSET Urban NA 1728 1275 None 1 0 Hospital 51 197 305 481 750 713 339 152 15 None None 874 334 1044 345 9 394 3 None None None 3003 None None None None None None
106190400 190400 HUNTINGTON MEMORIAL HOSPITAL 19 Hospital LOS ANGELES 100 W. CALIFORNIA BOULEVARD PASADENA 91105 Non-profit Corporation (incl. Church-related) None Teaching 500+ District 25 District 41 PASADENA SOUTH/SAN MARINO/SOUTH PASADENA Urban Teaching 2732 2703 1 1 0 Hospital 78 201 427 595 1036 1307 1012 686 84 10 None 631 361 1392 309 16 2720 7 32 2 6 5362 19 None 12 None 1 1
106190949 190949 HENRY MAYO NEWHALL HOSPITAL 19 Hospital LOS ANGELES 23845 MCBEAN PARKWAY VALENCIA 91355 Non-profit Corporation (incl. Church-related) None None 200-299 District 27 District 38 CANYON COUNTRY/SANTA CLARITA WEST/SAUGUS Urban NA 2245 1415 None 1 0 Hospital 105 207 344 523 801 798 536 282 63 1 None 163 131 440 50 5 2870 1 6 None None 3640 8 None None None None None
306197943 197943 HIGH DESERT HEALTH SYSTEM AMBULATORY SURGICAL CENTER 19 Clinic LOS ANGELES 335 EAST AVENUE I LANCASTER 93535 City or County None None - District 21 District 36 LANCASTER CENTRAL/PALMDALE NORTH CENTRAL Urban NA 767 776 None 0 1 Clinic 12 107 241 358 467 306 32 9 11 None None 45 135 959 243 40 119 2 None None None 1523 None None None None None None
106301205 301205 HOAG MEMORIAL HOSPITAL PRESBYTERIAN 30 Hospital ORANGE 1 HOAG DRIVE NEWPORT BEACH 92663 Non-profit Corporation (incl. Church-related) None None 300-499 District 37 District 74 COSTA MESA Urban NA 12583 9156 None 1 0 Hospital 195 888 1727 2602 3645 4930 5243 2474 33 2 None 2252 240 1594 256 252 17117 28 5 2 6 21611 36 None 72 1 None None
106301209 301209 HUNTINGTON BEACH HOSPITAL 30 Hospital ORANGE 17772 BEACH BOULEVARD HUNTINGTON BEACH 92647 Non-profit Corporation (incl. Church-related) None None 100-149 District 34 District 72 HUNTINGTON BEACH NORTH/SEAL BEACH EAST/WESTMINSTER Urban NA 61 73 None 1 0 Hospital 2 5 9 14 59 35 7 3 None None None 14 7 42 13 2 56 None 2 None None 110 4 None None None None 1
106304460 304460 HOAG ORTHOPEDIC INSTITUTE 30 Hospital ORANGE 16250 SAND CANYON AVENUE IRVINE 92618 Investor - Limited Liability Company None None 50-99 District 37 District 74 IRVINE CENTRAL/TUSTIN EAST Urban NA 407 438 None 1 0 Hospital 14 53 82 106 183 174 161 72 None None None 70 7 59 5 None 704 None 1 None None 784 4 None 56 None None None
106331194 331194 HEMET VALLEY MEDICAL CENTER 33 Hospital RIVERSIDE 1117 EAST DEVONSHIRE HEMET 92543 Investor - Limited Liability Company None None 300-499 District 23 District 42 EAST HEMET/HEMET/VALLE VISTA Urban NA 862 620 None 1 0 Hospital 57 85 138 141 243 310 261 201 46 None None 32 86 469 None 4 885 6 13 6 None 1451 6 None 3 None None None
106350784 350784 HAZEL HAWKINS MEMORIAL HOSPITAL 35 Hospital SAN BENITO 911 SUNSET DRIVE HOLLISTER 95023 District SMALL/RURAL None 100-149 District 12 District 30 HOLLISTER/PAICINES/PANOCHE/SAN JUAN BAUTISTA Rural Small/Rural 1213 735 None 1 0 Hospital 67 93 169 175 441 505 373 114 11 None None 36 4 885 4 2 1017 None None None None 1948 None None None None None None
106362041 362041 HI-DESERT MEDICAL CENTER 36 Hospital SAN BERNARDINO 6601 WHITE FEATHER ROAD JOSHUA TREE 92252 Investor - Limited Liability Company SMALL/RURAL None 150-199 District 16 District 42 JOSHUA TREE/LANDERS/MORONGO VALLEY/RIMROCK/YUCCA VALLEY Rural Small/Rural 338 277 None 1 0 Hospital 23 40 57 61 119 156 96 55 8 None None 30 None 63 None None 7 515 1 None None 614 None None None None None None
106490964 490964 HEALDSBURG DISTRICT HOSPITAL 49 Hospital SONOMA 1375 UNIVERSITY STREET HEALDSBURG 95448 District SMALL/RURAL None 1-49 District 2 District 2 GEYSERVILLE/HEALDSBURG Rural Small/Rural 396 368 None 1 0 Hospital 25 22 42 90 184 183 143 72 3 None None 9 None 116 13 12 612 2 None None None 763 1 None None None None None
306544086 544086 HAPY BEAR SURGERY, LLC 54 Clinic TULARE 1979 HILLMAN ST TULARE 93274 Investor - Limited Liability Company None None - District 16 District 26 TIPTON/TULARE/WOODVILLE Rural NA 1076 1180 None 0 1 Clinic 197 None None None None None None None 2032 27 None 10 5 1602 119 460 55 5 None None None 2256 None None None None None None