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 15 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 and "ownership" = :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	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 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
338	300 GARFIELD AVENUE SOUTHEAST FERTILE, MN 56540	47.528742	-96.276236	0		245545	FAIR MEADOW NURSING HOME	BOX 8 300 GARFIELD AVENUE SOUTHEAST	FERTILE	MN	56540	2189456194	590	Polk	Government - City	42	39.1	Medicare and Medicaid	false	VILLAGE OF FERTILE	02/01/1991	false		false	false	false	Resident	Yes	3	2	4	4		2	4		4		3.54403	1.17641	0.65601	1.83242	5.37645	0.02782	2.19369	0.70867	0.3085	3.21086	3.35767	1.24823	0.80037	5.36942	06/27/2019	2	2	0	8	1	0	8	08/13/2018	14	13	1	183	1	183	2017-07-13	3	3	0	1	12	0	12	67	1	0	1	22100.00	0	1	300 GARFIELD AVENUE SOUTHEAST FERTILE, MN 56540 (47.528742, -96.276236)	02/01/2020
998	702 WEST GAINES ST DERMOTT, AR 71638	33.519137	-91.444469	0		45172	DERMOTT CITY NURSING HOME	702 WEST GAINES ST	DERMOTT	AR	71638	8705383241	80	Chicot	Government - City	70	49.9	Medicare and Medicaid	false	DERMOTT CITY NURSING HOME	10/01/1991	false		false	false	false	Both	Yes	1	1	3	2	3		3		2		3.33231	0.84782	0.29358	1.14139	4.47371	0.09432	1.89953	0.69074	0.32354	2.91381	3.64599	0.92293	0.34153	4.92334	01/18/2019	7	6	1	123	2	62	185	01/12/2018	13	13	0	213	1	213	2016-12-02	4	1	3	1	40	0	40	170.167	0	4	1	13780.00	1	2	702 WEST GAINES ST DERMOTT, AR 71638 (33.519137, -91.444469)	02/01/2020
1365	427 MAIN STREET NORTHEAST MENAHGA, MN 56464	46.754599	-95.089333	0		245563	GREEN PINE ACRES NURSING HOME	427 MAIN STREET NORTHEAST	MENAHGA	MN	56464	2185644101	790	Wadena	Government - City	65	55.9	Medicare and Medicaid	false	GREEN PINE ACRES NURSING HOME	06/01/1991	false		false	false	false	Resident	Yes	5	5	5	5	5		4		4		3.20306	0.81603	0.81361	1.62964	4.8327	0.08603	2.10231	0.68568	0.31769	3.10568	3.16653	0.8949	0.96393	4.98984	03/15/2019	0	0	0	0	1	0	0	02/01/2018	3	3	0	12	1	12	2016-12-01	7	7	0	1	32	0	32	9.333	0	0	1	11278.00	0	1	427 MAIN STREET NORTHEAST MENAHGA, MN 56464 (46.754599, -95.089333)	02/01/2020
2606	410 SOUTH MCKINLEY STREET WARREN, MN 56762	48.191638	-96.775624	0		245550	NORTH STAR MANOR	410 SOUTH MCKINLEY STREET	WARREN	MN	56762	2187455282	440	Marshall	Government - City	45	35.2	Medicare and Medicaid	false	NORTH STAR MANOR	03/01/1991	false		true	false	false	Both	Yes	3	2	2	2		2	5		5		2.94312	0.79736	0.95259	1.74995	4.69307	0.02665	2.05825	0.63828	0.28976	2.98629	2.97185	0.93935	1.23735	5.03939	03/29/2019	4	4	3	91	1	0	91	01/05/2018	8	8	0	32	1	32	2017-07-06	3	3	0	1	12	0	12	58.167	1	0	1	17638.00	0	1	410 SOUTH MCKINLEY STREET WARREN, MN 56762 (48.191638, -96.775624)	02/01/2020
3205	70 PARSONAGE RD GREENWICH, CT 06830	41.059487	-73.624382	0		75117	WITHERELL, NATHANIEL	70 PARSONAGE RD	GREENWICH	CT	6830	2036184200	0	Fairfield	Government - City	202	188	Medicare and Medicaid	false	Legal Business Name Not Available	01/01/1967	false		false	false	false	Both	Yes	5	3	5	5	4		5		5		2.83696	0.33745	1.13348	1.47093	4.30788	0.10308	2.09912	0.69888	0.33235	3.13035	2.80887	0.36307	1.28364	4.4129	08/09/2019	7	7	4	20	1	0	20	07/12/2018	6	6	0	48	1	48	2017-07-27	5	5	0	1	52	0	52	34.667	3	0	1	10153.00	0	1	70 PARSONAGE RD GREENWICH, CT 06830 (41.059487, -73.624382)	02/01/2020
4233	608 NORTH MAIN STREET LINDEN, AL 36748	32.314081	-87.798181	0		15330	MARENGO NURSING HOME	608 NORTH MAIN STREET	LINDEN	AL	36748	3342958631	450	Marengo	Government - City	78	76.1	Medicare and Medicaid	false	LINDEN HOSPITAL BOARD	04/08/1971	false		false	false	false	Resident	Yes	3	2	4	4		2	4		4		3.62466	0.87359	0.56908	1.44267	5.06733	0.00368	1.90442	0.63323	0.25945	2.7971	3.95567	1.03736	0.82557	5.80931	05/08/2019	5	5	0	28	1	0	28	04/05/2018	0	0	0	0	0	0	2017-02-15	5	5	0	2	60	30	90	29	0	0	1	27145.00	0	1	608 NORTH MAIN STREET LINDEN, AL 36748 (32.314081, -87.798181)	02/01/2020
4685	402 WEST FIRST STREET ADRIAN, MO 64720	38.394542	-94.359107	0		265780	ADRIAN MANOR HEALTH & REHABILITATION CENTER	402 WEST FIRST STREET	ADRIAN	MO	64720	8162972107	60	Bates	Government - City	60	42.4	Medicare and Medicaid	false	CITY OF ADRIAN - ADRIAN MANOR HEALTH AND REHAB	02/19/2004	false		false	false	false	Resident	Yes	1	1	2	1	4		2		2		2.50125	0.63622	0.33634	0.97256	3.47381	0.01197	2.00003	0.65524	0.28216	2.93742	2.59918	0.73012	0.44866	3.79221	01/17/2019	19	19	0	179	1	0	179	04/19/2018	5	5	0	36	1	36	2017-03-02	7	6	1	1	40	0	40	108.167	0	1	1	42110.00	1	2	402 WEST FIRST STREET ADRIAN, MO 64720 (38.394542, -94.359107)	02/01/2020
8094	309 NORTH MADISON STREET COLERIDGE, NE 68727	42.509249	-97.206543	0		285073	PARK VIEW HAVEN NURSING HOME	309 NORTH MADISON STREET	COLERIDGE	NE	68727	4022834224	130	Cedar	Government - City	34	29.5	Medicare and Medicaid	false	PARK VIEW HAVEN NURSING HOME	07/28/1986	false		false	false	false	Resident	Yes	2	2	5	5		2	1	12	1	12	1.66498	0.57556	0.67478	1.25034	2.91531	0.02321	1.94322	0.62107	0.27549	2.83978	1.78075	0.69684	0.92189	3.29195	11/19/2018	12	11	1	64	1	0	64	09/28/2017	11	11	9	92	1	92	2016-07-13	10	10	0	1	60	0	60	72.667	4	0	1	5292.00	1	2	309 NORTH MADISON STREET COLERIDGE, NE 68727 (42.509249, -97.206543)	02/01/2020
9477	530 RIVER AVE S PRAIRIE FARM, WI 54762	45.234892	-91.983299	0		525652	PIONEER HEALTH AND REHAB	530 RIVER AVE S	PRAIRIE FARM	WI	54762	7154551178	20	Barron	Government - City	30	25.7	Medicare and Medicaid	false	VILLAGE OF PRAIRIE FARM	07/23/1999	false		false	false	false	Resident	Yes	5	3	5	5		2	4		5		2.13425	0.36039	0.83033	1.19073	3.32497	0.01256	2.0996	0.66987	0.2789	3.04838	2.11263	0.40455	1.12054	3.49762	05/23/2019	3	3	0	16	1	0	16	04/12/2018	1	1	0	4	1	4	2017-03-02	15	15	0	1	96	0	96	25.333	0	0	1	2013.00	0	1	530 RIVER AVE S PRAIRIE FARM, WI 54762 (45.234892, -91.983299)	02/01/2020
9584	3520 Highland Dr, Millcreek, UT 84106, USA	40.6949272	-111.849639	1	ROOFTOP	465185	MILLCREEK REHABILITATION AND NURSING, LLC	3520 SOUTH HIGHLAND DRIVE	SALT LAKE CITY	UT	84106	8014847638	170	Salt Lake	Government - City	61	43.1	Medicare and Medicaid	true	BEAVER VALLEY HOSPITAL	04/04/2016	false	SFF Candidate	false	false	false	Resident	Yes	1	1	3	4	3		3		4		1.88533	0.14658	1.07926	1.22583	3.11116	0.00729	1.83421	0.8228	0.44572	3.10273	2.13626	0.13395	0.91136	3.21537	05/14/2019	38	30	8	377	1	0	377	08/15/2018	12	12	0	48	1	48	2017-05-10	6	3	3	1	44	0	44	211.833	0	10	1	38695.00	0	1		02/01/2020
10734	3665 BRINKER AVENUE OGDEN, UT 84403	41.196421	-111.950178	0		465083	CRESTWOOD REHABILITATION AND NURSING	3665 BRINKER AVENUE	OGDEN	UT	84403	8016272273	280	Weber	Government - City	88	55.6	Medicare and Medicaid	false	BEAVER VALLEY HOSPITAL	11/01/1981	false		false	false	false	Resident	Yes	2	2	3	3	2		2		2		2.14294	0.68215	0.46803	1.15018	3.29312	0.00894	1.98272	0.82159	0.44397	3.24829	2.24628	0.62432	0.39678	3.25092	05/09/2019	11	10	3	60	1	0	60	03/26/2018	20	20	6	140	1	140	2016-12-01	5	5	0	1	40	0	40	83.333	0	6	1	20546.00	0	1	3665 BRINKER AVENUE OGDEN, UT 84403 (41.196421, -111.950178)	02/01/2020
11535	151 EAST CENTER STREET SPANISH FORK, UT 84660	40.109816	-111.652277	0		465183	SPANISH FORK REHABILITATION AND NURSING	151 EAST CENTER STREET	SPANISH FORK	UT	84660	8017986220	240	Utah	Government - City	29	28	Medicare and Medicaid	true	BEAVER VALLEY HOSPITAL	01/14/2015	false		false	false	false	Resident	Yes	3	3	3	3	2		2		3		1.83148	0.18847	0.8753	1.06377	2.89524	0.00146	1.92448	0.85119	0.45651	3.23218	1.9779	0.16649	0.72167	2.87239	08/01/2019	5	5	0	36	1	0	36	08/01/2018	6	6	0	28	1	28	2017-03-29	9	9	0	1	173	0	173	56.167	0	0	1	18190.00	0	1	151 EAST CENTER STREET SPANISH FORK, UT 84660 (40.109816, -111.652277)	02/01/2020
12278	8001 W 5TH STREET BOWDLE, SD 57428	45.448546	-99.660939	0		435107	BOWDLE NURSING HOME	8001 W 5TH STREET POST OFFICE BOX 556	BOWDLE	SD	57428	6052856146	220	Edmunds	Government - City	38	33.1	Medicare and Medicaid	false	BOWDLE HOSPITAL	09/01/1997	false		false	false	false	Resident	Yes	1	1	1	1		2	5		5		2.71476	0.33166	0.92646	1.25812	3.97288	0.00443	2.05187	0.61498	0.29687	2.96372	2.74978	0.40552	1.17459	4.29854	04/03/2019	12	7	5	100	1	0	100	12/07/2017	2	2	0	12	1	12	2016-09-14	5	5	0	1	20	0	20	57.333	2	0	1	19246.00	0	1	8001 W 5TH STREET BOWDLE, SD 57428 (45.448546, -99.660939)	02/01/2020
12289	323 BLACK RIVER AVE WESTBY, WI 54667	43.661772	-90.8511	0		525619	NORSELAND NURSING HOME	323 BLACK RIVER AVE	WESTBY	WI	54667	6086343747	610	Vernon	Government - City	59	46.2	Medicare and Medicaid	false	BETHANY-ST. JOSEPH CORPORATION	07/01/1997	false		false	false	false	Resident	Yes	4	2	5	5		2	4		5		2.34098	0.26553	1.00459	1.27011	3.61109	0.0523	2.00052	0.65766	0.30591	2.96409	2.43204	0.30359	1.236	3.90661	10/30/2019	6	5	1	111	1	0	111	09/20/2018	1	1	0	8	1	8	2017-07-19	3	3	0	1	16	0	16	60.833	0	1	1	11941.00	0	1	323 BLACK RIVER AVE WESTBY, WI 54667 (43.661772, -90.8511)	02/01/2020
15346	1501 NORTH 8TH STREET NOBLE, OK 73068	35.157184	-97.388497	0		375245	NOBLE HEALTH CARE CENTER	1501 NORTH 8TH STREET	NOBLE	OK	73068	4058727102	130	Cleveland	Government - City	110	88.2	Medicare and Medicaid	false	CITY OF PAULS VALLEY	11/01/1995	false		false	false	false	Resident	Yes	2	3	2	4	1		1		1		2.27457	0.83656	0.22085	1.05741	3.33197	0.01248	2.03356	0.67809	0.30909	3.02074	2.32465	0.92767	0.26893	3.53705	12/13/2018	11	11	0	92	1	0	92	10/16/2017	4	4	0	32	1	32	2016-07-28	2	2	0	2	12	6	18	59.667	0	0	1	16480.00	0	1	1501 NORTH 8TH STREET NOBLE, OK 73068 (35.157184, -97.388497)	02/01/2020