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	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 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
6154	2030 N GAREY AVE POMONA, CA 91767	34.083709	-117.752566	05A134	LANDMARK MEDICAL CENTER	2030 N. GAREY AVE.	POMONA	CA	91767	9095932585	200	Los Angeles	For profit - Corporation	95	93.9	Medicaid	false	Legal Business Name Not Available	03/31/1974	false	true	false	false	Resident	Yes	3	2	5	5		2	2		1		2.03403	0.70375	0.09013	0.79388	2.82791	0	1.43196	0.52772	0.22824	2.18793	2.95217	1.00277	0.14862	4.14463	08/01/2019	11	8	3	52	1	52	07/17/2018	9	5	4	56	1	56	2017-07-28	16	10	7	1	80	0	80	58	17	0	0	0.00	0	0	2030 N GAREY AVE POMONA, CA 91767 (34.083709, -117.752566)	02/01/2020
11085	200 LIVE OAK ST ATLANTA, TX 75551	33.107136	-94.16461	675603	ROSE HAVEN RETREAT	200 LIVE OAK ST	ATLANTA	TX	75551	9037964127	260	Cass	Government - Hospital district	108	51.7	Medicare and Medicaid	false	WINNIE-STOWELL HOSPITAL DISTRICT	06/14/1996	false	true	false	false	Resident	Yes	1	1	3	3	2		2		1		2.04815	1.38309	0.29988	1.68297	3.73112	0.007	1.97003	0.79106	0.4227	3.18379	2.16076	1.31469	0.26702	3.75793	05/16/2019	8	0	8	411	1	411	06/14/2018	0	0	0	0	0	0	2017-07-28	13	8	10	1	362	0	362	265.833	7	3	2	46571.00	0	2	200 LIVE OAK ST ATLANTA, TX 75551 (33.107136, -94.16461)	02/01/2020
11710	3701 WASSON RD BIG SPRING, TX 79720	32.211102	-101.492449	676380	BIG SPRING CENTER FOR SKILLED CARE	3701 WASSON RD	BIG SPRING	TX	79720	4326065012	661	Howard	For profit - Individual	120	71.5	Medicare and Medicaid	false	BIG SPRING I ENTERPRISES, LLC	03/13/2015	false	true	false	false	Resident	Yes	1	1	2	1	3		1	12	1	12	2.41958	0.81199	0.26906	1.08105	3.50063	0.07375	2.11488	0.78248	0.403	3.30037	2.37777	0.7803	0.25129	3.40124	09/19/2019	11	6	5	326	1	326	09/13/2018	6	4	6	48	1	48	2017-07-28	3	3	0	1	20	0	20	182.333	4	1	0	0.00	1	1	3701 WASSON RD BIG SPRING, TX 79720 (32.211102, -101.492449)	02/01/2020
12830	1555 EAST END BOULEVARD PLAINS WILKES BARRE, PA 18711	41.248912	-75.836029	395148	TIMBER RIDGE HEALTH CENTER	1555 EAST END BOULEVARD PLAINS TWP	WILKES BARRE	PA	18711	5708261011	480	Luzerne	For profit - Corporation	180	168.9	Medicare and Medicaid	false	VALLEY CREST NURSING, INC.	01/01/1967	false	true	false	false	None	Yes	2	2	3	4	2		2		2		2.30523	0.86056	0.44657	1.30713	3.61237	0.05457	2.15874	0.84867	0.44788	3.4553	2.21937	0.76248	0.37528	3.35243	07/26/2019	5	5	1	32	1	32	08/03/2018	12	11	2	60	1	60	2017-07-28	21	12	9	2	120	60	180	66	1	10	0	0.00	1	1	1555 EAST END BOULEVARD PLAINS WILKES BARRE, PA 18711 (41.248912, -75.836029)	02/01/2020
13144	120 LAKESIDE DRIVE WORTHINGTON, PA 16262	40.896932	-79.673697	395410	QUALITY LIFE SERVICES - SUGAR CREEK	120 LAKESIDE DRIVE	WORTHINGTON	PA	16262	7244453146	70	Armstrong	For profit - Partnership	114	96.6	Medicare and Medicaid	false	SUGAR CREEK REST, LTD PTR	04/06/1978	true	true	false	false	Resident	Yes	2	2	4	5	4		2		2		1.80066	1.09068	0.55206	1.64275	3.44341	0.02188	2.15974	0.82215	0.44081	3.4227	1.73279	0.99755	0.47137	3.22606	06/20/2019	7	5	2	68	1	68	06/05/2018	6	6	1	36	1	36	2017-07-28	6	5	2	1	44	0	44	53.333	1	6	0	0.00	0	0	120 LAKESIDE DRIVE WORTHINGTON, PA 16262 (40.896932, -79.673697)	02/01/2020
13283	515 W ASHBY PL SAN ANTONIO, TX 78212	29.449138	-98.498824	455689	SAN PEDRO MANOR	515 W ASHBY PL	SAN ANTONIO	TX	78212	2107325181	130	Bexar	For profit - Limited Liability company	150	94.5	Medicare and Medicaid	false	UVALDE COUNTY HOSPITAL AUTHORITY	02/18/1987	false	true	false	false	Resident	Yes	1	1	4	5	3		1		1		1.71552	1.07604	0.29193	1.36797	3.08349	0	2.01244	0.80048	0.41464	3.22756	1.77169	1.01079	0.265	3.06352	08/16/2019	14	12	3	124	1	124	08/17/2018	22	12	11	216	1	216	2017-07-28	10	8	3	1	80	0	80	147.333	5	8	1	12906.00	0	1	515 W ASHBY PL SAN ANTONIO, TX 78212 (29.449138, -98.498824)	02/01/2020