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
4 rows
where Number of Payment Denials = 4
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, nmbr_beds, Continuing Care Retirement Community, Special Focus Status, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, 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, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit Score, Number of Fines, Total Number of Penalties, Rating Cycle 3 Standard Health Survey Date (date)
Number of Payment Denials
✖
Link
|
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
|
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 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 |
1409 |
7501 KEYSTONE DRIVE OMAHA, NE 68134 |
41.299589 |
-96.027754 |
0 |
|
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 |
SFF |
false |
false |
false |
Resident |
Yes |
|
|
|
|
|
|
|
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 |
0 |
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 |
3363 |
911 S 3RD ST NILES, MI 49120 |
41.819191 |
-86.251737 |
0 |
|
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 |
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 |
0 |
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 |
6828 |
5211 W 103RD STREET OVERLAND PARK, KS 66207 |
38.942109 |
-94.645372 |
0 |
|
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 |
SFF |
false |
false |
false |
Resident |
Yes |
|
|
|
|
|
|
|
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 |
0 |
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 |
7651 |
1800 INDIAN HILLS DRIVE SIOUX CITY, IA 51104 |
42.533789 |
-96.388623 |
0 |
|
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 |
SFF |
false |
false |
true |
Both |
Yes |
|
|
|
|
|
|
|
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 |
0 |
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 |
CREATE TABLE [nh_gen_info_geocoded_final] (
[address] TEXT,
[lat] TEXT,
[lng] TEXT,
[geocode_flag] INTEGER,
[geocode_accuracy] TEXT,
[prvdr_nmbr] INTEGER,
[prvdr_nm] TEXT,
[prvdr_add] TEXT,
[prvdr_city] TEXT,
[prvdr_state] TEXT,
[prvdr_zip] INTEGER,
[prvdr_phn] INTEGER,
[prvdr_cnty] INTEGER,
[prvdr_cnty_name] TEXT,
[ownership] TEXT,
[nmbr_beds] INTEGER,
[avg_residents] TEXT,
[prvdr_type] TEXT,
[Provider Resides in Hospital] TEXT,
[Legal Business Name] TEXT,
[Date First Approved to Provide Medicare and Medicaid services] TEXT,
[Continuing Care Retirement Community] TEXT,
[Special Focus Status] TEXT,
[Abuse Icon] TEXT,
[Most Recent Health Inspection More Than 2 Years Ago] TEXT,
[Provider Changed Ownership in Last 12 Months] TEXT,
[With a Resident and Family Council] TEXT,
[Automatic Sprinkler Systems in All Required Areas] TEXT,
[Overall Rating] INTEGER,
[Overall Rating Footnote] TEXT,
[Health Inspection Rating] INTEGER,
[Health Inspection Rating Footnote] TEXT,
[QM Rating] INTEGER,
[QM Rating Footnote] TEXT,
[Long-Stay QM Rating] TEXT,
[Long-Stay QM Rating Footnote] TEXT,
[Short-Stay QM Rating] TEXT,
[Short-Stay QM Rating Footnote] TEXT,
[Staffing Rating] TEXT,
[Staffing Rating Footnote] TEXT,
[RN Staffing Rating] TEXT,
[RN Staffing Rating Footnote] TEXT,
[Reported Staffing Footnote] TEXT,
[Physical Therapist Staffing Footnote] TEXT,
[Reported Nurse Aide Staffing Hours per Resident per Day] TEXT,
[Reported LPN Staffing Hours per Resident per Day] TEXT,
[Reported RN Staffing Hours per Resident per Day] TEXT,
[Reported Licensed Staffing Hours per Resident per Day] TEXT,
[Reported Total Nurse Staffing Hours per Resident per Day] TEXT,
[Reported Physical Therapist Staffing Hours per Resident Per Day] TEXT,
[Case-Mix Nurse Aide Staffing Hours per Resident per Day] TEXT,
[Case-Mix LPN Staffing Hours per Resident per Day] TEXT,
[Case-Mix RN Staffing Hours per Resident per Day] TEXT,
[Case-Mix Total Nurse Staffing Hours per Resident per Day] TEXT,
[Adjusted Nurse Aide Staffing Hours per Resident per Day] TEXT,
[Adjusted LPN Staffing Hours per Resident per Day] TEXT,
[Adjusted RN Staffing Hours per Resident per Day] TEXT,
[Adjusted Total Nurse Staffing Hours per Resident per Day] TEXT,
[Rating Cycle 1 Standard Survey Health Date] TEXT,
[Rating Cycle 1 Total Number of Health Deficiencies] INTEGER,
[Rating Cycle 1 Number of Standard Health Deficiencies] INTEGER,
[Rating Cycle 1 Number of Complaint Health Deficiencies] INTEGER,
[Rating Cycle 1 Health Deficiency Score] INTEGER,
[Rating Cycle 1 Number of Health Revisits] INTEGER,
[Rating Cycle 1 Health Revisit Score] INTEGER,
[Rating Cycle 1 Total Health Score] INTEGER,
[Rating Cycle 2 Standard Health Survey Date] TEXT,
[Rating Cycle 2 Total Number of Health Deficiencies] INTEGER,
[Rating Cycle 2 Number of Standard Health Deficiencies] INTEGER,
[Rating Cycle 2 Number of Complaint Health Deficiencies] INTEGER,
[Rating Cycle 2 Health Deficiency Score] INTEGER,
[Rating Cycle 2 Number of Health Revisits] INTEGER,
[Rating Cycle 2 Health Revisit Score] INTEGER,
[Rating Cycle 2 Total Health Score] INTEGER,
[Rating Cycle 3 Standard Health Survey Date] TEXT,
[Rating Cycle 3 Total Number of Health Deficiencies] INTEGER,
[Rating Cycle 3 Number of Standard Health Deficiencies] INTEGER,
[Rating Cycle 3 Number of Complaint Health Deficiencies] INTEGER,
[Rating Cycle 3 Number of Health Revisits] INTEGER,
[Rating Cycle 3 Health Deficiency Score] INTEGER,
[Rating Cycle 3 Health Revisit Score] INTEGER,
[Rating Cycle 3 Total Health Score] INTEGER,
[Total Weighted Health Survey Score] TEXT,
[Number of Facility Reported Incidents] INTEGER,
[Number of Substantiated Complaints] INTEGER,
[Number of Fines] INTEGER,
[Total Amount of Fines in Dollars] TEXT,
[Number of Payment Denials] INTEGER,
[Total Number of Penalties] INTEGER,
[Location] TEXT,
[Processing Date] TEXT
);