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
6 rows
where Staffing Rating Footnote = 2 and geocode_accuracy = "ROOFTOP"
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, prvdr_type, Legal Business Name, Most Recent Health Inspection More Than 2 Years Ago, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, 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 Total Health Score, 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 Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Deficiency 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
|
2105 |
2105 |
1027 E Hwy 98, Panama City, FL 32401, USA |
30.15668359999999 |
-85.64594819999999 |
1 |
ROOFTOP |
105775 |
GLENCOVE HEALTH AND REHABILITATION CENTER |
1027 E HWY 98 |
PANAMA CITY |
FL |
32401 |
8508721438 |
20 |
Bay |
For profit - Corporation |
115 |
|
Medicare and Medicaid |
false |
NF GLEN COVE LLC |
09/16/1992 |
|
false |
true |
false |
Resident |
Yes |
5 |
4 |
5 |
5 |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
01/10/2018 |
4 |
4 |
0 |
16 |
1 |
0 |
16 |
03/10/2017 |
3 |
2 |
1 |
8 |
1 |
0 |
8 |
2015-12-04 |
2 |
2 |
0 |
1 |
8 |
0 |
8 |
12 |
0 |
1 |
0 |
0.00 |
0 |
0 |
|
02/01/2020 |
2370 |
2370 |
6700 US-165, Monroe, LA 71203, USA |
32.5898929 |
-92.066053 |
1 |
ROOFTOP |
195628 |
NORTHEAST LA WAR VETERANS HOME |
6700 HIGHWAY 165 NORTH |
MONROE |
LA |
71211 |
3183624206 |
360 |
Ouachita |
Government - State |
10 |
2.6 |
Medicare |
false |
NORTHEAST LOUISANA VETERANS HOME |
12/04/2008 |
|
false |
false |
false |
Resident |
Yes |
3 |
4 |
1 |
|
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
08/05/2019 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
07/17/2018 |
4 |
4 |
0 |
24 |
1 |
0 |
24 |
2017-07-06 |
2 |
1 |
1 |
1 |
8 |
0 |
8 |
9.333 |
0 |
1 |
0 |
0.00 |
0 |
0 |
|
02/01/2020 |
5569 |
5569 |
275 S Lasalle St, Aurora, IL 60505, USA |
41.751409 |
-88.3177809 |
1 |
ROOFTOP |
14A539 |
JENNINGS TERRACE |
275 SOUTH LASALLE |
AURORA |
IL |
60505 |
6308976947 |
530 |
Kane |
Non profit - Other |
60 |
14.5 |
Medicaid |
false |
Legal Business Name Not Available |
09/18/2008 |
|
false |
false |
false |
Resident |
Yes |
4 |
4 |
4 |
4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12/12/2019 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
11/29/2018 |
5 |
4 |
1 |
32 |
1 |
0 |
32 |
2018-01-16 |
12 |
9 |
3 |
1 |
56 |
0 |
56 |
20 |
1 |
2 |
0 |
0.00 |
0 |
0 |
|
02/01/2020 |
7737 |
7737 |
6800 Joliet Rd, Indian Head Park, IL 60525, USA |
41.7692481 |
-87.8901817 |
1 |
ROOFTOP |
145784 |
BRIAR PLACE NURSING |
6800 WEST JOLIET |
INDIAN HEAD PARK |
IL |
60525 |
7082468500 |
141 |
Cook |
For profit - Corporation |
232 |
205.4 |
Medicare and Medicaid |
false |
BRIAR PLACE NURSING LLC |
02/01/1994 |
|
true |
false |
false |
Resident |
Yes |
1 |
1 |
1 |
2 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
08/21/2019 |
20 |
11 |
9 |
136 |
1 |
0 |
136 |
10/26/2018 |
16 |
5 |
11 |
112 |
1 |
0 |
112 |
2017-09-01 |
21 |
10 |
12 |
1 |
128 |
0 |
128 |
126.667 |
1 |
30 |
0 |
0.00 |
0 |
0 |
|
02/01/2020 |
10380 |
10380 |
15230 15th Ave NE, Shoreline, WA 98155, USA |
47.740384 |
-122.3105044 |
1 |
ROOFTOP |
50A260 |
FIRCREST SCHOOL, PAT N |
15230-15TH NORTHEAST |
SEATTLE |
WA |
98155 |
2063613511 |
160 |
King |
Government - State |
92 |
109.2 |
Medicaid |
false |
Legal Business Name Not Available |
05/13/1994 |
|
false |
false |
false |
None |
Yes |
5 |
4 |
5 |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
08/15/2019 |
8 |
4 |
5 |
52 |
1 |
0 |
52 |
05/17/2018 |
8 |
1 |
7 |
52 |
1 |
0 |
52 |
2017-04-14 |
8 |
3 |
7 |
1 |
80 |
0 |
80 |
56.667 |
5 |
9 |
0 |
0.00 |
0 |
0 |
|
02/01/2020 |
13865 |
13865 |
932 Old US Hwy 70, Black Mountain, NC 28711, USA |
35.612557 |
-82.356127 |
1 |
ROOFTOP |
34A001 |
BLACK MOUNTAIN NEURO-MEDICAL TREATMENT CENTER |
932 OLD US HIGHWAY 70 |
BLACK MOUNTAIN |
NC |
28711 |
8282596700 |
100 |
Buncombe |
Government - State |
165 |
156.3 |
Medicaid |
false |
Legal Business Name Not Available |
10/04/1991 |
|
false |
false |
true |
Resident |
Yes |
5 |
4 |
5 |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
05/09/2019 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
05/03/2018 |
6 |
6 |
0 |
24 |
1 |
0 |
24 |
2017-05-25 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
8 |
0 |
0 |
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
);