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

31 rows where Overall Rating = 4 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-02-23

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, prvdr_type, Provider Resides in Hospital, Continuing Care Retirement Community, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing Footnote, Reported Physical Therapist Staffing Hours per Resident Per Day, Rating Cycle 1 Standard Survey Health Date, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Total Health Score, Rating Cycle 2 Standard Health Survey Date, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Total Health Score, Rating Cycle 3 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
690 690 1500 N FRANKLIN AVENUE MARENGO, IA 52301 41.705087 -91.268361 0   165614 ROSE HAVEN NURSING HOME 1500 N FRANKLIN AVENUE MARENGO IA 52301 3196425533 470 Iowa Non profit - Corporation 58 52.5 Medicare and Medicaid false PARADYM HEALTH CARE INC 03/17/2016 false   false false false None Yes 4   4   3   2   4   2   2       2.03103 0.50727 0.37018 0.87746 2.90849 0.01837 1.8302 0.67359 0.33718 2.84097 2.3064 0.56628 0.41323 3.28288 06/27/2019 1 1 0 8 1 0 8 04/26/2018 2 2 0 8 1 0 8 2017-02-23 4 4 0 1 28 0 28 11.333 2 0 0 0.00 0 0 1500 N FRANKLIN AVENUE MARENGO, IA 52301 (41.705087, -91.268361) 02/01/2020
1284 1284 114 THIRD STREET SE FORT WALTON BEACH, FL 32548 30.40865 -86.60602 0   105265 EMERALD COAST CENTER 114 THIRD STREET SE FORT WALTON BEACH FL 32548 8502436134 450 Okaloosa Non profit - Corporation 120 105.2 Medicare and Medicaid false EMERALD COAST REHABILITATION CENTER LLC 08/07/1973 false   false false false Resident Yes 4   4   4   5   3   2   2       2.5185 0.76261 0.4771 1.2397 3.7582 0.10777 1.93672 0.76348 0.37502 3.07522 2.70266 0.75108 0.47883 3.91884 04/25/2019 5 5 0 20 1 0 20 03/29/2018 4 4 0 16 1 0 16 2017-02-23 10 10 0 1 40 0 40 22 0 0 0 0.00 0 0 114 THIRD STREET SE FORT WALTON BEACH, FL 32548 (30.40865, -86.60602) 02/01/2020
1507 1507 606 Latiolais Dr, Breaux Bridge, LA 70517, USA 30.2934269 -91.9061839 1 ROOFTOP 195313 ST AGNES HEALTHCARE AND REHAB CENTER 606 LATIOLAIS ROAD BREAUX BRIDGE LA 70517 3373324808 490 St. Martin For profit - Corporation 128 109.6 Medicare and Medicaid false ST. AGNES HEALTHCARE & REHAB CENTER,INC. 01/01/1995 false   false false false Resident Yes 4   4   2   3   2   2   1       2.73463 1.125 0.12253 1.24754 3.98216 0.02141 1.96276 0.67569 0.30966 2.94811 2.89565 1.25195 0.14894 4.3314 01/24/2019 0 0 0 0 1 0 0 03/08/2018 0 0 0 0 0 0 0 2017-02-23 6 5 1 1 28 0 28 4.667 0 1 0 0.00 0 0   02/01/2020
1783 1783 383 N 17TH AVE FORSYTH, MT 59327 46.271304 -106.670752 0   275072 ROSEBUD HEALTH CARE CENTER 383 N 17TH AVE FORSYTH MT 59327 4063464243 430 Rosebud Non profit - Corporation 31 19.5 Medicare and Medicaid true ROSEBUD COMMUNITY HOSPITAL INC 11/01/1977 false   false false false Both Yes 4   3   4   4     2 5   5       3.59819 0.24946 1.45073 1.70018 5.29837 0 1.87226 0.57501 0.25779 2.70507 3.99424 0.32621 2.11808 6.28084 08/08/2019 6 6 0 44 1 0 44 06/28/2018 9 9 0 52 1 0 52 2017-02-23 3 3 0 1 40 0 40 46 0 0 0 0.00 0 0 383 N 17TH AVE FORSYTH, MT 59327 (46.271304, -106.670752) 02/01/2020
1886 1886 5015 SW 28TH STREET TOPEKA, KS 66614 39.016791 -95.740214 0   175463 TANGLEWOOD NURSING & REHABILITATION 5015 SW 28TH STREET TOPEKA KS 66614 7852730886 880 Shawnee For profit - Corporation 54 48.1 Medicare and Medicaid false HMG PARK MANOR OF WESTWOOD LLC 04/12/2003 false   false false false Both Yes 4   4   2   3   2   2   2       1.93154 0.54905 0.57305 1.1221 3.05364 0.08185 1.97342 0.82667 0.43221 3.2323 2.03423 0.49942 0.49903 3.02942 12/19/2018 5 5 4 24 1 0 24 08/30/2017 4 4 0 16 1 0 16 2017-02-23 8 8 8 1 60 0 60 27.333 0 1 0 0.00 1 1 5015 SW 28TH STREET TOPEKA, KS 66614 (39.016791, -95.740214) 02/01/2020
1993 1993 333 LEE DRIVE BATON ROUGE, LA 70808 30.398455 -91.15556 0   195410 ST JAMES PLACE NURSING CARE CENTER 333 LEE DRIVE BATON ROUGE LA 70808 2254903252 160 E. Baton Rouge Non profit - Corporation 64 61.8 Medicare false SPIRITAS SENIOR SERVICES 04/28/1997 true   false false false Resident Yes 4   4   5   5   5   1 12 1 12 6 6                             01/31/2019 0 0 0 0 0 0 0 01/12/2018 1 1 0 8 1 0 8 2017-02-23 2 2 0 1 16 0 16 5.333 0 0 0 0.00 0 0 333 LEE DRIVE BATON ROUGE, LA 70808 (30.398455, -91.15556) 02/01/2020
2688 2688 22425 OVERLAND AVENUE BLOOMFIELD, IA 52537 40.716716 -92.356443 0   16F001 DAVIS CENTER 22425 OVERLAND AVENUE BLOOMFIELD IA 52537 6416643202 250 Davis For profit - Corporation 32 29.7 Medicaid false Legal Business Name Not Available 03/16/1995 false   false false false Resident Yes 4   3   2   2     2 5   5       1.84001 0.70668 0.74121 1.4479 3.28791 0 1.58771 0.58275 0.25647 2.42694 2.4086 0.91185 1.08776 4.34425 08/22/2019 3 2 1 28 1 0 28 05/03/2018 1 1 0 16 1 0 16 2017-02-23 0 0 0 0 0 0 0 19.333 1 0 0 0.00 0 0 22425 OVERLAND AVENUE BLOOMFIELD, IA 52537 (40.716716, -92.356443) 02/01/2020
3162 3162 67 PINE POINT RD SCARBOROUGH, ME 04074 43.568288 -70.378063 0   205070 PINE POINT CENTER 67 PINE POINT RD SCARBOROUGH ME 4074 2078832468 20 Cumberland For profit - Corporation 61 54.1 Medicare and Medicaid false SCARBOROUGH OPERATIONS LLC 10/01/1991 false   false false false Resident Yes 4   3   4   3   5   5   5       2.24609 0.70248 1.046 1.74848 3.99458 0.09955 2.00647 0.7326 0.36371 3.10278 2.32654 0.72103 1.08244 4.12831 03/07/2019 8 8 1 32 1 0 32 02/01/2018 2 1 1 8 1 0 8 2017-02-23 3 3 0 1 12 0 12 20.667 3 0 0 0.00 0 0 67 PINE POINT RD SCARBOROUGH, ME 04074 (43.568288, -70.378063) 02/01/2020
3181 3181 1825 HOLTVILLE ROAD WETUMPKA, AL 36092 32.558544 -86.221265 0   15027 WETUMPKA HEALTH AND REHABILITATION, LLC 1825 HOLTVILLE ROAD WETUMPKA AL 36092 3345675131 250 Elmore For profit - Corporation 121 118.2 Medicare and Medicaid false WETUMPKA HEALTH AND REHABILITATION, LLC 07/24/1967 false   false false false Resident Yes 4   3   5   5   5   2   1       2.38765 0.87156 0.19198 1.06354 3.45119 0.01572 1.97204 0.64127 0.28044 2.89374 2.51635 1.02198 0.25767 3.82439 04/25/2019 3 3 0 24 1 0 24 04/13/2018 1 1 0 4 1 0 4 2017-02-23 3 3 0 1 24 0 24 17.333 0 0 0 0.00 0 0 1825 HOLTVILLE ROAD WETUMPKA, AL 36092 (32.558544, -86.221265) 02/01/2020
3360 3360 3601 LAKEWOOD BLVD NAPLES, FL 34112 26.11641 -81.754299 0   105421 MANORCARE NURSING AND REHABILITATION CENTER 3601 LAKEWOOD BLVD NAPLES FL 34112 2397757757 100 Collier Non profit - Other 120 88.2 Medicare and Medicaid false MANOR CARE OF NAPLES FL LLC 10/22/1982 false   false false false Resident Yes 4   3   4   5   4   4   4       2.71542 0.71567 0.75779 1.47346 4.18888 0.10127 2.17987 0.76112 0.36686 3.30784 2.58894 0.70705 0.77746 4.06074 01/17/2019 6 5 1 24 1 0 24 03/08/2018 2 0 2 8 0 0 8 2017-02-23 7 7 0 1 56 0 56 24 0 2 1 1575.00 0 1 3601 LAKEWOOD BLVD NAPLES, FL 34112 (26.11641, -81.754299) 02/01/2020
3488 3488 1701 NE 26TH ST FORT LAUDERDALE, FL 33305 26.15967 -80.12451 0   105089 MANOR PINES CONVALESCENT CENTER 1701 NE 26TH ST FORT LAUDERDALE FL 33305 9545668353 50 Broward For profit - Limited Liability company 206 159.3 Medicare and Medicaid false MANOR PINES CONVALESCENT CENTER, LLC 07/01/1970 false   false false false Resident Yes 4   3   4   5   2   4   4       2.99007 0.59989 1.05535 1.65523 4.64531 0.02662 2.17725 0.73278 0.38269 3.29273 2.85423 0.61557 1.03795 4.52389 05/16/2019 10 10 0 40 1 0 40 03/15/2018 6 6 0 36 1 0 36 2017-02-23 6 6 0 1 24 0 24 36 0 0 0 0.00 0 0 1701 NE 26TH ST FORT LAUDERDALE, FL 33305 (26.15967, -80.12451) 02/01/2020
4881 4881 18480 COCHRAN BLVD PORT CHARLOTTE, FL 33948 27.003601 -82.141214 0   105982 CONSULATE HEALTH CARE OF PORT CHARLOTTE 18480 COCHRAN BLVD PORT CHARLOTTE FL 33948 9417434700 70 Charlotte For profit - Corporation 120 111.6 Medicare and Medicaid false PORT CHARLOTTE FACILITY OPERATIONS, LLC 03/12/1998 false   false false false Both Yes 4   3   5   5   5   2   2       2.60266 1.01265 0.41889 1.43154 4.0342 0.05859 2.17399 0.69822 0.33631 3.20852 2.48815 1.09057 0.4688 4.03187 03/27/2019 5 5 0 20 1 0 20 03/22/2018 4 4 0 32 1 0 32 2017-02-23 8 8 0 1 44 0 44 28 0 0 0 0.00 0 0 18480 COCHRAN BLVD PORT CHARLOTTE, FL 33948 (27.003601, -82.141214) 02/01/2020
5478 5478 501 OAK STREET CHASKA, MN 55318 44.788853 -93.598641 0   245604 AUBURN MANOR 501 OAK STREET CHASKA MN 55318 9524489303 90 Carver Non profit - Church related 61 55.4 Medicare and Medicaid false AUBURN MANOR 08/01/1992 false   false false false Resident Yes 4   5   3   2   4   1 12 1 12     2.28575 0.33856 0.63142 0.96999 3.25574 0.0104 2.1513 0.69082 0.32889 3.17102 2.20822 0.36852 0.7226 3.29233 12/05/2018 2 2 0 8 1 0 8 10/19/2017 0 0 0 0 0 0 0 2017-02-23 2 2 0 1 20 0 20 7.333 0 0 1 12005.00 0 1 501 OAK STREET CHASKA, MN 55318 (44.788853, -93.598641) 02/01/2020
6254 6254 719 SOUTHEAST 2ND STREET GLENWOOD, MN 56334 45.643486 -95.386848 0   245402 GLENWOOD VILLAGE CARE CENTER 719 SOUTHEAST 2ND STREET GLENWOOD MN 56334 3206345131 600 Pope Non profit - Church related 64 56.1 Medicare and Medicaid false GLENWOOD VILLAGE CARE CENTER INC 12/01/1986 false   false false false Both Yes 4   3   2   2   3   4   4       2.89906 0.52123 0.66101 1.18224 4.0813 0.05868 2.0687 0.65817 0.29819 3.02506 2.91256 0.59549 0.83435 4.32631 05/10/2019 4 4 0 28 1 0 28 03/15/2018 10 7 3 48 1 0 48 2017-02-23 2 2 0 1 12 0 12 32 1 1 0 0.00 0 0 719 SOUTHEAST 2ND STREET GLENWOOD, MN 56334 (45.643486, -95.386848) 02/01/2020
6624 6624 383 SOUTH ORLEANS ROAD BREWSTER, MA 02631 41.738382 -70.000297 0   225667 PLEASANT BAY OF BREWSTER REHAB CENTER 383 SOUTH ORLEANS ROAD BREWSTER MA 2631 5082403500 0 Barnstable For profit - Corporation 135 115.8 Medicare and Medicaid false PLEASANT BAY OF BREWSTER REHAB CENTER LLC 02/16/1995 false   false false true Both Yes 4   4   4   5   4   4   4       1.84471 0.71626 0.90804 1.6243 3.46902 0.14341 1.94349 0.74708 0.37152 3.06209 1.9727 0.72093 0.91993 3.63281 07/11/2019 3 3 0 20 1 0 20 06/13/2018 3 3 0 20 1 0 20 2017-02-23 5 5 0 1 24 0 24 20.667 0 0 0 0.00 0 0 383 SOUTH ORLEANS ROAD BREWSTER, MA 02631 (41.738382, -70.000297) 02/01/2020
7218 7218 102 EAST NORTH STREET JANESVILLE, MN 56048 44.123558 -93.706907 0   245440 WHISPERING CREEK 102 EAST NORTH STREET JANESVILLE MN 56048 5072315113 800 Waseca Government - City 40 29.5 Medicare and Medicaid false JANESVILLE NURSING HOME 02/01/1987 false   false false false Resident Yes 4   3   4   3   5   5   5       3.31648 0.51886 1.02778 1.54663 4.86312 0.01487 2.03194 0.66234 0.29116 2.98543 3.39221 0.58905 1.32862 5.22349 02/08/2019 5 5 2 24 1 0 24 03/22/2018 6 6 0 44 1 0 44 2017-02-23 6 6 0 1 24 0 24 30.667 1 0 0 0.00 0 0 102 EAST NORTH STREET JANESVILLE, MN 56048 (44.123558, -93.706907) 02/01/2020
7245 7245 700 N PALMETTO ST LEESBURG, FL 34748 28.818239 -81.875091 0   105621 NORTH CAMPUS REHABILITATION AND NURSING CENTER 700 N PALMETTO ST LEESBURG FL 34748 3523235500 340 Lake Non profit - Corporation 90 80.5 Medicare and Medicaid false NCRNC INC 10/11/1988 false   false false false Resident Yes 4   3   5   5   5   2   1       2.60158 1.16864 0.26653 1.43518 4.03675 0.22602 2.03728 0.78063 0.38719 3.2051 2.65401 1.1257 0.25909 4.03872 04/04/2019 4 4 0 28 1 0 28 01/26/2018 6 6 0 28 1 0 28 2017-02-23 2 2 0 1 8 0 8 24.667 0 0 0 0.00 0 0 700 N PALMETTO ST LEESBURG, FL 34748 (28.818239, -81.875091) 02/01/2020
7755 7755 502 BUTLER STREET ACKLEY, IA 50601 42.552213 -93.046605 0   165443 GRAND JI VANTE 502 BUTLER STREET ACKLEY IA 50601 6418473531 410 Hardin Non profit - Other 64 44.2 Medicare and Medicaid false PRESBYTERIAN VILLAGE 01/01/2002 true   false false false Both Yes 4   4   4   2   5   4   4       2.10434 0.67558 0.60996 1.28554 3.38988 0.0156 1.82404 0.63785 0.28207 2.74397 2.39772 0.79642 0.81389 3.96149 07/25/2019 2 2 0 12 1 0 12 04/26/2018 2 2 0 8 1 0 8 2017-02-23 5 5 4 1 20 0 20 12 0 1 0 0.00 0 0 502 BUTLER STREET ACKLEY, IA 50601 (42.552213, -93.046605) 02/01/2020
7965 7965 2500 KY-5, Ashland, KY 41102, USA 38.4828694 -82.6921334 1 ROOFTOP 185449 KINGSBROOK LIFECARE CENTER 2500 STATE ROUTE 5 ASHLAND KY 41102 6063241414 90 Boyd Non profit - Corporation 137 130.4 Medicare and Medicaid false ASHLAND NURSING HOME CORPORATION 07/11/2002 false   false false false Both Yes 4   3   5   5   5   3   2       2.64 1.18438 0.40476 1.58914 4.22914 0.04239 2.10315 0.78144 0.37174 3.25633 2.60885 1.13967 0.40982 4.16463 03/28/2019 10 10 0 52 1 0 52 04/12/2018 1 1 0 4 1 0 4 2017-02-23 5 5 0 1 24 0 24 31.333 0 0 0 0.00 0 0   02/01/2020
8470 8470 849 13TH AVENUE NORTH CLINTON, IA 52732 41.85934 -90.203288 0   165509 THE ALVERNO SENIOR CARE COMMUNITY 849 13TH AVENUE NORTH CLINTON IA 52732 5632421521 220 Clinton Non profit - Corporation 84 78.2 Medicare and Medicaid false TRINITY CONTINUING CARE SERVICES 06/01/2004 false   false false false Resident Yes 4   3   4   5   3   4   5       1.91489 0.49953 0.88424 1.38377 3.29866 0.07866 1.8671 0.63476 0.29124 2.7931 2.13154 0.59175 1.14273 3.78708 08/15/2019 6 6 0 28 1 0 28 05/03/2018 4 4 0 20 1 0 20 2017-02-23 4 4 1 1 20 0 20 24 0 0 0 0.00 0 0 849 13TH AVENUE NORTH CLINTON, IA 52732 (41.85934, -90.203288) 02/01/2020
8540 8540 1055 EAST GRAND AVENUE LINDENHURST, IL 60046 42.415421 -88.055363 0   145602 VILLAGE AT VICTORY LAKES, THE 1055 EAST GRAND AVENUE LINDENHURST IL 60046 8473565900 570 Lake Non profit - Corporation 120 95.7 Medicare and Medicaid false FRANCISCAN COMMUNITIES, INC 02/02/1989 true   false false false Resident Yes 4   3   2   2   3   4   5       2.08002 0.61417 1.13703 1.7512 3.83121 0.138 2.18292 0.77003 0.36931 3.32226 1.98037 0.59974 1.15879 3.69791 04/02/2019 7 7 0 48 1 0 48 03/14/2018 11 6 5 56 1 0 56 2017-02-23 7 5 2 1 24 0 24 46.667 4 1 0 0.00 0 0 1055 EAST GRAND AVENUE LINDENHURST, IL 60046 (42.415421, -88.055363) 02/01/2020
8778 8778 901 SEVEN OAKS RD BONHAM, TX 75418 33.587497 -96.169112 0   675271 SEVEN OAKS NURSING AND REHABILITATION LP 901 SEVEN OAKS RD BONHAM TX 75418 9035832191 510 Fannin For profit - Limited Liability company 108 47.3 Medicare and Medicaid false SEVEN OAKS NURSING AND REHABILITATION LP 03/04/1994 false   false false false Resident Yes 4   4   3   4   1   2   2       1.47806 0.96851 0.41333 1.38184 2.8599 0.04128 1.79609 0.74249 0.37066 2.90924 1.71033 0.98084 0.41971 3.15228 02/28/2019 0 0 0 0 1 0 0 02/09/2018 4 4 0 56 1 0 56 2017-02-23 2 2 0 1 32 0 32 24 0 0 0 0.00 0 0 901 SEVEN OAKS RD BONHAM, TX 75418 (33.587497, -96.169112) 02/01/2020
9528 9528 4166 SOMERVILLE RD SOMERVILLE, OH 45064 39.544824 -84.6951 0   366109 WOODLAND COUNTRY MANOR INC 4166 SOMERVILLE RD SOMERVILLE OH 45064 5135234449 80 Butler For profit - Corporation 60 55.2 Medicare and Medicaid false WOODLAND COUNTY MANOR INC 12/06/1996 false   false false false Resident Yes 4   4   4   4   4   3   3       2.52895 0.91806 0.61306 1.53112 4.06007 0.06871 2.20163 0.76974 0.38835 3.35972 2.38733 0.89683 0.59417 3.87511 05/09/2019 1 1 0 16 1 0 16 04/26/2018 7 7 0 32 1 0 32 2017-02-23 2 2 0 1 4 0 4 19.333 0 0 0 0.00 0 0 4166 SOMERVILLE RD SOMERVILLE, OH 45064 (39.544824, -84.6951) 02/01/2020
10112 10112 3000 BETHEL RD COLUMBUS, OH 43230 40.065167 -83.098693 0   365410 MAYFAIR VILLAGE NURSING CARE C 3000 BETHEL RD COLUMBUS OH 43230 6148896320 250 Franklin For profit - Corporation 99 90.8 Medicare and Medicaid false CONSOLIDATED RESOURCES HEALTH CARE 04/12/1979 true   false false false Both Yes 4   4   3   4   2   2   3       1.79771 0.72557 0.60771 1.33329 3.131 0.13848 2.19396 0.8081 0.40382 3.40588 1.70297 0.67515 0.56642 2.94786 05/02/2019 4 4 0 16 1 0 16 04/26/2018 3 2 1 28 1 0 28 2017-02-23 3 2 1 1 12 0 12 19.333 0 1 0 0.00 0 0 3000 BETHEL RD COLUMBUS, OH 43230 (40.065167, -83.098693) 02/01/2020
10527 10527 18220 EUCLID AVE CLEVELAND, OH 44112 41.556187 -81.551278 0   365006 HILLSIDE PLAZA 18220 EUCLID AVE CLEVELAND OH 44112 2164866300 170 Cuyahoga For profit - Corporation 47 39.9 Medicare and Medicaid false EUCLID HILL HEALTH INVESTORS, INC. 01/01/1967 false   false false false Resident Yes 4   4   4   5   4   2   3       1.85398 0.98317 0.78198 1.76515 3.61913 0.05103 2.41295 1.01808 0.56713 3.99817 1.59688 0.72616 0.51897 2.90265 05/16/2019 5 4 1 12 1 0 12 04/12/2018 3 3 0 16 1 0 16 2017-02-23 1 1 0 1 8 0 8 12.667 0 1 0 0.00 0 0 18220 EUCLID AVE CLEVELAND, OH 44112 (41.556187, -81.551278) 02/01/2020
13093 13093 3550 NORTHFIELD ROAD SHAKER HEIGHTS, OH 44122 41.463466 -81.534861 0   366021 SHAKER GARDENS NURSING AND REHABILITATION CENTER 3550 NORTHFIELD ROAD SHAKER HEIGHTS OH 44122 2167525600 170 Cuyahoga For profit - Partnership 50 42.5 Medicare and Medicaid false SHAKER GARDENS OPCO LLC 08/11/1995 false   false false false Resident Yes 4   4   4   5   4   2   2       1.85316 1.77466 0.51246 2.28711 4.14027 0.00166 2.03589 0.82867 0.45892 3.32349 1.89179 1.61033 0.42029 3.99473 05/22/2019 2 2 0 8 1 0 8 04/12/2018 12 5 7 64 1 0 64 2017-02-23 3 2 1 1 12 0 12 27.333 0 4 0 0.00 0 0 3550 NORTHFIELD ROAD SHAKER HEIGHTS, OH 44122 (41.463466, -81.534861) 02/01/2020
13535 13535 604 LUCAS ROAD DUNN, NC 28334 35.312669 -78.649077 0   345478 HARNETT WOODS NURSING AND REHABILITATION CENTER 604 LUCAS ROAD DUNN NC 28334 9108914600 420 Harnett For profit - Corporation 100 92.6 Medicare and Medicaid false REDWOOD LTC GROUP, LLC 09/26/1996 false   false false false Resident Yes 4   4   3   4   2   2   2       1.92661 1.1118 0.41745 1.52925 3.45586 0.08416 2.28446 0.84949 0.44121 3.57515 1.75278 0.98413 0.35612 3.09967 05/31/2019 4 4 0 16 1 0 16 04/26/2018 1 1 0 4 1 0 4 2017-02-23 1 1 0 1 4 0 4 10 0 0 0 0.00 0 0 604 LUCAS ROAD DUNN, NC 28334 (35.312669, -78.649077) 02/01/2020
14036 14036 1245 PARK AVENUE HENDERSON, NC 27536 36.322335 -78.417367 0   345321 KERR LAKE NURSING AND REHABILITATION CENTER 1245 PARK AVENUE HENDERSON NC 27536 2524927021 900 Vance For profit - Limited Liability company 92 86.4 Medicare and Medicaid false EAGLE PEAK LTC GROUP, LLC 07/13/1990 false   false false false Resident Yes 4   4   3   3   3   2   2       2.07915 0.96162 0.64825 1.60986 3.68902 0.09291 2.24727 0.92612 0.52663 3.70002 1.92286 0.78076 0.4633 3.19713 03/28/2019 3 3 0 20 1 0 20 03/15/2018 2 2 0 12 1 0 12 2017-02-23 2 2 0 1 8 0 8 15.333 0 0 0 0.00 0 0 1245 PARK AVENUE HENDERSON, NC 27536 (36.322335, -78.417367) 02/01/2020
14047 14047 920 12TH AVENUE SOUTHEAST PUYALLUP, WA 98372 47.180867 -122.281401 0   505304 RAINIER REHABILITATION 920 12TH AVENUE SOUTHEAST PUYALLUP WA 98372 2538413422 260 Pierce For profit - Corporation 117 101.2 Medicare and Medicaid false WILDWOOD HEALTHCARE INC. 08/11/1986 false   false false false Both Yes 4   3   5   5   4   2   2       3.0189 0.81525 0.98955 1.80481 4.82371 0.10465 2.39573 0.97864 1.0451 4.41948 2.61895 0.6264 0.35638 3.49996 05/21/2019 8 8 0 36 1 0 36 03/19/2018 10 10 1 64 1 0 64 2017-02-23 13 4 13 1 294 0 294 88.333 2 14 2 70367.00 0 2 920 12TH AVENUE SOUTHEAST PUYALLUP, WA 98372 (47.180867, -122.281401) 02/01/2020
14477 14477 1 Martha Franks Dr, Laurens, SC 29360, USA 34.500742 -82.055949 1 ROOFTOP 425334 MARTHA FRANKS BAPTIST RETIREMENT CENTER ONE MARTHA FRANKS DRIVE LAURENS SC 29360 8649844541 290 Laurens Non profit - Corporation 88 78.5 Medicare and Medicaid false SOUTH CAROLINA BAPTIST MINISTRIES FOR THE AGING, INC. 05/03/1994 true   false false false Resident Yes 4   3   2   2   3   5   5       2.77639 0.97598 0.86769 1.84366 4.62005 0.05501 2.0508 0.64095 0.28016 2.97192 2.81366 1.14498 1.16568 4.98497 05/02/2019 2 2 0 12 1 0 12 05/17/2018 8 8 0 76 1 0 76 2017-02-23 2 2 0 1 8 0 8 32.667 0 0 1 127706.00 0 1   02/01/2020
14598 14598 611 N BROAD ST LAMPASAS, TX 76550 31.072136 -98.187911 0   455513 LAMPASAS NURSING AND REHABILITATION CENTER 611 N BROAD ST LAMPASAS TX 76550 5125563588 752 Lampasas For profit - Corporation 68 50.6 Medicare and Medicaid false DEWITT MEDICAL DISTRICT 04/26/1985 false   false false true Resident Yes 4   4   4   4   3   2   3       1.54581 0.45596 0.77153 1.22749 2.7733 0.13564 2.16922 0.8119 0.40044 3.38156 1.48104 0.42229 0.72519 2.62986 02/13/2019 2 2 0 24 1 0 24 02/08/2018 2 2 0 16 1 0 16 2017-02-23 5 5 0 1 40 0 40 24 0 0 0 0.00 0 0 611 N BROAD ST LAMPASAS, TX 76550 (31.072136, -98.187911) 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
);