Table: ambulatory_surgery_char_by_faclty_2017 , 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_id	facility_num	facility_name	county_code	license_type_desc	county_name	dba_address1	dba_city	dba_zip_code	control_type_desc	rural_hospital_desc	teaching_hospital_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	hispanic	other_race	unknown_race	white	american_indian_alaska_native	acute_care	against_medical_advice	rehab	routine	sn_ic_care	cah	home_health_service	hospice_care	not_defined_elsewhere	psychiatric_care
106104047	104047	FRESNO SURGICAL HOSPITAL	10	Hospital	FRESNO	6125 NORTH FRESNO STREET	FRESNO	93710	Investor - Individual	None	None	1-49	District 8	District 23	FRESNO NORTH CENTRAL	Urban	NA	4238	3310	None	1	0	Hospital	236	403	749	1190	1830	1832	988	320	None	None	None	220	254	2129	70	1	4838	36	4	None	None	7541	1	None	2	None	None	None
306105047	105047	FRESNO DENTAL SURGERY CENTER - A VALLARINE DENTAL PRACTICE	10	Clinic	FRESNO	2828 FRESNO ST	FRESNO	93721	Investor - Partnership	None	None	-	District 14	District 31	FRESNO WEST CENTRAL	Urban	NA	2353	2658	None	0	1	Clinic	47	None	None	None	None	None	None	None	4963	1	None	199	123	3226	455	11	993	4	None	None	None	5011	None	None	None	None	None	None
106190298	190298	FOOTHILL PRESBYTERIAN HOSPITAL-JOHNSTON MEMORIAL	19	Hospital	LOS ANGELES	250 SOUTH GRAND AVENUE	GLENDORA	91741	Non-profit Corporation (incl. Church-related)	None	None	100-149	District 25	District 48	ASUZA/CHARTER OAK/COVINA	Urban	NA	1806	1411	None	1	0	Hospital	39	124	165	293	761	915	600	290	30	None	None	248	88	1115	11	1	1749	5	None	None	None	3205	9	None	None	2	None	None
106301175	301175	FOUNTAIN VALLEY REGIONAL HOSPITAL & MEDICAL CENTER - EUCLID	30	Hospital	ORANGE	17100 EUCLID STREET	FOUNTAIN VALLEY	92708	Investor - Corporation	None	None	200-299	District 34	District 72	FOUNTAIN VALLEY/HUNTINGTON BEACH CENTRAL	Urban	NA	6637	5627	1	1	0	Hospital	284	657	895	1636	3711	2927	1322	671	92	70	None	5386	139	3330	862	28	2508	12	3	17	None	12101	97	None	34	4	None	1
106301357	301357	FOOTHILL REGIONAL MEDICAL CENTER	30	Hospital	ORANGE	14662 NEWPORT AVENUE	TUSTIN	92780	Investor - Corporation	None	None	150-199	District 37	District 68	CITY OF ORANGE SOUTH/SANTA ANA NORTH/TUSTIN FOOTHILLS/TUSTIN WEST	Urban	NA	388	379	None	1	0	Hospital	9	32	51	78	200	204	141	52	None	None	None	61	11	367	41	13	274	None	1	1	None	762	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	None	None	-	District 34	District 72	FOUNTAIN VALLEY/HUNTINGTON BEACH CENTRAL	Urban	NA	1480	1217	None	0	1	Clinic	180	258	264	407	726	543	197	49	73	None	None	710	50	692	186	24	1035	None	None	None	None	2697	None	None	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)	None	None	50-99	District 17	District 35	SAN LUIS OBISPO	Rural	NA	2115	2535	None	1	0	Hospital	44	124	211	313	622	1317	1247	682	89	1	None	60	49	282	43	211	3998	7	16	2	2	4558	14	None	4	None	None	1
106474007	474007	FAIRCHILD MEDICAL CENTER	47	Hospital	SISKIYOU	444 BRUCE STREET	YREKA	96097	Non-profit Corporation (incl. Church-related)	SMALL/RURAL	None	1-49	District 1	District 1	GAZELLE/GRENADA/HILT/HORNBROOK/YREKA	Rural	Small/Rural	1033	707	None	1	0	Hospital	40	87	158	146	410	494	292	103	10	None	None	17	8	74	9	38	1537	57	1	None	None	1739	None	None	None	None	None	None