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 18 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 "Automatic Sprinkler Systems in All Required Areas" = :p0 order by rowid 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	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	Health Inspection Rating	QM Rating	Long-Stay QM Rating	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 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 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	Total Number of Penalties	Location	Processing Date
1885	66 CENTRAL STREET EAST BRIDGEWATER, MA 02333	42.031178	-70.957678	0		225322	SACHEM CENTER FOR HEALTH & REHABILITATION	66 CENTRAL STREET	EAST BRIDGEWATER	MA	2333	5083787227	150	Plymouth	For profit - Partnership	111	103.6	Medicare and Medicaid	false	VK EAST BRIDGEWATER LLC	01/31/1989	false	false	false	false	Resident	Partial	2	2	4	3	5		3		4		1.97058	0.64152	0.69481	1.33633	3.30691	0.05723	2.04778	0.6683	0.31905	3.03512	1.99998	0.72181	0.81968	3.49381	07/25/2019	10	10	0	44	1	44	04/27/2018	14	14	2	72	1	72	2017-01-17	9	9	0	1	44	0	44	53.333	0	2	1	64194.00	1	66 CENTRAL STREET EAST BRIDGEWATER, MA 02333 (42.031178, -70.957678)	02/01/2020
2204	6450 MIAMI CIR SOUTH BEND, IN 46614	41.60565	-86.232977	0		155684	SOUTHFIELD VILLAGE	6450 MIAMI CIR	SOUTH BEND	IN	46614	5742311000	700	St. Joseph	Government - County	60	55.2	Medicare and Medicaid	false	WOODLAWN HOSPITAL	12/28/2000	true	false	false	false	Resident	Partial	1	1	4	3	5		3		3		2.58171	0.81069	0.7301	1.54079	4.1225	0.08341	2.18924	0.78794	0.40162	3.3788	2.45092	0.77365	0.68422	3.91247	04/01/2019	6	6	0	24	1	24	02/08/2018	6	6	0	28	1	28	2017-03-21	8	4	7	1	463	0	463	98.5	0	3	1	58795.00	1	6450 MIAMI CIR SOUTH BEND, IN 46614 (41.60565, -86.232977)	02/01/2020
3137	51 HOSPITAL ROAD BALDWINVILLE, MA 01436	42.610648	-72.061581	0		225388	ALLIANCE HEALTH AT BALDWINVILLE	51 HOSPITAL ROAD	BALDWINVILLE	MA	1436	9789392196	170	Worcester	Non profit - Corporation	94	89.8	Medicare and Medicaid	false	THE HOSPITAL COTTAGES FOR CHILDREN	07/01/1990	false	false	false	false	Resident	Partial	5	5	4	4	3		3		3		1.82884	0.80668	0.46654	1.27323	3.10206	0.05283	2.09806	0.66908	0.30689	3.07403	1.81164	0.90658	0.5722	3.23591	04/24/2019	3	3	0	12	1	12	02/06/2018	1	1	0	4	1	4	2016-11-14	3	3	0	1	16	0	16	10	0	0	0	0.00	0	51 HOSPITAL ROAD BALDWINVILLE, MA 01436 (42.610648, -72.061581)	02/01/2020
4083	1051 BRIGHTSEAT ROAD LANDOVER, MD 20785	38.905084	-76.853481	0		215364	FUTURE CARE CAPITAL REGION	1051 BRIGHTSEAT ROAD	LANDOVER	MD	20785	2404874400	160	Prince Georges	For profit - Corporation	150	126.2	Medicare and Medicaid	false	PRINCE GEORGES POST ACUTE LLC	05/01/2018	false	false	false	false	Resident	Partial	5	4	5	4	5		4		4		2.38351	0.95187	1.77362	2.72549	5.10899	0.2057	2.31092	1.01568	0.69207	4.01867	2.14362	0.7047	0.96458	4.07668	08/15/2019	10	9	1	60	1	60	04/27/2018	2	2	0	8	1	8		.	.	.	.	.	.	.	39.2	0	3	0	0.00	0	1051 BRIGHTSEAT ROAD LANDOVER, MD 20785 (38.905084, -76.853481)	02/01/2020
6409	64 PERFORMANCE DRIVE WEYMOUTH, MA 02189	42.196957	-70.942549	0		225634	CARE ONE AT WEYMOUTH	64 PERFORMANCE DRIVE	WEYMOUTH	MA	2189	7813409800	130	Norfolk	For profit - Corporation	154	131	Medicare and Medicaid	false	64 PERFORMANCE DRIVE OPERATING COMPANY, LLC	05/05/1994	false	false	false	false	Resident	Partial	4	4	3	3	2		3		3		2.08842	0.87544	0.60446	1.47989	3.56831	0.07691	2.1172	0.7621	0.34831	3.22761	2.05009	0.86377	0.65318	3.54516	02/20/2019	3	3	0	12	1	12	10/25/2017	10	10	0	48	1	48	2016-09-14	4	3	1	1	16	0	16	24.667	1	0	0	0.00	0	64 PERFORMANCE DRIVE WEYMOUTH, MA 02189 (42.196957, -70.942549)	02/01/2020
8300	340 MOTAGUE CITY ROAD TURNERS FALLS, MA 01376	42.585979	-72.575836	0		225527	FARREN CARE CENTER	340 MOTAGUE CITY ROAD	TURNERS FALLS	MA	1376	4137743111	60	Franklin	Non profit - Corporation	122	107.5	Medicare and Medicaid	false	TRINITY CONTINUING CARE SERVICES - MASSACHUSETTS	10/16/1990	false	false	false	false	Resident	Partial	3	3	1	2	1		5		5		2.72236	1.02845	0.81233	1.84078	4.56314	0.00663	2.17533	0.62321	0.28618	3.08472	2.60097	1.24089	1.06838	4.74352	02/20/2019	6	5	1	24	1	24	10/31/2017	7	5	2	99	1	99	2016-09-27	2	0	2	0	8	0	8	46.333	1	1	1	24746.00	1	340 MOTAGUE CITY ROAD TURNERS FALLS, MA 01376 (42.585979, -72.575836)	02/01/2020
9169	100 ROGERS LANE SHELBY, OH 44875	40.870172	-82.651757	0		365331	SHELBY POINTE, INC	100 ROGERS LANE	SHELBY	OH	44875	4193471313	710	Richland	For profit - Corporation	45	38.3	Medicare and Medicaid	false	SHELBY POINTE LLC	03/08/1976	false	false	false	false	Both	Partial	4	5	3	3		2	1		1		2.16596	0.96617	0.32853	1.29471	3.46066	0.02752	2.00754	0.86876	0.46616	3.34246	2.24235	0.83625	0.26526	3.32006	02/28/2019	1	1	0	4	1	4	01/05/2018	2	2	0	8	1	8	2016-10-13	7	7	0	1	32	0	32	10	0	0	0	0.00	0	100 ROGERS LANE SHELBY, OH 44875 (40.870172, -82.651757)	02/01/2020
9225	3416 COLUMBUS AVE SANDUSKY, OH 44870	41.418483	-82.689489	0		366325	OHIO VETERANS HOME	3416 COLUMBUS AVE	SANDUSKY	OH	44870	4196252454	220	Erie	Government - State	427	389.7	Medicare and Medicaid	false	Legal Business Name Not Available	10/01/2006	false	false	false	false	Both	Partial	3	3	3	5	2		3		3		1.9396	1.23849	0.41556	1.65406	3.59366	0.01295	1.85829	0.6299	0.27008	2.75827	2.16927	1.47845	0.57913	4.17785	10/24/2019	5	5	0	52	1	52	09/13/2018	3	3	0	12	1	12	2017-07-27	6	1	5	1	44	0	44	37.333	2	2	1	6500.00	1	3416 COLUMBUS AVE SANDUSKY, OH 44870 (41.418483, -82.689489)	02/01/2020
9251	303 RHODES AVENUE WOONSOCKET, RI 02895	42.005585	-71.533652	0		415044	FRIENDLY HOME INC THE	303 RHODES AVENUE	WOONSOCKET	RI	2895	4017697220	30	Providence	For profit - Corporation	126	123.2	Medicare and Medicaid	false	FRIENDLY HOME INC	06/01/1979	false	false	false	false	Resident	Partial	5	4	5	5	5		4		4		2.65577	0.37044	0.70246	1.07291	3.72868	0.01972	1.99968	0.65036	0.30699	2.95703	2.76023	0.42831	0.86126	4.04345	07/11/2019	0	0	0	0	0	0	09/20/2018	2	2	0	8	1	8	2017-07-13	0	0	0	0	0	0	0	2.667	0	0	0	0.00	0	303 RHODES AVENUE WOONSOCKET, RI 02895 (42.005585, -71.533652)	02/01/2020
10255	3086 GLOVER STREET GLOVER, VT 05839	44.704807	-72.188309	0		475036	UNION HOUSE NURSING HOME	3086 GLOVER STREET	GLOVER	VT	5839	8025256600	90	Orleans	For profit - Partnership	44	42.6	Medicare and Medicaid	false	UNION HOUSE NURSING HOME, INC	07/01/1991	false	false	false	false	Resident	Partial	5	5	2	2		2	3		3		2.02526	0.94965	0.57481	1.52446	3.54971	0.03794	2.12774	0.78608	0.41157	3.32539	1.97823	0.90841	0.52566	3.42297	07/31/2019	0	0	0	0	0	0	09/12/2018	0	0	0	0	0	0	2017-07-25	0	0	0	0	0	0	0	0	0	0	0	0.00	0	3086 GLOVER STREET GLOVER, VT 05839 (44.704807, -72.188309)	02/01/2020
10613	2440 BATON ROUGE AVENUE LIMA, OH 45805	40.771872	-84.145427	0		365936	LIBERTY RETIREMENT COMMUNITY OF LIMA INC	2440 BATON ROUGE AVENUE	LIMA	OH	45805	4193312273	10	Allen	For profit - Individual	95	46.1	Medicare and Medicaid	false	LIBERTY RETIREMENT COMMUNITY OF LIMA INC	12/01/1993	false	false	false	false	Resident	Partial	1	1	2	4	1		2		1		2.85599	0.88146	0.54747	1.42893	4.28492	0.03288	2.02437	0.89738	0.73961	3.66136	2.93214	0.73859	0.27861	3.75279	10/31/2019	16	12	4	108	1	108	09/20/2018	27	9	18	128	1	128	2017-07-13	13	10	12	1	72	0	72	108.667	1	14	1	11700.00	1	2440 BATON ROUGE AVENUE LIMA, OH 45805 (40.771872, -84.145427)	02/01/2020
11866	1020 Oak Ln, Philadelphia, PA 19126, USA	40.0545249	-75.1354291	1	ROOFTOP	395535	LAUREL SQUARE HEALTHCARE AND REHABILITATION CENTER	1020 OAK LANE AVENUE	PHILADELPHIA	PA	19126	2152249898	620	Philadelphia	For profit - Partnership	87	80.6	Medicare and Medicaid	false	LAUREL SQUARE HEALTHCARE AND REHABILITATION CENTER, LLC	06/21/1982	false	false	false	false	Resident	Partial	2	1	5	5	3		2		2		2.35012	0.75563	0.52308	1.27872	3.62884	0.07199	2.12207	0.77056	0.39862	3.29125	2.30169	0.73738	0.4939	3.53558	12/13/2018	24	24	0	164	1	164	11/01/2017	4	4	4	32	1	32	2017-01-12	3	3	0	1	20	0	20	96	0	0	0	0.00	0		02/01/2020
12021	160 EAST MAIN STREET PORT JERVIS, NY 12771	41.367766	-74.682593	0		335692	ST JOSEPHS PLACE	160 EAST MAIN STREET	PORT JERVIS	NY	12771	8458565351	540	Orange	Non profit - Church related	46	44.6	Medicare and Medicaid	true	BON SECOURS COMMUNITY HOSPITAL	04/11/1988	false	false	false	false	Both	Partial	4	4	4	4	4		3		4		1.69352	0.82776	0.94824	1.776	3.46952	0	2.26591	0.7241	0.35658	3.3466	1.55333	0.85958	1.00089	3.32444	06/07/2019	4	4	0	12	1	12	08/24/2017	0	0	0	0	0	0	2016-06-30	2	2	0	1	8	0	8	7.333	0	0	0	0.00	0	160 EAST MAIN STREET PORT JERVIS, NY 12771 (41.367766, -74.682593)	02/01/2020
12036	60 EASTER AVE WEAVERVILLE, CA 96093	40.737579	-122.939444	0		555907	TRINITY HOSPITAL SKILLED NURSING FACILITY	60 EASTER AVE	WEAVERVILLE	CA	96093	5306235541	630	Trinity	Government - Hospital district	23	11.7	Medicare and Medicaid	true	MOUNTAIN COMMUNITIES HEALTHCARE DISTRICT	09/26/2017	false	false	false	false	Resident	Partial	2	4	1	1		2	1	12	1	12	3.00859	2.13626	0.96054	3.0968	6.10539	0	1.92698	0.65272	0.2724	2.8521	3.2449	2.46099	1.32722	6.86439	08/28/2019	10	9	1	32	1	32	10/03/2018	7	7	7	40	1	40	2017-07-12	2	2	0	2	12	6	18	32.333	3	0	0	0.00	0	60 EASTER AVE WEAVERVILLE, CA 96093 (40.737579, -122.939444)	02/01/2020
14803	875 JERUSALEM AVENUE UNIONDALE, NY 11553	40.697401	-73.585634	0		335023	A HOLLY PATTERSON EXTENDED CARE FACILITY	875 JERUSALEM AVENUE	UNIONDALE	NY	11553	5165721400	400	Nassau	Government - State	589	467.5	Medicare and Medicaid	true	NASSAU HEALTH CARE CORPORATION	01/01/1967	false	false	false	false	Both	Partial	5	5	5	5	3		3		3		1.95729	0.61638	0.55886	1.17523	3.13252	0.02283	1.9698	0.69253	0.38506	3.04739	2.06513	0.66926	0.54627	3.29624	10/17/2019	0	0	0	0	0	0	06/06/2018	2	2	0	4	1	4	2017-02-17	2	2	0	1	8	0	8	2.667	0	0	0	0.00	0	875 JERUSALEM AVENUE UNIONDALE, NY 11553 (40.697401, -73.585634)	02/01/2020
14845	4000 POST ROAD WARWICK, RI 02886	41.682399	-71.450804	0		415061	BRENTWOOD NURSING HOME	4000 POST ROAD	WARWICK	RI	2886	4018848020	10	Kent	For profit - Limited Liability company	96	88	Medicare and Medicaid	false	BRENTWOOD HEALTH CENTER, LTD	07/01/1979	false	false	false	false	Resident	Partial	4	3	4	5	2		4		4		2.22497	0.44561	0.88789	1.33351	3.55848	0.1066	1.98607	0.72658	0.35856	3.07122	2.32834	0.46116	0.93203	3.71541	04/01/2019	1	1	1	4	1	4	05/15/2018	4	4	0	32	1	32	2017-03-16	0	0	0	0	0	0	0	12.667	2	0	0	0.00	0	4000 POST ROAD WARWICK, RI 02886 (41.682399, -71.450804)	02/01/2020
15066	1 Country Ln, Brookville, OH 45309, USA	39.8412624	-84.4038817	1	ROOFTOP	365422	BROOKHAVEN NURSING & REHABILITATION CENTER	ONE COUNTRY LANE	BROOKVILLE	OH	45309	9378332133	580	Montgomery	For profit - Corporation	110	83.8	Medicare and Medicaid	false	BROOKVILLE ENTERPRISE INC.	10/02/1979	true	false	false	false	Resident	Partial	4	2	5	3	5		4		3		2.9008	1.12753	0.77704	1.90456	4.80537	0.12733	2.24121	0.82937	0.41746	3.48804	2.69	1.02226	0.70058	4.41772	11/21/2019	10	9	1	64	1	64	09/20/2018	14	11	3	84	1	84	2017-06-28	6	5	1	1	40	0	40	66.667	0	4	0	0.00	0		02/01/2020
15367	3756 W ERIE AVE LORAIN, OH 44053	41.450978	-82.217052	0		365969	ANCHOR LODGE NURSING HOME INC	3756 W ERIE AVE	LORAIN	OH	44053	4402442019	480	Lorain	For profit - Corporation	114	93.8	Medicare and Medicaid	false	ANCHOR LODGE NURSING HOME, INC.	07/01/1994	false	false	false	false	None	Partial	4	3	5	4	5		2		2		2.03123	0.95113	0.50888	1.46001	3.49124	0.07007	2.24522	0.88123	0.47343	3.59988	1.88026	0.81158	0.40457	3.10989	10/31/2019	6	6	0	20	1	20	09/20/2018	15	12	3	76	1	76	2017-07-20	3	3	0	1	28	0	28	40	0	1	0	0.00	0	3756 W ERIE AVE LORAIN, OH 44053 (41.450978, -82.217052)	02/01/2020