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 6 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	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 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
188	3200 STATE ST SAGINAW, MI 48602	43.436632	-83.985897	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	188	364.5	28	39	5	191846.00	2	7	3200 STATE ST SAGINAW, MI 48602 (43.436632, -83.985897)	02/01/2020
4145	3322 SILVERSIDE ROAD WILMINGTON, DE 19810	39.808573	-75.539564	85056	CADIA REHABILITATION SILVERSIDE	3322 SILVERSIDE ROAD	WILMINGTON	DE	19810	3024788889	10	New Castle	For profit - Corporation	128	106.3	Medicare and Medicaid	false	ONIX SILVERSIDE LLC	12/05/2012	false		true	false	false	Resident	Yes	4		2		5		4		5		5		5		1.93136	0.7205	1.43767	2.15817	4.08953	0.19562	2.06908	0.77071	0.36637	3.20617	1.94	0.70295	1.47695	4.09016	06/25/2019	14	9	5	80	1	0	80	05/30/2018	19	19	0	88	1	0	88	2017-03-23	7	6	3	1	36	36	75.333	2	5	0	0.00	0	0	3322 SILVERSIDE ROAD WILMINGTON, DE 19810 (39.808573, -75.539564)	02/01/2020
7472	1400 POPLAR ST HANCOCK, MI 49930	47.14009	-88.596793	235552	THE LIGHTHOUSE AT HANCOCK HEALTH AND REHAB	1400 POPLAR ST	HANCOCK	MI	49930	9064826644	300	Houghton	For profit - Corporation	63	48	Medicare and Medicaid	false	CYPRESS HEALTHCARE, LLC	07/01/1994	false		true	false	false	Resident	Yes	2		1		2		1		2		4		5		2.26118	0.43116	0.94938	1.38053	3.64172	0.01518	2.00313	0.6466	0.29023	2.93996	2.34608	0.5014	1.23121	3.97208	04/02/2019	23	23	0	286	1	0	286	06/12/2018	14	11	5	92	1	0	92	2017-03-23	11	6	5	1	44	44	181	6	8	0	0.00	1	1	1400 POPLAR ST HANCOCK, MI 49930 (47.14009, -88.596793)	02/01/2020
8328	414 E STATE ST BELDING, MI 48809	43.08898	-85.224083	235357	METRON OF BELDING	414 E STATE ST	BELDING	MI	48809	6167940460	330	Ionia	For profit - Corporation	128	107.9	Medicare and Medicaid	false	BELDING CHRISTIAN NURSING HOME, INC	07/01/1978	false	SFF	true	false	false	Resident	Yes		18		18		18		18		18		18		18	2.27042	0.42678	0.92141	1.34819	3.61861	0.02103	1.96371	0.62841	0.28855	2.88066	2.40295	0.51068	1.2019	4.02813	07/11/2019	17	9	9	171	1	0	171	06/18/2018	55	30	25	2207	2	1104	3311	2017-03-23	25	17	12	1	425	425	1260	78	32	2	153692.00	2	4	414 E STATE ST BELDING, MI 48809 (43.08898, -85.224083)	02/01/2020
11576	1000 COLLEGE STREET WILKESBORO, NC 28697	36.141365	-81.166265	345133	CURIS AT WILKESBORO TRANSITIONAL CARE & REHAB CNTR	1000 COLLEGE STREET	WILKESBORO	NC	28697	3368384141	960	Wilkes	For profit - Limited Liability company	120	87.3	Medicare and Medicaid	false	CURIS AT WILKESBORO OPCO LLC	12/01/1974	false		true	false	false	Resident	Yes	1		1		3		2		4		3		3		2.15934	0.4343	0.71771	1.15201	3.31135	0.00575	1.94904	0.74922	0.372	3.07026	2.30259	0.43587	0.72618	3.45847	04/11/2019	6	3	3	99	1	0	99	05/05/2018	12	12	5	84	1	0	84	2017-03-23	7	7	0	1	32	32	82.833	2	6	2	209684.00	1	3	1000 COLLEGE STREET WILKESBORO, NC 28697 (36.141365, -81.166265)	02/01/2020
11611	710 15-401 BYPASS BENNETTSVILLE, SC 29512	34.60693	-79.713207	425118	DUNDEE MANOR, LLC	710 15-401 BYPASS, WEST	BENNETTSVILLE	SC	29512	8434796251	340	Marlboro	For profit - Corporation	110	103	Medicare and Medicaid	false	DUNDEE MANOR, LLC	07/01/1978	false		true	false	false	Resident	Yes	1		1		2		4		1		2		2		2.185	1.12588	0.26232	1.3882	3.5732	0.04585	2.03343	0.66532	0.28846	2.98721	2.23325	1.27247	0.34228	3.8357	09/19/2019	5	5	0	64	2	32	96	07/13/2018	10	10	0	44	1	0	44	2017-03-23	23	12	11	1	244	244	103.333	0	1	4	38300.00	2	6	710 15-401 BYPASS BENNETTSVILLE, SC 29512 (34.60693, -79.713207)	02/01/2020