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

29 rows where Overall Rating = 2 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-07-20

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, prvdr_type, Legal Business Name, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported 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 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 2 Total Health Score, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Health Revisit Score, Rating Cycle 3 Total Health Score, 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
406 406 1024 EAST TYLER LITCHFIELD, IL 62056 39.169521 -89.642843 0   1.4e+265 APERION CARE LITCHFIELD 1024 EAST TYLER LITCHFIELD IL 62056 2173243842 760 Montgomery For profit - Corporation 65 64.2 Medicaid false Legal Business Name Not Available 03/31/1974 false   false false false Resident Yes 2   3   4   4     2 1 12 1 12     1.11747 0.35323 0.28099 0.63422 1.75169 0 2.00199 0.78389 0.46088 3.24676 1.16009 0.33883 0.22947 1.73006 09/10/2019 5 5 0 28 1 0 28 08/03/2018 10 10 0 96 1 0 96 2017-07-20 10 9 1 1 28 0 28 50.667 0 1 0 0.00 0 0 1024 EAST TYLER LITCHFIELD, IL 62056 (39.169521, -89.642843) 02/01/2020
697 697 883 MAIN STREET ARNAUDVILLE, LA 70512 30.408096 -91.932262 0   195385 J. MICHAEL MORROW MEMORIAL NURSING HOME 883 MAIN STREET ARNAUDVILLE LA 70512 3377547703 480 St. Landry For profit - Partnership 175 155.5 Medicare and Medicaid false TECHE MANOR NURSING HOME, LLC 12/02/1996 false   false false false Resident Yes 2   1   5   5   4   2   1       2.51239 0.85602 0.1659 1.02192 3.53431 0.00889 2.08209 0.71055 0.31563 3.10826 2.50787 0.90589 0.19783 3.64619 06/14/2019 8 8 0 161 1 0 161 07/18/2018 3 3 0 12 1 0 12 2017-07-20 0 0 0 0 0 0 0 84.5 0 0 1 37934.00 1 2 883 MAIN STREET ARNAUDVILLE, LA 70512 (30.408096, -91.932262) 02/01/2020
2168 2168 1300 LAFOURCHE DRIVE THIBODAUX, LA 70301 29.806515 -90.822555 0   195319 THIBODAUX HEALTHCARE CENTER 1300 LAFOURCHE DRIVE THIBODAUX LA 70301 9854461332 280 Lafourche For profit - Corporation 78 73.8 Medicare and Medicaid false NEXION HEALTH AT THIBODAUX, INC. 01/01/1995 true   false false false Resident Yes 2   2   4   5   2   2   3       1.78698 0.71148 0.55865 1.27013 3.05711 0.09073 1.99976 0.81282 0.41285 3.22543 1.8572 0.65818 0.50931 3.03932 08/29/2019 9 9 0 48 1 0 48 08/30/2018 8 7 1 52 1 0 52 2017-07-20 2 2 0 1 16 0 16 44 0 1 0 0.00 0 0 1300 LAFOURCHE DRIVE THIBODAUX, LA 70301 (29.806515, -90.822555) 02/01/2020
2371 2371 599 ROGERSVILLE ROAD RADCLIFF, KY 40160 37.817482 -85.940729 0   185180 SIGNATURE HEALTHCARE AT NORTH HARDIN REHAB & WELLN 599 ROGERSVILLE ROAD RADCLIFF KY 40160 2703512999 460 Hardin For profit - Corporation 148 123 Medicare and Medicaid false LP RADCLIFF LLC 11/21/1986 false   false false false Resident Yes 2   2   3   2   4   2   2       2.04458 0.83355 0.57919 1.41274 3.45731 0.0926 2.14782 0.84779 0.44772 3.44333 1.97843 0.73931 0.4869 3.21969 06/07/2019 17 17 3 72 1 0 72 09/13/2018 5 4 2 24 1 0 24 2017-07-20 4 4 0 1 28 0 28 48.667 0 2 0 0.00 0 0 599 ROGERSVILLE ROAD RADCLIFF, KY 40160 (37.817482, -85.940729) 02/01/2020
2597 2597 1400 7TH AVENUE SE SIOUX CENTER, IA 51250 43.060947 -96.16575 0   165157 SIOUX CENTER HEALTH ROYALE MEADOWS 1400 7TH AVENUE SE SIOUX CENTER IA 51250 7127228305 830 Sioux Non profit - Corporation 69 68.1 Medicare and Medicaid false SIOUX CENTER HEALTH 10/04/1990 false   false false false Resident Yes 2   1   2   2     2 4   4       2.60623 0.38149 0.54805 0.92954 3.53577 0.00128 1.83187 0.58573 0.24931 2.66691 2.95688 0.48975 0.82737 4.25137 12/19/2019 9 9 0 48 1 0 48 11/01/2018 12 11 4 92 1 0 92 2017-07-20 4 4 1 1 40 0 40 61.333 5 0 3 42172.00 0 3 1400 7TH AVENUE SE SIOUX CENTER, IA 51250 (43.060947, -96.16575) 02/01/2020
2714 2714 9480 M-21, Ovid, MI 48866, USA 43.0001852 -84.3781073 1 ROOFTOP 235569 OVID HEALTHCARE CENTER 9480 E M-21 OVID MI 48866 9898342228 180 Clinton For profit - Corporation 94 66.2 Medicare and Medicaid false OVID HEALTHCARE, LLC 10/07/1996 false   false false false Resident Yes 2   1   3   3   3   4   4       2.29549 0.54588 0.65928 1.20516 3.50066 0.00671 1.99319 0.68182 0.32084 2.99585 2.39356 0.60203 0.77342 3.747 05/21/2019 18 17 1 124 2 62 186 09/14/2018 19 19 1 120 2 60 180 2017-07-20 24 15 9 2 263 132 395 218.833 5 7 1 44369.00 1 2   02/01/2020
4297 4297 4250 GLENN AVENUE COVINGTON, KY 41015 39.042486 -84.496073 0   185225 ROSEDALE GREEN 4250 GLENN AVENUE COVINGTON KY 41015 8594312244 580 Kenton Non profit - Corporation 176 169.5 Medicare and Medicaid false KENTON HOUSING, INC. 03/01/1991 false   false false false Both Yes 2   2   3   4   3   2   1       2.55772 0.9046 0.27127 1.17587 3.73359 0.02965 2.16103 0.72482 0.35163 3.23748 2.45985 0.93845 0.29037 3.69805 10/11/2019 7 6 1 60 1 0 60 08/16/2018 3 3 0 16 1 0 16 2017-07-20 1 0 1 0 4 0 4 36 0 1 0 0.00 0 0 4250 GLENN AVENUE COVINGTON, KY 41015 (39.042486, -84.496073) 02/01/2020
4309 4309 1950 LARKIN AVENUE ELGIN, IL 60123 42.03283 -88.324432 0   145699 AVANTARA OF ELGIN 1950 LARKIN AVENUE ELGIN IL 60123 8477427070 530 Kane For profit - Partnership 112 82.5 Medicare and Medicaid false ELGIN SKILLED NURSING FACILITY LLC 07/30/1991 false   false false false Both Yes 2   1   4   3   4   4   5       1.96824 0.21455 1.63556 1.85011 3.81836 0.13617 2.24169 0.83967 0.42415 3.50551 1.82482 0.19214 1.45137 3.49284 06/12/2019 14 5 9 116 1 0 116 07/03/2018 16 15 2 128 1 0 128 2017-07-20 6 6 0 1 36 0 36 106.667 0 9 0 0.00 0 0 1950 LARKIN AVENUE ELGIN, IL 60123 (42.03283, -88.324432) 02/01/2020
4312 4312 1505 EAST 4TH AVENUE YORK, AL 36925 32.496973 -88.28415 0   15042 SUMTER HEALTH AND REHABILITATION, L L C 1505 EAST 4TH AVENUE YORK AL 36925 2053925281 590 Sumter For profit - Corporation 125 94.3 Medicare and Medicaid false SUMTER HEALTH AND REHABILITATION, LLC 01/16/1967 false   false false false Both Yes 2   2   2   5   1   2   2       2.49087 0.91371 0.3113 1.22501 3.71587 0.00853 2.18142 0.6898 0.31479 3.186 2.37317 0.99603 0.37221 3.73997 09/05/2019 2 2 0 20 1 0 20 08/16/2018 4 4 0 40 1 0 40 2017-07-20 2 2 0 1 12 0 12 25.333 0 0 0 0.00 0 0 1505 EAST 4TH AVENUE YORK, AL 36925 (32.496973, -88.28415) 02/01/2020
4480 4480 1200 WEST COLLEGE STREET LIBERTY, MO 64068 39.247312 -94.442439 0   265437 ASHTON COURT CARE AND REHABILITATION CENTRE 1200 WEST COLLEGE STREET LIBERTY MO 64068 8167813020 230 Clay For profit - Corporation 140 114.3 Medicare and Medicaid false ASHTON COURT HEALTHCARE, LLC 09/01/1990 false   false false false Resident Yes 2   2   3   4   3   2   2       1.60937 0.73543 0.34788 1.08331 2.69268 0.05575 1.87803 0.6676 0.31108 2.8567 1.78103 0.82834 0.42091 3.02255 07/26/2019 16 12 4 96 1 0 96 09/07/2018 14 14 0 88 1 0 88 2017-07-20 5 4 3 1 36 0 36 83.333 2 4 0 0.00 0 0 1200 WEST COLLEGE STREET LIBERTY, MO 64068 (39.247312, -94.442439) 02/01/2020
4663 4663 400 BOMAR HEIGHTS COLUMBIA, KY 42728 37.094397 -85.310119 0   185052 SIGNATURE HEALTHCARE AT SUMMIT MANOR REHAB & WELLN 400 BOMAR HEIGHTS COLUMBIA KY 42728 2703842153 0 Adair For profit - Corporation 104 96.5 Medicare and Medicaid false LP COLUMBIA KY LLC 06/27/1967 false   false false false None Yes 2   3   1   1   2   3   3       2.28222 0.6193 0.60139 1.22069 3.50291 0.0489 2.25795 0.81042 0.41017 3.47854 2.10067 0.57462 0.55186 3.22913 10/17/2019 6 4 2 24 1 0 24 09/13/2018 7 6 1 28 1 0 28 2017-07-20 8 7 1 1 52 0 52 30 2 3 0 0.00 0 0 400 BOMAR HEIGHTS COLUMBIA, KY 42728 (37.094397, -85.310119) 02/01/2020
4862 4862 590 S Indian Hill Blvd, Claremont, CA 91711, USA 34.0852967 -117.7180953 1 ROOFTOP 55344 COUNTRY VILLA CLAREMONT HEALTH CENTER 590 S. INDIAN HILL BLVD. CLAREMONT CA 91711 9096244511 200 Los Angeles For profit - Individual 99 87.2 Medicare and Medicaid false COUNTRY VILLA CLAREMONT HEALTHCARE CENTER, INC. 10/01/1976 false   false false false Resident Yes 2   2   3   4   3   3   3       2.52982 0.88193 0.42066 1.30259 3.83241 0.0662 1.98854 0.6962 0.3023 2.98704 2.64406 0.95254 0.52374 4.11418 07/01/2019 15 12 4 96 1 0 96 07/21/2018 17 12 5 88 1 0 88 2017-07-20 20 11 9 1 96 0 96 93.333 6 12 0 0.00 1 1   02/01/2020
6939 6939 400 NORTH 4TH AVENUE EAST TRUMAN, MN 56088 43.830961 -94.430121 0   245346 TRUMAN SENIOR LIVING 400 NORTH 4TH AVENUE EAST TRUMAN MN 56088 5077762031 450 Martin Non profit - Corporation 40 35.4 Medicare and Medicaid false HEARTLAND SENIOR LIVING 10/01/1986 false   false false false Both Yes 2   1   4   5   2   4   4       2.41644 0.49144 0.84496 1.33641 3.75285 0.02928 1.95632 0.66987 0.3057 2.93189 2.56715 0.55165 1.04034 4.10456 06/14/2019 11 11 0 76 1 0 76 08/23/2018 15 15 0 171 2 86 257 2017-07-20 13 13 0 1 64 0 64 134.333 0 0 1 72867.00 0 1 400 NORTH 4TH AVENUE EAST TRUMAN, MN 56088 (43.830961, -94.430121) 02/01/2020
7210 7210 415 COOK SPRINGS PELL CITY, AL 35125 33.593208 -86.398024 0   15195 VILLAGE AT COOK SPRINGS SKILLED NURSING FACILITY 415 COOK SPRINGS PELL CITY AL 35125 2053382221 570 St. Clair Non profit - Corporation 168 147.1 Medicare and Medicaid false VILLAGE AT COOK SPRINGS, LLC 12/01/1977 true SFF Candidate true false false Resident Yes 2   1   4   4   5   4   4       2.33117 0.81728 0.66763 1.4849 3.81608 0.01572 2.00682 0.67553 0.31048 2.99283 2.41425 0.90972 0.80935 4.08873 07/28/2019 5 5 4 208 2 104 312 08/16/2018 10 5 5 132 1 0 132 2017-07-20 8 8 0 1 44 0 44 207.333 0 5 2 619290.00 1 3 415 COOK SPRINGS PELL CITY, AL 35125 (33.593208, -86.398024) 02/01/2020
7529 7529 2990 EAST RAMON ROAD PALM SPRINGS, CA 92264 33.815896 -116.513422 0   56328 PREMIER CARE CENTER FOR PALM SPRINGS 2990 EAST RAMON ROAD PALM SPRINGS CA 92264 7603232638 430 Riverside For profit - Individual 99 87.7 Medicare and Medicaid false ENSIGN PALM I LLC 12/26/1973 false   true false false Resident Yes 2   2   4   5   4   2   2       2.25399 1.36159 0.32269 1.68428 3.93827 0.0734 2.12703 0.76457 0.35473 3.24633 2.20239 1.3391 0.34238 3.89015 05/16/2019 25 16 9 128 1 0 128 06/29/2018 19 9 10 92 1 0 92 2017-07-20 20 8 12 1 88 0 88 109.333 19 17 0 0.00 0 0 2990 EAST RAMON ROAD PALM SPRINGS, CA 92264 (33.815896, -116.513422) 02/01/2020
7643 7643 1100 EAST MARTIN DRIVE WYNNE, AR 72396 35.216024 -90.78129 0   45157 RIVER RIDGE REHABILITATION AND CARE CENTER 1100 EAST MARTIN DRIVE WYNNE AR 72396 8702384400 180 Cross Non profit - Corporation 100 68.9 Medicare and Medicaid false PROGRESSIVE ELDERCARE SERVICES - CROSS, INC. 08/07/1990 false   false false false Resident Yes 2   2   2   2   3   3   2       2.61115 1.20459 0.27518 1.47977 4.09092 0.01814 2.00628 0.68851 0.32508 3.01987 2.70493 1.31557 0.31861 4.34396 07/19/2019 13 10 3 104 1 0 104 09/27/2018 2 2 0 83 1 0 83 2017-07-20 10 4 7 1 92 0 92 95 1 5 3 50063.00 0 3 1100 EAST MARTIN DRIVE WYNNE, AR 72396 (35.216024, -90.78129) 02/01/2020
8932 8932 707 SHEPERDSTOWN RD MECHANICSBURG, PA 17055 40.205845 -77.000928 0   396133 VIBRA REHABILITATION CENTER 707 SHEPERDSTOWN RD MECHANICSBURG PA 17055 7175912125 270 Cumberland For profit - Corporation 48 41.9 Medicare false MECHANICSBURG SENIOR CARE, LLC 02/11/2014 false SFF Candidate false false false Resident Yes 2   1   5     2 5   3   4       1.83543 1.02266 1.05343 2.07608 3.91152 0.18119 2.18534 0.90018 0.4964 3.58192 1.74557 0.85425 0.79873 3.50173 08/14/2019 27 19 8 381 1 0 381 07/02/2018 27 10 17 128 1 0 128 2017-07-20 8 3 5 1 32 0 32 238.5 2 12 0 0.00 0 0 707 SHEPERDSTOWN RD MECHANICSBURG, PA 17055 (40.205845, -77.000928) 02/01/2020
9730 9730 1108 BIRCH STREET DOUGLAS, WY 82633 42.752626 -105.373322 0   535040 DOUGLAS CARE CENTER LLC 1108 BIRCH STREET DOUGLAS WY 82633 3073583397 40 Converse For profit - Limited Liability company 60 53.9 Medicare and Medicaid false DOUGLAS CARE CENTER, LLC 01/01/1990 false   false false false Resident Yes 2   2   3   2   4   3   4       1.56997 0.32678 0.58913 0.91591 2.48588 0.00726 1.68556 0.60802 0.26768 2.56125 1.93582 0.40413 0.82839 3.1123 09/12/2019 11 11 11 44 2 22 66 08/02/2018 14 11 4 88 1 0 88 2017-07-20 8 8 2 1 52 0 52 71 0 6 0 0.00 0 0 1108 BIRCH STREET DOUGLAS, WY 82633 (42.752626, -105.373322) 02/01/2020
9947 9947 225 NORTH BROADWAY CARNEGIE, OK 73015 35.108643 -98.604898 0   3.7e+25 CARNEGIE NURSING HOME, INC. 225 NORTH BROADWAY CARNEGIE OK 73015 5806541439 70 Caddo For profit - Corporation 100 44.1 Medicaid false Legal Business Name Not Available 09/01/1975 false   false false false Resident Yes 2   3   2   2     2 1   1       1.5565 0.86257 0.20109 1.06366 2.62016 0 1.64315 0.58305 0.24979 2.47599 1.96874 1.11242 0.303 3.39337 10/16/2019 2 2 0 16 1 0 16 09/12/2018 5 5 0 28 1 0 28 2017-07-20 19 16 3 1 207 0 207 51.833 0 1 0 0.00 0 0 225 NORTH BROADWAY CARNEGIE, OK 73015 (35.108643, -98.604898) 02/01/2020
10316 10316 960 S RAPIDS RD MANITOWOC, WI 54220 44.088832 -87.707091 0   525475 RIVER'S BEND HEALTH SERVICES 960 S RAPIDS RD MANITOWOC WI 54220 9206841144 350 Manitowoc For profit - Limited Liability company 100 81.4 Medicare and Medicaid false NSH MANITOWOC LLC 07/01/1991 false   false false false Resident Yes 2   2   4   5   4   3   4       2.0106 0.54576 0.87231 1.41807 3.42867 0.05088 2.18293 0.79329 0.34827 3.32449 1.91426 0.51731 0.94273 3.30715 08/28/2019 11 10 5 56 1 0 56 08/23/2018 13 2 11 115 1 0 115 2017-07-20 8 6 2 1 36 0 36 72.333 0 6 0 0.00 0 0 960 S RAPIDS RD MANITOWOC, WI 54220 (44.088832, -87.707091) 02/01/2020
11060 11060 104 COLLEGE DRIVE FLAT ROCK, NC 28731 35.303915 -82.417698 0   345493 HENDERSONVILLE HEALTH AND REHABILITATION 104 COLLEGE DRIVE FLAT ROCK NC 28731 8286938600 440 Henderson For profit - Corporation 130 111.9 Medicare and Medicaid false HENDERSONVILLE HEALTH AND REHABILITATION 06/03/1999 false   false false false Resident Yes 2   1   5   4   5   2   3       2.05181 0.6762 0.72675 1.40296 3.45477 0 2.2536 0.88377 0.48987 3.62725 1.89224 0.57534 0.55838 3.05418 07/25/2019 3 2 2 12 1 0 12 06/07/2018 10 8 10 52 1 0 52 2017-07-20 11 4 7 1 378 0 378 86.333 0 1 1 8128.00 1 2 104 COLLEGE DRIVE FLAT ROCK, NC 28731 (35.303915, -82.417698) 02/01/2020
11421 11421 12100 REED HARTMAN HIGHWAY CINCINNATI, OH 45241 39.291799 -84.370733 0   365712 BROOKWOOD RETIREMENT COMMUNITY 12100 REED HARTMAN HIGHWAY CINCINNATI OH 45241 5136052000 310 Hamilton For profit - Individual 131 124.6 Medicare and Medicaid false C MICAH RAND 09/06/1988 true   false false false Resident Yes 2   2   4   4   4   2   2       2.31146 1.32116 0.48539 1.80655 4.11801 0.05028 2.19609 0.86042 0.47109 3.52761 2.18752 1.15459 0.3878 3.74335 10/31/2019 14 14 0 80 1 0 80 09/20/2018 11 11 1 60 1 0 60 2017-07-20 1 1 0 0 0 0 0 60 0 1 0 0.00 0 0 12100 REED HARTMAN HIGHWAY CINCINNATI, OH 45241 (39.291799, -84.370733) 02/01/2020
12848 12848 417 PA-28, Brookville, PA 15825, USA 41.1622253 -79.05444179999999 1 ROOFTOP 395626 JEFFERSON MANOR HEALTH CENTER 417 ROUTE 28 BROOKVILLE PA 15825 8148498026 400 Jefferson Non profit - Corporation 160 109.5 Medicare and Medicaid false JEFFCO HEALTH SERVICES INC. 01/01/1984 true   false false false Resident Yes 2   1   5   4   5   2   2       1.98195 1.16063 0.50176 1.66239 3.64434 0.04153 2.25604 0.81489 0.41706 3.48799 1.82584 1.07096 0.45283 3.3504 07/25/2019 27 24 3 132 1 0 132 08/09/2018 17 11 6 112 1 0 112 2017-07-20 8 7 1 1 48 0 48 111.333 1 5 1 13393.00 0 1   02/01/2020
12854 12854 5801 NORTH OAKWOOD ROAD ENID, OK 73703 36.452348 -97.926143 0   375406 GOLDEN OAKS VILLAGE 5801 NORTH OAKWOOD ROAD ENID OK 73703 5802492600 230 Garfield Non profit - Corporation 80 67.6 Medicare and Medicaid false OAKWOOD RETIREMENT VILLAGE INC 03/04/2002 false   false false false Resident Yes 2   1   4   4   5   4   3       3.44373 1.16524 0.41713 1.58237 5.0261 0.02723 1.88933 0.64043 0.27923 2.80899 3.78825 1.36813 0.56226 5.73766 12/05/2019 11 5 6 243 1 0 243 10/11/2018 7 7 0 60 1 0 60 2017-07-20 7 7 0 1 68 0 68 152.833 0 2 2 71178.00 0 2 5801 NORTH OAKWOOD ROAD ENID, OK 73703 (36.452348, -97.926143) 02/01/2020
13214 13214 4000 GOLDEN AGE DRIVE BATAVIA, OH 45103 39.079754 -84.142303 0   365469 BATAVIA NURSING CARE CENTER 4000 GOLDEN AGE DRIVE BATAVIA OH 45103 5137326500 120 Clermont For profit - Corporation 120 100.6 Medicare and Medicaid false CHS-BATAVIA, INC 04/02/1980 false   false false false Resident Yes 2   2   3   4   2   2   2       1.6981 1.30536 0.61369 1.91904 3.61714 0.05224 2.18545 0.89291 0.71824 3.7966 1.61487 1.09927 0.32159 3.05509 11/21/2019 8 7 1 68 1 0 68 09/28/2018 8 8 0 56 1 0 56 2017-07-20 15 8 7 1 104 0 104 70 0 4 1 17550.00 0 1 4000 GOLDEN AGE DRIVE BATAVIA, OH 45103 (39.079754, -84.142303) 02/01/2020
13279 13279 801 PINEHURST AVENUE CARTHAGE, NC 28327 35.333449 -79.415853 0   345429 PEAK RESOURCES - PINELAKE 801 PINEHURST AVENUE CARTHAGE NC 28327 9109475155 620 Moore For profit - Corporation 90 85.1 Medicare and Medicaid false CARTHAGE HEALTHCARE INC. 12/14/1992 false   false false false Resident Yes 2   3   4   3   5   1   1       2.27376 0.64219 0.32471 0.9669 3.24066 0 2.0805 0.85963 0.48019 3.42032 2.2714 0.56174 0.25451 3.03823 08/22/2019 8 8 0 28 1 0 28 07/26/2018 7 6 1 28 1 0 28 2017-07-20 5 5 0 1 16 0 16 26 0 0 0 0.00 0 0 801 PINEHURST AVENUE CARTHAGE, NC 28327 (35.333449, -79.415853) 02/01/2020
14828 14828 2512 NEW PINE DR ALTOONA, WI 54720 44.808211 -91.450643 0   525454 OAKWOOD HEALTH SERVICES 2512 NEW PINE DR ALTOONA WI 54720 7158330400 170 Eau Claire For profit - Corporation 80 66.3 Medicare and Medicaid false NSH ALTOONA LLC 01/01/1990 false   false false false Both Yes 2   1   5   5   4   4   5       1.85637 0.49446 1.18719 1.68164 3.53802 0.05057 2.17236 0.80445 0.3856 3.36241 1.77603 0.46218 1.15882 3.37414 08/26/2019 23 17 12 172 2 86 258 08/02/2018 6 5 1 40 1 0 40 2017-07-20 4 4 0 1 20 0 20 145.667 0 6 0 0.00 0 0 2512 NEW PINE DR ALTOONA, WI 54720 (44.808211, -91.450643) 02/01/2020
15072 15072 130 STRAWBERRY LN WISCONSIN RAPIDS, WI 54494 44.408755 -89.801792 0   525429 EDENBROOK OF WISCONSIN RAPIDS 130 STRAWBERRY LN WISCONSIN RAPIDS WI 54494 7154241600 700 Wood For profit - Corporation 80 58.7 Medicare and Medicaid false STRAWBERRY LANE NURSING AND REHAB LLC 08/01/1989 false   false false false Resident Yes 2   2   2   2   3   3   4       2.06875 0.54801 0.91333 1.46134 3.53009 0.08695 2.17436 0.84453 0.4364 3.45529 1.97739 0.48793 0.78773 3.27608 11/06/2019 5 2 3 20 1 0 20 10/15/2018 12 11 1 96 2 48 144 2017-07-20 7 5 2 1 103 0 103 75.167 0 4 2 104107.00 1 3 130 STRAWBERRY LN WISCONSIN RAPIDS, WI 54494 (44.408755, -89.801792) 02/01/2020
15244 15244 202 BILLIE DR FREDERICKSBURG, TX 78624 30.256657 -98.882658 0   675740 KNOPP NURSING & REHAB CENTER INC 202 BILLIE DR FREDERICKSBURG TX 78624 8309978840 552 Gillespie For profit - Corporation 60 37.1 Medicare and Medicaid false KNOPP NURSING & REHABILITATION CENTER INC 12/11/1997 false   false false false Resident Yes 2   2   2   2   3   3   3       1.79293 1.02104 0.49941 1.52045 3.31339 0.14803 1.96401 0.70025 0.35962 3.02388 1.8973 1.09641 0.52268 3.51366 08/16/2019 11 11 0 80 1 0 80 08/31/2018 17 17 0 160 1 0 160 2017-07-20 7 7 0 1 60 0 60 103.333 0 0 0 0.00 0 0 202 BILLIE DR FREDERICKSBURG, TX 78624 (30.256657, -98.882658) 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
);