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 4 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 "Number of Payment Denials" = :p0 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	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 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 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
1409	7501 KEYSTONE DRIVE OMAHA, NE 68134	41.299589	-96.027754	285238	KEYSTONE RIDGE POST ACUTE NURSING AND REHAB	7501 KEYSTONE DRIVE	OMAHA	NE	68134	4025725750	270	Douglas	For profit - Individual	100	40.1	Medicare and Medicaid	false	GOOD HOPE HEALTHCARE INC	05/08/2000	true	SFF	false	false	false	Resident	Yes		18		18		18		18		18		18		18	2.78176	0.94858	0.83189	1.78047	4.56223	0.07308	1.91189	0.73248	0.35427	2.99864	3.02395	0.97377	0.88382	4.87872	04/22/2019	23	22	12	452	2	226	678	01/02/2018	47	26	35	489	1	489	2016-09-06	21	13	8	2	144	72	216	538	9	44	4	272276.00	4	8	7501 KEYSTONE DRIVE OMAHA, NE 68134 (41.299589, -96.027754)	02/01/2020
3363	911 S 3RD ST NILES, MI 49120	41.819191	-86.251737	235361	CHALET OF NILES, LLC	911 S 3RD ST	NILES	MI	49120	2696844320	100	Berrien	For profit - Individual	100	54.6	Medicare and Medicaid	false	CHALET OF NILES LLC	07/01/1978	false		false	false	false	Resident	Yes	2		2		4		5		3		2		2		1.49935	0.84183	0.33979	1.18161	2.68097	0.02973	2.03126	0.70772	0.32533	3.06431	1.5341	0.89443	0.39311	2.80551	02/21/2019	17	10	7	88	2	44	132	09/13/2018	15	9	6	80	1	80	2018-03-30	28	19	15	1	342	0	342	149.667	17	35	2	406151.00	4	6	911 S 3RD ST NILES, MI 49120 (41.819191, -86.251737)	02/01/2020
6828	5211 W 103RD STREET OVERLAND PARK, KS 66207	38.942109	-94.645372	175180	OVERLAND PARK REHABILITATION AND HEALTHCARE	5211 W 103RD STREET	OVERLAND PARK	KS	66207	9133832569	450	Johnson	For profit - Partnership	165	82.3	Medicare and Medicaid	false	LEISURE OPERATIONS LLC	02/12/1989	false	SFF	false	false	false	Resident	Yes		18		18		18		18		18		18		18	2.73957	1.83296	1.10081	2.93377	5.67334	0.13951	2.06924	0.77908	0.40302	3.25133	2.75162	1.76911	1.02807	5.59539	07/11/2019	30	29	30	192	1	0	192	07/05/2018	64	13	64	1272	1	1272	2016-08-30	41	28	13	2	703	352	1055	695.833	14	81	4	210137.00	4	8	5211 W 103RD STREET OVERLAND PARK, KS 66207 (38.942109, -94.645372)	02/01/2020
7651	1800 INDIAN HILLS DRIVE SIOUX CITY, IA 51104	42.533789	-96.388623	165161	TOUCHSTONE HEALTHCARE COMMUNITY	1800 INDIAN HILLS DRIVE	SIOUX CITY	IA	51104	7122394582	960	Woodbury	For profit - Corporation	125	69.7	Medicare and Medicaid	false	INDIAN HILLS HEALTH CARE OF SIOUX CITY LLC	07/01/1991	false	SFF	false	false	true	Both	Yes		18		18		18		18		18		18		18	1.86563	0.79857	0.48145	1.28001	3.14565	0.04084	2.06149	0.7361	0.36409	3.16168	1.88088	0.81575	0.49771	3.1904	09/19/2019	27	21	6	140	1	0	140	03/21/2019	19	13	8	132	1	132	2018-09-26	51	31	41	1	670	0	670	225.667	7	49	4	138811.00	4	8	1800 INDIAN HILLS DRIVE SIOUX CITY, IA 51104 (42.533789, -96.388623)	02/01/2020