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 Most Recent Health Inspection More Than 2 Years Ago = "true" and Rating Cycle 2 Health Deficiency Score = 0
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, prvdr_type, Continuing Care Retirement Community, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing Footnote, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Total Health Score, Number of Substantiated Complaints, 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
|
68 |
68 |
1170 LINKHAW ROAD LUMBERTON, NC 28358 |
34.644218 |
-78.989713 |
0 |
|
345315 |
HIGHLAND ACRES NURSING AND REHABILITATION CENTER |
1170 LINKHAW ROAD |
LUMBERTON |
NC |
28358 |
9106711163 |
770 |
Robeson |
For profit - Corporation |
90 |
|
Medicare and Medicaid |
false |
MAPLE LTC GROUP, LLC |
04/05/1990 |
|
false |
true |
false |
Both |
Yes |
3 |
4 |
1 |
2 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
01/25/2018 |
5 |
5 |
1 |
32 |
1 |
0 |
32 |
01/27/2017 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2016-03-11 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
16 |
0 |
1 |
0 |
0.00 |
0 |
0 |
1170 LINKHAW ROAD LUMBERTON, NC 28358 (34.644218, -78.989713) |
02/01/2020 |
7603 |
7603 |
50 MANSION DRIVE ROWLEY, MA 01969 |
42.73727 |
-70.88174 |
0 |
|
225688 |
SEA VIEW CONVALESCENT AND NURSING HOME |
50 MANSION DRIVE |
ROWLEY |
MA |
1969 |
9789482552 |
40 |
Essex |
For profit - Corporation |
62 |
46.7 |
Medicare and Medicaid |
false |
SEAVIEW RETREAT INC |
09/01/1995 |
|
false |
true |
false |
Resident |
Yes |
5 |
5 |
3 |
5 |
1 |
3 |
3 |
2.13471 |
0.7294 |
0.48407 |
1.21347 |
3.34817 |
0.15994 |
2.28753 |
0.69908 |
0.33512 |
3.32174 |
1.93949 |
0.78455 |
0.54367 |
3.23218 |
08/10/2017 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
07/01/2016 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2015-07-29 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0.00 |
0 |
0 |
50 MANSION DRIVE ROWLEY, MA 01969 (42.73727, -70.88174) |
02/01/2020 |
13805 |
13805 |
245 NORTH STREET BRISTOL, VA 24201 |
36.596025 |
-82.217858 |
0 |
|
495131 |
NHC HEALTHCARE,BRISTOL |
245 NORTH STREET |
BRISTOL |
VA |
24201 |
2766694711 |
111 |
Bristol City |
For profit - Corporation |
120 |
106.5 |
Medicare and Medicaid |
false |
NHC HEALTHCARE-BRISTOL LLC |
09/29/1982 |
|
false |
true |
false |
Resident |
Yes |
5 |
5 |
4 |
5 |
4 |
3 |
3 |
2.18228 |
1.27099 |
0.49268 |
1.76367 |
3.94595 |
0.11147 |
2.13726 |
0.73747 |
0.34626 |
3.22099 |
2.12211 |
1.29594 |
0.53554 |
3.92839 |
05/18/2017 |
3 |
3 |
0 |
12 |
1 |
0 |
12 |
05/25/2016 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2015-06-25 |
3 |
3 |
0 |
1 |
24 |
0 |
24 |
10 |
0 |
0 |
0 |
0.00 |
0 |
0 |
245 NORTH STREET BRISTOL, VA 24201 (36.596025, -82.217858) |
02/01/2020 |
14244 |
14244 |
100 ANNA GOODE WAY SUFFOLK, VA 23434 |
36.787041 |
-76.619645 |
0 |
|
495366 |
LAKE PRINCE WOODS, INC |
100 ANNA GOODE WAY |
SUFFOLK |
VA |
23434 |
7579235500 |
892 |
Suffolk City |
Non profit - Corporation |
40 |
26.5 |
Medicare |
false |
LAKE PRINCE CENTER, INC. |
01/14/2003 |
|
false |
true |
false |
Resident |
Yes |
4 |
3 |
3 |
3 |
3 |
4 |
4 |
2.73757 |
1.92288 |
0.98063 |
2.90351 |
5.64108 |
0.28076 |
2.32969 |
0.78142 |
0.39962 |
3.51072 |
2.44221 |
1.85035 |
0.92362 |
5.15251 |
11/16/2017 |
10 |
10 |
0 |
72 |
1 |
0 |
72 |
11/10/2016 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2016-01-28 |
2 |
2 |
0 |
1 |
20 |
0 |
20 |
39.333 |
0 |
0 |
0 |
0.00 |
0 |
0 |
100 ANNA GOODE WAY SUFFOLK, VA 23434 (36.787041, -76.619645) |
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
);