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 Facility Reported Incidents = 27
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Abuse Icon, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Reported Physical Therapist Staffing Hours per Resident Per Day, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 3 Number of Complaint Health Deficiencies, Number of Fines, Total Amount of Fines in Dollars, 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
|
3239 |
3239 |
1523 US-2, Crystal Falls, MI 49920, USA |
46.093956 |
-88.378106 |
1 |
ROOFTOP |
235257 |
IRON CO MEDICAL CARE FACILITY |
1523 U S HIGHWAY 2 |
CRYSTAL FALLS |
MI |
49920 |
9068756671 |
350 |
Iron |
Government - County |
200 |
173.6 |
Medicare and Medicaid |
false |
IRON COUNTY MEDICAL CARE FACILITY |
05/01/1976 |
|
true |
false |
false |
Both |
Yes |
3 |
2 |
3 |
3 |
3 |
5 |
5 |
2.87235 |
0.27144 |
0.95421 |
1.22565 |
4.098 |
0.03409 |
2.04802 |
0.6291 |
0.28781 |
2.96493 |
2.91487 |
0.32444 |
1.24787 |
4.43211 |
11/29/2018 |
17 |
10 |
7 |
108 |
1 |
0 |
108 |
08/11/2017 |
26 |
19 |
7 |
152 |
2 |
76 |
228 |
2016-10-06 |
14 |
8 |
6 |
1 |
64 |
0 |
64 |
140.667 |
27 |
2 |
0 |
0.00 |
0 |
0 |
|
02/01/2020 |
3624 |
3624 |
4545 SHELLEY COURT STOCKTON, CA 95207 |
37.993085 |
-121.303487 |
0 |
|
55201 |
GOLDEN LIVING CENTER - HY-PANA |
4545 SHELLEY COURT |
STOCKTON |
CA |
95207 |
2094770271 |
490 |
San Joaquin |
For profit - Corporation |
119 |
98.1 |
Medicare and Medicaid |
false |
GGNSC STOCKTON LP |
01/01/1967 |
|
false |
false |
false |
Resident |
Yes |
2 |
2 |
4 |
5 |
2 |
3 |
3 |
2.15436 |
0.81425 |
0.42932 |
1.24357 |
3.39793 |
0 |
1.95691 |
0.68574 |
0.30786 |
2.95051 |
2.28803 |
0.89286 |
0.52487 |
3.69292 |
01/25/2019 |
21 |
12 |
9 |
140 |
1 |
0 |
140 |
02/16/2018 |
13 |
7 |
7 |
64 |
1 |
0 |
64 |
2017-03-03 |
20 |
11 |
10 |
1 |
112 |
0 |
112 |
110 |
27 |
9 |
0 |
0.00 |
0 |
0 |
4545 SHELLEY COURT STOCKTON, CA 95207 (37.993085, -121.303487) |
02/01/2020 |
11086 |
11086 |
5520 BRIDGEPORT WAY WEST UNIVERSITY PLACE, WA 98467 |
47.206489 |
-122.534546 |
0 |
|
505473 |
UNIVERSITY PLACE REHABILITATION CENTER |
5520 BRIDGEPORT WAY WEST |
UNIVERSITY PLACE |
WA |
98467 |
2535667166 |
260 |
Pierce |
For profit - Corporation |
120 |
99.1 |
Medicare and Medicaid |
false |
UNIVERSITY PLACE REHABILITATION CENTER LLC |
05/01/1992 |
|
false |
false |
false |
Resident |
Yes |
1 |
1 |
3 |
5 |
2 |
2 |
2 |
2.49099 |
1.00198 |
0.35568 |
1.35766 |
3.84865 |
0 |
2.22512 |
0.78305 |
0.38063 |
3.38881 |
2.32666 |
0.96217 |
0.35171 |
3.64179 |
12/14/2018 |
36 |
8 |
28 |
465 |
1 |
0 |
465 |
12/20/2017 |
14 |
11 |
3 |
201 |
1 |
0 |
201 |
2017-01-12 |
27 |
26 |
1 |
1 |
345 |
0 |
345 |
357 |
27 |
21 |
2 |
137678.00 |
0 |
2 |
5520 BRIDGEPORT WAY WEST UNIVERSITY PLACE, WA 98467 (47.206489, -122.534546) |
02/01/2020 |
15382 |
15382 |
153 JOHNS COURT SHELTON, WA 98584 |
47.233785 |
-123.109373 |
0 |
|
505507 |
SHELTON HEALTH & REHAB CENTER |
153 JOHNS COURT |
SHELTON |
WA |
98584 |
3604272575 |
220 |
Mason |
For profit - Corporation |
76 |
63.4 |
Medicare and Medicaid |
false |
EVERGREEN AT SHELTON, L.L.C. |
02/12/1999 |
|
true |
false |
false |
Resident |
Yes |
2 |
1 |
2 |
1 |
4 |
4 |
4 |
2.15906 |
0.72361 |
0.94307 |
1.66668 |
3.82574 |
0.09301 |
2.11376 |
0.78464 |
0.39686 |
3.29527 |
2.12287 |
0.69346 |
0.89441 |
3.72287 |
05/10/2019 |
54 |
30 |
28 |
432 |
1 |
0 |
432 |
05/23/2018 |
27 |
13 |
14 |
236 |
1 |
0 |
236 |
2017-06-28 |
19 |
14 |
6 |
1 |
160 |
0 |
160 |
321.333 |
27 |
17 |
7 |
126343.00 |
0 |
7 |
153 JOHNS COURT SHELTON, WA 98584 (47.233785, -123.109373) |
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
);