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 8 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 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 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 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
3344	642 NORTH THIRD STREET DANVILLE, KY 40422	37.65513	-84.771573	185127	DANVILLE CENTRE FOR HEALTH & REHABILITATION	642 NORTH THIRD STREET	DANVILLE	KY	40422	8592363972	100	Boyle	For profit - Corporation	106	99.7	Medicare and Medicaid	false	LP DANVILLE, LLC	10/01/1973	false		true	false	false	Resident	Yes	1	1	2	1	5		2		2				2.13755	0.80469	0.57152	1.37621	3.51376	0.05264	2.20207	0.86005	0.4594	3.52152	2.01745	0.70354	0.46824	3.1996	04/11/2019	7	4	3	40	1	40	01/18/2018	7	0	7	80	0	80	2016-11-03	13	3	10	1	716	716	166	4	3	2	629737.00	0	2	642 NORTH THIRD STREET DANVILLE, KY 40422 (37.65513, -84.771573)	02/01/2020
5168	100 MEDICAL CENTER DRIVE COMMERCE, GA 30529	34.218844	-83.469196	115714	NORTHRIDGE HEALTH AND REHABILITATION	100 MEDICAL CENTER DRIVE	COMMERCE	GA	30529	7063351330	610	Jackson	Non profit - Other	167	149.1	Medicare and Medicaid	true	RESTORATION HEALTH CARE	01/01/2006	false		true	false	false	Resident	Yes	1	1	4	4	4		3		3				2.27519	0.87141	0.4864	1.35781	3.633	0.04938	2.09634	0.68826	0.29894	3.08355	2.25565	0.95203	0.61241	3.77805	01/10/2019	5	5	0	325	1	325	02/02/2018	0	0	0	0	0	0	2016-11-03	5	5	0	1	24	24	166.5	0	0	1	110182.00	0	1	100 MEDICAL CENTER DRIVE COMMERCE, GA 30529 (34.218844, -83.469196)	02/01/2020
6300	404 W WILLOW RD DALE, IN 47523	38.177535	-86.993532	155363	WILLOWDALE VILLAGE	404 W WILLOW RD	DALE	IN	47523	8129374489	730	Spencer	Non profit - Corporation	50	28.4	Medicare and Medicaid	false	THE HEALTH AND HOSPITAL CORPORATION OF MARION COUNTY	07/02/1990	false		true	false	false	Resident	Yes	4	2	5	5		2	4		5				2.15191	0.56092	1.26253	1.82345	3.97536	0.04709	2.26913	0.79659	0.37043	3.43615	1.97097	0.52949	1.28283	3.70986	02/08/2019	13	13	0	72	1	72	01/10/2018	8	8	1	56	1	56	2016-11-03	6	6	0	1	24	24	58.667	0	1	1	8125.00	0	1	404 W WILLOW RD DALE, IN 47523 (38.177535, -86.993532)	02/01/2020
6873	451 NORTH HIGH STREET EAST HAVEN, CT 06512	41.292497	-72.866922	75389	APPLE REHAB LAUREL WOODS	451 NORTH HIGH STREET	EAST HAVEN	CT	6512	2034666850	40	New Haven	For profit - Corporation	120	108.6	Medicare and Medicaid	false	LAUREL WOODS HEALTH CARE CENTER LLC	10/28/1993	false		true	false	false	Resident	Yes	2	2	3	3	3		3		3				2.11873	0.89123	0.54867	1.4399	3.55863	0.11923	2.09782	0.68762	0.30972	3.09516	2.09906	0.97459	0.66676	3.68682	11/08/2018	2	1	1	8	1	8	10/13/2017	11	5	6	84	1	84	2016-11-03	2	2	0	1	8	8	33.333	2	2	2	32999.00	0	2	451 NORTH HIGH STREET EAST HAVEN, CT 06512 (41.292497, -72.866922)	02/01/2020
7845	1795 MONTEREY RD COLORADO SPRINGS, CO 80910	38.806182	-104.777664	65168	ASPEN LIVING CENTER	1795 MONTEREY RD	COLORADO SPRINGS	CO	80910	7194717850	200	El Paso	For profit - Individual	112	82.6	Medicare and Medicaid	false	SSC COLORADO SPRINGS ASPEN OPERATING COMPANY LLC	07/01/1982	false	SFF Candidate	true	false	false	Resident	Yes	2	1	5	5	4		4		4				2.23227	0.53922	0.69631	1.23552	3.46779	0.05398	1.9336	0.70753	0.33316	2.9743	2.39936	0.57306	0.78664	3.73871	08/01/2019	15	3	12	187	1	187	04/19/2018	26	23	4	315	1	315	2016-11-03	9	9	0	1	44	44	205.833	0	19	2	237511.00	1	3	1795 MONTEREY RD COLORADO SPRINGS, CO 80910 (38.806182, -104.777664)	02/01/2020
9476	581 NEWBERRY HIGHWAY SALUDA, SC 29138	34.02135	-81.768234	425081	SALUDA NURSING CENTER	581 NEWBERRY HIGHWAY	SALUDA	SC	29138	8644452146	400	Saluda	Government - County	176	170.9	Medicare and Medicaid	false	SALUDA NURSING CENTER	08/16/1971	false		true	false	false	Resident	Yes	2	2	5	5	5		1	12	1	12	6	6															03/30/2019	5	5	0	72	1	72	03/01/2018	12	12	0	64	1	64	2016-11-03	0	0	0	0	0	0	57.333	0	0	1	27810.00	1	2	581 NEWBERRY HIGHWAY SALUDA, SC 29138 (34.02135, -81.768234)	02/01/2020
12740	5757 WHITEFORD RD SYLVANIA, OH 43560	41.719516	-83.665964	365898	DIVINE REHABILITATION AND NURSING AT SYLVANIA	5757 WHITEFORD RD	SYLVANIA	OH	43560	4198821875	490	Lucas	For profit - Corporation	99	83.2	Medicare and Medicaid	false	MOUNTAIN CREST OH OPCO LLC	01/01/1993	false		true	false	false	Resident	Yes	2	2	3	4	2		2		2				1.52969	1.15565	0.39231	1.54796	3.07765	0.01816	1.95039	0.72179	0.36792	3.04011	1.63004	1.20392	0.40133	3.24625	03/28/2019	12	7	5	48	1	48	02/08/2018	17	5	12	88	1	88	2016-11-03	11	9	2	1	72	72	65.333	0	8	0	0.00	0	0	5757 WHITEFORD RD SYLVANIA, OH 43560 (41.719516, -83.665964)	02/01/2020
14081	710 JULIAN ROAD SALISBURY, NC 28147	35.642224	-80.49383	345286	SALISBURY CENTER	710 JULIAN ROAD	SALISBURY	NC	28147	7046365812	790	Rowan	For profit - Corporation	148	128.4	Medicare and Medicaid	false	710 JULIAN ROAD OPERATIONS LLC	08/05/1988	false		true	false	false	Resident	Yes	1	1	2	3	1		1		1				2.06498	0.90154	0.33049	1.23203	3.29701	0.10061	1.98796	0.78488	0.405	3.17784	2.15885	0.86371	0.30714	3.32692	02/14/2019	19	13	9	218	1	218	01/21/2018	10	9	6	88	1	88	2016-11-03	7	5	2	1	28	28	143	0	14	2	23770.00	0	2	710 JULIAN ROAD SALISBURY, NC 28147 (35.642224, -80.49383)	02/01/2020