nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
24 rows where Overall Rating = 2 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-03-30
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, Continuing Care Retirement Community, Abuse Icon, With a Resident and Family Council, 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 Physical Therapist 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 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2588 | 2588 | 1220 SOUTH 17TH STREET BIRMINGHAM, AL 35205 | 33.496663 | -86.799773 | 0 | 15097 | SOUTH HEALTH AND REHABILITATION, LLC | 1220 SOUTH 17TH STREET | BIRMINGHAM | AL | 35205 | 2059332180 | 360 | Jefferson | For profit - Corporation | 83 | 68.8 | Medicare and Medicaid | false | SOUTH HEALTH AND REHABILITATION, LLC | 10/01/1976 | false | false | false | false | Resident | Yes | 2 | 2 | 3 | 5 | 2 | 3 | 3 | 2.39484 | 0.9114 | 0.46636 | 1.37776 | 3.7726 | 0.02316 | 1.86365 | 0.66375 | 0.30062 | 2.82802 | 2.67073 | 1.03249 | 0.5839 | 4.27772 | 05/20/2019 | 7 | 2 | 5 | 32 | 1 | 0 | 32 | 05/17/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-03-30 | 10 | 10 | 0 | 1 | 52 | 0 | 52 | 27.333 | 0 | 4 | 0 | 0.00 | 0 | 0 | 1220 SOUTH 17TH STREET BIRMINGHAM, AL 35205 (33.496663, -86.799773) | 02/01/2020 | |||||||||||
2604 | 2604 | Sherman Ln, New Haven, CT 06514, USA | 41.3907368 | -72.917096 | 1 | GEOMETRIC_CENTER | 75366 | HAMDEN REHABILITATION & HEALTH CARE CENTER | 1270 SHERMAN LANE | HAMDEN | CT | 6514 | 2032817555 | 40 | New Haven | For profit - Partnership | 153 | 140.5 | Medicare and Medicaid | false | HAMDEN REHABILITATION LLC | 01/01/1992 | false | false | false | false | Both | Yes | 2 | 2 | 4 | 5 | 3 | 3 | 3 | 2.54929 | 0.84784 | 0.46332 | 1.31117 | 3.86045 | 0.0579 | 2.12273 | 0.67316 | 0.31191 | 3.1078 | 2.49597 | 0.94707 | 0.55909 | 3.98326 | 05/16/2019 | 8 | 8 | 4 | 52 | 1 | 0 | 52 | 04/23/2018 | 5 | 5 | 4 | 48 | 2 | 24 | 72 | 2017-03-30 | 10 | 10 | 9 | 1 | 32 | 0 | 32 | 55.333 | 3 | 8 | 2 | 27999.00 | 0 | 2 | 02/01/2020 | |||||||||||
3956 | 3956 | 21 MAEFAIR COURT TRUMBULL, CT 06611 | 41.236378 | -73.194834 | 0 | 75404 | MAEFAIR HEALTH CARE CENTER | 21 MAEFAIR COURT | TRUMBULL | CT | 6611 | 2034595152 | 0 | Fairfield | For profit - Corporation | 134 | 127.9 | Medicare and Medicaid | false | MAEFAIR HEALTH CARE CENTER INC | 05/04/1994 | false | false | false | false | Both | Yes | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2.18785 | 1.00018 | 0.31667 | 1.31685 | 3.5047 | 0.11584 | 2.13314 | 0.67709 | 0.31056 | 3.12078 | 2.13164 | 1.11076 | 0.38379 | 3.60115 | 03/21/2019 | 7 | 4 | 7 | 32 | 1 | 0 | 32 | 02/09/2018 | 9 | 4 | 6 | 111 | 1 | 0 | 111 | 2017-03-30 | 7 | 7 | 1 | 1 | 40 | 0 | 40 | 59.667 | 2 | 2 | 1 | 11700.00 | 0 | 1 | 21 MAEFAIR COURT TRUMBULL, CT 06611 (41.236378, -73.194834) | 02/01/2020 | |||||||||||
4653 | 4653 | 1907 CHINABERRY STREET FRANKLIN, LA 70538 | 29.790725 | -91.521718 | 0 | 195388 | FRANKLIN HEALTH CARE CENTER | 1907 CHINABERRY STREET | FRANKLIN | LA | 70538 | 3378281918 | 500 | St. Mary | For profit - Limited Liability company | 152 | 110 | Medicare and Medicaid | false | PINNACLE HEALTH FACILITIES OF LOUISIANA, LLC | 10/01/1996 | false | false | false | false | Resident | Yes | 2 | 3 | 2 | 4 | 1 | 1 | 1 | 2.14696 | 0.85716 | 0.24468 | 1.10183 | 3.24879 | 0.05349 | 1.94592 | 0.70274 | 0.32972 | 2.97838 | 2.29306 | 0.91717 | 0.2793 | 3.49781 | 04/04/2019 | 3 | 1 | 2 | 32 | 1 | 0 | 32 | 05/17/2018 | 2 | 2 | 0 | 16 | 1 | 0 | 16 | 2017-03-30 | 5 | 5 | 0 | 1 | 32 | 0 | 32 | 26.667 | 0 | 4 | 1 | 7027.00 | 0 | 1 | 1907 CHINABERRY STREET FRANKLIN, LA 70538 (29.790725, -91.521718) | 02/01/2020 | |||||||||||
5100 | 5100 | 804 WOLLARD BLVD RICHMOND, MO 64085 | 39.266087 | -93.957234 | 0 | 265708 | SHIRKEY NURSING AND REHABILITATION CENTER | 804 WOLLARD BLVD | RICHMOND | MO | 64085 | 8167765403 | 880 | Ray | Non profit - Other | 197 | 136.3 | Medicare and Medicaid | false | SENIOR CITIZENS NURSING HOME DISTRICT OF RAY COUNTY | 10/01/2000 | false | false | false | false | Resident | Yes | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2.76887 | 0.85328 | 0.15693 | 1.01021 | 3.77907 | 0 | 1.86445 | 0.62987 | 0.28262 | 2.77694 | 3.0865 | 1.01865 | 0.20899 | 4.36386 | 03/06/2019 | 11 | 11 | 0 | 72 | 2 | 36 | 108 | 03/22/2018 | 9 | 9 | 0 | 56 | 1 | 0 | 56 | 2017-03-30 | 8 | 7 | 1 | 1 | 36 | 0 | 36 | 78.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 804 WOLLARD BLVD RICHMOND, MO 64085 (39.266087, -93.957234) | 02/01/2020 | |||||||||||
5249 | 5249 | 301 ROPE FERRY RD WATERFORD, CT 06385 | 41.327443 | -72.165413 | 0 | 75324 | BAYVIEW HEALTH CARE | 301 ROPE FERRY RD | WATERFORD | CT | 6385 | 8604441175 | 50 | New London | For profit - Corporation | 127 | 122.4 | Medicare and Medicaid | false | 301 ROPE FERRY ROAD, LLC | 07/29/1989 | false | false | false | false | Both | Yes | 2 | 3 | 2 | 2 | 3 | 1 | 12 | 1 | 12 | 1.40457 | 0.42504 | 0.31381 | 0.73885 | 2.14342 | 0.06064 | 2.17424 | 0.70057 | 0.3265 | 3.20131 | 1.34261 | 0.45621 | 0.36175 | 2.147 | 05/09/2019 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 03/21/2018 | 8 | 6 | 2 | 28 | 1 | 0 | 28 | 2017-03-30 | 8 | 4 | 5 | 1 | 52 | 0 | 52 | 28 | 2 | 2 | 1 | 3535.00 | 0 | 1 | 301 ROPE FERRY RD WATERFORD, CT 06385 (41.327443, -72.165413) | 02/01/2020 | |||||||||
7426 | 7426 | 4783 FRUITVILLE ROAD SARASOTA, FL 34232 | 27.337965 | -82.472784 | 0 | 105983 | CONSULATE HEALTH CARE OF SARASOTA | 4783 FRUITVILLE ROAD | SARASOTA | FL | 34232 | 9413788000 | 570 | Sarasota | For profit - Corporation | 81 | 74.2 | Medicare and Medicaid | false | SARASOTA FACILITY OPERATIONS LLC | 02/18/1998 | false | false | false | false | Resident | Yes | 2 | 1 | 3 | 4 | 2 | 4 | 3 | 2.55679 | 0.90881 | 0.58228 | 1.49109 | 4.04787 | 0.02968 | 1.9537 | 0.67365 | 0.30803 | 2.93538 | 2.7199 | 1.01443 | 0.71149 | 4.42197 | 05/16/2019 | 12 | 12 | 0 | 88 | 1 | 0 | 88 | 04/05/2018 | 8 | 8 | 0 | 68 | 1 | 0 | 68 | 2017-03-30 | 6 | 5 | 1 | 1 | 28 | 0 | 28 | 71.333 | 0 | 2 | 1 | 7904.00 | 0 | 1 | 4783 FRUITVILLE ROAD SARASOTA, FL 34232 (27.337965, -82.472784) | 02/01/2020 | |||||||||||
7616 | 7616 | 216 COLLEGE BOULEVARD CARMI, IL 62821 | 38.081162 | -88.171034 | 0 | 146019 | WABASH CHRISTIAN RETIREMENT | 216 COLLEGE BOULEVARD | CARMI | IL | 62821 | 6183824644 | 987 | White | Non profit - Corporation | 156 | 124.9 | Medicare and Medicaid | false | MIDWEST CHRISTIAN VILLAGES, INC | 12/21/2001 | false | true | false | false | Resident | Yes | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 2.19802 | 0.65031 | 0.63367 | 1.28398 | 3.48201 | 0.0763 | 2.14572 | 0.7919 | 0.40922 | 3.34684 | 2.129 | 0.6175 | 0.58283 | 3.33617 | 05/16/2019 | 6 | 1 | 5 | 28 | 1 | 0 | 28 | 04/12/2018 | 4 | 0 | 4 | 16 | 0 | 0 | 16 | 2017-03-30 | 2 | 2 | 0 | 1 | 32 | 0 | 32 | 24.667 | 0 | 2 | 0 | 0.00 | 0 | 0 | 216 COLLEGE BOULEVARD CARMI, IL 62821 (38.081162, -88.171034) | 02/01/2020 | |||||||||||
8135 | 8135 | 1 ABRAHMS BLVD WEST HARTFORD, CT 06117 | 41.802774 | -72.728931 | 0 | 75109 | HEBREW CENTER FOR HEALTH AND REHABILITATION | 1 ABRAHMS BLVD | WEST HARTFORD | CT | 6117 | 8605233800 | 10 | Hartford | For profit - Corporation | 257 | 219.8 | Medicare and Medicaid | false | HEBREW HOME FOR HEALTH AND REHABILITATION LLC | 01/01/1967 | false | true | false | false | Both | Yes | 2 | 1 | 5 | 5 | 4 | 3 | 3 | 2.19379 | 0.78723 | 0.53056 | 1.31779 | 3.51159 | 0.05699 | 2.10509 | 0.66216 | 0.30662 | 3.07386 | 2.16591 | 0.89397 | 0.65129 | 3.6633 | 05/09/2019 | 13 | 9 | 5 | 68 | 1 | 0 | 68 | 03/20/2018 | 18 | 16 | 11 | 84 | 1 | 0 | 84 | 2017-03-30 | 4 | 2 | 2 | 1 | 28 | 0 | 28 | 66.667 | 4 | 11 | 0 | 0.00 | 0 | 0 | 1 ABRAHMS BLVD WEST HARTFORD, CT 06117 (41.802774, -72.728931) | 02/01/2020 | |||||||||||
8247 | 8247 | 11188 FLORIDA BLVD BATON ROUGE, LA 70815 | 30.458235 | -91.060522 | 0 | 195537 | CARE CENTER THE | 11188 FLORIDA BLVD | BATON ROUGE | LA | 70815 | 2252757570 | 160 | E. Baton Rouge | For profit - Corporation | 104 | 79.1 | Medicare and Medicaid | false | STT CORPORATION | 02/13/2002 | false | false | false | false | Resident | Yes | 2 | 3 | 2 | 4 | 1 | 1 | 1 | 1.80772 | 1.20608 | 0.164 | 1.37009 | 3.1778 | 0.07699 | 2.11347 | 0.76823 | 0.34029 | 3.22199 | 1.77767 | 1.18051 | 0.1814 | 3.16268 | 02/28/2019 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 03/08/2018 | 7 | 4 | 3 | 36 | 1 | 0 | 36 | 2017-03-30 | 4 | 4 | 0 | 1 | 28 | 0 | 28 | 22.667 | 0 | 3 | 0 | 0.00 | 0 | 0 | 11188 FLORIDA BLVD BATON ROUGE, LA 70815 (30.458235, -91.060522) | 02/01/2020 | |||||||||||
8287 | 8287 | 194 BOARDMAN STREET HAVERHILL, MA 01830 | 42.771787 | -71.059096 | 0 | 225743 | BAKER-KATZ SKILLED NURSING AND REHABILITATION CTR | 194 BOARDMAN STREET | HAVERHILL | MA | 1830 | 9783735697 | 40 | Essex | For profit - Corporation | 77 | 46.4 | Medicare and Medicaid | false | BILLERICA HEALTHCARE SOLUTIONS LLC | 09/01/1998 | false | false | false | false | Resident | Yes | 2 | 3 | 1 | 1 | 2 | 2 | 2 | 2.05667 | 0.78115 | 0.37834 | 1.15948 | 3.21615 | 0.02046 | 2.00319 | 0.68548 | 0.29945 | 2.98812 | 2.13382 | 0.85689 | 0.47553 | 3.45137 | 06/11/2019 | 5 | 5 | 0 | 16 | 1 | 0 | 16 | 05/24/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-03-30 | 14 | 14 | 0 | 2 | 80 | 40 | 120 | 28 | 0 | 0 | 1 | 38464.00 | 0 | 1 | 194 BOARDMAN STREET HAVERHILL, MA 01830 (42.771787, -71.059096) | 02/01/2020 | |||||||||||
8675 | 8675 | 119 BRICKYARD DRIVE DILLWYN, VA 23936 | 37.543825 | -78.465773 | 0 | 495317 | HERITAGE HALL DILLWYN | 119 BRICKYARD DRIVE | DILLWYN | VA | 23936 | 4349832050 | 140 | Buckingham | For profit - Corporation | 60 | 57.1 | Medicare and Medicaid | false | DILLWYN LIFE CARE, LLC | 12/04/1996 | false | false | false | false | Resident | Yes | 2 | 3 | 4 | 4 | 4 | 1 | 1 | 2.00335 | 0.76676 | 0.27054 | 1.0373 | 3.04065 | 0 | 2.13769 | 0.79999 | 0.39087 | 3.32855 | 1.94773 | 0.72071 | 0.26051 | 2.9293 | 06/27/2019 | 12 | 11 | 1 | 68 | 1 | 0 | 68 | 05/11/2018 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 2017-03-30 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 42.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 119 BRICKYARD DRIVE DILLWYN, VA 23936 (37.543825, -78.465773) | 02/01/2020 | |||||||||||
9189 | 9189 | 2550 ZACATECAS DR EAGLE PASS, TX 78852 | 28.715142 | -100.478561 | 0 | 675617 | EAGLE PASS NURSING AND REHABILITATION | 2550 ZACATECAS DR | EAGLE PASS | TX | 78852 | 8307734488 | 791 | Maverick | For profit - Individual | 114 | 63.7 | Medicare and Medicaid | false | EAGLE PASS I ENTERPRISES LLC | 08/01/1996 | false | false | false | false | Both | Yes | 2 | 3 | 3 | 2 | 3 | 1 | 1 | 2.05925 | 1.28658 | 0.1443 | 1.43088 | 3.49013 | 0.09255 | 2.25019 | 0.8742 | 0.46182 | 3.5862 | 1.90198 | 1.10665 | 0.11761 | 3.12076 | 03/22/2019 | 6 | 6 | 1 | 52 | 1 | 0 | 52 | 04/13/2018 | 9 | 6 | 3 | 56 | 1 | 0 | 56 | 2017-03-30 | 1 | 1 | 0 | 1 | 8 | 0 | 8 | 46 | 1 | 0 | 0 | 0.00 | 0 | 0 | 2550 ZACATECAS DR EAGLE PASS, TX 78852 (28.715142, -100.478561) | 02/01/2020 | |||||||||||
9881 | 9881 | 1171 TOWNE STREET CINCINNATI, OH 45216 | 39.183147 | -84.478344 | 0 | 366209 | WOODS EDGE REHAB AND NURSING | 1171 TOWNE STREET | CINCINNATI | OH | 45216 | 5132421360 | 310 | Hamilton | For profit - Individual | 93 | 88.9 | Medicare and Medicaid | false | WOODS EDGE REHAB AND NURSING LLC | 01/03/2001 | false | false | false | false | Resident | Yes | 2 | 2 | 5 | 5 | 2 | 1 | 1 | 2.23817 | 0.78266 | 0.3578 | 1.14046 | 3.37863 | 0.02247 | 1.98702 | 0.79803 | 0.43441 | 3.21945 | 2.34104 | 0.73746 | 0.31001 | 3.36521 | 06/13/2019 | 13 | 12 | 1 | 56 | 1 | 0 | 56 | 05/17/2018 | 16 | 13 | 3 | 76 | 1 | 0 | 76 | 2017-03-30 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 55.333 | 1 | 1 | 0 | 0.00 | 0 | 0 | 1171 TOWNE STREET CINCINNATI, OH 45216 (39.183147, -84.478344) | 02/01/2020 | |||||||||||
10391 | 10391 | 10450 GOSLING RD THE WOODLANDS, TX 77381 | 30.170554 | -95.503785 | 0 | 675739 | REGENT CARE CENTER OF THE WOODLANDS LIMITED PARTNE | 10450 GOSLING RD | THE WOODLANDS | TX | 77381 | 2812969234 | 801 | Montgomery | For profit - Corporation | 156 | 102.1 | Medicare and Medicaid | false | REGENT CARE CENTER OF THE WOODLANDS,LP | 01/06/1998 | false | false | false | false | Resident | Yes | 2 | 3 | 2 | 2 | 2 | 1 | 1 | 2.07333 | 0.93034 | 0.19005 | 1.1204 | 3.19373 | 0.06029 | 2.08716 | 0.79642 | 0.3982 | 3.28178 | 2.06456 | 0.87839 | 0.17964 | 3.12062 | 03/08/2019 | 3 | 2 | 1 | 16 | 1 | 0 | 16 | 03/02/2018 | 8 | 5 | 4 | 68 | 1 | 0 | 68 | 2017-03-30 | 7 | 6 | 1 | 1 | 72 | 0 | 72 | 42.667 | 3 | 17 | 0 | 0.00 | 0 | 0 | 10450 GOSLING RD THE WOODLANDS, TX 77381 (30.170554, -95.503785) | 02/01/2020 | |||||||||||
10799 | 10799 | 462 KENMORE DRIVE DANVILLE, WV 25053 | 38.083643 | -81.841785 | 0 | 515117 | HILLCREST HEALTH CARE CENTER | 462 KENMORE DRIVE | DANVILLE | WV | 25053 | 3043690986 | 20 | Boone | For profit - Limited Liability company | 90 | 84.8 | Medicare and Medicaid | false | HILLCREST HEALTH CARE CENTER LLC | 07/01/1992 | false | false | false | false | Resident | Yes | 2 | 3 | 1 | 2 | 1 | 3 | 3 | 2.13397 | 0.93265 | 0.8017 | 1.73434 | 3.86831 | 0.02377 | 2.11276 | 0.83672 | 0.4495 | 3.39898 | 2.0992 | 0.83815 | 0.67129 | 3.64943 | 05/15/2019 | 10 | 10 | 0 | 64 | 1 | 0 | 64 | 05/24/2018 | 16 | 16 | 0 | 84 | 1 | 0 | 84 | 2017-03-30 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 63.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 462 KENMORE DRIVE DANVILLE, WV 25053 (38.083643, -81.841785) | 02/01/2020 | |||||||||||
10958 | 10958 | 17 FORRY STREET NEWARK, OH 43055 | 40.046911 | -82.420349 | 0 | 366196 | ALTERCARE NEWARK SOUTH INC. | 17 FORRY STREET | NEWARK | OH | 43055 | 7403498175 | 460 | Licking | For profit - Corporation | 48 | 39.1 | Medicare and Medicaid | false | ALTERCARE NEWARK SOUTH INC | 04/25/2000 | false | false | false | false | Both | Yes | 2 | 2 | 4 | 3 | 5 | 2 | 3 | 1.91217 | 0.69708 | 0.74416 | 1.44124 | 3.35341 | 0.04511 | 2.1497 | 0.8729 | 0.47419 | 3.49679 | 1.84869 | 0.60049 | 0.59066 | 3.07518 | 02/21/2019 | 11 | 10 | 1 | 68 | 1 | 0 | 68 | 01/05/2018 | 18 | 17 | 1 | 108 | 1 | 0 | 108 | 2017-03-30 | 8 | 7 | 1 | 1 | 56 | 0 | 56 | 79.333 | 0 | 3 | 0 | 0.00 | 0 | 0 | 17 FORRY STREET NEWARK, OH 43055 (40.046911, -82.420349) | 02/01/2020 | |||||||||||
11606 | 11606 | 3364 KOLBE RD LORAIN, OH 44053 | 41.43925 | -82.235345 | 0 | 365623 | LAKE POINTE HEALTH CARE | 3364 KOLBE RD | LORAIN | OH | 44053 | 4402822244 | 480 | Lorain | For profit - Corporation | 99 | 80.8 | Medicare and Medicaid | false | KOLBE LEASING CO, LLC | 06/06/1984 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 4 | 3 | 2 | 2 | 1.89375 | 0.84562 | 0.46489 | 1.31051 | 3.20426 | 0.0566 | 2.17202 | 0.88449 | 0.45662 | 3.51314 | 1.81207 | 0.71889 | 0.3832 | 2.92472 | 06/06/2019 | 5 | 3 | 2 | 32 | 1 | 0 | 32 | 05/03/2018 | 18 | 9 | 9 | 136 | 1 | 0 | 136 | 2017-03-30 | 10 | 3 | 7 | 1 | 72 | 0 | 72 | 73.333 | 0 | 10 | 0 | 0.00 | 1 | 1 | 3364 KOLBE RD LORAIN, OH 44053 (41.43925, -82.235345) | 02/01/2020 | |||||||||||
12750 | 12750 | 1036 SOUTH PERRY STREET NAPOLEON, OH 43545 | 41.37942 | -84.12061 | 0 | 366162 | LUTHERAN HOME | 1036 SOUTH PERRY STREET | NAPOLEON | OH | 43545 | 4195921688 | 360 | Henry | Non profit - Church related | 80 | 70.7 | Medicare and Medicaid | false | LUTHERAN HOMES SOCIETY, INC. | 10/09/1998 | true | false | false | false | Both | Yes | 2 | 2 | 4 | 3 | 5 | 3 | 3 | 1.8982 | 0.88195 | 0.49159 | 1.37354 | 3.27174 | 0 | 2.12657 | 0.71899 | 0.34461 | 3.19017 | 1.85514 | 0.92237 | 0.53692 | 3.28866 | 07/25/2019 | 18 | 18 | 0 | 92 | 1 | 0 | 92 | 06/21/2018 | 1 | 0 | 1 | 4 | 0 | 0 | 4 | 2017-03-30 | 2 | 0 | 2 | 0 | 8 | 0 | 8 | 48.667 | 0 | 2 | 0 | 0.00 | 0 | 0 | 1036 SOUTH PERRY STREET NAPOLEON, OH 43545 (41.37942, -84.12061) | 02/01/2020 | |||||||||||
12912 | 12912 | 22822 MYRTLE STREET HAYWARD, CA 94541 | 37.665668 | -122.091388 | 0 | 555905 | ST CHRISTOPHER CONVALESCENT HOSPITAL | 22822 MYRTLE STREET | HAYWARD | CA | 94541 | 5105374844 | 0 | Alameda | For profit - Corporation | 36 | 33.2 | Medicare and Medicaid | false | Legal Business Name Not Available | 05/16/2017 | false | false | false | false | Resident | Yes | 2 | 3 | 4 | 4 | 4 | 1 | 12 | 1 | 12 | 2.63746 | 0.96536 | 0.29048 | 1.25584 | 3.89329 | 0.14896 | 1.96338 | 0.71582 | 0.30653 | 2.98573 | 2.79188 | 1.01407 | 0.35667 | 4.18138 | 05/23/2019 | 9 | 8 | 1 | 60 | 1 | 0 | 60 | 04/13/2018 | 11 | 9 | 2 | 48 | 1 | 0 | 48 | 2017-03-30 | 7 | 7 | 0 | 1 | 48 | 0 | 48 | 54 | 1 | 3 | 1 | 9955.00 | 0 | 1 | 22822 MYRTLE STREET HAYWARD, CA 94541 (37.665668, -122.091388) | 02/01/2020 | |||||||||
13890 | 13890 | South Mountain, PA, USA | 39.8465059 | -77.4901975 | 1 | APPROXIMATE | 395583 | SOUTH MOUNTAIN RESTORATION CEN | BUILDING #1 | SOUTH MOUNTAIN | PA | 17261 | 7177493121 | 350 | Franklin | Government - State | 159 | 134.2 | Medicare and Medicaid | false | PENNSYLVANIA DEPARTMENT OF HUMAN SERVICES | 07/01/1985 | false | false | false | false | Both | Yes | 2 | 1 | 4 | 4 | 2 | 5 | 5 | 2.36184 | 0.96438 | 1.01733 | 1.98172 | 4.34356 | 0.03726 | 1.99816 | 0.62003 | 0.26629 | 2.88448 | 2.45661 | 1.16955 | 1.43795 | 4.82871 | 02/07/2019 | 24 | 22 | 6 | 112 | 1 | 0 | 112 | 03/15/2018 | 9 | 9 | 0 | 44 | 1 | 0 | 44 | 2017-03-30 | 19 | 14 | 5 | 2 | 225 | 113 | 338 | 127 | 2 | 5 | 1 | 9899.00 | 0 | 1 | 02/01/2020 | |||||||||||
13999 | 13999 | 1211 W MARKET ST AKRON, OH 44313 | 41.101909 | -81.553525 | 0 | 365316 | AKRON HEALTHCARE | 1211 W MARKET ST | AKRON | OH | 44313 | 3308678530 | 780 | Summit | For profit - Corporation | 117 | 97.3 | Medicare and Medicaid | false | AKRON HEALTHCARE LLC | 12/06/1974 | false | false | false | false | Both | Yes | 2 | 1 | 5 | 4 | 5 | 2 | 2 | 2.26974 | 0.90169 | 0.56753 | 1.46922 | 3.73895 | 0.04774 | 2.04208 | 0.82134 | 0.43021 | 3.29363 | 2.31004 | 0.8255 | 0.49651 | 3.64022 | 06/06/2019 | 34 | 13 | 23 | 252 | 1 | 0 | 252 | 04/19/2018 | 15 | 4 | 11 | 128 | 1 | 0 | 128 | 2017-03-30 | 13 | 5 | 9 | 1 | 76 | 0 | 76 | 181.333 | 0 | 39 | 0 | 0.00 | 1 | 1 | 1211 W MARKET ST AKRON, OH 44313 (41.101909, -81.553525) | 02/01/2020 | |||||||||||
14214 | 14214 | 250 BISHOP LANE CONCORD, NC 28025 | 35.453148 | -80.604426 | 0 | 345362 | BRIAN CENTER HEALTH & RETIREMENT/CABARRUS | 250 BISHOP LANE | CONCORD | NC | 28025 | 7047886400 | 120 | Cabarrus | For profit - Corporation | 90 | 80.2 | Medicare and Medicaid | false | SSC CONCORD OPERATING COMPANY LLC | 04/30/1991 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 4 | 4 | 2 | 2 | 2.04033 | 1.05432 | 0.63933 | 1.69365 | 3.73398 | 0.20462 | 2.15722 | 0.90142 | 0.49662 | 3.55526 | 1.96573 | 0.87949 | 0.48454 | 3.36786 | 03/28/2019 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 04/19/2018 | 5 | 3 | 2 | 137 | 1 | 0 | 137 | 2017-03-30 | 2 | 1 | 1 | 1 | 16 | 0 | 16 | 48.333 | 0 | 0 | 1 | 57389.00 | 1 | 2 | 250 BISHOP LANE CONCORD, NC 28025 (35.453148, -80.604426) | 02/01/2020 | |||||||||||
14929 | 14929 | 31054 OH-93, McArthur, OH 45651, USA | 39.2732849 | -82.46931029999999 | 1 | ROOFTOP | 366139 | MAPLE HILLS SKILLED NURSING & REHABILITATION | 31054 STATE ROUTE 93 NORTH | MCARTHUR | OH | 45651 | 7405965955 | 830 | Vinton | For profit - Corporation | 42 | 32.6 | Medicare and Medicaid | false | MAPLE HILLS NURSING & REHABILITATION, INC. | 06/11/1997 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 4 | 4 | 3 | 3 | 2.1536 | 0.68806 | 0.636 | 1.32406 | 3.47766 | 0.01071 | 2.00203 | 0.77825 | 0.40526 | 3.18554 | 2.23569 | 0.66481 | 0.59068 | 3.50072 | 07/31/2019 | 13 | 13 | 0 | 96 | 1 | 0 | 96 | 06/07/2018 | 7 | 7 | 0 | 32 | 1 | 0 | 32 | 2017-03-30 | 6 | 4 | 2 | 1 | 56 | 0 | 56 | 68 | 0 | 1 | 0 | 0.00 | 0 | 0 | 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 );