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	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 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
347	3860 DOBIE RD OKEMOS, MI 48864	42.692251	-84.410335	235015	INGHAM COUNTY MEDICAL CARE FAC	3860 DOBIE RD	OKEMOS	MI	48864	5173816100	320	Ingham	Government - County	236	215.7	Medicare and Medicaid	false	INGHAM COUNTY MEDICAL CARE FACILITY	01/01/1967	false		true	false	false	Resident	Yes	4	2	5	5	4		5		5				3.27177	0.856	0.87704	1.73303	5.0048	0.05442	2.03655	0.65483	0.28873	2.98011	3.3389	0.98293	1.1433	5.38527	11/13/2019	10	7	3	68	1	0	68	12/18/2018	11	9	5	68	1	68	2017-08-30	9	9	2	2	100	50	150	81.667	11	12	3	63642.00	1	4	3860 DOBIE RD OKEMOS, MI 48864 (42.692251, -84.410335)	02/01/2020
699	21630 HESSEL DETROIT, MI 48219	42.441622	-83.257194	235475	BEACONSHIRE NURSING CENTRE	21630 HESSEL	DETROIT	MI	48219	3135348400	810	Wayne	For profit - Corporation	99	79.7	Medicare and Medicaid	false	NORTHWEST PARTNERS, LLC	08/10/1988	false		true	false	false	Resident	Yes	1	2	1	1	1		1	12	1	12			1.39446	1.10609	0.17509	1.28118	2.67564	0.0126	1.9008	0.61795	0.26369	2.78245	1.5247	1.34591	0.24992	3.08357	06/04/2019	13	9	4	119	1	0	119	09/12/2018	16	11	6	238	1	238	2017-08-30	8	7	1	1	96	0	96	154.833	6	11	1	11161.00	1	2	21630 HESSEL DETROIT, MI 48219 (42.441622, -83.257194)	02/01/2020
6772	2400 PORTAGE ST KALAMAZOO, MI 49001	42.266639	-85.56998	235050	HAROLD AND GRACE UPJOHN COMMUNITY CARE CENTER	2400 PORTAGE ST	KALAMAZOO	MI	49001	2693814290	380	Kalamazoo	Non profit - Corporation	90	81.6	Medicare and Medicaid	false	HAROLD AND GRACE UPJOHN COMMUNITY CARE CENTER	01/01/1967	true		true	false	false	Resident	Yes	3	2	4	4	5		5		5				2.44436	0.82994	1.14888	1.97882	4.42318	0.10394	2.1954	0.71993	0.36918	3.28451	2.31402	0.86684	1.17131	4.31835	12/19/2019	15	12	3	100	0	0	100	09/28/2018	20	6	14	206	1	206	2017-08-30	18	12	6	1	116	0	116	138	26	35	1	75036.00	0	1	2400 PORTAGE ST KALAMAZOO, MI 49001 (42.266639, -85.56998)	02/01/2020
8411	1330 GRAND POINTE COURT GRAND BLANC, MI 48439	42.941165	-83.679015	235666	REGENCY AT GRAND BLANC	1330 GRAND POINTE COURT	GRAND BLANC	MI	48439	8106958920	240	Genesee	For profit - Corporation	138	130.4	Medicare and Medicaid	false	GRAND BLANC CARE CENTER LLC	07/26/2013	false		true	false	false	Resident	Yes	4	2	5	5	5		4		4				2.3323	1.08805	1.0795	2.16755	4.49985	0.13774	2.26563	0.88076	0.42849	3.57488	2.1395	0.92891	0.94824	4.03636	10/11/2019	13	12	2	72	1	0	72	10/11/2018	8	8	1	40	1	40	2017-08-30	6	6	0	1	84	0	84	63.333	5	0	1	24375.00	0	1	1330 GRAND POINTE COURT GRAND BLANC, MI 48439 (42.941165, -83.679015)	02/01/2020
12415	515 E 8TH STREET WHITE RIVER, SD 57579	43.573185	-100.743577	43A089	WHITE RIVER HEALTH CARE CENTER	515 E 8TH STREET POST OFFICE BOX 310	WHITE RIVER	SD	57579	6052593161	470	Mellette	Non profit - Corporation	52	35.8	Medicaid	false	Legal Business Name Not Available	05/17/1990	false		true	false	false	Resident	Yes	2	1	5	5		2	1	12	1	12	6	6															12/12/2019	10	10	0	217	0	0	217	11/07/2018	0	0	0	0	0	0	2017-08-30	3	3	0	1	24	0	24	112.5	0	0	0	0.00	0	0	515 E 8TH STREET WHITE RIVER, SD 57579 (43.573185, -100.743577)	02/01/2020
12898	300 ARLINGTON AVENUE LOGAN, OH 43138	39.536159	-82.395098	365435	LOGAN CARE AND REHABILITATION	300 ARLINGTON AVENUE	LOGAN	OH	43138	7403852155	380	Hocking	For profit - Corporation	144	123.7	Medicare and Medicaid	false	LOGAN HEALTHCARE LEASING LLC	01/09/1980	false	SFF Candidate	true	false	false	Resident	Yes	1	1	3	4	3		1	12	1	12			1.72996	0.95592	0.16763	1.12355	2.85351	0.02047	2.06495	0.80149	0.41768	3.28412	1.74117	0.89682	0.15106	2.78621	10/10/2019	26	26	0	219	2	110	329	09/14/2018	23	14	9	195	1	195	2017-08-30	53	27	26	2	499	250	749	354.333	0	29	1	11427.00	0	1	300 ARLINGTON AVENUE LOGAN, OH 43138 (39.536159, -82.395098)	02/01/2020