Table: ccs_approved_hospitals , legal_name like F*

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
1316027709 Fresno Community Hospital Clovis Comm Medical Ctr Special Full 5/15/2014 None None Fresno 2755 Herndon Avenue None Clovis CA 93611-6800 (559) 324-4000
1104906569 Fresno Community Hospital Community Regional Medical Pediatric Community Full 8/23/2002 None 5/23/2017 Fresno 2823 Fresno Street None Fresno CA 93721-1324 (559) 459-6000