COVID_HospitalBeds_CountyDemographics_NursingHomes

Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

Custom SQL query returning 29 rows (hide)

select rowid, address, lat, lng, geocode_flag, geocode_accuracy, prvdr_nmbr, prvdr_nm, prvdr_add, prvdr_city, prvdr_state, prvdr_zip, prvdr_phn, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, avg_residents, prvdr_type, [Provider Resides in Hospital], [Legal Business Name], [Date First Approved to Provide Medicare and Medicaid services], [Continuing Care Retirement Community], [Special Focus Status], [Abuse Icon], [Most Recent Health Inspection More Than 2 Years Ago], [Provider Changed Ownership in Last 12 Months], [With a Resident and Family Council], [Automatic Sprinkler Systems in All Required Areas], [Overall Rating], [Overall Rating Footnote], [Health Inspection Rating], [Health Inspection Rating Footnote], [QM Rating], [QM Rating Footnote], [Long-Stay QM Rating], [Long-Stay QM Rating Footnote], [Short-Stay QM Rating], [Short-Stay QM Rating Footnote], [Staffing Rating], [Staffing Rating Footnote], [RN Staffing Rating], [RN Staffing Rating Footnote], [Reported Staffing Footnote], [Physical Therapist Staffing Footnote], [Reported Nurse Aide Staffing Hours per Resident per Day], [Reported LPN Staffing Hours per Resident per Day], [Reported RN Staffing Hours per Resident per Day], [Reported Licensed Staffing Hours per Resident per Day], [Reported Total Nurse Staffing Hours per Resident per Day], [Reported Physical Therapist Staffing Hours per Resident Per Day], [Case-Mix Nurse Aide Staffing Hours per Resident per Day], [Case-Mix LPN Staffing Hours per Resident per Day], [Case-Mix RN Staffing Hours per Resident per Day], [Case-Mix Total Nurse Staffing Hours per Resident per Day], [Adjusted Nurse Aide Staffing Hours per Resident per Day], [Adjusted LPN Staffing Hours per Resident per Day], [Adjusted RN Staffing Hours per Resident per Day], [Adjusted Total Nurse Staffing Hours per Resident per Day], [Rating Cycle 1 Standard Survey Health Date], [Rating Cycle 1 Total Number of Health Deficiencies], [Rating Cycle 1 Number of Standard Health Deficiencies], [Rating Cycle 1 Number of Complaint Health Deficiencies], [Rating Cycle 1 Health Deficiency Score], [Rating Cycle 1 Number of Health Revisits], [Rating Cycle 1 Health Revisit Score], [Rating Cycle 1 Total Health Score], [Rating Cycle 2 Standard Health Survey Date], [Rating Cycle 2 Total Number of Health Deficiencies], [Rating Cycle 2 Number of Standard Health Deficiencies], [Rating Cycle 2 Number of Complaint Health Deficiencies], [Rating Cycle 2 Health Deficiency Score], [Rating Cycle 2 Number of Health Revisits], [Rating Cycle 2 Health Revisit Score], [Rating Cycle 2 Total Health Score], [Rating Cycle 3 Standard Health Survey Date], [Rating Cycle 3 Total Number of Health Deficiencies], [Rating Cycle 3 Number of Standard Health Deficiencies], [Rating Cycle 3 Number of Complaint Health Deficiencies], [Rating Cycle 3 Number of Health Revisits], [Rating Cycle 3 Health Deficiency Score], [Rating Cycle 3 Health Revisit Score], [Rating Cycle 3 Total Health Score], [Total Weighted Health Survey Score], [Number of Facility Reported Incidents], [Number of Substantiated Complaints], [Number of Fines], [Total Amount of Fines in Dollars], [Number of Payment Denials], [Total Number of Penalties], Location, [Processing Date] from nh_gen_info_geocoded_final where "Number of Fines" = :p0 order by [Number of Substantiated Complaints] limit 101

Query parameters

This data as json, copyable, CSV

