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-02-02
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Date First Approved to Provide Medicare and Medicaid services, Special Focus Status, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing 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 2 Standard Health Survey Date, Rating Cycle 2 Number of Complaint Health Deficiencies, 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 Health Deficiency Score, Rating Cycle 3 Total Health Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
293 | 293 | 530 EAST BEARDSTOWN STREET VIRGINIA, IL 62691 | 39.94748 | -90.205881 | 0 | 146100 | WALKER NURSING HOME | 530 EAST BEARDSTOWN STREET | VIRGINIA | IL | 62691 | 2174523218 | 80 | Cass | For profit - Corporation | 71 | 39.3 | Medicare and Medicaid | false | WALKER NURSING HOME INC | 01/20/2006 | false | true | false | false | Both | Yes | 2 | 2 | 5 | 5 | 2 | 1 | 12 | 1 | 12 | 1.44939 | 0.65874 | 0.24862 | 0.90736 | 2.35675 | 0.00509 | 2.04575 | 0.61646 | 0.22759 | 2.88981 | 1.47248 | 0.80351 | 0.41115 | 2.61515 | 12/05/2018 | 5 | 4 | 1 | 52 | 1 | 0 | 52 | 01/04/2018 | 9 | 8 | 1 | 92 | 1 | 0 | 92 | 2017-02-02 | 4 | 4 | 0 | 1 | 40 | 0 | 40 | 63.333 | 1 | 1 | 1 | 8011.00 | 0 | 1 | 530 EAST BEARDSTOWN STREET VIRGINIA, IL 62691 (39.94748, -90.205881) | 02/01/2020 | |||||||||
2249 | 2249 | Elmore, AL, USA | 32.5387448 | -86.3149712 | 1 | APPROXIMATE | 15019 | MERRY WOOD LODGE CARE AND REHABILITATION CENTER | P O BOX 130 | ELMORE | AL | 36025 | 3345678484 | 250 | Elmore | For profit - Corporation | 124 | 97.9 | Medicare and Medicaid | false | SUNBRIDGE HEALTHCARE LLC | 01/01/1974 | false | SFF Candidate | true | false | false | Resident | Yes | 2 | 1 | 2 | 3 | 2 | 4 | 4 | 2.09629 | 0.63975 | 0.59735 | 1.2371 | 3.33339 | 0.04508 | 1.95583 | 0.67874 | 0.29761 | 2.93218 | 2.22759 | 0.70874 | 0.75546 | 3.64542 | 12/13/2018 | 8 | 2 | 6 | 562 | 1 | 0 | 562 | 03/29/2018 | 3 | 3 | 1 | 24 | 1 | 0 | 24 | 2017-02-02 | 5 | 5 | 1 | 1 | 16 | 0 | 16 | 291.667 | 1 | 2 | 1 | 78677.00 | 0 | 1 | 02/01/2020 | ||||||||||
5235 | 5235 | 620 PARKER ROAD MAYSVILLE, KY 41056 | 38.636145 | -83.794123 | 0 | 185207 | MAYSVILLE NURSING AND REHABILITATION FACILITY | 620 PARKER ROAD | MAYSVILLE | KY | 41056 | 6065644085 | 800 | Mason | For profit - Individual | 130 | 112 | Medicare and Medicaid | false | MAYSVILLE OPERATIONS LLC | 04/18/1990 | false | true | false | false | Both | Yes | 1 | 1 | 2 | 1 | 4 | 2 | 1 | 2.86542 | 1.04351 | 0.20256 | 1.24607 | 4.11149 | 0.05594 | 2.28943 | 0.82271 | 0.3969 | 3.50904 | 2.60122 | 0.95375 | 0.19209 | 3.75719 | 02/21/2019 | 16 | 10 | 6 | 412 | 1 | 0 | 412 | 03/22/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-02-02 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 208 | 0 | 1 | 2 | 26155.00 | 0 | 2 | 620 PARKER ROAD MAYSVILLE, KY 41056 (38.636145, -83.794123) | 02/01/2020 | |||||||||||
7401 | 7401 | 900 GAGEL AVENUE LOUISVILLE, KY 40216 | 38.172763 | -85.806075 | 0 | 185096 | LANDMARK OF IROQUOIS PARK REHAB AND NURSING CENTER | 900 GAGEL AVENUE | LOUISVILLE | KY | 40216 | 5023685827 | 550 | Jefferson | For profit - Corporation | 120 | 93.6 | Medicare and Medicaid | false | LANDMARK OF IRIQUOIS PARK REHABILITATION AND NURSING CENTER | 01/01/1974 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 1 | 2 | 2 | 1.85742 | 0.86906 | 0.3333 | 1.20237 | 3.05979 | 0.03797 | 1.98784 | 0.77178 | 0.39624 | 3.15585 | 1.94199 | 0.84673 | 0.3166 | 3.10905 | 06/24/2019 | 15 | 14 | 5 | 372 | 1 | 0 | 372 | 03/29/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 2017-02-02 | 4 | 1 | 3 | 1 | 16 | 0 | 16 | 194 | 2 | 2 | 1 | 21393.00 | 0 | 1 | 900 GAGEL AVENUE LOUISVILLE, KY 40216 (38.172763, -85.806075) | 02/01/2020 | |||||||||||
11488 | 11488 | 6201 EAST 36TH STREET TULSA, OK 74135 | 36.111657 | -95.907414 | 0 | 375438 | GRACEWOOD HEALTH & REHAB | 6201 EAST 36TH STREET | TULSA | OK | 74135 | 9186223430 | 710 | Tulsa | For profit - Individual | 121 | 68.1 | Medicare and Medicaid | false | GRACEWOOD HEALTH & REHAB LLC | 06/15/2003 | false | true | false | false | Resident | Yes | 2 | 2 | 4 | 5 | 2 | 2 | 2 | 2.13989 | 0.61375 | 0.3107 | 0.92445 | 3.06434 | 0.00702 | 1.78414 | 0.62121 | 0.30025 | 2.70561 | 2.49274 | 0.7429 | 0.38948 | 3.63182 | 05/08/2019 | 8 | 8 | 4 | 84 | 1 | 0 | 84 | 03/13/2018 | 11 | 7 | 4 | 116 | 1 | 0 | 116 | 2017-02-02 | 14 | 5 | 9 | 1 | 108 | 0 | 108 | 98.667 | 1 | 11 | 2 | 103031.00 | 0 | 2 | 6201 EAST 36TH STREET TULSA, OK 74135 (36.111657, -95.907414) | 02/01/2020 | |||||||||||
12283 | 12283 | 135 DODGE STREET PROVIDENCE, RI 02907 | 41.81389 | -71.424984 | 0 | 415038 | BANNISTER CTR FOR REHABILITATION AND HEALTH CARE | 135 DODGE STREET | PROVIDENCE | RI | 2907 | 4015219600 | 30 | Providence | For profit - Corporation | 161 | 138.8 | Medicare and Medicaid | false | BANNISTER OPERATIONS ASSOC LLC | 03/31/1974 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 1 | 3 | 1 | 3 | 4 | 2.02577 | 0.30238 | 0.74393 | 1.04631 | 3.07208 | 0.15801 | 1.8413 | 0.72924 | 0.37814 | 2.94868 | 2.28655 | 0.31179 | 0.74048 | 3.34086 | 02/15/2019 | 6 | 4 | 4 | 99 | 1 | 0 | 99 | 02/14/2018 | 15 | 13 | 2 | 104 | 1 | 0 | 104 | 2017-02-02 | 5 | 1 | 4 | 1 | 56 | 0 | 56 | 93.5 | 7 | 2 | 1 | 13627.00 | 0 | 1 | 135 DODGE STREET PROVIDENCE, RI 02907 (41.81389, -71.424984) | 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 );