nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
5 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2016-11-18
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, nmbr_beds, Special Focus Status, 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, 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 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, 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 Revisit Score, Number of Facility Reported Incidents, Number of Fines, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
235 | 235 | 400 EAST HOSPITAL ROAD EL DORADO SPRINGS, MO 64744 | 37.859255 | -94.01594 | 0 | 265446 | COMMUNITY SPRINGS HEALTHCARE FACILITY | 400 EAST HOSPITAL ROAD | EL DORADO SPRINGS | MO | 64744 | 4178762531 | 190 | Cedar | Non profit - Corporation | 120 | 60.4 | Medicare and Medicaid | false | CITIZENS MEMORIAL HEALTH CARE FOUNDATION | 02/01/1991 | false | true | false | false | Resident | Yes | 2 | 2 | 1 | 1 | 1 | 4 | 4 | 2.15376 | 0.44752 | 0.72304 | 1.17057 | 3.32433 | 0.08491 | 1.96801 | 0.63125 | 0.28614 | 2.8854 | 2.2745 | 0.53309 | 0.95109 | 3.69447 | 12/13/2018 | 3 | 2 | 1 | 28 | 1 | 0 | 28 | 11/16/2017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-11-18 | 3 | 3 | 0 | 1 | 28 | 0 | 28 | 18.667 | 1 | 0 | 1 | 11278.00 | 0 | 1 | 400 EAST HOSPITAL ROAD EL DORADO SPRINGS, MO 64744 (37.859255, -94.01594) | 02/01/2020 | |||||||||||
6842 | 6842 | 689 MAIN STREET HAVERHILL, MA 01830 | 42.7953 | -71.085563 | 0 | 225218 | OXFORD REHABILITATION & HEALTH CARE CENTER, THE | 689 MAIN STREET | HAVERHILL | MA | 1830 | 9783731131 | 40 | Essex | For profit - Corporation | 120 | 108.7 | Medicare and Medicaid | false | OXFORD MA SNF LLC | 08/01/1974 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.04133 | 0.61626 | 0.6813 | 1.29756 | 3.33889 | 0.11175 | 1.89645 | 0.68313 | 0.32529 | 2.90487 | 2.23711 | 0.67834 | 0.78831 | 3.68577 | 03/15/2019 | 20 | 9 | 11 | 215 | 1 | 0 | 215 | 02/09/2018 | 40 | 27 | 13 | 1195 | 2 | 598 | 1793 | 2016-11-18 | 19 | 8 | 11 | 1 | 258 | 0 | 258 | 748.167 | 5 | 4 | 3 | 142727.00 | 0 | 3 | 689 MAIN STREET HAVERHILL, MA 01830 (42.7953, -71.085563) | 02/01/2020 | ||||||||||
8756 | 8756 | 4000 LINGLESTOWN ROAD HARRISBURG, PA 17112 | 40.334868 | -76.838872 | 0 | 395372 | JEWISH HOME OF GREATER HARRISB | 4000 LINGLESTOWN ROAD | HARRISBURG | PA | 17112 | 7176570700 | 280 | Dauphin | Non profit - Corporation | 138 | 126 | Medicare and Medicaid | false | JEWISH HOME OF GREATER HARRISBURG | 04/12/1977 | false | true | false | false | None | Yes | 2 | 1 | 5 | 5 | 5 | 4 | 4 | 2.22914 | 0.9835 | 0.876 | 1.8595 | 4.08864 | 0.03764 | 2.2968 | 0.80237 | 0.40239 | 3.50155 | 2.01712 | 0.92168 | 0.8194 | 3.7443 | 01/31/2019 | 23 | 16 | 7 | 160 | 1 | 0 | 160 | 01/12/2018 | 16 | 13 | 3 | 112 | 1 | 0 | 112 | 2016-11-18 | 16 | 7 | 9 | 2 | 100 | 50 | 150 | 142.333 | 3 | 9 | 2 | 26904.00 | 0 | 2 | 4000 LINGLESTOWN ROAD HARRISBURG, PA 17112 (40.334868, -76.838872) | 02/01/2020 | |||||||||||
10552 | 10552 | 200 SECOND AVENUE KINGSTON, PA 18704 | 41.257013 | -75.883465 | 0 | 395397 | MANORCARE HEALTH SERVICES-KINGSTON | 200 SECOND AVENUE | KINGSTON | PA | 18704 | 5702889315 | 480 | Luzerne | Non profit - Other | 176 | 136 | Medicare and Medicaid | false | MANOR CARE OF KINGSTON PA LLC | 12/01/1977 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 2 | 3 | 3 | 1.95772 | 0.86864 | 0.51898 | 1.38761 | 3.34533 | 0.08077 | 2.11214 | 0.75195 | 0.37317 | 3.23727 | 1.92639 | 0.86862 | 0.52344 | 3.3137 | 11/19/2018 | 24 | 11 | 13 | 176 | 1 | 0 | 176 | 12/22/2017 | 20 | 7 | 13 | 120 | 2 | 60 | 180 | 2016-11-18 | 22 | 14 | 8 | 1 | 140 | 0 | 140 | 171.333 | 2 | 33 | 2 | 61988.00 | 2 | 4 | 200 SECOND AVENUE KINGSTON, PA 18704 (41.257013, -75.883465) | 02/01/2020 | |||||||||||
14660 | 14660 | 4680 CORDATA PARKWAY BELLINGHAM, WA 98226 | 48.811636 | -122.497692 | 0 | 505393 | NORTH CASCADES HEALTH AND REHABILITATION CENTER | 4680 CORDATA PARKWAY | BELLINGHAM | WA | 98226 | 3603981966 | 360 | Whatcom | For profit - Corporation | 122 | 95.5 | Medicare and Medicaid | false | EVERGREEN AT BELLINGHAM, L.L.C. | 09/01/1991 | false | true | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 3 | 4 | 2.0074 | 0.54144 | 0.99658 | 1.53802 | 3.54542 | 0.09696 | 2.15472 | 0.7544 | 0.36618 | 3.2753 | 1.93624 | 0.53968 | 1.02434 | 3.47113 | 04/24/2019 | 24 | 19 | 8 | 132 | 1 | 0 | 132 | 02/14/2018 | 22 | 20 | 2 | 156 | 1 | 0 | 156 | 2016-11-18 | 14 | 14 | 0 | 1 | 80 | 0 | 80 | 131.333 | 3 | 3 | 1 | 51714.00 | 0 | 1 | 4680 CORDATA PARKWAY BELLINGHAM, WA 98226 (48.811636, -122.497692) | 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 );