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 10 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 "geocode_flag" = :p0 and "ownership" = :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	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 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	Total Number of Penalties	Processing Date
20	12802 US-50, Loogootee, IN 47553, USA	38.6656802	-86.92629649999999	1	ROOFTOP	155263	LOOGOOTEE NURSING CENTER	12802 EAST US HWY 50	LOOGOOTEE	IN	47553	8122952101	500	Martin	Government - City/county	56	31.9	Medicare and Medicaid	false	MAJOR HOSPITAL	09/18/1985	false	false	false	false	Resident	Yes	3	2	5	5		2	3	4	1.78334	0.83234	0.86694	1.69928	3.48262	0.018	2.12978	0.76093	0.35552	3.24623	1.74026	0.82251	0.91781	3.44017	04/18/2019	6	6	0	32	1	32	05/30/2018	12	12	2	56	2	28	84	2017-03-18	4	4	0	1	20	0	20	47.333	0	5	0	0.00	0	02/01/2020
103	W76 N677 N Wauwatosa Rd, Cedarburg, WI 53012, USA	43.2993389	-88.0052043	1	ROOFTOP	525537	LASATA CARE CENTER	W76 N677 WAUWATOSA RD	CEDARBURG	WI	53012	2623775060	440	Ozaukee	Government - City/county	130	121.3	Medicare and Medicaid	false	COUNTY OF OZAUKEE	07/01/1994	false	false	false	false	Resident	Yes	4	3	4	4	3		5	5	2.93902	0.77321	1.12672	1.89994	4.83896	0.03996	2.26645	0.68988	0.32771	3.28404	2.69509	0.84277	1.29409	4.72495	01/09/2019	5	5	0	36	1	36	10/09/2017	1	1	0	8	1	0	8	2016-07-28	18	18	0	1	104	0	104	38	0	0	0	0.00	0	02/01/2020
1199	E Creek Rd, Nantucket, MA 02554, USA	41.274316	-70.090683	1	GEOMETRIC_CENTER	225772	OUR ISLAND HOME	EAST CREEK ROAD	NANTUCKET	MA	2554	5082280462	120	Nantucket	Government - City/county	45	39.4	Medicare and Medicaid	false	TOWN OF NANTUCKET	08/01/2007	false	false	false	false	Both	Yes	3	3	1	3	1		4	4	2.46416	0.79923	0.79774	1.59696	4.06112	0.03251	1.96195	0.66605	0.29099	2.91899	2.61034	0.90229	1.03183	4.46135	02/27/2019	5	5	0	20	1	20	11/09/2017	5	5	0	40	1	0	40	2016-09-27	6	6	0	1	36	0	36	29.333	0	0	1	8778.00	1	02/01/2020
1555	457 IN-145, French Lick, IN 47432, USA	38.5494486	-86.6115773	1	ROOFTOP	155126	SPRINGS VALLEY MEADOWS	457 S SR 145	FRENCH LICK	IN	47432	8129369991	580	Orange	Government - City/county	74	65.3	Medicare and Medicaid	false	THE HEALTH AND HOSPITAL CORPORATION OF MARION COUNTY	04/11/1972	false	false	false	false	Resident	Yes	5	5	4	5	2		2	2	2.01069	0.89822	0.59571	1.49392	3.50462	0.12747	2.27953	0.88573	0.46023	3.62549	1.83323	0.76255	0.48717	3.09975	04/05/2019	0	0	0	0	0	0	02/26/2018	6	6	0	24	1	0	24	2016-12-14	3	3	0	1	12	0	12	10	0	0	0	0.00	0	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	0	20	2017-07-13	19	19	0	1	112	0	112	83.333	1	3	1	22032.00	1	02/01/2020
3859	14688 IL-82, Geneseo, IL 61254, USA	41.3631964	-90.1637508	1	ROOFTOP	145949	HILLCREST HOME	14688 ILLINOIS HIGHWAY 82	GENESEO	IL	61254	3099442147	450	Henry	Government - City/county	106	91.6	Medicare and Medicaid	false	HILLCREST HOME	02/01/1998	false	false	false	false	Both	Yes	5	5	3	2	4		2	2	2.09135	0.8149	0.32917	1.14407	3.23542	0.00484	1.93635	0.63407	0.27545	2.84586	2.24471	0.96638	0.4498	3.64561	03/28/2019	2	2	0	4	1	4	05/10/2018	7	7	0	40	1	0	40	2017-04-20	1	1	0	1	8	0	8	16.667	0	0	0	0.00	0	02/01/2020
4286	78 Hospital Dr, Macon, MS 39341, USA	33.1220867	-88.5588576	1	ROOFTOP	25A374	NOXUBEE COUNTY NURSING HOME	78 HOSPITAL RD	MACON	MS	39341	6627262097	510	Noxubee	Government - City/county	60	52.1	Medicaid	false	Legal Business Name Not Available	10/22/1991	false	false	false	false	Resident	Yes	5	5	2	2		2	5	5	2.86215	0.9964	0.73279	1.7292	4.59135	0.05127	2.00327	0.62719	0.26112	2.89159	2.9694	1.19458	1.05625	5.09163	05/16/2019	1	1	0	4	1	4	03/29/2017	0	0	0	0	0	0	0	2016-05-06	1	1	0	1	16	0	16	4.667	1	0	0	0.00	0	02/01/2020
6795	103 Fram St, Petersburg, AK 99833, USA	56.8128691	-132.9554619	1	ROOFTOP	25019	PETERSBURG MEDICAL CENTER LTC	P.O. BOX 589	PETERSBURG	AK	99833	9077724291	195	Petersburg Borough	Government - City/county	15	13.2	Medicare and Medicaid	true	THE PETERSBURG MEDICAL CENTER	01/01/1981	false	false	false	false	Resident	Yes	5	5	5	5		2	5	5	4.69812	0.39221	1.92334	2.31555	7.01367	0.04269	2.12301	0.67905	0.27674	3.0788	4.59927	0.43431	2.61584	7.30494	04/12/2019	5	5	0	20	1	20	04/27/2018	8	8	0	84	1	0	84	2017-03-17	6	6	0	1	32	0	32	43.333	0	0	0	0.00	0	02/01/2020
13376	Gracedale Ave, Nazareth, PA 18064, USA	40.7380705	-75.3295748	1	GEOMETRIC_CENTER	395476	NORTHAMPTON COUNTY-GRACEDALE	GRACEDALE AVENUE	NAZARETH	PA	18064	6107461900	590	Northampton	Government - City/county	688	649.3	Medicare and Medicaid	false	COUNTY OF NORTHAMPTON	11/01/1980	false	false	false	false	Both	Yes	2	3	1	1	1		2	2	1.87815	0.85365	0.40697	1.26063	3.13878	0.0411	1.99103	0.70291	0.34361	3.03755	1.96051	0.91319	0.44579	3.31353	12/14/2018	13	11	2	52	1	52	11/17/2017	5	3	2	24	1	0	24	2017-01-13	10	9	1	2	40	20	60	44	0	5	0	0.00	0	02/01/2020
15405	3301 FM3009, Schertz, TX 78154, USA	29.5840208	-98.26725619999999	1	ROOFTOP	676301	AUTUMN WINDS LIVING & REHABILITATION	3301 FM 3009	SCHERTZ	TX	78154	2106586338	581	Guadalupe	Government - City/county	96	77.8	Medicare and Medicaid	false	GUADALUPE COUNTY HOSPITAL BOARD	12/11/2011	false	false	false	false	Resident	Yes	1	2	2	3	1		1	1	2.25035	0.75346	0.25869	1.01215	3.2625	0.01397	1.989	0.86247	0.49553	3.34701	2.35142	0.6569	0.19649	3.1257	03/28/2019	20	18	2	152	1	152	03/23/2018	10	10	0	80	1	0	80	2017-02-17	8	5	3	1	72	0	72	114.667	0	5	0	0.00	0	02/01/2020