Table: ambulatory_surgery_char_by_faclty_2017 , facility_name like J*

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
106070988	070988	JOHN MUIR MEDICAL CENTER-WALNUT CREEK CAMPUS	07	Hospital	CONTRA COSTA	1601 YGNACIO VALLEY ROAD	WALNUT CREEK	94598	Non-profit Corporation (incl. Church-related)	None	None	500+	District 7	District 16	CLAYTON/CONCORD SOUTH/WALNUT CREEK CENTRAL AND EAST	Urban	NA	2723	2019	None	1	0	Hospital	276	181	339	485	731	946	956	586	217	25	None	448	240	588	127	107	3204	28	6	5	4	4641	54	None	25	3	None	None
106071018	071018	JOHN MUIR MEDICAL CENTER-CONCORD CAMPUS	07	Hospital	CONTRA COSTA	2540 EAST STREET	CONCORD	94520	Non-profit Corporation (incl. Church-related)	None	None	200-299	District 7	District 14	AVON/CLYDE/CONCORD CENTRAL/PITTSBURG SOUTHWEST	Urban	NA	3143	3559	None	1	0	Hospital	41	168	341	638	1325	1765	1661	763	None	None	None	615	416	879	119	85	4567	21	12	3	None	6626	28	None	27	4	None	None
106220733	220733	JOHN C FREMONT HEALTHCARE DISTRICT	22	Hospital	MARIPOSA	5189 HOSPITAL RD., PO BOX 216	MARIPOSA	95338	District	SMALL/RURAL	None	1-49	District 8	District 5	BOOTJACK/CATHEY¿S VALLEY/COULTERVILLE/DON PEDRO/EL PORTAL/FISH CAMP/MARIPOSA	Rural	Small/Rural	108	68	None	1	0	Hospital	None	3	3	7	66	66	24	4	None	3	None	None	None	7	None	3	164	2	None	None	None	176	None	None	None	None	None	None
106331216	331216	JOHN F KENNEDY MEMORIAL HOSPITAL	33	Hospital	RIVERSIDE	47111 MONROE STREET	INDIO	92201	Investor - Corporation	None	None	100-149	District 28	District 56	ARABIA/COACHELLA/DESERT BEACH/FLOWING WELLS/INDIO SOUTH/LA QUINTA EAST/MECCA/OASIS/THERMAL	Urban	NA	1457	1270	None	1	0	Hospital	74	216	371	436	663	543	282	101	40	1	None	14	64	1603	24	12	1001	9	3	None	None	2711	7	None	4	1	None	None