nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
24 rows where Health Inspection Rating = 3 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-02-16
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, avg_residents, prvdr_type, Provider Resides in Hospital, Legal Business Name, Continuing Care Retirement Community, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall 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 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 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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
132 | 132 | 9171 COCKERHAM ROAD DENHAM SPRINGS, LA 70726 | 30.505251 | -90.935302 | 0 | 195501 | HARVEST MANOR HEALTHCARE AND REHABILITATION CENTER | 9171 COCKERHAM ROAD | DENHAM SPRINGS | LA | 70726 | 2256658946 | 310 | Livingston | For profit - Corporation | 171 | 154.5 | Medicare and Medicaid | false | Legal Business Name Not Available | 10/13/2000 | false | false | false | false | Resident | Yes | 3 | 3 | 5 | 5 | 3 | 1 | 1 | 2.15811 | 1.08806 | 0.12615 | 1.21422 | 3.37232 | 0.04046 | 2.14941 | 0.7569 | 0.35203 | 3.25835 | 2.08674 | 1.08093 | 0.13488 | 3.31883 | 03/28/2019 | 3 | 2 | 1 | 16 | 2 | 8 | 24 | 02/23/2018 | 6 | 4 | 2 | 36 | 1 | 0 | 36 | 2017-02-16 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 26 | 0 | 2 | 0 | 0.00 | 0 | 0 | 9171 COCKERHAM ROAD DENHAM SPRINGS, LA 70726 (30.505251, -90.935302) | 02/01/2020 | |||||||||||
1844 | 1844 | 600 E GARFIELD STREET IOLA, KS 66749 | 37.933446 | -95.397358 | 0 | 175226 | WINDSOR PLACE AT IOLA LLC | 600 E GARFIELD STREET | IOLA | KS | 66749 | 6203653183 | 0 | Allen | For profit - Individual | 45 | 44.2 | Medicare and Medicaid | false | HEALTH MANAGEMENT OF KANSAS INC | 06/01/1992 | false | false | false | false | Resident | Yes | 4 | 3 | 4 | 5 | 3 | 5 | 5 | 2.38738 | 0.55463 | 0.8917 | 1.44633 | 3.83371 | 0.02931 | 1.90642 | 0.67449 | 0.31 | 2.8909 | 2.60268 | 0.61832 | 1.08266 | 4.25244 | 06/18/2019 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 09/13/2018 | 13 | 12 | 1 | 100 | 1 | 0 | 100 | 2017-02-16 | 8 | 8 | 0 | 1 | 72 | 0 | 72 | 51.333 | 1 | 0 | 2 | 65234.00 | 1 | 3 | 600 E GARFIELD STREET IOLA, KS 66749 (37.933446, -95.397358) | 02/01/2020 | |||||||||||
2379 | 2379 | 100 WEST RAMSEY DAWSON SPRINGS, KY 42408 | 37.165811 | -87.691968 | 0 | 185133 | TRADEWATER POINTE | 100 WEST RAMSEY | DAWSON SPRINGS | KY | 42408 | 2707978132 | 530 | Hopkins | For profit - Corporation | 60 | 41 | Medicare and Medicaid | false | TRADEWATER POINTE, LLC | 07/14/1981 | false | false | false | false | Resident | Yes | 3 | 3 | 1 | 1 | 1 | 4 | 4 | 2.45681 | 0.35431 | 0.73075 | 1.08505 | 3.54187 | 0.09357 | 2.04035 | 0.75397 | 0.36464 | 3.15897 | 2.50255 | 0.35335 | 0.75427 | 3.59534 | 06/06/2019 | 5 | 2 | 3 | 20 | 1 | 0 | 20 | 03/15/2018 | 9 | 7 | 2 | 40 | 1 | 0 | 40 | 2017-02-16 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 25.333 | 1 | 2 | 0 | 0.00 | 0 | 0 | 100 WEST RAMSEY DAWSON SPRINGS, KY 42408 (37.165811, -87.691968) | 02/01/2020 | |||||||||||
3654 | 3654 | 20 BABCOCK AVENUE PLAINFIELD, CT 06374 | 41.678696 | -71.917758 | 0 | 75084 | VILLA MARIA NURSING & REHAB COMMUNITY, INC | 20 BABCOCK AVENUE | PLAINFIELD | CT | 6374 | 8605643387 | 70 | Windham | For profit - Corporation | 62 | 54.1 | Medicare and Medicaid | false | Legal Business Name Not Available | 03/01/1974 | false | false | false | false | Resident | Yes | 5 | 3 | 5 | 3 | 5 | 5 | 5 | 2.28916 | 0.61494 | 1.08284 | 1.69778 | 3.98694 | 0.05947 | 2.13301 | 0.70738 | 0.30834 | 3.14874 | 2.23048 | 0.65367 | 1.32179 | 4.06029 | 04/26/2019 | 8 | 6 | 3 | 32 | 1 | 0 | 32 | 03/12/2018 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 2017-02-16 | 5 | 5 | 1 | 1 | 40 | 0 | 40 | 28 | 4 | 0 | 1 | 1991.00 | 0 | 1 | 20 BABCOCK AVENUE PLAINFIELD, CT 06374 (41.678696, -71.917758) | 02/01/2020 | |||||||||||
3725 | 3725 | 7300 US-78, Pell City, AL 35128, USA | 33.5758858 | -86.4145388 | 1 | ROOFTOP | 15400 | MEADOWVIEW NURSING CENTER | 7300 OLD HIGHWAY 78 EAST | PELL CITY | AL | 35128 | 2056405212 | 570 | St. Clair | For profit - Corporation | 59 | 56.1 | Medicare and Medicaid | false | ST. CLAIR HEALTH & REHAB, INC. | 02/11/1988 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 3 | 5 | 2 | 2 | 2.33224 | 1.17256 | 0.33175 | 1.50431 | 3.83654 | 0.02289 | 2.04394 | 0.70338 | 0.31583 | 3.06315 | 2.37149 | 1.2535 | 0.39536 | 4.01629 | 02/28/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 03/29/2018 | 4 | 4 | 0 | 24 | 1 | 0 | 24 | 2017-02-16 | 5 | 5 | 0 | 1 | 32 | 0 | 32 | 17.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
5255 | 5255 | 745 BASINGER MEMORIAL DRIVE MOUNTAIN LAKE, MN 56159 | 43.942563 | -94.937066 | 0 | 245549 | GOOD SAMARITAN SOCIETY - MOUNTAIN LAKE | 745 BASINGER MEMORIAL DRIVE | MOUNTAIN LAKE | MN | 56159 | 5074272464 | 160 | Cottonwood | Non profit - Church related | 53 | 47.1 | Medicare and Medicaid | false | THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY | 02/01/1991 | false | false | false | false | Resident | Yes | 5 | 3 | 5 | 5 | 2 | 4 | 4 | 2.21193 | 0.50473 | 0.7763 | 1.28103 | 3.49296 | 0.03095 | 1.93904 | 0.64072 | 0.27902 | 2.85879 | 2.37083 | 0.59234 | 1.04719 | 3.91801 | 12/06/2018 | 9 | 9 | 0 | 48 | 1 | 0 | 48 | 10/05/2017 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 2017-02-16 | 7 | 7 | 0 | 1 | 40 | 0 | 40 | 38.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 745 BASINGER MEMORIAL DRIVE MOUNTAIN LAKE, MN 56159 (43.942563, -94.937066) | 02/01/2020 | |||||||||||
5404 | 5404 | 2616 N College Ave, Jackson, AL 36545, USA | 31.556752 | -87.8765674 | 1 | RANGE_INTERPOLATED | 15188 | JACKSON HEALTH CARE FACILITY | 2616 NORTH COLLEGE AVENUE | JACKSON | AL | 36545 | 2512462476 | 120 | Clarke | For profit - Corporation | 91 | 79 | Medicare and Medicaid | false | JACKSON HEALTH CARE FACILITY, LLC | 09/01/1977 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 4 | 3 | 3 | 2.5129 | 1.00065 | 0.57205 | 1.5727 | 4.0856 | 0.01261 | 2.19155 | 0.69738 | 0.3109 | 3.19983 | 2.38309 | 1.07894 | 0.69254 | 4.09432 | 02/28/2019 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 12/14/2017 | 4 | 4 | 1 | 16 | 1 | 0 | 16 | 2017-02-16 | 2 | 2 | 0 | 1 | 20 | 0 | 20 | 20.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
5500 | 5500 | 200 LIGHTHOUSE AVENUE PACIFIC GROVE, CA 93950 | 36.618524 | -121.908083 | 0 | 55356 | PACIFIC GROVE HEALTHCARE CENTER | 200 LIGHTHOUSE AVENUE | PACIFIC GROVE | CA | 93950 | 8313752695 | 370 | Monterey | For profit - Corporation | 51 | 45.3 | Medicare and Medicaid | false | 200 LIGHTHOUSE, LLC | 08/01/1971 | false | false | false | true | Resident | Yes | 4 | 3 | 5 | 4 | 5 | 3 | 2 | 2.4533 | 1.18943 | 0.41446 | 1.60389 | 4.05718 | 0 | 2.07432 | 0.69855 | 0.31768 | 3.09055 | 2.45804 | 1.28034 | 0.49104 | 4.2096 | 02/22/2019 | 18 | 15 | 3 | 112 | 1 | 0 | 112 | 01/31/2018 | 8 | 8 | 0 | 40 | 1 | 0 | 40 | 2017-02-16 | 2 | 2 | 0 | 1 | 4 | 0 | 4 | 70 | 0 | 4 | 0 | 0.00 | 0 | 0 | 200 LIGHTHOUSE AVENUE PACIFIC GROVE, CA 93950 (36.618524, -121.908083) | 02/01/2020 | |||||||||||
6091 | 6091 | 5211 Hwy 110, Aurora, MN 55705, USA | 47.51805479999999 | -92.22954469999999 | 1 | ROOFTOP | 245469 | ESSENTIA HEALTH NORTHERN PINES MEDICAL CENTER | 5211 HIGHWAY 110 | AURORA | MN | 55705 | 2182294222 | 680 | St. Louis | Non profit - Corporation | 33 | 31.2 | Medicare and Medicaid | true | NORTHERN PINES MEDICAL CENTER | 04/01/1987 | false | false | false | false | Resident | Yes | 5 | 3 | 5 | 5 | 2 | 4 | 4 | 2.26421 | 0.40783 | 0.65766 | 1.06549 | 3.3297 | 0.00405 | 1.95425 | 0.62573 | 0.2466 | 2.82658 | 2.40798 | 0.49009 | 1.00376 | 3.77743 | 01/24/2019 | 4 | 4 | 0 | 28 | 1 | 0 | 28 | 12/07/2017 | 11 | 11 | 0 | 44 | 1 | 0 | 44 | 2017-02-16 | 3 | 3 | 0 | 1 | 8 | 0 | 8 | 30 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
6113 | 6113 | 610 EAST YORK STREET AVOCA, IA 51521 | 41.502016 | -95.333233 | 0 | 165294 | AVOCA SPECIALTY CARE | 610 EAST YORK STREET | AVOCA | IA | 51521 | 7123436398 | 770 | Pottawattamie | Non profit - Corporation | 46 | 35.7 | Medicare and Medicaid | false | CARE INITIATIVES | 08/01/1996 | false | false | false | false | Resident | Yes | 3 | 3 | 1 | 2 | 1 | 4 | 4 | 1.97338 | 0.82917 | 0.66536 | 1.49454 | 3.46792 | 0.04623 | 1.98978 | 0.67701 | 0.3167 | 2.98349 | 2.06121 | 0.92094 | 0.79076 | 3.72732 | 08/08/2019 | 2 | 0 | 2 | 8 | 0 | 0 | 8 | 04/26/2018 | 5 | 4 | 4 | 40 | 1 | 0 | 40 | 2017-02-16 | 3 | 2 | 1 | 1 | 28 | 0 | 28 | 22 | 1 | 7 | 0 | 0.00 | 0 | 0 | 610 EAST YORK STREET AVOCA, IA 51521 (41.502016, -95.333233) | 02/01/2020 | |||||||||||
6857 | 6857 | 2375 ROOSEVELT STREET DUBUQUE, IA 52001 | 42.53086 | -90.656743 | 0 | 165556 | SUNNYCREST MANOR | 2375 ROOSEVELT STREET | DUBUQUE | IA | 52001 | 5635831781 | 300 | Dubuque | Government - County | 77 | 74.7 | Medicare and Medicaid | false | COUNTY OF DUBUQUE | 05/01/2005 | false | false | false | false | Resident | Yes | 4 | 3 | 4 | 4 | 2 | 5 | 5 | 3.12682 | 0.59192 | 0.82644 | 1.41836 | 4.54519 | 0 | 1.8982 | 0.65578 | 0.26941 | 2.82339 | 3.42355 | 0.67872 | 1.15458 | 5.16219 | 07/11/2019 | 8 | 7 | 1 | 28 | 1 | 0 | 28 | 04/05/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-02-16 | 2 | 1 | 1 | 1 | 28 | 0 | 28 | 21.333 | 2 | 2 | 0 | 0.00 | 0 | 0 | 2375 ROOSEVELT STREET DUBUQUE, IA 52001 (42.53086, -90.656743) | 02/01/2020 | |||||||||||
8157 | 8157 | 301 LONG RAPIDS RD ALPENA, MI 49707 | 45.077361 | -83.462321 | 0 | 235280 | MEDILODGE OF ALPENA | 301 LONG RAPIDS RD | ALPENA | MI | 49707 | 9893562194 | 30 | Alpena | For profit - Individual | 132 | 107.7 | Medicare and Medicaid | false | ALPENA OPCO LLC | 05/01/1976 | false | false | false | false | Both | Yes | 4 | 3 | 4 | 5 | 4 | 4 | 4 | 3.05921 | 0.74249 | 0.94714 | 1.68964 | 4.74885 | 0.06995 | 2.10108 | 0.78397 | 0.36589 | 3.25094 | 3.0261 | 0.71216 | 0.97432 | 4.68417 | 07/11/2019 | 11 | 9 | 2 | 68 | 1 | 0 | 68 | 05/04/2018 | 12 | 8 | 4 | 92 | 1 | 0 | 92 | 2017-02-16 | 4 | 4 | 0 | 1 | 36 | 0 | 36 | 70.667 | 4 | 7 | 0 | 0.00 | 0 | 0 | 301 LONG RAPIDS RD ALPENA, MI 49707 (45.077361, -83.462321) | 02/01/2020 | |||||||||||
8479 | 8479 | 3605 RATLIFF ROAD BIRMINGHAM, AL 35210 | 33.542569 | -86.634703 | 0 | 15457 | KIRKWOOD BY THE RIVER | 3605 RATLIFF ROAD | BIRMINGHAM | AL | 35210 | 2059562184 | 360 | Jefferson | Non profit - Church related | 61 | 54.1 | Medicare | false | PRESBYTERIAN RETIREMENT HOMES OF BIRMINGHAM, INC. | 09/08/2006 | true | false | false | false | Resident | Yes | 2 | 3 | 4 | 3 | 5 | 1 | 12 | 1 | 12 | 2.86675 | 2.03737 | 0.39856 | 2.43594 | 5.30269 | 0.02445 | 2.3124 | 0.64571 | 0.30363 | 3.26174 | 2.57657 | 2.37256 | 0.49407 | 5.21314 | 03/28/2019 | 2 | 2 | 0 | 20 | 1 | 0 | 20 | 03/22/2018 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 2017-02-16 | 5 | 5 | 0 | 1 | 36 | 0 | 36 | 22.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 3605 RATLIFF ROAD BIRMINGHAM, AL 35210 (33.542569, -86.634703) | 02/01/2020 | |||||||||
8728 | 8728 | 23900 CHAGRIN BLVD BEACHWOOD, OH 44122 | 41.464474 | -81.509654 | 0 | 365071 | BEACHWOOD POINTE CARE CENTER | 23900 CHAGRIN BLVD | BEACHWOOD | OH | 44122 | 2164641000 | 170 | Cuyahoga | For profit - Corporation | 120 | 100.2 | Medicare and Medicaid | false | BROOK POINTE HEALTH AND REHAB, INC. | 01/01/1967 | false | false | false | false | Resident | Yes | 2 | 3 | 3 | 3 | 2 | 1 | 1 | 1.70709 | 1.39031 | 0.1989 | 1.58921 | 3.2963 | 0.02667 | 2.07527 | 0.81226 | 0.46112 | 3.34864 | 1.70962 | 1.28707 | 0.16235 | 3.15654 | 05/09/2019 | 3 | 1 | 2 | 12 | 1 | 0 | 12 | 04/26/2018 | 3 | 2 | 3 | 32 | 1 | 0 | 32 | 2017-02-16 | 2 | 0 | 2 | 0 | 79 | 0 | 79 | 29.833 | 0 | 7 | 2 | 25775.00 | 0 | 2 | 23900 CHAGRIN BLVD BEACHWOOD, OH 44122 (41.464474, -81.509654) | 02/01/2020 | |||||||||||
9460 | 9460 | 4900 EAST SAM HOUSTON PARKWAY SOUTH PASADENA, TX 77505 | 29.638147 | -95.162985 | 0 | 676332 | THE MEDICAL RESORT AT BAY AREA | 4900 EAST SAM HOUSTON PARKWAY SOUTH | PASADENA | TX | 77505 | 2819980399 | 610 | Harris | For profit - Individual | 101 | 93.1 | Medicare and Medicaid | false | APOLLO HEALTHCARE AT BAY AREA LP | 03/20/2013 | false | false | false | false | Resident | Yes | 2 | 3 | 3 | 2 | 3 | 1 | 1 | 1.9648 | 1.07811 | 0.35882 | 1.43693 | 3.40173 | 0.07444 | 2.09077 | 0.96874 | 0.63285 | 3.69236 | 1.95312 | 0.83683 | 0.2134 | 2.95426 | 04/12/2019 | 8 | 8 | 1 | 48 | 1 | 0 | 48 | 04/27/2018 | 7 | 4 | 5 | 72 | 1 | 0 | 72 | 2017-02-16 | 10 | 6 | 4 | 1 | 96 | 0 | 96 | 64 | 3 | 5 | 1 | 11132.00 | 1 | 2 | 4900 EAST SAM HOUSTON PARKWAY SOUTH PASADENA, TX 77505 (29.638147, -95.162985) | 02/01/2020 | |||||||||||
9998 | 9998 | 100 CASTLETON AVENUE STATEN ISLAND, NY 10301 | 40.634354 | -74.087556 | 0 | 335273 | VERRAZANO NURSING HOME | 100 CASTLETON AVENUE | STATEN ISLAND | NY | 10301 | 7182731300 | 610 | Richmond | For profit - Corporation | 120 | 115.3 | Medicare and Medicaid | false | Legal Business Name Not Available | 01/01/1970 | false | false | false | false | Both | Yes | 2 | 3 | 4 | 5 | 3 | 1 | 1 | 1.99444 | 0.56284 | 0.27897 | 0.8418 | 2.83624 | 0.06286 | 2.03216 | 0.80371 | 0.43034 | 3.26621 | 2.03976 | 0.52658 | 0.24399 | 2.78454 | 01/13/2020 | 2 | 0 | 2 | 12 | 0 | 0 | 12 | 12/11/2018 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 2017-02-16 | 3 | 3 | 0 | 1 | 16 | 0 | 16 | 15.333 | 3 | 1 | 0 | 0.00 | 0 | 0 | 100 CASTLETON AVENUE STATEN ISLAND, NY 10301 (40.634354, -74.087556) | 02/01/2020 | |||||||||||
10085 | 10085 | 17350 OLD TURNPIKE ROAD MILLMONT, PA 17845 | 40.897517 | -77.186026 | 0 | 395614 | ROLLING HILLS HEALTHCARE AND REHABILITATION CENTER | 17350 OLD TURNPIKE ROAD | MILLMONT | PA | 17845 | 5709223351 | 720 | Union | For profit - Corporation | 57 | 56.2 | Medicare and Medicaid | false | GUARDIAN ELDER CARE AT MILLMONT LLC | 01/01/1984 | false | false | false | false | Both | Yes | 3 | 3 | 3 | 5 | 1 | 2 | 3 | 1.62536 | 0.9394 | 0.61376 | 1.55316 | 3.17852 | 0.04446 | 2.06474 | 0.82214 | 0.44486 | 3.33173 | 1.63606 | 0.85919 | 0.51929 | 3.0592 | 04/26/2019 | 3 | 2 | 1 | 28 | 1 | 0 | 28 | 03/23/2018 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 2017-02-16 | 14 | 14 | 2 | 1 | 76 | 0 | 76 | 33.333 | 1 | 1 | 1 | 7036.00 | 0 | 1 | 17350 OLD TURNPIKE ROAD MILLMONT, PA 17845 (40.897517, -77.186026) | 02/01/2020 | |||||||||||
10192 | 10192 | 101 FIRST ST OCONTO, WI 54153 | 44.884257 | -87.868908 | 0 | 525670 | BAY AT OCONTO HEALTH AND REHAB CENTER (THE) | 101 FIRST ST | OCONTO | WI | 54153 | 9208344575 | 410 | Oconto | For profit - Corporation | 50 | 42 | Medicare and Medicaid | false | BAY AT OCONTO HEALTH AND REHABILITATION CENTER LLC | 12/16/2003 | false | false | false | true | Resident | Yes | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 1.99961 | 0.69095 | 0.61267 | 1.30361 | 3.30322 | 0 | 2.01564 | 0.73886 | 0.38259 | 3.13709 | 2.06181 | 0.70318 | 0.60273 | 3.37648 | 04/24/2019 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 03/12/2018 | 5 | 3 | 2 | 52 | 1 | 0 | 52 | 2017-02-16 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 24 | 0 | 1 | 0 | 0.00 | 0 | 0 | 101 FIRST ST OCONTO, WI 54153 (44.884257, -87.868908) | 02/01/2020 | |||||||||||
10932 | 10932 | 900 S BAXTER AVE TYLER, TX 75701 | 32.338674 | -95.285507 | 0 | 455485 | THE CLAIRMONT TYLER | 900 S BAXTER AVE | TYLER | TX | 75701 | 9035978192 | 892 | Smith | For profit - Corporation | 120 | 89 | Medicare and Medicaid | false | HOPKINS COUNTY HOSPITAL DISTRICT | 04/18/1984 | false | false | false | false | Resident | Yes | 2 | 3 | 2 | 2 | 3 | 1 | 12 | 1 | 12 | 1.91593 | 1.18205 | 0.184 | 1.36605 | 3.28198 | 0 | 2.09641 | 0.88625 | 0.48378 | 3.46644 | 1.89942 | 1.00292 | 0.14316 | 3.03603 | 01/09/2019 | 7 | 6 | 1 | 72 | 1 | 0 | 72 | 02/15/2018 | 10 | 7 | 5 | 76 | 1 | 0 | 76 | 2017-02-16 | 3 | 1 | 3 | 1 | 32 | 0 | 32 | 66.667 | 1 | 2 | 0 | 0.00 | 0 | 0 | 900 S BAXTER AVE TYLER, TX 75701 (32.338674, -95.285507) | 02/01/2020 | |||||||||
11484 | 11484 | 1001 11 WALLACE STREET PHILADELPHIA, PA 19123 | 39.964081 | -75.15454 | 0 | 395461 | TUCKER HOUSE NURSING AND REHABILITATION CENTER | 1001-11 WALLACE STREET | PHILADELPHIA | PA | 19123 | 2152351600 | 620 | Philadelphia | For profit - Corporation | 180 | 162.2 | Medicare and Medicaid | false | TUCKER OPERATING LLC | 02/05/1980 | false | false | false | false | Resident | Yes | 3 | 3 | 3 | 4 | 3 | 2 | 2 | 2.06806 | 0.7749 | 0.52288 | 1.29778 | 3.36584 | 0.07283 | 2.15744 | 0.81963 | 0.42731 | 3.40438 | 1.99223 | 0.7109 | 0.46057 | 3.17036 | 02/06/2019 | 3 | 2 | 1 | 12 | 1 | 0 | 12 | 01/29/2018 | 11 | 3 | 8 | 60 | 1 | 0 | 60 | 2017-02-16 | 6 | 5 | 2 | 1 | 24 | 0 | 24 | 30 | 0 | 9 | 0 | 0.00 | 0 | 0 | 1001 11 WALLACE STREET PHILADELPHIA, PA 19123 (39.964081, -75.15454) | 02/01/2020 | |||||||||||
11842 | 11842 | 5 SAINT FRANCIS WAY CRANBERRY TOWNSHIP, PA 16066 | 40.682587 | -80.098649 | 0 | 395845 | CRANBERRY PLACE | 5 SAINT FRANCIS WAY | CRANBERRY TOWNSHIP | PA | 16066 | 7247725350 | 150 | Butler | Non profit - Church related | 150 | 99.1 | Medicare and Medicaid | false | CRANBERRY PLACE | 01/28/1991 | true | false | false | false | Resident | Yes | 4 | 3 | 3 | 4 | 2 | 4 | 4 | 2.35882 | 0.80455 | 0.94152 | 1.74607 | 4.10489 | 0.08799 | 2.1998 | 0.83605 | 0.41863 | 3.45448 | 2.22858 | 0.72361 | 0.8465 | 3.81041 | 03/22/2019 | 10 | 8 | 2 | 52 | 1 | 0 | 52 | 02/02/2018 | 4 | 4 | 4 | 24 | 1 | 0 | 24 | 2017-02-16 | 11 | 10 | 1 | 1 | 68 | 0 | 68 | 45.333 | 0 | 5 | 0 | 0.00 | 0 | 0 | 5 SAINT FRANCIS WAY CRANBERRY TOWNSHIP, PA 16066 (40.682587, -80.098649) | 02/01/2020 | |||||||||||
12379 | 12379 | 1315 TEXAS AVE SAN ANTONIO, TX 78201 | 29.449413 | -98.53488 | 0 | inf | THE SARAH ROBERTS FRENCH HOME | 1315 TEXAS AVE | SAN ANTONIO | TX | 78201 | 2107364238 | 130 | Bexar | Non profit - Corporation | 60 | 59.1 | Medicaid | false | Legal Business Name Not Available | 12/09/1974 | false | false | false | false | Resident | Yes | 1 | 3 | 1 | 1 | 2 | 1 | 1 | 2.14446 | 0.82006 | 0.17035 | 0.99041 | 3.13486 | 0 | 2.0046 | 0.65829 | 0.2932 | 2.95609 | 2.22334 | 0.93672 | 0.21868 | 3.40059 | 03/27/2019 | 14 | 10 | 4 | 96 | 1 | 0 | 96 | 03/16/2018 | 4 | 4 | 2 | 28 | 1 | 0 | 28 | 2017-02-16 | 6 | 4 | 2 | 1 | 44 | 0 | 44 | 64.667 | 0 | 13 | 0 | 0.00 | 0 | 0 | 1315 TEXAS AVE SAN ANTONIO, TX 78201 (29.449413, -98.53488) | 02/01/2020 | |||||||||||
12881 | 12881 | 69 COTTAGE ROAD MIFFLIN, PA 17058 | 40.557013 | -77.414728 | 0 | 395350 | LOCUST GROVE RETIREMENT VILLAGE | 69 COTTAGE ROAD | MIFFLIN | PA | 17058 | 7174368921 | 410 | Juniata | For profit - Corporation | 104 | 91 | Medicare and Medicaid | false | LOCUST GROVE FACILITY OPERATIONS, LLC | 05/12/1976 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 4 | 2 | 2 | 1.80183 | 1.00908 | 0.45874 | 1.46782 | 3.26965 | 0.06232 | 2.14762 | 0.7672 | 0.39846 | 3.31328 | 1.7437 | 0.98901 | 0.43332 | 3.16444 | 03/14/2019 | 12 | 11 | 2 | 56 | 1 | 0 | 56 | 03/29/2018 | 8 | 5 | 3 | 36 | 1 | 0 | 36 | 2017-02-16 | 8 | 5 | 3 | 1 | 36 | 0 | 36 | 46 | 0 | 3 | 0 | 0.00 | 0 | 0 | 69 COTTAGE ROAD MIFFLIN, PA 17058 (40.557013, -77.414728) | 02/01/2020 | |||||||||||
13793 | 13793 | 213 TANGLEWOOD COURT RIDGEWAY, SC 29130 | 34.301731 | -80.965276 | 0 | 425288 | PRUITTHEALTH- RIDGEWAY | 213 TANGLEWOOD COURT | RIDGEWAY | SC | 29130 | 8033373211 | 190 | Fairfield | For profit - Corporation | 150 | 135.4 | Medicare and Medicaid | false | PRUITTHEALTH- RIDGEWAY LLC | 07/25/1989 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 3 | 5 | 3 | 4 | 1.77769 | 0.78252 | 0.55046 | 1.33298 | 3.11067 | 0.02983 | 1.93627 | 0.64255 | 0.27661 | 2.85543 | 1.90812 | 0.91575 | 0.74902 | 3.49331 | 04/18/2019 | 4 | 4 | 0 | 20 | 1 | 0 | 20 | 06/15/2018 | 10 | 10 | 0 | 52 | 1 | 0 | 52 | 2017-02-16 | 10 | 6 | 4 | 1 | 84 | 0 | 84 | 41.333 | 0 | 2 | 1 | 13627.00 | 0 | 1 | 213 TANGLEWOOD COURT RIDGEWAY, SC 29130 (34.301731, -80.965276) | 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 );