nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
30 rows where Health Inspection Rating = 3 and Rating Cycle 1 Number of Complaint Health Deficiencies = 7
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, Provider Resides in Hospital, 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, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating 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 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 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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127 | 127 | 4204 OLD MILFORD MILL ROAD BALTIMORE, MD 21208 | 39.363971 | -76.716443 | 0 | 215022 | KING DAVID NURSING AND REHABILITATION CENTER | 4204 OLD MILFORD MILL ROAD | BALTIMORE | MD | 21208 | 4104861500 | 20 | Baltimore | For profit - Partnership | 100 | 92.7 | Medicare and Medicaid | false | KING DAVID AT AUTUMN LAKE LLC | 01/01/1967 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 4 | 4 | 2 | 2 | 2.35152 | 0.82317 | 0.60754 | 1.4307 | 3.78223 | 0.18142 | 2.26738 | 0.92332 | 0.50798 | 3.69868 | 2.15547 | 0.67038 | 0.45015 | 3.2791 | 10/24/2018 | 17 | 14 | 7 | 68 | 1 | 0 | 68 | 07/12/2017 | 8 | 8 | 0 | 36 | 1 | 0 | 36 | 2016-05-09 | 18 | 18 | 0 | 1 | 92 | 0 | 92 | 61.333 | 1 | 6 | 0 | 0.00 | 0 | 0 | 4204 OLD MILFORD MILL ROAD BALTIMORE, MD 21208 (39.363971, -76.716443) | 02/01/2020 | |||||||||||
550 | 550 | 1090 RIO LANE SACRAMENTO, CA 95822 | 38.532382 | -121.518299 | 0 | 55296 | APPLEWOOD POST ACUTE | 1090 RIO LANE | SACRAMENTO | CA | 95822 | 9164462506 | 440 | Sacramento | For profit - Partnership | 51 | 41.9 | Medicare and Medicaid | false | APPLEWOOD POST ACUTE LLC | 01/01/1969 | false | false | false | false | Resident | Yes | 5 | 3 | 5 | 5 | 4 | 5 | 5 | 2.70491 | 0.65088 | 1.18575 | 1.83663 | 4.54154 | 0.11258 | 1.82552 | 0.66458 | 0.30573 | 2.79583 | 3.07951 | 0.73643 | 1.4598 | 5.2089 | 04/18/2019 | 15 | 8 | 7 | 80 | 1 | 0 | 80 | 05/24/2018 | 8 | 7 | 1 | 52 | 1 | 0 | 52 | 2017-07-13 | 10 | 8 | 2 | 1 | 48 | 0 | 48 | 65.333 | 3 | 11 | 0 | 0.00 | 0 | 0 | 1090 RIO LANE SACRAMENTO, CA 95822 (38.532382, -121.518299) | 02/01/2020 | |||||||||||
716 | 716 | 1101 GILPIN AVENUE WILMINGTON, DE 19806 | 39.753209 | -75.555537 | 0 | 85047 | GILPIN HALL | 1101 GILPIN AVENUE | WILMINGTON | DE | 19806 | 3026544486 | 10 | New Castle | Non profit - Corporation | 96 | 92 | Medicare and Medicaid | false | HOME FOR AGED WOMEN, INC. | 01/07/1997 | false | false | false | false | Resident | Yes | 4 | 3 | 2 | 3 | 1 | 5 | 5 | 2.84324 | 0.73816 | 0.84431 | 1.58247 | 4.42571 | 0.05708 | 2.08404 | 0.6603 | 0.30243 | 3.04677 | 2.83547 | 0.84061 | 1.05075 | 4.65797 | 05/16/2019 | 7 | 7 | 7 | 44 | 2 | 22 | 66 | 05/10/2018 | 12 | 12 | 0 | 52 | 1 | 0 | 52 | 2017-03-07 | 10 | 10 | 0 | 1 | 44 | 0 | 44 | 57.667 | 0 | 0 | 1 | 11219.00 | 0 | 1 | 1101 GILPIN AVENUE WILMINGTON, DE 19806 (39.753209, -75.555537) | 02/01/2020 | |||||||||||
1089 | 1089 | 15750 JOY DETROIT, MI 48228 | 42.358137 | -83.20021 | 0 | 235445 | FAIRLANE SENIOR CARE AND REHAB CENTER | 15750 JOY | DETROIT | MI | 48228 | 3132736850 | 810 | Wayne | For profit - Corporation | 205 | 194.7 | Medicare and Medicaid | false | FAIRLANE SENIOR CARE AND REHAB CENTER, LLC | 04/01/1986 | false | false | false | false | Both | Yes | 3 | 3 | 3 | 3 | 3 | 2 | 1 | 2.1012 | 1.26171 | 0.26302 | 1.52473 | 3.62594 | 0.03155 | 2.02453 | 0.71532 | 0.31826 | 3.05811 | 2.15704 | 1.32631 | 0.31106 | 3.80207 | 03/07/2019 | 14 | 8 | 7 | 96 | 1 | 0 | 96 | 02/07/2018 | 4 | 3 | 1 | 56 | 1 | 0 | 56 | 2016-12-13 | 15 | 10 | 5 | 1 | 143 | 0 | 143 | 90.5 | 10 | 16 | 1 | 35421.00 | 0 | 1 | 15750 JOY DETROIT, MI 48228 (42.358137, -83.20021) | 02/01/2020 | |||||||||||
1595 | 1595 | 1420 SOUTH BARRINGTON ROAD BARRINGTON, IL 60010 | 42.133069 | -88.13619 | 0 | 145557 | ALDEN ESTATES OF BARRINGTON | 1420 SOUTH BARRINGTON ROAD | BARRINGTON | IL | 60010 | 8473826664 | 141 | Cook | For profit - Corporation | 150 | 132 | Medicare and Medicaid | false | ALDEN ESTATES OF BARRINGTON, INC. | 02/11/1986 | false | false | false | false | Resident | Yes | 3 | 3 | 3 | 4 | 3 | 2 | 3 | 1.67546 | 0.46359 | 1.04304 | 1.50663 | 3.18209 | 0.0753 | 2.38788 | 0.92862 | 0.66021 | 3.97672 | 1.45827 | 0.37539 | 0.59463 | 2.56591 | 07/25/2019 | 9 | 2 | 7 | 84 | 1 | 0 | 84 | 05/25/2018 | 7 | 5 | 2 | 24 | 1 | 0 | 24 | 2017-06-08 | 11 | 9 | 2 | 1 | 56 | 0 | 56 | 59.333 | 0 | 5 | 0 | 0.00 | 0 | 0 | 1420 SOUTH BARRINGTON ROAD BARRINGTON, IL 60010 (42.133069, -88.13619) | 02/01/2020 | |||||||||||
3832 | 3832 | 4505 SOUTH DREXEL CHICAGO, IL 60653 | 41.813074 | -87.603973 | 0 | 145828 | ESTATES OF HYDE PARK, THE | 4505 SOUTH DREXEL | CHICAGO | IL | 60653 | 7732850550 | 141 | Cook | For profit - Individual | 155 | 147.6 | Medicare and Medicaid | false | ESTATES OF HYDE PARK LLC | 01/23/1995 | false | false | false | false | Resident | Yes | 2 | 3 | 3 | 3 | 3 | 1 | 1 | 1.50931 | 0.7067 | 0.23101 | 0.93771 | 2.44702 | 0.02788 | 2.07408 | 0.7778 | 0.37084 | 3.22272 | 1.51241 | 0.68321 | 0.23446 | 2.43483 | 12/05/2019 | 13 | 6 | 7 | 56 | 1 | 0 | 56 | 11/15/2018 | 17 | 16 | 5 | 92 | 1 | 0 | 92 | 2017-12-08 | 1 | 0 | 1 | 0 | 8 | 0 | 8 | 60 | 0 | 32 | 0 | 0.00 | 0 | 0 | 4505 SOUTH DREXEL CHICAGO, IL 60653 (41.813074, -87.603973) | 02/01/2020 | |||||||||||
4268 | 4268 | 14255 S Cicero Ave, Crestwood, IL 60445, USA | 41.6331519 | -87.7370377 | 1 | ROOFTOP | 145718 | SYMPHONY OF CRESTWOOD | 14255 SOUTH CICERO AVENUE | CRESTWOOD | IL | 60445 | 7083710400 | 141 | Cook | For profit - Corporation | 297 | 213.8 | Medicare and Medicaid | false | SYMPHONY CRESTWOOD LLC | 06/01/1992 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 5 | 3 | 2 | 2 | 1.54093 | 0.82756 | 0.44335 | 1.27092 | 2.81185 | 0.05411 | 2.25249 | 0.7827 | 0.34401 | 3.37921 | 1.42179 | 0.79504 | 0.48507 | 2.66827 | 10/03/2019 | 11 | 4 | 7 | 64 | 1 | 0 | 64 | 12/06/2018 | 15 | 3 | 12 | 68 | 1 | 0 | 68 | 2017-11-09 | 7 | 4 | 3 | 1 | 36 | 0 | 36 | 60.667 | 0 | 21 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
4487 | 4487 | 3701 HODGIN RD RICHMOND, IN 47374 | 39.81175 | -84.851748 | 0 | 155481 | ARBOR TRACE HEALTH & LIVING COMMUNITY | 3701 HODGIN RD | RICHMOND | IN | 47374 | 7659393701 | 880 | Wayne | For profit - Corporation | 101 | 98.2 | Medicare and Medicaid | false | RIVERVIEW HOSPITAL | 01/29/1993 | false | false | false | false | Resident | Yes | 3 | 3 | 3 | 3 | 4 | 2 | 3 | 1.79258 | 0.64352 | 0.63573 | 1.27925 | 3.07183 | 0.11491 | 2.17262 | 0.83353 | 0.43685 | 3.44301 | 1.71479 | 0.58053 | 0.54774 | 2.86097 | 01/31/2019 | 14 | 9 | 7 | 72 | 1 | 0 | 72 | 11/20/2017 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2016-09-28 | 9 | 4 | 5 | 1 | 52 | 0 | 52 | 47.333 | 0 | 18 | 1 | 6500.00 | 0 | 1 | 3701 HODGIN RD RICHMOND, IN 47374 (39.81175, -84.851748) | 02/01/2020 | |||||||||||
5259 | 5259 | 2301 N SEVERANCE STREET HUTCHINSON, KS 67502 | 38.079879 | -97.913181 | 0 | 175236 | HUTCHINSON OPERATOR, LLC | 2301 N SEVERANCE STREET | HUTCHINSON | KS | 67502 | 6206620597 | 770 | Reno | For profit - Corporation | 45 | 41.2 | Medicare and Medicaid | false | HUTCHINSON OPERATOR LLC | 02/01/1993 | false | false | false | false | Resident | Yes | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 2.42251 | 0.73171 | 0.50446 | 1.23617 | 3.65868 | 0.02111 | 1.97476 | 0.74719 | 0.36633 | 3.08828 | 2.54957 | 0.73636 | 0.5183 | 3.79892 | 07/31/2019 | 11 | 10 | 7 | 76 | 1 | 0 | 76 | 06/26/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-06-27 | 10 | 10 | 0 | 1 | 72 | 0 | 72 | 50 | 1 | 2 | 0 | 0.00 | 0 | 0 | 2301 N SEVERANCE STREET HUTCHINSON, KS 67502 (38.079879, -97.913181) | 02/01/2020 | |||||||||||
5531 | 5531 | 1700 FURNAS STREET ASHLAND, NE 68003 | 41.045091 | -96.371943 | 0 | 285140 | AZRIA HEALTH ASHLAND | 1700 FURNAS STREET | ASHLAND | NE | 68003 | 4029447031 | 770 | Saunders | For profit - Corporation | 97 | 70.4 | Medicare and Medicaid | false | BCP ASHLAND LLC | 06/01/1994 | false | false | false | true | Resident | Yes | 4 | 3 | 4 | 4 | 4 | 4 | 5 | 1.65789 | 0.3294 | 0.91188 | 1.24128 | 2.89917 | 0.00767 | 1.757 | 0.61345 | 0.27071 | 2.64117 | 1.96109 | 0.40376 | 1.26785 | 3.5199 | 04/16/2019 | 16 | 12 | 7 | 76 | 1 | 0 | 76 | 12/27/2017 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 2016-10-24 | 4 | 4 | 0 | 1 | 16 | 0 | 16 | 44.667 | 1 | 3 | 0 | 0.00 | 0 | 0 | 1700 FURNAS STREET ASHLAND, NE 68003 (41.045091, -96.371943) | 02/01/2020 | |||||||||||
6513 | 6513 | 285 N STATE ST ZEELAND, MI 49464 | 42.816942 | -86.019102 | 0 | 235347 | SKLD ZEELAND | 285 N STATE ST | ZEELAND | MI | 49464 | 6167724641 | 690 | Ottawa | For profit - Corporation | 138 | 120.7 | Medicare and Medicaid | false | HAVEN PARK CHRISTIAN HOUSING AND NURSING ASSOCIATION OF ZEELAND | 06/01/1978 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 2 | 5 | 3 | 3 | 2.19726 | 0.83183 | 0.49732 | 1.32915 | 3.52641 | 0.01162 | 2.01352 | 0.65429 | 0.27646 | 2.94428 | 2.26798 | 0.95597 | 0.67707 | 3.84067 | 12/10/2019 | 10 | 3 | 7 | 68 | 0 | 0 | 68 | 01/10/2019 | 10 | 7 | 3 | 88 | 1 | 0 | 88 | 2017-11-01 | 10 | 7 | 3 | 1 | 104 | 0 | 104 | 80.667 | 23 | 3 | 2 | 18011.00 | 0 | 2 | 285 N STATE ST ZEELAND, MI 49464 (42.816942, -86.019102) | 02/01/2020 | |||||||||||
6858 | 6858 | 1625 S FRANKLIN AVENUE COLBY, KS 67701 | 39.373435 | -101.045998 | 0 | 175554 | CITIZENS MEDICAL CENTER LTCU | 1625 S FRANKLIN AVENUE | COLBY | KS | 67701 | 7854628295 | 960 | Thomas | Non profit - Corporation | 60 | 52.7 | Medicare and Medicaid | true | CITIZENS MEDICAL CENTER INC | 01/19/2017 | false | false | false | false | Resident | Yes | 5 | 3 | 5 | 5 | 2 | 4 | 3 | 2.54791 | 0.76879 | 0.47853 | 1.24733 | 3.79524 | 0.01367 | 1.74715 | 0.60634 | 0.2948 | 2.64828 | 3.03089 | 0.95341 | 0.61098 | 4.59545 | 06/13/2019 | 7 | 7 | 7 | 44 | 1 | 0 | 44 | 08/28/2018 | 3 | 3 | 0 | 40 | 1 | 0 | 40 | 2017-01-19 | 16 | 13 | 3 | 1 | 104 | 0 | 104 | 52.667 | 1 | 2 | 1 | 8453.00 | 0 | 1 | 1625 S FRANKLIN AVENUE COLBY, KS 67701 (39.373435, -101.045998) | 02/01/2020 | |||||||||||
7635 | 7635 | 18500 VAN HORN RD WOODHAVEN, MI 48183 | 42.126393 | -83.217125 | 0 | 235375 | APPLEWOOD NURSING CENTER INC | 18500 VAN HORN RD | WOODHAVEN | MI | 48183 | 7346767575 | 810 | Wayne | For profit - Corporation | 150 | 128.2 | Medicare and Medicaid | false | APPLEWOOD NURSING CENTER INC | 07/17/1978 | false | false | false | false | Both | Yes | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 2.08368 | 0.95845 | 0.49847 | 1.45692 | 3.54061 | 0.06221 | 2.1896 | 0.72585 | 0.32972 | 3.24517 | 1.9778 | 0.9929 | 0.56902 | 3.49859 | 05/23/2019 | 13 | 9 | 7 | 88 | 1 | 0 | 88 | 07/11/2018 | 9 | 8 | 1 | 60 | 1 | 0 | 60 | 2017-05-11 | 8 | 6 | 2 | 1 | 52 | 0 | 52 | 72.667 | 11 | 7 | 0 | 0.00 | 0 | 0 | 18500 VAN HORN RD WOODHAVEN, MI 48183 (42.126393, -83.217125) | 02/01/2020 | |||||||||||
7666 | 7666 | 26660 PATRICK AVENUE HAYWARD, CA 94544 | 37.6401 | -122.080773 | 0 | 56463 | GATEWAY CARE & REHABILITATION CENTER | 26660 PATRICK AVENUE | HAYWARD | CA | 94544 | 5107821845 | 0 | Alameda | For profit - Corporation | 99 | 71.4 | Medicare and Medicaid | false | NADHI, INC | 05/01/1980 | false | false | false | false | Resident | Yes | 3 | 3 | 2 | 3 | 2 | 2 | 2 | 2.50197 | 1.20883 | 0.2901 | 1.49893 | 4.00089 | 0.1136 | 2.25252 | 0.70565 | 0.32461 | 3.28278 | 2.30849 | 1.28813 | 0.33637 | 3.90813 | 05/09/2019 | 12 | 5 | 7 | 48 | 1 | 0 | 48 | 04/05/2018 | 11 | 10 | 2 | 76 | 1 | 0 | 76 | 2017-03-30 | 9 | 9 | 0 | 1 | 44 | 0 | 44 | 56.667 | 1 | 5 | 1 | 8125.00 | 0 | 1 | 26660 PATRICK AVENUE HAYWARD, CA 94544 (37.6401, -122.080773) | 02/01/2020 | |||||||||||
7710 | 7710 | 1125 NORTH DIVISION STREET SANDPOINT, ID 83864 | 48.283867 | -116.567898 | 0 | 135127 | LIFE CARE CENTER OF SANDPOINT | 1125 NORTH DIVISION STREET | SANDPOINT | ID | 83864 | 2082659299 | 80 | Bonner | For profit - Corporation | 124 | 89.8 | Medicare and Medicaid | false | SANDPOINT MEDICAL INVESTORS LIMITED PARTNERSHIP | 09/22/1997 | false | false | false | false | Resident | Yes | 4 | 3 | 4 | 3 | 5 | 4 | 4 | 2.43743 | 0.76437 | 0.78245 | 1.54682 | 3.98424 | 0.08579 | 2.04869 | 0.69618 | 0.31947 | 3.06434 | 2.4727 | 0.82559 | 0.92184 | 4.16929 | 03/29/2019 | 16 | 16 | 7 | 92 | 1 | 0 | 92 | 08/12/2016 | 11 | 11 | 0 | 52 | 1 | 0 | 52 | 2015-05-08 | 14 | 14 | 0 | 1 | 88 | 0 | 88 | 78 | 0 | 9 | 0 | 0.00 | 0 | 0 | 1125 NORTH DIVISION STREET SANDPOINT, ID 83864 (48.283867, -116.567898) | 02/01/2020 | |||||||||||
8089 | 8089 | 415 MORGNEC ROAD CHESTERTOWN, MD 21620 | 39.224602 | -76.0627 | 0 | 215260 | AUTUMN LAKE HEALTHCARE AT CHESTERTOWN | 415 MORGNEC ROAD | CHESTERTOWN | MD | 21620 | 4107781900 | 140 | Kent | For profit - Corporation | 92 | 65 | Medicare and Medicaid | false | CHESTERTOWN OPERATOR LLC | 09/14/1994 | false | false | false | false | Both | Yes | 3 | 3 | 3 | 4 | 3 | 2 | 2 | 1.79795 | 0.86464 | 0.39762 | 1.26225 | 3.06021 | 0.08632 | 2.10303 | 0.82913 | 0.45844 | 3.39059 | 1.77684 | 0.78415 | 0.32645 | 2.8942 | 02/15/2019 | 14 | 9 | 7 | 56 | 1 | 0 | 56 | 10/19/2017 | 10 | 10 | 4 | 52 | 1 | 0 | 52 | 2016-10-07 | 12 | 9 | 3 | 1 | 56 | 0 | 56 | 54.667 | 1 | 5 | 0 | 0.00 | 0 | 0 | 415 MORGNEC ROAD CHESTERTOWN, MD 21620 (39.224602, -76.0627) | 02/01/2020 | |||||||||||
8100 | 8100 | 935 KENWOOD AVENUE DULUTH, MN 55811 | 46.81414 | -92.10031 | 0 | 245236 | BENEDICTINE HEALTH CENTER | 935 KENWOOD AVENUE | DULUTH | MN | 55811 | 2185228900 | 680 | St. Louis | Non profit - Corporation | 96 | 91.3 | Medicare and Medicaid | false | BENEDICTINE HEALTH CENTER | 11/17/1980 | false | false | false | false | Both | Yes | 5 | 3 | 5 | 5 | 5 | 4 | 4 | 2.89478 | 0.85664 | 0.90232 | 1.75896 | 4.65373 | 0.10929 | 2.23301 | 0.75667 | 0.33819 | 3.32788 | 2.69426 | 0.85129 | 1.00422 | 4.48423 | 06/13/2019 | 7 | 7 | 7 | 36 | 1 | 0 | 36 | 04/12/2018 | 6 | 6 | 0 | 28 | 1 | 0 | 28 | 2017-06-29 | 6 | 6 | 0 | 1 | 24 | 0 | 24 | 31.333 | 2 | 2 | 0 | 0.00 | 0 | 0 | 935 KENWOOD AVENUE DULUTH, MN 55811 (46.81414, -92.10031) | 02/01/2020 | |||||||||||
8307 | 8307 | 3500 MAPLE AVE TERRE HAUTE, IN 47804 | 39.492163 | -87.36817 | 0 | 155426 | SIGNATURE HEALTHCARE OF TERRE HAUTE | 3500 MAPLE AVE | TERRE HAUTE | IN | 47804 | 8122381555 | 830 | Vigo | For profit - Corporation | 176 | 152 | Medicare and Medicaid | false | JACKSON COUNTY SCHNECK MEMORIAL HOSPITAL | 01/10/1992 | false | false | false | false | Resident | Yes | 3 | 3 | 2 | 3 | 2 | 3 | 3 | 2.08844 | 0.72191 | 0.65348 | 1.37539 | 3.46383 | 0.04289 | 2.11282 | 0.83675 | 0.42042 | 3.36998 | 2.05436 | 0.64874 | 0.58504 | 3.29597 | 06/05/2019 | 11 | 6 | 7 | 48 | 1 | 0 | 48 | 05/17/2018 | 8 | 4 | 4 | 36 | 1 | 0 | 36 | 2017-05-25 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 38 | 2 | 13 | 0 | 0.00 | 0 | 0 | 3500 MAPLE AVE TERRE HAUTE, IN 47804 (39.492163, -87.36817) | 02/01/2020 | |||||||||||
8782 | 8782 | 5301 W DUVAL RD AUSTIN, TX 78727 | 30.41769 | -97.742447 | 0 | 675956 | WINDSOR NURSING AND REHABILITATION CENTER OF DUVAL | 5301 W DUVAL RD | AUSTIN | TX | 78727 | 5123451805 | 940 | Travis | For profit - Corporation | 198 | 201.3 | Medicare and Medicaid | false | REGENCY IHS OF WINDSOR DUVAL LLC | 02/21/2003 | false | false | false | false | Resident | Yes | 2 | 3 | 4 | 5 | 3 | 1 | 1 | 2.03697 | 0.61106 | 0.25019 | 0.86125 | 2.89822 | 0 | 1.95392 | 0.8322 | 0.45168 | 3.2378 | 2.16668 | 0.55213 | 0.20848 | 2.87035 | 06/26/2019 | 7 | 3 | 7 | 56 | 1 | 0 | 56 | 07/11/2018 | 5 | 5 | 0 | 44 | 1 | 0 | 44 | 2017-07-27 | 9 | 2 | 7 | 1 | 80 | 0 | 80 | 56 | 2 | 7 | 0 | 0.00 | 0 | 0 | 5301 W DUVAL RD AUSTIN, TX 78727 (30.41769, -97.742447) | 02/01/2020 | |||||||||||
9175 | 9175 | 320 CATTLE CALL DR BRAWLEY, CA 92227 | 32.970812 | -115.546218 | 0 | 555557 | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC | 320 CATTLE CALL DR. | BRAWLEY | CA | 92227 | 7603445431 | 120 | Imperial | For profit - Corporation | 99 | 92.1 | Medicare and Medicaid | false | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE LLC | 06/15/1993 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 4 | 2 | 1 | 2.43607 | 0.96867 | 0.29573 | 1.2644 | 3.70047 | 0.06417 | 2.10142 | 0.78407 | 0.37115 | 3.25663 | 2.40931 | 0.92898 | 0.29991 | 3.64369 | 11/29/2018 | 21 | 14 | 7 | 92 | 1 | 0 | 92 | 10/19/2017 | 9 | 3 | 6 | 32 | 1 | 0 | 32 | 2016-07-22 | 25 | 12 | 13 | 1 | 96 | 0 | 96 | 72.667 | 12 | 25 | 0 | 0.00 | 0 | 0 | 320 CATTLE CALL DR BRAWLEY, CA 92227 (32.970812, -115.546218) | 02/01/2020 | |||||||||||
9917 | 9917 | 1413 W MAIN ST WAXAHACHIE, TX 75165 | 32.39748 | -96.863437 | 0 | 455591 | FOCUSED CARE OF WAXAHACHIE | 1413 W MAIN ST | WAXAHACHIE | TX | 75165 | 9729372298 | 470 | Ellis | For profit - Limited Liability company | 152 | 81.5 | Medicare and Medicaid | false | FPACP ELLIS LLC | 01/16/1986 | false | false | false | false | Resident | Yes | 2 | 3 | 4 | 4 | 4 | 1 | 1 | 1.76589 | 0.83896 | 0.18152 | 1.02049 | 2.78638 | 0.06642 | 2.15899 | 0.82019 | 0.44812 | 3.42731 | 1.69992 | 0.76915 | 0.15246 | 2.60699 | 06/06/2019 | 8 | 6 | 7 | 28 | 1 | 0 | 28 | 06/01/2018 | 10 | 10 | 10 | 72 | 1 | 0 | 72 | 2017-05-25 | 7 | 5 | 4 | 1 | 96 | 0 | 96 | 54 | 2 | 3 | 1 | 96755.00 | 1 | 2 | 1413 W MAIN ST WAXAHACHIE, TX 75165 (32.39748, -96.863437) | 02/01/2020 | |||||||||||
10039 | 10039 | 3620 LAS ESTANCIAS DR SW ALBUQUERQUE, NM 87105 | 35.018112 | -106.712403 | 0 | 325126 | THE RIO AT LAS ESTANCIAS | 3620 LAS ESTANCIAS DR SW | ALBUQUERQUE | NM | 87105 | 5052539600 | 0 | Bernalillo | For profit - Limited Liability company | 120 | 109.4 | Medicare and Medicaid | false | REHAB SUITES AT LAS ESTANCIAS LLC | 07/01/2014 | false | false | false | false | Resident | Yes | 3 | 3 | 5 | 5 | 5 | 1 | 1 | 2.13948 | 0.95297 | 0.29362 | 1.24659 | 3.38606 | 0.13856 | 1.96984 | 0.78352 | 0.3832 | 3.13656 | 2.25731 | 0.91456 | 0.2884 | 3.46174 | 09/05/2019 | 13 | 9 | 7 | 100 | 1 | 0 | 100 | 11/02/2018 | 17 | 7 | 10 | 140 | 1 | 0 | 140 | 2017-09-20 | 12 | 12 | 7 | 1 | 80 | 0 | 80 | 110 | 0 | 7 | 0 | 0.00 | 0 | 0 | 3620 LAS ESTANCIAS DR SW ALBUQUERQUE, NM 87105 (35.018112, -106.712403) | 02/01/2020 | |||||||||||
10406 | 10406 | 118 B ST FILLMORE, CA 93015 | 34.394281 | -118.922216 | 0 | 555066 | GREENFIELD CARE CENTER OF FILLMORE, LLC | 118 B ST | FILLMORE | CA | 93015 | 8055245250 | 660 | Ventura | For profit - Limited Liability company | 99 | 78.7 | Medicare and Medicaid | false | GREENFIELD CARE CENTER OF FILLMORE LLC | 05/20/1977 | false | false | false | false | Resident | Yes | 4 | 3 | 2 | 4 | 1 | 5 | 5 | 2.61916 | 0.46181 | 0.76912 | 1.23092 | 3.85008 | 0.07424 | 1.85975 | 0.62281 | 0.26832 | 2.75088 | 2.92701 | 0.55756 | 1.07887 | 4.48799 | 11/07/2019 | 11 | 4 | 7 | 48 | 1 | 0 | 48 | 11/15/2018 | 9 | 4 | 5 | 44 | 1 | 0 | 44 | 2017-11-20 | 12 | 12 | 1 | 1 | 76 | 0 | 76 | 51.333 | 4 | 6 | 0 | 0.00 | 0 | 0 | 118 B ST FILLMORE, CA 93015 (34.394281, -118.922216) | 02/01/2020 | |||||||||||
10745 | 10745 | N26W23977 Watertown Rd, Waukesha, WI 53188, USA | 43.0668291 | -88.2241323 | 1 | ROOFTOP | 525646 | CCC OF PEWAUKEE | N26 W23977 WATERTOWN RD | WAUKESHA | WI | 53188 | 2625230933 | 660 | Waukesha | For profit - Corporation | 120 | 107.6 | Medicare and Medicaid | false | CCC OF PEWAUKEE LLC | 07/28/1998 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 4 | 3 | 4 | 2.10198 | 0.6088 | 0.86799 | 1.47679 | 3.57876 | 0.09263 | 2.21823 | 0.81024 | 0.40951 | 3.43798 | 1.96942 | 0.56499 | 0.79777 | 3.33797 | 08/29/2019 | 7 | 7 | 7 | 40 | 1 | 0 | 40 | 06/14/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-04-12 | 4 | 4 | 0 | 1 | 16 | 0 | 16 | 22.667 | 0 | 2 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
10843 | 10843 | 4650 S PANTHER CREEK DR THE WOODLANDS, TX 77381 | 30.164479 | -95.504954 | 0 | 455876 | THE WOODLANDS HEALTHCARE CENTER | 4650 S PANTHER CREEK DR | THE WOODLANDS | TX | 77381 | 2813633535 | 801 | Montgomery | Government - Hospital district | 214 | 161.8 | Medicare and Medicaid | false | WINNIE-STOWELL HOSPITAL DISTRICT | 04/23/1990 | false | false | false | false | Resident | Yes | 2 | 3 | 4 | 5 | 3 | 1 | 1 | 2.09218 | 0.74703 | 0.29358 | 1.04061 | 3.13279 | 0.06681 | 1.98619 | 0.79849 | 0.4152 | 3.19988 | 2.18924 | 0.70349 | 0.26613 | 3.13943 | 03/22/2019 | 9 | 3 | 7 | 52 | 1 | 0 | 52 | 05/18/2018 | 9 | 7 | 2 | 76 | 1 | 0 | 76 | 2017-05-25 | 8 | 7 | 1 | 1 | 80 | 0 | 80 | 64.667 | 5 | 13 | 0 | 0.00 | 0 | 0 | 4650 S PANTHER CREEK DR THE WOODLANDS, TX 77381 (30.164479, -95.504954) | 02/01/2020 | |||||||||||
11440 | 11440 | 196 W MAIN ST NORWALK, OH 44857 | 41.236898 | -82.63037 | 0 | 365517 | TWILIGHT GARDENS NURSING AND REHABILITATION | 196 W MAIN ST | NORWALK | OH | 44857 | 4196682086 | 400 | Huron | For profit - Corporation | 100 | 65.1 | Medicare and Medicaid | false | TWILIGHT HEALTHCARE LLC | 07/03/1980 | false | false | false | true | Both | Yes | 2 | 3 | 3 | 2 | 3 | 1 | 1 | 1.96181 | 0.78694 | 0.48814 | 1.27508 | 3.2369 | 0.02239 | 2.04135 | 0.83859 | 0.59973 | 3.47968 | 1.99735 | 0.70563 | 0.30635 | 2.98292 | 02/07/2019 | 7 | 6 | 7 | 48 | 1 | 0 | 48 | 01/18/2018 | 6 | 5 | 1 | 24 | 1 | 0 | 24 | 2016-10-20 | 3 | 2 | 1 | 1 | 12 | 0 | 12 | 34 | 0 | 3 | 0 | 0.00 | 0 | 0 | 196 W MAIN ST NORWALK, OH 44857 (41.236898, -82.63037) | 02/01/2020 | |||||||||||
11591 | 11591 | 6700 HERITAGE PARKWAY ROCKWALL, TX 75087 | 32.919238 | -96.506676 | 0 | 675579 | SENIOR CARE AT LAKE POINTE | 6700 HERITAGE PARKWAY | ROCKWALL | TX | 75087 | 9724124000 | 879 | Rockwall | For profit - Corporation | 190 | 137.5 | Medicare and Medicaid | false | Legal Business Name Not Available | 04/16/1996 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 5 | 2 | 2 | 2 | 1.91787 | 0.82346 | 0.49968 | 1.32314 | 3.24101 | 0.08133 | 2.17918 | 0.9189 | 0.49459 | 3.59268 | 1.82912 | 0.67384 | 0.38026 | 2.89278 | 03/22/2019 | 7 | 6 | 7 | 60 | 1 | 0 | 60 | 02/09/2018 | 3 | 3 | 0 | 40 | 1 | 0 | 40 | 2016-12-14 | 6 | 5 | 1 | 1 | 56 | 0 | 56 | 52.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 6700 HERITAGE PARKWAY ROCKWALL, TX 75087 (32.919238, -96.506676) | 02/01/2020 | |||||||||||
13755 | 13755 | 7411 NORTH NEVADA SPOKANE, WA 99208 | 47.724775 | -117.395342 | 0 | 505379 | ROYAL PARK HEALTH AND REHABILITATION | 7411 NORTH NEVADA | SPOKANE | WA | 99208 | 5094892273 | 310 | Spokane | For profit - Corporation | 164 | 148.1 | Medicare and Medicaid | false | SPOKANE ROYAL PARK CARE LLC | 06/06/1991 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 3 | 3 | 3 | 2.43243 | 0.79922 | 0.70113 | 1.50035 | 3.93278 | 0.13513 | 2.20408 | 0.77902 | 0.37024 | 3.35334 | 2.29366 | 0.77144 | 0.71276 | 3.76076 | 01/31/2019 | 23 | 16 | 7 | 100 | 1 | 0 | 100 | 12/14/2017 | 25 | 22 | 3 | 191 | 1 | 0 | 191 | 2016-10-17 | 13 | 7 | 6 | 1 | 88 | 0 | 88 | 128.333 | 7 | 9 | 3 | 23400.00 | 0 | 3 | 7411 NORTH NEVADA SPOKANE, WA 99208 (47.724775, -117.395342) | 02/01/2020 | |||||||||||
13795 | 13795 | 703 TITUS STREET GILMER, TX 75644 | 32.734185 | -94.944435 | 0 | 675801 | GILMER NURSING AND REHABILITATION LP | 703 TITUS STREET | GILMER | TX | 75644 | 9038435529 | 943 | Upshur | For profit - Corporation | 93 | 67.6 | Medicare and Medicaid | false | GILMER NURSING AND REHABILITATION LP | 07/14/1999 | false | false | false | false | Resident | Yes | 2 | 3 | 2 | 1 | 3 | 1 | 1 | 1.55388 | 1.08286 | 0.19605 | 1.27891 | 2.83278 | 0.03535 | 1.9144 | 0.74069 | 0.37536 | 3.03045 | 1.68694 | 1.09931 | 0.19658 | 2.9975 | 02/13/2019 | 8 | 8 | 7 | 64 | 1 | 0 | 64 | 01/26/2018 | 4 | 2 | 2 | 52 | 1 | 0 | 52 | 2017-02-01 | 5 | 5 | 0 | 1 | 72 | 0 | 72 | 61.333 | 1 | 0 | 1 | 26627.00 | 0 | 1 | 703 TITUS STREET GILMER, TX 75644 (32.734185, -94.944435) | 02/01/2020 | |||||||||||
14126 | 14126 | 2101 TREASURE HILLS BLVD HARLINGEN, TX 78550 | 26.174763 | -97.66664 | 0 | 455672 | GOLDEN PALMS RETIREMENT AND HEALTH CENTER | 2101 TREASURE HILLS BLVD | HARLINGEN | TX | 78550 | 9564303100 | 240 | Cameron | For profit - Corporation | 60 | 36.3 | Medicare and Medicaid | false | SANTIAGO HEALTHCARE, INC. | 11/10/1986 | true | false | false | true | Resident | Yes | 3 | 3 | 5 | 4 | 5 | 1 | 12 | 1 | 12 | 2.30127 | 1.93118 | 0.45195 | 2.38313 | 4.6844 | 0.11223 | 2.18759 | 0.93989 | 0.52646 | 3.65395 | 2.18634 | 1.54499 | 0.32311 | 4.11098 | 09/19/2019 | 13 | 6 | 7 | 84 | 1 | 0 | 84 | 08/30/2018 | 5 | 5 | 0 | 40 | 1 | 0 | 40 | 2017-08-03 | 6 | 5 | 1 | 1 | 56 | 0 | 56 | 64.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 2101 TREASURE HILLS BLVD HARLINGEN, TX 78550 (26.174763, -97.66664) | 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 );