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	Health Inspection Rating	QM Rating	Long-Stay QM Rating	Short-Stay QM Rating	Short-Stay QM Rating Footnote	Staffing Rating	RN Staffing Rating	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
326	265 MAIN STREET DALTON, MA 01226	42.47262	-73.176943	225455	CRANEVILLE PLACE REHABILITATION & SKILLED CARE CT	265 MAIN STREET	DALTON	MA	1226	4136843212	10	Berkshire	For profit - Partnership	89	80.8	Medicare and Medicaid	false	GAHCR II DALTON SNF TRS SUB LLC	07/01/1990	false	SFF Candidate	true	false	false	Resident	Yes	1	1	3	2	5		3	3	2.12133	0.9311	0.50322	1.43432	3.55564	0.02431	2.05034	0.65725	0.2995	3.00709	2.15029	1.06525	0.63239	3.79162	04/26/2019	21	15	6	514	1	514	01/29/2018	3	3	0	12	1	12	2016-11-17	1	1	0	1	8	8	262.333	1	0	1	35997.00	0	1	265 MAIN STREET DALTON, MA 01226 (42.47262, -73.176943)	02/01/2020
467	3576 KEARSAGE DRIVE LAKE HAVASU CITY, AZ 86406	34.454679	-114.264775	35100	HAVASU NURSING CENTER	3576 KEARSAGE DRIVE	LAKE HAVASU CITY	AZ	86406	9284531500	70	Mohave	For profit - Corporation	118	57.5	Medicare and Medicaid	false	HAVASU NURSING CENTER #2 INC	02/28/1985	false		true	false	false	Resident	Yes	3	2	5	5	5		3	3	1.756	1.23501	0.58193	1.81694	3.57295	0.10787	1.87719	0.74867	0.3622	2.98805	1.94417	1.24041	0.60472	3.83435	02/06/2019	7	7	1	56	1	56	11/02/2017	5	5	1	36	1	36	2016-11-17	5	5	0	1	24	24	44	1	3	1	8294.00	0	1	3576 KEARSAGE DRIVE LAKE HAVASU CITY, AZ 86406 (34.454679, -114.264775)	02/01/2020
4335	2308 OLD HICKS ROAD LONG GROVE, IL 60047	42.167594	-88.018964	145872	ALDEN LONG GROVE REHAB &HC CTR	2308 OLD HICKS ROAD	LONG GROVE	IL	60047	8474388275	570	Lake	For profit - Corporation	246	174.9	Medicare and Medicaid	false	ALDEN-LONG GROVE REHABILITATION AND HEALTH CARE CENTER, INC.	03/12/1996	false		true	false	false	Resident	Yes	1	1	3	5	2		2	2	1.42515	0.54761	0.43794	0.98555	2.41071	0.03763	2.19898	0.72514	0.32863	3.25276	1.34696	0.56785	0.50157	2.37654	11/02/2018	18	12	6	199	1	199	10/18/2017	6	4	2	44	1	44	2016-11-17	14	2	12	1	112	112	132.833	2	15	4	58215.00	0	4	2308 OLD HICKS ROAD LONG GROVE, IL 60047 (42.167594, -88.018964)	02/01/2020
10529	400 VISION DRIVE ASHEBORO, NC 27203	35.735334	-79.816023	345277	WOODLAND HILL CENTER	400 VISION DRIVE	ASHEBORO	NC	27203	3366725450	750	Randolph	For profit - Corporation	100	86.1	Medicare and Medicaid	false	400 VISION DRIVE OPERATIONS LLC	03/24/1988	false	SFF Candidate	true	false	false	Resident	Yes	1	1	3	2	3		2	2	1.98671	0.89295	0.49178	1.38472	3.37143	0.02329	2.12017	0.81997	0.40738	3.34752	1.94751	0.81887	0.45436	3.22956	01/25/2019	22	22	2	317	1	317	12/01/2017	17	13	5	96	1	96	2016-11-17	7	7	0	1	40	40	197.167	4	3	2	98802.00	0	2	400 VISION DRIVE ASHEBORO, NC 27203 (35.735334, -79.816023)	02/01/2020
14554	2461 SIDNEY ROAD WALTERBORO, SC 29488	32.949562	-80.612836	425386	VETERANS VICTORY HOUSE	2461 SIDNEY ROAD	WALTERBORO	SC	29488	8435383000	140	Colleton	Government - State	220	214.3	Medicare and Medicaid	false	SOUTH CAROLINA DEPT OF MENTAL HEALTH ACCOUNTING OFFICE	10/03/2007	false	SFF Candidate	true	false	false	Both	Yes	2	1	5	5		2	4	4	2.61741	0.9092	0.54051	1.44971	4.06712	0.02195	1.83043	0.59088	0.24755	2.66886	2.97189	1.15704	0.82181	4.88668	05/31/2019	7	2	5	104	1	104	03/02/2018	10	3	7	848	1	848	2016-11-17	4	4	0	1	20	20	338	19	0	1	260746.00	1	2	2461 SIDNEY ROAD WALTERBORO, SC 29488 (32.949562, -80.612836)	02/01/2020