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 order by [Rating Cycle 2 Number of Health Revisits] 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	Staffing Rating	Staffing Rating Footnote	RN Staffing Rating	RN Staffing Rating 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 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
3050	1069 BALLENGER HWY FLINT, MI 48504	43.018281	-83.734828	0		235343	KITH HAVEN	G 1069 BALLENGER HWY	FLINT	MI	48504	8102356676	240	Genesee	For profit - Corporation	159	126.2	Medicare and Medicaid	false	KITH HAVEN ACQUISITION COMPANY, LLC	10/01/1977	false	false	false	false	Resident	Yes	1	1	4	5	3	3		3		2.52311	0.81613	0.51072	1.32685	3.84997	0.03016	2.08647	0.67081	0.2828	3.04008	2.51328	0.91483	0.67974	4.06093	10/17/2019	14	10	5	100	1	100	10/22/2018	35	14	22	343	1	343	2017-08-23	11	9	4	1	88	0	88	179	19	30	7	162552.00	0	7	1069 BALLENGER HWY FLINT, MI 48504 (43.018281, -83.734828)	02/01/2020
5428	6535 DRAKE ROAD WEST BLOOMFIELD, MI 48322	42.540603	-83.399923	0		235663	NOTTING HILL OF WEST BLOOMFIELD	6535 DRAKE ROAD	WEST BLOOMFIELD	MI	48322	2485922000	620	Oakland	For profit - Individual	118	112.1	Medicare and Medicaid	false	MAPLE-DRAKE REAL ESTATE, LLC	05/30/2013	false	false	false	false	Resident	Yes	2	2	4	3	4	3		3		1.88439	1.57753	0.57062	2.14815	4.03255	0.18071	2.21128	0.78473	0.37176	3.36776	1.7711	1.51162	0.57773	3.83965	07/29/2019	23	14	13	164	1	164	04/05/2018	16	6	10	152	1	152	2017-03-02	22	17	8	1	124	0	124	153.333	9	31	7	96031.00	0	7	6535 DRAKE ROAD WEST BLOOMFIELD, MI 48322 (42.540603, -83.399923)	02/01/2020
6524	535 N MAIN CLAWSON, MI 48017	42.537507	-83.146513	0		235214	CAMBRIDGE NORTH HEALTHCARE CENTER	535 N MAIN	CLAWSON	MI	48017	2484355200	620	Oakland	For profit - Corporation	120	94.8	Medicare and Medicaid	false	SSC CLAWSON OPERATING COMPANY LLC	10/08/1971	false	false	false	false	Resident	Yes	1	1	4	5	4	1	12	1	12	2.15528	1.17212	0.26557	1.43769	3.59297	0.08358	2.08638	0.73739	0.34536	3.16913	2.14697	1.19525	0.28943	3.63552	10/29/2018	27	18	12	400	1	400	08/10/2017	19	13	6	247	1	247	2016-07-20	23	12	11	2	227	114	341	339.167	10	30	7	295273.00	1	8	535 N MAIN CLAWSON, MI 48017 (42.537507, -83.146513)	02/01/2020
7288	915 N RIVER RD SAGINAW, MI 48609	43.422068	-84.052128	0		235249	ST FRANCIS HOME	915 N RIVER RD	SAGINAW	MI	48609	9897813150	720	Saginaw	Non profit - Church related	94	74.3	Medicare and Medicaid	false	ST. FRANCIS HOME OF SAGINAW	09/01/1975	false	false	false	false	Both	Yes	2	1	5	4	5	4		3		3.21364	0.99462	0.65291	1.64753	4.86117	0.0586	2.2035	0.72612	0.35046	3.28008	3.0311	1.02999	0.7012	4.75236	05/03/2019	18	13	5	251	1	251	04/26/2018	16	11	5	156	1	156	2017-06-08	46	22	25	2	385	193	578	273.833	22	16	7	173591.00	1	8	915 N RIVER RD SAGINAW, MI 48609 (43.422068, -84.052128)	02/01/2020
11579	6021 N Lidgerwood St, Spokane, WA 99208, USA	47.712626	-117.4066066	1	ROOFTOP	505024	FRANKLIN HILLS HEALTH & REHAB CENTER	6021 NORTH LIDGERWOOD	SPOKANE	WA	99207	5094893323	310	Spokane	For profit - Corporation	100	65.9	Medicare and Medicaid	false	FRANKLIN HILLS HEALTH - SPOKANE, LLC	01/01/1967	false	false	false	false	Resident	Yes	2	1	3	2	3	4		4		2.45496	0.3699	0.9357	1.3056	3.76056	0.1215	2.08737	0.78382	0.38687	3.25806	2.44433	0.35486	0.91034	3.70123	12/11/2018	49	28	23	367	1	367	10/17/2017	30	12	18	264	1	264	2016-09-21	41	23	18	1	295	0	295	320.667	29	35	7	154086.00	0	7		02/01/2020
15382	153 JOHNS COURT SHELTON, WA 98584	47.233785	-123.109373	0		505507	SHELTON HEALTH & REHAB CENTER	153 JOHNS COURT	SHELTON	WA	98584	3604272575	220	Mason	For profit - Corporation	76	63.4	Medicare and Medicaid	false	EVERGREEN AT SHELTON, L.L.C.	02/12/1999	false	true	false	false	Resident	Yes	2	1	2	1	4	4		4		2.15906	0.72361	0.94307	1.66668	3.82574	0.09301	2.11376	0.78464	0.39686	3.29527	2.12287	0.69346	0.89441	3.72287	05/10/2019	54	30	28	432	1	432	05/23/2018	27	13	14	236	1	236	2017-06-28	19	14	6	1	160	0	160	321.333	27	17	7	126343.00	0	7	153 JOHNS COURT SHELTON, WA 98584 (47.233785, -123.109373)	02/01/2020