nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
8 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2016-11-03
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, Provider Resides in Hospital, Special Focus Status, 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, Reported Staffing Footnote, Physical Therapist Staffing 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 1 Health Deficiency Score, Rating Cycle 1 Total Health 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 Total Health 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 Deficiency Score, Rating Cycle 3 Total Health Score, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3344 | 3344 | 642 NORTH THIRD STREET DANVILLE, KY 40422 | 37.65513 | -84.771573 | 0 | 185127 | DANVILLE CENTRE FOR HEALTH & REHABILITATION | 642 NORTH THIRD STREET | DANVILLE | KY | 40422 | 8592363972 | 100 | Boyle | For profit - Corporation | 106 | 99.7 | Medicare and Medicaid | false | LP DANVILLE, LLC | 10/01/1973 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 1 | 5 | 2 | 2 | 2.13755 | 0.80469 | 0.57152 | 1.37621 | 3.51376 | 0.05264 | 2.20207 | 0.86005 | 0.4594 | 3.52152 | 2.01745 | 0.70354 | 0.46824 | 3.1996 | 04/11/2019 | 7 | 4 | 3 | 40 | 1 | 0 | 40 | 01/18/2018 | 7 | 0 | 7 | 80 | 0 | 0 | 80 | 2016-11-03 | 13 | 3 | 10 | 1 | 716 | 0 | 716 | 166 | 4 | 3 | 2 | 629737.00 | 0 | 2 | 642 NORTH THIRD STREET DANVILLE, KY 40422 (37.65513, -84.771573) | 02/01/2020 | |||||||||||
5168 | 5168 | 100 MEDICAL CENTER DRIVE COMMERCE, GA 30529 | 34.218844 | -83.469196 | 0 | 115714 | NORTHRIDGE HEALTH AND REHABILITATION | 100 MEDICAL CENTER DRIVE | COMMERCE | GA | 30529 | 7063351330 | 610 | Jackson | Non profit - Other | 167 | 149.1 | Medicare and Medicaid | true | RESTORATION HEALTH CARE | 01/01/2006 | false | true | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 4 | 3 | 3 | 2.27519 | 0.87141 | 0.4864 | 1.35781 | 3.633 | 0.04938 | 2.09634 | 0.68826 | 0.29894 | 3.08355 | 2.25565 | 0.95203 | 0.61241 | 3.77805 | 01/10/2019 | 5 | 5 | 0 | 325 | 1 | 0 | 325 | 02/02/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-11-03 | 5 | 5 | 0 | 1 | 24 | 0 | 24 | 166.5 | 0 | 0 | 1 | 110182.00 | 0 | 1 | 100 MEDICAL CENTER DRIVE COMMERCE, GA 30529 (34.218844, -83.469196) | 02/01/2020 | |||||||||||
6300 | 6300 | 404 W WILLOW RD DALE, IN 47523 | 38.177535 | -86.993532 | 0 | 155363 | WILLOWDALE VILLAGE | 404 W WILLOW RD | DALE | IN | 47523 | 8129374489 | 730 | Spencer | Non profit - Corporation | 50 | 28.4 | Medicare and Medicaid | false | THE HEALTH AND HOSPITAL CORPORATION OF MARION COUNTY | 07/02/1990 | false | true | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 2 | 4 | 5 | 2.15191 | 0.56092 | 1.26253 | 1.82345 | 3.97536 | 0.04709 | 2.26913 | 0.79659 | 0.37043 | 3.43615 | 1.97097 | 0.52949 | 1.28283 | 3.70986 | 02/08/2019 | 13 | 13 | 0 | 72 | 1 | 0 | 72 | 01/10/2018 | 8 | 8 | 1 | 56 | 1 | 0 | 56 | 2016-11-03 | 6 | 6 | 0 | 1 | 24 | 0 | 24 | 58.667 | 0 | 1 | 1 | 8125.00 | 0 | 1 | 404 W WILLOW RD DALE, IN 47523 (38.177535, -86.993532) | 02/01/2020 | |||||||||||
6873 | 6873 | 451 NORTH HIGH STREET EAST HAVEN, CT 06512 | 41.292497 | -72.866922 | 0 | 75389 | APPLE REHAB LAUREL WOODS | 451 NORTH HIGH STREET | EAST HAVEN | CT | 6512 | 2034666850 | 40 | New Haven | For profit - Corporation | 120 | 108.6 | Medicare and Medicaid | false | LAUREL WOODS HEALTH CARE CENTER LLC | 10/28/1993 | false | true | false | false | Resident | Yes | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2.11873 | 0.89123 | 0.54867 | 1.4399 | 3.55863 | 0.11923 | 2.09782 | 0.68762 | 0.30972 | 3.09516 | 2.09906 | 0.97459 | 0.66676 | 3.68682 | 11/08/2018 | 2 | 1 | 1 | 8 | 1 | 0 | 8 | 10/13/2017 | 11 | 5 | 6 | 84 | 1 | 0 | 84 | 2016-11-03 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 33.333 | 2 | 2 | 2 | 32999.00 | 0 | 2 | 451 NORTH HIGH STREET EAST HAVEN, CT 06512 (41.292497, -72.866922) | 02/01/2020 | |||||||||||
7845 | 7845 | 1795 MONTEREY RD COLORADO SPRINGS, CO 80910 | 38.806182 | -104.777664 | 0 | 65168 | ASPEN LIVING CENTER | 1795 MONTEREY RD | COLORADO SPRINGS | CO | 80910 | 7194717850 | 200 | El Paso | For profit - Individual | 112 | 82.6 | Medicare and Medicaid | false | SSC COLORADO SPRINGS ASPEN OPERATING COMPANY LLC | 07/01/1982 | false | SFF Candidate | true | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 4 | 4 | 4 | 2.23227 | 0.53922 | 0.69631 | 1.23552 | 3.46779 | 0.05398 | 1.9336 | 0.70753 | 0.33316 | 2.9743 | 2.39936 | 0.57306 | 0.78664 | 3.73871 | 08/01/2019 | 15 | 3 | 12 | 187 | 1 | 0 | 187 | 04/19/2018 | 26 | 23 | 4 | 315 | 1 | 0 | 315 | 2016-11-03 | 9 | 9 | 0 | 1 | 44 | 0 | 44 | 205.833 | 0 | 19 | 2 | 237511.00 | 1 | 3 | 1795 MONTEREY RD COLORADO SPRINGS, CO 80910 (38.806182, -104.777664) | 02/01/2020 | ||||||||||
9476 | 9476 | 581 NEWBERRY HIGHWAY SALUDA, SC 29138 | 34.02135 | -81.768234 | 0 | 425081 | SALUDA NURSING CENTER | 581 NEWBERRY HIGHWAY | SALUDA | SC | 29138 | 8644452146 | 400 | Saluda | Government - County | 176 | 170.9 | Medicare and Medicaid | false | SALUDA NURSING CENTER | 08/16/1971 | false | true | false | false | Resident | Yes | 2 | 2 | 5 | 5 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 03/30/2019 | 5 | 5 | 0 | 72 | 1 | 0 | 72 | 03/01/2018 | 12 | 12 | 0 | 64 | 1 | 0 | 64 | 2016-11-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 57.333 | 0 | 0 | 1 | 27810.00 | 1 | 2 | 581 NEWBERRY HIGHWAY SALUDA, SC 29138 (34.02135, -81.768234) | 02/01/2020 | |||||||||||||||||||||
12740 | 12740 | 5757 WHITEFORD RD SYLVANIA, OH 43560 | 41.719516 | -83.665964 | 0 | 365898 | DIVINE REHABILITATION AND NURSING AT SYLVANIA | 5757 WHITEFORD RD | SYLVANIA | OH | 43560 | 4198821875 | 490 | Lucas | For profit - Corporation | 99 | 83.2 | Medicare and Medicaid | false | MOUNTAIN CREST OH OPCO LLC | 01/01/1993 | false | true | false | false | Resident | Yes | 2 | 2 | 3 | 4 | 2 | 2 | 2 | 1.52969 | 1.15565 | 0.39231 | 1.54796 | 3.07765 | 0.01816 | 1.95039 | 0.72179 | 0.36792 | 3.04011 | 1.63004 | 1.20392 | 0.40133 | 3.24625 | 03/28/2019 | 12 | 7 | 5 | 48 | 1 | 0 | 48 | 02/08/2018 | 17 | 5 | 12 | 88 | 1 | 0 | 88 | 2016-11-03 | 11 | 9 | 2 | 1 | 72 | 0 | 72 | 65.333 | 0 | 8 | 0 | 0.00 | 0 | 0 | 5757 WHITEFORD RD SYLVANIA, OH 43560 (41.719516, -83.665964) | 02/01/2020 | |||||||||||
14081 | 14081 | 710 JULIAN ROAD SALISBURY, NC 28147 | 35.642224 | -80.49383 | 0 | 345286 | SALISBURY CENTER | 710 JULIAN ROAD | SALISBURY | NC | 28147 | 7046365812 | 790 | Rowan | For profit - Corporation | 148 | 128.4 | Medicare and Medicaid | false | 710 JULIAN ROAD OPERATIONS LLC | 08/05/1988 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 1 | 1 | 1 | 2.06498 | 0.90154 | 0.33049 | 1.23203 | 3.29701 | 0.10061 | 1.98796 | 0.78488 | 0.405 | 3.17784 | 2.15885 | 0.86371 | 0.30714 | 3.32692 | 02/14/2019 | 19 | 13 | 9 | 218 | 1 | 0 | 218 | 01/21/2018 | 10 | 9 | 6 | 88 | 1 | 0 | 88 | 2016-11-03 | 7 | 5 | 2 | 1 | 28 | 0 | 28 | 143 | 0 | 14 | 2 | 23770.00 | 0 | 2 | 710 JULIAN ROAD SALISBURY, NC 28147 (35.642224, -80.49383) | 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 );