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	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	RN Staffing Rating	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
1726	4921 MEDICAL DRIVE BOSSIER CITY, LA 71112	32.46018	-93.667644	195604	COLONIAL OAKS SKILLED NURSING AND REHABILITATION	4921 MEDICAL DRIVE	BOSSIER CITY	LA	71112	3187425420	70	Bossier	For profit - Corporation	120	105.9	Medicare and Medicaid	false	PMG OPCO-COLONIAL LLC	09/24/2004	false	true	false	true	Resident	Yes	1	1	2	3	1	1	1	2.3008	1.05814	0.11733	1.17546	3.47626	0.09787	2.07163	0.90331	0.50031	3.47525	2.30825	0.88083	0.08826	3.2076	06/28/2019	12	9	3	193	1	193	06/21/2018	8	5	3	48	1	48	2017-05-18	1	1	0	1	4	0	4	113.167	1	4	1	37047.00	1	2	4921 MEDICAL DRIVE BOSSIER CITY, LA 71112 (32.46018, -93.667644)	02/01/2020
2500	38410 CHERRY HILL RD WESTLAND, MI 48185	42.309281	-83.418083	235228	CHERRY HILL FOR NURSING AND REHABILITATION	38410 CHERRY HILL RD	WESTLAND	MI	48185	7343261200	810	Wayne	For profit - Corporation	127	87.4	Medicare and Medicaid	false	CHERRY HILL OPCO LLC	06/01/1978	false	true	false	true	Resident	Yes	1	1	3	5	2	2	2	2.05291	0.85859	0.43571	1.2943	3.34721	0.1692	2.02776	0.71821	0.34792	3.09389	2.10411	0.89891	0.47136	3.46921	06/05/2019	15	10	5	234	1	234	03/22/2018	21	11	10	116	1	116	2017-05-18	30	6	26	1	244	0	244	196.333	8	78	3	254530.00	1	4	38410 CHERRY HILL RD WESTLAND, MI 48185 (42.309281, -83.418083)	02/01/2020
2769	701 HOMESTEAD ST MARQUETTE, MI 49855	46.541158	-87.409126	235367	NORLITE NURSING CENTER	701 HOMESTEAD ST	MARQUETTE	MI	49855	9062289252	510	Marquette	For profit - Corporation	99	78.6	Medicare and Medicaid	false	NORLITE NURSING CENTERS OF MARQUETTE INC	09/01/1978	false	true	false	false	Resident	Yes	3	2	4	2	5	4	3	2.58432	1.35558	0.60997	1.96555	4.54987	0.05203	2.16519	0.67827	0.32062	3.16409	2.48065	1.50281	0.71606	4.61109	09/12/2019	14	10	5	201	1	201	07/20/2018	15	10	5	96	1	96	2017-05-18	8	5	3	2	40	20	60	142.5	7	3	1	11941.00	0	1	701 HOMESTEAD ST MARQUETTE, MI 49855 (46.541158, -87.409126)	02/01/2020
3428	2320 E BELTLINE SE GRAND RAPIDS, MI 49546	42.921573	-85.584051	235103	SKLD BELTLINE	2320 E BELTLINE SE	GRAND RAPIDS	MI	49546	6169493000	400	Kent	For profit - Corporation	182	108.1	Medicare and Medicaid	false	GRAND RAPIDS SNF LLC	01/01/1967	false	true	false	false	Resident	Yes	3	2	3	3	3	4	4	2.59034	0.81557	0.84365	1.65921	4.24956	0.04363	2.12422	0.70517	0.31354	3.14293	2.53439	0.86966	1.01274	4.33573	09/11/2019	27	11	16	184	1	184	06/29/2018	14	4	10	112	1	112	2017-05-18	19	16	3	1	124	0	124	150	14	31	1	2121.00	1	2	2320 E BELTLINE SE GRAND RAPIDS, MI 49546 (42.921573, -85.584051)	02/01/2020
7336	4747 ALBEN BARKLEY DRIVE PADUCAH, KY 42001	37.056282	-88.659253	185312	STONECREEK HEALTH AND REHABILITATION	4747 ALBEN BARKLEY DRIVE	PADUCAH	KY	42001	2704449661	720	Mc Cracken	For profit - Corporation	86	77.4	Medicare and Medicaid	false	PADUCAH CENTER FOR HEALTH AND REHABILITATION, LLC	12/01/1991	false	true	false	false	Resident	Yes	2	2	3	2	3	2	2	2.14362	0.84804	0.43388	1.28192	3.42554	0.05391	2.05357	0.82136	0.4227	3.29763	2.16947	0.77637	0.38633	3.33104	10/04/2019	17	4	13	112	1	112	07/12/2018	8	5	3	56	1	56	2017-05-18	4	0	4	0	16	0	16	77.333	1	10	2	18190.00	0	2	4747 ALBEN BARKLEY DRIVE PADUCAH, KY 42001 (37.056282, -88.659253)	02/01/2020
10002	429 SOUTH MARKET STREET MARTINSBURG, PA 16662	40.305177	-78.328452	395563	MORRISONS COVE HOME	429 SOUTH MARKET STREET	MARTINSBURG	PA	16662	8147932104	120	Blair	Non profit - Corporation	124	119	Medicare and Medicaid	false	THE VILLAGE AT MORRISONS COVE	01/01/1983	true	true	false	false	Both	Yes	3	2	4	5	3	4	4	2.41836	0.79597	0.70322	1.4992	3.91756	0.02671	2.14301	0.72151	0.33948	3.204	2.34538	0.82954	0.77966	3.92081	06/20/2019	9	6	3	92	1	92	05/17/2018	9	9	0	48	1	48	2017-05-18	6	6	0	1	40	0	40	68.667	2	0	1	118141.00	0	1	429 SOUTH MARKET STREET MARTINSBURG, PA 16662 (40.305177, -78.328452)	02/01/2020