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 11 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 "Long-Stay QM Rating Footnote" = :p0 and "Total Number of Penalties" = :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 Footnote	Health Inspection Rating Footnote	QM Rating Footnote	Long-Stay QM Rating Footnote	Short-Stay QM Rating Footnote	Staffing Rating Footnote	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 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
2478	12942 WORNALL ROAD KANSAS CITY, MO 64145	38.891263	-94.595164	0		265830	KANSAS CITY CENTER FOR REHABILITATION AND HEALTHCA	12942 WORNALL ROAD	KANSAS CITY	MO	64145	8164238500	470	Jackson	For profit - Limited Liability company	180	112.4	Medicare and Medicaid	false	BROOK OPERATIONS LLC	06/29/2009	false	SFF	false	false	false	Resident	Yes	18	18	18	18	18	18	18	2.25224	1.2764	0.41639	1.6928	3.94504	0.04189	1.73081	0.63292	0.29802	2.66175	2.70446	1.51644	0.52589	4.75266	04/19/2019	43	37	17	240	3	168	408	04/20/2018	41	34	15	332	2	166	498	2017-02-17	26	25	5	1	140	0	140	393.333	4	30	3	162309.00	2	5	12942 WORNALL ROAD KANSAS CITY, MO 64145 (38.891263, -94.595164)	02/01/2020
5221	930 MILL HILL TERRACE SOUTHPORT, CT 06890	41.14438	-73.286615	0		75200	REGALCARE AT SOUTHPORT	930 MILL HILL TERRACE	SOUTHPORT	CT	6890	2032597894	0	Fairfield	For profit - Partnership	120	108.2	Medicare and Medicaid	false	FAIRVIEW HEALTH OF SOUTHPORT LLC	06/01/1977	false	SFF	false	false	false	Resident	Yes	18	18	18	18	18	18	18	2.04457	0.9491	0.43656	1.38566	3.43023	0.04559	1.79219	0.67576	0.32482	2.79277	2.37101	1.0561	0.50587	3.9386	06/12/2019	8	5	3	32	1	0	32	11/30/2018	17	16	9	162	1	0	162	2018-05-24	52	19	50	3	625	438	1063	247.167	8	9	4	27108.00	1	5	930 MILL HILL TERRACE SOUTHPORT, CT 06890 (41.14438, -73.286615)	02/01/2020
6606	9350 GREEN PARK ROAD SAINT LOUIS, MO 63123	38.524626	-90.333738	0		265703	GREEN PARK SENIOR LIVING COMMUNITY	9350 GREEN PARK ROAD	SAINT LOUIS	MO	63123	3148450900	940	St. Louis	For profit - Corporation	188	158.8	Medicare and Medicaid	false	GREEN PARK LEASING CO LLC	01/21/2000	false	SFF	false	false	false	Resident	Yes	18	18	18	18	18	18	18	1.8986	0.93923	0.42898	1.36822	3.26681	0.02783	1.76927	0.64017	0.2982	2.70764	2.23025	1.10322	0.54146	3.86889	10/11/2019	17	11	10	163	1	0	163	05/22/2019	33	30	9	176	1	0	176	2018-09-10	26	23	9	1	172	0	172	168.833	4	34	2	58468.00	3	5	9350 GREEN PARK ROAD SAINT LOUIS, MO 63123 (38.524626, -90.333738)	02/01/2020
6648	850 9TH STREET ALABASTER, AL 35007	33.253789	-86.826548	0		15144	AHAVA HEALTHCARE OF ALABASTER	850 9TH STREET, NORTHWEST	ALABASTER	AL	35007	2056633859	580	Shelby	For profit - Corporation	198	154.3	Medicare and Medicaid	false	ALABASTER OPERATING GROUP LLC	06/01/1976	false	SFF	false	false	false	Resident	Yes	18	18	18	18	18	18	18	1.66724	0.80895	0.3797	1.18865	2.85589	0.04646	1.91309	0.66621	0.30806	2.88735	1.81125	0.91306	0.46392	3.17172	07/11/2019	5	5	5	20	1	0	20	01/16/2019	17	9	8	136	2	68	204	2017-10-19	15	8	9	2	448	224	672	190	1	5	4	110470.00	1	5	850 9TH STREET ALABASTER, AL 35007 (33.253789, -86.826548)	02/01/2020
6700	5301 W FIRST AVE LAKEWOOD, CO 80226	39.718574	-105.054985	0		65248	BETHANY NURSING & REHAB CENTER	5301 W FIRST AVE	LAKEWOOD	CO	80226	3032388333	290	Jefferson	For profit - Corporation	170	137.5	Medicare and Medicaid	false	BETHANY NURSING & REHAB CENTER LLC	03/01/1989	false	SFF	false	false	false	Both	Yes	18	18	18	18	18	18	18	1.14861	0.54414	0.32874	0.87289	2.0215	0.02956	1.94198	0.70019	0.32477	2.96695	1.22926	0.58436	0.38098	2.18482	12/10/2019	17	11	6	80	0	0	80	05/16/2019	25	10	15	265	1	0	265	2018-11-29	35	10	25	1	345	0	345	185.833	3	24	4	255169.00	1	5	5301 W FIRST AVE LAKEWOOD, CO 80226 (39.718574, -105.054985)	02/01/2020
8273	1509 NORTH CALHOUN STREET BLOOMINGTON, IL 61701	40.493115	-89.005883	0		145371	APERION CARE BLOOMINGTON	1509 NORTH CALHOUN STREET	BLOOMINGTON	IL	61701	3098276046	650	Mc Lean	For profit - Corporation	115	68.9	Medicare and Medicaid	false	APERION CARE BLOOMINGTON LLC	03/29/1978	false	SFF	false	false	false	Resident	Yes	18	18	18	18	18	18	18	1.98157	0.54591	0.33186	0.87777	2.85934	0.00676	2.13815	0.86696	0.52719	3.53229	1.92614	0.47349	0.23693	2.59575	09/25/2019	27	10	17	235	1	0	235	05/20/2019	21	16	5	92	1	0	92	2018-10-01	100	16	84	1	814	0	814	283.833	0	68	3	183544.00	2	5	1509 NORTH CALHOUN STREET BLOOMINGTON, IL 61701 (40.493115, -89.005883)	02/01/2020
8682	12260 FOOTHILL BLVD SYLMAR, CA 91342	34.282013	-118.403063	0		555814	SAN FERNANDO POST ACUTE HOSPITAL	12260 FOOTHILL BLVD	SYLMAR	CA	91342	8188999545	200	Los Angeles	For profit - Corporation	204	150	Medicare and Medicaid	false	Legal Business Name Not Available	11/24/2004	false	SFF	false	false	false	Both	Yes	18	18	18	18	18	18	18	2.55203	1.93247	0.47791	2.41038	4.96241	0.02789	2.14524	0.79741	0.74916	3.6918	2.47244	1.82227	0.24011	4.3103	07/01/2019	25	15	13	140	1	0	140	01/14/2019	22	16	8	128	1	0	128	2018-07-16	19	11	8	1	221	0	221	149.5	12	17	4	256613.00	1	5	12260 FOOTHILL BLVD SYLMAR, CA 91342 (34.282013, -118.403063)	02/01/2020
8904	12921 MISTY WILLOW DR HOUSTON, TX 77070	29.960344	-95.556132	0		676251	MISTY WILLOW HEALTHCARE AND REHABILITATION CENTER	12921 MISTY WILLOW DR	HOUSTON	TX	77070	2814697881	610	Harris	For profit - Corporation	124	58.7	Medicare and Medicaid	false	LIBERTY COUNTY HOSPITAL DISTRICT NO 1	04/21/2010	false	SFF	false	false	false	Both	Yes	18	18	18	18	18	18	18	2.03912	1.36993	0.35134	1.72128	3.7604	0.12721	2.09128	0.87391	0.47783	3.44301	2.02651	1.17874	0.27675	3.50226	07/18/2019	0	0	0	0	0	0	0	01/12/2019	10	4	7	108	1	0	108	2018-07-13	20	6	14	1	1439	0	1439	275.833	4	24	3	94714.00	2	5	12921 MISTY WILLOW DR HOUSTON, TX 77070 (29.960344, -95.556132)	02/01/2020
9327	3195 OLD MURPHY ROAD FRANKLIN, NC 28734	35.167118	-83.433528	0		345263	MACON VALLEY NURSING AND REHABILITATION CENTER	3195 OLD MURPHY ROAD	FRANKLIN	NC	28734	8285247806	560	Macon	For profit - Corporation	200	78.2	Medicare and Medicaid	false	GRANITE FALLS LTC, LLC	07/14/1987	false	SFF	false	false	false	Both	Yes	18	18	18	18	18	18	18	2.38615	0.70726	1.20815	1.91541	4.30155	0.04949	2.14012	0.80457	0.40617	3.35086	2.31726	0.661	1.11954	4.11644	08/29/2019	3	0	3	44	0	0	44	02/22/2019	36	5	31	656	1	0	656	2018-04-13	13	8	13	2	68	34	102	257.667	1	39	4	433149.00	1	5	3195 OLD MURPHY ROAD FRANKLIN, NC 28734 (35.167118, -83.433528)	02/01/2020
13193	4403 FOREST HILL AVENUE RICHMOND, VA 23225	37.519708	-77.481539	0		495327	ENVOY OF WESTOVER HILLS	4403 FOREST HILL AVENUE	RICHMOND	VA	23225	8042310231	791	Richmond City	For profit - Corporation	174	146.7	Medicare and Medicaid	false	ENVOY OF RICHMOND, LLC	02/01/1998	false	SFF	true	false	false	Both	Yes	18	18	18	18	18	18	18	1.99688	1.06524	0.50247	1.56771	3.56459	0.06543	1.95113	0.72582	0.35943	3.03638	2.12707	1.10358	0.52617	3.7645	07/25/2019	22	16	8	168	1	0	168	01/31/2019	35	15	20	200	2	100	300	2018-07-23	52	30	39	2	584	292	876	330	0	38	4	668716.00	1	5	4403 FOREST HILL AVENUE RICHMOND, VA 23225 (37.519708, -77.481539)	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	0	793	617.833	9	26	4	220368.00	1	5		02/01/2020