nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
21 rows where Overall Rating = 3 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-04-13
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, 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 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 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 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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
370 | 370 | 616 CHAFFEE STREET TALLADEGA, AL 35160 | 33.427681 | -86.0881 | 0 | 15162 | TALLADEGA HEALTHCARE CENTER, INC | 616 CHAFFEE STREET | TALLADEGA | AL | 35160 | 2563624197 | 600 | Talladega | For profit - Corporation | 234 | 188.3 | Medicare and Medicaid | false | TALLADEGA HEALTHCARE CENTER, INC. | 03/01/1977 | false | false | false | false | Both | Yes | 3 | 3 | 2 | 2 | 2 | 3 | 2 | 2.92852 | 1.22067 | 0.3763 | 1.59697 | 4.52549 | 0.02199 | 1.99024 | 0.67468 | 0.31358 | 2.9785 | 3.05815 | 1.36045 | 0.45166 | 4.87215 | 08/01/2019 | 5 | 5 | 0 | 32 | 1 | 0 | 32 | 06/21/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-04-13 | 3 | 3 | 0 | 1 | 24 | 0 | 24 | 22.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 616 CHAFFEE STREET TALLADEGA, AL 35160 (33.427681, -86.0881) | 02/01/2020 | |||||||||||
614 | 614 | 601 S PRAIRIE STREET MOUNT PLEASANT, IA 52641 | 40.796981 | -91.1047 | 0 | 165592 | SAVANNAH HEIGHTS | 601 S PRAIRIE STREET | MOUNT PLEASANT | IA | 52641 | 3193858095 | 430 | Henry | For profit - Corporation | 50 | 26.5 | Medicare and Medicaid | false | PLEASANT MANOR CARE CENTER INC | 02/03/2009 | false | false | false | false | Resident | Yes | 3 | 2 | 3 | 1 | 5 | 5 | 5 | 2.54169 | 0.47843 | 1.70234 | 2.18077 | 4.72246 | 0.08105 | 2.09556 | 0.73939 | 0.34033 | 3.17528 | 2.5208 | 0.48655 | 1.88266 | 4.76913 | 10/03/2019 | 3 | 2 | 2 | 28 | 1 | 0 | 28 | 07/19/2018 | 8 | 5 | 3 | 60 | 1 | 0 | 60 | 2017-04-13 | 7 | 5 | 7 | 1 | 28 | 0 | 28 | 38.667 | 6 | 4 | 2 | 17102.00 | 0 | 2 | 601 S PRAIRIE STREET MOUNT PLEASANT, IA 52641 (40.796981, -91.1047) | 02/01/2020 | |||||||||||
1765 | 1765 | 3800 COMMERCE BLVD DAVENPORT, IA 52807 | 41.56899 | -90.51988 | 0 | 165575 | MANORCARE HEALTH SERVICES-UTICA RIDGE | 3800 COMMERCE BLVD | DAVENPORT | IA | 52807 | 5633442000 | 810 | Scott | Non profit - Corporation | 120 | 104.6 | Medicare and Medicaid | false | MANORCARE HEALTH SERVICES LLC | 02/09/2009 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 5 | 4 | 4 | 4 | 2.16808 | 0.65266 | 0.9968 | 1.64946 | 3.81754 | 0.14803 | 2.18667 | 0.78078 | 0.3743 | 3.34175 | 2.06067 | 0.62855 | 1.00236 | 3.66322 | 09/26/2019 | 8 | 6 | 2 | 28 | 1 | 0 | 28 | 06/28/2018 | 6 | 6 | 0 | 44 | 1 | 0 | 44 | 2017-04-13 | 4 | 3 | 4 | 1 | 20 | 0 | 20 | 32 | 0 | 2 | 0 | 0.00 | 0 | 0 | 3800 COMMERCE BLVD DAVENPORT, IA 52807 (41.56899, -90.51988) | 02/01/2020 | |||||||||||
3629 | 3629 | 2005 SOUTH LEXINGTON HOLDEN, MO 64040 | 38.700399 | -93.994671 | 0 | 265739 | HOLDEN MANOR CARE CENTER | 2005 SOUTH LEXINGTON | HOLDEN | MO | 64040 | 8167324138 | 500 | Johnson | For profit - Corporation | 52 | 29.4 | Medicare and Medicaid | false | HOLDEN MANOR INC | 05/14/2002 | false | false | false | false | Resident | Yes | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 2.22696 | 0.48443 | 0.49607 | 0.9805 | 3.20746 | 0.03265 | 1.86378 | 0.67012 | 0.29071 | 2.82461 | 2.48332 | 0.54358 | 0.64227 | 3.64129 | 04/05/2019 | 6 | 6 | 0 | 44 | 1 | 0 | 44 | 03/08/2018 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 2017-04-13 | 9 | 9 | 0 | 1 | 68 | 0 | 68 | 40 | 0 | 0 | 0 | 0.00 | 0 | 0 | 2005 SOUTH LEXINGTON HOLDEN, MO 64040 (38.700399, -93.994671) | 02/01/2020 | |||||||||||
3716 | 3716 | 206 PORT NEAL ROAD SERGEANT BLUFF, IA 51054 | 42.397235 | -96.355448 | 0 | 165145 | EMBASSY REHAB AND CARE CENTER | 206 PORT NEAL ROAD | SERGEANT BLUFF | IA | 51054 | 7129433837 | 960 | Woodbury | For profit - Corporation | 60 | 31.2 | Medicare and Medicaid | false | KISMET SUX LLC | 11/28/1988 | false | false | false | false | Resident | Yes | 3 | 2 | 2 | 1 | 4 | 4 | 4 | 2.0668 | 0.81418 | 0.86022 | 1.67439 | 3.7412 | 0.0251 | 1.96502 | 0.73845 | 0.34699 | 3.05046 | 2.18599 | 0.82905 | 0.93308 | 3.93277 | 09/18/2019 | 6 | 6 | 1 | 48 | 1 | 0 | 48 | 06/28/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-04-13 | 11 | 5 | 8 | 1 | 60 | 0 | 60 | 36.667 | 3 | 3 | 2 | 23351.00 | 0 | 2 | 206 PORT NEAL ROAD SERGEANT BLUFF, IA 51054 (42.397235, -96.355448) | 02/01/2020 | |||||||||||
5201 | 5201 | 325 SOUTHWEST SEVENTH STREET STUART, IA 50250 | 41.496654 | -94.321514 | 0 | 165501 | COMMUNITY CARE CENTER | 325 SOUTHWEST SEVENTH STREET | STUART | IA | 50250 | 5155232815 | 0 | Adair | For profit - Corporation | 69 | 57.6 | Medicare and Medicaid | false | COMMUNITY CARE CENTER, INC | 09/01/2003 | false | false | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 3 | 4 | 1.67683 | 0.50486 | 0.51798 | 1.02283 | 2.69966 | 0.02036 | 1.94469 | 0.61897 | 0.26304 | 2.8267 | 1.79206 | 0.61332 | 0.74116 | 3.06255 | 09/12/2019 | 9 | 9 | 0 | 40 | 1 | 0 | 40 | 06/21/2018 | 2 | 2 | 1 | 8 | 1 | 0 | 8 | 2017-04-13 | 5 | 5 | 0 | 1 | 36 | 0 | 36 | 28.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 325 SOUTHWEST SEVENTH STREET STUART, IA 50250 (41.496654, -94.321514) | 02/01/2020 | |||||||||||
5315 | 5315 | 5668 STRATHMOOR DRIVE ROCKFORD, IL 61107 | 42.269059 | -89.005866 | 0 | 145259 | ALDEN PARK STRATHMOOR | 5668 STRATHMOOR DRIVE | ROCKFORD | IL | 61107 | 8152295200 | 991 | Winnebago | For profit - Corporation | 189 | 144.5 | Medicare and Medicaid | false | ALDEN-PARK STRATHMOOR, INC. | 08/07/1973 | false | true | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 4 | 2 | 2 | 1.41714 | 0.50615 | 0.59305 | 1.0992 | 2.51635 | 0.02155 | 2.25018 | 0.77663 | 0.48497 | 3.51178 | 1.30892 | 0.49006 | 0.46027 | 2.29772 | 06/19/2019 | 10 | 7 | 3 | 44 | 1 | 0 | 44 | 05/04/2018 | 15 | 8 | 7 | 100 | 1 | 0 | 100 | 2017-04-13 | 8 | 7 | 2 | 1 | 44 | 0 | 44 | 62.667 | 0 | 15 | 0 | 0.00 | 0 | 0 | 5668 STRATHMOOR DRIVE ROCKFORD, IL 61107 (42.269059, -89.005866) | 02/01/2020 | |||||||||||
5831 | 5831 | 2101 JAMES STREET LAWRENCEVILLE, IL 62439 | 38.724238 | -87.696026 | 0 | 145722 | UNITED METHODIST VILLAGE, NORTH CAMPUS | 2101 JAMES STREET | LAWRENCEVILLE | IL | 62439 | 6189433444 | 590 | Lawrence | Non profit - Church related | 98 | 64.1 | Medicare and Medicaid | false | VILLAGE HEALTH CARE MANAGEMENT LLC | 02/20/1992 | false | false | false | false | Resident | Yes | 3 | 3 | 2 | 3 | 2 | 3 | 3 | 2.25858 | 0.90833 | 0.52141 | 1.42973 | 3.68831 | 0.22751 | 1.86652 | 0.66779 | 0.31 | 2.8443 | 2.51489 | 1.02279 | 0.63306 | 4.15819 | 06/26/2019 | 3 | 2 | 1 | 28 | 1 | 0 | 28 | 05/10/2018 | 10 | 4 | 6 | 80 | 1 | 0 | 80 | 2017-04-13 | 4 | 3 | 1 | 1 | 40 | 0 | 40 | 47.333 | 0 | 7 | 1 | 6500.00 | 0 | 1 | 2101 JAMES STREET LAWRENCEVILLE, IL 62439 (38.724238, -87.696026) | 02/01/2020 | |||||||||||
6077 | 6077 | 40 WHITEHALL ROAD ROCHESTER, NH 03867 | 43.298314 | -70.955814 | 0 | 305024 | ROCHESTER MANOR | 40 WHITEHALL ROAD | ROCHESTER | NH | 3867 | 6033327711 | 80 | Strafford | For profit - Corporation | 108 | 90.9 | Medicare and Medicaid | false | 40 WHITEHALL ROAD OPERATIONS LLC | 08/19/1972 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 3 | 4 | 2 | 2 | 1.77373 | 0.64633 | 0.45664 | 1.10297 | 2.8767 | 0.04945 | 1.96431 | 0.73672 | 0.36158 | 3.06261 | 1.8767 | 0.65968 | 0.47533 | 3.01201 | 07/11/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 06/14/2018 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2017-04-13 | 7 | 7 | 0 | 1 | 28 | 0 | 28 | 8.667 | 1 | 0 | 0 | 0.00 | 0 | 0 | 40 WHITEHALL ROAD ROCHESTER, NH 03867 (43.298314, -70.955814) | 02/01/2020 | |||||||||||
6634 | 6634 | 331 SOUTH SETON AVENUE EMMITSBURG, MD 21727 | 39.6985 | -77.329507 | 0 | 215267 | ST JOSEPH'S MINISTRIES | 331 SOUTH SETON AVENUE | EMMITSBURG | MD | 21727 | 3014477000 | 100 | Frederick | Non profit - Corporation | 99 | 96.3 | Medicare and Medicaid | false | ST JOSEPHS MINISTRIES INC | 10/24/1994 | false | false | false | false | Both | Yes | 3 | 2 | 4 | 3 | 5 | 4 | 4 | 2.35664 | 0.9855 | 0.87554 | 1.86104 | 4.21767 | 0.13481 | 2.17357 | 0.72952 | 0.36485 | 3.26794 | 2.25338 | 1.01579 | 0.90321 | 4.13858 | 07/26/2019 | 12 | 12 | 2 | 56 | 1 | 0 | 56 | 04/04/2018 | 23 | 18 | 5 | 148 | 1 | 0 | 148 | 2017-04-13 | 23 | 15 | 22 | 1 | 152 | 0 | 152 | 102.667 | 7 | 3 | 2 | 16776.00 | 0 | 2 | 331 SOUTH SETON AVENUE EMMITSBURG, MD 21727 (39.6985, -77.329507) | 02/01/2020 | |||||||||||
6880 | 6880 | 1007 W FORT WILLIAMS ST SYLACAUGA, AL 35150 | 33.16723 | -86.267588 | 0 | 15160 | SYLACAUGA HEALTH AND REHAB SERVICES | 1007 W FORT WILLIAMS ST | SYLACAUGA | AL | 35150 | 2562457402 | 600 | Talladega | For profit - Corporation | 149 | 134.4 | Medicare and Medicaid | false | SYLACAUGA HEALTH AND REHAB SERVICES, LLC | 02/01/1977 | true | false | false | false | Resident | Yes | 3 | 3 | 3 | 2 | 4 | 3 | 3 | 2.30238 | 0.78465 | 0.47852 | 1.26317 | 3.56555 | 0.00524 | 2.0874 | 0.64592 | 0.29286 | 3.02618 | 2.29238 | 0.91343 | 0.615 | 3.7782 | 04/18/2019 | 5 | 5 | 0 | 28 | 1 | 0 | 28 | 05/22/2018 | 4 | 4 | 2 | 16 | 1 | 0 | 16 | 2017-04-13 | 1 | 1 | 0 | 1 | 16 | 0 | 16 | 22 | 0 | 1 | 0 | 0.00 | 0 | 0 | 1007 W FORT WILLIAMS ST SYLACAUGA, AL 35150 (33.16723, -86.267588) | 02/01/2020 | |||||||||||
8642 | 8642 | 4375 S Co Rd 25A, Tipp City, OH 45371, USA | 39.9750394 | -84.1966266 | 1 | ROOFTOP | 365882 | SPRINGMEADE HEALTHCENTER | 4375 SOUTH COUNTY ROAD 25 A | TIPP CITY | OH | 45371 | 9376677500 | 560 | Miami | Non profit - Corporation | 114 | 99.8 | Medicare and Medicaid | false | UVMC NURSING CARE, INC | 07/01/1992 | false | false | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 3 | 3 | 1.97944 | 0.77406 | 0.70711 | 1.48117 | 3.4606 | 0.05089 | 2.20221 | 0.84528 | 0.43961 | 3.4871 | 1.86809 | 0.68859 | 0.60541 | 3.1823 | 07/18/2019 | 12 | 10 | 3 | 48 | 1 | 0 | 48 | 06/07/2018 | 12 | 11 | 1 | 68 | 1 | 0 | 68 | 2017-04-13 | 9 | 6 | 4 | 1 | 76 | 0 | 76 | 59.333 | 0 | 6 | 1 | 13000.00 | 0 | 1 | 02/01/2020 | |||||||||||
9192 | 9192 | 565 Bryn Mawr St, Ravenna, OH 44266, USA | 41.1652206 | -81.2219774 | 1 | ROOFTOP | 365354 | LONGMEADOW CARE CENTER | 565 BRYN MAWR | RAVENNA | OH | 44266 | 3302975781 | 680 | Portage | For profit - Individual | 105 | 68 | Medicare and Medicaid | false | EMBASSY LONGMEADOW LLC | 02/22/1978 | false | false | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 2 | 2 | 2.00923 | 0.82779 | 0.44124 | 1.26903 | 3.27826 | 0.06698 | 2.20644 | 0.86684 | 0.45277 | 3.52605 | 1.89258 | 0.71806 | 0.36679 | 2.98131 | 08/08/2019 | 6 | 6 | 0 | 36 | 1 | 0 | 36 | 06/21/2018 | 10 | 7 | 8 | 60 | 1 | 0 | 60 | 2017-04-13 | 15 | 3 | 12 | 1 | 92 | 0 | 92 | 53.333 | 0 | 17 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
10446 | 10446 | 2806 REAL ST AUSTIN, TX 78722 | 30.28244 | -97.711754 | 0 | 455599 | HERITAGE PARK REHABILITATION AND SKILLED NURSING C | 2806 REAL ST | AUSTIN | TX | 78722 | 5124741411 | 940 | Travis | For profit - Corporation | 190 | 194.2 | Medicare and Medicaid | false | REGENCY IHS OF HERITAGE PARK, LLC | 10/01/1985 | false | false | false | false | Both | Yes | 3 | 4 | 2 | 4 | 1 | 1 | 1 | 2.1134 | 0.76224 | 0.23797 | 1.0002 | 3.1136 | 0.04977 | 1.91528 | 0.77131 | 0.39937 | 3.08597 | 2.29332 | 0.74309 | 0.22427 | 3.23537 | 04/17/2019 | 1 | 1 | 0 | 16 | 1 | 0 | 16 | 04/26/2018 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 2017-04-13 | 4 | 1 | 3 | 1 | 24 | 0 | 24 | 20 | 0 | 0 | 0 | 0.00 | 0 | 0 | 2806 REAL ST AUSTIN, TX 78722 (30.28244, -97.711754) | 02/01/2020 | |||||||||||
10537 | 10537 | 1111 W SHORE DR RICHARDSON, TX 75080 | 32.964268 | -96.748219 | 0 | 675281 | COTTONWOOD CREEK HEALTHCARE COMMUNITY | 1111 W SHORE DR | RICHARDSON | TX | 75080 | 9727838000 | 390 | Dallas | For profit - Corporation | 106 | 67.7 | Medicare and Medicaid | false | DHC OPCO-RICHARDSON, LLC | 03/18/1994 | false | false | false | false | Both | Yes | 3 | 4 | 1 | 1 | 2 | 2 | 2 | 2.00763 | 0.71086 | 0.39676 | 1.10761 | 3.11524 | 0.01215 | 1.98937 | 0.79259 | 0.40281 | 3.18477 | 2.09741 | 0.6744 | 0.37073 | 3.13666 | 04/25/2019 | 2 | 0 | 2 | 24 | 1 | 0 | 24 | 04/26/2018 | 5 | 4 | 2 | 32 | 1 | 0 | 32 | 2017-04-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22.667 | 3 | 0 | 1 | 50219.00 | 1 | 2 | 1111 W SHORE DR RICHARDSON, TX 75080 (32.964268, -96.748219) | 02/01/2020 | |||||||||||
10546 | 10546 | 3300 LOGAN FERRY ROAD MURRYSVILLE, PA 15668 | 40.431105 | -79.69825 | 0 | 395295 | MURRYSVILLE REHABILITATION AND WELLNESS CENTER | 3300 LOGAN FERRY ROAD | MURRYSVILLE | PA | 15668 | 7243251500 | 770 | Westmoreland | For profit - Corporation | 120 | 103.5 | Medicare and Medicaid | false | MURRYSVILLE OPERATIONS LLC | 02/11/1972 | false | false | false | false | Both | Yes | 3 | 3 | 2 | 3 | 1 | 3 | 4 | 1.96444 | 0.47987 | 0.84258 | 1.32245 | 3.28689 | 0.10799 | 2.12793 | 0.82915 | 0.4265 | 3.38358 | 1.91865 | 0.43518 | 0.74356 | 3.11502 | 04/19/2019 | 7 | 5 | 2 | 40 | 1 | 0 | 40 | 03/09/2018 | 4 | 4 | 0 | 28 | 1 | 0 | 28 | 2017-04-13 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 30.667 | 0 | 4 | 0 | 0.00 | 0 | 0 | 3300 LOGAN FERRY ROAD MURRYSVILLE, PA 15668 (40.431105, -79.69825) | 02/01/2020 | |||||||||||
11114 | 11114 | 421 WEST F ST MUNDAY, TX 76371 | 33.452497 | -99.626814 | 0 | 675061 | MUNDAY NURSING CENTER | 421 WEST F ST | MUNDAY | TX | 76371 | 9404224541 | 744 | Knox | For profit - Individual | 61 | 40.3 | Medicare and Medicaid | false | KNOX COUNTY HOSPITAL DISTRICT | 06/18/1992 | false | false | false | false | Resident | Yes | 3 | 4 | 4 | 4 | 2 | 1 | 12 | 1 | 12 | 2.04105 | 0.70353 | 0.28783 | 0.99136 | 3.03241 | 0.00838 | 1.80054 | 0.68405 | 0.33217 | 2.81676 | 2.35595 | 0.77335 | 0.32614 | 3.45216 | 04/03/2019 | 8 | 8 | 0 | 56 | 1 | 0 | 56 | 05/16/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-04-13 | 1 | 1 | 0 | 1 | 8 | 0 | 8 | 29.333 | 0 | 1 | 1 | 8535.00 | 0 | 1 | 421 WEST F ST MUNDAY, TX 76371 (33.452497, -99.626814) | 02/01/2020 | |||||||||
11157 | 11157 | 2170 RHINE STREET PITTSBURGH, PA 15212 | 40.467904 | -79.994899 | 0 | 395666 | MANORCARE HEALTH SERVICES-NORTHSIDE | 2170 RHINE STREET | PITTSBURGH | PA | 15212 | 4123230420 | 10 | Allegheny | Non profit - Corporation | 100 | 84.6 | Medicare and Medicaid | false | SKY VUE TERRACE-PITTSBURGH PA LLC | 06/01/1984 | false | false | false | false | Resident | Yes | 3 | 3 | 3 | 4 | 2 | 3 | 4 | 1.63899 | 0.66256 | 0.84111 | 1.50367 | 3.14266 | 0.06656 | 1.89998 | 0.68539 | 0.32709 | 2.91247 | 1.79284 | 0.72689 | 0.96786 | 3.4601 | 05/24/2019 | 6 | 6 | 2 | 28 | 1 | 0 | 28 | 04/16/2018 | 5 | 5 | 0 | 32 | 1 | 0 | 32 | 2017-04-13 | 8 | 7 | 1 | 1 | 40 | 0 | 40 | 31.333 | 1 | 1 | 0 | 0.00 | 0 | 0 | 2170 RHINE STREET PITTSBURGH, PA 15212 (40.467904, -79.994899) | 02/01/2020 | |||||||||||
11860 | 11860 | 3003 W Iowa Ave, Chickasha, OK 73018, USA | 35.046825 | -97.97118599999999 | 1 | ROOFTOP | 375359 | GLENHAVEN RETIREMENT VILLAGE | 3003 IOWA | CHICKASHA | OK | 73023 | 4052240909 | 250 | Grady | For profit - Corporation | 120 | 77.3 | Medicare and Medicaid | false | GLENHAVEN CORPORATION | 01/01/1999 | true | false | false | false | Resident | Yes | 3 | 4 | 3 | 2 | 4 | 1 | 12 | 1 | 12 | 6 | 6 | 08/19/2019 | 1 | 1 | 0 | 16 | 1 | 0 | 16 | 07/02/2018 | 8 | 6 | 2 | 48 | 1 | 0 | 48 | 2017-04-13 | 1 | 0 | 1 | 0 | 8 | 0 | 8 | 25.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||
12203 | 12203 | 21158 PAINT BOULEVARD SHIPPENVILLE, PA 16254 | 41.2408 | -79.427639 | 0 | 395607 | SHIPPENVILLE HEALTHCARE AND REHABILITATION CENTER | 21158 PAINT BOULEVARD | SHIPPENVILLE | PA | 16254 | 8142265660 | 220 | Clarion | For profit - Corporation | 120 | 73.9 | Medicare and Medicaid | false | GUARDIAN ELDER CARE AT SHIPPENVILLE LLC | 11/07/1983 | false | false | false | false | Resident | Yes | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 1.67911 | 0.99875 | 0.51453 | 1.51328 | 3.19239 | 0.06018 | 2.15491 | 0.84571 | 0.45856 | 3.45918 | 1.61945 | 0.88801 | 0.42232 | 2.95935 | 04/12/2019 | 11 | 11 | 0 | 52 | 1 | 0 | 52 | 03/15/2018 | 4 | 4 | 0 | 20 | 1 | 0 | 20 | 2017-04-13 | 5 | 5 | 0 | 1 | 16 | 0 | 16 | 35.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 21158 PAINT BOULEVARD SHIPPENVILLE, PA 16254 (41.2408, -79.427639) | 02/01/2020 | |||||||||||
15153 | 15153 | 901 BRIDGE CREEK LANE AUGUSTA, WI 54722 | 45.165264 | -91.141893 | 0 | 525535 | AUGUSTA HEALTH AND REHABILITATION | 901 BRIDGE CREEK LANE | AUGUSTA | WI | 54722 | 7152862266 | 170 | Eau Claire | Non profit - Corporation | 50 | 41.9 | Medicare and Medicaid | false | AUGUSTA AREA HOME, INC | 06/01/1994 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 3 | 5 | 4 | 4 | 2.38662 | 0.37312 | 0.78535 | 1.15847 | 3.54509 | 0.02325 | 2.08338 | 0.6899 | 0.30913 | 3.08241 | 2.38084 | 0.40667 | 0.9562 | 3.68799 | 07/31/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 07/03/2018 | 7 | 7 | 7 | 161 | 1 | 0 | 161 | 2017-04-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 57.667 | 0 | 1 | 1 | 25356.00 | 0 | 1 | 901 BRIDGE CREEK LANE AUGUSTA, WI 54722 (45.165264, -91.141893) | 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 );