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 "Rating Cycle 3 Standard Health Survey Date" is on date 2018-05-09
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, ownership, Special Focus Status, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall Rating, Overall Rating Footnote, Health Inspection Rating, Health Inspection Rating Footnote, QM Rating, QM Rating Footnote, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Health Revisits, Rating Cycle 3 Number of Standard Health Deficiencies, Number of Facility Reported Incidents, Number of Fines, Total Amount of Fines in Dollars, Number of Payment Denials, Total Number of Penalties, 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
|
1829 |
1829 |
1021 NORTH CHURCH STREET JACKSONVILLE, IL 62650 |
39.747165 |
-90.233924 |
0 |
|
145928 |
APERION CARE JACKSONVILLE |
1021 NORTH CHURCH STREET |
JACKSONVILLE |
IL |
62650 |
2172454174 |
770 |
Morgan |
For profit - Corporation |
113 |
72.6 |
Medicare and Medicaid |
false |
NORTH CHURCH NURSING & REHAB, LLC |
04/15/1997 |
|
true |
false |
false |
Resident |
Yes |
1 |
1 |
2 |
4 |
1 |
2 |
2 |
1.60029 |
0.6323 |
0.37533 |
1.00764 |
2.60793 |
0.01255 |
2.18586 |
0.81513 |
0.44037 |
3.44135 |
1.52157 |
0.58329 |
0.3208 |
2.43008 |
11/19/2019 |
12 |
0 |
12 |
100 |
1 |
0 |
100 |
10/09/2018 |
10 |
4 |
6 |
52 |
1 |
0 |
52 |
2018-05-09 |
25 |
4 |
21 |
1 |
320 |
0 |
320 |
120.667 |
0 |
40 |
2 |
72703.00 |
2 |
4 |
1021 NORTH CHURCH STREET JACKSONVILLE, IL 62650 (39.747165, -90.233924) |
02/01/2020 |
11136 |
11136 |
524 WEST MAIN STREET DECATURVILLE, TN 38329 |
35.581331 |
-88.128105 |
0 |
|
445449 |
AHC WESTWOOD |
524 WEST MAIN STREET |
DECATURVILLE |
TN |
38329 |
7318523591 |
190 |
Decatur |
For profit - Corporation |
90 |
53.7 |
Medicare and Medicaid |
false |
WESTWOOD HEALTH CARE AND REHABILITATION CENTER INC |
04/01/2002 |
|
false |
false |
false |
Both |
Yes |
5 |
5 |
4 |
4 |
4 |
3 |
3 |
2.23175 |
0.94888 |
0.61474 |
1.56361 |
3.79536 |
0.05633 |
2.10546 |
0.72674 |
0.32333 |
3.15553 |
2.20299 |
0.98178 |
0.71561 |
3.85686 |
01/23/2020 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
03/12/2019 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2018-05-09 |
5 |
5 |
0 |
1 |
24 |
0 |
24 |
4 |
1 |
0 |
0 |
0.00 |
0 |
0 |
524 WEST MAIN STREET DECATURVILLE, TN 38329 (35.581331, -88.128105) |
02/01/2020 |
11217 |
11217 |
813 1/2 Marion Pike, Coal Grove, OH 45638, USA |
38.4998253 |
-82.6373679 |
1 |
ROOFTOP |
366202 |
CRYSTAL CARE OF COAL GROVE |
813 1/2 MARION PIKE |
COAL GROVE |
OH |
45638 |
7405320449 |
450 |
Lawrence |
For profit - Partnership |
57 |
44.8 |
Medicare and Medicaid |
false |
CRYSTAL CARE OF IRONTON, LLC |
08/10/2000 |
SFF |
false |
false |
false |
Resident |
Yes |
|
|
|
|
|
|
|
2.10044 |
0.97837 |
0.06223 |
1.0406 |
3.14105 |
0.01995 |
2.26517 |
0.89473 |
0.46124 |
3.62115 |
1.9272 |
0.82223 |
0.05078 |
2.78151 |
11/21/2019 |
24 |
13 |
11 |
144 |
0 |
0 |
144 |
06/24/2019 |
70 |
52 |
18 |
636 |
1 |
0 |
636 |
2018-05-09 |
31 |
29 |
3 |
1 |
240 |
0 |
240 |
324 |
1 |
12 |
0 |
0.00 |
1 |
1 |
|
02/01/2020 |
13840 |
13840 |
1026 E GOODE ST QUITMAN, TX 75783 |
32.795827 |
-95.431507 |
0 |
|
675553 |
HERITAGE HOUSE HEALTH CARE CENTRE |
1026 E GOODE ST |
QUITMAN |
TX |
75783 |
9037632284 |
974 |
Wood |
For profit - Limited Liability company |
164 |
49.6 |
Medicare and Medicaid |
false |
LS QUITMAN OPERATOR LLC |
10/10/1995 |
SFF |
false |
false |
true |
Resident |
Yes |
|
|
|
|
|
|
|
1.47653 |
0.89175 |
0.1394 |
1.03115 |
2.50768 |
0.00951 |
2.04133 |
0.74787 |
0.3912 |
3.1804 |
1.5033 |
0.8966 |
0.13412 |
2.52839 |
09/11/2019 |
18 |
7 |
18 |
752 |
1 |
0 |
752 |
04/03/2019 |
16 |
10 |
6 |
160 |
1 |
0 |
160 |
2018-05-09 |
10 |
5 |
7 |
1 |
128 |
0 |
128 |
450.667 |
4 |
8 |
1 |
27869.00 |
0 |
1 |
1026 E GOODE ST QUITMAN, TX 75783 (32.795827, -95.431507) |
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
);