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	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 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
293	530 EAST BEARDSTOWN STREET VIRGINIA, IL 62691	39.94748	-90.205881	0		146100	WALKER NURSING HOME	530 EAST BEARDSTOWN STREET	VIRGINIA	IL	62691	2174523218	80	Cass	For profit - Corporation	71	39.3	Medicare and Medicaid	false	WALKER NURSING HOME INC	01/20/2006	false		true	false	false	Both	Yes	2	2	5	5		2	1	12	1	12	1.44939	0.65874	0.24862	0.90736	2.35675	0.00509	2.04575	0.61646	0.22759	2.88981	1.47248	0.80351	0.41115	2.61515	12/05/2018	5	4	1	52	1	52	01/04/2018	9	8	1	92	1	92	2017-02-02	4	4	0	1	40	40	63.333	1	1	1	8011.00	1	530 EAST BEARDSTOWN STREET VIRGINIA, IL 62691 (39.94748, -90.205881)	02/01/2020
2249	Elmore, AL, USA	32.5387448	-86.3149712	1	APPROXIMATE	15019	MERRY WOOD LODGE CARE AND REHABILITATION CENTER	P O BOX 130	ELMORE	AL	36025	3345678484	250	Elmore	For profit - Corporation	124	97.9	Medicare and Medicaid	false	SUNBRIDGE HEALTHCARE LLC	01/01/1974	false	SFF Candidate	true	false	false	Resident	Yes	2	1	2	3	2		4		4		2.09629	0.63975	0.59735	1.2371	3.33339	0.04508	1.95583	0.67874	0.29761	2.93218	2.22759	0.70874	0.75546	3.64542	12/13/2018	8	2	6	562	1	562	03/29/2018	3	3	1	24	1	24	2017-02-02	5	5	1	1	16	16	291.667	1	2	1	78677.00	1		02/01/2020
5235	620 PARKER ROAD MAYSVILLE, KY 41056	38.636145	-83.794123	0		185207	MAYSVILLE NURSING AND REHABILITATION FACILITY	620 PARKER ROAD	MAYSVILLE	KY	41056	6065644085	800	Mason	For profit - Individual	130	112	Medicare and Medicaid	false	MAYSVILLE OPERATIONS LLC	04/18/1990	false		true	false	false	Both	Yes	1	1	2	1	4		2		1		2.86542	1.04351	0.20256	1.24607	4.11149	0.05594	2.28943	0.82271	0.3969	3.50904	2.60122	0.95375	0.19209	3.75719	02/21/2019	16	10	6	412	1	412	03/22/2018	1	1	0	4	1	4	2017-02-02	1	1	0	1	4	4	208	0	1	2	26155.00	2	620 PARKER ROAD MAYSVILLE, KY 41056 (38.636145, -83.794123)	02/01/2020
7401	900 GAGEL AVENUE LOUISVILLE, KY 40216	38.172763	-85.806075	0		185096	LANDMARK OF IROQUOIS PARK REHAB AND NURSING CENTER	900 GAGEL AVENUE	LOUISVILLE	KY	40216	5023685827	550	Jefferson	For profit - Corporation	120	93.6	Medicare and Medicaid	false	LANDMARK OF IRIQUOIS PARK REHABILITATION AND NURSING CENTER	01/01/1974	false		true	false	false	Resident	Yes	1	1	2	3	1		2		2		1.85742	0.86906	0.3333	1.20237	3.05979	0.03797	1.98784	0.77178	0.39624	3.15585	1.94199	0.84673	0.3166	3.10905	06/24/2019	15	14	5	372	1	372	03/29/2018	4	4	0	16	1	16	2017-02-02	4	1	3	1	16	16	194	2	2	1	21393.00	1	900 GAGEL AVENUE LOUISVILLE, KY 40216 (38.172763, -85.806075)	02/01/2020
11488	6201 EAST 36TH STREET TULSA, OK 74135	36.111657	-95.907414	0		375438	GRACEWOOD HEALTH & REHAB	6201 EAST 36TH STREET	TULSA	OK	74135	9186223430	710	Tulsa	For profit - Individual	121	68.1	Medicare and Medicaid	false	GRACEWOOD HEALTH & REHAB LLC	06/15/2003	false		true	false	false	Resident	Yes	2	2	4	5	2		2		2		2.13989	0.61375	0.3107	0.92445	3.06434	0.00702	1.78414	0.62121	0.30025	2.70561	2.49274	0.7429	0.38948	3.63182	05/08/2019	8	8	4	84	1	84	03/13/2018	11	7	4	116	1	116	2017-02-02	14	5	9	1	108	108	98.667	1	11	2	103031.00	2	6201 EAST 36TH STREET TULSA, OK 74135 (36.111657, -95.907414)	02/01/2020
12283	135 DODGE STREET PROVIDENCE, RI 02907	41.81389	-71.424984	0		415038	BANNISTER CTR FOR REHABILITATION AND HEALTH CARE	135 DODGE STREET	PROVIDENCE	RI	2907	4015219600	30	Providence	For profit - Corporation	161	138.8	Medicare and Medicaid	false	BANNISTER OPERATIONS ASSOC LLC	03/31/1974	false	SFF Candidate	true	false	false	Resident	Yes	1	1	1	3	1		3		4		2.02577	0.30238	0.74393	1.04631	3.07208	0.15801	1.8413	0.72924	0.37814	2.94868	2.28655	0.31179	0.74048	3.34086	02/15/2019	6	4	4	99	1	99	02/14/2018	15	13	2	104	1	104	2017-02-02	5	1	4	1	56	56	93.5	7	2	1	13627.00	1	135 DODGE STREET PROVIDENCE, RI 02907 (41.81389, -71.424984)	02/01/2020