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

25 rows where Overall Rating = 5 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-01-12

✎ 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, Continuing Care Retirement Community, 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, RN Staffing Rating, 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, Total Number of Penalties, 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
233 233 815 MAIN AVENUE SOUTH HARMONY, MN 55939 43.545985 -92.010055 0   245528 GUNDERSEN HARMONY CARE CENTER 815 MAIN AVENUE SOUTH HARMONY MN 55939 5078866544 220 Fillmore Non profit - Corporation 43 34.4 Medicare and Medicaid false HARMONY COMMUNITY HEALTHCARE, INC. 04/01/1988 false   false false false Both Yes 5   4   5   5     2 5   5       2.22227 0.59268 0.98641 1.57909 3.80136 0.02193 1.99121 0.63716 0.29473 2.9231 2.3195 0.69946 1.25969 4.17012 04/24/2019 3 3 2 12 1 0 12 03/15/2018 5 3 2 20 1 0 20 2017-01-12 4 4 0 1 16 0 16 15.333 2 0 0 0.00 0 0 815 MAIN AVENUE SOUTH HARMONY, MN 55939 (43.545985, -92.010055) 02/01/2020
519 519 277 ELLIOT STREET NEWTON UPPER FALLS, MA 02164 42.312722 -71.220644 0   225683 STONE REHABILITATION AND SENIOR LIVING 277 ELLIOT STREET NEWTON UPPER FALLS MA 2164 6175270023 90 Middlesex Non profit - Other 82 75.8 Medicare and Medicaid false STONE INSTITUTE AND NEWTON HOME FOR AGED PEOPLE 12/15/1995 false   false false false Resident Yes 5   4   5   5   5   3   3       2.34792 1.0733 0.43055 1.50386 3.85178 0 2.22637 0.66681 0.29173 3.18491 2.1918 1.21033 0.5555 3.87809 04/19/2019 6 6 0 32 1 0 32 04/02/2018 8 8 0 32 1 0 32 2017-01-12 0 0 0 0 0 0 0 26.667 0 0 0 0.00 0 0 277 ELLIOT STREET NEWTON UPPER FALLS, MA 02164 (42.312722, -71.220644) 02/01/2020
597 597 555 EAST AJO WAY TUCSON, AZ 85713 32.177887 -110.961518 0   35284 ARIZONA STATE VETERAN HOME-TUCSON 555 EAST AJO WAY TUCSON AZ 85713 5206382150 90 Pima Government - State 120 116.5 Medicare and Medicaid false STATE OF ARIZONA STATE DEPT OF FINANCE 02/23/2012 false   false false false Resident Yes 5   4   5   5     2 4   4       3.43504 1.45091 0.69953 2.15045 5.58549 0.03028 1.91279 0.63064 0.2846 2.82802 3.73233 1.72999 0.92514 6.33331 05/23/2019 5 5 0 20 1 0 20 03/01/2018 1 1 1 4 1 0 4 2017-01-12 2 2 0 1 8 0 8 12.667 1 0 0 0.00 0 0 555 EAST AJO WAY TUCSON, AZ 85713 (32.177887, -110.961518) 02/01/2020
647 647 1676 MEDICAL CTR DR SAN BERNARDINO, CA 92411 34.130267 -117.322562 0   56107 COMMUNITY CONVALESCENT CENTER OF SAN BERNARDINO 1676 MEDICAL CTR DR. SAN BERNARDINO CA 92411 9098876481 460 San Bernardino Non profit - Corporation 84 34.9 Medicare and Medicaid false Legal Business Name Not Available 04/01/1973 false   false false false Both Yes 5   4   5   5     2 3   1       3.83871 4.25389 1.10646 5.36036 9.19907 0 2.51709 1.06902 1.97356 5.55966 3.16958 2.99217 0.21102 5.30577 01/24/2019 4 4 0 24 1 0 24 02/16/2018 6 6 0 32 1 0 32 2017-01-12 4 3 1 1 16 0 16 25.333 2 0 0 0.00 0 0 1676 MEDICAL CTR DR SAN BERNARDINO, CA 92411 (34.130267, -117.322562) 02/01/2020
1584 1584 4000 KINGS HWY PORT CHARLOTTE, FL 33980 26.970698 -82.067281 0   105859 SOLARIS HEALTHCARE CHARLOTTE HARBOR 4000 KINGS HWY PORT CHARLOTTE FL 33980 9412555855 70 Charlotte Non profit - Corporation 180 170.1 Medicare and Medicaid false SOLARIS HEALTHCARE CHARLOTTE HARBOR LLC 06/02/1994 false   false false false Resident Yes 5   4   5   5   5   3   2       2.72237 1.23338 0.44657 1.67995 4.40233 0.07819 2.17666 0.78142 0.36962 3.3277 2.5994 1.18685 0.45475 4.2422 03/21/2019 2 2 0 20 1 0 20 03/01/2018 0 0 0 0 0 0 0 2017-01-12 3 3 0 1 16 0 16 12.667 0 0 0 0.00 0 0 4000 KINGS HWY PORT CHARLOTTE, FL 33980 (26.970698, -82.067281) 02/01/2020
1917 1917 1009 THIRD STREET REINBECK, IA 50669 42.323982 -92.607363 0   165522 PARKVIEW MANOR CARE CENTER 1009 THIRD STREET REINBECK IA 50669 3193456811 370 Grundy For profit - Corporation 40 30.6 Medicare and Medicaid false PARKVIEW MANOR, INC. 12/01/2003 false   false false false Resident Yes 5   4   5   5     2 4   5       2.2238 0.41691 1.26069 1.6776 3.9014 0.01563 2.29282 0.70597 0.279 3.27779 2.01577 0.44406 1.70074 3.81674 07/18/2019 3 3 0 4 1 0 4 04/05/2018 5 5 0 24 1 0 24 2017-01-12 2 2 0 1 8 0 8 11.333 0 0 0 0.00 0 0 1009 THIRD STREET REINBECK, IA 50669 (42.323982, -92.607363) 02/01/2020
2303 2303 4623 ROGERS AVE FORT SMITH, AR 72903 35.367743 -94.380337 0   45364 CHAPEL RIDGE HEALTH AND REHAB 4623 ROGERS AVE FORT SMITH AR 72903 4794521541 650 Sebastian For profit - Corporation 157 89 Medicare and Medicaid false CHAPEL RIDGE NURSING CENTER LLC 03/17/2001 false   false false false Resident Yes 5   4   5   5   3   2   1       2.72332 1.04148 0.22397 1.26544 3.98877 0.01461 1.99656 0.66503 0.30272 2.96431 2.83487 1.17759 0.27846 4.31488 02/07/2019 2 2 0 20 1 0 20 04/12/2018 5 5 0 36 1 0 36 2017-01-12 2 2 0 1 12 0 12 24 0 0 0 0.00 0 0 4623 ROGERS AVE FORT SMITH, AR 72903 (35.367743, -94.380337) 02/01/2020
2740 2740 3700 CEDAR LAKE AVENUE MINNEAPOLIS, MN 55416 44.953618 -93.326854 0   245460 JONES HARRISON RESIDENCE 3700 CEDAR LAKE AVENUE MINNEAPOLIS MN 55416 6129202030 260 Hennepin Non profit - Corporation 157 143.4 Medicare and Medicaid false JONES HARRISON RESIDENCE 04/01/1987 false   false false false Resident Yes 5   4   5   5   4   5   5       2.62369 0.97911 1.03965 2.01876 4.64245 0.09716 2.18047 0.64243 0.28502 3.10792 2.5008 1.14601 1.37289 4.78994 05/02/2019 1 1 0 4 1 0 4 03/08/2018 7 4 3 52 1 0 52 2017-01-12 3 3 0 1 12 0 12 21.333 5 1 0 0.00 0 0 3700 CEDAR LAKE AVENUE MINNEAPOLIS, MN 55416 (44.953618, -93.326854) 02/01/2020
3014 3014 1200 HOMELIFE PLAZA ROLLA, MO 65401 37.955884 -91.753592 0   265580 ROLLA PRESBYTERIAN MANOR 1200 HOMELIFE PLAZA ROLLA MO 65401 5733647336 800 Phelps Non profit - Corporation 30 22.4 Medicare and Medicaid false PRESBYTERIAN MANORS INC 07/01/1994 true   false false false Resident Yes 5   4   4   4     2 5   5       3.45372 1.38697 1.04198 2.42895 5.88267 0.03145 2.04774 0.63552 0.30547 2.98873 3.50532 1.64106 1.28386 6.31161 01/04/2019 4 4 0 44 1 0 44 12/08/2017 2 2 0 4 1 0 4 2017-01-12 2 2 0 1 16 0 16 26 0 0 0 0.00 0 0 1200 HOMELIFE PLAZA ROLLA, MO 65401 (37.955884, -91.753592) 02/01/2020
3092 3092 355 RAYMOND STREET ELGIN, IL 60120 42.029128 -88.273648 0   145447 HERITAGE HEALTH-ELGIN 355 RAYMOND STREET ELGIN IL 60120 8476976636 530 Kane For profit - Corporation 94 76.9 Medicare and Medicaid false HERITAGE MANOR ELGIN LLC 07/08/1982 false   false false false Both Yes 5   5   5   5   3   3   4       2.17225 0.2664 0.77414 1.04054 3.21279 0.07132 2.21168 0.82277 0.35679 3.39123 2.04129 0.24347 0.81666 3.03793 12/13/2018 0 0 0 0 0 0 0 11/17/2017 2 2 0 8 1 0 8 2017-01-12 0 0 0 0 0 0 0 2.667 0 0 0 0.00 0 0 355 RAYMOND STREET ELGIN, IL 60120 (42.029128, -88.273648) 02/01/2020
5550 5550 1408 SUMMERLIN LANE BASTROP, LA 71220 32.789319 -91.897748 0   195593 LAGNIAPPE HEALTHCARE 1408 SUMMERLIN LANE BASTROP LA 71220 3182815188 330 Morehouse For profit - Limited Liability company 112 77.8 Medicare and Medicaid false LAGNIAPPE HEALTHCARE LLC 05/02/2004 false   false false false Both Yes 5   5   3   3   2   2   1       2.86078 1.05864 0.232 1.29064 4.15142 0.03924 2.06675 0.7485 0.3527 3.16794 2.87682 1.06351 0.24758 4.20216 02/14/2019 0 0 0 0 1 0 0 02/15/2018 0 0 0 0 0 0 0 2017-01-12 1 1 0 1 8 0 8 1.333 0 0 0 0.00 0 0 1408 SUMMERLIN LANE BASTROP, LA 71220 (32.789319, -91.897748) 02/01/2020
5696 5696 914 DAVIDSON DRIVE OSAGE, IA 50461 43.276647 -92.807309 0   165433 FAITH LUTHERAN HOME 914 DAVIDSON DRIVE OSAGE IA 50461 6417325511 650 Mitchell Non profit - Corporation 60 52.1 Medicare and Medicaid false FAITH LUTHERAN HOME 06/01/2002 false   false false false Resident Yes 5   4   5   5   5   3   4       2.14767 0.54945 0.74297 1.29242 3.44009 0.03489 2.07818 0.70364 0.30937 3.09119 2.14783 0.58717 0.9039 3.5686 07/11/2019 4 4 0 12 1 0 12 04/05/2018 2 2 0 8 1 0 8 2017-01-12 0 0 0 0 0 0 0 8.667 0 0 0 0.00 0 0 914 DAVIDSON DRIVE OSAGE, IA 50461 (43.276647, -92.807309) 02/01/2020
6060 6060 451 WEST ORANGE STREET WEST BRANCH, IA 52358 41.674835 -91.353225 0   165287 CRESTVIEW SPECIALTY CARE 451 WEST ORANGE STREET WEST BRANCH IA 52358 3196432551 150 Cedar Non profit - Corporation 65 61.5 Medicare and Medicaid false CARE INITIATIVES 09/01/1996 false   false false false Resident Yes 5   5   5   5   5   4   5       2.53419 0.36841 0.80667 1.17509 3.70927 0.0206 2.06986 0.62945 0.28828 2.98758 2.54457 0.4401 1.05322 3.98127 06/12/2019 0 0 0 0 0 0 0 03/08/2018 1 1 0 4 1 0 4 2017-01-12 0 0 0 0 0 0 0 1.333 0 0 0 0.00 0 0 451 WEST ORANGE STREET WEST BRANCH, IA 52358 (41.674835, -91.353225) 02/01/2020
6316 6316 2601 FAIR STREET CHILLICOTHE, MO 64601 39.815728 -93.559414 0   265785 INDIAN HILLS-A STONEBRIDGE COMMUNITY 2601 FAIR STREET CHILLICOTHE MO 64601 6606461230 580 Livingston For profit - Individual 75 62.9 Medicare and Medicaid false ELDERCARE OF MID-MISSOURI IX INC 04/23/2004 false   false false false Resident Yes 5   5   2   2   2   4   4       2.70891 0.58313 0.56757 1.1507 3.85961 0.0292 1.88601 0.63195 0.29049 2.80845 2.98516 0.69385 0.73539 4.40687 02/22/2019 1 1 0 4 1 0 4 04/19/2018 5 5 0 20 1 0 20 2017-01-12 2 2 0 1 20 0 20 12 0 0 0 0.00 0 0 2601 FAIR STREET CHILLICOTHE, MO 64601 (39.815728, -93.559414) 02/01/2020
6367 6367 3674 PACIFIC AVENUE RIVERSIDE, CA 92509 34.005874 -117.420382 0   05A264 VISTA PACIFICA CENTER 3674 PACIFIC AVENUE RIVERSIDE CA 92509 9516824833 430 Riverside For profit - Individual 108 107.9 Medicaid false Legal Business Name Not Available 03/01/1976 false   false false false Resident Yes 5   4   5   5     2 3   2       2.00097 0.61168 0.24834 0.86002 2.861 0 1.433 0.5278 0.22819 2.18899 2.90209 0.87144 0.40962 4.19108 01/10/2019 6 5 1 28 1 0 28 02/26/2018 8 4 5 32 1 0 32 2017-01-12 3 3 0 1 12 0 12 26.667 5 0 0 0.00 0 0 3674 PACIFIC AVENUE RIVERSIDE, CA 92509 (34.005874, -117.420382) 02/01/2020
6541 6541 901 SOUTHEAST WILLMAR AVENUE WILLMAR, MN 56201 45.110548 -95.031343 0   245427 BETHESDA 901 SOUTHEAST WILLMAR AVENUE WILLMAR MN 56201 3202625376 330 Kandiyohi Non profit - Church related 248 229.6 Medicare and Medicaid false BETHESDA 02/01/1987 false   false false false Both Yes 5   4   5   5   4   4   3       3.32985 0.76892 0.51742 1.28634 4.61619 0.03159 1.89413 0.63324 0.28751 2.81488 3.65369 0.91305 0.67737 5.25869 04/25/2019 3 3 0 12 1 0 12 03/22/2018 5 5 0 24 1 0 24 2017-01-12 5 5 0 1 36 0 36 20 0 0 0 0.00 0 0 901 SOUTHEAST WILLMAR AVENUE WILLMAR, MN 56201 (45.110548, -95.031343) 02/01/2020
6888 6888 111 RENEGAR WAY SAINT SIMONS ISLAND, GA 31522 31.225139 -81.380968 0   115718 MARSH'S EDGE 111 RENEGAR WAY SAINT SIMONS ISLAND GA 31522 9122912000 490 Glynn For profit - Limited Liability company 20 11 Medicare false MARSH'S EDGE, LLC 04/25/2007 true   false false false Resident Yes 5   4   4   4   5   5   5       3.06767 3.37918 1.76722 5.14641 8.21407 0.08857 2.14488 0.71593 0.32018 3.18098 2.97249 3.54917 2.07746 8.28038 12/19/2018 0 0 0 0 0 0 0 11/22/2017 2 2 0 12 1 0 12 2017-01-12 5 5 0 1 32 0 32 9.333 0 0 0 0.00 0 0 111 RENEGAR WAY SAINT SIMONS ISLAND, GA 31522 (31.225139, -81.380968) 02/01/2020
7223 7223 1002 WEST MAIN STREET JEFFERSON CITY, MO 65109 38.586432 -92.184452 0   265794 HEISINGER LUTHERAN HOME 1002 WEST MAIN STREET JEFFERSON CITY MO 65109 5736366288 250 Cole Non profit - Church related 29 25.7 Medicare and Medicaid false COLE COUNTY LUTHERAN HOME ASSOCIATION 01/05/2005 true   false false false Both Yes 5   4   3   3     2 5   5       4.36188 1.14718 1.11391 2.26109 6.62297 0.00851 2.0938 0.64286 0.26483 3.00149 4.32968 1.34183 1.58313 7.0757 12/21/2018 4 4 0 32 1 0 32 03/21/2018 1 1 0 8 1 0 8 2017-01-12 7 7 0 1 32 0 32 24 0 0 0 0.00 0 0 1002 WEST MAIN STREET JEFFERSON CITY, MO 65109 (38.586432, -92.184452) 02/01/2020
8663 8663 350 NORTH ELEVENTH ST SUNBURY, PA 17801 40.862243 -76.778268 0   395317 SUNBURY COMMUNITY HEALTH AND REHABILITATION CENTER 350 NORTH ELEVENTH ST SUNBURY PA 17801 5702863378 600 Northumberlnd For profit - Corporation 29 24.3 Medicare and Medicaid false KLING HEALTH SERVICES LP 04/01/1974 false   false false false Both Yes 5   3   5   4   5   5   5       1.97077 1.05959 1.58017 2.63976 4.61053 0.04373 2.28232 0.83227 0.41137 3.52595 1.79463 0.95733 1.44579 4.19303 01/30/2019 5 5 0 24 1 0 24 12/19/2017 10 6 4 48 1 0 48 2017-01-12 4 4 0 1 40 0 40 34.667 0 2 0 0.00 0 0 350 NORTH ELEVENTH ST SUNBURY, PA 17801 (40.862243, -76.778268) 02/01/2020
9711 9711 3884 NOBEL DRIVE SAN DIEGO, CA 92122 32.868484 -117.221862 0   555739 THE SPRINGS AT PACIFIC REGENT 3884 NOBEL DRIVE SAN DIEGO CA 92122 8586258700 470 San Diego For profit - Corporation 59 52.4 Medicare false LA JOLLA SKILLED, INC. 06/28/1999 false   false false false None Yes 5   5   3     2 3   4   4       2.50795 1.20332 1.50968 2.713 5.22094 0.42038 2.28684 1.08527 0.62244 3.99456 2.27928 0.83373 0.91289 4.19115 02/14/2019 5 4 1 20 1 0 20 04/06/2018 7 7 0 28 1 0 28 2017-01-12 6 3 3 1 28 0 28 24 3 3 0 0.00 0 0 3884 NOBEL DRIVE SAN DIEGO, CA 92122 (32.868484, -117.221862) 02/01/2020
10560 10560 120 CARE CENTER ROAD ARLINGTON, SD 57212 44.368171 -97.132495 0   435050 AVANTARA ARLINGTON 120 CARE CENTER ROAD POST OFFICE BOX 280 ARLINGTON SD 57212 6059835796 380 Kingsbury For profit - Limited Liability company 35 35.2 Medicare and Medicaid false ARLINGTON SD SKILLED NURSING FACILITY LLC 01/01/1991 false   false false false Resident Yes 5   3   5   4   5   4   5       1.68943 0.30239 0.94637 1.24877 2.93819 0.02778 1.93661 0.66678 0.30913 2.91252 1.81307 0.34101 1.15225 3.23492 06/26/2019 9 9 0 44 1 0 44 03/15/2018 0 0 0 0 0 0 0 2017-01-12 5 5 0 1 28 0 28 26.667 0 0 0 0.00 0 0 120 CARE CENTER ROAD ARLINGTON, SD 57212 (44.368171, -97.132495) 02/01/2020
11662 11662 10805 El Camino Real, Atascadero, CA 93422, USA 35.4571194 -120.6398085 1 ROOFTOP 555554 DANISH CARE CENTER 10805 EL CAMINO REAL ATASCADERO CA 93422 8054669254 500 San Luis Obispo For profit - Corporation 65 57.3 Medicare and Medicaid false COMPASS HEALTH INC 03/17/1993 false   false false false Resident Yes 5   5   5   5   5   4   3       3.44316 1.11575 0.46759 1.58334 5.0265 0.0818 2.29175 0.72967 0.33396 3.35537 3.12253 1.14981 0.527 4.80373 01/30/2019 3 3 0 20 1 0 20 01/16/2018 6 5 1 28 1 0 28 2017-01-12 5 5 0 1 28 0 28 24 0 1 0 0.00 0 0   02/01/2020
11966 11966 3202 S WILLIS ST ABILENE, TX 79605 32.410893 -99.765797 0   675593 WISTERIA PLACE 3202 S WILLIS ST ABILENE TX 79605 3256926145 911 Taylor For profit - Corporation 123 76.8 Medicare and Medicaid false EASTLAND MEMORIAL HOSPITAL DISTRICT 07/01/1996 true   false false false Resident Yes 5   5   5   5   5   2   2       1.85161 0.99763 0.38769 1.38533 3.23694 0.27112 2.07413 0.82968 0.42326 3.32707 1.85537 0.90416 0.34476 3.11979 05/01/2019 0 0 0 0 0 0 0 03/16/2018 1 1 0 8 1 0 8 2017-01-12 10 9 1 1 80 0 80 16 1 1 0 0.00 0 0 3202 S WILLIS ST ABILENE, TX 79605 (32.410893, -99.765797) 02/01/2020
12639 12639 3801 WADE COBLE DRIVE BURLINGTON, NC 27215 36.082406 -79.521844 0   345235 TWIN LAKES COMMUNITY 3801 WADE COBLE DRIVE BURLINGTON NC 27215 3365381400 0 Alamance Non profit - Church related 100 94.1 Medicare and Medicaid false LUTHERAN RETIREMENT MINISTRIES OF ALAMANCE COUNTY, NORTH CAROLINA 10/04/1983 true   false false false Both Yes 5   4   5   5   5   5   5       3.02923 0.73289 0.86764 1.60053 4.62976 0.05009 2.14448 0.66241 0.30854 3.11543 2.93581 0.83195 1.05841 4.76534 04/11/2019 0 0 0 0 0 0 0 02/23/2018 9 9 0 32 1 0 32 2017-01-12 4 4 0 1 20 0 20 14 0 0 0 0.00 0 0 3801 WADE COBLE DRIVE BURLINGTON, NC 27215 (36.082406, -79.521844) 02/01/2020
14972 14972 1400 W SEMINARY ST RICHLAND CENTER, WI 53581 43.33435 -90.400021 0   525671 SCHMITT WOODLAND HILLS 1400 W SEMINARY ST RICHLAND CENTER WI 53581 6086478931 510 Richland Non profit - Corporation 50 46.8 Medicare and Medicaid false SCHMITT WOODLAND HILLS, INC. 02/25/2004 false   false false false Resident Yes 5   4   5   5   5   4   5       2.49346 0.1927 1.1221 1.31479 3.80825 0.06136 2.06071 0.72804 0.33155 3.1203 2.51478 0.19902 1.27385 3.91365 04/03/2019 0 0 0 0 0 0 0 03/01/2018 1 1 0 8 1 0 8 2017-01-12 5 2 3 1 40 0 40 9.333 2 0 1 2013.00 0 1 1400 W SEMINARY ST RICHLAND CENTER, WI 53581 (43.33435, -90.400021) 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
);