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 = 26
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, nmbr_beds, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 3 Number of Standard Health Deficiencies, Number of Fines, Number of Payment Denials, 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
|
5705 |
5705 |
675 24TH AVENUE SANTA CRUZ, CA 95062 |
36.964747 |
-121.979543 |
0 |
|
55109 |
DRIFTWOOD HEALTHCARE CENTER - SANTA CRUZ |
675 24TH AVENUE |
SANTA CRUZ |
CA |
95062 |
8314756323 |
540 |
Santa Cruz |
For profit - Partnership |
92 |
88.6 |
Medicare and Medicaid |
false |
DRIFTWOOD SANTA CRUZ OPERATING COMPANY LP |
06/01/1969 |
|
false |
false |
false |
Resident |
Yes |
2 |
1 |
5 |
5 |
4 |
4 |
4 |
2.53887 |
0.57236 |
0.76899 |
1.34135 |
3.88021 |
0.02184 |
1.82872 |
0.65626 |
0.29721 |
2.78219 |
2.88542 |
0.65581 |
0.97384 |
4.47221 |
12/13/2018 |
15 |
9 |
7 |
68 |
1 |
0 |
68 |
02/08/2018 |
34 |
17 |
18 |
164 |
1 |
0 |
164 |
2017-02-02 |
41 |
18 |
41 |
1 |
192 |
0 |
192 |
120.667 |
26 |
29 |
1 |
13500.00 |
0 |
1 |
675 24TH AVENUE SANTA CRUZ, CA 95062 (36.964747, -121.979543) |
02/01/2020 |
6599 |
6599 |
625 36TH ST SW WYOMING, MI 49509 |
42.898776 |
-85.681566 |
0 |
|
235441 |
SKLD WYOMING |
625 36TH ST SW |
WYOMING |
MI |
49509 |
6165310200 |
400 |
Kent |
For profit - Partnership |
92 |
79.2 |
Medicare and Medicaid |
false |
CRESTVIEW SNF LLC |
10/01/1985 |
|
true |
false |
false |
Resident |
Yes |
1 |
1 |
4 |
3 |
5 |
3 |
4 |
1.98226 |
0.41283 |
0.70006 |
1.1129 |
3.09516 |
0.03309 |
2.06367 |
0.72721 |
0.3394 |
3.13028 |
1.99635 |
0.42687 |
0.77634 |
3.17068 |
03/14/2019 |
26 |
12 |
14 |
244 |
1 |
0 |
244 |
02/14/2018 |
28 |
21 |
7 |
308 |
2 |
154 |
462 |
2017-01-12 |
11 |
4 |
7 |
1 |
80 |
0 |
80 |
289.333 |
26 |
27 |
1 |
74763.00 |
2 |
3 |
625 36TH ST SW WYOMING, MI 49509 (42.898776, -85.681566) |
02/01/2020 |
6772 |
6772 |
2400 PORTAGE ST KALAMAZOO, MI 49001 |
42.266639 |
-85.56998 |
0 |
|
235050 |
HAROLD AND GRACE UPJOHN COMMUNITY CARE CENTER |
2400 PORTAGE ST |
KALAMAZOO |
MI |
49001 |
2693814290 |
380 |
Kalamazoo |
Non profit - Corporation |
90 |
81.6 |
Medicare and Medicaid |
false |
HAROLD AND GRACE UPJOHN COMMUNITY CARE CENTER |
01/01/1967 |
|
true |
false |
false |
Resident |
Yes |
3 |
2 |
4 |
4 |
5 |
5 |
5 |
2.44436 |
0.82994 |
1.14888 |
1.97882 |
4.42318 |
0.10394 |
2.1954 |
0.71993 |
0.36918 |
3.28451 |
2.31402 |
0.86684 |
1.17131 |
4.31835 |
12/19/2019 |
15 |
12 |
3 |
100 |
0 |
0 |
100 |
09/28/2018 |
20 |
6 |
14 |
206 |
1 |
0 |
206 |
2017-08-30 |
18 |
12 |
6 |
1 |
116 |
0 |
116 |
138 |
26 |
35 |
1 |
75036.00 |
0 |
1 |
2400 PORTAGE ST KALAMAZOO, MI 49001 (42.266639, -85.56998) |
02/01/2020 |
7471 |
7471 |
1037 W VERNON AVENUE LOS ANGELES, CA 90037 |
34.003672 |
-118.292993 |
0 |
|
55167 |
VERNON HEALTHCARE CENTER |
1037 W. VERNON AVENUE |
LOS ANGELES |
CA |
90037 |
3232324895 |
200 |
Los Angeles |
For profit - Individual |
99 |
89.9 |
Medicare and Medicaid |
false |
VERNON HEALTHCARE CENTER, LLC |
01/01/1967 |
SFF Candidate |
false |
false |
false |
Resident |
Yes |
1 |
1 |
2 |
3 |
1 |
3 |
2 |
2.60074 |
1.15065 |
0.41298 |
1.56363 |
4.16437 |
0.16088 |
2.06206 |
0.7252 |
0.36721 |
3.15447 |
2.62127 |
1.19307 |
0.4233 |
4.23327 |
09/15/2019 |
25 |
15 |
10 |
237 |
1 |
0 |
237 |
09/22/2018 |
14 |
10 |
4 |
96 |
1 |
0 |
96 |
2017-11-02 |
34 |
18 |
17 |
1 |
679 |
0 |
679 |
263.667 |
26 |
34 |
0 |
0.00 |
1 |
1 |
1037 W VERNON AVENUE LOS ANGELES, CA 90037 (34.003672, -118.292993) |
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
);