nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
18 rows where Number of Fines = 2 and Overall Rating Footnote = 18
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Reported Staffing Footnote, Physical Therapist Staffing Footnote, Reported Physical Therapist Staffing Hours per Resident Per Day, 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 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, Number of Facility Reported Incidents, Number of Substantiated Complaints, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1103 | 1103 | 2970 SCARLETT RD WINTER PARK, FL 32792 | 28.597153 | -81.309049 | 0 | 105332 | WINTER PARK CARE & REHABILITATION CENTER | 2970 SCARLETT RD | WINTER PARK | FL | 32792 | 4076718030 | 470 | Orange | For profit - Corporation | 103 | 83.3 | Medicare and Medicaid | false | LP WINTER PARK LLC | 09/25/1978 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.65006 | 0.87989 | 0.72322 | 1.60312 | 4.25317 | 0.03557 | 1.97367 | 0.67882 | 0.30307 | 2.95556 | 2.79059 | 0.97468 | 0.89818 | 4.61452 | 09/26/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 03/20/2019 | 7 | 7 | 0 | 36 | 1 | 0 | 36 | 2018-08-09 | 6 | 6 | 0 | 1 | 24 | 0 | 24 | 18 | 0 | 0 | 2 | 44116.00 | 0 | 2 | 2970 SCARLETT RD WINTER PARK, FL 32792 (28.597153, -81.309049) | 02/01/2020 | ||||||||||
6606 | 6606 | 9350 GREEN PARK ROAD SAINT LOUIS, MO 63123 | 38.524626 | -90.333738 | 0 | 265703 | GREEN PARK SENIOR LIVING COMMUNITY | 9350 GREEN PARK ROAD | SAINT LOUIS | MO | 63123 | 3148450900 | 940 | St. Louis | For profit - Corporation | 188 | 158.8 | Medicare and Medicaid | false | GREEN PARK LEASING CO LLC | 01/21/2000 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.8986 | 0.93923 | 0.42898 | 1.36822 | 3.26681 | 0.02783 | 1.76927 | 0.64017 | 0.2982 | 2.70764 | 2.23025 | 1.10322 | 0.54146 | 3.86889 | 10/11/2019 | 17 | 11 | 10 | 163 | 1 | 0 | 163 | 05/22/2019 | 33 | 30 | 9 | 176 | 1 | 0 | 176 | 2018-09-10 | 26 | 23 | 9 | 1 | 172 | 0 | 172 | 168.833 | 4 | 34 | 2 | 58468.00 | 3 | 5 | 9350 GREEN PARK ROAD SAINT LOUIS, MO 63123 (38.524626, -90.333738) | 02/01/2020 | ||||||||||
6783 | 6783 | 390 SWEAT STREET HOMERVILLE, GA 31634 | 31.042609 | -82.746039 | 0 | 115635 | RIVER BROOK HEALTHCARE CENTER | 390 SWEAT STREET | HOMERVILLE | GA | 31634 | 9124875328 | 281 | Clinch | For profit - Corporation | 92 | 71.6 | Medicare and Medicaid | false | CL SNF LLC | 05/01/1996 | true | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.89746 | 0.96484 | 0.16765 | 1.1325 | 3.02995 | 0.03309 | 2.04843 | 0.76944 | 0.38637 | 3.20423 | 1.92516 | 0.9429 | 0.16332 | 3.03225 | 07/24/2019 | 9 | 7 | 2 | 52 | 1 | 0 | 52 | 07/19/2018 | 6 | 3 | 3 | 36 | 1 | 0 | 36 | 2017-07-20 | 17 | 7 | 10 | 1 | 911 | 0 | 911 | 189.833 | 0 | 12 | 2 | 148506.00 | 1 | 3 | 390 SWEAT STREET HOMERVILLE, GA 31634 (31.042609, -82.746039) | 02/01/2020 | ||||||||||
7305 | 7305 | 1244 TRAVIS BLVD FAIRFIELD, CA 94533 | 38.25822 | -122.047987 | 0 | 56086 | LA MARIPOSA CARE AND REHABILITATION CENTER | 1244 TRAVIS BLVD | FAIRFIELD | CA | 94533 | 7074227750 | 580 | Solano | For profit - Corporation | 99 | 58.5 | Medicare and Medicaid | false | SAGAR, INC. | 08/11/1969 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.37046 | 1.05135 | 0.34796 | 1.39931 | 3.76977 | 0.06392 | 2.09609 | 0.7084 | 0.31827 | 3.12276 | 2.35038 | 1.11597 | 0.41149 | 3.87105 | 06/21/2019 | 11 | 11 | 0 | 60 | 1 | 0 | 60 | 06/15/2018 | 6 | 6 | 0 | 52 | 1 | 0 | 52 | 2018-02-20 | 5 | 4 | 1 | 1 | 24 | 0 | 24 | 51.333 | 0 | 2 | 2 | 16490.00 | 0 | 2 | 1244 TRAVIS BLVD FAIRFIELD, CA 94533 (38.25822, -122.047987) | 02/01/2020 | ||||||||||
8328 | 8328 | 414 E STATE ST BELDING, MI 48809 | 43.08898 | -85.224083 | 0 | 235357 | METRON OF BELDING | 414 E STATE ST | BELDING | MI | 48809 | 6167940460 | 330 | Ionia | For profit - Corporation | 128 | 107.9 | Medicare and Medicaid | false | BELDING CHRISTIAN NURSING HOME, INC | 07/01/1978 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.27042 | 0.42678 | 0.92141 | 1.34819 | 3.61861 | 0.02103 | 1.96371 | 0.62841 | 0.28855 | 2.88066 | 2.40295 | 0.51068 | 1.2019 | 4.02813 | 07/11/2019 | 17 | 9 | 9 | 171 | 1 | 0 | 171 | 06/18/2018 | 55 | 30 | 25 | 2207 | 2 | 1104 | 3311 | 2017-03-23 | 25 | 17 | 12 | 1 | 425 | 0 | 425 | 1260 | 78 | 32 | 2 | 153692.00 | 2 | 4 | 414 E STATE ST BELDING, MI 48809 (43.08898, -85.224083) | 02/01/2020 | ||||||||||
10030 | 10030 | 740 CANONBY PLACE COLUMBUS, OH 43223 | 39.945048 | -83.021548 | 0 | 366313 | SCIOTO POINTE | 740 CANONBY PLACE | COLUMBUS | OH | 43223 | 6142245738 | 250 | Franklin | For profit - Individual | 99 | 88.3 | Medicare and Medicaid | false | LONGTERM LODGING INC | 04/25/2005 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.42998 | 0.97837 | 0.37638 | 1.35476 | 2.78474 | 0.02185 | 1.88899 | 0.81654 | 0.41796 | 3.12349 | 1.57332 | 0.90098 | 0.33894 | 2.85889 | 09/19/2019 | 9 | 8 | 1 | 40 | 1 | 0 | 40 | 11/13/2018 | 11 | 11 | 5 | 568 | 1 | 0 | 568 | 2017-09-21 | 20 | 14 | 6 | 1 | 361 | 0 | 361 | 269.5 | 2 | 3 | 2 | 166166.00 | 0 | 2 | 740 CANONBY PLACE COLUMBUS, OH 43223 (39.945048, -83.021548) | 02/01/2020 | ||||||||||
10361 | 10361 | 1000 WEST PARK AVENUE LOGAN, WV 25601 | 37.84917 | -81.98706 | 0 | 515140 | TRINITY HEALTH CARE OF LOGAN | 1000 WEST PARK AVENUE | LOGAN | WV | 25601 | 3047528723 | 220 | Logan | For profit - Corporation | 120 | 108.3 | Medicare and Medicaid | false | TRINITY HEALTH CARE SERVICES OF LOGAN INC | 01/19/1996 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.09129 | 1.41007 | 0.37681 | 1.78688 | 3.87816 | 0.08853 | 2.01166 | 0.74626 | 0.34875 | 3.10668 | 2.1606 | 1.4208 | 0.40666 | 4.00297 | 03/27/2019 | 8 | 8 | 0 | 28 | 1 | 0 | 28 | 06/12/2018 | 20 | 20 | 0 | 244 | 1 | 0 | 244 | 2017-04-11 | 25 | 25 | 0 | 1 | 426 | 0 | 426 | 166.333 | 0 | 0 | 2 | 483519.00 | 0 | 2 | 1000 WEST PARK AVENUE LOGAN, WV 25601 (37.84917, -81.98706) | 02/01/2020 | ||||||||||
10713 | 10713 | 1 Penn Blvd, Philadelphia, PA 19144, USA | 40.0403868 | -75.1595035 | 1 | ROOFTOP | 396129 | WILLOW TERRACE | ONE PENN BOULEVARD | PHILADELPHIA | PA | 19144 | 2159518500 | 620 | Philadelphia | For profit - Corporation | 174 | 157.5 | Medicare and Medicaid | false | WT OPERATING LLC | 08/13/2010 | true | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.20546 | 1.00255 | 0.40408 | 1.40664 | 3.6121 | 0.06443 | 1.9975 | 0.81605 | 0.4388 | 3.25235 | 2.29471 | 0.92379 | 0.34661 | 3.56135 | 06/19/2019 | 27 | 24 | 5 | 172 | 1 | 0 | 172 | 05/02/2018 | 51 | 32 | 26 | 605 | 2 | 303 | 908 | 2017-03-01 | 9 | 4 | 5 | 1 | 52 | 0 | 52 | 397.333 | 2 | 39 | 2 | 202672.00 | 1 | 3 | 02/01/2020 | ||||||||||
10813 | 10813 | 601 RED VILLAGE ROAD LYNDONVILLE, VT 05851 | 44.513187 | -71.996037 | 0 | 475044 | PINES REHAB & HEALTH CTR | 601 RED VILLAGE ROAD | LYNDONVILLE | VT | 5851 | 8026264304 | 20 | Caledonia | For profit - Partnership | 60 | 51.2 | Medicare and Medicaid | false | PINE KNOLL NURSING HOME, INC | 04/01/1994 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.60587 | 0.72629 | 0.68496 | 1.41125 | 4.01712 | 0.06956 | 2.04606 | 0.77786 | 0.38306 | 3.20699 | 2.64698 | 0.70208 | 0.67302 | 4.01671 | 10/02/2019 | 21 | 9 | 12 | 508 | 1 | 0 | 508 | 04/17/2019 | 3 | 2 | 1 | 16 | 1 | 0 | 16 | 2018-10-10 | 16 | 2 | 14 | 1 | 132 | 0 | 132 | 281.333 | 7 | 18 | 2 | 22358.00 | 0 | 2 | 601 RED VILLAGE ROAD LYNDONVILLE, VT 05851 (44.513187, -71.996037) | 02/01/2020 | ||||||||||
11077 | 11077 | 770 POPLAR CHURCH ROAD CAMP HILL, PA 17011 | 40.257437 | -76.920261 | 0 | 395223 | GARDENS AT WEST SHORE, THE | 770 POPLAR CHURCH ROAD | CAMP HILL | PA | 17011 | 7177637070 | 270 | Cumberland | For profit - Corporation | 309 | 202.2 | Medicare and Medicaid | false | THE MEADOWS AT WEST SHORE FOR NURSING AND REHABILITATION LLC | 12/01/1978 | false | SFF | false | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.87915 | 0.83853 | 0.31944 | 1.15797 | 3.03713 | 0.0662 | 2.03359 | 0.7922 | 0.42105 | 3.24684 | 1.9205 | 0.79592 | 0.28556 | 2.99954 | 10/30/2019 | 27 | 13 | 14 | 140 | 1 | 0 | 140 | 04/12/2019 | 48 | 27 | 48 | 443 | 2 | 222 | 665 | 2018-10-29 | 72 | 24 | 52 | 1 | 599 | 0 | 599 | 391.5 | 3 | 65 | 2 | 70746.00 | 2 | 4 | 770 POPLAR CHURCH ROAD CAMP HILL, PA 17011 (40.257437, -76.920261) | 02/01/2020 | ||||||||||
11269 | 11269 | 104 WATSON ROAD SPRINGFIELD, TN 37172 | 36.483703 | -86.891395 | 0 | 445137 | THE WATERS OF ROBERTSON, LLC | 104 WATSON ROAD | SPRINGFIELD | TN | 37172 | 6153849565 | 730 | Robertson | For profit - Limited Liability company | 120 | 48.6 | Medicare and Medicaid | false | THE WATERS OF ROBERTSON LLC | 10/01/1980 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.71302 | 0.85863 | 0.66223 | 1.52086 | 3.23388 | 0.07801 | 2.45185 | 0.90975 | 0.46299 | 3.82458 | 1.45206 | 0.70969 | 0.53836 | 2.7114 | 03/26/2019 | 12 | 11 | 1 | 678 | 1 | 0 | 678 | 05/09/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-05-09 | 13 | 9 | 4 | 1 | 60 | 0 | 60 | 353 | 4 | 4 | 2 | 173903.00 | 0 | 2 | 104 WATSON ROAD SPRINGFIELD, TN 37172 (36.483703, -86.891395) | 02/01/2020 | ||||||||||
11861 | 11861 | 149 BALLSTON AVENUE BALLSTON SPA, NY 12020 | 42.996735 | -73.8538 | 0 | 335518 | SARATOGA CENTER FOR REHAB & SKILLED NURSING CARE | 149 BALLSTON AVENUE | BALLSTON SPA | NY | 12020 | 5188852288 | 640 | Saratoga | For profit - Corporation | 257 | 163.9 | Medicare and Medicaid | false | SARATOGA CENTER FOR CARE LLC | 07/01/1977 | true | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.74562 | 1.93979 | 0.35398 | 2.29377 | 4.03939 | 0.07627 | 1.79704 | 0.64651 | 0.30147 | 2.74502 | 2.01887 | 2.25612 | 0.44195 | 4.71871 | 11/13/2019 | 11 | 8 | 3 | 48 | 1 | 0 | 48 | 05/13/2019 | 15 | 15 | 3 | 76 | 3 | 53 | 129 | 2018-04-25 | 33 | 13 | 20 | 1 | 541 | 0 | 541 | 157.167 | 3 | 25 | 2 | 158695.00 | 0 | 2 | 149 BALLSTON AVENUE BALLSTON SPA, NY 12020 (42.996735, -73.8538) | 02/01/2020 | ||||||||||
13249 | 13249 | 504 N JOHN REDDITT DR LUFKIN, TX 75904 | 31.336977 | -94.7615 | 0 | 455855 | KENNEDY HEALTH & REHAB | 504 N JOHN REDDITT DR | LUFKIN | TX | 75904 | 9366323331 | 20 | Angelina | For profit - Individual | 145 | 75.4 | Medicare and Medicaid | false | KENNEDY REHABILITATION & HEALTHCARE LLC | 12/05/1989 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 09/17/2019 | 5 | 5 | 0 | 32 | 1 | 0 | 32 | 10/17/2018 | 6 | 4 | 2 | 48 | 1 | 0 | 48 | 2017-11-30 | 41 | 13 | 28 | 1 | 1033 | 0 | 1033 | 204.167 | 14 | 13 | 2 | 172485.00 | 1 | 3 | 504 N JOHN REDDITT DR LUFKIN, TX 75904 (31.336977, -94.7615) | 02/01/2020 | ||||||||||||||||||||||
13271 | 13271 | 4438 PAMPLICO HIGHWAY FLORENCE, SC 29505 | 34.105007 | -79.703537 | 0 | 425119 | COMMANDER NURSING CENTER | 4438 PAMPLICO HIGHWAY | FLORENCE | SC | 29505 | 8436693502 | 200 | Florence | For profit - Corporation | 163 | 139.5 | Medicare and Medicaid | false | COMMANDER HEALTH CARE FACILITIES | 07/01/1978 | false | SFF | false | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.53037 | 1.13205 | 0.5144 | 1.64645 | 4.17682 | 0.01138 | 1.90075 | 0.6448 | 0.27504 | 2.8206 | 2.76679 | 1.32015 | 0.70393 | 4.74852 | 08/29/2019 | 13 | 11 | 2 | 243 | 2 | 122 | 365 | 07/31/2018 | 32 | 30 | 2 | 1492 | 1 | 0 | 1492 | 2017-03-23 | 16 | 16 | 0 | 1 | 92 | 0 | 92 | 695.167 | 1 | 0 | 2 | 115523.00 | 1 | 3 | 4438 PAMPLICO HIGHWAY FLORENCE, SC 29505 (34.105007, -79.703537) | 02/01/2020 | ||||||||||
13397 | 13397 | 801 CANTWELL LN CORPUS CHRISTI, TX 78408 | 27.800022 | -97.447928 | 0 | 675670 | FOCUSED CARE AT CORPUS | 801 CANTWELL LN | CORPUS CHRISTI | TX | 78408 | 3618824284 | 830 | Nueces | For profit - Partnership | 94 | 51.1 | Medicare and Medicaid | false | FPACP CORPUS LLC | 04/01/1997 | false | SFF | false | false | true | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.49359 | 1.19893 | 0.27786 | 1.47679 | 3.97038 | 0.01138 | 2.0183 | 0.78088 | 0.40566 | 3.20484 | 2.56776 | 1.1545 | 0.25781 | 3.97264 | 08/01/2019 | 5 | 5 | 0 | 24 | 1 | 0 | 24 | 02/14/2019 | 13 | 13 | 3 | 92 | 1 | 0 | 92 | 2018-08-31 | 13 | 13 | 1 | 1 | 104 | 0 | 104 | 60 | 5 | 0 | 2 | 100299.00 | 1 | 3 | 801 CANTWELL LN CORPUS CHRISTI, TX 78408 (27.800022, -97.447928) | 02/01/2020 | ||||||||||
13451 | 13451 | 320 NORTH CRAWFORD STREET WILLOWS, CA 95988 | 39.523662 | -122.206029 | 0 | 555151 | WILLOWS CENTER | 320 NORTH CRAWFORD STREET | WILLOWS | CA | 95988 | 5309342834 | 100 | Glenn | For profit - Corporation | 76 | 66.8 | Medicare and Medicaid | false | SUNBRIDGE HEALTHCARE LLC | 10/01/1982 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.4309 | 1.10266 | 0.63274 | 1.73539 | 4.16629 | 0.02378 | 1.88766 | 0.70733 | 0.46685 | 3.06184 | 2.67645 | 1.1722 | 0.51012 | 4.36334 | 06/06/2019 | 11 | 8 | 3 | 56 | 1 | 0 | 56 | 06/14/2018 | 24 | 19 | 5 | 140 | 1 | 0 | 140 | 2017-05-26 | 18 | 4 | 14 | 1 | 616 | 0 | 616 | 177.333 | 8 | 11 | 2 | 91955.00 | 2 | 4 | 320 NORTH CRAWFORD STREET WILLOWS, CA 95988 (39.523662, -122.206029) | 02/01/2020 | ||||||||||
13685 | 13685 | 2400 E Mitchell St, Humboldt, TN 38343, USA | 35.8227245 | -88.9042207 | 1 | ROOFTOP | 445339 | BAILEY PARK CLC | 2400 MITCHELL STREET | HUMBOLDT | TN | 38343 | 7317845183 | 260 | Gibson | For profit - Individual | 50 | 36.1 | Medicare and Medicaid | false | CLC OF HUMBOLDT, LLC | 11/02/1994 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.03168 | 1.29206 | 0.54092 | 1.83298 | 3.86467 | 0.11876 | 2.24378 | 0.79897 | 0.3785 | 3.42124 | 1.88188 | 1.21601 | 0.5379 | 3.62228 | 12/04/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 02/28/2019 | 9 | 9 | 0 | 612 | 1 | 0 | 612 | 2018-04-11 | 5 | 5 | 0 | 1 | 24 | 0 | 24 | 212 | 0 | 0 | 2 | 326998.00 | 1 | 3 | 02/01/2020 | ||||||||||
14286 | 14286 | 6655 FRANKSTOWN AVENUE PITTSBURGH, PA 15206 | 40.459057 | -79.909602 | 0 | 395423 | CORNER VIEW NURSING AND REHABILITATION CENTER | 6655 FRANKSTOWN AVENUE | PITTSBURGH | PA | 15206 | 4126653232 | 10 | Allegheny | For profit - Corporation | 187 | 122.2 | Medicare and Medicaid | false | PENN-ALLEGHENY NURSING AND REHABILITATION CENTER, LLC | 09/01/1978 | true | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.62083 | 0.89523 | 0.52426 | 1.41949 | 4.04032 | 0.0134 | 1.9025 | 0.78413 | 0.52522 | 3.21186 | 2.86305 | 0.85848 | 0.37569 | 4.03378 | 11/08/2019 | 5 | 5 | 0 | 24 | 1 | 0 | 24 | 02/19/2019 | 30 | 22 | 8 | 615 | 2 | 308 | 923 | 2018-03-30 | 39 | 25 | 18 | 2 | 244 | 122 | 366 | 380.667 | 2 | 29 | 2 | 136479.00 | 1 | 3 | 6655 FRANKSTOWN AVENUE PITTSBURGH, PA 15206 (40.459057, -79.909602) | 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 );