Table: ccs_approved_hospitals , legal_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  *

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
1710065933	Radys Childrens Hospital	Rady Children's Hosp	Tertiary	Full	1/1/1954	None	None	San Diego	3020 Childrens Way	None	San Diego	CA	92123-4223	(858) 576-1700
1801803705	Rancho Los Amigos	National Rehab Ctr	Special	Full	1/1/1980	None	None	Los Angeles	7601 E Imperial Highway	None	Downey	CA	90242-3456	(562) 401-7022
1316081482	Redlands Community Hosp	Redlands Community Hosp	Standard	Full	8/1/1983	None	None	San Bernardino	350 Terracina Boulevard	None	Redlands	CA	92373-4897	(714) 793-3101
1184722779	Regents of The Univ Ca	UCSD Medical Center	General Community (over 14 without pediatric license)	Provisional	5/5/1982	None	7/1/2010	San Diego	200 W Arbor Drive	None	San Diego	CA	92103-1911	(619) 543-6060
1902803315	Regents of The University of	Ronald Reagan UCLA Med	Tertiary	Full	8/1/1962	None	9/25/2015	Los Angeles	757 Westwood Plaza	None	Los Angeles	CA	90095-8358	(310) 825-8021
1427055839	Regents University of	Santa Monica-UCLA Medical	Pediatric Community	Full	3/21/2017	None	None	Los Angeles	1250 16th Street	None	Santa Monica	CA	90404-1249	(310) 319-4000
1124098421	Renown Regional Med Ctr	Renown Regional Med Ctr	Standard	Full	1/1/1979	None	None	None	1155 Mill Street	None	Reno	NV	89502-1474	(775) 982-4100
1720088354	Rideout Memorial Hospital	Adventist Health And Rideout	Special	Full	12/19/2022	None	12/19/2022	Yuba	726 4th Street	None	Marysville	CA	95901-5656	(916) 749-4300
1447253125	Ridgecrest Regional Hospital	Ridgecrest Regional Hospital	Limited	Full	11/1/1976	None	None	Kern	1081 N China Lake Boulevard	None	Ridgecrest	CA	93555-3130	(760) 446-3551
1336186394	Riverside Healthcare Sys	Riverside Community Hosp	Pediatric Community	Full	5/17/2004	None	None	Riverside	4445 Magnolia Avenue	None	Riverside	CA	92501-4135	(702) 855-1022