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	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	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 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
2498	1005 E CENTENNIAL DRIVE PITTSBURG, KS 66762	37.381788	-94.688739	0		175208	PITTSBURG OPERATOR LLC	1005 E CENTENNIAL DRIVE	PITTSBURG	KS	66762	6202311120	180	Crawford	Government - State	86	63.2	Medicare and Medicaid	false	PITTSBURG OPERATOR, LLC	05/15/1991	false		true	false	true	Resident	Yes	1	1	3	2	5	3		3				2.59714	0.4351	0.64413	1.07922	3.67636	0	1.85742	0.69344	0.33425	2.88511	2.90603	0.47181	0.72532	4.08611	08/05/2019	20	15	19	160	1	0	160	09/27/2018	28	22	13	192	1	192	2016-12-01	14	13	1	1	390	390	209	2	11	3	79057.00	1	4	1005 E CENTENNIAL DRIVE PITTSBURG, KS 66762 (37.381788, -94.688739)	02/01/2020
3551	5901 LEMON HILL AVE SACRAMENTO, CA 95824	38.515906	-121.436572	0		55956	BRIARWOOD POST ACUTE	5901 LEMON HILL AVE	SACRAMENTO	CA	95824	9163832741	440	Sacramento	For profit - Individual	49	44.4	Medicare and Medicaid	false	BRIARWOOD POST ACUTE LLC	11/01/1969	false		true	false	false	Resident	Yes	1	1	2	4	1	1	12	1	12			2.74326	1.56068	0.22022	1.7809	4.52416	0.15756	1.8413	0.71835	0.33565	2.89529	3.09641	1.63367	0.24694	5.0107	11/13/2018	40	31	13	232	1	0	232	12/18/2017	22	19	3	104	1	104	2016-12-01	13	9	4	1	68	68	162	9	23	0	0.00	0	0	5901 LEMON HILL AVE SACRAMENTO, CA 95824 (38.515906, -121.436572)	02/01/2020
10281	1007 N KING ST COLUMBIA, SC 29223	34.082451	-80.934375	0		425287	MAGNOLIA MANOR - COLUMBIA	1007 N KING ST	COLUMBIA	SC	29223	8036994111	390	Richland	For profit - Corporation	88	83	Medicare and Medicaid	false	THI OF SOUTH CAROLINA AT COLUMBIA, LLC	08/08/1988	false	SFF Candidate	true	false	false	Resident	Yes	1	1	2	4	1	2		2				1.9336	1.18468	0.46112	1.6458	3.57941	0.06197	2.03656	0.7876	0.46669	3.29085	1.97327	1.13105	0.37189	3.48784	02/03/2019	25	25	0	375	2	188	563	02/09/2018	17	16	1	120	1	120	2016-12-01	1	1	0	1	4	4	322.167	0	1	2	119343.00	0	2	1007 N KING ST COLUMBIA, SC 29223 (34.082451, -80.934375)	02/01/2020
10658	33426 OLD SALISBURY ROAD ALBEMARLE, NC 28002	35.391085	-80.222097	0		345146	BETHANY WOODS NURSING AND REHABILITATION CENTER	33426 OLD SALISBURY ROAD BOX 1250	ALBEMARLE	NC	28002	7049831195	830	Stanly	For profit - Corporation	180	147.3	Medicare and Medicaid	false	SPRUCE LTC GROUP, LLC	03/19/1975	false		true	false	false	Resident	Yes	1	1	3	2	3	3		3				1.86462	0.71213	0.52476	1.23689	3.10151	0.03524	1.91687	0.7459	0.37112	3.0339	2.02168	0.71789	0.5322	3.27812	11/16/2018	28	20	8	243	1	0	243	11/02/2017	9	8	1	40	1	40	2016-12-01	14	14	0	1	64	64	145.5	0	8	0	0.00	0	0	33426 OLD SALISBURY ROAD ALBEMARLE, NC 28002 (35.391085, -80.222097)	02/01/2020
11398	7777 COOPER ROAD CINCINNATI, OH 45242	39.226769	-84.357466	0		365327	MONTGOMERY CARE CENTER	7777 COOPER ROAD	CINCINNATI	OH	45242	5137935092	310	Hamilton	For profit - Corporation	102	73.9	Medicare and Medicaid	false	MONTGOMERY AT CARECORE LLC	07/25/1975	false		true	false	false	Resident	Yes	1	1	3	4	2	2		1				1.97625	1.41374	0.37713	1.79087	3.76712	0.07508	2.0423	0.84614	0.4569	3.34533	2.01112	1.25635	0.31068	3.61096	03/12/2019	18	11	7	104	1	0	104	02/01/2018	29	12	18	156	1	156	2016-12-01	8	4	4	1	44	44	111.333	2	15	0	0.00	2	2	7777 COOPER ROAD CINCINNATI, OH 45242 (39.226769, -84.357466)	02/01/2020
12727	335 Township Rd 1026, South Point, OH 45680, USA	38.4097766	-82.5368649	1	ROOFTOP	366265	RIVER'S BEND HEALTH CARE LLC	335 TOWNSHIP ROAD 1026	SOUTH POINT	OH	45680	7408943476	450	Lawrence	For profit - Corporation	80	36.9	Medicare and Medicaid	false	RIVER'S BEND HEALTH CARE, LLC	04/24/2003	false	SFF Candidate	true	false	false	Resident	Yes	2	1	5	5	4	1	12	1	12	6	6															11/16/2018	30	20	10	1464	1	0	1464	09/22/2017	15	15	0	124	1	124	2016-12-01	6	6	0	1	32	32	778.667	0	3	2	35464.00	2	4		02/01/2020