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	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 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 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	Total Number of Penalties	Location	Processing Date
1248	1904 PALMYRA ROAD ALBANY, GA 31702	31.603176	-84.169078	0		115628	PRUITTHEALTH - PALMYRA	1904 PALMYRA ROAD	ALBANY	GA	31702	2298830500	390	Dougherty	For profit - Corporation	250	214.4	Medicare and Medicaid	false	PRUITTHEALTH - PALMYRA, LLC	01/01/1997	false	SFF Candidate	true	false	false	Resident	Yes	1	1	4	4	3	3	3	2.16304	0.95911	0.50326	1.46237	3.62541	0.03991	2.06315	0.72075	0.3109	3.09481	2.17897	1.00061	0.60926	3.75645	12/06/2018	8	2	6	408	1	0	408	11/16/2017	1	0	1	8	0	0	8	2016-10-27	2	2	0	1	8	8	208	0	4	1	186564.00	1	1904 PALMYRA ROAD ALBANY, GA 31702 (31.603176, -84.169078)	02/01/2020
1250	161 WEST RODEO ROAD CASA GRANDE, AZ 85122	32.92343	-111.753174	0		35276	OASIS PAVILION NURSING & REHABILITATION CENTER	161 WEST RODEO ROAD	CASA GRANDE	AZ	85122	5208361772	100	Pinal	For profit - Limited Liability company	134	135.3	Medicare and Medicaid	false	OASIS PAVILION NURSING AND REHABILITATION CENTER, LLC	10/04/2010	false		true	false	false	Resident	Yes	1	1	4	3	5	2	2	1.68262	0.87719	0.32915	1.20634	2.88896	0.13692	1.89532	0.72463	0.3624	2.98236	1.8451	0.91025	0.34185	3.10625	02/12/2019	11	9	3	72	1	0	72	11/02/2017	5	5	0	32	1	0	32	2016-10-27	12	12	0	1	84	84	60.667	0	3	0	0.00	0	161 WEST RODEO ROAD CASA GRANDE, AZ 85122 (32.92343, -111.753174)	02/01/2020
5209	13550 S Outer Forty Rd, Chesterfield, MO 63017, USA	38.6392324	-90.50228109999999	1	ROOFTOP	265105	DELMAR GARDENS WEST	13550 SOUTH OUTER 40 ROAD	TOWN AND COUNTRY	MO	63017	3148781330	940	St. Louis	For profit - Corporation	321	241.2	Medicare and Medicaid	false	DELMAR GARDENS WEST OPERATING, LLC	02/01/1972	false		true	false	false	Resident	Yes	2	2	4	2	5	2	2	2.27808	0.5966	0.32004	0.91664	3.19472	0.04962	1.85344	0.64793	0.28823	2.7896	2.5545	0.69237	0.41792	3.67235	12/05/2018	8	7	1	68	1	0	68	01/19/2018	8	7	4	88	1	0	88	2016-10-27	7	6	1	1	48	48	71.333	2	11	3	46449.00	3		02/01/2020
5789	435 STONEVILLE RD ISHPEMING, MI 49849	46.479186	-87.718492	0		235349	THE LIGHTHOUSE AT ISHPEMING HEALTH AND REHAB	435 STONEVILLE RD	ISHPEMING	MI	49849	9064851073	510	Marquette	For profit - Limited Liability company	122	61.1	Medicare and Medicaid	false	MATHER HEALTHCARE LLC	02/16/1978	false	SFF Candidate	true	false	false	Resident	Yes	1	1	1	1	2	3	3	1.92965	1.07199	0.57642	1.64842	3.57807	0.02504	2.02736	0.6911	0.32551	3.04397	1.97817	1.16637	0.66651	3.7693	02/07/2019	25	13	13	333	2	167	500	11/03/2017	47	16	36	368	2	184	552	2016-10-27	37	14	23	1	303	303	484.5	18	71	2	21640.00	2	435 STONEVILLE RD ISHPEMING, MI 49849 (46.479186, -87.718492)	02/01/2020
8131	615 WEST WEBB STREET CARMI, IL 62821	38.08342	-88.165741	0		146124	CARMI MANOR REHAB & NRSG CTR	615 WEST WEBB STREET, PO BOX 133	CARMI	IL	62821	6183827270	987	White	For profit - Partnership	74	55.9	Medicare and Medicaid	false	CARMI MANOR REHABILITATION AND NURSING CENTER LLC	07/14/2008	false		true	false	false	None	Yes	2	1	5	5	3	4	4	3.12903	1.06521	1.26527	2.33048	5.45951	0.05596	2.11137	0.88442	0.50733	3.50312	3.08007	0.90565	0.93869	4.99748	01/10/2019	23	13	10	277	1	0	277	12/20/2017	5	5	0	36	1	0	36	2016-10-27	5	4	1	1	28	28	155.167	0	6	0	0.00	0	615 WEST WEBB STREET CARMI, IL 62821 (38.08342, -88.165741)	02/01/2020
14331	3600 BUTZ RD MAUMEE, OH 43537	41.575424	-83.717969	0		366041	ADDISON HEIGHTS HEALTH AND REHABILITATION CENTER	3600 BUTZ RD	MAUMEE	OH	43537	4198677926	490	Lucas	For profit - Partnership	90	64.5	Medicare and Medicaid	false	ADDISON HEIGHTS HEALTH AND REHABILITATION CENTER LLC	01/02/1996	false		true	false	false	Resident	Yes	1	1	1	2	1	2	2	1.59942	0.74917	0.44721	1.19638	2.7958	0.04962	1.98471	0.77178	0.39521	3.1517	1.67487	0.72991	0.4259	2.84456	02/07/2019	28	20	8	136	1	0	136	01/18/2018	26	18	12	136	1	0	136	2016-10-27	11	0	11	0	100	100	130	0	18	1	10000.00	1	3600 BUTZ RD MAUMEE, OH 43537 (41.575424, -83.717969)	02/01/2020