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 "Overall Rating Footnote" = :p0 and "geocode_flag" = :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 Footnote	Health Inspection Rating Footnote	QM Rating Footnote	Long-Stay QM Rating Footnote	Short-Stay QM Rating Footnote	Staffing Rating Footnote	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 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	Processing Date
4164	621 W 21st St, Andover, KS 67002, USA	37.72251	-97.1414099	1	ROOFTOP	175157	LIFE CARE CENTER OF ANDOVER	621 W 21ST, PO BOX 100	ANDOVER	KS	67002	3167331349	70	Butler	For profit - Corporation	154	76.8	Medicare and Medicaid	false	ANDOVER MEDICAL INVESTORS, LLC	10/31/1986	true	SFF	false	false	false	Resident	Yes	18	18	18	18	18	18	18	2.13408	0.98012	0.32956	1.30968	3.44377	0.14483	2.04491	0.73652	0.3436	3.12503	2.16897	1.00064	0.36101	3.53372	02/07/2019	41	26	22	434	2	217	651	03/06/2018	32	26	15	256	1	0	256	2016-09-06	36	27	9	2	364	182	546	501.833	3	28	5	350261.00	1	6	02/01/2020
10411	1104 US-12, Hettinger, ND 58639, USA	46.0026439	-102.6256355	1	ROOFTOP	355042	WESTERN HORIZONS CARE CENTER	1104 HWY 12	HETTINGER	ND	58639	7015672401	0	Adams	Non profit - Corporation	45	38.7	Medicare and Medicaid	false	WESTERN HORIZONS LIVING CENTERS	05/01/1978	false	SFF	false	false	false	Resident	Yes	18	18	18	18	18	18	18	2.9425	0.60227	0.58489	1.18716	4.12966	0.00793	2.00509	0.62943	0.24733	2.88185	3.04999	0.71949	0.8901	4.59511	07/11/2019	4	4	0	16	1	0	16	12/20/2018	8	8	0	36	1	0	36	2018-01-25	52	16	36	1	551	0	551	111.833	0	17	1	193772.00	0	1	02/01/2020
10713	1 Penn Blvd, Philadelphia, PA 19144, USA	40.0403868	-75.1595035	1	ROOFTOP	396129	WILLOW TERRACE	ONE PENN BOULEVARD	PHILADELPHIA	PA	19144	2159518500	620	Philadelphia	For profit - Corporation	174	157.5	Medicare and Medicaid	false	WT OPERATING LLC	08/13/2010	true	SFF	false	false	false	Resident	Yes	18	18	18	18	18	18	18	2.20546	1.00255	0.40408	1.40664	3.6121	0.06443	1.9975	0.81605	0.4388	3.25235	2.29471	0.92379	0.34661	3.56135	06/19/2019	27	24	5	172	1	0	172	05/02/2018	51	32	26	605	2	303	908	2017-03-01	9	4	5	1	52	0	52	397.333	2	39	2	202672.00	1	3	02/01/2020
11217	813 1/2 Marion Pike, Coal Grove, OH 45638, USA	38.4998253	-82.6373679	1	ROOFTOP	366202	CRYSTAL CARE OF COAL GROVE	813 1/2 MARION PIKE	COAL GROVE	OH	45638	7405320449	450	Lawrence	For profit - Partnership	57	44.8	Medicare and Medicaid	false	CRYSTAL CARE OF IRONTON, LLC	08/10/2000	false	SFF	false	false	false	Resident	Yes	18	18	18	18	18	18	18	2.10044	0.97837	0.06223	1.0406	3.14105	0.01995	2.26517	0.89473	0.46124	3.62115	1.9272	0.82223	0.05078	2.78151	11/21/2019	24	13	11	144	0	0	144	06/24/2019	70	52	18	636	1	0	636	2018-05-09	31	29	3	1	240	0	240	324	1	12	0	0.00	1	1	02/01/2020
13608	821 I-35BL, New Braunfels, TX 78130, USA	29.6911115	-98.1237433	1	ROOFTOP	455020	COLONIAL MANOR CARE CENTER	821 US HWY 81 W	NEW BRAUNFELS	TX	78130	8306257526	320	Comal	For profit - Corporation	154	126.9	Medicare and Medicaid	false	COLONIAL NEW BRAUNFELS CARE CENTER LLC	06/01/1976	false	SFF	true	false	false	Resident	Yes	18	18	18	18	18	18	18	2.13263	1.26971	0.22817	1.49788	3.63051	0	1.9021	0.79213	0.4156	3.10984	2.33022	1.20529	0.20664	3.74354	02/26/2019	39	31	11	830	1	0	830	02/02/2018	26	21	5	212	1	0	212	2017-01-12	19	5	14	1	793	0	793	617.833	9	26	4	220368.00	1	5	02/01/2020
13685	2400 E Mitchell St, Humboldt, TN 38343, USA	35.8227245	-88.9042207	1	ROOFTOP	445339	BAILEY PARK CLC	2400 MITCHELL STREET	HUMBOLDT	TN	38343	7317845183	260	Gibson	For profit - Individual	50	36.1	Medicare and Medicaid	false	CLC OF HUMBOLDT, LLC	11/02/1994	false	SFF	false	false	false	Resident	Yes	18	18	18	18	18	18	18	2.03168	1.29206	0.54092	1.83298	3.86467	0.11876	2.24378	0.79897	0.3785	3.42124	1.88188	1.21601	0.5379	3.62228	12/04/2019	2	2	0	8	1	0	8	02/28/2019	9	9	0	612	1	0	612	2018-04-11	5	5	0	1	24	0	24	212	0	0	2	326998.00	1	3	02/01/2020
15107	NC-177, Hamlet, NC, USA	34.8920793	-79.7027708	1	GEOMETRIC_CENTER	345293	RICHMOND PINES HEALTHCARE AND REHABILITATION CENTE	HIGHWAY 177 S BOX 1489	HAMLET	NC	28345	9105820021	760	Richmond	For profit - Corporation	105	88.5	Medicare and Medicaid	false	SPRUCE LTC GROUP, LLC	01/18/1989	false	SFF	false	false	false	Both	Yes	18	18	18	18	18	18	18	2.10043	0.82314	0.55654	1.37969	3.48012	0.0587	1.94029	0.73343	0.36447	3.03819	2.24987	0.84392	0.57474	3.6731	10/03/2019	15	15	1	72	1	0	72	04/04/2019	25	19	12	132	1	0	132	2018-10-18	34	22	15	1	355	0	355	139.167	1	44	4	133263.00	2	6	02/01/2020