nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
28 rows where Overall Rating = 4 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-04-27
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, prvdr_cnty, ownership, nmbr_beds, prvdr_type, Provider Resides in Hospital, Date First Approved to Provide Medicare and Medicaid services, 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 Staffing Footnote, Physical Therapist Staffing Footnote, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
364 | 364 | 7300 OLEANDER AVE PORT SAINT LUCIE, FL 34952 | 27.34231 | -80.334048 | 0 | 105410 | PORT ST LUCIE REHABILITATION AND HEALTHCARE | 7300 OLEANDER AVE | PORT SAINT LUCIE | FL | 34952 | 5614664100 | 550 | St. Lucie | For profit - Limited Liability company | 180 | 125.6 | Medicare and Medicaid | false | PSL REHABILITATION AND HEALTHCARE LLC | 07/19/1982 | false | false | false | false | Resident | Yes | 4 | 3 | 4 | 3 | 4 | 5 | 5 | 2.90235 | 0.67064 | 1.00191 | 1.67255 | 4.5749 | 0.04561 | 2.08743 | 0.70806 | 0.32912 | 3.1246 | 2.88971 | 0.71221 | 1.14579 | 4.69505 | 07/11/2019 | 8 | 6 | 2 | 44 | 1 | 0 | 44 | 05/25/2018 | 3 | 2 | 1 | 16 | 1 | 0 | 16 | 2017-04-27 | 5 | 4 | 1 | 1 | 32 | 0 | 32 | 32.667 | 0 | 4 | 0 | 0.00 | 0 | 0 | 7300 OLEANDER AVE PORT SAINT LUCIE, FL 34952 (27.34231, -80.334048) | 02/01/2020 | |||||||||||
504 | 504 | 445 S VALLEY ST WEST BRANCH, MI 48661 | 44.272658 | -84.230672 | 0 | 235414 | THE VILLA AT WEST BRANCH | 445 S VALLEY ST | WEST BRANCH | MI | 48661 | 9893453600 | 640 | Ogemaw | For profit - Corporation | 70 | 62.4 | Medicare and Medicaid | false | WEST BRANCH OPCO LLC | 07/01/1981 | false | false | false | false | Resident | Yes | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 2.19819 | 0.6454 | 0.76058 | 1.40597 | 3.60416 | 0.08039 | 2.07834 | 0.7377 | 0.34154 | 3.15758 | 2.19819 | 0.65785 | 0.83818 | 3.66019 | 06/20/2019 | 18 | 14 | 4 | 128 | 1 | 0 | 128 | 07/25/2018 | 5 | 5 | 0 | 28 | 1 | 0 | 28 | 2017-04-27 | 2 | 1 | 1 | 1 | 12 | 0 | 12 | 75.333 | 4 | 3 | 0 | 0.00 | 1 | 1 | 445 S VALLEY ST WEST BRANCH, MI 48661 (44.272658, -84.230672) | 02/01/2020 | |||||||||||
1194 | 1194 | 1 MYRTLE LANE HARDIN, IL 62047 | 39.15858 | -90.624563 | 0 | 145910 | CALHOUN NURSING & REHAB CENTER | #1 MYRTLE LANE | HARDIN | IL | 62047 | 6185762278 | 60 | Calhoun | For profit - Limited Liability company | 80 | 73.1 | Medicare and Medicaid | false | CALHOUN NURSING AND REHABILITATION CENTER, LLC | 09/26/1996 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 5 | 2 | 2 | 3 | 1.51048 | 0.63782 | 0.6256 | 1.26342 | 2.7739 | 0.07532 | 2.20043 | 0.74356 | 0.35252 | 3.29651 | 1.42667 | 0.64501 | 0.66794 | 2.69829 | 08/02/2019 | 3 | 3 | 0 | 28 | 1 | 0 | 28 | 05/07/2018 | 4 | 4 | 0 | 24 | 1 | 0 | 24 | 2017-04-27 | 7 | 6 | 1 | 1 | 44 | 0 | 44 | 29.333 | 0 | 2 | 1 | 2013.00 | 0 | 1 | 1 MYRTLE LANE HARDIN, IL 62047 (39.15858, -90.624563) | 02/01/2020 | |||||||||||
1663 | 1663 | 176 SOUTH MAIN STREET PONTOTOC, MS 38863 | 34.242827 | -88.9968 | 0 | 25A380 | PONTOTOC NURSING HOME | 176 SOUTH MAIN STREET | PONTOTOC | MS | 38863 | 6624895510 | 570 | Pontotoc | Non profit - Corporation | 44 | 43.1 | Medicaid | true | Legal Business Name Not Available | 09/30/1996 | false | false | false | false | Resident | Yes | 4 | 5 | 1 | 1 | 2 | 5 | 5 | 2.43181 | 0.68736 | 0.791 | 1.47836 | 3.91017 | 0.00328 | 2.03619 | 0.64664 | 0.27561 | 2.95845 | 2.48215 | 0.79928 | 1.08021 | 4.23823 | 09/05/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 08/16/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-04-27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0.00 | 0 | 0 | 176 SOUTH MAIN STREET PONTOTOC, MS 38863 (34.242827, -88.9968) | 02/01/2020 | |||||||||||
2603 | 2603 | 6456 LYNCHS PRAIRIE COVE SPRINGDALE, AR 72762 | 36.177649 | -94.203058 | 0 | 45407 | THE MAPLES AT HAR-BER MEADOWS | 6456 LYNCHS PRAIRIE COVE | SPRINGDALE | AR | 72762 | 4793614669 | 710 | Washington | For profit - Limited Liability company | 140 | 129.5 | Medicare and Medicaid | false | NWA NURSING CENTER, LLC | 07/28/2005 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 3 | 5 | 2 | 2 | 2.44015 | 1.06603 | 0.27187 | 1.3379 | 3.77805 | 0.05267 | 2.03671 | 0.66026 | 0.30838 | 3.00535 | 2.49003 | 1.21405 | 0.33182 | 4.03112 | 07/12/2019 | 8 | 8 | 0 | 40 | 1 | 0 | 40 | 08/23/2018 | 5 | 5 | 0 | 40 | 1 | 0 | 40 | 2017-04-27 | 4 | 4 | 0 | 1 | 40 | 0 | 40 | 40 | 0 | 0 | 0 | 0.00 | 0 | 0 | 6456 LYNCHS PRAIRIE COVE SPRINGDALE, AR 72762 (36.177649, -94.203058) | 02/01/2020 | |||||||||||
3414 | 3414 | 1206 WEST FOURTH STREET STORM LAKE, IA 50588 | 42.642535 | -95.216578 | 0 | 165359 | METHODIST MANOR RETIREMENT COM | 1206 WEST FOURTH STREET | STORM LAKE | IA | 50588 | 7127321120 | 100 | Buena Vista | Non profit - Corporation | 93 | 89.8 | Medicare and Medicaid | false | METHODIST MANOR RETIREMENT COMMUNITY | 09/01/1997 | true | false | false | false | Resident | Yes | 4 | 3 | 3 | 3 | 3 | 5 | 5 | 3.12462 | 0.45367 | 0.99828 | 1.45194 | 4.57656 | 0.01014 | 2.00729 | 0.61847 | 0.26593 | 2.89169 | 3.23522 | 0.55158 | 1.41288 | 5.07506 | 10/17/2019 | 8 | 8 | 0 | 32 | 1 | 0 | 32 | 07/19/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-04-27 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 22 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1206 WEST FOURTH STREET STORM LAKE, IA 50588 (42.642535, -95.216578) | 02/01/2020 | |||||||||||
3480 | 3480 | 800 WEST TEMPLE STREET EFFINGHAM, IL 62401 | 39.127496 | -88.55154 | 0 | 145256 | LAKELAND REHAB & HEALTHCARE CENTER | 800 WEST TEMPLE STREET | EFFINGHAM | IL | 62401 | 2173422171 | 330 | Effingham | For profit - Corporation | 154 | 101.4 | Medicare and Medicaid | false | LAKELAND REHABILITATION AND HEALTHCARE CENTER, LLC | 06/11/1973 | false | false | false | false | Both | Yes | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 2.24869 | 0.77698 | 0.60255 | 1.37953 | 3.62822 | 0.04781 | 2.27861 | 0.74206 | 0.37234 | 3.39301 | 2.05104 | 0.78733 | 0.60908 | 3.42894 | 03/28/2019 | 6 | 3 | 3 | 52 | 1 | 0 | 52 | 06/14/2018 | 4 | 4 | 0 | 20 | 1 | 0 | 20 | 2017-04-27 | 2 | 2 | 0 | 1 | 24 | 0 | 24 | 36.667 | 0 | 3 | 0 | 0.00 | 0 | 0 | 800 WEST TEMPLE STREET EFFINGHAM, IL 62401 (39.127496, -88.55154) | 02/01/2020 | |||||||||||
3745 | 3745 | 600 34TH ST NORTHPORT, AL 35473 | 33.239209 | -87.620846 | 0 | 15034 | HUNTER CREEK HEALTH AND REHABILITATION, LLC | 600 34TH ST | NORTHPORT | AL | 35473 | 2053395900 | 620 | Tuscaloosa | For profit - Corporation | 78 | 70.1 | Medicare and Medicaid | false | HUNTER CREEK HEALTH AND REHABILITATION LLC | 07/01/1968 | false | false | false | false | Resident | Yes | 4 | 3 | 2 | 2 | 2 | 4 | 4 | 2.21178 | 0.60718 | 0.62208 | 1.22926 | 3.44104 | 0.02116 | 2.05424 | 0.67288 | 0.29507 | 3.02219 | 2.23772 | 0.67853 | 0.79352 | 3.65108 | 06/06/2019 | 3 | 3 | 0 | 8 | 1 | 0 | 8 | 06/07/2018 | 5 | 5 | 0 | 28 | 1 | 0 | 28 | 2017-04-27 | 4 | 4 | 0 | 1 | 28 | 0 | 28 | 18 | 0 | 0 | 0 | 0.00 | 0 | 0 | 600 34TH ST NORTHPORT, AL 35473 (33.239209, -87.620846) | 02/01/2020 | |||||||||||
4281 | 4281 | 1145 POQUONNOCK RD GROTON, CT 06340 | 41.346698 | -72.043241 | 0 | 75270 | GROTON REGENCY CENTER | 1145 POQUONNOCK RD | GROTON | CT | 6340 | 8604469960 | 50 | New London | For profit - Individual | 162 | 117.3 | Medicare and Medicaid | false | 1145 POQUONNOCK ROAD OPERATIONS LLC | 07/26/1976 | false | false | false | false | Resident | Yes | 4 | 3 | 3 | 3 | 3 | 4 | 4 | 2.06528 | 0.65998 | 0.56924 | 1.22923 | 3.2945 | 0.04027 | 1.95441 | 0.65605 | 0.29249 | 2.90294 | 2.19624 | 0.75645 | 0.73253 | 3.63919 | 05/31/2019 | 6 | 6 | 3 | 20 | 1 | 0 | 20 | 04/17/2018 | 11 | 11 | 0 | 56 | 1 | 0 | 56 | 2017-04-27 | 12 | 5 | 9 | 1 | 64 | 0 | 64 | 39.333 | 2 | 2 | 1 | 15691.00 | 0 | 1 | 1145 POQUONNOCK RD GROTON, CT 06340 (41.346698, -72.043241) | 02/01/2020 | |||||||||||
4476 | 4476 | 725 DUNBAR AVE BAY SAINT LOUIS, MS 39520 | 30.324224 | -89.337961 | 0 | 255322 | DUNBAR VILLAGE TERRACE | 725 DUNBAR AVE | BAY SAINT LOUIS | MS | 39520 | 2284663099 | 220 | Hancock | For profit - Partnership | 70 | 62.8 | Medicare and Medicaid | false | DUNBAR VILLAGE L.P. | 09/05/2007 | false | false | false | false | Resident | Yes | 4 | 3 | 3 | 3 | 3 | 4 | 3 | 2.87377 | 1.15349 | 0.61319 | 1.76668 | 4.64045 | 0.07534 | 1.95905 | 0.72177 | 0.3486 | 3.02942 | 3.04875 | 1.2017 | 0.66206 | 4.91194 | 07/25/2019 | 5 | 5 | 1 | 32 | 1 | 0 | 32 | 08/23/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-04-27 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 22 | 0 | 0 | 0 | 0.00 | 0 | 0 | 725 DUNBAR AVE BAY SAINT LOUIS, MS 39520 (30.324224, -89.337961) | 02/01/2020 | |||||||||||
4822 | 4822 | 1190 E 2900 NORTH ROAD CLIFTON, IL 60927 | 40.929719 | -87.906196 | 0 | 146085 | A MERKLE C KNIPPRATH N H | 1190 E 2900 NORTH ROAD | CLIFTON | IL | 60927 | 8156942306 | 460 | Iroquois | Non profit - Corporation | 99 | 63.1 | Medicare and Medicaid | false | ARTHUR MERKLE-CLARA KNIPPRATH NURSING HOME | 05/21/2005 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 4 | 5 | 3 | 4 | 1.63876 | 0.58552 | 0.65621 | 1.24173 | 2.88049 | 0.0242 | 1.93334 | 0.64065 | 0.28949 | 2.86348 | 1.76167 | 0.68723 | 0.85319 | 3.22571 | 06/20/2019 | 6 | 5 | 1 | 36 | 1 | 0 | 36 | 05/17/2018 | 3 | 3 | 0 | 8 | 1 | 0 | 8 | 2017-04-27 | 16 | 16 | 0 | 1 | 144 | 0 | 144 | 44.667 | 0 | 1 | 1 | 50000.00 | 0 | 1 | 1190 E 2900 NORTH ROAD CLIFTON, IL 60927 (40.929719, -87.906196) | 02/01/2020 | |||||||||||
5708 | 5708 | 3440 GRAND AVENUE AMES, IA 50010 | 42.055179 | -93.620556 | 0 | 165423 | ACCURA HEALTHCARE OF AMES, LLC | 3440 GRAND AVENUE | AMES | IA | 50010 | 5152323426 | 840 | Story | For profit - Corporation | 110 | 71.2 | Medicare and Medicaid | false | GRAND CARE LLC | 09/01/2000 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 2 | 2 | 3 | 4 | 1.97386 | 0.36626 | 0.68166 | 1.04792 | 3.02178 | 0.02939 | 1.87221 | 0.66322 | 0.30096 | 2.83639 | 2.19118 | 0.41526 | 0.85248 | 3.41625 | 09/12/2019 | 7 | 7 | 0 | 20 | 1 | 0 | 20 | 06/14/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-04-27 | 1 | 1 | 0 | 1 | 8 | 0 | 8 | 15.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 3440 GRAND AVENUE AMES, IA 50010 (42.055179, -93.620556) | 02/01/2020 | |||||||||||
5729 | 5729 | 1212 MADELYN AVENUE MACOMB, IL 61455 | 40.445409 | -90.66115 | 0 | 146033 | ELMS, THE | 1212 MADELYN AVENUE | MACOMB | IL | 61455 | 3098375482 | 630 | Mc Donough | Government - County | 98 | 79 | Medicare and Medicaid | false | COUNTY OF MCDONOUGH MCDONOUGH COUNTY CLERK | 09/01/2002 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 2.23169 | 0.6379 | 0.76998 | 1.40788 | 3.63957 | 0.04905 | 2.2418 | 0.69691 | 0.32011 | 3.25883 | 2.06896 | 0.68827 | 0.90534 | 3.58131 | 03/14/2019 | 5 | 4 | 1 | 48 | 1 | 0 | 48 | 02/08/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-04-27 | 14 | 14 | 0 | 1 | 68 | 0 | 68 | 38 | 0 | 2 | 0 | 0.00 | 0 | 0 | 1212 MADELYN AVENUE MACOMB, IL 61455 (40.445409, -90.66115) | 02/01/2020 | |||||||||||
7206 | 7206 | 300 BEECH STREET KUTTAWA, KY 42055 | 37.062474 | -88.134072 | 0 | 185410 | RIVER'S BEND RETIREMENT COMMUNITY | 300 BEECH STREET | KUTTAWA | KY | 42055 | 2703882868 | 710 | Lyon | Non profit - Corporation | 40 | 37.8 | Medicare and Medicaid | false | RBRC, INC. | 06/29/1995 | true | false | false | false | Resident | Yes | 4 | 4 | 2 | 1 | 2 | 4 | 3 | 2.9407 | 1.18428 | 0.6312 | 1.81549 | 4.75619 | 0.03871 | 2.0809 | 0.7526 | 0.34385 | 3.17735 | 2.93708 | 1.18325 | 0.69092 | 4.80006 | 08/29/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 06/01/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-04-27 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 10 | 0 | 0 | 0 | 0.00 | 0 | 0 | 300 BEECH STREET KUTTAWA, KY 42055 (37.062474, -88.134072) | 02/01/2020 | |||||||||||
7265 | 7265 | 601 LUTZ ROAD BLOOMINGTON, IL 61704 | 40.444401 | -89.011447 | 0 | 146184 | LUTHER OAKS | 601 LUTZ ROAD | BLOOMINGTON | IL | 61704 | 3096645940 | 650 | Mc Lean | Non profit - Corporation | 18 | 18.1 | Medicare and Medicaid | false | LUTHER OAKS INC | 10/01/2017 | true | false | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 2 | 5 | 5 | 2.21746 | 0.56419 | 1.26845 | 1.83263 | 4.05009 | 0.04564 | 2.0582 | 0.62852 | 0.23211 | 2.91883 | 2.23915 | 0.67498 | 2.05686 | 4.44948 | 07/11/2019 | 13 | 13 | 0 | 76 | 1 | 0 | 76 | 06/20/2018 | 14 | 14 | 0 | 100 | 1 | 0 | 100 | 2017-04-27 | 7 | 6 | 1 | 2 | 36 | 18 | 54 | 80.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 601 LUTZ ROAD BLOOMINGTON, IL 61704 (40.444401, -89.011447) | 02/01/2020 | |||||||||||
7370 | 7370 | 2403 BATTLEFIELD PKWY FORT OGLETHORPE, GA 30742 | 34.944419 | -85.226329 | 0 | 115492 | NHC HEALTHCARE FT OGLETHORPE | 2403 BATTLEFIELD PKWY | FORT OGLETHORPE | GA | 30742 | 7068667700 | 200 | Catoosa | For profit - Corporation | 135 | 125.8 | Medicare and Medicaid | false | NATIONAL HEALTHCARE CENTER OF FT OGLETHORPE LTD | 11/14/1989 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 3 | 5 | 2 | 2 | 1.90858 | 1.02475 | 0.37187 | 1.39661 | 3.30519 | 0.11645 | 2.09008 | 0.73409 | 0.34047 | 3.16465 | 1.89785 | 1.04966 | 0.4111 | 3.34907 | 06/20/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 04/19/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-04-27 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 9.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 2403 BATTLEFIELD PKWY FORT OGLETHORPE, GA 30742 (34.944419, -85.226329) | 02/01/2020 | |||||||||||
7525 | 7525 | 535 AUTO CENTER DRIVE WATSONVILLE, CA 95076 | 36.919234 | -121.76736 | 0 | 55240 | WATSONVILLE NURSING CENTER | 535 AUTO CENTER DRIVE | WATSONVILLE | CA | 95076 | 8317240875 | 540 | Santa Cruz | For profit - Corporation | 87 | 76.8 | Medicare and Medicaid | false | CF WATSONVILLE EAST, LLC | 05/01/1978 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 3 | 3 | 2.54374 | 0.67294 | 0.50365 | 1.17659 | 3.72033 | 0.02242 | 2.02064 | 0.6939 | 0.31876 | 3.0333 | 2.61637 | 0.72923 | 0.5947 | 3.93296 | 05/04/2019 | 9 | 9 | 0 | 56 | 1 | 0 | 56 | 04/05/2018 | 14 | 13 | 1 | 80 | 1 | 0 | 80 | 2017-04-27 | 16 | 14 | 3 | 1 | 76 | 0 | 76 | 67.333 | 4 | 0 | 0 | 0.00 | 0 | 0 | 535 AUTO CENTER DRIVE WATSONVILLE, CA 95076 (36.919234, -121.76736) | 02/01/2020 | |||||||||||
8215 | 8215 | 1133 WASHINGTON AVE PORTLAND, ME 04103 | 43.692664 | -70.281874 | 0 | 205134 | ST JOSEPH'S REHABILITATION AND RESIDENCE | 1133 WASHINGTON AVE | PORTLAND | ME | 4103 | 2077970600 | 20 | Cumberland | Non profit - Corporation | 121 | 108.2 | Medicare and Medicaid | false | ST JOSEPHS REHABILITATION & RESIDENCE | 01/01/1993 | false | false | false | false | Resident | Yes | 4 | 3 | 2 | 3 | 1 | 5 | 5 | 2.69559 | 0.27021 | 1.21654 | 1.48675 | 4.18234 | 0.05925 | 2.00756 | 0.71686 | 0.34054 | 3.06496 | 2.79062 | 0.28343 | 1.34459 | 4.3757 | 07/11/2019 | 1 | 1 | 0 | 16 | 1 | 0 | 16 | 05/24/2018 | 4 | 4 | 0 | 20 | 2 | 10 | 30 | 2017-04-27 | 3 | 3 | 3 | 1 | 16 | 0 | 16 | 20.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1133 WASHINGTON AVE PORTLAND, ME 04103 (43.692664, -70.281874) | 02/01/2020 | |||||||||||
8619 | 8619 | 1622 EAST BROADWAY MUSKOGEE, OK 74403 | 35.742228 | -95.350142 | 0 | 375146 | BROADWAY MANOR NURSING HOME | 1622 EAST BROADWAY | MUSKOGEE | OK | 74403 | 9186832851 | 500 | Muskogee | For profit - Corporation | 105 | 87.3 | Medicare and Medicaid | false | OK4 BROADWAY OPCO LLC | 12/06/1993 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 4 | 2 | 1 | 2.52216 | 0.89352 | 0.1923 | 1.08582 | 3.60798 | 0.01311 | 1.87247 | 0.68753 | 0.33063 | 2.89063 | 2.79945 | 0.97723 | 0.21891 | 4.00244 | 08/08/2019 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 06/14/2018 | 7 | 7 | 0 | 56 | 1 | 0 | 56 | 2017-04-27 | 6 | 4 | 2 | 1 | 48 | 0 | 48 | 38.667 | 0 | 2 | 0 | 0.00 | 0 | 0 | 1622 EAST BROADWAY MUSKOGEE, OK 74403 (35.742228, -95.350142) | 02/01/2020 | |||||||||||
8722 | 8722 | 305 BONITA ST JACKSONVILLE, TX 75766 | 31.948705 | -95.27641 | 0 | 675011 | JACKSONVILLE HEALTHCARE CENTER | 305 BONITA ST | JACKSONVILLE | TX | 75766 | 9035863616 | 281 | Cherokee | For profit - Corporation | 35 | 38.4 | Medicare and Medicaid | false | SLP JACKSONVILLE LLC | 02/20/1992 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 2 | 2 | 2 | 1.69182 | 0.98081 | 0.44204 | 1.42286 | 3.11468 | 0.00332 | 2.0293 | 0.80358 | 0.42875 | 3.26162 | 1.73271 | 0.91779 | 0.38806 | 3.06219 | 05/15/2019 | 2 | 2 | 0 | 16 | 1 | 0 | 16 | 05/04/2018 | 2 | 2 | 0 | 24 | 1 | 0 | 24 | 2017-04-27 | 11 | 9 | 2 | 1 | 136 | 0 | 136 | 38.667 | 1 | 0 | 1 | 7800.00 | 0 | 1 | 305 BONITA ST JACKSONVILLE, TX 75766 (31.948705, -95.27641) | 02/01/2020 | |||||||||||
9090 | 9090 | 1505 SOUTHEAST CARPENTER ROAD LACEY, WA 98503 | 47.032835 | -122.791466 | 0 | 505254 | ROO-LAN HEALTHCARE CENTER | 1505 SOUTHEAST CARPENTER ROAD | LACEY | WA | 98503 | 3604911765 | 330 | Thurston | For profit - Corporation | 96 | 78.3 | Medicare and Medicaid | false | LACEY NURSING CENTER, INC. | 04/01/1980 | true | false | false | false | Resident | Yes | 4 | 4 | 4 | 3 | 5 | 3 | 3 | 2.34371 | 0.87257 | 0.44201 | 1.31458 | 3.65829 | 0.0079 | 2.22748 | 0.67212 | 0.2879 | 3.1875 | 2.18678 | 0.9762 | 0.57786 | 3.68028 | 02/13/2019 | 17 | 16 | 1 | 100 | 1 | 0 | 100 | 03/23/2018 | 6 | 6 | 1 | 36 | 1 | 0 | 36 | 2017-04-27 | 8 | 5 | 3 | 1 | 56 | 0 | 56 | 71.333 | 2 | 2 | 2 | 8937.00 | 0 | 2 | 1505 SOUTHEAST CARPENTER ROAD LACEY, WA 98503 (47.032835, -122.791466) | 02/01/2020 | |||||||||||
10492 | 10492 | 4800 CLAGUE ROAD NORTH OLMSTED, OH 44070 | 41.419233 | -81.877383 | 0 | 366272 | O'NEILL HEALTHCARE NORTH OLMSTED | 4800 CLAGUE ROAD | NORTH OLMSTED | OH | 44070 | 4407349933 | 170 | Cuyahoga | For profit - Corporation | 56 | 49.3 | Medicare and Medicaid | false | WELLINGTON PLACE, LLC | 06/12/2003 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 5 | 4 | 3 | 3 | 1.94667 | 0.88982 | 0.74194 | 1.63176 | 3.57843 | 0.21802 | 2.21138 | 0.84215 | 0.43836 | 3.49189 | 1.82956 | 0.7945 | 0.63704 | 3.28613 | 04/11/2019 | 2 | 1 | 1 | 20 | 1 | 0 | 20 | 02/22/2018 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 2017-04-27 | 7 | 0 | 7 | 0 | 44 | 0 | 44 | 25.333 | 0 | 1 | 1 | 6500.00 | 0 | 1 | 4800 CLAGUE ROAD NORTH OLMSTED, OH 44070 (41.419233, -81.877383) | 02/01/2020 | |||||||||||
12404 | 12404 | 501 N MAIN ST COLLINSVILLE, TX 76233 | 33.564659 | -96.911186 | 0 | 675206 | HOMESTEAD NURSING AND REHABILITATION OF COLLINSVIL | 501 N MAIN ST | COLLINSVILLE | TX | 76233 | 9034296426 | 564 | Grayson | Government - Hospital district | 65 | 34.9 | Medicare and Medicaid | false | JACK COUNTY HOSPITAL DISTRICT | 12/06/1993 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 2 | 2 | 2 | 1.48722 | 0.87765 | 0.43501 | 1.31266 | 2.79988 | 0.01432 | 2.01622 | 0.81419 | 0.43746 | 3.26788 | 1.53304 | 0.81055 | 0.37427 | 2.74743 | 04/11/2019 | 2 | 2 | 0 | 4 | 1 | 0 | 4 | 04/05/2018 | 7 | 6 | 5 | 52 | 1 | 0 | 52 | 2017-04-27 | 7 | 7 | 2 | 1 | 80 | 0 | 80 | 32.667 | 1 | 0 | 0 | 0.00 | 0 | 0 | 501 N MAIN ST COLLINSVILLE, TX 76233 (33.564659, -96.911186) | 02/01/2020 | |||||||||||
12914 | 12914 | 1402 NORTHWEST 7TH STREET STIGLER, OK 74462 | 35.268016 | -95.132439 | 0 | 375497 | HASKELL COUNTY NURSING CENTER, INC | 1402 NORTHWEST 7TH STREET | STIGLER | OK | 74462 | 9189673381 | 300 | Haskell | For profit - Individual | 80 | 60.8 | Medicare and Medicaid | false | HASKELL COUNTY NURSING CENTER | 01/09/2006 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 1 | 5 | 3 | 1 | 2.54398 | 1.15938 | 0.17853 | 1.33791 | 3.88189 | 0 | 1.80006 | 0.6429 | 0.31189 | 2.75485 | 2.93726 | 1.35602 | 0.21545 | 4.51854 | 01/31/2019 | 6 | 5 | 1 | 32 | 1 | 0 | 32 | 03/01/2018 | 5 | 5 | 0 | 36 | 1 | 0 | 36 | 2017-04-27 | 4 | 4 | 0 | 1 | 24 | 0 | 24 | 32 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1402 NORTHWEST 7TH STREET STIGLER, OK 74462 (35.268016, -95.132439) | 02/01/2020 | |||||||||||
13216 | 13216 | 1011 W TULARE ROAD LINDSAY, CA 93247 | 36.210556 | -119.10657 | 0 | 555663 | LINDSAY GARDENS NURSING & REHABILITATION | 1011 W. TULARE ROAD | LINDSAY | CA | 93247 | 5595620055 | 640 | Tulare | For profit - Corporation | 99 | 90 | Medicare and Medicaid | false | LINDSAY GARDENSIDENCE OPCO,LLC | 05/07/1996 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 2 | 1 | 2.49386 | 0.96953 | 0.14735 | 1.11688 | 3.61074 | 0.12041 | 2.02005 | 0.72689 | 0.33796 | 3.0849 | 2.56581 | 1.00294 | 0.1641 | 3.75325 | 02/27/2019 | 7 | 5 | 3 | 36 | 1 | 0 | 36 | 03/29/2018 | 15 | 15 | 0 | 88 | 1 | 0 | 88 | 2017-04-27 | 21 | 17 | 4 | 1 | 120 | 0 | 120 | 67.333 | 3 | 2 | 0 | 0.00 | 0 | 0 | 1011 W TULARE ROAD LINDSAY, CA 93247 (36.210556, -119.10657) | 02/01/2020 | |||||||||||
13508 | 13508 | 7385 WALKER AVE GLOUCESTER, VA 23061 | 37.415535 | -76.526534 | 0 | 495383 | FRANCIS N SANDERS NURSING HOME, INC | 7385 WALKER AVE | GLOUCESTER | VA | 23061 | 8046932000 | 360 | Gloucester | Non profit - Corporation | 55 | 46.4 | Medicare | false | FRANCIS N. SANDERS NURSING HOME, INC | 01/27/2005 | false | true | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 5 | 5 | 5 | 2.37734 | 1.54497 | 0.99895 | 2.54391 | 4.92126 | 0.17575 | 2.29511 | 0.74477 | 0.35808 | 3.39796 | 2.1528 | 1.55985 | 1.05 | 4.6442 | 07/11/2019 | 17 | 17 | 0 | 96 | 2 | 48 | 144 | 04/19/2018 | 9 | 9 | 0 | 36 | 1 | 0 | 36 | 2017-04-27 | 7 | 7 | 0 | 1 | 28 | 0 | 28 | 88.667 | 0 | 0 | 1 | 137389.00 | 0 | 1 | 7385 WALKER AVE GLOUCESTER, VA 23061 (37.415535, -76.526534) | 02/01/2020 | |||||||||||
13969 | 13969 | 409 S FILES ST ITASCA, TX 76055 | 32.158597 | -97.143022 | 0 | 675712 | HOMESTEAD NURSING AND REHABILITATION OF ITASCA | 409 S FILES ST | ITASCA | TX | 76055 | 2546872383 | 651 | Hill | For profit - Corporation | 51 | 53.2 | Medicare and Medicaid | false | EASTLAND MEMORIAL HOSPITAL DISTRICT | 08/04/1997 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 3 | 2 | 2 | 2 | 1.85616 | 0.79493 | 0.38628 | 1.18122 | 3.03738 | 0.0105 | 1.92136 | 0.82432 | 0.43931 | 3.18499 | 2.00781 | 0.72514 | 0.33095 | 3.05804 | 06/26/2019 | 5 | 5 | 0 | 28 | 1 | 0 | 28 | 05/23/2018 | 6 | 6 | 1 | 44 | 1 | 0 | 44 | 2017-04-27 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 30 | 0 | 1 | 0 | 0.00 | 0 | 0 | 409 S FILES ST ITASCA, TX 76055 (32.158597, -97.143022) | 02/01/2020 | |||||||||||
14127 | 14127 | 1901 PARKVIEW DRIVE EL RENO, OK 73036 | 35.53067 | -97.977488 | 0 | 375113 | GRACE LIVING CENTER-EL RENO | 1901 PARKVIEW DRIVE | EL RENO | OK | 73036 | 4052622833 | 80 | Canadian | For profit - Partnership | 120 | 75.6 | Medicare and Medicaid | false | EL RENO NURSING CENTER LLC | 10/11/1991 | false | false | false | false | Resident | Yes | 4 | 5 | 3 | 4 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 08/01/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 06/19/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-04-27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1901 PARKVIEW DRIVE EL RENO, OK 73036 (35.53067, -97.977488) | 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 );