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 10 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 "Abuse Icon" = :p0 and date("Rating Cycle 3 Standard Health Survey Date") = :p1 order by rowid limit 101

Query parameters

This data as json, copyable, CSV

rowid	address	lat	lng	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	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 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 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
1448	601 RICHMOND ROAD BEREA, KY 40403	37.593752	-84.283511	185384	BEREA HEALTH AND REHABILITATION	601 RICHMOND ROAD	BEREA	KY	40403	8599864710	750	Madison	For profit - Corporation	84	77.1	Medicare and Medicaid	false	BEREA HEALTHCARE LLC	09/28/1993	false		true	false	false	Both	Yes	1	1	3	3	3		3		3		2.60743	0.57488	0.62197	1.19684	3.80427	0.04407	2.24814	0.81899	0.42339	3.49052	2.41048	0.52781	0.55292	3.49489	03/27/2019	16	12	14	383	1	383	03/08/2018	2	1	1	16	1	0	16	2016-12-15	2	1	1	1	8	8	198.167	1	7	1	206560.00	0	1	601 RICHMOND ROAD BEREA, KY 40403 (37.593752, -84.283511)	02/01/2020
4422	1350 SLEEPY HILL RD LAKELAND, FL 33810	28.09514	-81.978528	105301	VALENCIA HILLS HEALTH AND REHABILITATION CENTER	1350 SLEEPY HILL RD	LAKELAND	FL	33810	8638584402	520	Polk	For profit - Partnership	249	226.6	Medicare and Medicaid	false	LAKELAND INVESTORS,LLC	02/16/1977	false		true	false	false	Resident	Yes	2	1	4	5	3		4		3		2.657	0.99861	0.62578	1.62439	4.28139	0.06852	2.03013	0.69623	0.34013	3.06649	2.7201	1.07851	0.69248	4.4771	04/05/2019	11	6	5	189	1	189	01/05/2018	12	11	1	80	2	40	120	2016-12-15	8	6	2	1	52	52	143.167	4	3	3	189577.00	0	3	1350 SLEEPY HILL RD LAKELAND, FL 33810 (28.09514, -81.978528)	02/01/2020
5184	48 TARN TERRACE FROSTBURG, MD 21532	39.660536	-78.927868	215277	WEST MD HEALTH SYST FROSTBURG NRSG AND REHAB CTR	48 TARN TERRACE	FROSTBURG	MD	21532	3016891391	0	Allegany	Non profit - Corporation	88	66.1	Medicare and Medicaid	false	WESTERN MARYLAND HEALTH SYSTEM CORPORATION	08/17/1995	false		true	false	false	Resident	Yes	2	2	2	1	4		2		2		2.68638	0.6879	0.30799	0.99589	3.68227	0.04141	2.19178	0.70476	0.34318	3.23972	2.54734	0.73395	0.33778	3.6447	09/20/2019	6	6	1	24	1	24	03/09/2018	22	19	3	132	2	66	198	2016-12-15	13	12	1	1	92	92	93.333	6	4	1	10273.00	0	1	48 TARN TERRACE FROSTBURG, MD 21532 (39.660536, -78.927868)	02/01/2020
7679	88 CLARK LANE WATERFORD, CT 06385	41.34864	-72.127527	75158	NEW LONDON SUB-ACUTE AND NURSING	88 CLARK LANE	WATERFORD	CT	6385	8604420471	50	New London	For profit - Corporation	120	103.9	Medicare and Medicaid	false	88 CLARK OPERATING LLC	01/01/1967	false		true	false	false	Resident	Yes	3	2	3	4	3		4		4		1.7206	0.81282	0.61324	1.42606	3.14666	0.04242	1.87405	0.64303	0.29245	2.80953	1.90816	0.95049	0.78925	3.59145	10/26/2018	6	6	4	36	1	36	09/21/2017	8	2	6	32	1	0	32	2016-12-15	2	2	0	1	8	8	30	1	5	1	9750.00	0	1	88 CLARK LANE WATERFORD, CT 06385 (41.34864, -72.127527)	02/01/2020
9180	7450 KELLER ROAD CINCINNATI, OH 45243	39.208067	-84.363139	365178	KENWOOD TERRACE CARE CENTER	7450 KELLER ROAD	CINCINNATI	OH	45243	5137932255	310	Hamilton	For profit - Corporation	108	73.7	Medicare and Medicaid	false	KENWOOD TERRACE HEALTH CARE CENTER, INC.	10/01/1970	false		true	false	false	Both	Yes	2	2	4	5	3		2		2		2.14924	1.10308	0.51772	1.6208	3.77005	0.07817	2.18997	0.81288	0.41236	3.41521	2.03969	1.02039	0.47255	3.53983	04/16/2019	10	10	4	135	1	135	02/22/2018	2	2	0	8	1	0	8	2016-12-15	1	1	0	1	4	4	70.833	3	0	1	20415.00	0	1	7450 KELLER ROAD CINCINNATI, OH 45243 (39.208067, -84.363139)	02/01/2020
9997	600 BACON STREET MADISONVILLE, TX 77864	30.946898	-95.907218	675481	RIVERWOOD HEALTHCARE	600 BACON STREET	MADISONVILLE	TX	77864	9363489097	782	Madison	For profit - Corporation	90	30.5	Medicare and Medicaid	false	Legal Business Name Not Available	05/01/1995	false		true	false	false	Resident	Yes	1	1	1	1		2	1	12	1	12	2.23952	1.12999	0.19244	1.32243	3.56195	0	1.8877	0.64278	0.24342	2.7739	2.46568	1.32189	0.29757	4.11766	01/10/2019	22	19	5	196	1	196	01/10/2018	12	6	12	376	1	0	376	2016-12-15	2	2	0	1	32	32	228.667	0	13	0	0.00	2	2	600 BACON STREET MADISONVILLE, TX 77864 (30.946898, -95.907218)	02/01/2020
10807	3145 HIGH STREET OAKLAND, CA 94619	37.785178	-122.199004	555499	REDWOOD HEALTHCARE CENTER LLC	3145 HIGH STREET	OAKLAND	CA	94619	5105339970	0	Alameda	For profit - Corporation	44	43.4	Medicare and Medicaid	false	REDWOOD HEALTHCARE CENTER LLC	03/11/1992	false		true	false	false	Resident	Yes	2	2	2	2	2		3		3		2.23998	0.73324	0.50704	1.24028	3.48026	0.03214	2.15493	0.70529	0.30332	3.16353	2.16036	0.78174	0.62919	3.52771	01/10/2019	13	10	3	76	1	76	12/07/2017	15	11	4	92	1	0	92	2016-12-15	7	7	0	1	32	32	74	3	6	0	0.00	0	0	3145 HIGH STREET OAKLAND, CA 94619 (37.785178, -122.199004)	02/01/2020
12840	1000 MILL STREET DUNMORE, PA 18512	41.409618	-75.62742	395567	DUNMORE HEALTH CARE CENTER	1000 MILL STREET	DUNMORE	PA	18512	5703427624	420	Lackawanna	For profit - Corporation	92	85.6	Medicare and Medicaid	false	DUNMORE HEALTHCARE GROUP, INC.	06/02/1982	false		true	false	false	Resident	Yes	1	1	1	3	1		2		2		1.8041	0.77678	0.5233	1.30008	3.10418	0.05661	2.19372	0.79886	0.41806	3.41064	1.70921	0.73115	0.47114	2.91853	12/07/2018	20	14	7	144	1	144	01/05/2018	23	9	14	140	1	0	140	2016-12-15	15	10	5	1	96	96	134.667	1	22	0	0.00	1	1	1000 MILL STREET DUNMORE, PA 18512 (41.409618, -75.62742)	02/01/2020
13334	8800 FOURWINDS DR SAN ANTONIO, TX 78239	29.52068	-98.393308	455533	WINDCREST NURSING AND REHABILITATION	8800 FOURWINDS DR	SAN ANTONIO	TX	78239	2106372700	130	Bexar	For profit - Corporation	180	124.6	Medicare and Medicaid	false	WINDCREST SCC LLC	07/01/1985	false	SFF Candidate	true	false	false	Resident	Yes	2	1	5	5	4		1		1		1.80279	1.13465	0.24525	1.37989	3.18269	0.03924	2.14072	0.84333	0.46979	3.45384	1.75026	1.01169	0.19649	2.95491	02/08/2019	35	31	9	292	1	292	02/16/2018	27	18	9	647	2	324	971	2016-12-15	11	8	3	1	104	104	487	4	6	0	0.00	1	1	8800 FOURWINDS DR SAN ANTONIO, TX 78239 (29.52068, -98.393308)	02/01/2020
13568	100 SOUTH WHITEWOMAN STREET COSHOCTON, OH 43812	40.27263	-81.87876	365880	SIGNATURE HEALTHCARE OF COSHOCTON	100 SOUTH WHITEWOMAN STREET	COSHOCTON	OH	43812	7406221220	150	Coshocton	For profit - Corporation	83	57.9	Medicare and Medicaid	false	LP COSHOCTON LLC	06/23/1992	false		true	false	false	Resident	Yes	1	1	4	5	4		3		4		1.36313	0.67011	0.77424	1.44435	2.80749	0.04589	1.99968	0.78012	0.39138	3.17117	1.41675	0.64591	0.74458	2.8389	03/21/2019	9	5	4	123	1	123	02/01/2018	13	13	0	80	2	40	120	2016-12-15	9	9	0	1	72	72	113.5	2	0	1	76567.00	1	2	100 SOUTH WHITEWOMAN STREET COSHOCTON, OH 43812 (40.27263, -81.87876)	02/01/2020