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
3 rows
where Number of Fines = 6
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, Special Focus Status, Abuse Icon, 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 Footnote, Staffing Rating Footnote, RN Staffing Rating Footnote, Rating Cycle 3 Number of Standard Health Deficiencies, 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
|
726 |
726 |
555 WEST CARPENTER SPRINGFIELD, IL 62702 |
39.807588 |
-89.662793 |
0 |
|
145160 |
APERION CARE CAPITOL |
555 WEST CARPENTER |
SPRINGFIELD |
IL |
62702 |
2175251880 |
920 |
Sangamon |
For profit - Corporation |
251 |
92.6 |
Medicare and Medicaid |
false |
APERION CARE CAPITOL LLC |
05/23/1969 |
SFF |
false |
false |
false |
Resident |
Yes |
|
|
|
|
|
|
|
1.68655 |
0.86113 |
0.19506 |
1.05618 |
2.74274 |
0.0384 |
1.98797 |
0.83678 |
0.44386 |
3.26862 |
1.76321 |
0.77382 |
0.1654 |
2.69075 |
08/30/2019 |
39 |
18 |
33 |
248 |
1 |
0 |
248 |
04/12/2019 |
45 |
14 |
45 |
432 |
1 |
0 |
432 |
2018-07-16 |
16 |
12 |
4 |
1 |
96 |
0 |
96 |
284 |
2 |
48 |
6 |
229677.00 |
0 |
6 |
555 WEST CARPENTER SPRINGFIELD, IL 62702 (39.807588, -89.662793) |
02/01/2020 |
14174 |
14174 |
2430 NORTH 13TH STREET SHELTON, WA 98584 |
47.22765 |
-123.112641 |
0 |
|
505230 |
FIR LANE HEALTH AND REHAB CTR |
2430 NORTH 13TH STREET |
SHELTON |
WA |
98584 |
3604261651 |
220 |
Mason |
For profit - Corporation |
135 |
93.3 |
Medicare and Medicaid |
false |
FIR LANE HEALTH - SHELTON, LLC |
01/01/1980 |
|
true |
false |
false |
Resident |
Yes |
1 |
1 |
3 |
3 |
4 |
2 |
2 |
1.84589 |
0.95528 |
0.43455 |
1.38984 |
3.23572 |
0.05793 |
2.0367 |
0.68324 |
0.32872 |
3.04866 |
1.88363 |
1.05133 |
0.49756 |
3.40341 |
02/28/2019 |
26 |
21 |
5 |
220 |
1 |
0 |
220 |
04/11/2018 |
22 |
18 |
4 |
132 |
1 |
0 |
132 |
2017-03-31 |
25 |
12 |
13 |
1 |
531 |
0 |
531 |
242.5 |
8 |
18 |
6 |
239353.00 |
0 |
6 |
2430 NORTH 13TH STREET SHELTON, WA 98584 (47.22765, -123.112641) |
02/01/2020 |
15348 |
15348 |
1000 EAST ELEP STREET COLVILLE, WA 99114 |
48.539714 |
-117.892449 |
0 |
|
505275 |
PRESTIGE CARE & REHABILITATION - PINEWOOD TERRACE |
1000 EAST ELEP STREET |
COLVILLE |
WA |
99114 |
5096842573 |
320 |
Stevens |
For profit - Corporation |
92 |
71.2 |
Medicare and Medicaid |
false |
CARE CENTER COLVILLE INC. |
09/01/1983 |
|
true |
false |
false |
Resident |
Yes |
2 |
1 |
3 |
3 |
3 |
5 |
5 |
2.60504 |
0.46008 |
0.86041 |
1.32049 |
3.92553 |
0.0321 |
2.01986 |
0.64269 |
0.29967 |
2.96222 |
2.68045 |
0.53829 |
1.08069 |
4.24947 |
07/19/2019 |
31 |
20 |
16 |
188 |
1 |
0 |
188 |
06/26/2018 |
26 |
13 |
13 |
322 |
1 |
0 |
322 |
2017-05-15 |
17 |
11 |
17 |
1 |
116 |
0 |
116 |
220.667 |
21 |
11 |
6 |
75105.00 |
0 |
6 |
1000 EAST ELEP STREET COLVILLE, WA 99114 (48.539714, -117.892449) |
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
);