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 4 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 date("Rating Cycle 3 Standard Health Survey Date") = :p0 and "Reported Staffing Footnote" = :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	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	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 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	Total Number of Penalties	Location	Processing Date
3750	404 MAIN STREET FENTON, MO 63026	38.51337	-90.436376	26A490	FIESER NURSING CENTER	404 MAIN STREET	FENTON	MO	63026	6363434344	940	St. Louis	For profit - Corporation	60	33.1	Medicaid	false	Legal Business Name Not Available	08/03/2006	false	false	false	false	Resident	Yes	1	1	1	1		2	1	12	1	12	6	6	04/10/2019	17	17	0	116	2	58	174	06/01/2018	12	11	1	108	1	108	2017-05-12	10	10	1	1	32	0	32	128.333	1	2	0	0.00	0	404 MAIN STREET FENTON, MO 63026 (38.51337, -90.436376)	02/01/2020
9902	103 N THIRTEENTH STREET FRANKLIN, PA 16323	41.403294	-79.83128	395959	CARING PLACE, THE	103 N. THIRTEENTH STREET	FRANKLIN	PA	16323	8144324491	730	Venango	Non profit - Church related	100	96	Medicare and Medicaid	false	GROVE MANOR CORPORATION	09/28/1995	false	false	false	false	Both	Yes	4	4	5	4	5		1	12	1	12	6	6	06/07/2019	3	3	0	12	1	0	12	04/13/2018	2	2	0	12	1	12	2017-05-12	4	4	0	1	28	0	28	14.667	0	0	0	0.00	0	103 N THIRTEENTH STREET FRANKLIN, PA 16323 (41.403294, -79.83128)	02/01/2020
11969	179 SOUTH FAIRVIEW LANE SONORA, CA 95370	37.978887	-120.391402	555209	ADVENTIST HEALTH SONORA - D/P SNF	179 SOUTH FAIRVIEW LANE	SONORA	CA	95370	2095363779	650	Tuolumne	Non profit - Church related	68	66.4	Medicare and Medicaid	true	SONORA COMMUNITY HOSPITAL	10/07/1985	true	false	false	false	Resident	Yes	4	4	5	5		2	1	12	1	12	6	6	06/07/2019	4	4	0	16	1	0	16	03/22/2018	5	3	2	24	1	24	2017-05-12	5	5	1	2	60	30	90	31	5	0	1	39939.00	1	179 SOUTH FAIRVIEW LANE SONORA, CA 95370 (37.978887, -120.391402)	02/01/2020
12659	905 BEALL ROAD KINGFISHER, OK 73750	35.832737	-97.937318	375102	CIMARRON NURSING CENTER	905 BEALL ROAD	KINGFISHER	OK	73750	4053756857	360	Kingfisher	For profit - Corporation	92	73.6	Medicare and Medicaid	false	Legal Business Name Not Available	12/14/1989	false	false	false	false	Resident	Yes	1	2	1	1	2		1	12	1	12	6	6	10/07/2019	15	13	2	104	0	0	104	08/07/2018	15	15	0	120	1	120	2017-05-12	15	14	1	1	80	0	80	105.333	0	2	1	6500.00	1	905 BEALL ROAD KINGFISHER, OK 73750 (35.832737, -97.937318)	02/01/2020