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 8 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	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 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
1460	403 15TH STREET PORT ALLEN, LA 70767	30.45496	-91.21808	195599	LEGACY NURSING AND REHABILITATION OF PORT ALLEN	403 15TH STREET	PORT ALLEN	LA	70767	2253468815	600	W. Baton Rouge	For profit - Limited Liability company	125	114	Medicare and Medicaid	false	PORT ALLEN CARE CENTER, LLC	06/17/2004	false	true	false	false	Resident	Yes	1	1	3	3	3		1		1		1.59034	0.74221	0.28026	1.02247	2.61281	0.00774	1.75068	0.69353	0.34109	2.7853	1.88799	0.80472	0.30926	3.00808	04/04/2019	7	6	3	80	1	80	04/19/2018	7	4	3	76	1	76	2017-05-11	2	2	0	0	0	0	0	65.333	4	0	3	59367.00	0	3	403 15TH STREET PORT ALLEN, LA 70767 (30.45496, -91.21808)	02/01/2020
1805	3270 PRATT LAKE RD GLADWIN, MI 48624	44.00892	-84.497743	235335	GLADWIN NURSING AND REHABILITATION COMMUNITY	3270 PRATT LAKE RD	GLADWIN	MI	48624	9894267275	250	Gladwin	For profit - Corporation	60	33.8	Medicare and Medicaid	false	ATRIUM GLADWIN, INC.	05/12/1977	false	true	false	false	Resident	Yes	3	2	3	4	2		4		4		2.14267	0.85781	0.73138	1.58919	3.73187	0.31547	2.03095	0.73465	0.36924	3.13484	2.19267	0.87801	0.74552	3.81737	09/12/2019	19	18	4	152	1	152	07/25/2018	12	8	6	155	1	155	2017-05-11	8	5	3	1	48	0	48	135.667	7	6	1	13325.00	1	2	3270 PRATT LAKE RD GLADWIN, MI 48624 (44.00892, -84.497743)	02/01/2020
2060	1150 E MICHIGAN AVE BATTLE CREEK, MI 49014	42.310464	-85.126433	235237	CALHOUN COUNTY MEDICAL CARE FACILITY	1150 E MICHIGAN AVE	BATTLE CREEK	MI	49014	2699625458	120	Calhoun	Government - County	120	113.2	Medicare and Medicaid	false	CALHOUN COUNTY MEDICAL CARE FACILITY	11/01/1974	false	true	false	false	Both	Yes	3	2	4	4	4		4		4		2.76318	0.74395	0.68612	1.43007	4.19325	0.04134	2.01974	0.65938	0.29356	2.97268	2.84335	0.84838	0.87971	4.52331	08/07/2019	10	3	7	68	1	68	07/20/2018	8	6	3	36	1	36	2017-05-11	15	13	7	3	124	87	211	81.167	9	3	1	12500.00	1	2	1150 E MICHIGAN AVE BATTLE CREEK, MI 49014 (42.310464, -85.126433)	02/01/2020
4396	700 MANOR DRIVE PRESCOTT, AR 71857	33.787601	-93.380341	45181	PRESCOTT MANOR NURSING CENTER	700 MANOR DRIVE	PRESCOTT	AR	71857	8708876639	490	Nevada	For profit - Limited Liability company	111	56.5	Medicare and Medicaid	false	KSJ, LLC	12/09/1991	false	true	false	false	Resident	Yes	1	1	4	4		2	1	12	1	12	1.18861	0.57739	0.07239	0.64978	1.83839	0.02143	1.69242	0.61918	0.33457	2.64618	1.45965	0.70119	0.08143	2.22778	05/03/2019	11	6	5	423	1	423	07/13/2018	8	7	1	68	1	68	2017-05-11	3	3	0	1	12	0	12	236.167	1	3	0	0.00	0	0	700 MANOR DRIVE PRESCOTT, AR 71857 (33.787601, -93.380341)	02/01/2020
4450	6975 BURLINGTON PIKE FLORENCE, KY 41042	39.007611	-84.630606	185174	FLORENCE PARK CARE CENTER	6975 BURLINGTON PIKE	FLORENCE	KY	41042	5136055000	70	Boone	For profit - Corporation	150	125.1	Medicare and Medicaid	false	EVAN GRAY, LLC	06/25/1984	false	true	false	false	Resident	Yes	1	2	1	1	1		1		1		1.89638	1.39974	0.21146	1.6112	3.50758	0.04709	2.20231	0.82881	0.44203	3.47315	1.78963	1.26992	0.18005	3.23845	07/25/2019	7	1	6	80	1	80	06/14/2018	5	5	2	20	1	20	2017-05-11	4	4	0	1	24	0	24	50.667	1	1	1	8099.00	0	1	6975 BURLINGTON PIKE FLORENCE, KY 41042 (39.007611, -84.630606)	02/01/2020
7534	107 EAST LONE PINE DRIVE PAYSON, AZ 85541	34.231411	-111.323154	35117	PAYSON CARE CENTER	107 EAST LONE PINE DRIVE	PAYSON	AZ	85541	9284746896	30	Gila	For profit - Limited Liability company	163	85.3	Medicare and Medicaid	false	PAYSON UNITED MEDICAL INVESTORS LLC	11/25/1985	false	true	false	false	Resident	Yes	1	1	4	5	3		3		4		1.79482	0.91844	0.69411	1.61255	3.40737	0.06129	2.05231	0.68454	0.32235	3.0592	1.81758	1.00888	0.81046	3.57162	09/19/2019	10	10	1	76	1	76	07/13/2018	6	6	1	44	1	44	2017-05-11	6	6	1	1	24	0	24	56.667	5	1	1	99788.00	0	1	107 EAST LONE PINE DRIVE PAYSON, AZ 85541 (34.231411, -111.323154)	02/01/2020
10967	411 S LASALLE STREET DURHAM, NC 27705	36.013274	-78.948142	345070	DURHAM NURSING & REHABILITATION CENTER	411 S LASALLE STREET	DURHAM	NC	27705	9193835521	310	Durham	For profit - Corporation	126	92.8	Medicare and Medicaid	false	DURHAM REHAB OPERATIONS LLC	09/01/1973	false	true	false	false	Resident	Yes	1	2	1	2	1		2		2		1.78209	0.75867	0.56336	1.32203	3.10412	0.12137	2.01769	0.79998	0.42905	3.24672	1.83566	0.71311	0.4942	3.06582	06/06/2019	7	6	1	52	1	52	05/17/2018	2	2	1	32	1	32	2017-05-11	1	1	1	1	8	0	8	38	2	1	1	11047.00	0	1	411 S LASALLE STREET DURHAM, NC 27705 (36.013274, -78.948142)	02/01/2020
14076	804 SOUTH LONG DRIVE ROCKINGHAM, NC 28379	34.931562	-79.75119	345378	PRUITTHEALTH-ROCKINGHAM	804 SOUTH LONG DRIVE	ROCKINGHAM	NC	28379	9109974493	760	Richmond	For profit - Corporation	120	88.2	Medicare and Medicaid	false	PRUITTHEALTH ROCKINGHAM LLC	06/21/1991	false	true	false	false	Resident	Yes	2	1	5	5	4		3		3		1.75394	0.93159	0.52438	1.45597	3.20991	0.13049	2.08835	0.72076	0.32821	3.13732	1.74553	0.97189	0.60136	3.28086	08/29/2019	16	8	8	226	1	226	06/21/2018	16	16	2	68	1	68	2017-05-11	11	11	10	1	52	0	52	144.333	1	4	1	224199.00	0	1	804 SOUTH LONG DRIVE ROCKINGHAM, NC 28379 (34.931562, -79.75119)	02/01/2020