nh_gen_info_geocoded_final

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

27 rows where Overall Rating = 4 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-07-27

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_accuracy, prvdr_city, prvdr_state, prvdr_cnty, nmbr_beds, prvdr_type, Provider Resides in Hospital, Continuing Care Retirement Community, With a Resident and Family Council, Health Inspection Rating, QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Physical Therapist Staffing Footnote, Reported Nurse Aide Staffing Hours per Resident per Day, Reported RN Staffing Hours per Resident per Day, Reported Licensed 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 Total Nurse Staffing Hours per Resident per Day, Adjusted Nurse Aide 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 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Total Health Score, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 3 Total Number of 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 Substantiated Complaints, Number of Fines, Total Amount of Fines in Dollars, Total Number of Penalties, Location

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
1402 1402 922 MCDONOUGH ROAD JACKSON, GA 30233 33.302166 -83.976546 0   115563 WESTBURY MEDICAL CARE AND REHAB 922 MCDONOUGH ROAD JACKSON GA 30233 7707757832 160 Butts For profit - Corporation 196 177.7 Medicare and Medicaid false WESTBURY MEDICAL CARE HOME, INC. 04/01/1994 false   false false false Resident Yes 4   4   5   5   5   1   1       2.29214 1.19784 0.26075 1.45858 3.75072 0.04745 2.31328 0.77807 0.32423 3.41558 2.05934 1.15761 0.30269 3.5213 11/07/2019 4 4 0 12 1 0 12 06/21/2018 0 0 0 0 0 0 0 2017-07-27 4 4 4 1 28 0 28 10.667 0 0 0 0.00 0 0 922 MCDONOUGH ROAD JACKSON, GA 30233 (33.302166, -83.976546) 02/01/2020
2380 2380 611 WEST MAIN STREET BELLE PLAINE, MN 56011 44.623031 -93.776984 0   245590 THE LUTHERAN HOME: BELLE PLAINE 611 WEST MAIN STREET BELLE PLAINE MN 56011 9528732131 690 Scott Non profit - Church related 97 76.8 Medicare and Medicaid false LUTHERAN HOME BELLE PLAINE LLC 01/01/1992 true   false false false Both Yes 4   3   3   4   2   5   5       3.2437 0.75069 1.04721 1.7979 5.0416 0.06455 2.18502 0.6672 0.29874 3.15096 3.08532 0.84604 1.31939 5.13073 08/15/2019 8 6 2 36 1 0 36 09/20/2018 6 6 0 40 1 0 40 2017-07-27 7 7 0 1 36 0 36 37.333 0 3 0 0.00 0 0 611 WEST MAIN STREET BELLE PLAINE, MN 56011 (44.623031, -93.776984) 02/01/2020
2469 2469 40 Smith St, Frankfort, IL 60423, USA 41.5007122 -87.8536518 1 ROOFTOP 1.4e+213 FRANKFORT TERRACE 40 NORTH SMITH FRANKFORT IL 60423 8154693156 989 Will For profit - Corporation 120 96.9 Medicaid false Legal Business Name Not Available 04/14/1975 false   false false false Resident Yes 4   4   5   5     2 1 12 1 12 6 6                             06/05/2019 4 4 0 0 0 0 0 05/11/2018 7 6 1 60 1 0 60 2017-07-27 7 6 1 1 36 0 36 26 1 1 0 0.00 0 0   02/01/2020
2907 2907 50 SHEPHERD LANE BEDFORD, KY 40006 38.58286 -85.320523 0   185358 SIGNATURE HEALTHCARE OF TRIMBLE COUNTY 50 SHEPHERD LANE BEDFORD KY 40006 5022553244 984 Trimble For profit - Corporation 60 48.9 Medicare and Medicaid false LP BEDFORD LLC 09/29/1992 false   false false false Resident Yes 4   3   3   4   2   4   4       1.87699 0.74343 0.81396 1.55739 3.43438 0.05431 1.9764 0.73345 0.31799 3.02785 1.97379 0.76217 0.96342 3.63719 11/08/2019 2 2 0 20 1 0 20 09/13/2018 5 5 0 20 1 0 20 2017-07-27 7 7 0 1 52 0 52 25.333 0 0 0 0.00 0 0 50 SHEPHERD LANE BEDFORD, KY 40006 (38.58286, -85.320523) 02/01/2020
2999 2999 3111 CHURCH STREET DULUTH, MN 55811 46.785085 -92.160524 0   245414 VIEWCREST HEALTH CENTER 3111 CHURCH STREET DULUTH MN 55811 2187278801 680 St. Louis Non profit - Corporation 92 82.5 Medicare and Medicaid false DULUTH HEALTH SERVICES 01/01/1987 false   false false false Resident Yes 4   2   5   4   5   4   4       2.51874 0.60931 0.84791 1.45722 3.97596 0.06026 2.07405 0.69454 0.30477 3.07336 2.52395 0.65966 1.04714 4.1484 05/16/2019 12 12 11 72 1 0 72 04/26/2018 9 9 0 68 1 0 68 2017-07-27 8 8 0 1 56 0 56 68 0 6 0 0.00 0 0 3111 CHURCH STREET DULUTH, MN 55811 (46.785085, -92.160524) 02/01/2020
3968 3968 2012 E Nifong Blvd, Columbia, MO 65201, USA 38.9069396 -92.3097616 1 ROOFTOP 265778 COLUMBIA MANOR CARE CENTER 2012 NIFONG BOULEVARD COLUMBIA MO 65201 5734491246 90 Boone For profit - Corporation 52 39.8 Medicare and Medicaid false COLUMBIA MANOR INC 05/01/2004 false   false false false Resident Yes 4   5   1   1   2   2   2       1.95553 0.87021 0.44665 1.31686 3.27239 0.02048 1.87305 0.7504 0.35632 2.97976 2.16986 0.872 0.4718 3.52157 08/15/2019 2 2 0 4 1 0 4 07/26/2018 2 2 0 20 1 0 20 2017-07-27 3 3 0 1 4 0 4 9.333 0 0 0 0.00 0 0   02/01/2020
4659 4659 5980 CHERRY RIDGE RD BASTROP, LA 71220 32.796572 -91.890864 0   195541 CHERRY RIDGE 5980 CHERRY RIDGE RD BASTROP LA 71220 3182816933 330 Morehouse For profit - Corporation 110 88.4 Medicare and Medicaid false CHERRY RIDGE SKILLED NURSING FACILITY, LLC 01/20/2002 false   false false false Resident Yes 4   4   2   5   1   2   1       2.43021 1.13405 0.11001 1.24407 3.67427 0.02859 1.96594 0.71276 0.33727 3.01597 2.56914 1.19639 0.12277 3.90658 07/11/2019 2 1 1 12 1 0 12 06/21/2018 2 2 0 16 1 0 16 2017-07-27 3 3 0 1 16 0 16 14 0 1 0 0.00 0 0 5980 CHERRY RIDGE RD BASTROP, LA 71220 (32.796572, -91.890864) 02/01/2020
5176 5176 E Hwy 7, Montevideo, MN 56265, USA 44.9491079 -95.693918 1 GEOMETRIC_CENTER 245259 LUTHER HAVEN 1109 EAST HIGHWAY 7 MONTEVIDEO MN 56265 3202696517 110 Chippewa Non profit - Church related 90 84.2 Medicare and Medicaid false LUTHER HAVEN 01/01/1975 false   false false false Resident Yes 4   2   5   3   5   4   4       2.50029 0.27994 0.77494 1.05488 3.55517 0.04181 1.91428 0.64891 0.2939 2.85709 2.71456 0.32439 0.99243 3.99016 04/05/2019 6 6 0 56 1 0 56 06/28/2018 10 9 1 48 1 0 48 2017-07-27 1 1 0 1 16 0 16 46.667 1 0 0 0.00 0 0   02/01/2020
6116 6116 611 TURNER CAMP RD INVERNESS, FL 34453 28.84641 -82.336828 0   105703 ARBOR TRAIL REHAB AND SKILLED NURSING CENTER 611 TURNER CAMP RD INVERNESS FL 34453 3526371130 80 Citrus For profit - Corporation 116 89.2 Medicare and Medicaid false SOVEREIGN HEALTHCARE OF INVERNESS, LLC 04/05/1990 false   false false false Resident Yes 4   4   4   3   5   3   3       2.72674 0.8579 0.70562 1.56352 4.29026 0.11351 2.19318 0.77116 0.37464 3.33899 2.58396 0.83652 0.7089 4.12024 08/01/2019 3 3 0 12 1 0 12 05/10/2018 5 4 1 20 1 0 20 2017-07-27 1 1 0 1 16 0 16 15.333 0 2 1 13627.00 0 1 611 TURNER CAMP RD INVERNESS, FL 34453 (28.84641, -82.336828) 02/01/2020
6380 6380 120 CHIPOLA AVE DELAND, FL 32720 29.002517 -81.305603 0   105930 VILLA HEALTH & REHABILITATION CENTER 120 CHIPOLA AVE DELAND FL 32720 3867383433 630 Volusia For profit - Corporation 120 116.5 Medicare and Medicaid false VILLA HEALTH NH LLC 09/27/1996 false   false false false Resident Yes 4   5   4   4   4   1 12 1 12 6 6                             12/12/2019 2 2 0 8 1 0 8 08/16/2018 0 0 0 0 0 0 0 2017-07-27 7 7 0 1 32 0 32 9.333 0 0 0 0.00 0 0 120 CHIPOLA AVE DELAND, FL 32720 (29.002517, -81.305603) 02/01/2020
6712 6712 164 NURSING HOME CIRCLE BLAIRSVILLE, GA 30512 34.884538 -83.959491 0   115695 UNION COUNTY NURSING HOME 164 NURSING HOME CIRCLE BLAIRSVILLE GA 30512 7067454948 913 Union Non profit - Corporation 150 141.2 Medicare and Medicaid true UNION COUNTY HOSPITAL AUTHORITY 10/01/2005 false   false false false Both Yes 4   4   3   3   3   3   3       2.42135 1.21639 0.39829 1.61468 4.03603 0.02682 2.05559 0.68078 0.25581 2.99218 2.44814 1.34354 0.58602 4.32533 10/03/2019 0 0 0 0 0 0 0 06/21/2018 5 5 0 20 1 0 20 2017-07-27 0 0 0 0 0 0 0 6.667 0 0 0 0.00 0 0 164 NURSING HOME CIRCLE BLAIRSVILLE, GA 30512 (34.884538, -83.959491) 02/01/2020
6788 6788 5500 FORT ST TRENTON, MI 48183 42.114607 -83.212894 0   235052 ABERDEEN REHABILITATION AND SKILLED NURSING CENTER 5500 FORT ST TRENTON MI 48183 7346713500 810 Wayne For profit - Corporation 120 58.4 Medicare and Medicaid false SANA HEALTH INC 10/01/1978 false   false false false Both Yes 4   4   4   3   5   3   3       2.24705 1.16186 0.433 1.59486 3.84191 0.0134 1.99804 0.64251 0.27657 2.91712 2.33736 1.35974 0.58928 4.22325 08/15/2019 5 4 1 32 1 0 32 10/03/2018 11 10 1 84 1 0 84 2017-07-27 15 12 4 1 104 0 104 61.333 1 10 0 0.00 0 0 5500 FORT ST TRENTON, MI 48183 (42.114607, -83.212894) 02/01/2020
6853 6853 13900 NE 3RD COURT NORTH MIAMI, FL 33161 25.903338 -80.192098 0   105513 CLARIDGE HOUSE NURSING & REHABILITATION CENTER 13900 NE 3RD COURT NORTH MIAMI FL 33161 3058932288 120 Miami-Dade For profit - Corporation 240 230 Medicare and Medicaid false CHR ASSOCIATES INC 08/22/1985 false   false false false Resident Yes 4   2   5   5   5   4   3       2.65223 1.12859 0.58052 1.7091 4.36133 0.02444 2.04545 0.70304 0.31292 3.06141 2.69487 1.20709 0.69825 4.56826 11/07/2019 10 9 1 44 0 0 44 07/26/2018 8 8 0 32 1 0 32 2017-07-27 11 9 2 1 48 0 48 40.667 0 1 0 0.00 0 0 13900 NE 3RD COURT NORTH MIAMI, FL 33161 (25.903338, -80.192098) 02/01/2020
7034 7034 420 EAST GRUNDY AVENUE SPRINGFIELD, KY 40069 37.686434 -85.212708 0   185336 SPRINGFIELD NURSING AND REHABILITATION CENTER 420 EAST GRUNDY AVENUE SPRINGFIELD KY 40069 8593367771 987 Washington For profit - Individual 70 60.5 Medicare and Medicaid false SPRINGFIELD HEALTH CENTER LLC 04/17/1992 false   false false false Resident Yes 4   4   2   2   2   3   3       2.13063 0.63409 0.66375 1.29784 3.42847 0 2.08095 0.75826 0.37715 3.21636 2.12795 0.6288 0.6624 3.41812 10/17/2019 4 4 0 28 1 0 28 08/23/2018 1 1 0 4 1 0 4 2017-07-27 0 0 0 0 0 0 0 15.333 0 0 0 0.00 0 0 420 EAST GRUNDY AVENUE SPRINGFIELD, KY 40069 (37.686434, -85.212708) 02/01/2020
7522 7522 907 11TH STREET JASPER, AL 35504 33.859719 -87.26335 0   15155 RIDGEVIEW HEALTH SERVICES, INC 907 11TH STREET, NE JASPER AL 35504 2052219111 630 Walker For profit - Corporation 148 141.7 Medicare and Medicaid false RIDGEVIEW HEALTH SERVICES, INC. 12/01/1977 false   false false false Both Yes 4   4   4   5   3   4   4       2.5735 1.10237 0.65691 1.75928 4.33278 0.02061 2.00238 0.6683 0.29279 2.96346 2.67113 1.24035 0.84446 4.68836 09/19/2019 2 2 0 12 1 0 12 08/16/2018 2 2 0 8 1 0 8 2017-07-27 0 0 0 0 0 0 0 8.667 0 0 0 0.00 0 0 907 11TH STREET JASPER, AL 35504 (33.859719, -87.26335) 02/01/2020
7944 7944 1350 EAST DEVONSHIRE AVENUE HEMET, CA 92544 33.751262 -116.957742 0   56095 DEVONSHIRE CARE CENTER 1350 EAST DEVONSHIRE AVENUE HEMET CA 92544 9519252571 430 Riverside For profit - Corporation 99 82.2 Medicare and Medicaid false DEVONSHIRE CARE CENTER, LLC 09/05/1969 false   false false false Resident Yes 4   3   5   5   5   3   2       2.49834 1.20919 0.4239 1.63308 4.13142 0.07191 1.8922 0.69056 0.32828 2.91104 2.7441 1.31667 0.48601 4.55098 06/27/2019 16 5 11 64 1 0 64 07/26/2018 9 7 2 36 1 0 36 2017-07-27 11 8 3 1 40 0 40 50.667 5 9 0 0.00 0 0 1350 EAST DEVONSHIRE AVENUE HEMET, CA 92544 (33.751262, -116.957742) 02/01/2020
7958 7958 3800 NORTH CALIFORNIA AVENUE CHICAGO, IL 60618 41.950372 -87.698119 0   145767 PAUL HOUSE & HEALTH CR CTR 3800 NORTH CALIFORNIA AVENUE CHICAGO IL 60618 7734784222 141 Cook Non profit - Corporation 110 90.9 Medicare and Medicaid false ST. PAULS CORPORATION 11/01/1993 false   false false false Resident Yes 4   4   3   2   3   4   5       2.02875 0.36248 1.11615 1.47864 3.50738 0.15061 2.15162 0.81592 0.3805 3.34804 1.95965 0.33406 1.10409 3.35928 06/12/2019 3 3 0 20 1 0 20 08/24/2018 6 3 3 20 1 0 20 2017-07-27 14 12 3 1 128 0 128 38 2 4 1 13626.00 0 1 3800 NORTH CALIFORNIA AVENUE CHICAGO, IL 60618 (41.950372, -87.698119) 02/01/2020
8064 8064 1755 18TH ST SARASOTA, FL 34230 27.353209 -82.53555 0   105774 CROSSBREEZE CARE CENTER 1755 18TH ST SARASOTA FL 34230 9419554915 570 Sarasota For profit - Corporation 101 91.8 Medicare and Medicaid false 1755 GOLDEN LLC 06/01/1992 false   false false false Both Yes 4   4   4   3   4   4   3       2.62827 0.85539 0.41176 1.26715 3.89542 0.04614 1.80426 0.62068 0.28417 2.70912 3.02751 1.03629 0.54538 4.61084 09/12/2019 3 0 3 12 0 0 12 06/07/2018 2 2 0 12 1 0 12 2017-07-27 4 3 1 2 16 8 24 14 0 7 1 1953.00 0 1 1755 18TH ST SARASOTA, FL 34230 (27.353209, -82.53555) 02/01/2020
8084 8084 210 21ST AVE W BRADENTON, FL 34205 27.480769 -82.564539 0   105159 GREENBRIAR REHABILITATION AND NURSING CENTER 210 21ST AVE W BRADENTON FL 34205 9417473786 400 Manatee For profit - Limited Liability company 79 74.7 Medicare and Medicaid false GREENBRIAR NH, LLC 06/01/1982 false   false false false Resident Yes 4   4   4   4   5   3   3       2.56678 1.04067 0.71761 1.75828 4.32506 0.20725 2.18996 0.76486 0.37817 3.33298 2.43595 1.0231 0.71423 4.16114 10/24/2019 2 2 0 8 0 0 8 08/16/2018 6 4 2 28 1 0 28 2017-07-27 10 10 0 1 52 0 52 22 0 1 0 0.00 0 0 210 21ST AVE W BRADENTON, FL 34205 (27.480769, -82.564539) 02/01/2020
8159 8159 1040 US-127, Frankfort, KY 40601, USA 38.1778868 -84.8961337 1 ROOFTOP 185170 BRADFORD SQUARE GENESIS HEALTHCARE 1040 US 127 SOUTH FRANKFORT KY 40601 5028755600 360 Franklin For profit - Corporation 100 90.5 Medicare and Medicaid false BRADFORD SQUARE NURSING, LLC 10/05/1983 false   false false false Resident Yes 4   4   4   3   5   3   3       1.91274 0.79091 0.55482 1.34573 3.25848 0.0508 2.0751 0.78886 0.4014 3.26536 1.91573 0.75389 0.52024 3.1999 10/18/2019 3 3 0 12 1 0 12 08/23/2018 1 1 0 4 1 0 4 2017-07-27 8 5 3 1 44 0 44 14.667 0 1 0 0.00 0 0   02/01/2020
8814 8814 900 LOMA COLORADO BLVD NE RIO RANCHO, NM 87124 35.271785 -106.658308 0   325130 NEIGHBORHOOD IN RIO RANCHO (THE) 900 LOMA COLORADO BLVD NE RIO RANCHO NM 87124 5059624121 210 Sandoval For profit - Corporation 48 37.9 Medicare and Medicaid false THE NEIGHBORHOOD IN RIO RANCHO 08/10/2016 true   false false false Resident Yes 4   4   2   1   4   4   4       2.55507 1.19729 0.92674 2.12403 4.6791 0.13028 2.05171 0.87412 0.44701 3.37284 2.58823 1.02994 0.78032 4.44856 06/28/2019 7 5 2 48 1 0 48 09/26/2018 9 9 1 60 1 0 60 2017-07-27 0 0 0 0 0 0 0 44 1 1 0 0.00 0 0 900 LOMA COLORADO BLVD NE RIO RANCHO, NM 87124 (35.271785, -106.658308) 02/01/2020
9276 9276 107 CURRY ROAD WAYNESBURG, PA 15370 39.890046 -80.125203 0   395624 ROLLING MEADOWS 107 CURRY ROAD WAYNESBURG PA 15370 7246273153 370 Greene Non profit - Corporation 121 99.3 Medicare and Medicaid false ROLLING MEADOWS CARE, INC 01/01/1984 false   false false false Resident Yes 4   4   3   5   2   3   3       2.10452 0.8034 0.7276 1.53099 3.63552 0.05326 2.17319 0.86577 0.46793 3.50689 2.01267 0.69777 0.58525 3.32428 08/23/2019 5 5 0 24 1 0 24 07/26/2018 1 1 0 4 1 0 4 2017-07-27 3 2 1 1 12 0 12 15.333 0 2 0 0.00 0 0 107 CURRY ROAD WAYNESBURG, PA 15370 (39.890046, -80.125203) 02/01/2020
10150 10150 417 SOUTH MAIN STREET OBERLIN, OH 44074 41.279825 -82.217731 0   365508 WELCOME NURSING HOME 417 SOUTH MAIN STREET OBERLIN OH 44074 4407751491 480 Lorain For profit - Corporation 99 89 Medicare and Medicaid false WESSELL GENERATIONS, INC. 05/20/1980 false   false false false Resident Yes 4   4   3   4   2   3   2       2.68975 1.18418 0.49748 1.68166 4.37141 0.02452 2.13487 0.80757 0.38024 3.32269 2.61852 1.1026 0.49244 4.21876 11/06/2019 4 4 0 16 1 0 16 09/13/2018 9 8 1 60 1 0 60 2017-07-27 0 0 0 0 0 0 0 28 0 1 0 0.00 0 0 417 SOUTH MAIN STREET OBERLIN, OH 44074 (41.279825, -82.217731) 02/01/2020
10294 10294 2150 MONTEGO DRIVE SPRINGFIELD, OH 45503 39.981243 -83.76124 0   366245 FOREST GLEN HEALTH CAMPUS 2150 MONTEGO DRIVE SPRINGFIELD OH 45503 9373909913 110 Clark For profit - Corporation 80 70.1 Medicare and Medicaid false TRILOGY HEALTHCARE OPERATIONS OF SPRINGFIELD, LLC 08/02/2002 true   false false false Resident Yes 4   3   5   5   5   3   4       2.0523 0.72636 0.98224 1.7086 3.7609 0.06455 2.30832 0.74266 0.36458 3.41556 1.84782 0.73544 1.01406 3.53088 10/24/2019 5 5 0 36 1 0 36 09/13/2018 9 9 0 68 1 0 68 2017-07-27 5 5 0 1 32 0 32 46 0 0 0 0.00 0 0 2150 MONTEGO DRIVE SPRINGFIELD, OH 45503 (39.981243, -83.76124) 02/01/2020
10747 10747 9184 MARKET ST NORTH LIMA, OH 44452 40.98526 -80.662718 0   366062 CAPRICE HEALTH CARE CENTER 9184 MARKET ST NORTH LIMA OH 44452 3309659200 510 Mahoning For profit - Corporation 86 70 Medicare and Medicaid false BLCC, INC 06/05/1996 false   false false false Resident Yes 4   4   2   4   1   2   2       2.38963 1.30794 0.83042 2.13836 4.52799 0.01626 2.24351 0.9245 0.64264 3.81066 2.2137 1.06381 0.48636 3.8103 10/17/2019 1 1 0 4 1 0 4 09/24/2018 6 6 0 40 1 0 40 2017-07-27 7 4 3 1 32 0 32 20.667 0 1 0 0.00 0 0 9184 MARKET ST NORTH LIMA, OH 44452 (40.98526, -80.662718) 02/01/2020
11691 11691 101 S Bissell Rd, Aurora, OH 44202, USA 41.314242 -81.3589377 1 ROOFTOP 365844 AURORA MANOR SPECIAL CARE CENT 101 BISSELL RD AURORA OH 44202 4404244000 680 Portage For profit - Corporation 85 52.6 Medicare and Medicaid false AURORA MANOR LIMITED PARTNERSHIP 08/09/1991 false   false false false Resident Yes 4   3   5   5   5   2   2       1.89302 0.96618 0.41161 1.37779 3.27081 0.0729 2.12255 0.83935 0.43452 3.39642 1.85358 0.86556 0.35654 3.08807 10/31/2019 3 3 0 12 1 0 12 09/13/2018 4 0 4 87 0 0 87 2017-07-27 2 2 0 1 32 0 32 40.333 0 1 1 13627.00 1 2   02/01/2020
15340 15340 8073 TYLERSVILLE ROAD WEST CHESTER, OH 45069 39.352375 -84.357304 0   366080 CHESTERWOOD VILLAGE 8073 TYLERSVILLE ROAD WEST CHESTER OH 45069 5137771400 80 Butler For profit - Corporation 125 88 Medicare and Medicaid false CHESTERWOOD NURSING CARE, LTD 06/28/1996 true   false false false Resident Yes 4   4   4   4   5   4   4       2.0833 1.40583 0.98522 2.39106 4.47435 0.21059 2.17279 0.85432 0.43112 3.45823 1.99273 1.23736 0.86015 4.14887 10/10/2019 4 4 0 24 1 0 24 09/13/2018 0 0 0 0 0 0 0 2017-07-27 2 2 0 1 8 0 8 13.333 0 0 0 0.00 0 0 8073 TYLERSVILLE ROAD WEST CHESTER, OH 45069 (39.352375, -84.357304) 02/01/2020

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);