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 6 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	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 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	Location	Processing Date
2480	10303 STATE ROAD MOKANE, MO 65059	38.681023	-91.881396	0		265434	RIVERVIEW NURSING CENTER	10303 STATE ROAD C	MOKANE	MO	65059	5736763136	130	Callaway	For profit - Individual	60	40	Medicare and Medicaid	false	MOKANE NO 1 INC	08/15/1990	false	true	false	false	Resident	Yes	2	1	5	5		2	1	12	1	12	2.2617	0.74742	0.40282	1.15023	3.41193	0.03795	1.69027	0.60812	0.2812	2.57959	2.78096	0.92418	0.53916	4.24133	04/18/2019	12	11	1	80	1	80	03/16/2018	21	18	3	156	1	156	2017-01-11	9	7	2	1	52	52	100.667	3	5	0	0.00	0	10303 STATE ROAD MOKANE, MO 65059 (38.681023, -91.881396)	02/01/2020
2748	100 KINGSTON ROAD SULPHUR, LA 70663	30.228871	-93.328746	0		195431	HOLLY HILL HOUSE	100 KINGSTON ROAD	SULPHUR	LA	70663	3376255843	90	Calcasieu	For profit - Corporation	200	97.1	Medicare and Medicaid	false	HOLLY HILL HOUSE, LLC	09/01/1997	false	true	false	false	Resident	Yes	1	1	1	2	1		2		2		2.34712	0.88301	0.31215	1.19516	3.54227	0.0567	1.90514	0.68678	0.281	2.87292	2.5605	0.96678	0.41811	3.95377	01/10/2019	9	0	9	265	1	265	02/28/2018	5	3	2	24	1	24	2017-01-11	7	2	5	1	40	40	147.167	8	4	1	39234.00	1	100 KINGSTON ROAD SULPHUR, LA 70663 (30.228871, -93.328746)	02/01/2020
7874	500 6TH STREET MENDOTA, IL 61342	41.547602	-89.114541	0		146072	MENDOTA LUTHERAN HOME	500 6TH STREET	MENDOTA	IL	61342	8155397439	580	La Salle	Non profit - Corporation	99	45.1	Medicare and Medicaid	false	AMERICAN LUTHERAN CHURCH MENDOTA	01/10/2005	false	true	false	false	Resident	Yes	3	2	4	3	5		4		4		2.67075	0.68631	0.73551	1.42183	4.09258	0.0327	2.29591	0.72728	0.29595	3.31913	2.41765	0.70959	0.93543	3.9539	03/22/2019	11	4	7	131	1	131	02/15/2018	4	4	0	20	1	20	2017-01-11	3	3	0	1	12	12	74.167	2	3	0	0.00	0	500 6TH STREET MENDOTA, IL 61342 (41.547602, -89.114541)	02/01/2020
12269	5790 Denlinger Rd, Dayton, OH 45426, USA	39.8291741	-84.2721832	1	ROOFTOP	365309	FRIENDSHIP VILLAGE	5790 DENLINGER ROAD	DAYTON	OH	45426	9378375581	580	Montgomery	Non profit - Corporation	127	107.1	Medicare and Medicaid	false	DAYTON SENIOR CARE LLC	09/17/1974	true	true	false	false	Resident	Yes	2	1	5	5	5		1	12	1	12	2.06032	1.65276	0.1531	1.80587	3.86618	0.0443	2.15041	0.81112	0.42243	3.38396	1.99126	1.53218	0.13642	3.66362	06/27/2019	15	11	8	229	1	229	03/22/2018	21	12	9	144	1	144	2017-01-11	8	5	3	1	44	44	169.833	2	11	0	0.00	0		02/01/2020
13819	145 OLIVE ST AKRON, OH 44310	41.097119	-81.510443	0		365259	CANAL POINTE NURSING & REHAB CENTER	145 OLIVE ST	AKRON	OH	44310	3307620901	780	Summit	For profit - Corporation	120	99.5	Medicare and Medicaid	false	OLIVE HEALTH CARE, INC.	01/13/1971	false	true	false	false	Both	Yes	2	2	4	5	3		2		2		1.9394	0.88304	0.44663	1.32967	3.26907	0.01617	1.92472	0.79283	0.41221	3.12977	2.09419	0.83749	0.40781	3.34939	05/16/2019	3	1	2	32	1	32	04/05/2018	5	4	4	28	1	28	2017-01-11	10	5	5	1	44	44	32.667	2	4	0	0.00	0	145 OLIVE ST AKRON, OH 44310 (41.097119, -81.510443)	02/01/2020
14963	59 BLACKSTOCK ROAD INMAN, SC 29349	35.038462	-82.090637	0		425303	LAKE EMORY POST ACUTE CARE	59 BLACKSTOCK ROAD	INMAN	SC	29349	8644722028	410	Spartanburg	For profit - Corporation	88	80.2	Medicare and Medicaid	false	THI OF SOUTH CAROLINA AT CAMP CARE, LLC	02/15/1991	false	true	false	false	Both	Yes	1	1	2	3	1		3		3		2.00711	0.96425	0.45326	1.41751	3.42462	0.03594	2.10584	0.67886	0.29964	3.08433	1.9809	1.06805	0.56936	3.56044	04/25/2019	19	17	5	152	1	152	05/02/2018	8	8	0	40	1	40	2017-01-11	7	7	0	1	72	72	101.333	2	0	1	13905.00	1	59 BLACKSTOCK ROAD INMAN, SC 29349 (35.038462, -82.090637)	02/01/2020