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	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 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
655	1000 DIANA ST LUDINGTON, MI 49431	43.95773	-86.4313	235072	OAKVIEW MEDICAL CARE FACILITY	1000 DIANA ST	LUDINGTON	MI	49431	2318455185	520	Mason	Government - County	96	92.4	Medicare and Medicaid	false	OAKVIEW MEDICAL CARE FACILITY	01/04/1967	false		true	false	false	Resident	Yes	2	1	3	2	5		5		5				2.60113	0.41127	1.19605	1.60732	4.20845	0.05315	1.97662	0.62117	0.27912	2.8769	2.73498	0.49785	1.61287	4.69083	09/27/2019	16	9	7	392	1	0	392	07/17/2018	15	11	4	92	1	92	2017-05-25	13	13	0	1	80	80	240	20	0	3	106524.00	1	4	1000 DIANA ST LUDINGTON, MI 49431 (43.95773, -86.4313)	02/01/2020
6039	3311 S MICHIGAN AVE CHICAGO, IL 60616	41.834371	-87.623323	146161	SOUTHVIEW MANOR	3311 S. MICHIGAN AVE.	CHICAGO	IL	60616	3123269101	141	Cook	For profit - Individual	200	186.6	Medicare and Medicaid	false	Legal Business Name Not Available	06/02/2013	false		true	false	false	Resident	Yes	2	2	5	5		2	1	12	1	12	6	6															04/18/2019	6	1	6	115	1	0	115	06/21/2018	11	7	5	64	1	64	2017-05-25	12	7	7	1	88	88	93.5	2	37	0	0.00	0	0	3311 S MICHIGAN AVE CHICAGO, IL 60616 (41.834371, -87.623323)	02/01/2020
8977	2400 SAMISH WAY BELLINGHAM, WA 98225	48.709579	-122.464023	505140	HIGHLAND HEALTH AND REHABILITATION	2400 SAMISH WAY	BELLINGHAM	WA	98225	3607344800	360	Whatcom	For profit - Limited Liability company	44	40.5	Medicare and Medicaid	false	EMPRES HIGHLAND CARE LLC	05/31/1972	false		true	false	false	Resident	Yes	2	1	3	3	4		4		4				2.08657	0.66463	0.80762	1.47225	3.55883	0.01722	2.03686	0.68135	0.30734	3.02555	2.12906	0.73349	0.98906	3.77185	09/16/2019	29	22	9	176	1	0	176	07/31/2018	28	15	15	297	1	297	2017-05-25	28	25	24	1	618	618	290	18	7	3	169260.00	0	3	2400 SAMISH WAY BELLINGHAM, WA 98225 (48.709579, -122.464023)	02/01/2020
12466	5225 SOUTH J ST OXNARD, CA 93033	34.152845	-119.186144	555163	SHORELINE CARE CENTER	5225 SOUTH J ST	OXNARD	CA	93033	8054883696	660	Ventura	For profit - Corporation	193	169.3	Medicare and Medicaid	false	COVENANT CARE CALIFORNIA, LLC	01/30/1984	false		true	false	false	Resident	Yes	4	2	5	5	4		4		4				2.37045	0.60417	0.68661	1.29078	3.66122	0.03019	2.06459	0.65544	0.27458	2.99461	2.38623	0.69312	0.94117	3.92047	05/09/2019	10	3	7	56	1	0	56	05/09/2018	11	8	3	44	1	44	2017-05-25	6	5	1	1	28	28	47.333	3	8	0	0.00	0	0	5225 SOUTH J ST OXNARD, CA 93033 (34.152845, -119.186144)	02/01/2020
14215	457 N MAIN ST LA GRANGE, TX 78945	29.907875	-96.881058	675277	CARE INN OF LA GRANGE	457 N MAIN ST	LA GRANGE	TX	78945	9799685865	511	Fayette	For profit - Limited Liability company	98	51.8	Medicare and Medicaid	false	OAKBEND MEDICAL CENTER	02/14/1994	false	SFF Candidate	true	false	false	Resident	Yes	1	1	4	3	5		2		2				1.91796	0.9516	0.40208	1.35368	3.27164	0.10568	1.89181	0.8325	0.44374	3.16805	2.10707	0.85952	0.34105	3.31151	08/05/2019	23	22	1	361	2	181	542	06/29/2018	10	10	10	52	1	52	2017-05-25	3	2	1	1	16	16	291	0	1	0	0.00	1	1	457 N MAIN ST LA GRANGE, TX 78945 (29.907875, -96.881058)	02/01/2020
14912	349 VOTECH DRIVE JOHNSTOWN, PA 15904	40.277516	-78.834838	395610	RICHLAND HEALTHCARE AND REHABILITATION CENTER	349 VOTECH DRIVE	JOHNSTOWN	PA	15904	8142669702	160	Cambria	For profit - Corporation	97	85.7	Medicare and Medicaid	false	GUARDIAN ELDER CARE AT JOHNSTOWN LLC	10/03/1983	false		true	false	false	Resident	Yes	2	2	3	3	3		2		3				1.87972	0.70214	0.66627	1.36841	3.24813	0.11316	2.38296	0.86512	0.44712	3.6952	1.63943	0.61028	0.56087	2.8187	05/17/2019	12	9	3	72	1	0	72	04/27/2018	14	9	5	68	1	68	2017-05-25	9	9	0	1	52	52	67.333	1	3	0	0.00	0	0	349 VOTECH DRIVE JOHNSTOWN, PA 15904 (40.277516, -78.834838)	02/01/2020