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	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 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 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
4203	1010 VARNUM AVENUE LOWELL, MA 01854	42.643744	-71.365962	225298	NORTHWOOD REHABILITATION & HEALTHCARE CENTER	1010 VARNUM AVENUE	LOWELL	MA	1854	9784588773	90	Middlesex	For profit - Corporation	123	115.6	Medicare and Medicaid	false	NORTHWOOD MA SNF LLC	02/17/1987	false	SFF Candidate	true	false	false	Resident	Yes	1	1	4	4	4	2	2	2.47232	0.87884	0.45843	1.33727	3.80959	0.14221	2.08245	0.72888	0.35342	3.16475	2.46743	0.90665	0.48821	3.86004	02/07/2019	10	7	3	80	1	0	80	12/07/2017	13	8	5	589	1	589	2016-10-13	4	2	2	1	20	20	239.667	3	0	3	128136.00	0	3	1010 VARNUM AVENUE LOWELL, MA 01854 (42.643744, -71.365962)	02/01/2020
5496	400 SOUTH CRAPO ST MOUNT PLEASANT, MI 48858	43.601259	-84.757615	235385	LAURELS OF MT. PLEASANT (THE)	400 SOUTH CRAPO ST	MOUNT PLEASANT	MI	48858	9897735918	360	Isabella	For profit - Corporation	112	84.1	Medicare and Medicaid	false	LAUREL HEALTH CARE COMPANY OF MT PLEASANT	01/01/1979	false		true	false	false	Resident	Yes	1	1	4	4	5	3	3	2.03163	0.64305	0.65263	1.29568	3.32731	0.0665	2.07899	0.76802	0.37395	3.22097	2.03099	0.62958	0.65687	3.31254	12/20/2018	43	11	35	264	1	0	264	10/05/2017	20	6	15	104	1	104	2016-10-13	8	5	4	1	147	147	191.167	49	19	2	120886.00	1	3	400 SOUTH CRAPO ST MOUNT PLEASANT, MI 48858 (43.601259, -84.757615)	02/01/2020
9074	8 NORTH TEXAS AVENUE GREENVILLE, SC 29611	34.836764	-82.4401	425102	POINSETT REHABILITATION AND HEALTHCARE CENTER	8 NORTH TEXAS AVENUE	GREENVILLE	SC	29611	8642951331	220	Greenville	For profit - Corporation	132	122.5	Medicare and Medicaid	false	Legal Business Name Not Available	09/02/1975	false		true	false	false	Resident	Yes	1	1	1	1	1	3	3	2.52566	0.9754	0.45709	1.43249	3.95815	0.0184	1.95156	0.68125	0.31184	2.94464	2.68973	1.07662	0.55171	4.31035	02/14/2019	8	8	0	100	2	50	150	02/01/2018	10	9	1	44	1	44	2016-10-13	8	8	0	1	44	44	97	0	1	3	35321.00	1	4	8 NORTH TEXAS AVENUE GREENVILLE, SC 29611 (34.836764, -82.4401)	02/01/2020
10917	401 WITSELL STREET WALTERBORO, SC 29488	32.908717	-80.657955	425053	PRUITTHEALTH-WALTERBORO	401 WITSELL STREET	WALTERBORO	SC	29488	8435495546	140	Colleton	For profit - Corporation	132	120.5	Medicare and Medicaid	false	PRUITTHEALTH-WALTERBORO LLC	01/01/1981	false		true	false	false	Resident	Yes	2	2	3	1	4	2	2	2.27071	0.73309	0.3932	1.12629	3.397	0.02912	2.08032	0.70618	0.31334	3.09983	2.26855	0.7806	0.47232	3.51407	01/11/2019	14	14	0	60	1	0	60	11/02/2017	21	21	0	112	1	112	2016-10-13	4	2	2	1	16	16	70	0	0	0	0.00	0	0	401 WITSELL STREET WALTERBORO, SC 29488 (32.908717, -80.657955)	02/01/2020
11485	959 SOUTHWEST 107TH STREET OKLAHOMA CITY, OK 73139	35.359806	-97.532177	375256	MEADOWLAKE ESTATES	959 SOUTHWEST 107TH STREET	OKLAHOMA CITY	OK	73139	4057033400	130	Cleveland	For profit - Corporation	124	105.1	Medicare and Medicaid	false	CITY OF PAULS VALLEY	04/26/1996	false	SFF Candidate	true	false	false	Resident	Yes	1	1	2	3	1	2	1	2.14567	0.96977	0.25102	1.22079	3.36646	0.01241	1.86119	0.67885	0.32418	2.86422	2.39601	1.07418	0.29145	3.76896	03/06/2019	41	16	25	364	1	0	364	01/24/2018	18	5	17	160	1	160	2016-10-13	9	7	2	1	60	60	245.333	0	41	2	24053.00	3	5	959 SOUTHWEST 107TH STREET OKLAHOMA CITY, OK 73139 (35.359806, -97.532177)	02/01/2020
15236	2044 PAGELAND HWY LANCASTER, SC 29720	34.721319	-80.719445	425155	LANCASTER CONVALESCENT CENTER	2044 PAGELAND HWY	LANCASTER	SC	29720	8032857907	280	Lancaster	For profit - Corporation	142	136.9	Medicare and Medicaid	false	LANCASTER HEALTH CARE LLC	02/24/1986	false		true	false	false	Both	Yes	2	2	3	3	3	3	3	2.237	0.87937	0.41723	1.2966	3.5336	0.05154	2.08015	0.69311	0.30793	3.08119	2.23505	0.95401	0.50999	3.6775	02/01/2019	8	8	0	88	1	0	88	01/13/2018	12	12	0	56	1	56	2016-10-13	11	11	0	1	56	56	72	0	0	1	13905.00	0	1	2044 PAGELAND HWY LANCASTER, SC 29720 (34.721319, -80.719445)	02/01/2020