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	Long-Stay QM Rating Footnote	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 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
2067	3520 KENNETH DRIVE MACON, GA 31206	32.795431	-83.695568	115652	CHERRY BLOSSOM HEALTH AND REHABILITATION	3520 KENNETH DRIVE	MACON	GA	31206	4787817553	90	Bibb	Non profit - Other	82	72	Medicare and Medicaid	false	CHERRY BLOSSOM HEALTH CARE CENTER LLC	02/01/1998	false		true	false	false	Resident	Yes	1	1	2	3		2	2	2	1.88059	1.04064	0.35181	1.39246	3.27305	0.06936	2.15176	0.78166	0.37672	3.31014	1.81642	1.00108	0.35149	3.17073	12/05/2019	9	2	7	199	1	0	199	07/26/2018	3	3	0	16	1	16	2017-07-20	2	2	0	1	32	32	110.167	0	4	1	13905.00	0	1	3520 KENNETH DRIVE MACON, GA 31206 (32.795431, -83.695568)	02/01/2020
6382	14900 MIDDLEBELT RD LIVONIA, MI 48154	42.394064	-83.334268	235479	REGENCY AT LIVONIA	14900 MIDDLEBELT RD	LIVONIA	MI	48154	7344254200	810	Wayne	For profit - Corporation	142	123.6	Medicare and Medicaid	false	MIDDLEBELT HOPE ACQUISTION COMPANY INC	01/06/1989	false		true	false	false	Resident	Yes	3	2	5	5		5	2	2	1.84955	0.87591	0.4075	1.28341	3.13296	0.07253	2.12861	0.70427	0.31301	3.14589	1.80586	0.93521	0.49	3.19348	08/28/2019	16	10	6	124	1	0	124	09/27/2018	12	10	5	112	1	112	2017-07-20	19	13	9	1	128	128	120.667	8	19	4	85444.00	0	4	14900 MIDDLEBELT RD LIVONIA, MI 48154 (42.394064, -83.334268)	02/01/2020
7210	415 COOK SPRINGS PELL CITY, AL 35125	33.593208	-86.398024	15195	VILLAGE AT COOK SPRINGS SKILLED NURSING FACILITY	415 COOK SPRINGS	PELL CITY	AL	35125	2053382221	570	St. Clair	Non profit - Corporation	168	147.1	Medicare and Medicaid	false	VILLAGE AT COOK SPRINGS, LLC	12/01/1977	true	SFF Candidate	true	false	false	Resident	Yes	2	1	4	4		5	4	4	2.33117	0.81728	0.66763	1.4849	3.81608	0.01572	2.00682	0.67553	0.31048	2.99283	2.41425	0.90972	0.80935	4.08873	07/28/2019	5	5	4	208	2	104	312	08/16/2018	10	5	5	132	1	132	2017-07-20	8	8	0	1	44	44	207.333	0	5	2	619290.00	1	3	415 COOK SPRINGS PELL CITY, AL 35125 (33.593208, -86.398024)	02/01/2020
7529	2990 EAST RAMON ROAD PALM SPRINGS, CA 92264	33.815896	-116.513422	56328	PREMIER CARE CENTER FOR PALM SPRINGS	2990 EAST RAMON ROAD	PALM SPRINGS	CA	92264	7603232638	430	Riverside	For profit - Individual	99	87.7	Medicare and Medicaid	false	ENSIGN PALM I LLC	12/26/1973	false		true	false	false	Resident	Yes	2	2	4	5		4	2	2	2.25399	1.36159	0.32269	1.68428	3.93827	0.0734	2.12703	0.76457	0.35473	3.24633	2.20239	1.3391	0.34238	3.89015	05/16/2019	25	16	9	128	1	0	128	06/29/2018	19	9	10	92	1	92	2017-07-20	20	8	12	1	88	88	109.333	19	17	0	0.00	0	0	2990 EAST RAMON ROAD PALM SPRINGS, CA 92264 (33.815896, -116.513422)	02/01/2020
11834	9969 OLD HWY 70 RD MINOCQUA, WI 54548	45.883372	-89.733789	525678	AVANTI HEALTH AND REHABILITATION CENTER, LLC	9969 OLD HWY 70 RD	MINOCQUA	WI	54548	7153566016	420	Oneida	For profit - Partnership	72	55.6	Medicare and Medicaid	false	AVANTI HEALTH AND REHABILITATION CENTER LLC	07/09/2004	false		true	false	false	Resident	Yes	3	2	3	3		3	4	5	2.17848	0.38561	1.09205	1.47766	3.65614	0.11507	2.1485	0.78372	0.36773	3.29996	2.10734	0.36997	1.11774	3.55278	10/09/2019	6	5	1	56	1	0	56	08/27/2018	5	5	0	99	1	99	2017-07-20	5	5	5	1	36	36	67	1	2	1	11050.00	0	1	9969 OLD HWY 70 RD MINOCQUA, WI 54548 (45.883372, -89.733789)	02/01/2020
13024	2801 EUREKA WAY REDDING, CA 96001	40.585677	-122.414102	555588	VIBRA HOSPITAL OF NORTHERN CALIFORNIA D/P SNF	2801 EUREKA WAY	REDDING	CA	96001	5302454112	550	Shasta	For profit - Corporation	32	29.1	Medicare and Medicaid	true	NORTHERN CALIFORNIA REHABILITATION HOSPITAL LLC	02/03/1994	false		true	false	false	Resident	Yes	3	2	4		2	4	4	4	2.66225	2.40935	1.32552	3.73488	6.39712	0.41625	1.97484	0.96198	0.54767	3.48448	2.80177	1.8833	0.91097	5.88708	07/12/2019	11	9	2	68	1	0	68	07/12/2018	17	11	6	84	1	84	2017-07-20	6	6	0	1	36	36	68	5	3	1	10000.00	1	2	2801 EUREKA WAY REDDING, CA 96001 (40.585677, -122.414102)	02/01/2020