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	Short-Stay QM Rating Footnote	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 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
1962	521 LOREL WAY YUBA CITY, CA 95991	39.155087	-121.620613	56346	BRIDGEVIEW POST ACUTE	521 LOREL WAY	YUBA CITY	CA	95991	5306749140	610	Sutter	For profit - Limited Liability company	130	105.8	Medicare and Medicaid	false	HANALEI HOLDINGS LLC	08/31/1972	false	SFF Candidate	true	false	false	Resident	Yes	1	1	4	5	3		3	3	2.437	0.73353	0.52445	1.25798	3.69497	0.09003	1.95085	0.70678	0.31623	2.97386	2.59626	0.7804	0.62421	3.98423	10/16/2019	13	8	5	52	1	52	09/05/2018	32	27	11	426	2	213	639	2017-08-02	18	11	7	1	88	0	88	253.667	25	5	0	0.00	1	1	521 LOREL WAY YUBA CITY, CA 95991 (39.155087, -121.620613)	02/01/2020
2664	920 S CHELTON RD COLORADO SPRINGS, CO 80910	38.819187	-104.767812	65246	LAUREL MANOR CARE CENTER, INC	920 S CHELTON RD	COLORADO SPRINGS	CO	80910	7194737780	200	El Paso	Non profit - Corporation	81	71.8	Medicare and Medicaid	false	VOLUNTEERS OF AMERICA CARE FACILITIES	03/01/1989	false		true	false	false	Resident	Yes	3	2	3	3		2	5	5	2.31499	0.82941	0.88765	1.71706	4.03205	0.02549	2.09865	0.66149	0.28799	3.04813	2.29258	0.94282	1.16011	4.24176	12/19/2019	9	6	3	92	0	92	01/10/2019	11	11	1	64	1	0	64	2017-08-02	5	5	0	1	32	0	32	72.667	0	2	1	7433.00	0	1	920 S CHELTON RD COLORADO SPRINGS, CO 80910 (38.819187, -104.767812)	02/01/2020
4163	18525 WOODLAND RIDGE DRIVE SPRING LAKE, MI 49456	43.093319	-86.239029	235373	NORTH OTTAWA CARE CENTER	18525 WOODLAND RIDGE DRIVE	SPRING LAKE	MI	49456	6168420770	690	Ottawa	Non profit - Corporation	84	67.2	Medicare and Medicaid	true	NORTH OTTAWA CARE CENTER INC	08/01/1978	false		true	false	false	Resident	Yes	2	1	3	2	4		4	3	2.95184	0.79332	0.52288	1.31619	4.26804	0.05068	2.07204	0.69536	0.30424	3.07164	2.96082	0.85787	0.64686	4.45565	10/24/2019	16	7	9	505	1	505	10/10/2018	11	10	1	60	1	0	60	2017-08-02	9	9	0	1	76	0	76	285.167	9	4	1	8775.00	1	2	18525 WOODLAND RIDGE DRIVE SPRING LAKE, MI 49456 (43.093319, -86.239029)	02/01/2020
5458	9500 GRAND RIVER AVE DETROIT, MI 48204	42.366698	-83.134	235234	HERITAGE MANOR NURSING AND REHAB CENTER	9500 GRAND RIVER AVE	DETROIT	MI	48204	3134917920	810	Wayne	For profit - Corporation	122	90.4	Medicare and Medicaid	false	HERITAGE MANOR NURSING & REHAB CENTER	10/01/1974	false		true	false	false	Resident	Yes	1	1	2	2	2		2	2	1.67816	1.0695	0.26037	1.32987	3.00803	0.03713	1.72021	0.62567	0.27584	2.62173	2.02752	1.28534	0.35527	3.67915	09/20/2019	29	24	6	465	1	465	10/24/2018	13	10	3	84	1	0	84	2017-08-02	19	16	7	2	120	60	180	290.5	4	16	0	0.00	1	1	9500 GRAND RIVER AVE DETROIT, MI 48204 (42.366698, -83.134)	02/01/2020
6379	4465 W 48TH ST FREMONT, MI 49412	43.467021	-85.911905	235076	NEWAYGO CO MEDICAL CARE FACILI	4465 W 48TH ST	FREMONT	MI	49412	2319242020	610	Newaygo	Government - County	116	91.7	Medicare and Medicaid	false	NEWAYGO MEDICAL CARE FACILITY	01/01/1967	false		true	false	false	Resident	Yes	4	2	5	5	5		5	5	2.71943	0.55328	0.89172	1.44501	4.16444	0.01443	2.11457	0.67052	0.295	3.08009	2.67283	0.62047	1.13773	4.33556	10/18/2019	13	12	1	104	1	104	08/29/2018	4	4	0	44	1	0	44	2017-08-02	7	7	0	1	36	0	36	72.667	1	0	0	0.00	0	0	4465 W 48TH ST FREMONT, MI 49412 (43.467021, -85.911905)	02/01/2020
10905	21400 72ND AVENUE WEST EDMONDS, WA 98026	47.804558	-122.330144	505236	ALDERCREST HEALTH & REHAB CENTER	21400 72ND AVENUE WEST	EDMONDS	WA	98026	4257751961	300	Snohomish	For profit - Corporation	128	86	Medicare and Medicaid	false	ALDERCREST HEALTH - EDMONDS, LLC	08/01/1977	false		true	false	false	Resident	Yes	1	1	2	2	2		3	3	1.59608	1.16099	0.63838	1.79937	3.39545	0.02935	2.1984	0.75566	0.36009	3.31415	1.50891	1.15528	0.66726	3.28532	09/13/2019	40	25	16	280	1	280	07/19/2018	27	20	9	180	2	90	270	2017-08-02	26	16	13	1	208	0	208	264.667	14	37	5	130469.00	0	5	21400 72ND AVENUE WEST EDMONDS, WA 98026 (47.804558, -122.330144)	02/01/2020