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 Overall Rating = 3 and Rating Cycle 2 Number of Standard Health Deficiencies = 22
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit Score, Rating Cycle 3 Total Health Score, 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
|
2412 |
2412 |
1684 VULCAN ST MUSKEGON, MI 49442 |
43.221072 |
-86.215696 |
0 |
|
235116 |
LAKE WOODS NURSING & REHABILITATION CENTER |
1684 VULCAN ST |
MUSKEGON |
MI |
49442 |
2317772511 |
600 |
Muskegon |
For profit - Corporation |
90 |
83.8 |
Medicare and Medicaid |
false |
DEBOER, INC. |
10/01/2002 |
|
false |
false |
false |
Resident |
Yes |
3 |
2 |
4 |
5 |
3 |
4 |
4 |
2.37515 |
0.32331 |
0.68787 |
1.01118 |
3.38633 |
0.02524 |
1.96169 |
0.64339 |
0.28572 |
2.8908 |
2.51638 |
0.37786 |
0.90614 |
3.75633 |
03/22/2019 |
16 |
16 |
3 |
116 |
1 |
0 |
116 |
12/05/2017 |
26 |
22 |
4 |
160 |
1 |
0 |
160 |
2016-10-19 |
10 |
10 |
0 |
2 |
64 |
32 |
96 |
127.333 |
6 |
0 |
3 |
67064.00 |
0 |
3 |
1684 VULCAN ST MUSKEGON, MI 49442 (43.221072, -86.215696) |
02/01/2020 |
7693 |
7693 |
4075 54TH ST SAN DIEGO, CA 92105 |
32.750177 |
-117.079367 |
0 |
|
55508 |
JACOB HEALTH CARE CENTER, LLC |
4075 54TH ST. |
SAN DIEGO |
CA |
92105 |
6195825168 |
470 |
San Diego |
For profit - Partnership |
128 |
122.4 |
Medicare and Medicaid |
false |
JACOB HEALTH CARE CENTER LP |
01/01/1967 |
|
false |
false |
false |
Resident |
Yes |
3 |
2 |
5 |
5 |
5 |
3 |
3 |
2.44296 |
1.3928 |
1.15449 |
2.54729 |
4.99024 |
0.1572 |
2.2312 |
0.90429 |
0.75157 |
3.88705 |
2.27558 |
1.15815 |
0.57817 |
4.11675 |
09/19/2019 |
13 |
5 |
8 |
60 |
1 |
0 |
60 |
09/17/2018 |
22 |
22 |
1 |
104 |
1 |
0 |
104 |
2017-07-31 |
20 |
18 |
2 |
1 |
96 |
0 |
96 |
80.667 |
8 |
6 |
0 |
0.00 |
0 |
0 |
4075 54TH ST SAN DIEGO, CA 92105 (32.750177, -117.079367) |
02/01/2020 |
14003 |
14003 |
1508 WEST SEVENTH AVENUE KENNEWICK, WA 99336 |
46.202192 |
-119.139428 |
0 |
|
505080 |
LIFE CARE CENTER OF KENNEWICK |
1508 WEST SEVENTH AVENUE |
KENNEWICK |
WA |
99336 |
5095869185 |
20 |
Benton |
For profit - Corporation |
136 |
55.9 |
Medicare and Medicaid |
false |
KENNEWICK MEDICAL INVESTORS, LLC |
06/01/1974 |
|
false |
false |
false |
Resident |
Yes |
3 |
2 |
2 |
2 |
3 |
4 |
5 |
2.50366 |
0.66047 |
1.11001 |
1.77048 |
4.27414 |
0.08399 |
2.32054 |
0.77612 |
0.38046 |
3.47712 |
2.24235 |
0.63989 |
1.09812 |
3.94169 |
03/05/2019 |
25 |
11 |
14 |
164 |
1 |
0 |
164 |
04/12/2018 |
29 |
22 |
11 |
263 |
1 |
0 |
263 |
2017-01-13 |
22 |
15 |
7 |
1 |
176 |
0 |
176 |
199 |
9 |
19 |
2 |
75267.00 |
0 |
2 |
1508 WEST SEVENTH AVENUE KENNEWICK, WA 99336 (46.202192, -119.139428) |
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
);