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	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	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 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
2898	3250 SW 41ST PLACE GAINESVILLE, FL 32608	29.615652	-82.370169	105193	PARK MEADOWS HEALTH AND REHABILITATION CENTER	3250 SW 41ST PLACE	GAINESVILLE	FL	32608	3523781558	0	Alachua	For profit - Corporation	154	147	Medicare and Medicaid	false	THE OAKS NH LLC	11/20/1968	false		true	false	false	Both	Yes	2	1	3	3	3	4	3	2.53404	1.00712	0.51995	1.52707	4.06111	0.11605	1.89999	0.69336	0.33395	2.9273	2.7719	1.09221	0.58602	4.44868	03/21/2019	10	5	5	232	1	0	232	01/11/2018	9	9	0	48	1	0	48	2017-02-09	11	8	3	1	60	0	60	142	1	3	0	0.00	0	0	3250 SW 41ST PLACE GAINESVILLE, FL 32608 (29.615652, -82.370169)	02/01/2020
4751	516 WEST FRECH STREET STREATOR, IL 61364	41.140037	-88.843063	145989	PARKER NURSING & REHAB CENTER	516 WEST FRECH STREET	STREATOR	IL	61364	8156722600	580	La Salle	For profit - Corporation	102	52.7	Medicare and Medicaid	false	PARKER NURSING & REHABILITATION CENTER, LLC	05/11/1999	false	SFF Candidate	true	false	false	Resident	Yes	2	1	5	5	5	2	2	1.91677	0.64732	0.40888	1.05619	2.97296	0.01878	2.54776	0.83347	0.3997	3.78093	1.5636	0.584	0.38502	2.52141	01/17/2019	20	5	15	544	1	0	544	03/02/2018	9	1	8	40	1	0	40	2017-02-09	12	10	2	1	116	0	116	304.667	0	17	2	9309.00	0	2	516 WEST FRECH STREET STREATOR, IL 61364 (41.140037, -88.843063)	02/01/2020
6594	725 W GENESEE FRANKENMUTH, MI 48734	43.335854	-83.748128	235269	WELLSPRING LUTHERAN SERVICES	725 W GENESEE	FRANKENMUTH	MI	48734	9896529951	720	Saginaw	Non profit - Corporation	112	70.7	Medicare and Medicaid	false	LUTHERAN HOMES OF MICHIGAN, INC	03/01/1976	false		true	false	false	Resident	Yes	3	2	3	4	2	4	4	3.06322	1.0423	0.90747	1.94978	5.01299	0.05842	2.14135	0.70955	0.32888	3.17979	2.97308	1.10457	1.03854	5.05536	03/14/2019	10	10	2	92	1	0	92	03/15/2018	19	18	1	116	2	58	174	2017-02-09	22	12	10	1	168	0	168	132	6	8	0	0.00	0	0	725 W GENESEE FRANKENMUTH, MI 48734 (43.335854, -83.748128)	02/01/2020
8833	1200 LANE LAREDO, TX 78043	29.034269	-98.565069	455528	RETAMA MANOR NURSING CENTER/LAREDO-WEST	1200 LANE	LAREDO	TX	78043	9567220031	953	Webb	For profit - Corporation	198	136.8	Medicare and Medicaid	false	UVALDE COUNTY HOSPITAL AUTHORITY	07/03/1985	false	SFF Candidate	true	false	false	Resident	Yes	1	1	3	3	2	1	1	2.14726	0.79267	0.36387	1.15654	3.30379	0.03255	2.13372	0.80901	0.4495	3.39224	2.09152	0.73675	0.30468	3.12306	01/18/2019	11	7	4	136	1	0	136	02/16/2018	24	20	6	176	1	0	176	2017-02-09	35	9	26	1	899	0	899	276.5	4	12	3	238101.00	0	3	1200 LANE LAREDO, TX 78043 (29.034269, -98.565069)	02/01/2020
11746	11830 NORTHPOINTE BOULEVARD TOMBALL, TX 77377	30.033071	-95.610194	676244	GRACE CARE CENTER AT NORTHPOINTE	11830 NORTHPOINTE BOULEVARD	TOMBALL	TX	77377	2812059400	610	Harris	For profit - Corporation	135	100.9	Medicare and Medicaid	false	NORTHPOINTE LTC LTD	02/16/2010	false		true	false	false	Resident	Yes	1	1	2	2	2	2	1	2.01696	1.56291	0.3458	1.9087	3.92566	0	2.17508	0.80045	0.41769	3.39323	1.92725	1.46819	0.3116	3.70982	02/15/2019	11	5	8	108	1	0	108	02/02/2018	17	8	9	184	1	0	184	2017-02-09	10	7	3	1	96	0	96	131.333	3	13	4	44104.00	1	5	11830 NORTHPOINTE BOULEVARD TOMBALL, TX 77377 (30.033071, -95.610194)	02/01/2020
12026	1600 BLAND STREET BLUEFIELD, WV 24701	37.258782	-81.219128	515186	MAPLES NURSING HOME	1600 BLAND STREET	BLUEFIELD	WV	24701	3043272485	270	Mercer	For profit - Corporation	60	56	Medicare and Medicaid	false	Legal Business Name Not Available	05/01/2004	false	SFF Candidate	true	false	false	Resident	Yes	1	1	2	2	2	3	3	2.26624	1.34272	0.52893	1.87165	4.13789	0.01815	1.8901	0.74527	0.38748	3.02285	2.49194	1.35474	0.51378	4.38951	04/11/2019	24	24	0	402	2	201	603	04/05/2018	21	21	0	104	1	0	104	2017-02-09	18	18	4	2	124	62	186	367.167	0	5	1	81262.00	2	3	1600 BLAND STREET BLUEFIELD, WV 24701 (37.258782, -81.219128)	02/01/2020