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 7 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 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 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
247	99 SOUTH CANAAN RD CANAAN, CT 06018	42.016475	-73.332471	0		75202	GEER NURSING AND REHABILITATION	99 SOUTH CANAAN RD	CANAAN	CT	6018	8608245137	20	Litchfield	Non profit - Corporation	120	97.4	Medicare and Medicaid	false	ROBERT C GEER MEMORIAL HOSPITAL INC	02/09/1971	false	SFF Candidate	true	false	false	Resident	Yes	2	1	3	2	4		4		5				2.22232	0.49994	0.93469	1.43462	3.65695	0.0362	2.10526	0.66606	0.3065	3.07782	2.1939	0.5644	1.14779	3.81003	07/19/2019	11	4	7	266	1	266	06/28/2018	8	6	2	48	1	48	2017-07-13	3	0	3	0	12	12	151	3	0	1	6500.00	0	1	99 SOUTH CANAAN RD CANAAN, CT 06018 (42.016475, -73.332471)	02/01/2020
2946	PO Box 728, Browning, MT 59417, USA	48.5606889	-113.0144936	1	GEOMETRIC_CENTER	275133	BLACKFEET CARE CENTER	728 S GOVERNMENT SQ	BROWNING	MT	59417	4063382686	170	Glacier	Government - City/county	47	22.2	Medicare and Medicaid	false	BLACKFEET TRIBE	07/20/1989	false		true	false	false	Resident	Yes	4	2	5	5		2	5		5				2.99829	0.62183	0.82726	1.44909	4.44738	0.04004	1.91226	0.63574	0.27834	2.82634	3.25869	0.73549	1.11865	5.04583	10/31/2019	10	6	5	116	0	116	10/04/2018	5	5	0	20	1	20	2017-07-13	19	19	0	1	112	112	83.333	1	3	1	22032.00	0	1		02/01/2020
3711	13484 SAN PABLO AVENUE SAN PABLO, CA 94806	37.955348	-122.335368	0		56389	VALE HEALTHCARE CENTER	13484 SAN PABLO AVENUE	SAN PABLO	CA	94806	5102325945	60	Contra Costa	For profit - Corporation	202	192.3	Medicare and Medicaid	false	Legal Business Name Not Available	04/13/1973	false		true	false	false	Resident	Yes	3	2	5	5	4		3		3				2.42561	0.70631	0.52297	1.22928	3.65489	0.0342	1.97831	0.66736	0.2932	2.93887	2.54826	0.79582	0.67134	3.98792	06/21/2019	18	15	3	80	1	80	07/20/2018	9	3	6	24	1	24	2017-07-13	8	8	2	1	28	28	52.667	15	2	0	0.00	0	0	13484 SAN PABLO AVENUE SAN PABLO, CA 94806 (37.955348, -122.335368)	02/01/2020
4258	20395 SUMMERVILLE ROAD DEEPHAVEN, MN 55331	44.926996	-93.539601	0		245606	LAKE MINNETONKA CARE CENTER	20395 SUMMERVILLE ROAD	DEEPHAVEN	MN	55331	9524744474	260	Hennepin	For profit - Corporation	21	18.6	Medicare and Medicaid	false	Legal Business Name Not Available	07/02/1992	false		true	false	false	Resident	Yes	1	2	3	3		2	1	12	1	12	6	6															04/19/2019	10	9	1	84	1	84	07/12/2018	6	6	0	16	1	16	2017-07-13	10	6	4	1	68	68	58.667	1	2	1	6500.00	0	1	20395 SUMMERVILLE ROAD DEEPHAVEN, MN 55331 (44.926996, -93.539601)	02/01/2020
6119	1314 ROWELL AVENUE JOLIET, IL 60433	41.499603	-88.061574	0		145618	SALEM VILLAGE NURSING & REHAB	1314 ROWELL AVENUE	JOLIET	IL	60433	8157275451	989	Will	For profit - Partnership	266	175.8	Medicare and Medicaid	false	SALEM VILLAGE NURSING AND REHABILITATION CENTER LLC	02/16/1989	false		true	false	false	Resident	Yes	1	1	2	2	2		2		3				1.69278	0.72569	0.72198	1.44766	3.14044	0.01938	2.24466	0.7773	0.4345	3.45646	1.56735	0.70201	0.62541	2.91348	06/14/2019	23	14	9	148	1	148	08/24/2018	28	9	19	160	1	160	2017-07-13	18	9	9	1	88	88	142	2	35	0	0.00	1	1	1314 ROWELL AVENUE JOLIET, IL 60433 (41.499603, -88.061574)	02/01/2020
13384	15015 CYPRESS WOODS MEDICAL DR HOUSTON, TX 77014	29.998241	-95.467217	0		676239	VILLA TOSCANA AT CYPRESS WOODS	15015 CYPRESS WOODS MEDICAL DR	HOUSTON	TX	77014	2815866088	610	Harris	Government - Hospital district	120	98.8	Medicare and Medicaid	false	SOUTH LIMESTONE HOSPITAL DISTRICT	11/04/2009	false	SFF Candidate	true	false	false	Resident	Yes	1	1	4	4	5		2		2				1.98753	0.89274	0.47604	1.36878	3.35631	0.03624	2.1686	0.86806	0.45186	3.48852	1.9048	0.77332	0.39653	3.08513	07/17/2019	19	16	5	482	1	482	08/10/2018	13	5	9	120	1	120	2017-07-13	8	4	4	1	104	104	298.333	4	11	1	34092.00	1	2	15015 CYPRESS WOODS MEDICAL DR HOUSTON, TX 77014 (29.998241, -95.467217)	02/01/2020
13577	4420 SOUTH AVENUE TOLEDO, OH 43615	41.630951	-83.646357	0		365488	CONTINUING HEALTHCARE OF TOLEDO	4420 SOUTH AVENUE	TOLEDO	OH	43615	4195314201	490	Lucas	For profit - Corporation	75	54.6	Medicare and Medicaid	false	CONTINUING HEALTHCARE OF TOLEDO LLC	05/09/1980	false		true	false	false	Resident	Yes	2	1	5	3	5		1		1				1.70732	1.08153	0.3367	1.41823	3.12554	0.01195	2.11355	0.8557	0.48092	3.45016	1.67887	0.95039	0.26351	2.90495	08/07/2019	27	22	6	172	1	172	09/20/2018	30	11	21	164	1	164	2017-07-13	14	8	6	1	56	56	150	3	17	0	0.00	1	1	4420 SOUTH AVENUE TOLEDO, OH 43615 (41.630951, -83.646357)	02/01/2020