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 5 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 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
235	400 EAST HOSPITAL ROAD EL DORADO SPRINGS, MO 64744	37.859255	-94.01594	265446	COMMUNITY SPRINGS HEALTHCARE FACILITY	400 EAST HOSPITAL ROAD	EL DORADO SPRINGS	MO	64744	4178762531	190	Cedar	Non profit - Corporation	120	60.4	Medicare and Medicaid	false	CITIZENS MEMORIAL HEALTH CARE FOUNDATION	02/01/1991	false		true	false	false	Resident	Yes	2		2		1		1		1		4		4		2.15376	0.44752	0.72304	1.17057	3.32433	0.08491	1.96801	0.63125	0.28614	2.8854	2.2745	0.53309	0.95109	3.69447	12/13/2018	3	2	1	28	1	28	11/16/2017	0	0	0	0	0	0	0	2016-11-18	3	3	0	1	28	0	28	18.667	1	0	1	11278.00	0	1	400 EAST HOSPITAL ROAD EL DORADO SPRINGS, MO 64744 (37.859255, -94.01594)	02/01/2020
6842	689 MAIN STREET HAVERHILL, MA 01830	42.7953	-71.085563	225218	OXFORD REHABILITATION & HEALTH CARE CENTER, THE	689 MAIN STREET	HAVERHILL	MA	1830	9783731131	40	Essex	For profit - Corporation	120	108.7	Medicare and Medicaid	false	OXFORD MA SNF LLC	08/01/1974	false	SFF	true	false	false	Resident	Yes		18		18		18		18		18		18		18	2.04133	0.61626	0.6813	1.29756	3.33889	0.11175	1.89645	0.68313	0.32529	2.90487	2.23711	0.67834	0.78831	3.68577	03/15/2019	20	9	11	215	1	215	02/09/2018	40	27	13	1195	2	598	1793	2016-11-18	19	8	11	1	258	0	258	748.167	5	4	3	142727.00	0	3	689 MAIN STREET HAVERHILL, MA 01830 (42.7953, -71.085563)	02/01/2020
8756	4000 LINGLESTOWN ROAD HARRISBURG, PA 17112	40.334868	-76.838872	395372	JEWISH HOME OF GREATER HARRISB	4000 LINGLESTOWN ROAD	HARRISBURG	PA	17112	7176570700	280	Dauphin	Non profit - Corporation	138	126	Medicare and Medicaid	false	JEWISH HOME OF GREATER HARRISBURG	04/12/1977	false		true	false	false	None	Yes	2		1		5		5		5		4		4		2.22914	0.9835	0.876	1.8595	4.08864	0.03764	2.2968	0.80237	0.40239	3.50155	2.01712	0.92168	0.8194	3.7443	01/31/2019	23	16	7	160	1	160	01/12/2018	16	13	3	112	1	0	112	2016-11-18	16	7	9	2	100	50	150	142.333	3	9	2	26904.00	0	2	4000 LINGLESTOWN ROAD HARRISBURG, PA 17112 (40.334868, -76.838872)	02/01/2020
10552	200 SECOND AVENUE KINGSTON, PA 18704	41.257013	-75.883465	395397	MANORCARE HEALTH SERVICES-KINGSTON	200 SECOND AVENUE	KINGSTON	PA	18704	5702889315	480	Luzerne	Non profit - Other	176	136	Medicare and Medicaid	false	MANOR CARE OF KINGSTON PA LLC	12/01/1977	false		true	false	false	Resident	Yes	1		1		3		3		2		3		3		1.95772	0.86864	0.51898	1.38761	3.34533	0.08077	2.11214	0.75195	0.37317	3.23727	1.92639	0.86862	0.52344	3.3137	11/19/2018	24	11	13	176	1	176	12/22/2017	20	7	13	120	2	60	180	2016-11-18	22	14	8	1	140	0	140	171.333	2	33	2	61988.00	2	4	200 SECOND AVENUE KINGSTON, PA 18704 (41.257013, -75.883465)	02/01/2020
14660	4680 CORDATA PARKWAY BELLINGHAM, WA 98226	48.811636	-122.497692	505393	NORTH CASCADES HEALTH AND REHABILITATION CENTER	4680 CORDATA PARKWAY	BELLINGHAM	WA	98226	3603981966	360	Whatcom	For profit - Corporation	122	95.5	Medicare and Medicaid	false	EVERGREEN AT BELLINGHAM, L.L.C.	09/01/1991	false		true	false	false	Resident	Yes	3		2		5		5		5		3		4		2.0074	0.54144	0.99658	1.53802	3.54542	0.09696	2.15472	0.7544	0.36618	3.2753	1.93624	0.53968	1.02434	3.47113	04/24/2019	24	19	8	132	1	132	02/14/2018	22	20	2	156	1	0	156	2016-11-18	14	14	0	1	80	0	80	131.333	3	3	1	51714.00	0	1	4680 CORDATA PARKWAY BELLINGHAM, WA 98226 (48.811636, -122.497692)	02/01/2020