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 Rating Cycle 3 Number of Health Revisits = 4
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, Overall Rating, Health Inspection Rating, Staffing Rating, Number of Facility Reported Incidents, Number of Fines, Number of Payment Denials
Rating Cycle 3 Number of Health Revisits
✖
Automatic Sprinkler Systems in All Required Areas
✖
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
|
1378 |
1378 |
1560 KS-96, Great Bend, KS 67530, USA |
38.3680403 |
-98.80305639999999 |
1 |
ROOFTOP |
175291 |
GREAT BEND HEALTH & REHAB CENTER |
1560 K 96 HWY |
GREAT BEND |
KS |
67530 |
6207922448 |
40 |
Barton |
For profit - Corporation |
45 |
41.7 |
Medicare and Medicaid |
false |
GREAT BEND-LTC, LLC |
04/01/1994 |
|
false |
false |
false |
Resident |
Yes |
1 |
1 |
1 |
1 |
|
3 |
3 |
2.03314 |
0.53626 |
0.58816 |
1.12442 |
3.15756 |
0.04077 |
1.935 |
0.72901 |
0.32309 |
2.9871 |
2.18374 |
0.55313 |
0.68517 |
3.38965 |
05/08/2019 |
4 |
4 |
0 |
20 |
1 |
0 |
20 |
05/02/2018 |
22 |
21 |
3 |
168 |
1 |
0 |
168 |
2016-09-09 |
27 |
23 |
4 |
4 |
378 |
321 |
699 |
182.5 |
2 |
3 |
0 |
0.00 |
0 |
0 |
|
02/01/2020 |
4980 |
4980 |
5154 SUNSET BLVD LOS ANGELES, CA 90027 |
34.098112 |
-118.302413 |
0 |
|
56056 |
BRIER OAK ON SUNSET |
5154 SUNSET BLVD |
LOS ANGELES |
CA |
90027 |
3236633951 |
200 |
Los Angeles |
For profit - Corporation |
159 |
103.3 |
Medicare and Medicaid |
false |
BRIER OAK ON SUNSET LLC |
01/01/1979 |
|
false |
false |
false |
Resident |
Yes |
1 |
1 |
3 |
4 |
3 |
3 |
3 |
2.06975 |
1.12818 |
0.68309 |
1.81127 |
3.88102 |
0.07042 |
1.93346 |
0.74558 |
0.37333 |
3.05237 |
2.22484 |
1.13781 |
0.68868 |
4.0772 |
09/10/2019 |
12 |
6 |
6 |
64 |
1 |
0 |
64 |
09/27/2018 |
13 |
11 |
2 |
72 |
1 |
0 |
72 |
2017-02-28 |
39 |
33 |
6 |
4 |
264 |
224 |
488 |
137.333 |
0 |
20 |
1 |
79268.00 |
1 |
2 |
5154 SUNSET BLVD LOS ANGELES, CA 90027 (34.098112, -118.302413) |
02/01/2020 |
12689 |
12689 |
287 EAST SOUTH BOULEVARD PETERSBURG, VA 23805 |
37.206 |
-77.381479 |
0 |
|
495144 |
PETERSBURG HEALTHCARE CENTER |
287 EAST SOUTH BOULEVARD |
PETERSBURG |
VA |
23805 |
8047331190 |
701 |
Petersburg City |
For profit - Corporation |
120 |
112.9 |
Medicare and Medicaid |
false |
SOUTH LEASING VA CO LLC |
09/01/1984 |
|
false |
false |
false |
Resident |
Yes |
2 |
2 |
4 |
2 |
5 |
2 |
2 |
1.9279 |
0.8657 |
0.42754 |
1.29324 |
3.22114 |
0.02419 |
2.17982 |
0.81289 |
0.39704 |
3.38975 |
1.83814 |
0.80079 |
0.4053 |
3.04716 |
11/29/2018 |
17 |
13 |
4 |
76 |
1 |
0 |
76 |
09/21/2017 |
17 |
17 |
6 |
116 |
1 |
0 |
116 |
2016-09-01 |
13 |
13 |
0 |
4 |
72 |
61 |
133 |
98.833 |
0 |
9 |
1 |
54418.00 |
0 |
1 |
287 EAST SOUTH BOULEVARD PETERSBURG, VA 23805 (37.206, -77.381479) |
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
);