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 8 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	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 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
3010	5700 EAST RIVER ROAD FRIDLEY, MN 55432	45.071529	-93.277123	245201	THE ESTATES AT FRIDLEY LLC	5700 EAST RIVER ROAD	FRIDLEY	MN	55432	7635713150	10	Anoka	For profit - Corporation	54	42.8	Medicare and Medicaid	false	ESTATES AT FRIDLEY LLC	04/01/1975	false	true	false	false	Both	Yes	3	2	4	4	4		4	4	2.43707	0.73863	0.89173	1.63037	4.06744	0.08419	2.03746	0.76247	0.37317	3.1731	2.48596	0.72843	0.89941	4.11045	07/11/2019	9	7	4	76	1	76	05/10/2018	6	3	3	32	1	32	2017-03-09	15	13	2	1	76	76	61.333	6	4	0	0.00	0	0	5700 EAST RIVER ROAD FRIDLEY, MN 55432 (45.071529, -93.277123)	02/01/2020
4066	205 N TRACY AVE BOZEMAN, MT 59715	45.681665	-111.037229	275039	MOUNTAIN VIEW CARE CENTER	205 N TRACY AVE	BOZEMAN	MT	59715	4065872218	150	Gallatin	For profit - Corporation	86	33.3	Medicare and Medicaid	false	KISMET BZN LLC	01/20/1971	false	true	false	false	Resident	Yes	1	1	2	2	3		3	3	2.08303	0.7975	0.56353	1.36103	3.44406	0.0444	1.77379	0.6845	0.33513	2.79341	2.44068	0.87608	0.6329	3.95356	07/11/2019	17	17	0	136	1	136	05/31/2018	11	11	0	76	1	76	2017-03-09	20	12	8	1	208	208	128	0	5	3	122796.00	0	3	205 N TRACY AVE BOZEMAN, MT 59715 (45.681665, -111.037229)	02/01/2020
5882	2 PENROSE BLVD COLORADO SPRINGS, CO 80906	38.786219	-104.858447	06A196	NAMASTE ALZHEIMER CENTER	2 PENROSE BLVD	COLORADO SPRINGS	CO	80906	7194424240	200	El Paso	Non profit - Corporation	64	63	Medicaid	false	Legal Business Name Not Available	05/29/2003	false	true	false	false	Family	Yes	2	1	5	5		2	4	4	2.56191	0.42351	0.53411	0.95761	3.51952	0	2.01156	0.58379	0.24957	2.84492	2.64695	0.54549	0.80552	3.96704	12/10/2019	16	11	5	104	1	104	11/15/2018	11	10	10	100	1	100	2017-03-09	16	12	4	1	88	88	100	0	12	0	0.00	0	0	2 PENROSE BLVD COLORADO SPRINGS, CO 80906 (38.786219, -104.858447)	02/01/2020
8046	3033 AUGUSTA ST SAN LUIS OBISPO, CA 93401	35.267218	-120.640812	56189	BELLA VISTA TRANSITIONAL CARE CENTER	3033 AUGUSTA ST	SAN LUIS OBISPO	CA	93401	8055445100	500	San Luis Obispo	For profit - Corporation	162	96	Medicare and Medicaid	false	BAYSHORE HEALTHCARE, INC.	02/29/1972	false	true	false	false	Resident	Yes	3	2	5	4	5		3	3	2.4978	0.94987	0.65511	1.60498	4.10278	0.15377	2.17385	0.72676	0.3392	3.23981	2.38805	0.98278	0.72692	4.0608	02/07/2019	12	8	4	76	1	76	02/15/2018	15	8	7	84	1	84	2017-03-09	9	6	5	1	64	64	76.667	7	6	1	12250.00	0	1	3033 AUGUSTA ST SAN LUIS OBISPO, CA 93401 (35.267218, -120.640812)	02/01/2020
9744	1700 PINE STREET NORRISTOWN, PA 19401	40.130248	-75.331053	396009	NORRITON SQUARE NURSING AND REHABILITATION CENTER	1700 PINE STREET	NORRISTOWN	PA	19401	6102397100	560	Montgomery	For profit - Corporation	99	87.4	Medicare and Medicaid	false	1700 PINE STREET OPERATIONS LLC	09/10/1996	false	true	false	false	Resident	Yes	2	1	3	2	4		4	4	1.81112	0.77773	0.9083	1.68603	3.49715	0.05065	1.91311	0.74848	0.37669	3.03828	1.96754	0.78133	0.90757	3.69097	03/29/2019	16	15	1	120	1	120	05/16/2018	17	7	10	92	1	92	2017-03-09	6	6	0	1	48	48	98.667	1	6	1	82823.00	0	1	1700 PINE STREET NORRISTOWN, PA 19401 (40.130248, -75.331053)	02/01/2020
12229	3600 MOUNTAIN ROAD GLEN ALLEN, VA 23060	37.673318	-77.522195	495299	ELIZABETH ADAM CRUMP HEALTH AND REHAB	3600 MOUNTAIN ROAD	GLEN ALLEN	VA	23060	8046728725	430	Henrico	For profit - Partnership	180	163.6	Medicare and Medicaid	false	GL VIRGINIA ELIZABETH HOUSE LLC	03/01/1995	false	true	false	false	Resident	Yes	1	1	3	1	5		2	2	1.83948	0.70198	0.34166	1.04365	2.88313	0.03739	1.95833	0.74396	0.36233	3.06462	1.9522	0.70951	0.35492	3.01675	06/14/2019	28	23	7	136	1	136	04/27/2018	29	29	5	160	1	160	2017-03-09	21	17	4	1	116	116	140.667	0	34	0	0.00	0	0	3600 MOUNTAIN ROAD GLEN ALLEN, VA 23060 (37.673318, -77.522195)	02/01/2020
12812	146 BATTLESHIP ROAD CAMDEN, SC 29020	34.252144	-80.634137	425169	SPRINGDALE HEALTHCARE CENTER	146 BATTLESHIP ROAD	CAMDEN	SC	29020	8034323741	270	Kershaw	For profit - Corporation	148	133.4	Medicare and Medicaid	false	PALMETTO SPRINGDALE OPERATING LLC	01/06/1989	false	true	false	false	Resident	Yes	1	1	3	4	3		2	1	2.0498	1.2326	0.25525	1.48785	3.53764	0.04974	2.0319	0.69009	0.31251	3.0345	2.09665	1.34307	0.30742	3.73835	08/15/2019	9	9	4	76	1	76	06/22/2018	16	16	0	108	1	108	2017-03-09	7	7	0	1	36	36	80	2	0	1	11284.00	0	1	146 BATTLESHIP ROAD CAMDEN, SC 29020 (34.252144, -80.634137)	02/01/2020
13845	140 N STATE STREET WESTERVILLE, OH 43081	40.129654	-82.932817	365933	BUCKEYE TERRACE REHABILITATION AND NURSING CENTER	140 N STATE STREET	WESTERVILLE	OH	43081	6148824055	250	Franklin	For profit - Corporation	70	61.8	Medicare and Medicaid	false	EDGEWOOD MANOR OF WESTERVILLE LLC	10/29/1993	false	true	false	false	Both	Yes	1	1	3	3	3		2	2	1.75748	1.12334	0.53909	1.66243	3.41991	0.03245	2.05563	0.85015	0.44847	3.35425	1.77689	0.99357	0.45244	3.26943	07/03/2019	38	21	17	200	1	200	05/31/2018	22	12	10	120	1	120	2017-03-09	8	7	1	1	32	32	145.333	0	10	0	0.00	1	1	140 N STATE STREET WESTERVILLE, OH 43081 (40.129654, -82.932817)	02/01/2020