nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-06-23
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Special Focus Status, 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 Health Revisits, Rating Cycle 1 Health Revisit 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 Number of Health Revisits, Rating Cycle 2 Health Revisit 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 Total Health Score, 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 | Continuing Care Retirement Community | 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 | 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 | Reported Staffing Footnote | Physical Therapist Staffing Footnote | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2764 | 2764 | 2501 RICE LAKE ROAD DULUTH, MN 55811 | 46.817077 | -92.125336 | 0 | 245366 | CHRIS JENSEN HEALTH & REHABILITATION CENTER | 2501 RICE LAKE ROAD | DULUTH | MN | 55811 | 2186256400 | 680 | St. Louis | For profit - Corporation | 170 | 157.1 | Medicare and Medicaid | false | CHRIS JENSEN LLC | 08/01/1986 | false | true | false | false | Both | Yes | 2 | 1 | 2 | 2 | 2 | 4 | 4 | 2.24282 | 0.44125 | 0.80745 | 1.24871 | 3.49153 | 0.03975 | 2.00257 | 0.69773 | 0.32573 | 3.02603 | 2.32768 | 0.47554 | 0.93303 | 3.69995 | 09/18/2019 | 9 | 0 | 9 | 157 | 2 | 79 | 236 | 08/23/2018 | 22 | 17 | 5 | 136 | 1 | 0 | 136 | 2017-06-23 | 4 | 4 | 0 | 1 | 20 | 0 | 20 | 166.667 | 14 | 5 | 1 | 12350.00 | 0 | 1 | 2501 RICE LAKE ROAD DULUTH, MN 55811 (46.817077, -92.125336) | 02/01/2020 | |||||||||||
3786 | 3786 | 2901 S Wolf Rd, Westchester, IL 60154, USA | 41.8364763 | -87.89957299999999 | 1 | ROOFTOP | 145660 | WESTCHESTER HEALTH & REHABILITATION | 2901 SOUTH WOLF ROAD | WESTCHESTER | IL | 60154 | 7085311441 | 141 | Cook | For profit - Corporation | 120 | 89.1 | Medicare and Medicaid | false | SSC WESTCHESTER OPERATING COMPANY LLC | 11/24/1989 | false | true | false | false | Both | Yes | 1 | 1 | 2 | 3 | 2 | 2 | 3 | 1.69219 | 0.83961 | 0.52418 | 1.36379 | 3.05598 | 0.10636 | 2.05352 | 0.74324 | 0.35897 | 3.15573 | 1.71263 | 0.84945 | 0.5496 | 3.1053 | 06/26/2019 | 22 | 14 | 8 | 140 | 1 | 0 | 140 | 08/17/2018 | 33 | 23 | 10 | 144 | 1 | 0 | 144 | 2017-06-23 | 24 | 20 | 4 | 1 | 168 | 0 | 168 | 146 | 0 | 18 | 1 | 29221.00 | 1 | 2 | 02/01/2020 | |||||||||||
4432 | 4432 | 150 NORTH 27TH STREET BELLEVILLE, IL 62226 | 38.525934 | -90.009532 | 0 | 145668 | BRIA OF BELLEVILLE | 150 NORTH 27TH STREET | BELLEVILLE | IL | 62226 | 6182356600 | 900 | St. Clair | For profit - Corporation | 140 | 116.6 | Medicare and Medicaid | false | BELLEVILLE HEALTHCARE & REHAB CENTER | 12/29/1989 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 3 | 1 | 12 | 1 | 12 | 6 | 6 | 06/07/2019 | 35 | 17 | 22 | 268 | 2 | 134 | 402 | 07/24/2018 | 10 | 8 | 2 | 64 | 1 | 0 | 64 | 2017-06-23 | 20 | 10 | 11 | 1 | 112 | 0 | 112 | 241 | 0 | 35 | 1 | 24555.00 | 1 | 2 | 150 NORTH 27TH STREET BELLEVILLE, IL 62226 (38.525934, -90.009532) | 02/01/2020 | ||||||||||||||||||||
6308 | 6308 | 800 NORTH MARKET STREET KNOXVILLE, IL 61448 | 40.917589 | -90.284867 | 0 | 145697 | KNOX COUNTY NURSING HOME | 800 NORTH MARKET STREET | KNOXVILLE | IL | 61448 | 3092892338 | 560 | Knox | Government - County | 169 | 107.5 | Medicare and Medicaid | false | COUNTY OF KNOX | 09/01/1991 | false | true | false | false | Both | Yes | 4 | 2 | 5 | 4 | 5 | 4 | 4 | 2.66 | 0.74407 | 0.59346 | 1.33753 | 3.99754 | 0.00453 | 2.12062 | 0.65854 | 0.27705 | 3.0562 | 2.60697 | 0.84961 | 0.80624 | 4.19434 | 05/10/2019 | 4 | 2 | 3 | 16 | 1 | 0 | 16 | 07/26/2018 | 11 | 8 | 3 | 56 | 1 | 0 | 56 | 2017-06-23 | 4 | 2 | 2 | 0 | 8 | 0 | 8 | 28 | 3 | 6 | 0 | 0.00 | 0 | 0 | 800 NORTH MARKET STREET KNOXVILLE, IL 61448 (40.917589, -90.284867) | 02/01/2020 | |||||||||||
6895 | 6895 | 1201 DIXIE HIGHWAY BEECHER, IL 60401 | 41.354155 | -87.621357 | 0 | 145538 | BEECHER MANOR NRSG & REHAB CTR | 1201 DIXIE HIGHWAY | BEECHER | IL | 60401 | 7089462600 | 989 | Will | For profit - Partnership | 128 | 123 | Medicare and Medicaid | false | BEECHER MANOR NURSING AND REHABILITATION CENTER, LLC | 02/21/1986 | false | true | false | false | Resident | Yes | 2 | 2 | 3 | 4 | 3 | 2 | 3 | 1.65367 | 0.74644 | 0.6022 | 1.34864 | 3.00231 | 0.09281 | 2.16816 | 0.81603 | 0.39461 | 3.3788 | 1.58516 | 0.68781 | 0.57438 | 2.84935 | 06/20/2019 | 6 | 5 | 1 | 32 | 1 | 0 | 32 | 05/17/2018 | 12 | 11 | 3 | 96 | 1 | 0 | 96 | 2017-06-23 | 1 | 1 | 0 | 1 | 8 | 0 | 8 | 49.333 | 0 | 4 | 0 | 0.00 | 0 | 0 | 1201 DIXIE HIGHWAY BEECHER, IL 60401 (41.354155, -87.621357) | 02/01/2020 | |||||||||||
14239 | 14239 | 1000 EVERGREEN AVENUE WEATHERLY, PA 18255 | 40.93734 | -75.815191 | 0 | 395464 | WEATHERWOOD HEALTHCARE AND REHABILITATION CENTER | 1000 EVERGREEN AVENUE | WEATHERLY | PA | 18255 | 5704278683 | 190 | Carbon | For profit - Corporation | 200 | 179.5 | Medicare and Medicaid | false | GUARDIAN ELDER CARE AT WEATHERLY I LLC | 12/01/1979 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 4 | 3 | 1 | 1 | 2.16457 | 0.908 | 0.35887 | 1.26687 | 3.43144 | 0.0572 | 2.17136 | 0.82388 | 0.43974 | 3.43498 | 2.07184 | 0.82872 | 0.30716 | 3.20336 | 06/14/2019 | 23 | 21 | 2 | 188 | 1 | 0 | 188 | 05/25/2018 | 16 | 10 | 6 | 96 | 2 | 48 | 144 | 2017-06-23 | 16 | 10 | 8 | 1 | 128 | 0 | 128 | 163.333 | 1 | 17 | 1 | 7673.00 | 1 | 2 | 1000 EVERGREEN AVENUE WEATHERLY, PA 18255 (40.93734, -75.815191) | 02/01/2020 |
Advanced export
JSON shape: default, array, newline-delimited
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 );