Table: ambulatory_surgery_char_by_faclty_2019 , facility_name like R*

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	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	racegrp_aman	racegrp_asian	racegrp_black	racegrp_multirace	racegrp_nhpi	racegrp_other	racegrp_unknown	racegrp_white	racegrp_inv_blank	eth_hispanic	eth_nonhispanic	eth_unknown	eth_blank_invalid	other_disp	psychiatric_care	routine	sn_ic_care	acute_care	against_medical_advice	cah
106121051	121051	REDWOOD MEMORIAL HOSPITAL	Hospital	Humboldt	3300 RENNER DR	FORTUNA	95540	Investor - Limited Liability Company	1-49	District 2	District 2	Ferndale/Fortuna/Rio Dell/Scotia	Rural	Small/Rural	1114	720	None	1	0	Hospital	32	80	134	147	337	480	404	189	31	None	None	33	13	12	5	3	128	60	1580	None	72	1631	131	None	None	None	1830	None	1	2	None
106150782	150782	RIDGECREST REGIONAL HOSPITAL	Hospital	Kern	1081 N CHINA LAKE BLVD	RIDGECREST	93555	Non-profit Corporation (incl. Church-related)	50-99	District 16	District 34	Inyokern/Ridgecrest	Rural	Small/Rural	1093	862	None	1	0	Hospital	36	126	252	237	475	448	266	109	6	None	None	12	39	68	2	10	130	54	1640	None	180	1772	3	None	None	None	1945	4	1	4	None
106190796	190796	RONALD REAGAN UCLA MEDICAL CENTER	Hospital	Los Angeles	757 WESTWOOD PLAZA	LOS ANGELES	90095	University of California	300-499	District 26	District 54	Century City/Cheviot Hills/Rancho Park/West Los Angeles/Westwood	Urban	Teaching	18205	16204	None	1	0	Hospital	1338	2327	3022	3397	5978	7502	6543	2516	1635	151	None	101	3679	2154	486	72	5292	758	21861	6	5539	28081	781	8	1	2	34315	14	38	1	None
106331312	331312	RIVERSIDE COMMUNITY HOSPITAL	Hospital	Riverside	4445 MAGNOLIA AVE	RIVERSIDE	92501	Investor - Individual	300-499	District 31	District 61	Eastside/Fairmont Park/Riverside Downtown/Rubidoux/University	Urban	NA	5413	3671	1	1	0	Hospital	158	423	791	1085	1875	2262	1715	745	31	None	None	21	380	719	688	22	2730	None	4525	None	3515	5440	130	None	24	None	8974	26	21	4	None
106334487	334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM - MEDICAL CENTER	Hospital	Riverside	26520 CACTUS AVE	MORENO VALLEY	92555	City or County	300-499	District 31	District 61	Banning/Beaumont/Cabizon/Calimesa/Cherry Valley	Urban	Teaching	3482	2930	None	1	0	Hospital	149	513	874	1219	1904	1253	354	95	46	5	None	15	144	721	27	23	177	21	5284	None	4101	2303	8	None	8	None	5939	13	6	8	None
106361308	361308	REDLANDS COMMUNITY HOSPITAL	Hospital	San Bernardino	350 TERRACINA BLVD	REDLANDS	92373	Non-profit Corporation (incl. Church-related)	200-299	District 23	District 40	Mentone/Redlands South/Yucaipa	Urban	NA	3386	2130	None	1	0	Hospital	167	277	519	778	1183	1254	898	420	20	None	None	15	149	269	49	17	1608	43	3366	None	1444	4049	23	None	None	None	5510	2	3	None	None
306364122	364122	REDLANDS DENTAL SURGERY CENTER	Clinic	San Bernardino	1180 Nevada St	Redlands	92374	Investor - Partnership	-	District 23	District 40	Colton Southeast/Grand Terrace/Loma Linda/Redlands North	Urban	NA	1366	1765	None	0	1	Clinic	351	562	516	388	467	272	57	8	503	7	None	36	84	264	29	10	681	236	1791	None	1143	1757	231	None	None	None	1712	1	None	None	None
106370673	370673	RADY CHILDREN'S HOSPITAL - SAN DIEGO	Hospital	San Diego	3020 CHILDRENS WAY	SAN DIEGO	92123	Non-profit Corporation (incl. Church-related)	500+	District 39	District 79	Bay Park/Five Points/Hillcrest Northwest/Mission Hills/Mission Valley/Morena/Normal Heights/Old Town/Serra Mesa	Urban	NA	6581	9202	1	1	0	Hospital	5681	220	19	2	None	None	None	None	9065	797	None	46	730	536	682	82	6133	55	7520	None	6852	8858	74	None	8	None	15722	5	10	None	None
106430705	430705	REGIONAL MEDICAL CENTER OF SAN JOSE	Hospital	Santa Clara	225 N JACKSON AVE	SAN JOSE	95116	Investor - Corporation	200-299	District 15	District 27	Berryessa/East San Jose/Milpitas East	Urban	NA	1778	1793	None	1	0	Hospital	85	126	177	231	494	905	995	526	32	None	None	None	1927	72	142	10	53	None	1367	None	884	2633	54	None	5	None	3543	8	8	1	None