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 4/8/2020 Sacramento 2315 Stockton Boulevard Sacramento CA 95817-2201 (916) 734-2011
1457450116 UCSF Medical Center Regents of Univ of Ca Tertiary Full 1/1/1981 San Francisco 505 Parnassus Avenue San Francisco CA 94143 (415) 476-1000
1235120676 Ukiah Adventist Hospital Adventist Health Ukiah Valle Limited Full 7/1/1997 Mendocino 275 Hospital Drive 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 Orange 101 The City Dr S Orange CA 92868-3201 (714) 456-7890