Table: ccs_approved_hospitals , legal_name like G*

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
1730171265 Garfield Medical Center Ahmc Garfield Med Ctr Lp Pediatric Community Full 12/2/1997 None None Los Angeles 525 N Garfield Avenue None Monterey Park CA 91754-1205 (626) 943-4100
1831188275 Glendale Adventist Med Glendale Adventist Med Special Full 1/19/1994 None None Los Angeles 1509 Wilson Ter None Glendale CA 91206-4007 (818) 409-8000
1376595777 Good Samaritan Hosp, Lp Good Samaritan Hosp, Lp Pediatric Community Full 1/1/1979 None 2/18/2016 Santa Clara 2425 Samaritan Drive None San Jose CA 95124-3985 (702) 855-1022
1528041811 Grossmont Hospital Corporati Grossmont Hosp Corp General Community (over 14 without pediatric license) Full 11/15/1959 None None San Diego 5555 Grossmont Center Drive None La Mesa CA 91942-3019 (619) 465-0711