rowid	address	lat	lng	geocode_flag	geocode_accuracy	prvdr_nmbr	prvdr_nm	prvdr_add	prvdr_city	prvdr_state	prvdr_zip	prvdr_phn	prvdr_cnty	prvdr_cnty_name	ownership	nmbr_beds	avg_residents	prvdr_type	Provider Resides in Hospital	Legal Business Name	Date First Approved to Provide Medicare and Medicaid services	Continuing Care Retirement Community	Special Focus Status	Abuse Icon	Most Recent Health Inspection More Than 2 Years Ago	Provider Changed Ownership in Last 12 Months	With a Resident and Family Council	Automatic Sprinkler Systems in All Required Areas	Overall Rating	Overall Rating Footnote	Health Inspection Rating	Health Inspection Rating Footnote	QM Rating	QM Rating Footnote	Long-Stay QM Rating	Long-Stay QM Rating Footnote	Short-Stay QM Rating	Short-Stay QM Rating Footnote	Staffing Rating	Staffing Rating Footnote	RN Staffing Rating	RN Staffing Rating Footnote	Reported Nurse Aide Staffing Hours per Resident per Day	Reported LPN Staffing Hours per Resident per Day	Reported RN Staffing Hours per Resident per Day	Reported Licensed Staffing Hours per Resident per Day	Reported Total Nurse Staffing Hours per Resident per Day	Reported Physical Therapist Staffing Hours per Resident Per Day	Case-Mix Nurse Aide Staffing Hours per Resident per Day	Case-Mix LPN Staffing Hours per Resident per Day	Case-Mix RN Staffing Hours per Resident per Day	Case-Mix Total Nurse Staffing Hours per Resident per Day	Adjusted Nurse Aide Staffing Hours per Resident per Day	Adjusted LPN Staffing Hours per Resident per Day	Adjusted RN Staffing Hours per Resident per Day	Adjusted Total Nurse Staffing Hours per Resident per Day	Rating Cycle 1 Standard Survey Health Date	Rating Cycle 1 Total Number of Health Deficiencies	Rating Cycle 1 Number of Standard Health Deficiencies	Rating Cycle 1 Number of Complaint Health Deficiencies	Rating Cycle 1 Health Deficiency Score	Rating Cycle 1 Number of Health Revisits	Rating Cycle 1 Health Revisit Score	Rating Cycle 1 Total Health Score	Rating Cycle 2 Standard Health Survey Date	Rating Cycle 2 Total Number of Health Deficiencies	Rating Cycle 2 Number of Standard Health Deficiencies	Rating Cycle 2 Number of Complaint Health Deficiencies	Rating Cycle 2 Health Deficiency Score	Rating Cycle 2 Number of Health Revisits	Rating Cycle 2 Health Revisit Score	Rating Cycle 2 Total Health Score	Rating Cycle 3 Standard Health Survey Date	Rating Cycle 3 Total Number of Health Deficiencies	Rating Cycle 3 Number of Standard Health Deficiencies	Rating Cycle 3 Number of Complaint Health Deficiencies	Rating Cycle 3 Number of Health Revisits	Rating Cycle 3 Health Deficiency Score	Rating Cycle 3 Health Revisit Score	Rating Cycle 3 Total Health Score	Total Weighted Health Survey Score	Number of Facility Reported Incidents	Number of Substantiated Complaints	Number of Fines	Total Amount of Fines in Dollars	Number of Payment Denials	Total Number of Penalties	Location	Processing Date
2941	33904 US Hwy 63, Marked Tree, AR 72365, USA	35.5266218	-90.4375834	1	ROOFTOP	45391	THREE RIVERS HEALTHCARE AND REHABILITATION	33904 HIGHWAY 63 E	MARKED TREE	AR	72365	8703582432	550	Poinsett	For profit - Limited Liability company	110	102.6	Medicare and Medicaid	false	THREE RIVERS NURSING AND REHABILITATION LLC	11/29/2003	false		false	false	false	Resident	Yes	2		2		2		4		1		2		1		2.78557	0.94506	0.22225	1.16731	3.95288	0.0426	2.15407	0.71269	0.30658	3.17335	2.68763	0.99711	0.27285	3.99438	09/27/2019	4	4	0	32	1	0	32	10/19/2018	6	2	4	52	1	0	52	2017-08-11	8	2	6	1	260	0	260	76.667	3	4	5	85802.00	0	5		02/01/2020
9625	555 16TH AVENUE SEATTLE, WA 98122	47.607477	-122.311546	0		505311	SEATTLE MEDICAL POST ACUTE CARE	555 16TH AVENUE	SEATTLE	WA	98122	2063248200	160	King	For profit - Corporation	103	88.5	Medicare and Medicaid	false	EVERGREEN WASHINGTON HEALTHCARE SEATTLE, L.L.C.	04/03/1987	false		false	false	false	Resident	Yes	1		1		3		4		3		2		1		2.97254	1.14137	0.67517	1.81654	4.78908	0.01387	2.23535	0.92034	0.84355	3.99924	2.76374	0.93254	0.30125	3.83997	03/13/2019	22	21	1	188	1	0	188	02/20/2018	17	11	6	278	1	0	278	2016-11-01	14	11	3	1	372	0	372	248.667	7	4	5	63706.00	0	5	555 16TH AVENUE SEATTLE, WA 98122 (47.607477, -122.311546)	02/01/2020
12607	316 GENERAL CAVAZOS BLVD KINGSVILLE, TX 78363	27.491227	-97.86623	0		675494	KLEBERG COUNTY NURSING AND REHABILITATION LP	316 GENERAL CAVAZOS BLVD	KINGSVILLE	TX	78363	3615929366	743	Kleberg	For profit - Partnership	146	92.9	Medicare and Medicaid	false	KLEBERG COUNTY NURSING AND REHABILITATION LP	06/07/1995	false	SFF Candidate	false	false	false	Resident	Yes	1		1		1		1		1		1		1		1.90377	1.19804	0.24042	1.43846	3.34223	0.02521	2.01566	0.80625	0.43388	3.2558	1.96296	1.11734	0.20856	3.29179	03/29/2019	24	21	6	220	1	0	220	04/28/2018	29	21	8	327	1	0	327	2017-05-26	29	19	24	1	404	0	404	286.333	3	5	5	152522.00	1	6	316 GENERAL CAVAZOS BLVD KINGSVILLE, TX 78363 (27.491227, -97.86623)	02/01/2020
1671	222 RIVER ROAD LEEDS, MA 01053	42.359791	-72.701416	0		225466	HIGHVIEW OF NORTHAMPTON	222 RIVER ROAD	LEEDS	MA	1053	4135848457	80	Hampshire	For profit - Corporation	120	92.5	Medicare and Medicaid	false	LEEDS MA SNF LLC	07/01/1990	false		false	false	false	Resident	Yes	2		1		4		4		3		4		3		2.46735	0.82767	0.50791	1.33558	3.80293	0.06603	1.78928	0.62854	0.2839	2.70172	2.86595	0.99016	0.67336	4.51367	09/20/2019	15	11	4	104	1	0	104	06/07/2018	30	19	11	302	2	151	453	2017-04-13	11	5	6	1	92	0	92	218.333	6	6	5	163741.00	0	5	222 RIVER ROAD LEEDS, MA 01053 (42.359791, -72.701416)	02/01/2020
11692	311 NORTHEAST 3RD STREET COUPEVILLE, WA 98239	48.215676	-122.681392	0		505309	CAREAGE OF WHIDBEY	311 NORTHEAST 3RD STREET	COUPEVILLE	WA	98239	3606782273	140	Island	For profit - Individual	112	54.6	Medicare and Medicaid	false	RON HAYES & ASSOCIATES INC	01/27/1987	false	SFF Candidate	true	false	false	Resident	Yes	2		1		3		3		3		4		4		2.76045	1.43443	0.66318	2.09761	4.85806	0	2.19893	0.74828	0.3229	3.2701	2.60906	1.44144	0.77304	4.76381	02/14/2019	42	40	12	540	2	270	810	01/17/2018	40	38	2	248	2	124	372	2016-10-21	29	22	7	1	216	0	216	565	9	6	5	175295.00	0	5	311 NORTHEAST 3RD STREET COUPEVILLE, WA 98239 (48.215676, -122.681392)	02/01/2020
10362	1500 3RD AVENUE LONGVIEW, WA 98632	46.137485	-122.921385	0		505276	FRONTIER REHAB & EXTENDED CARE	1500 3RD AVENUE	LONGVIEW	WA	98632	3604238800	70	Cowlitz	For profit - Corporation	140	100.6	Medicare and Medicaid	false	EVERGREEN WASHINGTON HEALTHCARE FRONTIER, L.L.C.	07/01/1983	false		false	false	false	Both	Yes	1		2		4		5		2		1	12	1	12	2.43929	0.61548	0.56833	1.18381	3.6231	0.11996	2.0703	0.75201	0.36068	3.18299	2.44876	0.61542	0.59306	3.65004	09/24/2019	26	21	5	200	1	0	200	08/13/2018	36	29	7	236	1	0	236	2017-07-18	16	13	3	1	152	0	152	204	7	7	5	116035.00	0	5	1500 3RD AVENUE LONGVIEW, WA 98632 (46.137485, -122.921385)	02/01/2020
7358	1955 S VERNON ST WABASH, IN 46992	40.778459	-85.82917	0		155810	VERNON HEALTH & REHABILITATION	1955 S VERNON ST	WABASH	IN	46992	2605638438	840	Wabash	Non profit - Corporation	119	65.3	Medicare and Medicaid	false	PUTNAM COUNTY HOSPITAL	10/12/2013	false		true	false	false	Resident	Yes	1		1		4		4			2	1	12	1	12	3.17714	0.7453	0.41295	1.15824	4.33539	0.01254	2.36635	0.90516	0.46627	3.73778	2.79045	0.61914	0.33334	3.71935	10/11/2019	9	2	7	44	1	0	44	04/26/2019	11	7	4	294	1	0	294	2018-11-15	11	8	3	1	255	0	255	162.5	9	10	5	220658.00	0	5	1955 S VERNON ST WABASH, IN 46992 (40.778459, -85.82917)	02/01/2020
5566	2475 WINNE AVE HELENA, MT 59601	46.581443	-111.99859	0		275044	BIG SKY CARE CENTER	2475 WINNE AVE	HELENA	MT	59601	4064421350	240	Lewis And Clark	For profit - Limited Liability company	108	39.6	Medicare and Medicaid	false	KISMET HLN2, LLC	09/18/1973	false	SFF Candidate	true	false	false	Resident	Yes	1		1		3		2		4		3		3		1.96163	1.01019	0.49752	1.50771	3.46934	0.04447	1.97381	0.73271	0.33678	3.0433	2.06551	1.0367	0.55603	3.65558	02/21/2019	34	23	22	311	1	0	311	12/11/2017	29	22	9	349	1	0	349	2016-12-14	9	9	0	1	60	0	60	281.833	1	15	5	209556.00	0	5	2475 WINNE AVE HELENA, MT 59601 (46.581443, -111.99859)	02/01/2020
13871	44 GOETHALS DRIVE RICHLAND, WA 99352	46.261454	-119.281667	0		505070	LIFE CARE CENTER OF RICHLAND	44 GOETHALS DRIVE	RICHLAND	WA	99352	5099431117	20	Benton	For profit - Limited Liability company	104	45.1	Medicare and Medicaid	false	RICHLAND MEDICAL INVESTORS, LLC	07/10/1979	false		false	false	false	Resident	Yes	5		3		5		5		4		4		4		2.42927	0.78134	1.06426	1.84561	4.27488	0.23764	2.20052	0.83445	0.4175	3.45247	2.29439	0.70409	0.95946	3.97052	08/29/2019	21	13	8	152	1	0	152	09/18/2018	13	6	7	80	1	0	80	2017-08-30	11	7	4	1	120	0	120	122.667	6	15	5	123232.00	1	6	44 GOETHALS DRIVE RICHLAND, WA 99352 (46.261454, -119.281667)	02/01/2020
8098	43533 ELIZABETH RD MOUNT CLEMENS, MI 48043	42.617368	-82.887711	0		235155	MARTHA T BERRY MCF	43533 ELIZABETH RD	MOUNT CLEMENS	MI	48043	5864695265	490	Macomb	Government - County	217	206.4	Medicare and Medicaid	false	COUNTY OF MACOMB	04/22/1968	false		false	false	false	Both	Yes	2		1		2		4		1		4		3		3.13098	1.3947	0.45013	1.84483	4.97581	0.01989	2.13055	0.7132	0.32412	3.16787	3.05424	1.47047	0.52271	5.03674	04/04/2019	15	14	2	104	1	0	104	02/09/2018	25	20	5	235	1	0	235	2017-05-17	24	16	8	1	346	0	346	188	13	16	5	146483.00	2	7	43533 ELIZABETH RD MOUNT CLEMENS, MI 48043 (42.617368, -82.887711)	02/01/2020
14150	1103 WEST CHEROKEE LINDSAY, OK 73052	34.837492	-97.620786	0		375206	LINDSAY NURSING & REHAB	1103 WEST CHEROKEE	LINDSAY	OK	73052	4057564334	240	Garvin	For profit - Individual	106	49.2	Medicare and Medicaid	false	LINDSAY NURSING & REHABILITATION LLC	02/01/1995	false		false	false	false	Resident	Yes	1		1		3		3			2	3		3		1.8332	0.8353	0.3904	1.22571	3.05891	0.00562	1.58452	0.61732	0.28879	2.49063	2.40452	1.01747	0.50882	3.93832	09/05/2019	6	6	0	56	1	0	56	06/27/2018	34	15	19	487	1	0	487	2017-05-01	14	3	11	1	140	0	140	213.667	1	16	5	142019.00	3	8	1103 WEST CHEROKEE LINDSAY, OK 73052 (34.837492, -97.620786)	02/01/2020
11422	2702 FARRELL ROAD SANFORD, NC 27330	35.568944	-79.125356	0		345534	SANFORD HEALTH & REHABILITATION CO	2702 FARRELL ROAD	SANFORD	NC	27330	9197769602	520	Lee	For profit - Corporation	131	117.4	Medicare and Medicaid	false	SANFORD HEALTH AND REHABILITATION CO LLC	06/08/2005	false	SFF Candidate	true	false	false	Resident	Yes	1		1		2		2		2		1		1		2.21078	0.98156	0.29411	1.27567	3.48645	0	2.21756	0.84837	0.46482	3.53075	2.07198	0.86999	0.23816	3.16643	08/08/2019	10	6	4	92	1	0	92	08/09/2018	25	14	15	508	1	0	508	2017-08-17	9	3	6	1	60	0	60	225.333	4	17	5	444928.00	2	7	2702 FARRELL ROAD SANFORD, NC 27330 (35.568944, -79.125356)	02/01/2020
7731	10040 HILLVIEW ROAD PENSACOLA, FL 32514	30.540282	-87.217787	0		105445	UNIVERSITY HILLS HEALTH AND REHABILITATION	10040 HILLVIEW ROAD	PENSACOLA	FL	32514	8504740570	160	Escambia	For profit - Corporation	120	110	Medicare and Medicaid	false	10040 HILLVIEW ROAD OPERATIONS LLC	01/03/1984	false	SFF Candidate	false	false	false	Both	Yes	1		1		4		3		5		3		2		2.65994	0.92309	0.41513	1.33822	3.99816	0.04889	1.85148	0.67801	0.32229	2.85177	2.98586	1.02375	0.48481	4.49572	04/19/2019	22	10	12	200	2	100	300	04/27/2018	8	8	0	32	1	0	32	2017-05-11	14	4	10	1	140	0	140	184	1	19	5	236871.00	3	8	10040 HILLVIEW ROAD PENSACOLA, FL 32514 (30.540282, -87.217787)	02/01/2020
9512	820 NORTHWEST 95TH STREET SEATTLE, WA 98117	47.697847	-122.367086	0		505042	BALLARD CENTER	820 NORTHWEST 95TH STREET	SEATTLE	WA	98117	2067820100	160	King	For profit - Corporation	142	116	Medicare and Medicaid	false	SUNBRIDGE HEALTHCARE LLC	01/01/1967	false	SFF Candidate	false	false	false	Resident	Yes	2		1		4		3		4		4		4		2.2273	0.43912	0.9109	1.35002	3.57732	0.08494	2.09438	0.71577	0.33344	3.14358	2.21024	0.46131	1.02823	3.64911	11/07/2018	39	32	10	530	1	0	530	11/03/2017	30	24	6	338	1	0	338	2016-08-04	19	13	6	1	140	0	140	401	10	19	5	138415.00	0	5	820 NORTHWEST 95TH STREET SEATTLE, WA 98117 (47.697847, -122.367086)	02/01/2020
7899	5211 MARSH RD OKEMOS, MI 48864	42.732497	-84.41105	0		235647	MEDILODGE OF OKEMOS	5211 MARSH RD	OKEMOS	MI	48864	5173191400	320	Ingham	For profit - Limited Liability company	100	66.5	Medicare and Medicaid	false	OKEMOS OPCO LLC	10/09/2009	false		false	false	false	Resident	Yes	2		1		4		4		5		5		5		2.62852	0.69587	1.40245	2.09832	4.72683	0.0713	2.10324	0.73004	0.34679	3.18007	2.5974	0.71675	1.52211	4.76636	03/13/2019	22	18	6	148	1	0	148	01/19/2018	28	17	15	204	1	0	204	2016-10-27	20	16	4	2	148	74	222	179	8	21	5	112906.00	0	5	5211 MARSH RD OKEMOS, MI 48864 (42.732497, -84.41105)	02/01/2020
10251	414 S UNIVERSITY RD SPOKANE, WA 99206	47.652768	-117.261386	0		505114	GARDENS ON UNIVERSITY, THE	414 S UNIVERSITY RD	SPOKANE	WA	99206	5099244650	310	Spokane	For profit - Corporation	124	104.5	Medicare and Medicaid	false	GARDENS ON UNIVERSITY - SPOKANE VALLEY, LLC	01/06/1967	false		true	false	false	Resident	Yes	2		1		4		4		4		4		4		2.0309	0.56985	0.92009	1.48994	3.52084	0.09659	2.02667	0.7383	0.37048	3.13544	2.08268	0.58038	0.93474	3.60081	09/27/2019	43	32	15	328	1	0	328	11/19/2018	41	25	18	252	2	126	378	2018-01-17	47	33	16	1	454	0	454	365.667	18	24	5	113957.00	1	6	414 S UNIVERSITY RD SPOKANE, WA 99206 (47.652768, -117.261386)	02/01/2020
13212	430 LILLY ROAD NORTHEAST OLYMPIA, WA 98506	47.053145	-122.844368	0		505243	OLYMPIA TRANSITIONAL CARE AND REHABILITATION	430 LILLY ROAD NORTHEAST	OLYMPIA	WA	98506	3604919700	330	Thurston	For profit - Corporation	135	81.4	Medicare and Medicaid	false	WOODARD CREEK HEALTHCARE INC	07/07/1976	false		false	false	false	Resident	Yes	1		1		2		2		2		3		3		2.42878	1.05415	0.55354	1.60769	4.03648	0.06538	2.11565	0.77913	0.39668	3.29146	2.38595	1.01736	0.52522	3.93248	09/09/2019	13	10	3	68	1	0	68	10/09/2018	32	22	11	192	1	0	192	2017-12-15	44	29	24	1	869	0	869	242.833	12	25	5	226646.00	0	5	430 LILLY ROAD NORTHEAST OLYMPIA, WA 98506 (47.053145, -122.844368)	02/01/2020
4164	621 W 21st St, Andover, KS 67002, USA	37.72251	-97.1414099	1	ROOFTOP	175157	LIFE CARE CENTER OF ANDOVER	621 W 21ST, PO BOX 100	ANDOVER	KS	67002	3167331349	70	Butler	For profit - Corporation	154	76.8	Medicare and Medicaid	false	ANDOVER MEDICAL INVESTORS, LLC	10/31/1986	true	SFF	false	false	false	Resident	Yes		18		18		18		18		18		18		18	2.13408	0.98012	0.32956	1.30968	3.44377	0.14483	2.04491	0.73652	0.3436	3.12503	2.16897	1.00064	0.36101	3.53372	02/07/2019	41	26	22	434	2	217	651	03/06/2018	32	26	15	256	1	0	256	2016-09-06	36	27	9	2	364	182	546	501.833	3	28	5	350261.00	1	6		02/01/2020
10777	16357 AURORA AVENUE NORTH SHORELINE, WA 98133	47.748091	-122.345577	0		505214	THE OAKS AT FOREST BAY	16357 AURORA AVENUE NORTH	SHORELINE	WA	98133	2065423103	160	King	For profit - Limited Liability company	90	64	Medicare and Medicaid	false	AURORA OAKS LLC	09/01/1971	false	SFF Candidate	true	false	false	Resident	Yes	2		1		4		3		4		4		4		2.05148	0.62997	0.81384	1.44382	3.4953	0.01319	2.06115	0.71059	0.33244	3.10418	2.06859	0.66663	0.92143	3.61069	03/11/2019	47	38	17	558	2	279	837	01/25/2018	53	39	14	562	1	0	562	2017-02-24	27	16	11	1	439	0	439	679	18	28	5	111142.00	0	5	16357 AURORA AVENUE NORTH SHORELINE, WA 98133 (47.748091, -122.345577)	02/01/2020
11523	1116 E LAURIDSEN BOULEVARD PORT ANGELES, WA 98362	48.103507	-123.4195	0		505185	CRESTWOOD HEALTH AND REHABILITATION CENTER	1116 E LAURIDSEN BOULEVARD	PORT ANGELES	WA	98362	3604529206	40	Clallam	For profit - Limited Liability company	101	81.9	Medicare and Medicaid	false	CRESTWOOD CONVALESCENT - PORT ANGELES, LLC	07/18/1968	false		true	false	false	Resident	Yes	1		1		2		3		2		3		4		1.64091	0.45856	0.91395	1.37251	3.01342	0.06162	2.13707	0.76449	0.39305	3.29462	1.59581	0.45104	0.87519	2.93297	03/28/2019	46	31	15	284	1	0	284	05/08/2018	30	13	17	276	1	0	276	2017-03-15	10	7	3	1	112	0	112	252.667	15	32	5	124077.00	1	6	1116 E LAURIDSEN BOULEVARD PORT ANGELES, WA 98362 (48.103507, -123.4195)	02/01/2020
6849	309 RAILROAD STREET HULL, IA 51239	43.186844	-96.143408	0		165248	PLEASANT ACRES CARE CENTER	309 RAILROAD STREET	HULL	IA	51239	7124392758	830	Sioux	For profit - Corporation	60	42.5	Medicare and Medicaid	false	PREMIER ESTATES 505, LLC	01/01/1995	false	SFF Candidate	false	false	false	Both	Yes	1		1		3		3		4		3		4		1.89848	0.23222	0.67873	0.91096	2.80944	0.01788	1.88515	0.65432	0.31708	2.85655	2.09303	0.26687	0.80568	3.15378	10/24/2019	22	18	6	187	1	0	187	08/16/2018	27	8	19	140	1	0	140	2017-05-11	16	2	14	1	175	0	175	169.333	8	34	5	140200.00	2	7	309 RAILROAD STREET HULL, IA 51239 (43.186844, -96.143408)	02/01/2020
10905	21400 72ND AVENUE WEST EDMONDS, WA 98026	47.804558	-122.330144	0		505236	ALDERCREST HEALTH & REHAB CENTER	21400 72ND AVENUE WEST	EDMONDS	WA	98026	4257751961	300	Snohomish	For profit - Corporation	128	86	Medicare and Medicaid	false	ALDERCREST HEALTH - EDMONDS, LLC	08/01/1977	false		true	false	false	Resident	Yes	1		1		2		2		2		3		3		1.59608	1.16099	0.63838	1.79937	3.39545	0.02935	2.1984	0.75566	0.36009	3.31415	1.50891	1.15528	0.66726	3.28532	09/13/2019	40	25	16	280	1	0	280	07/19/2018	27	20	9	180	2	90	270	2017-08-02	26	16	13	1	208	0	208	264.667	14	37	5	130469.00	0	5	21400 72ND AVENUE WEST EDMONDS, WA 98026 (47.804558, -122.330144)	02/01/2020
188	3200 STATE ST SAGINAW, MI 48602	43.436632	-83.985897	0		235250	SAMARITAS SENIOR LIVING SAGINAW	3200 STATE ST	SAGINAW	MI	48602	9897991902	720	Saginaw	Non profit - Church related	98	58.8	Medicare and Medicaid	false	SAMARITAS - LUTHERAN SOCIAL SERVICES OF MICHIGAN	12/01/1975	false	SFF Candidate	true	false	false	Resident	Yes	1		1		2		1		4		3		2		2.56619	1.3568	0.44244	1.79924	4.36543	0.09823	2.135	0.79244	0.39171	3.31915	2.49808	1.28745	0.42513	4.21748	04/25/2019	30	17	14	307	1	0	307	06/06/2018	24	10	14	359	2	180	539	2017-03-23	25	15	11	1	188	0	188	364.5	28	39	5	191846.00	2	7	3200 STATE ST SAGINAW, MI 48602 (43.436632, -83.985897)	02/01/2020
6006	1901 N TELEGRAPH RD WATERFORD, MI 48328	42.667677	-83.328788	0		235260	REGENCY AT WATERFORD	1901 N TELEGRAPH RD	WATERFORD	MI	48328	2488361000	620	Oakland	For profit - Corporation	150	135	Medicare and Medicaid	false	NORTHERN OAK MANAGEMENT COMPANY, LLC	01/01/1976	false		false	false	false	Both	Yes	2		1		4		4		4		4		4		2.22503	0.9856	0.86901	1.85462	4.07964	0.16339	2.19748	0.76145	0.3489	3.30783	2.10439	0.97329	0.93748	3.95487	03/20/2019	17	13	6	156	1	0	156	03/08/2018	23	17	11	207	1	0	207	2017-02-02	17	12	8	1	148	0	148	171.667	3	43	5	42988.00	1	6	1901 N TELEGRAPH RD WATERFORD, MI 48328 (42.667677, -83.328788)	02/01/2020
8355	750 FULLER AVE NE GRAND RAPIDS, MI 49503	42.976109	-85.639838	0		235075	SPECTRUM HEALTH REHAB & NURSING CENTER-FULLER AVE	750 FULLER AVE NE	GRAND RAPIDS	MI	49503	6164863001	400	Kent	Non profit - Corporation	250	195.6	Medicare and Medicaid	true	SPECTRUM HEALTH HOSPITALS	01/03/1967	false		false	false	false	Resident	Yes	3		2		3		2		4		5		5		2.80919	1.00551	1.18789	2.19339	5.00258	0.2847	2.05067	0.70146	0.32525	3.07738	2.84709	1.07787	1.37464	5.21274	10/30/2019	18	8	10	116	0	0	116	08/30/2018	20	17	4	136	1	0	136	2017-10-12	29	11	19	1	260	0	260	146.667	40	47	5	166739.00	2	7	750 FULLER AVE NE GRAND RAPIDS, MI 49503 (42.976109, -85.639838)	02/01/2020
1359	4220 S HOSPITAL DR EAST CHINA, MI 48054	42.784762	-82.480005	0		235370	MEDILODGE OF ST CLAIR	4220 S HOSPITAL DR	EAST CHINA	MI	48054	8103294736	730	St. Clair	For profit - Corporation	172	119.8	Medicare and Medicaid	false	ST. CLAIR OPCO, LLC	11/01/1978	false		false	false	false	Resident	Yes	2		2		4		4		4		3		3		2.0244	0.90788	0.49426	1.40214	3.42654	0.04455	1.96803	0.73544	0.35288	3.05635	2.13786	0.92825	0.52717	3.59505	10/30/2019	16	7	11	108	1	0	108	12/20/2018	14	7	7	92	1	0	92	2017-09-20	24	6	19	1	196	0	196	117.333	10	58	5	81548.00	0	5	4220 S HOSPITAL DR EAST CHINA, MI 48054 (42.784762, -82.480005)	02/01/2020
5268	2121 WEST 19TH STREET SIOUX CITY, IA 51103	42.510173	-96.435929	0		165174	CASA DE PAZ HEALTH CARE CENTER	2121 WEST 19TH STREET	SIOUX CITY	IA	51103	7122333127	960	Woodbury	For profit - Corporation	71	48	Medicare and Medicaid	false	PREMIER ESTATES 510, LLC	10/28/1992	false	SFF Candidate	false	false	false	Resident	Yes	1		1		2		1		3		3		4		1.62509	0.6385	0.89818	1.53668	3.16178	0.05624	1.88735	0.7703	0.39473	3.05239	1.78954	0.62328	0.85643	3.32158	09/10/2019	13	9	7	123	1	0	123	06/21/2018	30	9	21	368	1	0	368	2017-04-20	25	5	25	1	392	0	392	249.5	2	58	5	201452.00	1	6	2121 WEST 19TH STREET SIOUX CITY, IA 51103 (42.510173, -96.435929)	02/01/2020
1521	14151 E 15 MILE RD STERLING HEIGHTS, MI 48312	42.552546	-82.981815	0		235263	MEDILODGE OF STERLING HEIGHTS	14151 E 15 MILE RD	STERLING HEIGHTS	MI	48312	5869390200	490	Macomb	For profit - Limited Liability company	283	242.5	Medicare and Medicaid	false	STERLING HEIGHTS OPCO LLC	05/01/1976	false		false	false	false	Resident	Yes	1		1		3		4		3		3		3		1.86467	0.90056	0.4366	1.33716	3.20183	0.03654	1.96302	0.66726	0.30712	2.9374	1.97421	1.01485	0.53507	3.49533	08/22/2019	38	20	21	367	1	0	367	09/21/2018	14	6	9	128	1	0	128	2017-07-26	43	18	33	2	514	257	771	354.667	19	89	5	273521.00	1	6	14151 E 15 MILE RD STERLING HEIGHTS, MI 48312 (42.552546, -82.981815)	02/01/2020
7811	26505 POWERS AVE DEARBORN HEIGHTS, MI 48125	42.272116	-83.298344	0		235514	IMPERIAL, A VILLA CENTER	26505 POWERS AVE	DEARBORN HEIGHTS	MI	48125	3132916200	810	Wayne	For profit - Corporation	265	232	Medicare and Medicaid	false	DETROIT NURSING CENTER LLC	03/13/1992	false		true	false	false	Resident	Yes	1		1		3		2		4		2		3		1.22472	0.95429	0.41426	1.36855	2.59327	0.03959	1.88983	0.68062	0.29935	2.8698	1.34688	1.05429	0.52087	2.89767	08/08/2019	32	17	18	212	1	0	212	09/14/2018	16	9	10	100	1	0	100	2017-06-21	21	13	11	1	132	0	132	161.333	7	92	5	142113.00	1	6	26505 POWERS AVE DEARBORN HEIGHTS, MI 48125 (42.272116, -83.298344)	02/01/2020