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 5 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 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	Number of Payment Denials	Total Number of Penalties	Location	Processing Date
1712	431 WEST RACE STREET ROLLING FORK, MS 39159	32.905796	-90.88511	255220	SHARKEY-ISSAQUENA NURSING HOME	431 WEST RACE STREET	ROLLING FORK	MS	39159	6628735182	620	Sharkey	Government - County	54	45.6	Medicare and Medicaid	false	SHARKEY-ISSAQUENA COMMUNITY HOSPITAL	01/01/1996	false		true	false	false	Both	Yes	1	1	1	1	1	3	2	3.14847	0.95231	0.33772	1.29003	4.4385	0.00804	1.94311	0.59609	0.27636	2.81556	3.36758	1.20129	0.45995	5.05503	10/11/2018	6	1	5	88	1	88	07/14/2017	3	2	1	16	1	16	2016-09-22	4	4	0	1	24	24	53.333	1	1	1	8099.00	0	1	431 WEST RACE STREET ROLLING FORK, MS 39159 (32.905796, -90.88511)	02/01/2020
5318	3293 NORTH DRINKWATER BOULEVARD SCOTTSDALE, AZ 85251	33.48566	-111.923896	35059	HAVEN OF SCOTTSDALE	3293 NORTH DRINKWATER BOULEVARD	SCOTTSDALE	AZ	85251	4809477443	60	Maricopa	For profit - Corporation	90	47.2	Medicare and Medicaid	false	HAVEN OF SCOTTSDALE LLC	11/16/1978	false		true	false	false	Resident	Yes	3	2	5	5	4	2	3	1.84634	0.80016	0.70324	1.5034	3.34974	0.1716	2.24932	0.83631	0.4192	3.50482	1.70599	0.71944	0.63142	3.06478	01/25/2019	5	5	1	40	1	40	10/25/2017	4	4	3	20	1	20	2016-09-22	6	6	0	1	24	24	30.667	1	1	1	6633.00	0	1	3293 NORTH DRINKWATER BOULEVARD SCOTTSDALE, AZ 85251 (33.48566, -111.923896)	02/01/2020
5731	680 COLE STREET CARLISLE, IA 50047	41.495666	-93.493113	165255	CARLISLE CENTER FOR WELLNESS AND REHAB	680 COLE STREET	CARLISLE	IA	50047	5159890871	900	Warren	For profit - Partnership	101	63.1	Medicare and Medicaid	false	PACIFICA HEALTH SERVICES LLC	06/01/1995	false	SFF Candidate	true	false	false	Resident	Yes	1	1	3	2	5	3	3	1.99772	0.79937	0.4717	1.27107	3.26879	0.01606	1.91643	0.68179	0.31153	2.90975	2.16649	0.88162	0.56989	3.60233	03/07/2019	20	17	10	354	1	354	10/26/2017	7	7	1	36	1	36	2016-09-22	11	10	1	1	76	76	201.667	5	5	2	40740.00	1	3	680 COLE STREET CARLISLE, IA 50047 (41.495666, -93.493113)	02/01/2020
7847	3001 N HURSTBOURNE PARKWAY LOUISVILLE, KY 40241	38.292995	-85.575383	185305	SPRINGHURST HEALTH AND REHAB	3001 N. HURSTBOURNE PARKWAY	LOUISVILLE	KY	40241	5024265531	550	Jefferson	Non profit - Church related	90	56.7	Medicare and Medicaid	false	BAPTIST HOMES, INC.	12/01/1991	false	SFF Candidate	true	false	false	Resident	Yes	1	1	1	1	2	4	4	2.14569	1.15285	0.883	2.03584	4.18153	0	2.25319	0.74021	0.39509	3.38849	1.97918	1.17112	0.84118	3.95714	01/18/2019	20	10	10	839	1	839	11/09/2017	16	3	13	764	1	764	2016-09-22	17	6	11	1	128	128	695.5	3	3	4	358693.00	3	7	3001 N HURSTBOURNE PARKWAY LOUISVILLE, KY 40241 (38.292995, -85.575383)	02/01/2020
9011	63 BLACKSTOCK ROAD INMAN, SC 29349	35.03671	-82.090405	425032	MAGNOLIA MANOR - INMAN	63 BLACKSTOCK ROAD	INMAN	SC	29349	8644729055	410	Spartanburg	For profit - Corporation	176	161.5	Medicare and Medicaid	false	THI OF SOUTH CAROLINA AT MAGNOLIA MANORINMAN, LLC	01/01/1967	false		true	false	false	Resident	Yes	1	1	2	1	3	1	1	1.88192	1.06955	0.22834	1.29789	3.17982	0.03622	1.9639	0.65794	0.2998	2.92165	1.99158	1.22235	0.28667	3.49001	12/20/2018	22	13	11	152	1	152	10/05/2017	10	7	3	88	1	88	2016-09-22	11	11	0	1	80	80	118.667	5	0	3	105382.00	1	4	63 BLACKSTOCK ROAD INMAN, SC 29349 (35.03671, -82.090405)	02/01/2020