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 None None 030000129 OPEN CA0300129 052055 None 2013/08/28 07:00:00+00 2021/06/17 07:00:00+00 1578989703 Y Y 1 15 28AUG2022:00:00:00 None 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 None PARENT None 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) None 50 STANISLAUS 06099 None None None None None 2024/10/15 07:00:00+00 46
-13396301.1236029 4321561.64538273 LICENSED AND CERTIFIED None None 040000096 OPEN CA040000096 051338 None 2021/04/12 07:00:00+00 2022/12/13 08:00:00+00 1801452941 Y Y 1 15 12APR2021:00:00:00 None 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-6202 090 FRESNO 04 FRESNO Y None PARENT None 040000085 COALINGA MEDICAL CENTER, LLC ACTIVE None 2024/08/27 07:00:00+00 2025/05/31 07:00:00+00 LIMITED LIABILITY COMPANY 36.152037 -120.3410205 (-120.3410205,36.152037) None 10 FRESNO 06019 YES None None None Y 2024/10/15 07:00:00+00 133
-13128055.492854 3978590.30017713 LICENSED AND CERTIFIED None None 060000014 OPEN CA060000014 050224 None 1966/07/01 07:00:00+00 2013/05/14 07:00:00+00 1518951300 Y Y 1 15 21JAN2022:00:00:00 None 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 None (949) 764-8030 400 ORANGE 06 ORANGE Y None PARENT None 060000122 HOAG MEMORIAL HOSPITAL PRESBYTERIAN ACTIVE 1952/09/15 07:00:00+00 2024/07/06 07:00:00+00 2024/12/09 08:00:00+00 NONPROFIT CORP 33.625233 -117.931329 (-117.931329,33.625233) None 30 ORANGE 06059 YES None None None None 2024/10/15 07:00:00+00 539
-13110347.8457938 3983423.35549505 LICENSED AND CERTIFIED USE PARENT MATCH None 060001022 OPEN CA060000014 050224 None 1966/07/01 07:00:00+00 2013/05/14 07:00:00+00 1518951300 Y Y 1 15 21JAN2022:00:00:00 None DNV GL HOAG HOSPITAL IRVINE GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 96 16200 SAND CANYON AVE IRVINE 92618 3714 None MONICA.DANG@HOAG.ORG None (949) 764-8030 400 ORANGE 06 ORANGE Y 060000014 CONSOLIDATED 19FEB2009 060000122 HOAG MEMORIAL HOSPITAL PRESBYTERIAN ACTIVE 1952/09/15 07:00:00+00 2024/07/06 07:00:00+00 2024/12/09 08:00:00+00 NONPROFIT CORP 33.661377 -117.7722585 (-117.7722585,33.661377) None 30 ORANGE 06059 YES None None None None 2024/10/15 07:00:00+00 689
-13275751.465911 4065732.88800244 LICENSED AND CERTIFIED None None 050000014 OPEN CA050000014 050394 None 1966/07/01 07:00:00+00 2024/08/22 07:00:00+00 1215903018 Y Y 1 15 06APR2023:00:00:00 None 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 None PARENT None 050000026 COMMUNITY MEMORIAL HEALTH SYSTEM ACTIVE 1946/01/01 08:00:00+00 2024/09/19 07:00:00+00 2025/02/28 08:00:00+00 NONPROFIT CORP 34.274592 -119.2581045 (-119.2581045,34.274592) None 56 VENTURA 06111 YES None None None None 2024/10/15 07:00:00+00 724
-13276458.7899555 4088427.77223303 LICENSED AND CERTIFIED None None 050000023 OPEN CA050000023 051334 None 2014/02/19 08:00:00+00 2024/05/01 07:00:00+00 1992876767 Y Y 1 15 26JAN2023:00:00:00 None 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 None PARENT None 050000045 COMMUNITY MEMORIAL HEALTH SYSTEM ACTIVE 2000/10/01 07:00:00+00 2024/06/01 07:00:00+00 2025/05/31 07:00:00+00 NONPROFIT CORP 34.442892 -119.2644585 (-119.2644585,34.442892) None 56 VENTURA 06111 None None None None Y 2024/10/15 07:00:00+00 731
-13117208.1877126 3999670.3742672 LICENSED AND CERTIFIED None None 060001674 OPEN CA060001674 053308 None 2000/02/23 08:00:00+00 2017/02/13 08:00:00+00 1528662954 Y Y 1 15 31MAY2022:00:00:00 None 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 None PARENT None 060000530 VSC HBO, LLC ACTIVE 2000/02/04 08:00:00+00 2024/02/04 08:00:00+00 2025/02/03 08:00:00+00 LIMITED LIABILITY COMPANY 33.782769 -117.833886 (-117.833886,33.782769) None 30 ORANGE 06059 None None None None None 2024/10/15 07:00:00+00 1384
-12863303.1901777 3889997.29589787 LICENSED AND CERTIFIED None None 090000146 OPEN CA090000146 050342 None 1966/07/01 07:00:00+00 2017/07/05 07:00:00+00 1073519443 Y Y 1 15 21JUL2017:00:00:00 None 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 None PARENT None 090000087 PIONEERS MEMORIAL HEALTHCARE DISTRICT ACTIVE 1950/11/06 08:00:00+00 2024/06/30 07:00:00+00 2025/06/29 07:00:00+00 HEALTH CARE DISTRICT 32.96001101 -115.5530186 (-115.5530186,32.960011013) None 13 IMPERIAL 06025 YES None LEVEL IV None None 2024/10/15 07:00:00+00 1670
-13672157.5009581 4635709.55318746 LICENSED AND CERTIFIED None None 110000038 OPEN CA11000038 052057 None 2019/04/01 07:00:00+00 2019/11/14 08:00:00+00 1396205050 Y Y 0 15 17DEC2015:00:00:00 05MAY2020:00:00:00 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 None (707) 503-8772 590 SONOMA 11 SANTA ROSA Y None PARENT None 110000091 SONOMA SPECIALTY HOSPITAL, LLC ACTIVE 1946/01/01 08:00:00+00 2023/11/01 07:00:00+00 2024/10/31 07:00:00+00 LIMITED LIABILITY COMPANY 38.397339 -122.8190805 (-122.8190805,38.397339) None 49 SONOMA 06097 None None None None None 2024/10/15 07:00:00+00 2073
-13284717.7499567 4331090.09251898 LICENSED AND CERTIFIED None None 120001467 OPEN CA1200001467 050784 None 2019/01/30 08:00:00+00 2022/10/05 07:00:00+00 1801366711 Y Y 1 15 30JAN2022:00:00:00 None DNV GL ADVENTIST HEALTH TULARE GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 108 869 N CHERRY ST TULARE 93274 2207 KOFL, ANDREA SMITHIW@AH.ORG (559) 605-0032 (559) 366-1212 640 TULARE 12 BAKERSFIELD Y None PARENT None 120000585 ADVENTIST HEALTH TULARE ACTIVE None 2024/04/01 07:00:00+00 2025/03/31 07:00:00+00 NONPROFIT CORP 36.221121 -119.33865 (-119.33865,36.221121) None 54 TULARE 06107 YES None None None None 2024/10/15 07:00:00+00 2124
-13099095.7829839 4251314.20710461 LICENSED AND CERTIFIED None None 120000409 OPEN CA120000409 051333 None 2012/08/08 07:00:00+00 2024/07/05 07:00:00+00 1447253125 Y Y 1 15 25APR2022:00:00:00 None 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 None PARENT None 120000186 RIDGECREST REGIONAL HOSPITAL ACTIVE 1946/09/30 07:00:00+00 2023/11/01 07:00:00+00 2024/10/31 07:00:00+00 NONPROFIT CORP 35.640846 -117.6711795 (-117.6711795,35.640846) None 15 KERN 06029 YES None LEVEL IV None Y 2024/10/15 07:00:00+00 2225
-13098950.8895347 4251472.77046018 LICENSED AND CERTIFIED USE PARENT MATCH None 120000323 OPEN CA120000409 051333 None 2012/08/08 07:00:00+00 2024/07/05 07:00:00+00 1447253125 Y Y 1 15 25APR2022:00:00:00 None 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 2023/11/01 07:00:00+00 2024/10/31 07:00:00+00 NONPROFIT CORP 35.64200358 -117.6698779 (-117.6698779,35.642003579) None 15 KERN 06029 None None None None Y 2024/10/15 07:00:00+00 2879
-13280413.192227 4082171.81245296 LICENSED AND CERTIFIED USE PARENT MATCH None 630004262 OPEN CA050000023 051334 None 2014/02/19 08:00:00+00 2024/05/01 07:00:00+00 1992876767 Y Y 1 15 26JAN2023:00:00:00 None DNV GL COMMUNITY MEMORIAL HEALTH CENTER RHC PRIMARY CARE CLINIC NON-LTC 0 655 N VENTURA AVE OAK VIEW 93022 None None None None None 660 VENTURA 05 VENTURA N 050000023 OTHER CERTIFIABLE PART 01SEP2006 050000045 COMMUNITY MEMORIAL HEALTH SYSTEM ACTIVE 2000/10/01 07:00:00+00 2024/06/01 07:00:00+00 2025/05/31 07:00:00+00 NONPROFIT CORP 34.396533 -119.2999815 (-119.2999815,34.396533) None 56 VENTURA 06111 None None None None Y 2024/10/15 07:00:00+00 3717
-12756681.3151042 3976913.16496824 LICENSED AND CERTIFIED None None 250000042 OPEN CA250000042 051339 None 2023/07/20 07:00:00+00 2024/02/28 08:00:00+00 1194705202 Y Y 1 15 20JUL2023:00:00:00 None DNV GL PALO VERDE HOSPITAL GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 25 250 N 1ST ST BLYTHE 92225 1702 ANAYA, SANDRA WILLIAM.VANNOLL@PALOVERDEHOSPITAL.ORG (760) 921-5201 (760) 922-7200 430 RIVERSIDE 25 RIVERSIDE Y None PARENT None 250000184 PALO VERDE HEALTHCARE DISTRICT ACTIVE 1946/03/20 08:00:00+00 2024/01/01 08:00:00+00 2024/12/31 08:00:00+00 HEALTH CARE DISTRICT 33.612687 -114.595218 (-114.595218,33.612687) None 33 RIVERSIDE 06065 YES None None None Y 2024/10/15 07:00:00+00 3892
-13243001.4720947 4529503.56076029 LICENSED AND CERTIFIED None None 240000005 OPEN CA240000005 051303 None 2001/07/01 07:00:00+00 2018/12/31 08:00:00+00 1962444059 Y Y 1 15 27DEC2018:00:00:00 None DNV GL MAMMOTH HOSPITAL GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 17 85 SIERRA PARK RD MAMMOTH LAKES 93546 2073 PARKER, THOMAS S LINDSEY.SARULLO@MAMMOTHHOSPITAL.COM (760) 924-4104 (760) 934-3311 360 MONO 24 SAN BERNARDINO Y None PARENT None 240000008 SOUTHERN MONO HEALTH CARE DISTRICT ACTIVE 1985/08/26 07:00:00+00 2023/11/15 08:00:00+00 2024/11/14 08:00:00+00 HEALTH CARE DISTRICT 37.64575873 -118.9639063 (-118.9639063,37.64575873) None 26 MONO 06051 YES None None None Y 2024/10/15 07:00:00+00 3899
-13546431.6539235 4774439.11132742 LICENSED AND CERTIFIED None None 230000001 OPEN CA230000001 051311 None 2002/07/01 07:00:00+00 2017/08/01 07:00:00+00 1477522019 Y Y 1 15 25SEP2015:00:00:00 None DNV GL ORCHARD HOSPITAL GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 24 240 SPRUCE ST GRIDLEY 95948 2216 STARK, STEVEN L SSTARK@ORCHARDHOSPITAL.COM (530) 846-9027 (530) 846-9021 030 BUTTE 23 CHICO Y None PARENT None 230000007 ORCHARD HOSPITAL ACTIVE 1949/05/24 07:00:00+00 2023/12/01 08:00:00+00 2024/11/30 08:00:00+00 NONPROFIT CORP 39.367422 -121.689666 (-121.689666,39.367422) None 04 BUTTE 06007 None None None None Y 2024/10/15 07:00:00+00 3972
-13604147.6929541 4796599.3018993 LICENSED AND CERTIFIED None None 230000006 OPEN CA23000000006 051306 None 2001/10/23 07:00:00+00 2024/02/29 08:00:00+00 1619929759 Y Y 1 15 23DEC2021:00:00:00 None DNV GL GLENN MEDICAL CENTER GACH GENERAL ACUTE CARE HOSPITAL NON-LTC 47 1133 W SYCAMORE ST WILLOWS 95988 2601 STILL, LAUREN None (530) 934-1818 (530) 934-1800 100 GLENN 23 CHICO Y None PARENT None 230000018 GLENN MEDICAL CENTER, LLC ACTIVE 1953/07/01 07:00:00+00 2024/09/16 07:00:00+00 2024/10/31 07:00:00+00 LIMITED LIABILITY COMPANY 39.521151 -122.208138 (-122.208138,39.521151) None 11 GLENN 06021 None None None None Y 2024/10/15 07:00:00+00 3984
-13110351.3523577 3983306.596924 LICENSED AND CERTIFIED None None 630012891 OPEN CA630012891 050769 None 2010/11/19 08:00:00+00 2018/12/27 08:00:00+00 1982927877 Y Y 1 15 19NOV2021:00:00:00 None 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 None PARENT None 550001431 HOAG ORTHOPEDIC INSTITUTE, LLC ACTIVE 2010/11/10 08:00:00+00 2023/11/10 08:00:00+00 2024/11/09 08:00:00+00 LIMITED LIABILITY COMPANY 33.660504 -117.77229 (-117.77229,33.660504) None 30 ORANGE 06059 None None None None None 2024/10/15 07:00:00+00 5453
-13146902.7732012 4030818.21771955 LICENSED AND CERTIFIED None None 930000012 OPEN CA930000012 050350 None 1966/07/01 07:00:00+00 2019/08/13 07:00:00+00 None Y Y 1 15 12MAR2019:00:00:00 None 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 None (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/10/04 07:00:00+00 2024/10/31 07:00:00+00 NONPROFIT CORP 34.015014 -118.100637 (-118.100637,34.015014) None 19 LOS ANGELES 06037 YES None None None None 2024/10/15 07:00:00+00 14136
-13168053.3651325 4041950.88992692 LICENSED AND CERTIFIED None None 930000034 OPEN CA930000034 053302 None 1984/03/01 08:00:00+00 2021/08/05 07:00:00+00 1124073366 Y Y 1 15 10JUN2021:00:00:00 None 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 GOKATAHBOI@CHLA.USC.EDU (323) 361-4002 (323) 361-1690 200 LOS ANGELES 93 LA ACUTE/ANCILLARY Y None PARENT None 930000032 CHILDREN'S HOSPITAL LOS ANGELES ACTIVE 1946/01/01 08:00:00+00 2024/01/04 08:00:00+00 2024/12/31 08:00:00+00 NONPROFIT CORP 34.097868 -118.290636 (-118.290636,34.097868) None 19 LOS ANGELES 06037 None LEVEL I PED None None None 2024/10/15 07:00:00+00 14247
-13159833.9792103 4056432.64587201 LICENSED AND CERTIFIED USE PARENT MATCH None 930001555 OPEN CA930000187 050124 None 1966/07/01 07:00:00+00 2021/09/01 07:00:00+00 1033716147 Y Y 1 15 06DEC2024:00:00:00 None DNV GL VERDUGO HILLS HOSPITAL D/P APH APH ACUTE PSYCHIATRIC HOSPITAL NON-LTC 24 1812 VERDUGO BLVD GLENDALE 91208 1407 GLOSSY, BERNARD None None (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 2024/05/29 07:00:00+00 2025/05/28 07:00:00+00 NONPROFIT CORP 34.205526 -118.2168 (-118.2168,34.205526) None 19 LOS ANGELES 06037 None None None None None 2024/10/15 07:00:00+00 14554
-13187213.2306099 4054933.0082953 LICENSED AND CERTIFIED None None 930000129 OPEN CA930000129 050126 None 1966/07/01 07:00:00+00 2021/08/13 07:00:00+00 1578529285 Y Y 1 15 18AUG2020:00:00:00 None 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 None PARENT None 930000170 VALLEY PRESBYTERIAN HOSPITAL ACTIVE 1958/01/21 08:00:00+00 2024/07/01 07:00:00+00 2025/04/30 07:00:00+00 NONPROFIT CORP 34.194384 -118.462752 (-118.462752,34.194384) None 19 LOS ANGELES 06037 YES None None None None 2024/10/15 07:00:00+00 14765
-13159833.9792103 4056432.64587201 LICENSED AND CERTIFIED None None 930000187 OPEN CA930000187 050124 None 1966/07/01 07:00:00+00 2021/09/01 07:00:00+00 1033716147 Y Y 1 15 06DEC2024:00:00:00 None 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-2208 200 LOS ANGELES 93 LA ACUTE/ANCILLARY Y None PARENT None 930000173 USC VERDUGO HILLS HOSPITAL ACTIVE 1972/12/08 08:00:00+00 2024/05/29 07:00:00+00 2025/05/28 07:00:00+00 NONPROFIT CORP 34.205526 -118.2168 (-118.2168,34.205526) None 19 LOS ANGELES 06037 YES None None None None 2024/10/15 07:00:00+00 14938