nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
18 rows where Automatic Sprinkler Systems in All Required Areas = "Partial" sorted by Rating Cycle 3 Number of Health Revisits
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, Provider Resides in Hospital, Continuing Care Retirement Community, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported 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 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 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8300 | 8300 | 340 MOTAGUE CITY ROAD TURNERS FALLS, MA 01376 | 42.585979 | -72.575836 | 0 | 225527 | FARREN CARE CENTER | 340 MOTAGUE CITY ROAD | TURNERS FALLS | MA | 1376 | 4137743111 | 60 | Franklin | Non profit - Corporation | 122 | 107.5 | Medicare and Medicaid | false | TRINITY CONTINUING CARE SERVICES - MASSACHUSETTS | 10/16/1990 | false | false | false | false | Resident | Partial | 3 | 3 | 1 | 2 | 1 | 5 | 5 | 2.72236 | 1.02845 | 0.81233 | 1.84078 | 4.56314 | 0.00663 | 2.17533 | 0.62321 | 0.28618 | 3.08472 | 2.60097 | 1.24089 | 1.06838 | 4.74352 | 02/20/2019 | 6 | 5 | 1 | 24 | 1 | 0 | 24 | 10/31/2017 | 7 | 5 | 2 | 99 | 1 | 0 | 99 | 2016-09-27 | 2 | 0 | 2 | 0 | 8 | 0 | 8 | 46.333 | 1 | 1 | 1 | 24746.00 | 0 | 1 | 340 MOTAGUE CITY ROAD TURNERS FALLS, MA 01376 (42.585979, -72.575836) | 02/01/2020 | |||||||||||
9251 | 9251 | 303 RHODES AVENUE WOONSOCKET, RI 02895 | 42.005585 | -71.533652 | 0 | 415044 | FRIENDLY HOME INC THE | 303 RHODES AVENUE | WOONSOCKET | RI | 2895 | 4017697220 | 30 | Providence | For profit - Corporation | 126 | 123.2 | Medicare and Medicaid | false | FRIENDLY HOME INC | 06/01/1979 | false | false | false | false | Resident | Partial | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 2.65577 | 0.37044 | 0.70246 | 1.07291 | 3.72868 | 0.01972 | 1.99968 | 0.65036 | 0.30699 | 2.95703 | 2.76023 | 0.42831 | 0.86126 | 4.04345 | 07/11/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 09/20/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-07-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 303 RHODES AVENUE WOONSOCKET, RI 02895 (42.005585, -71.533652) | 02/01/2020 | |||||||||||
10255 | 10255 | 3086 GLOVER STREET GLOVER, VT 05839 | 44.704807 | -72.188309 | 0 | 475036 | UNION HOUSE NURSING HOME | 3086 GLOVER STREET | GLOVER | VT | 5839 | 8025256600 | 90 | Orleans | For profit - Partnership | 44 | 42.6 | Medicare and Medicaid | false | UNION HOUSE NURSING HOME, INC | 07/01/1991 | false | false | false | false | Resident | Partial | 5 | 5 | 2 | 2 | 2 | 3 | 3 | 2.02526 | 0.94965 | 0.57481 | 1.52446 | 3.54971 | 0.03794 | 2.12774 | 0.78608 | 0.41157 | 3.32539 | 1.97823 | 0.90841 | 0.52566 | 3.42297 | 07/31/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 09/12/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-07-25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 | 0 | 3086 GLOVER STREET GLOVER, VT 05839 (44.704807, -72.188309) | 02/01/2020 | |||||||||||
14845 | 14845 | 4000 POST ROAD WARWICK, RI 02886 | 41.682399 | -71.450804 | 0 | 415061 | BRENTWOOD NURSING HOME | 4000 POST ROAD | WARWICK | RI | 2886 | 4018848020 | 10 | Kent | For profit - Limited Liability company | 96 | 88 | Medicare and Medicaid | false | BRENTWOOD HEALTH CENTER, LTD | 07/01/1979 | false | false | false | false | Resident | Partial | 4 | 3 | 4 | 5 | 2 | 4 | 4 | 2.22497 | 0.44561 | 0.88789 | 1.33351 | 3.55848 | 0.1066 | 1.98607 | 0.72658 | 0.35856 | 3.07122 | 2.32834 | 0.46116 | 0.93203 | 3.71541 | 04/01/2019 | 1 | 1 | 1 | 4 | 1 | 0 | 4 | 05/15/2018 | 4 | 4 | 0 | 32 | 1 | 0 | 32 | 2017-03-16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.667 | 2 | 0 | 0 | 0.00 | 0 | 0 | 4000 POST ROAD WARWICK, RI 02886 (41.682399, -71.450804) | 02/01/2020 | |||||||||||
1885 | 1885 | 66 CENTRAL STREET EAST BRIDGEWATER, MA 02333 | 42.031178 | -70.957678 | 0 | 225322 | SACHEM CENTER FOR HEALTH & REHABILITATION | 66 CENTRAL STREET | EAST BRIDGEWATER | MA | 2333 | 5083787227 | 150 | Plymouth | For profit - Partnership | 111 | 103.6 | Medicare and Medicaid | false | VK EAST BRIDGEWATER LLC | 01/31/1989 | false | false | false | false | Resident | Partial | 2 | 2 | 4 | 3 | 5 | 3 | 4 | 1.97058 | 0.64152 | 0.69481 | 1.33633 | 3.30691 | 0.05723 | 2.04778 | 0.6683 | 0.31905 | 3.03512 | 1.99998 | 0.72181 | 0.81968 | 3.49381 | 07/25/2019 | 10 | 10 | 0 | 44 | 1 | 0 | 44 | 04/27/2018 | 14 | 14 | 2 | 72 | 1 | 0 | 72 | 2017-01-17 | 9 | 9 | 0 | 1 | 44 | 0 | 44 | 53.333 | 0 | 2 | 1 | 64194.00 | 0 | 1 | 66 CENTRAL STREET EAST BRIDGEWATER, MA 02333 (42.031178, -70.957678) | 02/01/2020 | |||||||||||
2204 | 2204 | 6450 MIAMI CIR SOUTH BEND, IN 46614 | 41.60565 | -86.232977 | 0 | 155684 | SOUTHFIELD VILLAGE | 6450 MIAMI CIR | SOUTH BEND | IN | 46614 | 5742311000 | 700 | St. Joseph | Government - County | 60 | 55.2 | Medicare and Medicaid | false | WOODLAWN HOSPITAL | 12/28/2000 | true | false | false | false | Resident | Partial | 1 | 1 | 4 | 3 | 5 | 3 | 3 | 2.58171 | 0.81069 | 0.7301 | 1.54079 | 4.1225 | 0.08341 | 2.18924 | 0.78794 | 0.40162 | 3.3788 | 2.45092 | 0.77365 | 0.68422 | 3.91247 | 04/01/2019 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 02/08/2018 | 6 | 6 | 0 | 28 | 1 | 0 | 28 | 2017-03-21 | 8 | 4 | 7 | 1 | 463 | 0 | 463 | 98.5 | 0 | 3 | 1 | 58795.00 | 0 | 1 | 6450 MIAMI CIR SOUTH BEND, IN 46614 (41.60565, -86.232977) | 02/01/2020 | |||||||||||
3137 | 3137 | 51 HOSPITAL ROAD BALDWINVILLE, MA 01436 | 42.610648 | -72.061581 | 0 | 225388 | ALLIANCE HEALTH AT BALDWINVILLE | 51 HOSPITAL ROAD | BALDWINVILLE | MA | 1436 | 9789392196 | 170 | Worcester | Non profit - Corporation | 94 | 89.8 | Medicare and Medicaid | false | THE HOSPITAL COTTAGES FOR CHILDREN | 07/01/1990 | false | false | false | false | Resident | Partial | 5 | 5 | 4 | 4 | 3 | 3 | 3 | 1.82884 | 0.80668 | 0.46654 | 1.27323 | 3.10206 | 0.05283 | 2.09806 | 0.66908 | 0.30689 | 3.07403 | 1.81164 | 0.90658 | 0.5722 | 3.23591 | 04/24/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 02/06/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2016-11-14 | 3 | 3 | 0 | 1 | 16 | 0 | 16 | 10 | 0 | 0 | 0 | 0.00 | 0 | 0 | 51 HOSPITAL ROAD BALDWINVILLE, MA 01436 (42.610648, -72.061581) | 02/01/2020 | |||||||||||
6409 | 6409 | 64 PERFORMANCE DRIVE WEYMOUTH, MA 02189 | 42.196957 | -70.942549 | 0 | 225634 | CARE ONE AT WEYMOUTH | 64 PERFORMANCE DRIVE | WEYMOUTH | MA | 2189 | 7813409800 | 130 | Norfolk | For profit - Corporation | 154 | 131 | Medicare and Medicaid | false | 64 PERFORMANCE DRIVE OPERATING COMPANY, LLC | 05/05/1994 | false | false | false | false | Resident | Partial | 4 | 4 | 3 | 3 | 2 | 3 | 3 | 2.08842 | 0.87544 | 0.60446 | 1.47989 | 3.56831 | 0.07691 | 2.1172 | 0.7621 | 0.34831 | 3.22761 | 2.05009 | 0.86377 | 0.65318 | 3.54516 | 02/20/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 10/25/2017 | 10 | 10 | 0 | 48 | 1 | 0 | 48 | 2016-09-14 | 4 | 3 | 1 | 1 | 16 | 0 | 16 | 24.667 | 1 | 0 | 0 | 0.00 | 0 | 0 | 64 PERFORMANCE DRIVE WEYMOUTH, MA 02189 (42.196957, -70.942549) | 02/01/2020 | |||||||||||
9169 | 9169 | 100 ROGERS LANE SHELBY, OH 44875 | 40.870172 | -82.651757 | 0 | 365331 | SHELBY POINTE, INC | 100 ROGERS LANE | SHELBY | OH | 44875 | 4193471313 | 710 | Richland | For profit - Corporation | 45 | 38.3 | Medicare and Medicaid | false | SHELBY POINTE LLC | 03/08/1976 | false | false | false | false | Both | Partial | 4 | 5 | 3 | 3 | 2 | 1 | 1 | 2.16596 | 0.96617 | 0.32853 | 1.29471 | 3.46066 | 0.02752 | 2.00754 | 0.86876 | 0.46616 | 3.34246 | 2.24235 | 0.83625 | 0.26526 | 3.32006 | 02/28/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 01/05/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2016-10-13 | 7 | 7 | 0 | 1 | 32 | 0 | 32 | 10 | 0 | 0 | 0 | 0.00 | 0 | 0 | 100 ROGERS LANE SHELBY, OH 44875 (40.870172, -82.651757) | 02/01/2020 | |||||||||||
9225 | 9225 | 3416 COLUMBUS AVE SANDUSKY, OH 44870 | 41.418483 | -82.689489 | 0 | 366325 | OHIO VETERANS HOME | 3416 COLUMBUS AVE | SANDUSKY | OH | 44870 | 4196252454 | 220 | Erie | Government - State | 427 | 389.7 | Medicare and Medicaid | false | Legal Business Name Not Available | 10/01/2006 | false | false | false | false | Both | Partial | 3 | 3 | 3 | 5 | 2 | 3 | 3 | 1.9396 | 1.23849 | 0.41556 | 1.65406 | 3.59366 | 0.01295 | 1.85829 | 0.6299 | 0.27008 | 2.75827 | 2.16927 | 1.47845 | 0.57913 | 4.17785 | 10/24/2019 | 5 | 5 | 0 | 52 | 1 | 0 | 52 | 09/13/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-07-27 | 6 | 1 | 5 | 1 | 44 | 0 | 44 | 37.333 | 2 | 2 | 1 | 6500.00 | 0 | 1 | 3416 COLUMBUS AVE SANDUSKY, OH 44870 (41.418483, -82.689489) | 02/01/2020 | |||||||||||
10613 | 10613 | 2440 BATON ROUGE AVENUE LIMA, OH 45805 | 40.771872 | -84.145427 | 0 | 365936 | LIBERTY RETIREMENT COMMUNITY OF LIMA INC | 2440 BATON ROUGE AVENUE | LIMA | OH | 45805 | 4193312273 | 10 | Allen | For profit - Individual | 95 | 46.1 | Medicare and Medicaid | false | LIBERTY RETIREMENT COMMUNITY OF LIMA INC | 12/01/1993 | false | false | false | false | Resident | Partial | 1 | 1 | 2 | 4 | 1 | 2 | 1 | 2.85599 | 0.88146 | 0.54747 | 1.42893 | 4.28492 | 0.03288 | 2.02437 | 0.89738 | 0.73961 | 3.66136 | 2.93214 | 0.73859 | 0.27861 | 3.75279 | 10/31/2019 | 16 | 12 | 4 | 108 | 1 | 0 | 108 | 09/20/2018 | 27 | 9 | 18 | 128 | 1 | 0 | 128 | 2017-07-13 | 13 | 10 | 12 | 1 | 72 | 0 | 72 | 108.667 | 1 | 14 | 1 | 11700.00 | 0 | 1 | 2440 BATON ROUGE AVENUE LIMA, OH 45805 (40.771872, -84.145427) | 02/01/2020 | |||||||||||
11866 | 11866 | 1020 Oak Ln, Philadelphia, PA 19126, USA | 40.0545249 | -75.1354291 | 1 | ROOFTOP | 395535 | LAUREL SQUARE HEALTHCARE AND REHABILITATION CENTER | 1020 OAK LANE AVENUE | PHILADELPHIA | PA | 19126 | 2152249898 | 620 | Philadelphia | For profit - Partnership | 87 | 80.6 | Medicare and Medicaid | false | LAUREL SQUARE HEALTHCARE AND REHABILITATION CENTER, LLC | 06/21/1982 | false | false | false | false | Resident | Partial | 2 | 1 | 5 | 5 | 3 | 2 | 2 | 2.35012 | 0.75563 | 0.52308 | 1.27872 | 3.62884 | 0.07199 | 2.12207 | 0.77056 | 0.39862 | 3.29125 | 2.30169 | 0.73738 | 0.4939 | 3.53558 | 12/13/2018 | 24 | 24 | 0 | 164 | 1 | 0 | 164 | 11/01/2017 | 4 | 4 | 4 | 32 | 1 | 0 | 32 | 2017-01-12 | 3 | 3 | 0 | 1 | 20 | 0 | 20 | 96 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
12021 | 12021 | 160 EAST MAIN STREET PORT JERVIS, NY 12771 | 41.367766 | -74.682593 | 0 | 335692 | ST JOSEPHS PLACE | 160 EAST MAIN STREET | PORT JERVIS | NY | 12771 | 8458565351 | 540 | Orange | Non profit - Church related | 46 | 44.6 | Medicare and Medicaid | true | BON SECOURS COMMUNITY HOSPITAL | 04/11/1988 | false | false | false | false | Both | Partial | 4 | 4 | 4 | 4 | 4 | 3 | 4 | 1.69352 | 0.82776 | 0.94824 | 1.776 | 3.46952 | 0 | 2.26591 | 0.7241 | 0.35658 | 3.3466 | 1.55333 | 0.85958 | 1.00089 | 3.32444 | 06/07/2019 | 4 | 4 | 0 | 12 | 1 | 0 | 12 | 08/24/2017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-06-30 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 7.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 160 EAST MAIN STREET PORT JERVIS, NY 12771 (41.367766, -74.682593) | 02/01/2020 | |||||||||||
14803 | 14803 | 875 JERUSALEM AVENUE UNIONDALE, NY 11553 | 40.697401 | -73.585634 | 0 | 335023 | A HOLLY PATTERSON EXTENDED CARE FACILITY | 875 JERUSALEM AVENUE | UNIONDALE | NY | 11553 | 5165721400 | 400 | Nassau | Government - State | 589 | 467.5 | Medicare and Medicaid | true | NASSAU HEALTH CARE CORPORATION | 01/01/1967 | false | false | false | false | Both | Partial | 5 | 5 | 5 | 5 | 3 | 3 | 3 | 1.95729 | 0.61638 | 0.55886 | 1.17523 | 3.13252 | 0.02283 | 1.9698 | 0.69253 | 0.38506 | 3.04739 | 2.06513 | 0.66926 | 0.54627 | 3.29624 | 10/17/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 06/06/2018 | 2 | 2 | 0 | 4 | 1 | 0 | 4 | 2017-02-17 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 2.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 875 JERUSALEM AVENUE UNIONDALE, NY 11553 (40.697401, -73.585634) | 02/01/2020 | |||||||||||
15066 | 15066 | 1 Country Ln, Brookville, OH 45309, USA | 39.8412624 | -84.4038817 | 1 | ROOFTOP | 365422 | BROOKHAVEN NURSING & REHABILITATION CENTER | ONE COUNTRY LANE | BROOKVILLE | OH | 45309 | 9378332133 | 580 | Montgomery | For profit - Corporation | 110 | 83.8 | Medicare and Medicaid | false | BROOKVILLE ENTERPRISE INC. | 10/02/1979 | true | false | false | false | Resident | Partial | 4 | 2 | 5 | 3 | 5 | 4 | 3 | 2.9008 | 1.12753 | 0.77704 | 1.90456 | 4.80537 | 0.12733 | 2.24121 | 0.82937 | 0.41746 | 3.48804 | 2.69 | 1.02226 | 0.70058 | 4.41772 | 11/21/2019 | 10 | 9 | 1 | 64 | 1 | 0 | 64 | 09/20/2018 | 14 | 11 | 3 | 84 | 1 | 0 | 84 | 2017-06-28 | 6 | 5 | 1 | 1 | 40 | 0 | 40 | 66.667 | 0 | 4 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
15367 | 15367 | 3756 W ERIE AVE LORAIN, OH 44053 | 41.450978 | -82.217052 | 0 | 365969 | ANCHOR LODGE NURSING HOME INC | 3756 W ERIE AVE | LORAIN | OH | 44053 | 4402442019 | 480 | Lorain | For profit - Corporation | 114 | 93.8 | Medicare and Medicaid | false | ANCHOR LODGE NURSING HOME, INC. | 07/01/1994 | false | false | false | false | None | Partial | 4 | 3 | 5 | 4 | 5 | 2 | 2 | 2.03123 | 0.95113 | 0.50888 | 1.46001 | 3.49124 | 0.07007 | 2.24522 | 0.88123 | 0.47343 | 3.59988 | 1.88026 | 0.81158 | 0.40457 | 3.10989 | 10/31/2019 | 6 | 6 | 0 | 20 | 1 | 0 | 20 | 09/20/2018 | 15 | 12 | 3 | 76 | 1 | 0 | 76 | 2017-07-20 | 3 | 3 | 0 | 1 | 28 | 0 | 28 | 40 | 0 | 1 | 0 | 0.00 | 0 | 0 | 3756 W ERIE AVE LORAIN, OH 44053 (41.450978, -82.217052) | 02/01/2020 | |||||||||||
12036 | 12036 | 60 EASTER AVE WEAVERVILLE, CA 96093 | 40.737579 | -122.939444 | 0 | 555907 | TRINITY HOSPITAL SKILLED NURSING FACILITY | 60 EASTER AVE | WEAVERVILLE | CA | 96093 | 5306235541 | 630 | Trinity | Government - Hospital district | 23 | 11.7 | Medicare and Medicaid | true | MOUNTAIN COMMUNITIES HEALTHCARE DISTRICT | 09/26/2017 | false | false | false | false | Resident | Partial | 2 | 4 | 1 | 1 | 2 | 1 | 12 | 1 | 12 | 3.00859 | 2.13626 | 0.96054 | 3.0968 | 6.10539 | 0 | 1.92698 | 0.65272 | 0.2724 | 2.8521 | 3.2449 | 2.46099 | 1.32722 | 6.86439 | 08/28/2019 | 10 | 9 | 1 | 32 | 1 | 0 | 32 | 10/03/2018 | 7 | 7 | 7 | 40 | 1 | 0 | 40 | 2017-07-12 | 2 | 2 | 0 | 2 | 12 | 6 | 18 | 32.333 | 3 | 0 | 0 | 0.00 | 0 | 0 | 60 EASTER AVE WEAVERVILLE, CA 96093 (40.737579, -122.939444) | 02/01/2020 | |||||||||
4083 | 4083 | 1051 BRIGHTSEAT ROAD LANDOVER, MD 20785 | 38.905084 | -76.853481 | 0 | 215364 | FUTURE CARE CAPITAL REGION | 1051 BRIGHTSEAT ROAD | LANDOVER | MD | 20785 | 2404874400 | 160 | Prince Georges | For profit - Corporation | 150 | 126.2 | Medicare and Medicaid | false | PRINCE GEORGES POST ACUTE LLC | 05/01/2018 | false | false | false | false | Resident | Partial | 5 | 4 | 5 | 4 | 5 | 4 | 4 | 2.38351 | 0.95187 | 1.77362 | 2.72549 | 5.10899 | 0.2057 | 2.31092 | 1.01568 | 0.69207 | 4.01867 | 2.14362 | 0.7047 | 0.96458 | 4.07668 | 08/15/2019 | 10 | 9 | 1 | 60 | 1 | 0 | 60 | 04/27/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | . | . | . | . | . | . | . | 39.2 | 0 | 3 | 0 | 0.00 | 0 | 0 | 1051 BRIGHTSEAT ROAD LANDOVER, MD 20785 (38.905084, -76.853481) | 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 );