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 9 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	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 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 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
2388	26715 GREENFIELD RD SOUTHFIELD, MI 48076	42.486105	-83.202288	0		235296	MEDILODGE OF SOUTHFIELD	26715 GREENFIELD RD	SOUTHFIELD	MI	48076	2485570050	620	Oakland	For profit - Corporation	191	163.8	Medicare and Medicaid	false	SOUTHFIELD OPCO, LLC	07/01/1976	false	SFF Candidate	true	false	false	Both	Yes	1		1		3		4		3		3		3		2.31216	1.00514	0.60202	1.60716	3.91932	0.039	2.05696	0.69338	0.31721	3.06755	2.33619	1.09003	0.71433	4.09706	03/14/2019	42	15	27	335	1	0	335	02/20/2018	52	27	25	416	1	0	416	2017-01-12	39	14	25	1	426	426	377.167	33	134	3	140026.00	1	4	26715 GREENFIELD RD SOUTHFIELD, MI 48076 (42.486105, -83.202288)	02/01/2020
2724	800 WEST OAKTON STREET ARLINGTON HTS, IL 60004	42.095584	-87.992616	0		145739	LUTHERAN HOME FOR THE AGED	800 WEST OAKTON STREET	ARLINGTON HTS	IL	60004	8472533710	141	Cook	Non profit - Church related	354	306.5	Medicare and Medicaid	false	LUTHERAN HOME FOR THE AGED	12/17/1992	false		true	false	false	Resident	Yes	3		2		3		3		4		4		5		2.41326	0.16216	1.21635	1.37851	3.79178	0.18415	2.07969	0.78031	0.35821	3.2182	2.4117	0.15627	1.27807	3.77818	12/12/2018	7	2	5	64	1	0	64	03/01/2018	5	5	0	32	1	0	32	2017-01-12	13	12	1	1	80	80	56	1	4	0	0.00	0	0	800 WEST OAKTON STREET ARLINGTON HTS, IL 60004 (42.095584, -87.992616)	02/01/2020
4020	1460 EL CAMINO REAL DRIVE THE VILLAGES, FL 32159	28.949271	-81.959123	0		106083	FREEDOM POINTE AT THE VILLAGES REHABILITATION AND	1460 EL CAMINO REAL DRIVE	THE VILLAGES	FL	32159	3527500866	340	Lake	For profit - Corporation	72	67.4	Medicare	false	CCRC- FREEDOM POINTE AT THE VILLAGES, LLC	11/12/2009	true		true	false	false	Resident	Yes	2		1		5			2	5		3		3		2.8624	1.01149	1.07015	2.08164	4.94404	0.33612	2.15165	1.0074	0.57739	3.73644	2.76487	0.755	0.6976	4.24304	01/31/2019	13	9	4	206	1	0	206	10/19/2017	8	8	0	60	1	0	60	2017-01-12	3	3	0	1	12	12	125	3	0	0	0.00	0	0	1460 EL CAMINO REAL DRIVE THE VILLAGES, FL 32159 (28.949271, -81.959123)	02/01/2020
4409	900 CENTENNIAL DRIVE EAST PEORIA, IL 61611	40.70423	-89.521568	0		145646	ROSEWOOD CARE CENTER OF EAST PEORIA	900 CENTENNIAL DRIVE	EAST PEORIA	IL	61611	3096995400	980	Tazewell	For profit - Corporation	86	69.8	Medicare and Medicaid	false	BRAVO CARE OF EAST PEORIA INC	05/15/1989	false		true	false	false	Resident	Yes	2		1		3		4		2		4		4		2.87583	0.7377	0.68389	1.4216	4.29743	0.02896	1.9371	0.67702	0.30556	2.91968	3.08551	0.81934	0.84241	4.71983	03/06/2019	35	18	19	144	1	0	144	02/22/2018	29	12	17	140	1	0	140	2017-01-12	4	3	1	1	20	20	122	6	28	0	0.00	0	0	900 CENTENNIAL DRIVE EAST PEORIA, IL 61611 (40.70423, -89.521568)	02/01/2020
5611	1305 E 7TH ST WHITEFISH, MT 59937	48.405176	-114.32479	0		275132	WHITEFISH CARE AND REHABILITATION	1305 E 7TH ST	WHITEFISH	MT	59937	4068623557	140	Flathead	For profit - Corporation	100	64.6	Medicare and Medicaid	false	SWEETWATER WHITEFISH OPCO LLC	09/01/1989	false		true	false	false	Resident	Yes	1		1		3		2		4		2		3		1.52514	0.73282	0.5309	1.26371	2.78885	0.01547	1.81595	0.72099	0.3617	2.89863	1.74551	0.76428	0.55245	3.08521	06/27/2019	17	14	13	188	1	0	188	05/03/2018	8	8	0	64	1	0	64	2017-01-12	4	4	0	1	60	60	125.333	3	5	1	108500.00	0	1	1305 E 7TH ST WHITEFISH, MT 59937 (48.405176, -114.32479)	02/01/2020
6599	625 36TH ST SW WYOMING, MI 49509	42.898776	-85.681566	0		235441	SKLD WYOMING	625 36TH ST SW	WYOMING	MI	49509	6165310200	400	Kent	For profit - Partnership	92	79.2	Medicare and Medicaid	false	CRESTVIEW SNF LLC	10/01/1985	false		true	false	false	Resident	Yes	1		1		4		3		5		3		4		1.98226	0.41283	0.70006	1.1129	3.09516	0.03309	2.06367	0.72721	0.3394	3.13028	1.99635	0.42687	0.77634	3.17068	03/14/2019	26	12	14	244	1	0	244	02/14/2018	28	21	7	308	2	154	462	2017-01-12	11	4	7	1	80	80	289.333	26	27	1	74763.00	2	3	625 36TH ST SW WYOMING, MI 49509 (42.898776, -85.681566)	02/01/2020
7452	163 QUINNIPIAC AVENUE NORTH HAVEN, CT 06473	41.346922	-72.863569	0		75017	MONTOWESE HEALTH & REHABILITATION CENTER	163 QUINNIPIAC AVENUE	NORTH HAVEN	CT	6473	2036243303	40	New Haven	For profit - Corporation	120	110	Medicare and Medicaid	false	ATHENA MONTOWESE SNF, LLC	01/01/1967	false		true	false	false	Resident	Yes	1		1		4		4		3		3		3		2.17257	0.80759	0.77599	1.58359	3.75616	0.33486	2.1381	0.82763	0.43376	3.39949	2.11185	0.73373	0.67335	3.5431	01/17/2019	11	5	7	68	1	0	68	12/04/2017	13	9	5	52	1	0	52	2017-01-12	9	1	8	1	68	68	62.667	4	7	2	51436.00	0	2	163 QUINNIPIAC AVENUE NORTH HAVEN, CT 06473 (41.346922, -72.863569)	02/01/2020
8115	799 CONCORD AVENUE CAMBRIDGE, MA 02138	42.390732	-71.15559	0		225573	SANCTA MARIA NURSING FACILITY	799 CONCORD AVENUE	CAMBRIDGE	MA	2138	6178682200	90	Middlesex	Non profit - Church related	141	132.1	Medicare and Medicaid	false	SANCTA MARIA HOSPITAL, INC.	02/03/1993	false		true	false	false	Resident	Yes	2		1		2		2		2		4		4		2.48538	0.71139	1.04341	1.75481	4.24019	0.21187	2.21202	0.77682	0.3872	3.37604	2.33518	0.68861	1.01427	4.02746	02/18/2019	15	15	0	96	2	48	144	10/23/2017	5	4	1	32	1	0	32	2017-01-12	10	10	0	1	56	56	92	0	0	1	29016.00	0	1	799 CONCORD AVENUE CAMBRIDGE, MA 02138 (42.390732, -71.15559)	02/01/2020
13608	821 I-35BL, New Braunfels, TX 78130, USA	29.6911115	-98.1237433	1	ROOFTOP	455020	COLONIAL MANOR CARE CENTER	821 US HWY 81 W	NEW BRAUNFELS	TX	78130	8306257526	320	Comal	For profit - Corporation	154	126.9	Medicare and Medicaid	false	COLONIAL NEW BRAUNFELS CARE CENTER LLC	06/01/1976	false	SFF	true	false	false	Resident	Yes		18		18		18		18		18		18		18	2.13263	1.26971	0.22817	1.49788	3.63051	0	1.9021	0.79213	0.4156	3.10984	2.33022	1.20529	0.20664	3.74354	02/26/2019	39	31	11	830	1	0	830	02/02/2018	26	21	5	212	1	0	212	2017-01-12	19	5	14	1	793	793	617.833	9	26	4	220368.00	1	5		02/01/2020