nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
22 rows where Overall Rating = 2 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-03-16
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, prvdr_type, Provider Resides in Hospital, Abuse Icon, With a Resident and Family Council, Health Inspection Rating, QM Rating, 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, Rating Cycle 1 Standard Survey Health Date, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 1 Total Health Score, Rating Cycle 2 Standard Health Survey Date, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 2 Total Health Score, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Health Revisit Score, Rating Cycle 3 Total Health Score, Total Weighted Health Survey Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, Total Amount of Fines in Dollars, Number of Payment Denials, Total Number of Penalties, Location, Rating Cycle 3 Standard Health Survey Date (date)
Link | rowid ▼ | address | lat | lng | geocode_flag | geocode_accuracy | prvdr_nmbr | prvdr_nm | prvdr_add | prvdr_city | prvdr_state | prvdr_zip | prvdr_phn | prvdr_cnty | prvdr_cnty_name | ownership | nmbr_beds | avg_residents | prvdr_type | Provider Resides in Hospital | Legal Business Name | Date First Approved to Provide Medicare and Medicaid services | Continuing Care Retirement Community | Special Focus Status | Abuse Icon | Most Recent Health Inspection More Than 2 Years Ago | Provider Changed Ownership in Last 12 Months | With a Resident and Family Council | Automatic Sprinkler Systems in All Required Areas | Overall Rating | Overall Rating Footnote | Health Inspection Rating | Health Inspection Rating Footnote | QM Rating | QM Rating Footnote | Long-Stay QM Rating | Long-Stay QM Rating Footnote | Short-Stay QM Rating | Short-Stay QM Rating Footnote | Staffing Rating | Staffing Rating Footnote | RN Staffing Rating | RN Staffing Rating Footnote | Reported Staffing Footnote | Physical Therapist Staffing Footnote | Reported Nurse Aide Staffing Hours per Resident per Day | Reported LPN Staffing Hours per Resident per Day | Reported RN Staffing Hours per Resident per Day | Reported Licensed Staffing Hours per Resident per Day | Reported Total Nurse Staffing Hours per Resident per Day | Reported Physical Therapist Staffing Hours per Resident Per Day | Case-Mix Nurse Aide Staffing Hours per Resident per Day | Case-Mix LPN Staffing Hours per Resident per Day | Case-Mix RN Staffing Hours per Resident per Day | Case-Mix Total Nurse Staffing Hours per Resident per Day | Adjusted Nurse Aide Staffing Hours per Resident per Day | Adjusted LPN Staffing Hours per Resident per Day | Adjusted RN Staffing Hours per Resident per Day | Adjusted Total Nurse Staffing Hours per Resident per Day | Rating Cycle 1 Standard Survey Health Date | Rating Cycle 1 Total Number of Health Deficiencies | Rating Cycle 1 Number of Standard Health Deficiencies | Rating Cycle 1 Number of Complaint Health Deficiencies | Rating Cycle 1 Health Deficiency Score | Rating Cycle 1 Number of Health Revisits | Rating Cycle 1 Health Revisit Score | Rating Cycle 1 Total Health Score | Rating Cycle 2 Standard Health Survey Date | Rating Cycle 2 Total Number of Health Deficiencies | Rating Cycle 2 Number of Standard Health Deficiencies | Rating Cycle 2 Number of Complaint Health Deficiencies | Rating Cycle 2 Health Deficiency Score | Rating Cycle 2 Number of Health Revisits | Rating Cycle 2 Health Revisit Score | Rating Cycle 2 Total Health Score | Rating Cycle 3 Standard Health Survey Date | Rating Cycle 3 Total Number of Health Deficiencies | Rating Cycle 3 Number of Standard Health Deficiencies | Rating Cycle 3 Number of Complaint Health Deficiencies | Rating Cycle 3 Number of Health Revisits | Rating Cycle 3 Health Deficiency Score | Rating Cycle 3 Health Revisit Score | Rating Cycle 3 Total Health Score | Total Weighted Health Survey Score | Number of Facility Reported Incidents | Number of Substantiated Complaints | Number of Fines | Total Amount of Fines in Dollars | Number of Payment Denials | Total Number of Penalties | Location | Processing Date |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2790 | 2790 | 401 ORANGE PLACE WAUCHULA, FL 33873 | 27.534877 | -81.814223 | 0 | 105362 | HARDEE MANOR HEALTHCARE CENTER | 401 ORANGE PLACE | WAUCHULA | FL | 33873 | 8637733231 | 240 | Hardee | For profit - Corporation | 79 | 63.8 | Medicare and Medicaid | false | DIVERSICARE LEASING CORP. | 02/19/1980 | false | false | false | false | Resident | Yes | 2 | 2 | 3 | 5 | 1 | 3 | 3 | 2.55569 | 0.96259 | 0.45827 | 1.42086 | 3.97655 | 0.01451 | 1.88593 | 0.69673 | 0.32915 | 2.91181 | 2.81644 | 1.03887 | 0.52403 | 4.37922 | 07/03/2019 | 9 | 7 | 2 | 36 | 1 | 0 | 36 | 03/22/2018 | 9 | 8 | 1 | 80 | 1 | 0 | 80 | 2017-03-16 | 7 | 7 | 0 | 1 | 48 | 0 | 48 | 52.667 | 1 | 2 | 1 | 10475.00 | 0 | 1 | 401 ORANGE PLACE WAUCHULA, FL 33873 (27.534877, -81.814223) | 02/01/2020 | |||||||||||
3439 | 3439 | 111 E Van Buren St, Lenox, IA 50851, USA | 40.8856567 | -94.5567825 | 1 | ROOFTOP | 165235 | LENOX CARE CENTER | 111 EAST VAN BUREN | LENOX | IA | 50851 | 6413332226 | 860 | Taylor | For profit - Partnership | 46 | 28.2 | Medicare and Medicaid | false | PREMIER ESTATES 507, LLC | 11/01/1994 | false | false | false | false | Resident | Yes | 2 | 2 | 2 | 2 | 2 | 3 | 4 | 1.61713 | 0.82891 | 0.7931 | 1.62201 | 3.23914 | 0.01016 | 2.03709 | 0.73383 | 0.39232 | 3.16324 | 1.64988 | 0.84936 | 0.76089 | 3.28361 | 08/23/2019 | 4 | 2 | 2 | 28 | 1 | 0 | 28 | 06/07/2018 | 5 | 2 | 3 | 36 | 1 | 0 | 36 | 2017-03-16 | 5 | 4 | 3 | 1 | 24 | 0 | 24 | 30 | 2 | 4 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
4771 | 4771 | 328 MUNGER LANE HANNIBAL, MO 63401 | 39.719468 | -91.400536 | 0 | 265462 | WILLOW CARE REHABILITATION & HEALTH CARE CENTER | 328 MUNGER LANE | HANNIBAL | MO | 63401 | 5732219122 | 630 | Marion | For profit - Corporation | 111 | 52.8 | Medicare and Medicaid | false | TUTERA ACQUIRERS, INC | 08/02/1991 | false | false | false | false | Both | Yes | 2 | 2 | 4 | 2 | 5 | 2 | 2 | 1.66603 | 0.96579 | 0.39067 | 1.35645 | 3.02248 | 0.02043 | 1.9615 | 0.65942 | 0.29051 | 2.91143 | 1.76527 | 1.10128 | 0.50615 | 3.32897 | 05/02/2019 | 17 | 11 | 6 | 100 | 1 | 0 | 100 | 02/16/2018 | 10 | 7 | 3 | 72 | 1 | 0 | 72 | 2017-03-16 | 3 | 3 | 0 | 1 | 16 | 0 | 16 | 76.667 | 0 | 15 | 0 | 0.00 | 0 | 0 | 328 MUNGER LANE HANNIBAL, MO 63401 (39.719468, -91.400536) | 02/01/2020 | |||||||||||
5038 | 5038 | 3523 WICKENHAUSER ALTON, IL 62002 | 38.889152 | -90.126033 | 0 | 145427 | INTEGRITY HC OF ALTON | 3523 WICKENHAUSER | ALTON | IL | 62002 | 6184658887 | 680 | Madison | For profit - Individual | 181 | 76.3 | Medicare and Medicaid | false | ALTON REHABILITATION AND NURSING CENTER, LLC | 08/28/1981 | false | false | false | false | Both | Yes | 2 | 2 | 4 | 4 | 4 | 2 | 2 | 1.1013 | 0.40903 | 0.39538 | 0.80441 | 1.90572 | 0.03313 | 2.01972 | 0.78806 | 0.41483 | 3.2226 | 1.13327 | 0.39028 | 0.35874 | 1.89629 | 12/20/2018 | 20 | 10 | 10 | 136 | 1 | 0 | 136 | 02/20/2018 | 11 | 8 | 3 | 56 | 1 | 0 | 56 | 2017-03-16 | 11 | 8 | 3 | 1 | 48 | 0 | 48 | 94.667 | 0 | 14 | 0 | 0.00 | 0 | 0 | 3523 WICKENHAUSER ALTON, IL 62002 (38.889152, -90.126033) | 02/01/2020 | |||||||||||
5424 | 5424 | 78 OPAL STREET CARTERSVILLE, GA 30120 | 34.179934 | -84.786583 | 0 | 115571 | CARTERSVILLE CENTER FOR NURSING AND HEALING | 78 OPAL STREET | CARTERSVILLE | GA | 30120 | 7703826120 | 60 | Bartow | For profit - Corporation | 118 | 111.3 | Medicare and Medicaid | false | CARTERSVILLE NURSING LLC | 07/01/1994 | false | false | false | false | Resident | Yes | 2 | 2 | 2 | 1 | 4 | 2 | 3 | 1.50633 | 0.81201 | 0.51927 | 1.33128 | 2.8376 | 0.04862 | 2.13788 | 0.76958 | 0.36342 | 3.27089 | 1.46437 | 0.79339 | 0.53779 | 2.78188 | 04/18/2019 | 6 | 6 | 6 | 40 | 1 | 0 | 40 | 03/22/2018 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 2017-03-16 | 3 | 3 | 3 | 1 | 20 | 0 | 20 | 31.333 | 0 | 3 | 0 | 0.00 | 0 | 0 | 78 OPAL STREET CARTERSVILLE, GA 30120 (34.179934, -84.786583) | 02/01/2020 | |||||||||||
5853 | 5853 | 1919 WEST MEDICAL STREET TUCSON, AZ 85704 | 32.321988 | -111.007223 | 0 | 35070 | CASAS ADOBES POST ACUTE REHAB CENTER | 1919 WEST MEDICAL STREET | TUCSON | AZ | 85704 | 5202978311 | 90 | Pima | For profit - Corporation | 230 | 115.2 | Medicare and Medicaid | false | SENTINEL PEAK HEALTHCARE, INC | 04/17/1979 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 4 | 4 | 2 | 2 | 2.15606 | 1.21426 | 0.30262 | 1.51688 | 3.67294 | 0.04806 | 1.95307 | 0.71326 | 0.32965 | 2.99599 | 2.29434 | 1.2801 | 0.34552 | 3.93121 | 06/27/2019 | 7 | 7 | 1 | 72 | 1 | 0 | 72 | 04/12/2018 | 3 | 3 | 1 | 12 | 1 | 0 | 12 | 2017-03-16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 3 | 0 | 0.00 | 0 | 0 | 1919 WEST MEDICAL STREET TUCSON, AZ 85704 (32.321988, -111.007223) | 02/01/2020 | |||||||||||
6728 | 6728 | 21017 MIDDLEBELT RD FARMINGTON HILLS, MI 48336 | 42.443757 | -83.336404 | 0 | 235508 | THE MANOR OF FARMINGTON HILLS | 21017 MIDDLEBELT RD | FARMINGTON HILLS | MI | 48336 | 2484768300 | 620 | Oakland | For profit - Individual | 99 | 94 | Medicare and Medicaid | false | RHEMA FARMINGTON INC | 08/13/1991 | false | false | false | false | Resident | Yes | 2 | 2 | 3 | 4 | 1 | 2 | 2 | 2.01447 | 0.99333 | 0.41878 | 1.41211 | 3.42658 | 0.04119 | 2.07691 | 0.70276 | 0.31382 | 3.0935 | 2.01585 | 1.06284 | 0.50227 | 3.55193 | 04/24/2019 | 21 | 13 | 8 | 152 | 1 | 0 | 152 | 04/19/2018 | 24 | 15 | 10 | 136 | 1 | 0 | 136 | 2017-03-16 | 8 | 7 | 3 | 1 | 36 | 0 | 36 | 127.333 | 4 | 33 | 0 | 0.00 | 0 | 0 | 21017 MIDDLEBELT RD FARMINGTON HILLS, MI 48336 (42.443757, -83.336404) | 02/01/2020 | |||||||||||
6991 | 6991 | 14716 S EASTERN AVENUE PLAINFIELD, IL 60544 | 41.61498 | -88.196596 | 0 | 145761 | LAKEWOOD NRSG & REHAB CENTER | 14716 S EASTERN AVENUE | PLAINFIELD | IL | 60544 | 8154363400 | 989 | Will | For profit - Individual | 131 | 111.7 | Medicare and Medicaid | false | LAKEWOOD NURSING AND REHABILITATION CENTER, LLC | 07/07/1993 | false | false | false | false | Resident | Yes | 2 | 2 | 3 | 4 | 3 | 2 | 3 | 1.83584 | 0.65608 | 0.70486 | 1.36094 | 3.19678 | 0.08761 | 2.23423 | 0.85082 | 0.43984 | 3.52489 | 1.70774 | 0.57984 | 0.60317 | 2.90817 | 05/15/2019 | 15 | 10 | 5 | 132 | 1 | 0 | 132 | 04/19/2018 | 4 | 2 | 2 | 16 | 1 | 0 | 16 | 2017-03-16 | 11 | 8 | 3 | 1 | 60 | 0 | 60 | 81.333 | 0 | 9 | 0 | 0.00 | 1 | 1 | 14716 S EASTERN AVENUE PLAINFIELD, IL 60544 (41.61498, -88.196596) | 02/01/2020 | |||||||||||
7052 | 7052 | 310 BOXWOOD RUN ROAD MOUNT WASHINGTON, KY 40047 | 38.040815 | -85.560739 | 0 | 185464 | BEDROCK HC AT GREEN MEADOWS, LLC | 310 BOXWOOD RUN ROAD | MOUNT WASHINGTON | KY | 40047 | 5029557600 | 140 | Bullitt | For profit - Corporation | 122 | 88.7 | Medicare and Medicaid | false | BEDROCK HC AT GREEN MEADOWS LLC | 07/22/2009 | false | false | false | false | Resident | Yes | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 1.82647 | 1.24205 | 0.53199 | 1.77404 | 3.60052 | 0.15736 | 2.09384 | 0.74138 | 0.35116 | 3.18638 | 1.81295 | 1.25974 | 0.57021 | 3.62343 | 06/28/2019 | 19 | 12 | 7 | 84 | 1 | 0 | 84 | 04/26/2018 | 4 | 3 | 1 | 16 | 1 | 0 | 16 | 2017-03-16 | 12 | 4 | 10 | 2 | 112 | 56 | 168 | 75.333 | 5 | 2 | 1 | 34145.00 | 0 | 1 | 310 BOXWOOD RUN ROAD MOUNT WASHINGTON, KY 40047 (38.040815, -85.560739) | 02/01/2020 | |||||||||||
7276 | 7276 | 310 TERRACE AVE WEST HAVEN, CT 06516 | 41.283035 | -72.969025 | 0 | 75201 | REGALCARE AT WEST HAVEN | 310 TERRACE AVE | WEST HAVEN | CT | 6516 | 2039322247 | 40 | New Haven | For profit - Corporation | 98 | 93 | Medicare and Medicaid | false | REGALCARE AT WEST HAVEN LLC | 11/13/1970 | false | true | false | false | Both | Yes | 2 | 2 | 4 | 4 | 4 | 3 | 3 | 1.7611 | 0.85284 | 0.63578 | 1.48862 | 3.24972 | 0.05673 | 1.94182 | 0.74605 | 0.38511 | 3.07299 | 1.88491 | 0.85957 | 0.62137 | 3.39107 | 04/17/2019 | 14 | 14 | 4 | 56 | 1 | 0 | 56 | 03/01/2018 | 8 | 8 | 0 | 60 | 1 | 0 | 60 | 2017-03-16 | 11 | 11 | 0 | 1 | 44 | 0 | 44 | 55.333 | 0 | 3 | 1 | 8125.00 | 0 | 1 | 310 TERRACE AVE WEST HAVEN, CT 06516 (41.283035, -72.969025) | 02/01/2020 | |||||||||||
8683 | 8683 | 125 BUENA VISTA CIRCLE SOUTH HILL, VA 23970 | 36.734491 | -78.133439 | 0 | 495177 | COMMUNITY MEMORIAL HOSPITAL HUNDLEY CENTER | 125 BUENA VISTA CIRCLE | SOUTH HILL | VA | 23970 | 4344473151 | 580 | Mecklenburg | Non profit - Corporation | 140 | 88.6 | Medicare and Medicaid | false | COMMUNITY MEMORIAL HOSPITAL | 10/14/1987 | false | false | false | false | Resident | Yes | 2 | 1 | 2 | 2 | 2 | 5 | 5 | 2.00984 | 1.30089 | 1.12452 | 2.42541 | 4.43524 | 0.03783 | 2.18367 | 0.73505 | 0.36696 | 3.28568 | 1.91289 | 1.33079 | 1.15339 | 4.32858 | 05/30/2019 | 16 | 16 | 0 | 132 | 2 | 66 | 198 | 05/10/2018 | 15 | 15 | 0 | 128 | 2 | 64 | 192 | 2017-03-16 | 11 | 11 | 0 | 1 | 48 | 0 | 48 | 171 | 0 | 0 | 1 | 59618.00 | 1 | 2 | 125 BUENA VISTA CIRCLE SOUTH HILL, VA 23970 (36.734491, -78.133439) | 02/01/2020 | |||||||||||
8735 | 8735 | 3855 SOUTH 700 EAST SALT LAKE CITY, UT 84106 | 40.688771 | -111.871385 | 0 | 465094 | WOODLAND PARK REHABILITATION AND CARE CENTER | 3855 SOUTH 700 EAST | SALT LAKE CITY | UT | 84106 | 8012684766 | 170 | Salt Lake | Government - County | 184 | 105.5 | Medicare and Medicaid | false | GUNNISON VALLEY HOSPITAL | 07/16/1984 | false | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 5 | 4 | 4 | 2.27263 | 0.60322 | 1.22793 | 1.83115 | 4.10377 | 0.08238 | 2.12151 | 0.8772 | 0.4993 | 3.49801 | 2.22638 | 0.51708 | 0.92564 | 3.76198 | 08/19/2019 | 30 | 28 | 2 | 196 | 1 | 0 | 196 | 07/19/2018 | 9 | 9 | 2 | 44 | 1 | 0 | 44 | 2017-03-16 | 22 | 22 | 0 | 1 | 148 | 0 | 148 | 137.333 | 0 | 4 | 1 | 10286.00 | 0 | 1 | 3855 SOUTH 700 EAST SALT LAKE CITY, UT 84106 (40.688771, -111.871385) | 02/01/2020 | |||||||||||
9386 | 9386 | 3525 3533 RIVERS EDGE DRIVE PERRYSBURG, OH 43551 | 41.50894 | -83.652396 | 0 | 366354 | OTTERBEIN PERRYSBURG | 3525 - 3533 RIVERS EDGE DRIVE | PERRYSBURG | OH | 43551 | 4198742428 | 880 | Wood | Non profit - Church related | 50 | 47.6 | Medicare and Medicaid | false | OTTERBEIN PERRYSBURG | 10/02/2007 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 5 | 2 | 3 | 2 | 3.86044 | 0.83326 | 0.46391 | 1.29717 | 5.15761 | 0.03658 | 2.2079 | 0.84266 | 0.45009 | 3.50065 | 3.63389 | 0.74355 | 0.38794 | 4.72446 | 06/20/2019 | 9 | 7 | 2 | 72 | 1 | 0 | 72 | 05/08/2018 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 2017-03-16 | 5 | 5 | 0 | 1 | 12 | 0 | 12 | 46 | 0 | 0 | 0 | 0.00 | 0 | 0 | 3525 3533 RIVERS EDGE DRIVE PERRYSBURG, OH 43551 (41.50894, -83.652396) | 02/01/2020 | |||||||||||
9413 | 9413 | 3804 NORTH BARR OKLAHOMA CITY, OK 73122 | 35.509436 | -97.605626 | 0 | 375502 | HERITAGE MANOR | 3804 NORTH BARR | OKLAHOMA CITY | OK | 73122 | 4057897103 | 540 | Oklahoma | For profit - Individual | 55 | 53.4 | Medicare and Medicaid | false | CRANE YOUNG AND ASSOCIATES INC | 11/08/2006 | false | false | false | false | Resident | Yes | 2 | 2 | 3 | 3 | 2 | 3 | 3 | 2.24478 | 0.72175 | 0.37121 | 1.09296 | 3.33774 | 0.00143 | 1.72184 | 0.59594 | 0.25633 | 2.57411 | 2.70954 | 0.91068 | 0.54508 | 4.15794 | 06/17/2019 | 5 | 5 | 1 | 44 | 1 | 0 | 44 | 05/08/2018 | 11 | 11 | 0 | 84 | 2 | 42 | 126 | 2017-03-16 | 13 | 8 | 6 | 1 | 128 | 0 | 128 | 85.333 | 0 | 5 | 1 | 24850.00 | 2 | 3 | 3804 NORTH BARR OKLAHOMA CITY, OK 73122 (35.509436, -97.605626) | 02/01/2020 | |||||||||||
10751 | 10751 | 20611 EUCLID AVE EUCLID, OH 44117 | 41.568024 | -81.536235 | 0 | 365729 | BRAEVIEW MANOR | 20611 EUCLID AVE | EUCLID | OH | 44117 | 2164869300 | 170 | Cuyahoga | For profit - Individual | 97 | 47.9 | Medicare and Medicaid | false | ALLIANCE HEALTHCARE BRAEVIEW, INC. | 04/05/1989 | false | false | false | false | Resident | Yes | 2 | 3 | 1 | 1 | 2 | 2 | 3 | 1.73393 | 0.57955 | 0.66029 | 1.23984 | 2.97377 | 0.02944 | 1.95323 | 0.76945 | 0.36873 | 3.0914 | 1.845 | 0.56636 | 0.674 | 3.08464 | 05/02/2019 | 15 | 12 | 3 | 60 | 1 | 0 | 60 | 05/31/2018 | 5 | 3 | 2 | 32 | 1 | 0 | 32 | 2017-03-16 | 8 | 6 | 2 | 1 | 40 | 0 | 40 | 47.333 | 1 | 6 | 0 | 0.00 | 0 | 0 | 20611 EUCLID AVE EUCLID, OH 44117 (41.568024, -81.536235) | 02/01/2020 | |||||||||||
10814 | 10814 | 1925 E FOURTH ST OTTAWA, OH 45875 | 41.021594 | -84.023685 | 0 | 366217 | AUTUMN COURT | 1925 E FOURTH ST | OTTAWA | OH | 45875 | 4195234370 | 700 | Putnam | For profit - Corporation | 50 | 41.3 | Medicare and Medicaid | false | HEALTHCARE VENTURES OF OHIO LLC | 05/03/2001 | false | false | false | false | Resident | Yes | 2 | 3 | 4 | 4 | 2 | 1 | 12 | 1 | 12 | 1.94743 | 1.08303 | 0.27303 | 1.35605 | 3.30349 | 0.03852 | 2.04044 | 0.83629 | 0.46125 | 3.33799 | 1.98361 | 0.97379 | 0.22279 | 3.17352 | 06/13/2019 | 5 | 3 | 2 | 36 | 1 | 0 | 36 | 05/08/2018 | 5 | 0 | 5 | 20 | 0 | 0 | 20 | 2017-03-16 | 7 | 2 | 5 | 1 | 60 | 0 | 60 | 34.667 | 0 | 6 | 1 | 6830.00 | 0 | 1 | 1925 E FOURTH ST OTTAWA, OH 45875 (41.021594, -84.023685) | 02/01/2020 | |||||||||
11763 | 11763 | 163 LOVE & CARE ROAD SIX MILE, SC 29682 | 34.971114 | -82.438691 | 0 | 425306 | HERITAGE HEALTHCARE OF PICKENS | 163 LOVE & CARE ROAD | SIX MILE | SC | 29682 | 8648682307 | 380 | Pickens | For profit - Corporation | 44 | 39.3 | Medicare and Medicaid | false | PRUITTHEALTH- PICKENS, LLC | 04/11/1991 | false | false | false | false | Resident | Yes | 2 | 3 | 2 | 2 | 1 | 1 | 12 | 1 | 12 | 1.70894 | 0.78787 | 0.69979 | 1.48766 | 3.1966 | 0.12586 | 2.14754 | 0.69868 | 0.30562 | 3.15184 | 1.65387 | 0.84793 | 0.86181 | 3.2522 | 06/13/2019 | 5 | 5 | 0 | 24 | 1 | 0 | 24 | 06/13/2018 | 11 | 11 | 0 | 80 | 1 | 0 | 80 | 2017-03-16 | 1 | 1 | 1 | 1 | 8 | 0 | 8 | 40 | 0 | 0 | 0 | 0.00 | 0 | 0 | 163 LOVE & CARE ROAD SIX MILE, SC 29682 (34.971114, -82.438691) | 02/01/2020 | |||||||||
12002 | 12002 | 74-350 Country Club Dr, Palm Desert, CA 92260, USA | 33.7589916 | -116.3676056 | 1 | ROOFTOP | 555339 | MANORCARE HEALTH SERVICES-PALM DESERT | 74-350 COUNTRY CLUB DRIVE | PALM DESERT | CA | 92260 | 7603410261 | 430 | Riverside | Non profit - Other | 178 | 140.8 | Medicare and Medicaid | false | MANOR CARE OF PALM DESERT CA LLC | 02/09/1989 | false | true | false | false | Resident | Yes | 2 | 1 | 4 | 4 | 4 | 4 | 3 | 2.41797 | 1.58735 | 0.66219 | 2.24955 | 4.66751 | 0.1841 | 2.07603 | 0.77127 | 0.37313 | 3.22043 | 2.42066 | 1.54757 | 0.66796 | 4.64755 | 02/05/2019 | 52 | 15 | 39 | 280 | 1 | 0 | 280 | 03/23/2018 | 13 | 6 | 7 | 56 | 1 | 0 | 56 | 2017-03-16 | 11 | 11 | 0 | 1 | 60 | 0 | 60 | 168.667 | 19 | 22 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
13444 | 13444 | 5360 HARROUN SYLVANIA, OH 43560 | 41.711324 | -83.694426 | 0 | 366436 | HEARTLAND AT PROMEDICA FLOWER HOSPITAL CAMPUS | 5360 HARROUN | SYLVANIA | OH | 43560 | 4195406001 | 490 | Lucas | Non profit - Other | 120 | 57.8 | Medicare and Medicaid | false | HCRMC - PROMEDICA, LLC | 01/28/2016 | false | false | false | false | Resident | Yes | 2 | 1 | 4 | 4 | 4 | 4 | 4 | 2.93826 | 1.60285 | 1.23831 | 2.84116 | 5.77942 | 0.1809 | 2.03658 | 0.84637 | 0.44824 | 3.33119 | 2.9985 | 1.42402 | 1.0398 | 5.56337 | 06/27/2019 | 22 | 15 | 7 | 160 | 1 | 0 | 160 | 05/03/2018 | 21 | 9 | 12 | 104 | 1 | 0 | 104 | 2017-03-16 | 18 | 9 | 18 | 1 | 88 | 0 | 88 | 129.333 | 0 | 23 | 2 | 46833.00 | 0 | 2 | 5360 HARROUN SYLVANIA, OH 43560 (41.711324, -83.694426) | 02/01/2020 | |||||||||||
13456 | 13456 | 725 S ORANGE AVENUE WEST COVINA, CA 91790 | 34.070928 | -117.944166 | 0 | 555649 | WEST COVINA MEDICAL CENTER D/P SNF | 725 S. ORANGE AVENUE | WEST COVINA | CA | 91790 | 8183388481 | 200 | Los Angeles | For profit - Corporation | 33 | 25.4 | Medicare and Medicaid | true | Legal Business Name Not Available | 10/12/1995 | false | false | false | false | None | Yes | 2 | 2 | 4 | 4 | 2 | 3 | 2 | 4.11375 | 4.05008 | 1.56077 | 5.61084 | 9.72459 | 0.01307 | 2.49563 | 1.09689 | 1.65904 | 5.25156 | 3.42589 | 2.7764 | 0.35409 | 5.93795 | 01/31/2019 | 12 | 12 | 0 | 80 | 1 | 0 | 80 | 01/19/2018 | 16 | 16 | 0 | 96 | 1 | 0 | 96 | 2017-03-16 | 10 | 9 | 1 | 1 | 56 | 0 | 56 | 81.333 | 0 | 4 | 0 | 0.00 | 0 | 0 | 725 S ORANGE AVENUE WEST COVINA, CA 91790 (34.070928, -117.944166) | 02/01/2020 | |||||||||||
14786 | 14786 | PR-844, San Juan, 00926, Puerto Rico | 18.3551846 | -66.0400062 | 1 | GEOMETRIC_CENTER | 405031 | HIMA SAN PABLO CUPEY SNF | CARR 844 KM 0 5 CUPEY BAJO | RIO PIEDRAS | PR | 928 | 7877618383 | 640 | San Juan | For profit - Corporation | 25 | 5 | Medicare | true | CENTRO MEDICO DEL TURABO INC | 06/06/2017 | false | false | false | false | None | Yes | 2 | 3 | 4 | 2 | 4 | 1 | 12 | 1 | 12 | 6 | 6 | 05/16/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 07/19/2018 | 6 | 6 | 0 | 52 | 1 | 0 | 52 | 2017-03-16 | 23 | 23 | 0 | 1 | 364 | 0 | 364 | 80 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||
15155 | 15155 | 2740 NORTH CALIFORNIA STREET STOCKTON, CA 95204 | 37.977167 | -121.291722 | 0 | 555105 | DYCORA TRANSITIONAL HEALTH - WEBER OAKS | 2740 NORTH CALIFORNIA STREET | STOCKTON | CA | 95204 | 2094663522 | 490 | San Joaquin | For profit - Corporation | 99 | 94.1 | Medicare and Medicaid | false | DYCORA TRANSITIONAL HEALTH - WEBER OAKS LLC | 12/29/1978 | false | false | false | false | Both | Yes | 2 | 2 | 3 | 4 | 2 | 2 | 2 | 2.47932 | 0.97638 | 0.2397 | 1.21608 | 3.69539 | 0 | 2.0309 | 0.65046 | 0.28309 | 2.96445 | 2.53722 | 1.12872 | 0.31869 | 3.99733 | 03/07/2019 | 20 | 11 | 9 | 128 | 1 | 0 | 128 | 03/08/2018 | 7 | 5 | 2 | 32 | 1 | 0 | 32 | 2017-03-16 | 6 | 5 | 1 | 1 | 28 | 0 | 28 | 79.333 | 14 | 5 | 0 | 0.00 | 0 | 0 | 2740 NORTH CALIFORNIA STREET STOCKTON, CA 95204 (37.977167, -121.291722) | 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 );