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 Standard Health Survey Date" is on date 2016-10-27 and Total Number of Penalties = 3
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, ownership, Abuse Icon, Overall Rating, Health Inspection Rating, QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, 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, Number of Fines, Number of Payment Denials, 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
|
4727 |
4727 |
6120 MORNINGSIDE AVENUE SIOUX CITY, IA 51106 |
42.461538 |
-96.328987 |
0 |
|
165540 |
COUNTRYSIDE HEALTH CARE CENTER |
6120 MORNINGSIDE AVENUE |
SIOUX CITY |
IA |
51106 |
7122763000 |
960 |
Woodbury |
For profit - Individual |
69 |
38.5 |
Medicare and Medicaid |
false |
COUNTRYSIDE HEALTH INVESTORS LLC |
04/01/2004 |
|
false |
false |
false |
Resident |
Yes |
1 |
1 |
4 |
3 |
5 |
3 |
3 |
1.99011 |
0.83141 |
0.63454 |
1.46596 |
3.45607 |
0.02789 |
2.05205 |
0.75025 |
0.3636 |
3.1659 |
2.0156 |
0.83328 |
0.65685 |
3.50056 |
04/12/2019 |
32 |
30 |
20 |
219 |
1 |
0 |
219 |
11/27/2017 |
3 |
3 |
0 |
12 |
1 |
0 |
12 |
2016-10-27 |
3 |
3 |
0 |
1 |
20 |
0 |
20 |
116.833 |
1 |
4 |
2 |
59346.00 |
1 |
3 |
6120 MORNINGSIDE AVENUE SIOUX CITY, IA 51106 (42.461538, -96.328987) |
02/01/2020 |
5209 |
5209 |
13550 S Outer Forty Rd, Chesterfield, MO 63017, USA |
38.6392324 |
-90.50228109999999 |
1 |
ROOFTOP |
265105 |
DELMAR GARDENS WEST |
13550 SOUTH OUTER 40 ROAD |
TOWN AND COUNTRY |
MO |
63017 |
3148781330 |
940 |
St. Louis |
For profit - Corporation |
321 |
241.2 |
Medicare and Medicaid |
false |
DELMAR GARDENS WEST OPERATING, LLC |
02/01/1972 |
|
true |
false |
false |
Resident |
Yes |
2 |
2 |
4 |
2 |
5 |
2 |
2 |
2.27808 |
0.5966 |
0.32004 |
0.91664 |
3.19472 |
0.04962 |
1.85344 |
0.64793 |
0.28823 |
2.7896 |
2.5545 |
0.69237 |
0.41792 |
3.67235 |
12/05/2018 |
8 |
7 |
1 |
68 |
1 |
0 |
68 |
01/19/2018 |
8 |
7 |
4 |
88 |
1 |
0 |
88 |
2016-10-27 |
7 |
6 |
1 |
1 |
48 |
0 |
48 |
71.333 |
2 |
11 |
3 |
46449.00 |
0 |
3 |
|
02/01/2020 |
5555 |
5555 |
826 NORTH STREET STAMPS, AR 71860 |
33.369119 |
-93.489996 |
0 |
|
45232 |
THE WATERS OF STAMPS, LLC |
826 NORTH STREET |
STAMPS |
AR |
71860 |
8705334444 |
360 |
Lafayette |
For profit - Corporation |
94 |
47.8 |
Medicare and Medicaid |
false |
THE WATERS OF STAMPS LLC |
03/01/1994 |
|
false |
false |
false |
Resident |
Yes |
1 |
1 |
3 |
4 |
1 |
3 |
2 |
2.37142 |
1.20506 |
0.33252 |
1.53758 |
3.909 |
0.00806 |
1.80084 |
0.61405 |
0.2722 |
2.6871 |
2.73684 |
1.47566 |
0.45978 |
4.66482 |
01/11/2019 |
7 |
2 |
5 |
119 |
1 |
0 |
119 |
11/10/2017 |
11 |
7 |
4 |
88 |
1 |
0 |
88 |
2016-10-27 |
10 |
7 |
3 |
1 |
290 |
0 |
290 |
137.167 |
0 |
10 |
2 |
23131.00 |
1 |
3 |
826 NORTH STREET STAMPS, AR 71860 (33.369119, -93.489996) |
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
);