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-17
This data as json, copyable, CSV (advanced)
Suggested facets: 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, RN Staffing Rating, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Number of Facility Reported Incidents, Number of Substantiated Complaints, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
326 | 326 | 265 MAIN STREET DALTON, MA 01226 | 42.47262 | -73.176943 | 0 | 225455 | CRANEVILLE PLACE REHABILITATION & SKILLED CARE CT | 265 MAIN STREET | DALTON | MA | 1226 | 4136843212 | 10 | Berkshire | For profit - Partnership | 89 | 80.8 | Medicare and Medicaid | false | GAHCR II DALTON SNF TRS SUB LLC | 07/01/1990 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 3 | 2 | 5 | 3 | 3 | 2.12133 | 0.9311 | 0.50322 | 1.43432 | 3.55564 | 0.02431 | 2.05034 | 0.65725 | 0.2995 | 3.00709 | 2.15029 | 1.06525 | 0.63239 | 3.79162 | 04/26/2019 | 21 | 15 | 6 | 514 | 1 | 0 | 514 | 01/29/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2016-11-17 | 1 | 1 | 0 | 1 | 8 | 0 | 8 | 262.333 | 1 | 0 | 1 | 35997.00 | 0 | 1 | 265 MAIN STREET DALTON, MA 01226 (42.47262, -73.176943) | 02/01/2020 | ||||||||||
467 | 467 | 3576 KEARSAGE DRIVE LAKE HAVASU CITY, AZ 86406 | 34.454679 | -114.264775 | 0 | 35100 | HAVASU NURSING CENTER | 3576 KEARSAGE DRIVE | LAKE HAVASU CITY | AZ | 86406 | 9284531500 | 70 | Mohave | For profit - Corporation | 118 | 57.5 | Medicare and Medicaid | false | HAVASU NURSING CENTER #2 INC | 02/28/1985 | false | true | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 3 | 3 | 1.756 | 1.23501 | 0.58193 | 1.81694 | 3.57295 | 0.10787 | 1.87719 | 0.74867 | 0.3622 | 2.98805 | 1.94417 | 1.24041 | 0.60472 | 3.83435 | 02/06/2019 | 7 | 7 | 1 | 56 | 1 | 0 | 56 | 11/02/2017 | 5 | 5 | 1 | 36 | 1 | 0 | 36 | 2016-11-17 | 5 | 5 | 0 | 1 | 24 | 0 | 24 | 44 | 1 | 3 | 1 | 8294.00 | 0 | 1 | 3576 KEARSAGE DRIVE LAKE HAVASU CITY, AZ 86406 (34.454679, -114.264775) | 02/01/2020 | |||||||||||
4335 | 4335 | 2308 OLD HICKS ROAD LONG GROVE, IL 60047 | 42.167594 | -88.018964 | 0 | 145872 | ALDEN LONG GROVE REHAB &HC CTR | 2308 OLD HICKS ROAD | LONG GROVE | IL | 60047 | 8474388275 | 570 | Lake | For profit - Corporation | 246 | 174.9 | Medicare and Medicaid | false | ALDEN-LONG GROVE REHABILITATION AND HEALTH CARE CENTER, INC. | 03/12/1996 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 5 | 2 | 2 | 2 | 1.42515 | 0.54761 | 0.43794 | 0.98555 | 2.41071 | 0.03763 | 2.19898 | 0.72514 | 0.32863 | 3.25276 | 1.34696 | 0.56785 | 0.50157 | 2.37654 | 11/02/2018 | 18 | 12 | 6 | 199 | 1 | 0 | 199 | 10/18/2017 | 6 | 4 | 2 | 44 | 1 | 0 | 44 | 2016-11-17 | 14 | 2 | 12 | 1 | 112 | 0 | 112 | 132.833 | 2 | 15 | 4 | 58215.00 | 0 | 4 | 2308 OLD HICKS ROAD LONG GROVE, IL 60047 (42.167594, -88.018964) | 02/01/2020 | |||||||||||
10529 | 10529 | 400 VISION DRIVE ASHEBORO, NC 27203 | 35.735334 | -79.816023 | 0 | 345277 | WOODLAND HILL CENTER | 400 VISION DRIVE | ASHEBORO | NC | 27203 | 3366725450 | 750 | Randolph | For profit - Corporation | 100 | 86.1 | Medicare and Medicaid | false | 400 VISION DRIVE OPERATIONS LLC | 03/24/1988 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 3 | 2 | 3 | 2 | 2 | 1.98671 | 0.89295 | 0.49178 | 1.38472 | 3.37143 | 0.02329 | 2.12017 | 0.81997 | 0.40738 | 3.34752 | 1.94751 | 0.81887 | 0.45436 | 3.22956 | 01/25/2019 | 22 | 22 | 2 | 317 | 1 | 0 | 317 | 12/01/2017 | 17 | 13 | 5 | 96 | 1 | 0 | 96 | 2016-11-17 | 7 | 7 | 0 | 1 | 40 | 0 | 40 | 197.167 | 4 | 3 | 2 | 98802.00 | 0 | 2 | 400 VISION DRIVE ASHEBORO, NC 27203 (35.735334, -79.816023) | 02/01/2020 | ||||||||||
14554 | 14554 | 2461 SIDNEY ROAD WALTERBORO, SC 29488 | 32.949562 | -80.612836 | 0 | 425386 | VETERANS VICTORY HOUSE | 2461 SIDNEY ROAD | WALTERBORO | SC | 29488 | 8435383000 | 140 | Colleton | Government - State | 220 | 214.3 | Medicare and Medicaid | false | SOUTH CAROLINA DEPT OF MENTAL HEALTH ACCOUNTING OFFICE | 10/03/2007 | false | SFF Candidate | true | false | false | Both | Yes | 2 | 1 | 5 | 5 | 2 | 4 | 4 | 2.61741 | 0.9092 | 0.54051 | 1.44971 | 4.06712 | 0.02195 | 1.83043 | 0.59088 | 0.24755 | 2.66886 | 2.97189 | 1.15704 | 0.82181 | 4.88668 | 05/31/2019 | 7 | 2 | 5 | 104 | 1 | 0 | 104 | 03/02/2018 | 10 | 3 | 7 | 848 | 1 | 0 | 848 | 2016-11-17 | 4 | 4 | 0 | 1 | 20 | 0 | 20 | 338 | 19 | 0 | 1 | 260746.00 | 1 | 2 | 2461 SIDNEY ROAD WALTERBORO, SC 29488 (32.949562, -80.612836) | 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 );