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 Overall Rating = 4 and Rating Cycle 3 Number of Standard Health Deficiencies = 21
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, Continuing Care Retirement Community, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Staffing Rating, RN Staffing Rating, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit 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
|
6977 |
6977 |
1500 BYRON ROAD HOWELL, MI 48855 |
42.624305 |
-83.942604 |
0 |
|
235707 |
THE WILLOWS AT HOWELL |
1500 BYRON ROAD |
HOWELL |
MI |
48855 |
5175529323 |
460 |
Livingston |
For profit - Corporation |
56 |
52.2 |
Medicare and Medicaid |
false |
TRILOGY HEALTHCARE OF LIVINGSTON, LLC |
09/28/2015 |
|
false |
false |
false |
Resident |
Yes |
4 |
3 |
4 |
5 |
3 |
4 |
5 |
1.7545 |
0.62593 |
1.49527 |
2.12121 |
3.8757 |
0.11589 |
2.12487 |
0.74397 |
0.34186 |
3.2107 |
1.71607 |
0.63264 |
1.64628 |
3.87083 |
01/09/2020 |
6 |
6 |
0 |
52 |
0 |
0 |
52 |
02/07/2019 |
11 |
10 |
1 |
68 |
1 |
0 |
68 |
2018-02-22 |
22 |
21 |
7 |
2 |
160 |
80 |
240 |
88.667 |
4 |
1 |
0 |
0.00 |
0 |
0 |
1500 BYRON ROAD HOWELL, MI 48855 (42.624305, -83.942604) |
02/01/2020 |
7749 |
7749 |
1881 E GRAND BLVD DETROIT, MI 48211 |
42.374498 |
-83.03794 |
0 |
|
235454 |
THE BAY AT ELMWOOD HEALTH & REHABILITATION CENTER |
1881 E GRAND BLVD |
DETROIT |
MI |
48211 |
3139221600 |
810 |
Wayne |
For profit - Corporation |
120 |
61.4 |
Medicare and Medicaid |
false |
THE BAY AT ELMWOOD HEALTH AND REHABILITATION CENTER, LLC |
06/13/1986 |
|
false |
false |
false |
Resident |
Yes |
4 |
3 |
5 |
5 |
4 |
3 |
3 |
2.00306 |
0.62748 |
0.38124 |
1.00872 |
3.01178 |
0 |
1.72053 |
0.61398 |
0.26742 |
2.60192 |
2.41962 |
0.76847 |
0.53659 |
3.71177 |
06/20/2019 |
12 |
8 |
11 |
48 |
1 |
0 |
48 |
08/01/2018 |
13 |
13 |
0 |
120 |
1 |
0 |
120 |
2017-06-07 |
22 |
21 |
5 |
1 |
164 |
0 |
164 |
91.333 |
3 |
6 |
0 |
0.00 |
0 |
0 |
1881 E GRAND BLVD DETROIT, MI 48211 (42.374498, -83.03794) |
02/01/2020 |
8123 |
8123 |
1233 WEST LA HABRA BOULEVARD LA HABRA, CA 90631 |
33.931902 |
-117.959717 |
0 |
|
55622 |
LA HABRA CONVALESCENT HOSPITAL |
1233 WEST LA HABRA BOULEVARD |
LA HABRA |
CA |
90631 |
5626910781 |
400 |
Orange |
For profit - Corporation |
86 |
82.6 |
Medicare and Medicaid |
false |
LIFE CARE CENTERS OF AMERICA, INC. |
01/01/1976 |
|
false |
false |
false |
Resident |
Yes |
4 |
4 |
3 |
4 |
2 |
2 |
2 |
2.28779 |
1.0611 |
0.32473 |
1.38583 |
3.67362 |
0.07677 |
2.18759 |
0.6894 |
0.30684 |
3.18383 |
2.17353 |
1.15737 |
0.39832 |
3.69996 |
12/05/2018 |
2 |
0 |
2 |
4 |
1 |
0 |
4 |
12/18/2017 |
16 |
15 |
1 |
72 |
1 |
0 |
72 |
2017-01-20 |
26 |
21 |
5 |
1 |
124 |
0 |
124 |
46.667 |
2 |
5 |
0 |
0.00 |
0 |
0 |
1233 WEST LA HABRA BOULEVARD LA HABRA, CA 90631 (33.931902, -117.959717) |
02/01/2020 |
10776 |
10776 |
1330 KINARD STREET NEWBERRY, SC 29108 |
34.284691 |
-81.605804 |
0 |
|
425035 |
J F HAWKINS NURSING HOME |
1330 KINARD STREET |
NEWBERRY |
SC |
29108 |
8032762601 |
350 |
Newberry |
For profit - Corporation |
118 |
110.4 |
Medicare and Medicaid |
false |
NEWBERRY OPERATOR LLC |
01/01/1967 |
|
false |
false |
false |
Resident |
Yes |
4 |
3 |
5 |
5 |
5 |
3 |
3 |
2.24491 |
0.90144 |
0.54502 |
1.44646 |
3.69137 |
0.04576 |
2.06377 |
0.67173 |
0.32189 |
3.0574 |
2.26075 |
1.00908 |
0.63729 |
3.87159 |
11/25/2019 |
3 |
3 |
0 |
20 |
1 |
0 |
20 |
09/06/2018 |
4 |
4 |
0 |
24 |
1 |
0 |
24 |
2017-05-11 |
21 |
21 |
21 |
1 |
88 |
0 |
88 |
32.667 |
0 |
0 |
0 |
0.00 |
0 |
0 |
1330 KINARD STREET NEWBERRY, SC 29108 (34.284691, -81.605804) |
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
);