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 = 3 and Reported Staffing Footnote = 6
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, With a Resident and Family Council, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, 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)
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
|
4330 |
4330 |
1435 TOLEDO STREET SIDNEY, NE 69162 |
41.134408 |
-102.981771 |
0 |
|
285113 |
SIDNEY CARE AND REHABILITATION CENTER, LLC |
1435 TOLEDO STREET |
SIDNEY |
NE |
69162 |
3082544756 |
160 |
Cheyenne |
For profit - Corporation |
41 |
|
Medicare and Medicaid |
false |
Legal Business Name Not Available |
12/01/1991 |
SFF Candidate |
false |
false |
false |
Both |
Yes |
1 |
1 |
3 |
3 |
|
1 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
03/06/2018 |
34 |
34 |
8 |
444 |
1 |
0 |
444 |
04/19/2017 |
20 |
14 |
9 |
156 |
1 |
0 |
156 |
2016-05-11 |
30 |
22 |
8 |
1 |
216 |
0 |
216 |
310 |
5 |
22 |
0 |
0.00 |
3 |
3 |
1435 TOLEDO STREET SIDNEY, NE 69162 (41.134408, -102.981771) |
02/01/2020 |
7095 |
7095 |
365 ALPHA STREET CAMDEN, AR 71701 |
33.585439 |
-92.885101 |
0 |
|
45348 |
LONGMEADOW NURSING CENTER - CAMDEN |
365 ALPHA STREET |
CAMDEN |
AR |
71701 |
8708369337 |
510 |
Ouachita |
For profit - Limited Liability company |
69 |
19.7 |
Medicare and Medicaid |
false |
JACQUELINE KILGORE LLC |
12/30/1998 |
|
false |
false |
false |
Resident |
Yes |
1 |
1 |
1 |
1 |
|
1 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11/15/2019 |
17 |
12 |
5 |
288 |
1 |
0 |
288 |
10/19/2018 |
9 |
8 |
1 |
44 |
1 |
0 |
44 |
2017-09-29 |
13 |
6 |
9 |
1 |
504 |
0 |
504 |
242.667 |
2 |
9 |
1 |
263208.00 |
3 |
4 |
365 ALPHA STREET CAMDEN, AR 71701 (33.585439, -92.885101) |
02/01/2020 |
8510 |
8510 |
34330 VAN BORN RD WAYNE, MI 48184 |
42.266803 |
-83.377061 |
0 |
|
235559 |
PINE CREEK MANOR SKILLED NURSING & REHAB CENTER |
34330 VAN BORN RD |
WAYNE |
MI |
48184 |
7347210740 |
810 |
Wayne |
For profit - Individual |
49 |
38.6 |
Medicare and Medicaid |
false |
PINE CREEK MANOR SKILLED NURSING & REHAB CENTER LLC |
08/24/1994 |
|
true |
false |
false |
Resident |
Yes |
1 |
1 |
1 |
2 |
1 |
1 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11/28/2018 |
22 |
18 |
6 |
156 |
2 |
78 |
234 |
10/10/2017 |
25 |
17 |
10 |
192 |
1 |
0 |
192 |
2016-10-05 |
16 |
13 |
3 |
1 |
116 |
0 |
116 |
200.333 |
8 |
20 |
2 |
38786.00 |
3 |
5 |
34330 VAN BORN RD WAYNE, MI 48184 (42.266803, -83.377061) |
02/01/2020 |
13822 |
13822 |
1530 NORTHEAST GRAND BLVD OKLAHOMA CITY, OK 73117 |
35.485339 |
-97.46493 |
0 |
|
375339 |
EDWARDS REDEEMER HEALTH & REHAB |
1530 NORTHEAST GRAND BLVD |
OKLAHOMA CITY |
OK |
73117 |
4054242273 |
540 |
Oklahoma |
For profit - Corporation |
106 |
48.6 |
Medicare and Medicaid |
false |
EDWARDS REDEEMER HEALTHCARE & REHAB |
05/01/1998 |
SFF Candidate |
false |
false |
false |
Resident |
Yes |
1 |
1 |
2 |
3 |
2 |
1 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
05/14/2019 |
1 |
0 |
1 |
8 |
2 |
4 |
12 |
04/18/2018 |
30 |
27 |
3 |
292 |
2 |
146 |
438 |
2016-11-23 |
34 |
28 |
6 |
2 |
461 |
231 |
692 |
267.333 |
0 |
8 |
2 |
48578.00 |
3 |
5 |
1530 NORTHEAST GRAND BLVD OKLAHOMA CITY, OK 73117 (35.485339, -97.46493) |
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
);