Table: ccs_approved_hospitals , legal_name like U*

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  *

npi legal_name business_name facility_type facility_status start_date end_date most_recent_review_date county address_line_1 address_line_2 city state zip_code phone
1710918545 U C Davis Medical Center U C Davis Medical Center Tertiary Full 8/4/1977 None 4/8/2020 Sacramento 2315 Stockton Boulevard None Sacramento CA 95817-2201 (916) 734-2011
1457450116 UCSF Medical Center Regents of Univ of Ca Tertiary Full 1/1/1981 None None San Francisco 505 Parnassus Avenue None San Francisco CA 94143-2204 (415) 476-1000
1235120676 Ukiah Adventist Hospital Adventist Health Ukiah Valle Limited Full 7/1/1997 None None Mendocino 275 Hospital Drive None Ukiah CA 95482-4531 (707) 462-3111
1689608150 University of California University of California Irv General Community (over 14 without pediatric license) Full 6/1/1981 None None Orange 101 The City Dr S None Orange CA 92868-3201 (714) 456-7890