Table: ccs_special_care_centers , center_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  *

scc_num	center_name	scc_type	scc_effective_date	facility_status	most_recent_review_date	county	npi	provider_name	business_name	address_line_1	address_line_2	city	state	zip_code	phone
7.13.09	John Muir Medical Center Walnut Creek Campus	Community Neonatal Intensive Care Unit	3/8/2022	Full	None	Contra Costa	1740215219	John Muir Medical Center	John Muir Health	1601 Ygnacio Valley Road	None	Walnut Creek	CA	94598-3122	(415) 939-3000
7.25.37	John Muir Medical Center Walnut Creek Campus	Pediatric Intensive Care Unit	5/24/2017	Full	None	Contra Costa	1740215219	John Muir Medical Center	John Muir Health	1601 Ygnacio Valley Road	None	Walnut Creek	CA	94598-3122	(415) 939-3000
7.38.06	John Muir Medical Center Walnut Creek Campus	HRIF - Community	12/21/1990	Conditional	None	Contra Costa	1740215219	John Muir Medical Center	John Muir Health	1601 Ygnacio Valley Road	None	Walnut Creek	CA	94598-3122	(415) 939-3000
7.35.104	John Tracy Center	Communication Disorders Center Type C	5/8/2006	Full	5/23/2006	Los Angeles	1487959938	John Tracy Clinic	John Tracy Clinic	740 E Wardlow Road	None	Long Beach	CA	90807-4626	(562) 426-2257