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 "Number of Fines" = :p0 and "ownership" = :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 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 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	Total Number of Penalties	Location	Processing Date
1330	1660 SOUTH MULFORD ROCKFORD, IL 61108	42.251732	-88.999665	0		145891	ROSEWOOD CARE CENTER OF ROCKFORD	1660 SOUTH MULFORD	ROCKFORD	IL	61108	8153978700	991	Winnebago	Government - Federal	116	70.5	Medicare and Medicaid	false	BRAVO CARE OF ROCKFORD INC	05/29/1996	false	false	false	false	Resident	Yes	3	2	2	2	2		4		4				2.1437	0.73513	0.75308	1.48821	3.63192	0.07636	1.96867	0.76006	0.34511	3.07383	2.26312	0.72728	0.82134	3.78886	03/26/2019	9	8	1	48	1	48	02/06/2018	25	15	10	136	1	0	136	2017-02-01	18	9	9	1	171	171	97.833	3	10	1	68381.00	1	1660 SOUTH MULFORD ROCKFORD, IL 61108 (42.251732, -88.999665)	02/01/2020
5650	1201 THIRD ST GUEYDAN, LA 70542	30.032694	-92.511508	0		195458	GUEYDAN MEMORIAL GUEST HOME	1201 THIRD ST	GUEYDAN	LA	70542	3375366584	560	Vermilion	Government - Federal	66	45.2	Medicare and Medicaid	false	VERMILION PARISH HOSPITAL SERVICE DIST. #3	04/01/1998	false	false	false	false	Resident	Yes	1	3	1	1	1		1	12	1	12	6	6															07/31/2019	2	2	0	24	1	24	07/26/2018	6	6	0	20	1	0	20	2017-08-03	5	5	0	1	32	32	24	0	0	1	7027.00	1	1201 THIRD ST GUEYDAN, LA 70542 (30.032694, -92.511508)	02/01/2020
7839	9380 NW 7TH AVENUE MIAMI, FL 33150	25.860709	-80.209642	0		105449	MIAMI SHORES NURSING AND REHAB CENTER	9380 NW 7TH AVENUE	MIAMI	FL	33150	3057598711	120	Miami-Dade	Government - Federal	99	96.8	Medicare and Medicaid	false	DOS OF NORTH SHORE LTD	03/01/1984	false	false	false	false	Both	Yes	4	2	5	5	5		4		4				3.36123	0.71869	0.68822	1.40691	4.76814	0.00854	2.1114	0.69934	0.31224	3.12298	3.3086	0.77275	0.8296	4.89591	01/18/2019	3	3	0	12	1	12	12/08/2017	10	10	0	72	1	0	72	2017-03-02	8	8	0	1	36	36	36	0	0	1	7748.00	1	9380 NW 7TH AVENUE MIAMI, FL 33150 (25.860709, -80.209642)	02/01/2020
8994	4 NORTH FORK ROAD FORT WASHAKIE, WY 82514	43.003538	-108.882163	0		535050	MORNING STAR CARE CENTER	4 NORTH FORK ROAD	FORT WASHAKIE	WY	82514	3073326902	60	Fremont	Government - Federal	45	32.1	Medicare and Medicaid	false	MORNING STAR CARE CENTER	05/15/1994	false	false	false	false	Resident	Yes	3	2	2	2		2	5		5				3.62459	0	2.37099	2.37099	5.99557	0	1.9559	0.67018	0.29966	2.92573	3.85149	0	2.97808	6.57127	10/03/2019	9	9	0	40	1	40	10/18/2018	13	12	2	88	1	0	88	2017-10-26	7	7	0	1	48	48	57.333	2	0	1	7803.00	1	4 NORTH FORK ROAD FORT WASHAKIE, WY 82514 (43.003538, -108.882163)	02/01/2020
9955	Nespelem, WA 99155, USA	48.1671004	-118.9747476	1	APPROXIMATE	505412	COLVILLE TRIBAL CONVALESCENT C	PO BOX 150	NESPELEM	WA	99155	5096342878	230	Okanogan	Government - Federal	44	32.5	Medicare and Medicaid	false	CONFEDERATED TRIBES OF THE COLVILLE RESERVATION	01/01/1992	false	false	false	false	Resident	Yes	2	2	1	1		2	4		4				2.69985	0.74331	0.65614	1.39945	4.0993	0	1.87295	0.62389	0.24088	2.73772	2.99592	0.89588	1.02523	4.80147	08/16/2019	19	18	4	132	1	132	10/10/2018	17	16	1	163	2	82	245	2017-11-08	8	5	3	1	48	48	155.667	4	1	1	40173.00	1		02/01/2020
10806	110 SUMMIT HILLS DRIVE SPARTANBURG, SC 29307	34.983406	-81.891203	0		425390	SUMMIT HILLS SKILLED NURSING FACILITY	110 SUMMIT HILLS DRIVE	SPARTANBURG	SC	29307	8645912222	410	Spartanburg	Government - Federal	27	17.8	Medicare	false	SUMMIT HILLS, LLC	12/05/2008	true	false	false	false	Both	Yes	4	3	4	5	3		5		5				3.55652	1.33644	1.42873	2.76517	6.32169	0.30393	2.25979	0.85637	0.41673	3.53289	3.27094	1.17346	1.29041	5.73794	11/20/2018	6	6	0	68	1	68	10/05/2017	0	0	0	0	0	0	0	2017-01-04	2	2	0	1	20	20	37.333	0	0	1	20965.00	1	110 SUMMIT HILLS DRIVE SPARTANBURG, SC 29307 (34.983406, -81.891203)	02/01/2020