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	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 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
386	5405 BABCOCK ST NE PALM BAY, FL 32905	28.014539	-80.622121	0		105985	PALMS REHABILITATION AND HEALTHCARE CENTER, THE	5405 BABCOCK ST NE	PALM BAY	FL	32905	3217220660	40	Brevard	For profit - Limited Liability company	120	114	Medicare and Medicaid	false	5405 BABCOCK STREET OPERATIONS LLC	03/12/1998	false	true	false	false	Both	Yes	2	1	5	5	5	2	2	2.56929	0.97946	0.50039	1.47985	4.04914	0.08141	2.18161	0.81648	0.41726	3.41535	2.44766	0.90204	0.45136	3.80172	05/16/2019	12	8	4	236	1	236	02/15/2018	4	4	0	28	1	0	28	2017-01-26	4	4	0	1	16	16	130	1	2	1	27810.00	0	1	5405 BABCOCK ST NE PALM BAY, FL 32905 (28.014539, -80.622121)	02/01/2020
7662	1200 MCCUTCHEN ROAD ROLLA, MO 65401	37.952945	-91.748048	0		265844	ROLLA HEALTH & REHABILITATION SUITES	1200 MCCUTCHEN ROAD	ROLLA	MO	65401	5733642311	800	Phelps	For profit - Corporation	116	70.5	Medicare and Medicaid	false	SRZ OP ROLLA LLC	04/05/2013	false	true	false	false	Resident	Yes	2	2	1	1	2	4	4	2.21052	0.4582	0.69278	1.15098	3.3615	0.05819	1.93405	0.72153	0.33737	2.99296	2.37543	0.47752	0.77288	3.60152	12/21/2018	7	6	2	44	1	44	03/13/2018	13	13	3	72	1	0	72	2017-01-26	6	5	1	1	44	44	53.333	2	3	0	0.00	0	0	1200 MCCUTCHEN ROAD ROLLA, MO 65401 (37.952945, -91.748048)	02/01/2020
9400	4200 Harrington Dr, Zanesville, OH 43701, USA	40.0051096	-82.0268703	1	ROOFTOP	366429	ALTERCARE ZANESVILLE INC.	4200 HARRINGTON DRIVE	ZANESVILLE	OH	43701	7404524351	610	Muskingum	For profit - Corporation	99	76.5	Medicare and Medicaid	false	ALTERCARE ZANESVILLE INC	11/04/2015	false	true	false	false	Resident	Yes	1	1	2	3	1	2	2	1.82748	0.7284	0.56992	1.29832	3.1258	0.0688	2.0532	0.85986	0.47686	3.38992	1.84986	0.63698	0.44984	2.95682	04/25/2019	19	13	7	116	1	116	03/20/2018	37	32	5	180	1	0	180	2017-01-26	9	8	1	1	56	56	127.333	0	10	0	0.00	0	0		02/01/2020
12824	25150 Lakecrest Manor Dr, Katy, TX 77493, USA	29.79942	-95.80086070000002	1	ROOFTOP	676417	STERLING OAKS REHABILITATION	25150 LAKECREST MANOR DR	KATY	TX	77493	2813478200	610	Harris	For profit - Corporation	126	100	Medicare and Medicaid	false	KATY LONG TERM CARE LLC	01/26/2017	false	true	false	false	Both	Yes	1	1	2	2	3	2	2	2.17253	0.71121	0.32895	1.04016	3.21269	0.05169	2.08551	0.79056	0.38327	3.25934	2.16505	0.67647	0.32304	3.16077	02/05/2019	23	11	16	284	1	284	03/02/2018	22	14	8	224	2	112	336	2017-01-26	5	0	5	0	52	52	262.667	8	37	2	79826.00	3	5		02/01/2020
14237	4048 RED BLUFF ROAD PASADENA, TX 77503	29.680598	-95.149185	0		676155	THE COURTYARDS AT PASADENA	4048 RED BLUFF ROAD	PASADENA	TX	77503	7134777877	610	Harris	For profit - Corporation	196	126.7	Medicare and Medicaid	false	LIBERTY COUNTY HOSPITAL DISTRICT NO 1	10/05/2007	false	true	false	false	Resident	Yes	1	1	2	2	2	1	1	1.93226	0.94805	0.31126	1.2593	3.19156	0.04877	2.06438	0.77872	0.42196	3.26505	1.94533	0.91544	0.27764	3.13449	04/25/2019	9	2	7	324	1	324	03/01/2018	5	5	0	48	1	0	48	2017-01-26	4	3	1	1	40	40	184.667	2	5	2	20993.00	1	3	4048 RED BLUFF ROAD PASADENA, TX 77503 (29.680598, -95.149185)	02/01/2020
14372	1814 Atrium Pl Dr, Harlingen, TX 78550, USA	26.1679314	-97.65767079999999	1	ROOFTOP	676125	WINDSOR ATRIUM	1814 ATRIUM PLACE	HARLINGEN	TX	78550	9562302300	240	Cameron	For profit - Corporation	111	110.5	Medicare and Medicaid	false	STARR COUNTY HOSPITAL DISTRICT	02/01/2007	false	true	false	false	Resident	Yes	2	1	5	4	5	1	1	2.25128	1.20805	0.16908	1.37713	3.62841	0.0786	2.22246	0.87625	0.45542	3.55413	2.10529	1.03667	0.13973	3.27368	02/01/2019	21	16	5	192	1	192	02/16/2018	17	16	1	136	1	0	136	2017-01-26	24	10	14	1	208	208	176	4	3	1	6633.00	0	1		02/01/2020