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-08-04
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, nmbr_beds, Overall Rating, QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, RN Staffing Rating, 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 2 Standard Health Survey Date, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6360 | 6360 | 171 HERITAGE WAY KALISPELL, MT 59901 | 48.218121 | -114.327829 | 0 | 275025 | HERITAGE PLACE | 171 HERITAGE WAY | KALISPELL | MT | 59901 | 4067550800 | 140 | Flathead | For profit - Limited Liability company | 140 | 80.4 | Medicare and Medicaid | false | KISMET GPI, LLC | 01/01/1967 | false | true | false | false | Resident | Yes | 2 | 1 | 3 | 1 | 4 | 4 | 4 | 2.0598 | 0.47018 | 0.66961 | 1.13979 | 3.19959 | 0.02002 | 1.88029 | 0.66921 | 0.3084 | 2.8579 | 2.27675 | 0.5283 | 0.81721 | 3.59004 | 11/29/2018 | 12 | 12 | 0 | 104 | 1 | 0 | 104 | 08/24/2017 | 15 | 12 | 5 | 403 | 1 | 0 | 403 | 2016-08-04 | 13 | 5 | 8 | 1 | 96 | 0 | 96 | 202.333 | 0 | 9 | 3 | 337204.00 | 1 | 4 | 171 HERITAGE WAY KALISPELL, MT 59901 (48.218121, -114.327829) | 02/01/2020 | |||||||||||
9740 | 9740 | 400 SEVENTH STREET MARIETTA, OH 45750 | 39.421903 | -81.450742 | 0 | 365687 | ARBORS AT MARIETTA | 400 SEVENTH STREET | MARIETTA | OH | 45750 | 7403733597 | 850 | Washington | For profit - Partnership | 150 | 129.9 | Medicare and Medicaid | false | MARIETTA OPCO LLC | 06/30/1986 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 3 | 3 | 2 | 2.66435 | 0.98533 | 0.63856 | 1.62389 | 4.28824 | 0.02871 | 2.0555 | 0.79791 | 0.50309 | 3.3565 | 2.69395 | 0.92856 | 0.47774 | 4.09681 | 11/29/2018 | 18 | 13 | 5 | 88 | 1 | 0 | 88 | 09/14/2017 | 37 | 22 | 16 | 192 | 1 | 0 | 192 | 2016-08-04 | 26 | 9 | 17 | 1 | 124 | 0 | 124 | 128.667 | 1 | 11 | 2 | 42890.00 | 0 | 2 | 400 SEVENTH STREET MARIETTA, OH 45750 (39.421903, -81.450742) | 02/01/2020 | |||||||||||
11025 | 11025 | 6969 GLENMEADOW LANE CINCINNATI, OH 45237 | 39.187326 | -84.468172 | 0 | 366220 | HARMONY COURT REHAB AND NURSING | 6969 GLENMEADOW LANE | CINCINNATI | OH | 45237 | 5133517007 | 310 | Hamilton | For profit - Corporation | 120 | 107.6 | Medicare and Medicaid | false | HARMONY COURT REHAB AND NURSING LLC | 03/27/2001 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 2 | 1 | 1 | 2.1166 | 0.78729 | 0.37428 | 1.16157 | 3.27817 | 0.03436 | 2.11412 | 0.84433 | 0.45504 | 3.41349 | 2.08077 | 0.70115 | 0.30958 | 3.07954 | 12/19/2018 | 22 | 20 | 4 | 152 | 1 | 0 | 152 | 11/02/2017 | 19 | 6 | 13 | 183 | 1 | 0 | 183 | 2016-08-04 | 4 | 4 | 0 | 1 | 20 | 0 | 20 | 140.333 | 1 | 8 | 1 | 8388.00 | 1 | 2 | 6969 GLENMEADOW LANE CINCINNATI, OH 45237 (39.187326, -84.468172) | 02/01/2020 | |||||||||||
11562 | 11562 | 6606 CARNEGIE AVE CLEVELAND, OH 44103 | 41.501673 | -81.643935 | 0 | 365879 | CITYVIEW HEALTHCARE AND REHABILITATION | 6606 CARNEGIE AVE | CLEVELAND | OH | 44103 | 2163611414 | 170 | Cuyahoga | For profit - Corporation | 150 | 130.6 | Medicare and Medicaid | false | AJ CITYVIEW NURSING & REHAB OPCO LLC | 04/13/1992 | false | true | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 2 | 2 | 2 | 1.76958 | 0.76252 | 0.31616 | 1.07868 | 2.84826 | 0 | 1.8097 | 0.72353 | 0.36915 | 2.90238 | 2.03226 | 0.79247 | 0.32235 | 3.14686 | 11/01/2018 | 12 | 5 | 8 | 128 | 1 | 0 | 128 | 09/21/2017 | 15 | 7 | 8 | 92 | 1 | 0 | 92 | 2016-08-04 | 7 | 3 | 4 | 1 | 56 | 0 | 56 | 104 | 1 | 13 | 1 | 6633.00 | 0 | 1 | 6606 CARNEGIE AVE CLEVELAND, OH 44103 (41.501673, -81.643935) | 02/01/2020 | |||||||||||
12798 | 12798 | 2502 NC-119, Mebane, NC 27302, USA | 36.048457 | -79.31281 | 1 | ROOFTOP | 345363 | THE PRESBYTERIAN HOME OF HAWFIELDS | 2502 S NC 119 | MEBANE | NC | 27302 | 3365784701 | 0 | Alamance | Non profit - Corporation | 117 | 79 | Medicare and Medicaid | false | PRESBYTERIAN HOME OF HAWFIELDS INC | 04/23/1991 | false | true | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 5 | 3 | 2 | 3.11392 | 0.74814 | 0.39083 | 1.13897 | 4.25289 | 0.0356 | 1.95888 | 0.64906 | 0.31219 | 2.92013 | 3.30381 | 0.86672 | 0.4712 | 4.67019 | 10/25/2018 | 6 | 5 | 1 | 48 | 1 | 0 | 48 | 09/21/2017 | 10 | 6 | 4 | 190 | 1 | 0 | 190 | 2016-08-04 | 3 | 3 | 0 | 1 | 24 | 0 | 24 | 91.333 | 0 | 2 | 2 | 109597.00 | 0 | 2 | 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 );