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

41 rows where Rating Cycle 3 Number of Health Revisits = 3

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, 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, 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 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit 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, 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, Rating Cycle 3 Standard Health Survey Date (date)

Rating Cycle 3 Number of Health Revisits ✖

Automatic Sprinkler Systems in All Required Areas ✖

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
217 217 774 LIBERTY ROAD WEST LIBERTY, KY 41472 37.923628 -83.266232 0   185274 WEST LIBERTY NURSING & REHABILITATION 774 LIBERTY ROAD, PO BOX 219 WEST LIBERTY KY 41472 6067433846 861 Morgan For profit - Corporation 48 43.5 Medicare and Medicaid false WEST LIBERTY NURSING AND REHABILITATION LLC 06/17/1991 false   false false false Resident Yes 1   1   1   1   2   4   4       2.35892 0.69254 0.74691 1.43945 3.79837 0.05376 2.13708 0.76449 0.36536 3.26694 2.29408 0.68117 0.76944 3.72829 01/09/2019 8 6 5 72 1 0 72 10/26/2017 8 6 2 32 1 0 32 2016-09-24 19 19 0 3 430 301 731 168.5 1 5 1 8294.00 0 1 774 LIBERTY ROAD WEST LIBERTY, KY 41472 (37.923628, -83.266232) 02/01/2020
782 782 840 EAST ELVA STREET IDAHO FALLS, ID 83401 43.504014 -112.015191 0   135092 GOOD SAMARITAN SOCIETY - IDAHO FALLS VILLAGE 840 EAST ELVA STREET IDAHO FALLS ID 83401 2085234795 90 Bonneville Non profit - Church related 113 39.5 Medicare and Medicaid false THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY 11/01/1981 false   false false false Resident Yes 4   2   5   4   5   4   5       2.04978 0.51749 1.1702 1.68769 3.73747 0.05274 1.98367 0.69332 0.31705 2.99404 2.1476 0.56124 1.38922 4.00288 03/29/2019 8 8 0 36 1 0 36 10/27/2017 11 11 0 100 2 50 150 2016-08-16 13 13 0 3 207 145 352 126.667 0 0 1 6500.00 0 1 840 EAST ELVA STREET IDAHO FALLS, ID 83401 (43.504014, -112.015191) 02/01/2020
1009 1009 12385 Washington Blvd, Whittier, CA 90606, USA 33.9681215 -118.0496663 1 ROOFTOP 55706 THE ORCHARD - POST ACUTE CARE 12385 E. WASHINGTON BLVD WHITTIER CA 90606 5626937701 200 Los Angeles For profit - Individual 162 147.6 Medicare and Medicaid false ENSIGN WHITTIER WEST LLC 12/31/1971 false   false false false Resident Yes 2   1   5   5   4   2   1       2.67455 1.0633 0.27615 1.33945 4.014 0.14744 2.22341 0.75874 0.37615 3.3583 2.50004 1.05377 0.27632 3.83275 12/21/2018 16 13 3 72 1 0 72 12/17/2017 11 10 2 56 1 0 56 2016-11-18 31 25 6 3 220 154 374 117 4 6 0 0.00 0 0   02/01/2020
2060 2060 1150 E MICHIGAN AVE BATTLE CREEK, MI 49014 42.310464 -85.126433 0   235237 CALHOUN COUNTY MEDICAL CARE FACILITY 1150 E MICHIGAN AVE BATTLE CREEK MI 49014 2699625458 120 Calhoun Government - County 120 113.2 Medicare and Medicaid false CALHOUN COUNTY MEDICAL CARE FACILITY 11/01/1974 false   true false false Both Yes 3   2   4   4   4   4   4       2.76318 0.74395 0.68612 1.43007 4.19325 0.04134 2.01974 0.65938 0.29356 2.97268 2.84335 0.84838 0.87971 4.52331 08/07/2019 10 3 7 68 1 0 68 07/20/2018 8 6 3 36 1 0 36 2017-05-11 15 13 7 3 124 87 211 81.167 9 3 1 12500.00 1 2 1150 E MICHIGAN AVE BATTLE CREEK, MI 49014 (42.310464, -85.126433) 02/01/2020
2820 2820 115 HOLLISTON STREET MEDWAY, MA 02053 42.15906 -71.409318 0   225412 MEDWAY COUNTRY MANOR SKILLED NURSING & REHABILITAT 115 HOLLISTON STREET MEDWAY MA 2053 5085336634 130 Norfolk For profit - Corporation 123 107.9 Medicare and Medicaid false MEDWAY COUNTRY MANOR, INC. 07/01/1990 false   false false false Resident Yes 1   1   4   4   4   3   3       1.90909 0.80229 0.5126 1.31489 3.22398 0.06678 2.01344 0.66415 0.29687 2.97446 1.97063 0.90834 0.64989 3.47566 04/24/2019 25 25 0 156 2 78 234 01/26/2018 11 11 0 76 1 0 76 2016-10-26 15 15 0 3 144 101 245 183.167 0 0 1 48223.00 0 1 115 HOLLISTON STREET MEDWAY, MA 02053 (42.15906, -71.409318) 02/01/2020
3116 3116 715 WEST THIRD STREET BOONE, IA 50036 42.059352 -93.902118 0   165468 EASTERN STAR MASONIC HOME 715 WEST THIRD STREET BOONE IA 50036 5154325274 70 Boone Non profit - Corporation 76 72.2 Medicare and Medicaid false EASTERN STAR MASONIC HOME 09/01/2002 true   false false false None Yes 2   1   2   3   2   4   4       3.74187 0.71984 0.62659 1.34643 5.08829 0.02188 2.12245 0.6221 0.28786 3.03241 3.6641 0.87007 0.81928 5.38068 02/28/2019 12 11 1 64 1 0 64 11/09/2017 5 5 0 24 1 0 24 2016-09-19 13 8 5 3 80 56 136 62.667 1 4 0 0.00 0 0 715 WEST THIRD STREET BOONE, IA 50036 (42.059352, -93.902118) 02/01/2020
3893 3893 2438 FOUNTAIN BLVD COLORADO SPRINGS, CO 80910 38.817358 -104.784198 0   65172 TERRACE GARDENS HEALTH CARE CENTER 2438 FOUNTAIN BLVD COLORADO SPRINGS CO 80910 7194738000 200 El Paso For profit - Corporation 90 64 Medicare and Medicaid false SSC COLORADO SPRINGS TERRACE GARDENS OPERATING COMPANY LLC 01/06/1983 false   false false false Resident Yes 2   1   5   5     2 4   4       2.30984 0.69098 0.81552 1.5065 3.81634 0.0651 1.87729 0.73802 0.37184 2.98715 2.55722 0.70402 0.82548 4.09679 07/24/2019 11 10 1 64 1 0 64 05/07/2018 13 11 2 48 1 0 48 2016-11-23 39 33 6 3 284 199 483 128.5 1 11 0 0.00 0 0 2438 FOUNTAIN BLVD COLORADO SPRINGS, CO 80910 (38.817358, -104.784198) 02/01/2020
4081 4081 235 WEST AIRPORT BLVD PENSACOLA, FL 32505 30.472201 -87.252707 0   105935 CONSULATE HEALTH CARE OF PENSACOLA 235 WEST AIRPORT BLVD PENSACOLA FL 32505 8508575200 160 Escambia For profit - Corporation 120 111.7 Medicare and Medicaid false PENSACOLA FACILITY OPERATIONS LLC 01/08/1997 false   false false false Resident Yes 2   2   2   2   2   3   3       2.59544 0.7774 0.55725 1.33465 3.93009 0.04963 1.92775 0.69672 0.33376 2.95823 2.79818 0.83901 0.62843 4.26014 10/25/2019 7 6 1 28 1 0 28 10/05/2018 13 11 2 68 1 0 68 2017-07-21 7 4 3 3 40 28 68 48 2 5 2 53739.00 1 3 235 WEST AIRPORT BLVD PENSACOLA, FL 32505 (30.472201, -87.252707) 02/01/2020
4102 4102 405 WEST SEVENTH STREET SILVERTON, ID 83867 46.728753 -117.009503 0   135058 GOOD SAMARITAN SOCIETY - SILVER WOOD VILLAGE 405 WEST SEVENTH STREET SILVERTON ID 83867 2085561147 390 Shoshone Non profit - Church related 50 40.8 Medicare and Medicaid false THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY 10/01/1974 false   false false false Resident Yes 1   1   3   1   4   1 12 1 12     1.73907 0.8895 0.42075 1.31025 3.04932 0.08146 1.91174 0.63929 0.2838 2.83482 1.89062 1.04624 0.55802 3.4493 10/12/2018 15 15 0 120 1 0 120 05/22/2017 15 15 0 237 2 119 356 2016-06-24 16 16 0 3 128 90 218 215 0 0 2 66009.00 1 3 405 WEST SEVENTH STREET SILVERTON, ID 83867 (46.728753, -117.009503) 02/01/2020
5026 5026 320 COLLINS ROAD BOISE, ID 83702 43.618128 -116.18943 0   135131 IDAHO STATE VETERANS HOME - BOISE 320 COLLINS ROAD BOISE ID 83702 2087801600 0 Ada Government - State 122 110.8 Medicare and Medicaid false DIVISION OF VETERANS SERVICES 09/01/2007 false   false false false Both Yes 4   2   5   5     2 5   5       2.3784 0.63174 0.82777 1.45951 3.83791 0.01974 1.92604 0.63654 0.25026 2.81284 2.56647 0.74627 1.24495 4.37526 11/09/2018 12 12 5 96 1 0 96 02/24/2017 9 9 0 32 1 0 32 2016-01-22 5 5 0 3 207 145 352 117.333 0 2 1 23433.00 0 1 320 COLLINS ROAD BOISE, ID 83702 (43.618128, -116.18943) 02/01/2020
5221 5221 930 MILL HILL TERRACE SOUTHPORT, CT 06890 41.14438 -73.286615 0   75200 REGALCARE AT SOUTHPORT 930 MILL HILL TERRACE SOUTHPORT CT 6890 2032597894 0 Fairfield For profit - Partnership 120 108.2 Medicare and Medicaid false FAIRVIEW HEALTH OF SOUTHPORT LLC 06/01/1977 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.04457 0.9491 0.43656 1.38566 3.43023 0.04559 1.79219 0.67576 0.32482 2.79277 2.37101 1.0561 0.50587 3.9386 06/12/2019 8 5 3 32 1 0 32 11/30/2018 17 16 9 162 1 0 162 2018-05-24 52 19 50 3 625 438 1063 247.167 8 9 4 27108.00 1 5 930 MILL HILL TERRACE SOUTHPORT, CT 06890 (41.14438, -73.286615) 02/01/2020
5394 5394 103 W Wallace St, Ashley, MI 48806, USA 43.1829375 -84.4758131 1 ROOFTOP 235532 ASHLEY CARE CENTER 103 EAST WALLACE STREET ASHLEY MI 48806 9898472011 280 Gratiot For profit - Limited Liability company 63 50.1 Medicare and Medicaid false ORCHARD LAKE INVESTMENTS ASSOCIATES, LLC 12/09/1992 false   false false false Resident Yes 3   2   2   2   2   5   5       3.20858 0.31993 0.92944 1.24937 4.45795 0 1.95606 0.67677 0.32547 2.9583 3.40916 0.35547 1.07483 4.83222 11/08/2019 21 21 0 132 0 0 132 02/15/2019 12 10 2 64 2 32 96 2018-02-01 9 9 0 3 40 28 68 109.333 2 0 1 13211.00 1 2   02/01/2020
5419 5419 14857 ROSCOE BOULEVARD PANORAMA CITY, CA 91402 34.221491 -118.457143 0   56137 THE MEADOWS POST ACUTE 14857 ROSCOE BOULEVARD PANORAMA CITY CA 91402 8188945707 200 Los Angeles For profit - Partnership 98 92.6 Medicare and Medicaid false PANORAMA MEADOWS NURSING CENTER LP 11/20/1969 false   false false false Resident Yes 1   1   4   5   4   2   2       2.4548 0.95194 0.5257 1.47765 3.93245 0.06633 2.07292 0.80481 0.40352 3.28125 2.46121 0.88941 0.49035 3.84306 03/26/2019 17 16 1 96 1 0 96 04/11/2018 22 14 8 104 1 0 104 2017-04-30 27 21 6 3 148 104 252 124.667 5 11 1 24851.00 1 2 14857 ROSCOE BOULEVARD PANORAMA CITY, CA 91402 (34.221491, -118.457143) 02/01/2020
5431 5431 1843 N HAGADORN RD EAST LANSING, MI 48823 42.754639 -84.462384 0   235283 MEDILODGE OF EAST LANSING 1843 N HAGADORN RD EAST LANSING MI 48823 5173325061 320 Ingham For profit - Individual 95 74.7 Medicare and Medicaid false NORTH LANSING OPCO LLC 04/06/1976 false   true false false Resident Yes 2   1   5   5   3   3   3       2.79968 0.872 1.27977 2.15177 4.95145 0.0345 2.13665 0.79483 0.67593 3.60741 2.72326 0.82495 0.71263 4.40139 10/30/2019 22 8 14 267 1 0 267 08/09/2018 23 9 14 172 1 0 172 2017-06-08 18 14 7 3 112 78 190 222.5 8 21 3 148658.00 2 5 1843 N HAGADORN RD EAST LANSING, MI 48823 (42.754639, -84.462384) 02/01/2020
5772 5772 11400 HIDDEN LAKE DRIVE RAYTOWN, MO 64133 39.028376 -94.445849 0   265510 HIDDEN LAKE CARE CENTER 11400 HIDDEN LAKE DRIVE RAYTOWN MO 64133 8167371010 470 Jackson For profit - Corporation 112 86 Medicare and Medicaid false HIDDEN LAKE MANAGEMENT LLC 11/01/1992 false   false false false Resident Yes 1   1   4   5   3   3   2       2.82995 0.94225 0.38389 1.32614 4.15609 0.02216 1.89938 0.6769 0.29237 2.86865 3.09658 1.04671 0.4942 4.6458 03/22/2019 17 17 0 96 2 48 144 10/18/2018 17 16 1 112 2 56 168 2018-03-14 21 19 2 3 128 90 218 164.333 0 3 0 0.00 1 1 11400 HIDDEN LAKE DRIVE RAYTOWN, MO 64133 (39.028376, -94.445849) 02/01/2020
6107 6107 110 W NORTH STREET GEORGETOWN, DE 19947 38.692618 -75.396229 0   85029 HARRISON SENIOR LIVING OF GEORGETOWN, LLC 110 W. NORTH STREET GEORGETOWN DE 19947 3028564574 20 Sussex For profit - Partnership 139 128.8 Medicare and Medicaid false HARRISON SENIOR LIVING OF GEORGETOWN, LLC 07/22/1985 false   false false false Both Yes 3   2   3   2   4   4   4       2.33215 0.8631 0.69368 1.55679 3.88894 0.07927 2.00001 0.68442 0.30594 2.99037 2.42348 0.94826 0.8534 4.17022 05/21/2019 25 24 1 132 1 0 132 07/18/2018 11 11 2 68 1 0 68 2017-05-11 16 15 4 3 92 64 156 114.667 6 2 3 124116.00 1 4 110 W NORTH STREET GEORGETOWN, DE 19947 (38.692618, -75.396229) 02/01/2020
6333 6333 2350 TAFT ST GARY, IN 46404 41.576047 -87.365831 0   155580 APERION CARE TOLLESTON PARK 2350 TAFT ST GARY IN 46404 2199772600 440 Lake Government - City/county 180 110.9 Medicare and Medicaid false MAJOR HOSPITAL 10/25/1995 false   false false false Both Yes 1   1   1   2   1   1 12 1 12     1.62014 1.05211 0.2156 1.26771 2.88785 0.04704 2.23465 0.8599 0.45628 3.55083 1.50681 0.92002 0.17785 2.60794 01/28/2019 36 31 8 176 1 0 176 04/17/2018 26 24 2 116 2 58 174 2017-03-17 24 12 12 3 132 92 224 183.333 0 38 0 0.00 1 1 2350 TAFT ST GARY, IN 46404 (41.576047, -87.365831) 02/01/2020
6506 6506 2810 SECOND AVENUE NORTH MOORHEAD, MN 56560 46.876749 -96.735406 0   245052 MOORHEAD REHABILITATION & HEALTHCARE CENTER 2810 SECOND AVENUE NORTH MOORHEAD MN 56560 2182337578 130 Clay For profit - Corporation 78 51 Medicare and Medicaid false MOORHEAD OPERATIONS LLC 03/01/1979 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.57162 0.96551 0.73195 1.69745 4.26908 0.05614 1.92306 0.71537 0.33668 2.97511 2.77927 1.01486 0.81827 4.60134 11/07/2019 13 0 13 68 1 0 68 11/09/2018 18 11 14 211 2 106 317 2018-03-13 41 34 9 3 407 285 692 255 9 14 0 0.00 2 2 2810 SECOND AVENUE NORTH MOORHEAD, MN 56560 (46.876749, -96.735406) 02/01/2020
7049 7049 650 NORTH KINZIE BRADLEY, IL 60915 41.152212 -87.851103 0   146112 APERION CARE BRADLEY 650 NORTH KINZIE BRADLEY IL 60915 8159331666 540 Kankakee For profit - Corporation 120 68 Medicare and Medicaid false APERION CARE BRADLEY LLC 07/01/2007 false SFF false false true Resident Yes   18   18   18   18   18   18   18     1.55234 0.88539 0.35048 1.23587 2.78821 0.01014 2.20292 0.74243 0.33491 3.28025 1.46456 0.89673 0.39388 2.72566 10/10/2019 18 6 12 148 1 0 148 05/17/2019 33 13 20 276 1 0 276 2018-04-03 20 14 11 3 176 123 299 215.833 1 41 4 129109.00 2 6 650 NORTH KINZIE BRADLEY, IL 60915 (41.152212, -87.851103) 02/01/2020
7460 7460 210 WEST LACROSSE AVENUE COEUR D'ALENE, ID 83814 47.689885 -116.786923 0   135042 LACROSSE HEALTH & REHABILITATION CENTER 210 WEST LACROSSE AVENUE COEUR D'ALENE ID 83814 2086642185 270 Kootenai For profit - Limited Liability company 100 77 Medicare and Medicaid false LACROSSE HEALTH - COEUR D'ALENE, LLC 12/13/1967 false   false false false Resident Yes 1   1   2   2   2   3   2       2.5497 1.24368 0.74513 1.98881 4.53851 0.07491 2.10016 0.81865 0.60224 3.52105 2.5232 1.14235 0.46568 4.13328 06/21/2019 6 6 0 52 1 0 52 04/20/2018 12 11 3 52 1 0 52 2016-11-07 26 18 8 3 405 284 689 158.167 3 7 0 0.00 0 0 210 WEST LACROSSE AVENUE COEUR D'ALENE, ID 83814 (47.689885, -116.786923) 02/01/2020
8000 8000 1131 SOUTH MABELLE AVENUE FERGUS FALLS, MN 56537 46.271684 -96.061168 0   245463 PIONEER CARE CENTER 1131 SOUTH MABELLE AVENUE FERGUS FALLS MN 56537 2189981500 550 Otter Tail Non profit - Corporation 105 97.1 Medicare and Medicaid false PIONEER HOME INCORPORATED 04/11/1987 false   false false false Both Yes 3   2   4   4   4   4   4       2.80416 0.39994 0.84234 1.24228 4.04644 0.05151 2.07423 0.66904 0.30854 3.0518 2.80971 0.44949 1.02758 4.25177 11/21/2019 1 0 1 4 1 0 4 01/31/2019 9 9 4 72 1 0 72 2018-03-22 7 6 3 3 165 116 281 72.833 14 0 2 32006.00 1 3 1131 SOUTH MABELLE AVENUE FERGUS FALLS, MN 56537 (46.271684, -96.061168) 02/01/2020
8060 8060 5522 Gracewood Ave, Arcadia, CA 91007, USA 34.1020886 -118.0452298 1 ROOFTOP 55293 SANTA ANITA CONVALESCENT HOSP 5522 GRACEWOOD AVE. TEMPLE CITY CA 91780 6265790310 200 Los Angeles For profit - Limited Liability company 391 357.6 Medicare and Medicaid false SANTA ANITA CONVALESCENT HOSPITAL & RETIREMENT CENTER INC 04/01/1974 true SFF Candidate false false false Both Yes 2   1   5   5   4   3   2       2.41973 1.20804 0.34311 1.55115 3.97088 0.04804 2.09018 0.70867 0.31447 3.11331 2.40603 1.28181 0.41066 4.08994 09/26/2019 31 22 9 136 1 0 136 10/02/2018 37 29 9 611 1 0 611 2017-11-09 38 27 13 3 232 162 394 337.333 18 16 2 134693.00 1 3   02/01/2020
8517 8517 1035 W BEVERLY BLVD MONTEBELLO, CA 90640 34.017925 -118.109747 0   55153 MONTEBELLO CARE CENTER 1035 W BEVERLY BLVD MONTEBELLO CA 90640 3237241315 200 Los Angeles For profit - Corporation 99 94.9 Medicare and Medicaid false MONTEBELLO CARE CENTER LLC 04/01/1969 false   true false false Resident Yes 1   1   4   5   3   2   2       2.31167 1.02572 0.43425 1.45998 3.77165 0.12572 2.33273 0.74864 0.35868 3.44005 2.05958 1.03024 0.45569 3.51576 12/20/2019 22 16 6 124 1 0 124 12/10/2018 27 17 11 148 1 0 148 2017-11-18 31 20 11 3 184 129 313 163.5 22 12 2 35126.00 1 3 1035 W BEVERLY BLVD MONTEBELLO, CA 90640 (34.017925, -118.109747) 02/01/2020
8943 8943 109 S ATWOOD AVENUE JANESVILLE, WI 53545 42.683214 -89.016453 0   525639 ST ELIZABETH NURSING HOME 109 S ATWOOD AVENUE JANESVILLE WI 53545 6087526709 520 Rock Non profit - Corporation 43 35.3 Medicare and Medicaid false SISTERS OF CHARITY OF OUR LADY MOTHER OF THE CHURCH 02/01/1998 false   false false false Resident Yes 2   1   3   3   2   4   5       2.1506 0.20484 1.05026 1.2551 3.4057 0.01616 1.85835 0.68266 0.31543 2.85644 2.40518 0.22563 1.25322 3.82327 07/31/2019 10 7 3 52 1 0 52 10/02/2018 7 6 2 60 1 0 60 2017-06-26 9 9 1 3 135 95 230 84.333 0 7 1 76482.00 1 2 109 S ATWOOD AVENUE JANESVILLE, WI 53545 (42.683214, -89.016453) 02/01/2020
10248 10248 18740 W BLUEMOUND RD BROOKFIELD, WI 53045 43.03639 -88.144456 0   525424 BROOKFIELD REHAB AND SPECIALTY CARE CTR 18740 W BLUEMOUND RD BROOKFIELD WI 53045 2627820230 660 Waukesha For profit - Corporation 224 124.9 Medicare and Medicaid false Legal Business Name Not Available 05/01/1989 false   false false false Resident Yes 1   1   4   4   4   3   3       2.52964 0.90622 0.463 1.36922 3.89886 0.06937 2.11557 0.7131 0.31385 3.14252 2.48512 0.95558 0.55525 3.97844 12/17/2019 7 2 5 32 1 0 32 10/16/2018 17 11 6 279 1 0 279 2017-09-28 27 25 13 3 319 223 542 199.333 3 15 2 150976.00 1 3 18740 W BLUEMOUND RD BROOKFIELD, WI 53045 (43.03639, -88.144456) 02/01/2020
10293 10293 227 SAND HILL ROAD GREENSBURG, PA 15601 40.281466 -79.448707 0   395500 TWIN LAKES REHABILITATION AND HEALTHCARE CENTER 227 SAND HILL ROAD GREENSBURG PA 15601 7248376482 770 Westmoreland For profit - Corporation 137 92.2 Medicare and Medicaid false WESTMORLAND CENTER OPCO LLC 03/20/1981 false SFF false false false Resident Yes   18   18   18   18   18   18   18     1.89482 0.82432 0.99686 1.82118 3.716 0.06676 2.15133 0.92029 0.64262 3.71425 1.83053 0.67353 0.58386 3.20817 08/08/2019 34 24 10 192 2 96 288 02/13/2019 43 24 20 248 1 0 248 2018-05-11 37 18 23 3 200 140 340 283.333 3 12 3 239612.00 1 4 227 SAND HILL ROAD GREENSBURG, PA 15601 (40.281466, -79.448707) 02/01/2020
10365 10365 600 WALDEN ROAD ABINGDON, VA 24210 36.72047 -81.960216 0   495338 GRACE HEALTHCARE OF ABINGDON 600 WALDEN ROAD ABINGDON VA 24210 2766285137 950 Washington For profit - Corporation 119 84.7 Medicare and Medicaid false CEDAR LAWN INVESTMENTS, LLC 07/01/1999 false   false false false Resident Yes 2   2   2   3   1   3   3       1.91934 1.24986 0.51143 1.76129 3.68064 0.0435 2.07391 0.73209 0.36359 3.1696 1.92344 1.28375 0.52942 3.72368 05/02/2019 14 11 4 76 1 0 76 02/08/2018 14 14 0 64 1 0 64 2016-11-10 20 20 0 3 104 73 177 88.833 0 0 0 0.00 0 0 600 WALDEN ROAD ABINGDON, VA 24210 (36.72047, -81.960216) 02/01/2020
10615 10615 120 CORNING AVENUE MILPITAS, CA 95035 37.42452 -121.907813 0   555757 MILPITAS CARE CENTER 120 CORNING AVENUE MILPITAS CA 95035 4082620217 530 Santa Clara For profit - Corporation 35 33.5 Medicare and Medicaid false UNITED FAMILY MEDICAL SUPPLY, INC. 06/27/2000 false   false false false None Yes 3   2   5   5   5   2   2       2.42999 0.66342 0.3672 1.03062 3.46061 0 2.01296 0.69764 0.30175 3.01236 2.5089 0.71505 0.45802 3.68382 06/19/2019 17 16 1 112 1 0 112 08/16/2018 8 5 3 28 1 0 28 2017-08-03 9 8 1 3 60 42 102 82.333 5 0 1 37461.00 0 1 120 CORNING AVENUE MILPITAS, CA 95035 (37.42452, -121.907813) 02/01/2020
10676 10676 752 E CENTER AVENUE MOORESVILLE, NC 28115 35.578278 -80.798172 0   345179 ACCORDIUS HEALTH AT MOORESVILLE 752 E CENTER AVENUE MOORESVILLE NC 28115 7048000570 480 Iredell For profit - Corporation 131 59.9 Medicare and Medicaid false ACCORDIUS HEALTH AT MOORESVILLE LLC 05/01/1978 false   false false false Resident Yes 1   1   3   3   3   2   2       1.91196 0.9275 0.40601 1.33351 3.24547 0.06067 2.12554 0.82417 0.45122 3.40093 1.8695 0.84622 0.33867 3.06008 05/23/2019 4 2 2 24 1 0 24 06/08/2018 4 4 0 24 1 0 24 2017-07-14 25 23 25 3 220 154 374 82.333 0 15 2 30082.00 0 2 752 E CENTER AVENUE MOORESVILLE, NC 28115 (35.578278, -80.798172) 02/01/2020
11977 11977 2000 WESTWOOD ROAD VISTA, CA 92083 33.192172 -117.286377 0   555425 VISTA KNOLL SPECIALIZED CARE FACILITY 2000 WESTWOOD ROAD VISTA CA 92083 7606302273 470 San Diego For profit - Limited Liability company 119 112.6 Medicare and Medicaid false VISTA WOODS HEALTH ASSOCIATES, LLC 05/30/1990 false   false false false Resident Yes 4   3   5   5   5   3   3       2.22742 0.96176 0.53723 1.49899 3.72641 0.08578 1.87539 0.69883 0.32777 2.90199 2.46846 1.03485 0.61691 4.11763 03/04/2019 10 10 0 52 1 0 52 03/08/2018 12 7 5 56 1 0 56 2016-12-12 13 10 3 3 84 59 143 68.5 2 11 0 0.00 0 0 2000 WESTWOOD ROAD VISTA, CA 92083 (33.192172, -117.286377) 02/01/2020
12463 12463 2309 STAFFORD AVENUE SCRANTON, PA 18505 41.380332 -75.670642 0   395881 MOUNTAIN VIEW CARE AND REHABILITATION CENTER 2309 STAFFORD AVENUE SCRANTON PA 18505 5703410050 420 Lackawanna For profit - Corporation 180 156.6 Medicare and Medicaid false MOUNTAIN VIEW CARE AND REHABILITATION CENTER, LLC 11/05/1992 false SFF Candidate true false false Resident Yes 1   1   3   5   2   2   2       2.55584 1.10229 0.47507 1.57736 4.1332 0.11131 2.23831 0.8339 0.43482 3.50702 2.37318 0.99395 0.41123 3.77921 07/19/2019 30 17 13 212 1 0 212 06/15/2018 37 24 17 244 2 122 366 2017-05-12 14 10 7 3 104 73 177 257.5 6 25 1 13905.00 3 4 2309 STAFFORD AVENUE SCRANTON, PA 18505 (41.380332, -75.670642) 02/01/2020
12482 12482 9200 GLENWATER DRIVE CHARLOTTE, NC 28262 35.316782 -80.750553 0   345142 UNIVERSITY PLACE NURSING AND REHABILITATION CENTER 9200 GLENWATER DRIVE CHARLOTTE NC 28262 7045490807 590 Mecklenburg For profit - Corporation 207 150.9 Medicare and Medicaid false GRANITE FALLS LTC, LLC 07/01/1974 false   false false false Resident Yes 1   1   2   2   3   1   1       1.78335 0.83616 0.30258 1.13874 2.92208 0.06657 1.97092 0.74398 0.37276 3.08765 1.88054 0.84511 0.30552 3.03471 11/17/2018 13 8 6 139 1 0 139 01/12/2018 7 7 1 32 1 0 32 2016-11-03 15 10 5 3 295 207 502 163.833 0 9 0 0.00 0 0 9200 GLENWATER DRIVE CHARLOTTE, NC 28262 (35.316782, -80.750553) 02/01/2020
13200 13200 500 NORTH DAWSON STREET MEEKER, OK 74855 35.509828 -96.894428 0   375326 MEEKER NURSING CENTER 500 NORTH DAWSON STREET MEEKER OK 74855 4052793521 400 Lincoln For profit - Corporation 70 54.8 Medicare and Medicaid false MEEKER NORTH DAWSON NURSING LLC 01/05/1998 false   false false false Both Yes 1   1   1   2   1   2   2       2.3962 0.7385 0.36847 1.10697 3.50317 0.00123 1.99106 0.61924 0.28847 2.89876 2.50124 0.89676 0.48077 3.87527 10/09/2018 12 8 4 100 1 0 100 07/19/2017 12 10 12 120 1 0 120 2016-04-28 15 15 0 3 132 92 224 127.333 0 3 0 0.00 1 1 500 NORTH DAWSON STREET MEEKER, OK 74855 (35.509828, -96.894428) 02/01/2020
13512 13512 1100 WEST LONG AVENUE DUBOIS, PA 15801 41.126592 -78.784768 0   395460 CHRIST THE KING MANOR 1100 WEST LONG AVENUE DUBOIS PA 15801 8143713180 230 Clearfield Non profit - Church related 160 153.1 Medicare and Medicaid false CHRIST THE KING MANOR, INC. 04/01/1980 true   false false false Resident Yes 1   1   4   4   4   2   2       2.73844 1.0617 0.45584 1.51754 4.25598 0.03837 2.31738 0.80621 0.41694 3.54053 2.45596 0.99023 0.4115 3.85464 10/03/2019 22 18 4 104 1 0 104 11/01/2018 21 15 6 96 1 0 96 2017-10-19 17 11 6 3 136 95 231 122.5 1 13 0 0.00 1 1 1100 WEST LONG AVENUE DUBOIS, PA 15801 (41.126592, -78.784768) 02/01/2020
13883 13883 500 WEST LAUREL STREET FRACKVILLE, PA 17931 40.777411 -76.235921 0   395286 BROAD MOUNTAIN HEALTH AND REHABILITATION CENTER 500 WEST LAUREL STREET FRACKVILLE PA 17931 5708740696 650 Schuylkill For profit - Corporation 129 99 Medicare and Medicaid false BROAD MOUNTAIN HEALTH & REHABILITATION CENTER LLC 10/29/1970 false   false false false Resident Yes 2   2   3   4   3   2   2       1.95343 0.73853 0.56207 1.3006 3.25403 0.05686 2.16057 0.82531 0.42559 3.41147 1.87908 0.67287 0.49708 3.05867 07/12/2019 15 14 1 72 1 0 72 06/07/2018 4 4 0 16 1 0 16 2017-07-21 18 16 7 3 112 78 190 73 1 2 1 11605.00 1 2 500 WEST LAUREL STREET FRACKVILLE, PA 17931 (40.777411, -76.235921) 02/01/2020
14153 14153 8425 IOWA STREET DOWNEY, CA 90241 33.93653 -118.132281 0   555128 DOWNEY COMMUNITY HEALTH CENTER 8425 IOWA STREET DOWNEY CA 90241 5628626506 200 Los Angeles For profit - Partnership 198 189.2 Medicare and Medicaid false WDW JOINT VENTURE 03/25/1980 false   false false false Resident Yes 1   1   3   5   1   3   2       2.38388 1.15845 0.3585 1.51695 3.90082 0.06162 1.88018 0.69383 0.32081 2.89482 2.63512 1.25547 0.4206 4.32103 12/28/2018 21 20 1 128 1 0 128 01/08/2018 29 20 9 204 1 0 204 2016-12-19 34 25 9 3 208 146 354 191 9 21 1 5000.00 0 1 8425 IOWA STREET DOWNEY, CA 90241 (33.93653, -118.132281) 02/01/2020
14843 14843 3434 KENTUCKY PLACE BARTLESVILLE, OK 74006 36.754319 -95.939462 0   375110 BARTLESVILLE HEALTH AND REHABILITATION COMMUNITY 3434 KENTUCKY PLACE BARTLESVILLE OK 74006 9183339545 730 Washington For profit - Corporation 119 73.3 Medicare and Medicaid false BARTLESVILLE CARE CENTER INC. 04/01/1991 false   false false false Resident Yes 1   1   2   1   3   2   1       2.74037 0.96754 0.14006 1.1076 3.84797 0.00545 2.05288 0.64824 0.28636 2.98748 2.77434 1.12232 0.18409 4.13028 12/04/2018 6 5 1 88 1 0 88 09/27/2017 14 14 0 253 1 0 253 2016-06-30 8 8 0 3 60 42 102 145.333 0 1 2 39045.00 0 2 3434 KENTUCKY PLACE BARTLESVILLE, OK 74006 (36.754319, -95.939462) 02/01/2020
14865 14865 1785 SOUTH HAYES STREET ARLINGTON, VA 22202 38.857604 -77.057513 0   495114 REGENCY CARE OF ARLINGTON, LLC 1785 SOUTH HAYES STREET ARLINGTON VA 22202 7039205700 60 Arlington For profit - Individual 240 175.8 Medicare and Medicaid false REGENCY CARE OF ARLINGTON LLC 10/23/1978 false   false false false Resident Yes 1   1   3   3   3   2   2       1.8038 0.97813 0.33069 1.30883 3.11263 0.05741 2.12368 0.77858 0.37453 3.2768 1.76528 0.94466 0.33233 3.04601 11/01/2018 20 18 8 124 2 62 186 09/20/2017 9 8 1 36 1 0 36 2016-08-04 15 13 2 3 88 62 150 130 0 12 1 11443.00 0 1 1785 SOUTH HAYES STREET ARLINGTON, VA 22202 (38.857604, -77.057513) 02/01/2020
15217 15217 1335 PORTLAND AVE ROCHESTER, NY 14621 43.190481 -77.584295 0   335439 NEW ROC NURSING AND REHABILITATION CENTER 1335 PORTLAND AVE ROCHESTER NY 14621 5855444000 370 Monroe For profit - Corporation 120 109.3 Medicare and Medicaid false BLOSSOM NORTH, LLC 01/01/1975 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.32042 1.00843 0.5933 1.60173 3.92215 0.09136 1.90736 0.84364 0.46094 3.21194 2.52842 0.89882 0.48446 3.9157 12/16/2019 6 6 0 24 0 0 24 05/30/2019 16 11 5 84 2 42 126 2018-06-06 26 25 6 3 306 214 520 140.667 1 17 1 55594.00 0 1 1335 PORTLAND AVE ROCHESTER, NY 14621 (43.190481, -77.584295) 02/01/2020
15273 15273 1520 HAWTHORNE AVENUE COLUMBUS, OH 43203 39.970277 -82.960678 0   366207 ISABELLE RIDGWAY POST ACUTE CARE CAMPUS LLC 1520 HAWTHORNE AVENUE COLUMBUS OH 43203 6142524931 250 Franklin For profit - Corporation 96 33.1 Medicare and Medicaid false ISABELLE RIDGWAY POST ACUTE CARE CAMPUS LLC 12/19/2000 false   false false false Resident Yes 1   1   4   4     2 1 12 1 12     1.81333 1.23616 0.44404 1.6802 3.49353 0 2.0284 0.8015 0.39261 3.22251 1.85797 1.15973 0.42569 3.47635 12/05/2019 12 7 6 80 0 0 80 07/11/2019 31 5 26 172 1 0 172 2019-01-31 43 17 30 3 252 176 428 168.667 0 46 2 203436.00 2 4 1520 HAWTHORNE AVENUE COLUMBUS, OH 43203 (39.970277, -82.960678) 02/01/2020
15431 15431 8951 GRANITE HILL DRIVE RIVERSIDE, CA 92509 34.020188 -117.479809 0   555884 RIVERSIDE HEIGHTS HEALTHCARE CENTER, LLC 8951 GRANITE HILL DRIVE RIVERSIDE CA 92509 9516857474 430 Riverside For profit - Limited Liability company 70 64.8 Medicare and Medicaid false RIVERSIDE HEIGHTS HEALTHCARE CENTER LLC 07/08/2013 false   false false false Resident Yes 2   2   4   4   4   3   2       2.48767 1.12235 0.28343 1.40578 3.89345 0.0836 1.79714 0.64308 0.3033 2.74352 2.87692 1.31233 0.35173 4.55071 04/11/2019 11 5 6 64 1 0 64 11/01/2018 26 8 18 144 1 0 144 2018-04-17 17 10 8 3 92 64 156 106 9 23 1 155711.00 0 1 8951 GRANITE HILL DRIVE RIVERSIDE, CA 92509 (34.020188, -117.479809) 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
);