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 8 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	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	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
214	1100 TEXAS AVE DEER LODGE, MT 59722	46.391232	-112.720933	0		275134	DEER LODGE	1100 TEXAS AVE	DEER LODGE	MT	59722	4068461655	380	Powell	For profit - Corporation	60	47.8	Medicare and Medicaid	false	1100 TEXAS AVENUE OPERATIONS LLC	10/01/1989	false		true	false	false	Resident	Yes	1	1	3	3		2	3	3	1.78565	0.84876	0.41694	1.2657	3.05135	0.02	1.80882	0.64923	0.29513	2.75318	2.05172	0.98304	0.53172	3.55395	10/17/2019	7	7	1	64	1	64	09/20/2018	5	5	0	44	1	0	44	2017-09-14	19	4	16	1	854	0	854	189	2	31	3	721513.00	0	3	1100 TEXAS AVE DEER LODGE, MT 59722 (46.391232, -112.720933)	02/01/2020
1416	1601 PETERSEN AVENUE SAN JOSE, CA 95129	37.294157	-121.998841	0		55750	AMBERWOOD GARDENS	1601 PETERSEN AVENUE	SAN JOSE	CA	95129	4082537502	530	Santa Clara	For profit - Corporation	258	237.7	Medicare and Medicaid	false	WESTGATE PREMIER HEALTHCARE SERVICES, INC.	07/01/1978	false		true	false	false	Resident	Yes	1	1	4	5	3		3	3	2.79717	1.23179	0.76219	1.99398	4.79115	0.02805	2.26435	0.7416	0.53734	3.54329	2.56738	1.24897	0.53389	4.33597	09/13/2019	21	12	9	96	1	96	09/14/2018	31	21	10	188	1	0	188	2017-09-14	21	17	6	1	112	0	112	129.333	12	18	3	26068.00	0	3	1601 PETERSEN AVENUE SAN JOSE, CA 95129 (37.294157, -121.998841)	02/01/2020
1689	5888 N Ridge Ave, Chicago, IL 60660, USA	41.9888142	-87.6689396	1	ROOFTOP	145765	PARK VIEW REHAB CENTER	5888 NORTH RIDGE	CHICAGO	IL	60660	7737692626	141	Cook	For profit - Partnership	128	120.7	Medicare and Medicaid	false	PARK VIEW REHAB CENTER, LLC	12/01/1993	false		true	false	false	Resident	Yes	1	2	1	3	1		2	2	1.2933	0.48066	0.36202	0.84268	2.13598	0.04343	1.85392	0.79482	0.41339	3.06213	1.44986	0.45473	0.32961	2.23679	08/22/2019	12	8	4	68	1	68	10/03/2018	14	9	5	108	1	0	108	2017-09-14	13	11	2	1	112	0	112	88.667	0	16	0	0.00	0	0		02/01/2020
2692	1925 SOUTH MAIN STREET BLOOMINGTON, IL 61701	40.455941	-88.99273	0		145610	BLOOMINGTON REHABILITATION & HCC	1925 SOUTH MAIN STREET	BLOOMINGTON	IL	61701	3098294348	650	Mc Lean	For profit - Corporation	78	47.3	Medicare and Medicaid	false	PETERSEN HEALTH OPERATIONS LLC	03/22/1989	false	SFF Candidate	true	false	false	Resident	Yes	1	1	3	3		2	2	3	1.88046	0.38587	0.563	0.94887	2.82934	0.01934	2.11825	0.7605	0.34248	3.22123	1.84503	0.38153	0.61874	2.81654	08/08/2019	33	4	29	184	1	184	10/26/2018	35	8	27	176	1	0	176	2017-09-14	24	11	13	2	188	94	282	197.667	2	32	2	14047.00	0	2	1925 SOUTH MAIN STREET BLOOMINGTON, IL 61701 (40.455941, -88.99273)	02/01/2020
4879	2121 RAYBROOK SE GRAND RAPIDS, MI 49546	42.922833	-85.58813	0		235440	HOLLAND HOME - RAYBROOK MANOR	2121 RAYBROOK SE	GRAND RAPIDS	MI	49546	6162355702	400	Kent	Non profit - Corporation	101	93.5	Medicare and Medicaid	false	HOLLAND HOME	09/01/1985	true		true	false	false	Resident	Yes	4	2	5	5	5		4	4	2.69611	0.88565	0.7385	1.62414	4.32025	0.02041	2.16388	0.67301	0.28858	3.12546	2.58952	0.98952	0.96321	4.43249	11/06/2019	5	3	2	103	1	103	08/23/2018	7	6	1	60	1	0	60	2017-09-14	14	14	0	1	100	0	100	88.167	5	3	1	9100.00	1	2	2121 RAYBROOK SE GRAND RAPIDS, MI 49546 (42.922833, -85.58813)	02/01/2020
5906	2850 RUBY VISTA DRIVE ELKO, NV 89801	40.858758	-115.745547	0		295078	HIGHLAND MANOR OF ELKO	2850 RUBY VISTA DRIVE	ELKO	NV	89801	7757535500	30	Elko	Non profit - Corporation	112	103.3	Medicare and Medicaid	false	DESERT HEALTH CARE FACILITIES INC	02/16/2001	false		true	false	false	Resident	Yes	3	2	4	5	3		4	4	2.24774	0.53938	0.69742	1.2368	3.48453	0.03633	2.08251	0.71907	0.31183	3.11341	2.24324	0.56403	0.8418	3.5889	06/24/2019	16	16	0	72	1	72	06/21/2018	12	11	2	68	1	0	68	2017-09-14	10	10	0	1	84	0	84	72.667	0	2	0	0.00	0	0	2850 RUBY VISTA DRIVE ELKO, NV 89801 (40.858758, -115.745547)	02/01/2020
6598	16391 ROTUNDA DR DEARBORN, MI 48120	42.302155	-83.196574	0		235502	BEAUMONT REHABILITATION & CONTINUING CARE DEARBORN	16391 ROTUNDA DR	DEARBORN	MI	48120	3132539700	810	Wayne	Non profit - Corporation	196	129.1	Medicare and Medicaid	false	OAKWOOD HEALTH PROMOTIONS, INC.	04/12/1991	true		true	false	false	Resident	Yes	3	2	5	5	5		3	3	2.08886	1.67552	0.65135	2.32687	4.41573	0.10153	2.106	0.79684	0.39412	3.29697	2.06142	1.5811	0.62203	4.29478	09/19/2019	1	0	1	20	0	20	10/17/2018	7	7	1	190	1	0	190	2017-09-14	16	14	2	1	108	0	108	91.333	3	8	2	32847.00	0	2	16391 ROTUNDA DR DEARBORN, MI 48120 (42.302155, -83.196574)	02/01/2020
6967	2490 COURT STREET REDDING, CA 96001	40.573276	-122.392223	0		56258	WINDSOR REDDING CARE CENTER	2490 COURT STREET	REDDING	CA	96001	5302460600	550	Shasta	For profit - Limited Liability company	113	94.5	Medicare and Medicaid	false	Legal Business Name Not Available	01/02/1973	false		true	false	false	Resident	Yes	2	1	5	5	5		3	2	2.4941	1.09599	0.40705	1.50304	3.99714	0.07745	2.04377	0.69904	0.3346	3.07742	2.53628	1.17892	0.45787	4.165	10/30/2019	31	4	31	168	1	168	09/13/2018	36	27	11	204	2	102	306	2017-09-14	30	20	11	1	184	0	184	216.667	38	27	1	10400.00	1	2	2490 COURT STREET REDDING, CA 96001 (40.573276, -122.392223)	02/01/2020