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	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	Health Inspection Rating	QM Rating	Long-Stay QM Rating	Short-Stay QM Rating	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 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
2764	2501 RICE LAKE ROAD DULUTH, MN 55811	46.817077	-92.125336	0		245366	CHRIS JENSEN HEALTH & REHABILITATION CENTER	2501 RICE LAKE ROAD	DULUTH	MN	55811	2186256400	680	St. Louis	For profit - Corporation	170	157.1	Medicare and Medicaid	false	CHRIS JENSEN LLC	08/01/1986	false		true	false	false	Both	Yes	2	1	2	2	2	4		4				2.24282	0.44125	0.80745	1.24871	3.49153	0.03975	2.00257	0.69773	0.32573	3.02603	2.32768	0.47554	0.93303	3.69995	09/18/2019	9	0	9	157	2	79	236	08/23/2018	22	17	5	136	1	0	136	2017-06-23	4	4	0	1	20	20	166.667	14	5	1	12350.00	0	1	2501 RICE LAKE ROAD DULUTH, MN 55811 (46.817077, -92.125336)	02/01/2020
3786	2901 S Wolf Rd, Westchester, IL 60154, USA	41.8364763	-87.89957299999999	1	ROOFTOP	145660	WESTCHESTER HEALTH & REHABILITATION	2901 SOUTH WOLF ROAD	WESTCHESTER	IL	60154	7085311441	141	Cook	For profit - Corporation	120	89.1	Medicare and Medicaid	false	SSC WESTCHESTER OPERATING COMPANY LLC	11/24/1989	false		true	false	false	Both	Yes	1	1	2	3	2	2		3				1.69219	0.83961	0.52418	1.36379	3.05598	0.10636	2.05352	0.74324	0.35897	3.15573	1.71263	0.84945	0.5496	3.1053	06/26/2019	22	14	8	140	1	0	140	08/17/2018	33	23	10	144	1	0	144	2017-06-23	24	20	4	1	168	168	146	0	18	1	29221.00	1	2		02/01/2020
4432	150 NORTH 27TH STREET BELLEVILLE, IL 62226	38.525934	-90.009532	0		145668	BRIA OF BELLEVILLE	150 NORTH 27TH STREET	BELLEVILLE	IL	62226	6182356600	900	St. Clair	For profit - Corporation	140	116.6	Medicare and Medicaid	false	BELLEVILLE HEALTHCARE & REHAB CENTER	12/29/1989	false	SFF Candidate	true	false	false	Resident	Yes	1	1	2	2	3	1	12	1	12	6	6															06/07/2019	35	17	22	268	2	134	402	07/24/2018	10	8	2	64	1	0	64	2017-06-23	20	10	11	1	112	112	241	0	35	1	24555.00	1	2	150 NORTH 27TH STREET BELLEVILLE, IL 62226 (38.525934, -90.009532)	02/01/2020
6308	800 NORTH MARKET STREET KNOXVILLE, IL 61448	40.917589	-90.284867	0		145697	KNOX COUNTY NURSING HOME	800 NORTH MARKET STREET	KNOXVILLE	IL	61448	3092892338	560	Knox	Government - County	169	107.5	Medicare and Medicaid	false	COUNTY OF KNOX	09/01/1991	false		true	false	false	Both	Yes	4	2	5	4	5	4		4				2.66	0.74407	0.59346	1.33753	3.99754	0.00453	2.12062	0.65854	0.27705	3.0562	2.60697	0.84961	0.80624	4.19434	05/10/2019	4	2	3	16	1	0	16	07/26/2018	11	8	3	56	1	0	56	2017-06-23	4	2	2	0	8	8	28	3	6	0	0.00	0	0	800 NORTH MARKET STREET KNOXVILLE, IL 61448 (40.917589, -90.284867)	02/01/2020
6895	1201 DIXIE HIGHWAY BEECHER, IL 60401	41.354155	-87.621357	0		145538	BEECHER MANOR NRSG & REHAB CTR	1201 DIXIE HIGHWAY	BEECHER	IL	60401	7089462600	989	Will	For profit - Partnership	128	123	Medicare and Medicaid	false	BEECHER MANOR NURSING AND REHABILITATION CENTER, LLC	02/21/1986	false		true	false	false	Resident	Yes	2	2	3	4	3	2		3				1.65367	0.74644	0.6022	1.34864	3.00231	0.09281	2.16816	0.81603	0.39461	3.3788	1.58516	0.68781	0.57438	2.84935	06/20/2019	6	5	1	32	1	0	32	05/17/2018	12	11	3	96	1	0	96	2017-06-23	1	1	0	1	8	8	49.333	0	4	0	0.00	0	0	1201 DIXIE HIGHWAY BEECHER, IL 60401 (41.354155, -87.621357)	02/01/2020
14239	1000 EVERGREEN AVENUE WEATHERLY, PA 18255	40.93734	-75.815191	0		395464	WEATHERWOOD HEALTHCARE AND REHABILITATION CENTER	1000 EVERGREEN AVENUE	WEATHERLY	PA	18255	5704278683	190	Carbon	For profit - Corporation	200	179.5	Medicare and Medicaid	false	GUARDIAN ELDER CARE AT WEATHERLY I LLC	12/01/1979	false		true	false	false	Resident	Yes	1	1	3	4	3	1		1				2.16457	0.908	0.35887	1.26687	3.43144	0.0572	2.17136	0.82388	0.43974	3.43498	2.07184	0.82872	0.30716	3.20336	06/14/2019	23	21	2	188	1	0	188	05/25/2018	16	10	6	96	2	48	144	2017-06-23	16	10	8	1	128	128	163.333	1	17	1	7673.00	1	2	1000 EVERGREEN AVENUE WEATHERLY, PA 18255 (40.93734, -75.815191)	02/01/2020