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 9 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 "Rating Cycle 2 Number of Health Revisits" = :p0 and "Special Focus Status" = :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	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 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
953	2644 ALDRICH AVENUE SOUTH MINNEAPOLIS, MN 55408	44.954202	-93.289331	inf	SOUTHSIDE CARE CENTER	2644 ALDRICH AVENUE SOUTH	MINNEAPOLIS	MN	55408	6128724233	260	Hennepin	For profit - Partnership	17	15.2	Medicaid	false	Legal Business Name Not Available	01/26/1978	false	SFF Candidate	false	false	false	Resident	Yes	1	1	4	4		2	3		5		0.23728	0.7313	0.82858	1.55988	1.79716	0	1.38764	0.58	0.26877	2.23641	0.35538	0.9481	1.16035	2.57684	10/24/2018	12	12	0	68	1	0	68	01/29/2018	25	24	1	302	3	211	513	2017-05-26	12	12	0	2	163	82	245	245.833	0	3	0	0.00	0	0	2644 ALDRICH AVENUE SOUTH MINNEAPOLIS, MN 55408 (44.954202, -93.289331)	02/01/2020
5783	5427 GEX ROAD DIAMONDHEAD, MS 39525	30.377543	-89.379591	255163	MEMORIAL WOODLAND VILLAGE NURSING CENTER	5427 GEX ROAD	DIAMONDHEAD	MS	39525	2282554832	220	Hancock	For profit - Corporation	132	119.9	Medicare and Medicaid	false	MEMORIAL HOSPITAL AT GULFPORT	03/15/1993	false	SFF Candidate	false	false	false	Resident	Yes	1	1	1	1	1		2		2		2.17652	1.16175	0.40584	1.5676	3.74412	0.01605	1.97546	0.77555	0.3815	3.13251	2.28987	1.12638	0.4004	3.83274	04/11/2019	4	4	0	16	1	0	16	02/16/2018	16	16	1	473	3	331	804	2016-10-28	3	3	0	1	12	0	12	278	1	0	2	16559.00	1	3	5427 GEX ROAD DIAMONDHEAD, MS 39525 (30.377543, -89.379591)	02/01/2020
6242	33 MATEO AVENUE MILLBRAE, CA 94030	37.605154	-122.39402	56122	MILLBRAE SKILLED CARE	33 MATEO AVENUE	MILLBRAE	CA	94030	6506895784	510	San Mateo	For profit - Corporation	140	108.5	Medicare and Medicaid	false	Legal Business Name Not Available	10/24/1969	false	SFF Candidate	false	false	false	Resident	Yes	2	1	5	5	5		2		2		1.75714	0.87323	0.38053	1.25376	3.0109	0.07378	2.0878	0.67744	0.30314	3.06838	1.74918	0.96926	0.47247	3.14659	07/25/2019	17	15	2	92	1	0	92	08/06/2018	30	28	2	466	3	326	792	2017-07-03	12	7	5	1	56	0	56	319.333	7	5	1	43804.00	0	1	33 MATEO AVENUE MILLBRAE, CA 94030 (37.605154, -122.39402)	02/01/2020
7709	1313 SOUTH 25TH ST BETHANY, MO 64424	40.256602	-94.026919	265807	CRESTVIEW HOME	1313 SOUTH 25TH ST, PO BOX 430	BETHANY	MO	64424	6604253128	400	Harrison	For profit - Corporation	92	69.3	Medicare and Medicaid	false	N & R OF CRESTVIEW LLC	12/13/2006	false	SFF Candidate	false	false	false	Resident	Yes	1	1	4	4		2	3		3		2.02871	0.29902	0.37294	0.67196	2.70067	0.02972	1.71894	0.60913	0.27644	2.60451	2.45287	0.36913	0.50778	3.32506	05/23/2019	21	9	12	112	2	56	168	05/03/2018	18	10	8	242	3	169	411	2017-05-05	10	7	4	1	76	0	76	233.667	0	21	1	50567.00	1	2	1313 SOUTH 25TH ST BETHANY, MO 64424 (40.256602, -94.026919)	02/01/2020
8659	2108 STILLMAN SELMA, CA 93662	36.572478	-119.612861	555892	SELMA CONVALESCENT HOSPITAL	2108 STILLMAN	SELMA	CA	93662	5598964990	90	Fresno	For profit - Corporation	34	29.8	Medicare and Medicaid	false	Legal Business Name Not Available	06/17/2014	false	SFF Candidate	false	false	false	Resident	Yes	2	1	2	3	1		4		4		3.11128	1.44332	0.63343	2.07675	5.18803	0.05858	1.8255	0.67803	0.31734	2.82088	3.5422	1.60065	0.75129	5.89756	09/17/2019	16	13	5	104	1	0	104	09/18/2018	22	22	3	604	3	423	1027	2017-06-22	3	2	1	1	12	0	12	396.333	8	3	0	0.00	1	1	2108 STILLMAN SELMA, CA 93662 (36.572478, -119.612861)	02/01/2020
9370	68222 COMMERCIAL DRIVE BRIDGEPORT, OH 43912	40.071038	-80.780644	365559	ROLLING HILLS REHAB AND CARE CTR	68222 COMMERCIAL DRIVE	BRIDGEPORT	OH	43912	7406354600	60	Belmont	For profit - Partnership	99	55	Medicare and Medicaid	false	LANSING GARDENS REHABILITATION AND CARE CENTER LLC	07/23/1981	false	SFF Candidate	false	false	false	Both	Yes	1	1	2	4	1		2		2		1.90567	0.87362	0.56796	1.44157	3.34724	0.08046	2.26765	0.87978	0.46025	3.60768	1.74658	0.74667	0.46446	2.97518	02/07/2019	21	13	8	132	1	0	132	12/22/2017	54	47	10	1302	3	911	2213	2016-10-06	24	12	12	2	120	60	180	833.667	0	15	1	232683.00	1	2	68222 COMMERCIAL DRIVE BRIDGEPORT, OH 43912 (40.071038, -80.780644)	02/01/2020
11190	240 SPRUCE STREET GRIDLEY, CA 95948	39.366974	-121.689717	555776	ORCHARD HOSPITAL D/P SNF	240 SPRUCE STREET	GRIDLEY	CA	95948	5308465671	30	Butte	For profit - Corporation	82	56.2	Medicare and Medicaid	true	ORCHARD HOSPITAL	12/31/2001	false	SFF Candidate	false	false	false	Resident	Yes	1	1	2	2		2	3		2		2.60482	1.40607	0.27308	1.67915	4.28397	0.00784	1.9335	0.6131	0.29049	2.83709	2.79994	1.7245	0.35383	4.84202	10/03/2019	15	13	2	120	2	60	180	11/06/2018	46	38	28	493	3	345	838	2017-09-14	12	12	0	1	72	0	72	381.333	3	1	1	77244.00	1	2	240 SPRUCE STREET GRIDLEY, CA 95948 (39.366974, -121.689717)	02/01/2020
11237	454 LIPAN AVENUE MESCALERO, NM 88340	33.15751	-105.770463	325116	MESCALERO CARE CENTER	454 LIPAN AVENUE	MESCALERO	NM	88340	5754644802	170	Otero	Non profit - Other	40	35	Medicare and Medicaid	false	MESCALERO CARE CENTER	12/17/2003	false	SFF Candidate	false	false	false	Resident	Yes	1	1	3	3	4		1	12	1	12	3.99969	0.4254	0	0.4254	4.42509	0	1.84942	0.70975	0.34347	2.90263	4.49477	0.45069	0	4.88859	10/01/2019	30	30	0	300	1	0	300	07/19/2018	37	31	10	1693	3	1185	2878	2017-08-16	10	10	0	1	52	0	52	1118	0	2	1	168522.00	2	3	454 LIPAN AVENUE MESCALERO, NM 88340 (33.15751, -105.770463)	02/01/2020
12398	25652 OLD TRABUCO ROAD LAKE FOREST, CA 92630	33.645333	-117.683217	555308	LAKE FOREST NURSING CENTER	25652 OLD TRABUCO ROAD	LAKE FOREST	CA	92630	9493809380	400	Orange	For profit - Corporation	175	127.7	Medicare and Medicaid	false	EL TORO MEDICAL INVESTORS LIMITED PARTNERSHIP	06/28/1988	false	SFF Candidate	false	false	false	Resident	Yes	2	1	5	5	5		3		3		2.31302	1.37722	0.50378	1.881	4.19402	0.26776	2.34179	0.79043	0.36558	3.49781	2.0528	1.31016	0.51866	3.84492	04/29/2019	28	21	7	112	1	0	112	05/18/2018	52	38	16	312	3	218	530	2017-05-30	38	23	16	1	156	0	156	258.667	4	18	0	0.00	0	0	25652 OLD TRABUCO ROAD LAKE FOREST, CA 92630 (33.645333, -117.683217)	02/01/2020