Table: ccs_approved_hospitals , legal_name like H*

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
1538141627 Hanford Community Hospital Adventist Medical Hanford Limited Full 4/1/1969 None None Kings 115 Mall Drive None Hanford CA 93230-3513 (559) 582-9000
1942298153 Hayward Sisters Hospital St Rose Hosp Limited Full 3/1/1974 None None Alameda 27200 Calaroga Avenue None Hayward CA 94545-4383 (510) 264-4000
1275578817 Hazel Hawkins Mem Hosp Hazel Hawkins Mem Hosp Limited Full 6/14/1978 None None San Benito 911 Sunset Drive None Hollister CA 95023-5602 (408) 637-5711