Table: licensed_and_certified_healthcare_facilities , ao_name like D*

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  *

x y licensed_certified flag t18_19 facid fac_status_type_code aspen_facid ccn terminat_sw participation_date approval_date npi can_be_deemed_fac_type can_be_certified_fac_type deemed ao_cd dmg_efctv_dt ao_trmntn_dt ao_name facname fac_type_code fac_fdr ltc capacity address city zip zip9 facadmin contact_email contact_fax contact_phone_number county_code county_name district_number district_name isfacmain parent_facid fac_fac_relationship_type_code start_date license_number business_name license_status_description initial_license_date license_effective_date license_expiration_date entity_type_description latitude longitude location oshpd_id cclho_code cclho_name fips_county_code birthing_facility_flag trauma_ped_ctr trauma_ctr type_of_care critical_access_hospital data_date objectid
-13468627.0109039 4529184.60478609 LICENSED AND CERTIFIED 030000129 OPEN CA0300129 052055 2013/08/28 07:00:00+00 2021/06/17 07:00:00+00 1578989703 Y Y 1 15 08/28/2022 DNV GL CENTRAL VALLEY SPECIALTY HOSPITAL GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 96 730 17TH ST MODESTO 95354 1209 SIDHU, DUPINDER DUPINDER.SIDHU@CENTRALVALLEYSPECIALTY.ORG (209) 846-0345 (209) 248-7700 600 STANISLAUS 04 FRESNO Y PARENT 030000464 CENTRAL VALLEY SPECIALTY HOSPITAL, INC. ACTIVE 1992/11/18 08:00:00+00 2024/07/19 07:00:00+00 2025/07/18 07:00:00+00 PROFIT CORP 37.64349 -120.990735 (-120.990735,37.64349) 50 STANISLAUS 06099 2025/06/15 07:00:00+00 142
-13128055.492854 3978590.30017713 LICENSED AND CERTIFIED 060000014 OPEN CA060000014 050224 1966/07/01 07:00:00+00 2013/05/14 07:00:00+00 1518951300 Y Y 1 15 01/21/2025 DNV GL HOAG MEMORIAL HOSPITAL PRESBYTERIAN GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 440 ONE HOAG DR NEWPORT BEACH 92663 4162 BRAITHWAITE, ROBERT MONICA.DANG@HOAG.ORG (949) 764-8030 400 ORANGE 06 ORANGE Y PARENT 060000122 HOAG MEMORIAL HOSPITAL PRESBYTERIAN ACTIVE 1952/09/15 07:00:00+00 2025/06/10 07:00:00+00 2025/12/09 08:00:00+00 NONPROFIT CORP 33.625233 -117.931329 (-117.931329,33.625233) 30 ORANGE 06059 YES 2025/06/15 07:00:00+00 534
-13275751.465911 4065732.88800244 LICENSED AND CERTIFIED 050000014 OPEN CA050000014 050394 1966/07/01 07:00:00+00 2024/08/22 07:00:00+00 1215903018 Y Y 1 15 04/06/2023 DNV GL COMMUNITY MEMORIAL HOSPITAL - VENTURA GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 250 147 N BRENT ST VENTURA 93003 2809 ZDEBLICK, MICHAEL MARCHAMBAULT@CMHSHEALTH.ORG (805) 385-3036 (805) 948-2884 660 VENTURA 05 VENTURA Y PARENT 050000026 COMMUNITY MEMORIAL HEALTH SYSTEM ACTIVE 1946/01/01 08:00:00+00 2025/03/01 08:00:00+00 2026/02/28 08:00:00+00 NONPROFIT CORP 34.274592 -119.2581045 (-119.2581045,34.274592) 56 VENTURA 06111 YES 2025/06/15 07:00:00+00 618
-13276458.7899555 4088427.77223303 LICENSED AND CERTIFIED 050000023 OPEN CA050000023 051334 2014/02/19 08:00:00+00 2024/05/01 07:00:00+00 1992876767 Y Y 1 15 01/26/2023 DNV GL COMMUNITY MEMORIAL HOSPITAL - OJAI GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 25 1306 MARICOPA HWY OJAI 93023 3131 LASHKARI, HAADY HLASHKARI@CMHSHEALTH.ORG (805) 640-2298 (805) 640-2280 660 VENTURA 05 VENTURA Y PARENT 050000045 COMMUNITY MEMORIAL HEALTH SYSTEM ACTIVE 2000/10/01 07:00:00+00 2025/06/01 07:00:00+00 2026/05/31 07:00:00+00 NONPROFIT CORP 34.442892 -119.2644585 (-119.2644585,34.442892) 56 VENTURA 06111 Y 2025/06/15 07:00:00+00 625
-13396301.1236029 4321561.64538273 LICENSED AND CERTIFIED 040000096 OPEN CA040000096 051338 2021/04/12 07:00:00+00 2022/12/13 08:00:00+00 1801452941 Y Y 1 15 04/12/2021 DNV GL COALINGA REGIONAL MEDICAL CENTER GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 24 1191 PHELPS AVE COALINGA 93210 9609 BRAR, AMARDEEP TTHOMPSON@AMERICANAM.ORG (559) 935-6596 (559) 821-6100 090 FRESNO 04 FRESNO Y PARENT 040000085 COALINGA MEDICAL CENTER, LLC ACTIVE 2025/06/01 07:00:00+00 2026/05/31 07:00:00+00 LIMITED LIABILITY COMPANY 36.152037 -120.3410205 (-120.3410205,36.152037) 10 FRESNO 06019 YES Y 2025/06/15 07:00:00+00 728
-13110347.8457938 3983423.35549505 LICENSED AND CERTIFIED USE PARENT MATCH 060001022 OPEN CA060000014 050224 1966/07/01 07:00:00+00 2013/05/14 07:00:00+00 1518951300 Y Y 1 15 01/21/2025 DNV GL HOAG HOSPITAL IRVINE GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 96 16200 SAND CANYON AVE IRVINE 92618 3714 MONICA.DANG@HOAG.ORG (949) 764-8030 400 ORANGE 06 ORANGE Y 060000014 CONSOLIDATED 19FEB2009 060000122 HOAG MEMORIAL HOSPITAL PRESBYTERIAN ACTIVE 1952/09/15 07:00:00+00 2025/06/10 07:00:00+00 2025/12/09 08:00:00+00 NONPROFIT CORP 33.661377 -117.7722585 (-117.7722585,33.661377) 30 ORANGE 06059 YES 2025/06/15 07:00:00+00 880
-12863303.1901777 3889997.29589787 LICENSED AND CERTIFIED 090000146 OPEN CA090000146 050342 1966/07/01 07:00:00+00 2017/07/05 07:00:00+00 1073519443 Y Y 1 15 07/21/2017 DNV GL PIONEERS MEMORIAL HEALTHCARE DISTRICT GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 107 207 W LEGION RD BRAWLEY 92227 7780 BJORNBERG, CHRISTOPHER CZAMORA@PMHD.ORG (760) 351-4849 (760) 351-3290 120 IMPERIAL 10 SAN DIEGO Y PARENT 090000087 IMPERIAL VALLEY HEALTHCARE DISTRICT ACTIVE 1950/11/06 08:00:00+00 2025/04/11 07:00:00+00 2025/06/29 07:00:00+00 HEALTH CARE DISTRICT 32.96001101 -115.5530186 (-115.5530186,32.960011013) 13 IMPERIAL 06025 YES LEVEL IV 2025/06/15 07:00:00+00 1830
-13117208.1877126 3999670.3742672 LICENSED AND CERTIFIED 060001674 OPEN CA060001674 053308 2000/02/23 08:00:00+00 2017/02/13 08:00:00+00 1528662954 Y Y 1 15 05/31/2025 DNV GL HEALTHBRIDGE CHILDREN'S HOSPITAL - ORANGE GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 6 393 S TUSTIN ST ORANGE 92866 2501 CONSOLVER, ROBERTA L ROBERTA.CONSOLVER@HEALTHBRIDGECC.COM (714) 289-2367 (714) 464-1853 400 ORANGE 06 ORANGE Y PARENT 060000530 VSC HBO, LLC ACTIVE 2000/02/04 08:00:00+00 2025/02/04 08:00:00+00 2026/02/03 08:00:00+00 LIMITED LIABILITY COMPANY 33.782769 -117.833886 (-117.833886,33.782769) 30 ORANGE 06059 2025/06/15 07:00:00+00 1983
-13672157.5009581 4635709.55318746 LICENSED AND CERTIFIED 110000038 OPEN CA11000038 052057 2019/04/01 07:00:00+00 2024/12/26 08:00:00+00 1396205050 Y Y 1 15 09/24/2024 DNV GL SONOMA SPECIALTY HOSPITAL GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 58 501 PETALUMA AVE SEBASTOPOL 95472 4215 SINGH, SATWINDER MANNY.G@AMERICANAM.ORG (707) 503-8772 590 SONOMA 11 SANTA ROSA Y PARENT 110000091 SONOMA SPECIALTY HOSPITAL, LLC ACTIVE 1946/01/01 08:00:00+00 2025/01/23 08:00:00+00 2025/10/31 07:00:00+00 LIMITED LIABILITY COMPANY 38.397339 -122.8190805 (-122.8190805,38.397339) 49 SONOMA 06097 2025/06/15 07:00:00+00 2037
-13098950.8895347 4251472.77046018 LICENSED AND CERTIFIED USE PARENT MATCH 120000323 OPEN CA120000409 051333 2012/08/08 07:00:00+00 2024/07/05 07:00:00+00 1447253125 Y Y 1 15 04/25/2022 DNV GL BELLA SERA SNF SKILLED NURSING FACILITY LTC 99 1131 N CHINA LAKE BLVD RIDGECREST 93555 3131 SALVIEJO, CHRISTIAN ROMULO.LOMIBAO@RRH.ORG (760) 446-2254 (760) 446-3591 140 KERN 12 BAKERSFIELD N 120000409 DISTINCT PART 04MAR2015 120000186 RIDGECREST REGIONAL HOSPITAL ACTIVE 1946/09/30 07:00:00+00 2024/11/01 07:00:00+00 2025/10/31 07:00:00+00 NONPROFIT CORP 35.64200358 -117.6698779 (-117.6698779,35.642003579) 15 KERN 06029 Y 2025/06/15 07:00:00+00 2286
-13099095.7829839 4251314.20710461 LICENSED AND CERTIFIED 120000409 OPEN CA120000409 051333 2012/08/08 07:00:00+00 2024/07/05 07:00:00+00 1447253125 Y Y 1 15 04/25/2022 DNV GL RIDGECREST REGIONAL HOSPITAL GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 72 1081 N CHINA LAKE BLVD RIDGECREST 93555 3130 SUVER, CEO, JIM JAMES.SUVER@RRH.ORG (760) 446-2254 (760) 446-3551 140 KERN 12 BAKERSFIELD Y PARENT 120000186 RIDGECREST REGIONAL HOSPITAL ACTIVE 1946/09/30 07:00:00+00 2024/11/01 07:00:00+00 2025/10/31 07:00:00+00 NONPROFIT CORP 35.640846 -117.6711795 (-117.6711795,35.640846) 15 KERN 06029 YES LEVEL IV Y 2025/06/15 07:00:00+00 2437
-13284717.7499567 4331090.09251898 LICENSED AND CERTIFIED 120001467 OPEN CA1200001467 050784 2019/01/30 08:00:00+00 2025/05/05 07:00:00+00 1801366711 Y Y 1 15 01/30/2022 DNV GL ADVENTIST HEALTH TULARE GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 108 869 N CHERRY ST TULARE 93274 2207 WELLS, JASON SMITHIW@AH.ORG (559) 605-0032 (559) 537-2029 640 TULARE 12 BAKERSFIELD Y PARENT 120000585 ADVENTIST HEALTH TULARE ACTIVE 2025/04/01 07:00:00+00 2026/03/31 07:00:00+00 NONPROFIT CORP 36.221121 -119.33865 (-119.33865,36.221121) 54 TULARE 06107 YES 2025/06/15 07:00:00+00 2665
-13243001.4720947 4529503.56076029 LICENSED AND CERTIFIED 240000005 OPEN CA240000005 051303 2001/07/01 07:00:00+00 2018/12/31 08:00:00+00 1962444059 Y Y 1 15 12/27/2018 DNV GL MAMMOTH HOSPITAL GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 17 85 SIERRA PARK RD MAMMOTH LAKES 93546 2073 PARKER, THOMAS S LENNA.MONTE@MAMMOTHHOSPITAL.COM (760) 924-4110 360 MONO 24 SAN BERNARDINO Y PARENT 240000008 SOUTHERN MONO HEALTH CARE DISTRICT ACTIVE 1985/08/26 07:00:00+00 2024/11/15 08:00:00+00 2025/11/14 08:00:00+00 HEALTH CARE DISTRICT 37.64575873 -118.9639063 (-118.9639063,37.64575873) 26 MONO 06051 YES Y 2025/06/15 07:00:00+00 3380
-12756681.3151042 3976913.16496824 LICENSED AND CERTIFIED 250000042 OPEN CA250000042 051339 2023/07/20 07:00:00+00 2024/02/28 08:00:00+00 1194705202 Y Y 1 15 07/20/2023 DNV GL PALO VERDE HOSPITAL GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 25 250 N 1ST ST BLYTHE 92225 1702 ANAYA, SANDRA MICHAEL.ROSE@PALOVERDEHOSPITAL.ORG (760) 921-5201 (760) 922-7200 430 RIVERSIDE 25 RIVERSIDE Y PARENT 250000184 PALO VERDE HEALTHCARE DISTRICT ACTIVE 1946/03/20 08:00:00+00 2025/01/01 08:00:00+00 2025/12/31 08:00:00+00 HEALTH CARE DISTRICT 33.612687 -114.595218 (-114.595218,33.612687) 33 RIVERSIDE 06065 YES Y 2025/06/15 07:00:00+00 3950
-13110351.3523577 3983306.596924 LICENSED AND CERTIFIED 630012891 OPEN CA630012891 050769 2010/11/19 08:00:00+00 2018/12/27 08:00:00+00 1982927877 Y Y 1 15 11/19/2024 DNV GL HOAG ORTHOPEDIC INSTITUTE GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 70 16250 SAND CANYON AVE IRVINE 92618 3714 MIKES, KIM MONICA.DANG@HOAG.ORG (949) 764-4441 (949) 764-8030 400 ORANGE 06 ORANGE Y PARENT 550001431 HOAG ORTHOPEDIC INSTITUTE, LLC ACTIVE 2010/11/10 08:00:00+00 2024/11/10 08:00:00+00 2025/11/09 08:00:00+00 LIMITED LIABILITY COMPANY 33.660504 -117.77229 (-117.77229,33.660504) 30 ORANGE 06059 2025/06/15 07:00:00+00 5266
-13146902.7732012 4030818.21771955 LICENSED AND CERTIFIED 930000012 OPEN CA930000012 050350 1966/07/01 07:00:00+00 2019/08/13 07:00:00+00 Y Y 1 15 03/12/2019 DNV GL ADVENTIST HEALTH WHITE MEMORIAL MONTEBELLO GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 192 309 W BEVERLY BLVD MONTEBELLO 90640 4308 RAFFOUL, JOHN BRYANTMC@AH.ORG (323) 268-5000 200 LOS ANGELES 93 LA ACUTE/ANCILLARY Y 930000191 CONSOLIDATED 07SEP2023 930000195 WHITE MEMORIAL MEDICAL CENTER ACTIVE 1946/01/01 08:00:00+00 2024/11/01 07:00:00+00 2025/10/31 07:00:00+00 NONPROFIT CORP 34.015014 -118.100637 (-118.100637,34.015014) 19 LOS ANGELES 06037 YES 2025/06/15 07:00:00+00 14107
-13168053.3651325 4041950.88992692 LICENSED AND CERTIFIED 930000034 OPEN CA930000034 053302 1984/03/01 08:00:00+00 2021/08/05 07:00:00+00 1124073366 Y Y 1 15 06/10/2021 DNV GL CHILDREN'S HOSPITAL LOS ANGELES GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 438 4650 W SUNSET BLVD LOS ANGELES 90027 6062 VIVIANO, PAUL S ACCRLICENSE@CHLA.USC.EDU (323) 361-4002 (323) 208-2860 200 LOS ANGELES 93 LA ACUTE/ANCILLARY Y PARENT 930000032 CHILDREN'S HOSPITAL LOS ANGELES ACTIVE 1946/01/01 08:00:00+00 2025/01/01 08:00:00+00 2025/12/31 08:00:00+00 NONPROFIT CORP 34.097868 -118.290636 (-118.290636,34.097868) 19 LOS ANGELES 06037 LEVEL I PED 2025/06/15 07:00:00+00 14273
-13159833.9792103 4056432.64587201 LICENSED AND CERTIFIED USE PARENT MATCH 930001555 OPEN CA930000187 050124 1966/07/01 07:00:00+00 2021/09/01 07:00:00+00 1487251401 Y Y 1 15 12/06/2024 DNV GL VERDUGO HILLS HOSPITAL D/P APH APH ACUTE PSYCHIATRIC HOSPITAL NON-LTC 24 1812 VERDUGO BLVD GLENDALE 91208 1407 GLOSSY, BERNARD (818) 790-7100 200 LOS ANGELES 93 LA ACUTE/ANCILLARY N 930000187 DISTINCT PART 08DEC1972 930000173 USC VERDUGO HILLS HOSPITAL ACTIVE 1972/12/08 08:00:00+00 2025/05/29 07:00:00+00 2026/05/28 07:00:00+00 NONPROFIT CORP 34.205526 -118.2168 (-118.2168,34.205526) 19 LOS ANGELES 06037 2025/06/15 07:00:00+00 14466
-13187213.2306099 4054933.0082953 LICENSED AND CERTIFIED 930000129 OPEN CA930000129 050126 1966/07/01 07:00:00+00 2021/08/13 07:00:00+00 1578529285 Y Y 1 15 08/18/2020 DNV GL VALLEY PRESBYTERIAN HOSPITAL GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 350 15107 VANOWEN ST VAN NUYS 91405 4542 VALDESPINO, GUSTAVO LORI.CARDLE@VALLEYPRES.ORG (818) 902-3974 (818) 782-6600 200 LOS ANGELES 93 LA ACUTE/ANCILLARY Y PARENT 930000170 VALLEY PRESBYTERIAN HOSPITAL ACTIVE 1958/01/21 08:00:00+00 2025/05/01 07:00:00+00 2026/04/30 07:00:00+00 NONPROFIT CORP 34.194384 -118.462752 (-118.462752,34.194384) 19 LOS ANGELES 06037 YES 2025/06/15 07:00:00+00 14669
-13159833.9792103 4056432.64587201 LICENSED AND CERTIFIED 930000187 OPEN CA930000187 050124 1966/07/01 07:00:00+00 2021/09/01 07:00:00+00 1487251401 Y Y 1 15 12/06/2024 DNV GL USC VERDUGO HILLS HOSPITAL GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 116 1812 VERDUGO BLVD GLENDALE 91208 1407 DORIAN, ARMAND KECKLICENSING@MED.USC.EDU (818) 952-4649 (818) 952-2210 200 LOS ANGELES 93 LA ACUTE/ANCILLARY Y PARENT 930000173 USC VERDUGO HILLS HOSPITAL ACTIVE 1972/12/08 08:00:00+00 2025/05/29 07:00:00+00 2026/05/28 07:00:00+00 NONPROFIT CORP 34.205526 -118.2168 (-118.2168,34.205526) 19 LOS ANGELES 06037 YES 2025/06/15 07:00:00+00 14807