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 Automatic Sprinkler Systems in All Required Areas = "Partial" and Staffing Rating = 4
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Continuing Care Retirement Community, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM 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 Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, 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 Total Health Score, 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, Number of Facility Reported Incidents, 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
|
4083 |
4083 |
1051 BRIGHTSEAT ROAD LANDOVER, MD 20785 |
38.905084 |
-76.853481 |
0 |
|
215364 |
FUTURE CARE CAPITAL REGION |
1051 BRIGHTSEAT ROAD |
LANDOVER |
MD |
20785 |
2404874400 |
160 |
Prince Georges |
For profit - Corporation |
150 |
126.2 |
Medicare and Medicaid |
false |
PRINCE GEORGES POST ACUTE LLC |
05/01/2018 |
|
false |
false |
false |
Resident |
Partial |
5 |
4 |
5 |
4 |
5 |
4 |
4 |
2.38351 |
0.95187 |
1.77362 |
2.72549 |
5.10899 |
0.2057 |
2.31092 |
1.01568 |
0.69207 |
4.01867 |
2.14362 |
0.7047 |
0.96458 |
4.07668 |
08/15/2019 |
10 |
9 |
1 |
60 |
1 |
0 |
60 |
04/27/2018 |
2 |
2 |
0 |
8 |
1 |
0 |
8 |
|
. |
. |
. |
. |
. |
. |
. |
39.2 |
0 |
3 |
0 |
0.00 |
0 |
0 |
1051 BRIGHTSEAT ROAD LANDOVER, MD 20785 (38.905084, -76.853481) |
02/01/2020 |
9251 |
9251 |
303 RHODES AVENUE WOONSOCKET, RI 02895 |
42.005585 |
-71.533652 |
0 |
|
415044 |
FRIENDLY HOME INC THE |
303 RHODES AVENUE |
WOONSOCKET |
RI |
2895 |
4017697220 |
30 |
Providence |
For profit - Corporation |
126 |
123.2 |
Medicare and Medicaid |
false |
FRIENDLY HOME INC |
06/01/1979 |
|
false |
false |
false |
Resident |
Partial |
5 |
4 |
5 |
5 |
5 |
4 |
4 |
2.65577 |
0.37044 |
0.70246 |
1.07291 |
3.72868 |
0.01972 |
1.99968 |
0.65036 |
0.30699 |
2.95703 |
2.76023 |
0.42831 |
0.86126 |
4.04345 |
07/11/2019 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
09/20/2018 |
2 |
2 |
0 |
8 |
1 |
0 |
8 |
2017-07-13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2.667 |
0 |
0 |
0 |
0.00 |
0 |
0 |
303 RHODES AVENUE WOONSOCKET, RI 02895 (42.005585, -71.533652) |
02/01/2020 |
14845 |
14845 |
4000 POST ROAD WARWICK, RI 02886 |
41.682399 |
-71.450804 |
0 |
|
415061 |
BRENTWOOD NURSING HOME |
4000 POST ROAD |
WARWICK |
RI |
2886 |
4018848020 |
10 |
Kent |
For profit - Limited Liability company |
96 |
88 |
Medicare and Medicaid |
false |
BRENTWOOD HEALTH CENTER, LTD |
07/01/1979 |
|
false |
false |
false |
Resident |
Partial |
4 |
3 |
4 |
5 |
2 |
4 |
4 |
2.22497 |
0.44561 |
0.88789 |
1.33351 |
3.55848 |
0.1066 |
1.98607 |
0.72658 |
0.35856 |
3.07122 |
2.32834 |
0.46116 |
0.93203 |
3.71541 |
04/01/2019 |
1 |
1 |
1 |
4 |
1 |
0 |
4 |
05/15/2018 |
4 |
4 |
0 |
32 |
1 |
0 |
32 |
2017-03-16 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12.667 |
2 |
0 |
0 |
0.00 |
0 |
0 |
4000 POST ROAD WARWICK, RI 02886 (41.682399, -71.450804) |
02/01/2020 |
15066 |
15066 |
1 Country Ln, Brookville, OH 45309, USA |
39.8412624 |
-84.4038817 |
1 |
ROOFTOP |
365422 |
BROOKHAVEN NURSING & REHABILITATION CENTER |
ONE COUNTRY LANE |
BROOKVILLE |
OH |
45309 |
9378332133 |
580 |
Montgomery |
For profit - Corporation |
110 |
83.8 |
Medicare and Medicaid |
false |
BROOKVILLE ENTERPRISE INC. |
10/02/1979 |
|
false |
false |
false |
Resident |
Partial |
4 |
2 |
5 |
3 |
5 |
4 |
3 |
2.9008 |
1.12753 |
0.77704 |
1.90456 |
4.80537 |
0.12733 |
2.24121 |
0.82937 |
0.41746 |
3.48804 |
2.69 |
1.02226 |
0.70058 |
4.41772 |
11/21/2019 |
10 |
9 |
1 |
64 |
1 |
0 |
64 |
09/20/2018 |
14 |
11 |
3 |
84 |
1 |
0 |
84 |
2017-06-28 |
6 |
5 |
1 |
1 |
40 |
0 |
40 |
66.667 |
0 |
4 |
0 |
0.00 |
0 |
0 |
|
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
);