Table: ambulatory_surgery_char_by_faclty_2018 , facility_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  *

oshpd_id2	facility_num	facility_name	county_code	license_type_desc	county_name	dba_address1	dba_city	dba_zip_code	control_type_desc	licensed_bed_size	senate_district_desc	assembly_district_desc	mssa_name	mssa_designation	teach_rural	sex_female	sex_male	sex_unknown_invalid	hcount	ccount	license_type	age_10_19	age_20_29	age_30_39	age_40_49	age_50_59	age_60_69	age_70_79	age_80_	age_01_09	age_under_1	age_unknown	asian_pacific_islander	black	other_race	unknown_race	white	american_indian_alaska_native	invalid_blank_race	eth_hispanicl	eth_nonhispanicl	eth_unknown	eth_invalid_blank	against_medical_advice	routine	sn_ic_care	acute_care	cah	home_health_service	hospice_care	not_defined_elsewhere
106104047	104047	FRESNO SURGICAL HOSPITAL	10	Hospital	FRESNO	6125 NORTH FRESNO STREET	FRESNO	93710	Investor - Individual	1-49	District 8	District 23	FRESNO NORTH CENTRAL	Urban	NA	3869	3258	None	1	0	Hospital	200	328	660	1062	1730	1646	1090	411	None	None	None	196	219	160	None	6517	35	None	2043	5084	None	None	None	7103	1	9	None	1	None	None
306105047	105047	FRESNO DENTAL SURGERY CENTER - A VALLARINE DENTAL PRACTICE	10	Clinic	FRESNO	2828 FRESNO ST	FRESNO	93721	Investor - Partnership	-	District 14	District 31	FRESNO WEST CENTRAL	Urban	NA	2331	2506	2	0	1	Clinic	62	None	None	None	None	None	None	None	4776	1	None	59	42	1268	None	3465	5	None	4700	139	None	None	None	4839	None	None	None	None	None	None
106301175	301175	FOUNTAIN VALLEY REGIONAL HOSPITAL & MEDICAL CENTER - EUCLID	30	Hospital	ORANGE	17100 EUCLID STREET	FOUNTAIN VALLEY	92708	Investor - Corporation	200-299	District 34	District 72	FOUNTAIN VALLEY/HUNTINGTON BEACH CENTRAL	Urban	NA	4015	3387	None	1	0	Hospital	220	506	641	1153	1768	1561	881	475	106	91	None	2283	113	2750	29	2207	20	None	2279	5049	74	None	35	7263	62	7	None	26	3	None
106301357	301357	FOOTHILL REGIONAL MEDICAL CENTER	30	Hospital	ORANGE	14662 NEWPORT AVENUE	TUSTIN	92780	Investor - Corporation	150-199	District 37	District 68	CITY OF ORANGE SOUTH/SANTA ANA NORTH/TUSTIN FOOTHILLS/TUSTIN WEST	Urban	NA	618	550	None	1	0	Hospital	13	65	83	145	311	289	212	50	None	None	None	205	9	300	114	539	1	None	461	596	111	None	None	1165	3	None	None	None	None	None
306304147	304147	FOUNTAIN VALLEY SURGERY CENTER	30	Clinic	ORANGE	11190 WARNER AVENUE	FOUNTAIN VALLEY	92708	Investor - Limited Liability Company	-	District 34	District 72	FOUNTAIN VALLEY/HUNTINGTON BEACH CENTRAL	Urban	NA	1435	1125	None	0	1	Clinic	232	255	246	358	640	541	177	48	63	None	None	687	59	818	58	938	None	None	434	2076	50	None	None	2559	None	1	None	None	None	None
106400480	400480	FRENCH HOSPITAL MEDICAL CENTER	40	Hospital	SAN LUIS OBISPO	1911 JOHNSON AVENUE	SAN LUIS OBISPO	93401	Non-profit Corporation (incl. Church-related)	50-99	District 17	District 35	SAN LUIS OBISPO	Rural	NA	2478	2681	None	1	0	Hospital	53	158	290	336	727	1383	1427	702	83	None	None	43	31	300	386	4398	1	None	359	4587	213	None	1	5101	13	8	None	3	1	None
106474007	474007	FAIRCHILD MEDICAL CENTER	47	Hospital	SISKIYOU	444 BRUCE STREET	YREKA	96097	Non-profit Corporation (incl. Church-related)	1-49	District 1	District 1	GAZELLE/GRENADA/HILT/HORNBROOK/YREKA	Rural	Small/Rural	1015	751	None	1	0	Hospital	36	103	162	180	367	497	305	110	6	None	None	16	13	32	14	1626	65	None	98	1588	80	None	None	1765	None	1	None	None	None	None