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 Total Number of Penalties = 6

✎ 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, Legal Business Name, Date First Approved to Provide Medicare and Medicaid services, 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, 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 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, Number of Payment Denials, Location, Rating Cycle 3 Standard Health Survey Date (date)

Total Number of Penalties ✖

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
726 726 555 WEST CARPENTER SPRINGFIELD, IL 62702 39.807588 -89.662793 0   145160 APERION CARE CAPITOL 555 WEST CARPENTER SPRINGFIELD IL 62702 2175251880 920 Sangamon For profit - Corporation 251 92.6 Medicare and Medicaid false APERION CARE CAPITOL LLC 05/23/1969 false SFF false false false Resident Yes   18   18   18   18   18   18   18     1.68655 0.86113 0.19506 1.05618 2.74274 0.0384 1.98797 0.83678 0.44386 3.26862 1.76321 0.77382 0.1654 2.69075 08/30/2019 39 18 33 248 1 0 248 04/12/2019 45 14 45 432 1 0 432 2018-07-16 16 12 4 1 96 0 96 284 2 48 6 229677.00 0 6 555 WEST CARPENTER SPRINGFIELD, IL 62702 (39.807588, -89.662793) 02/01/2020
1067 1067 11941 BELSAY RD GRAND BLANC, MI 48439 42.930115 -83.596686 0   235226 MEDILODGE OF GRAND BLANC 11941 BELSAY RD GRAND BLANC MI 48439 8106941970 240 Genesee For profit - Corporation 161 95.9 Medicare and Medicaid false GRAND BLANC OPCO, LLC 10/01/1973 false SFF false false false Resident Yes   18   18   18   18   18   18   18     3.49649 1.6363 0.9755 2.6118 6.10829 0.02216 2.26549 0.86337 0.89593 4.02479 3.20765 1.42511 0.40981 4.86665 11/08/2019 19 13 6 136 0 0 136 05/16/2019 36 15 22 264 1 0 264 2018-03-22 26 16 14 2 204 102 306 207 3 72 4 147766.00 2 6 11941 BELSAY RD GRAND BLANC, MI 48439 (42.930115, -83.596686) 02/01/2020
1521 1521 14151 E 15 MILE RD STERLING HEIGHTS, MI 48312 42.552546 -82.981815 0   235263 MEDILODGE OF STERLING HEIGHTS 14151 E 15 MILE RD STERLING HEIGHTS MI 48312 5869390200 490 Macomb For profit - Limited Liability company 283 242.5 Medicare and Medicaid false STERLING HEIGHTS OPCO LLC 05/01/1976 false   false false false Resident Yes 1   1   3   4   3   3   3       1.86467 0.90056 0.4366 1.33716 3.20183 0.03654 1.96302 0.66726 0.30712 2.9374 1.97421 1.01485 0.53507 3.49533 08/22/2019 38 20 21 367 1 0 367 09/21/2018 14 6 9 128 1 0 128 2017-07-26 43 18 33 2 514 257 771 354.667 19 89 5 273521.00 1 6 14151 E 15 MILE RD STERLING HEIGHTS, MI 48312 (42.552546, -82.981815) 02/01/2020
2176 2176 11515 TROOST KANSAS CITY, MO 64131 38.917376 -94.579319 0   265822 BRIDGEWOOD HEALTH CARE CENTER 11515 TROOST KANSAS CITY MO 64131 8169430101 470 Jackson For profit - Individual 166 161 Medicare and Medicaid false BRIDGEWOOD HEALTH CARE CENTER LLC 08/28/2008 false   false false false Resident Yes 2   1   5   5   5   1   1       1.45765 0.41948 0.17186 0.59134 2.04899 0 1.42344 0.55851 0.24128 2.22323 2.12828 0.56476 0.26809 2.95534 03/22/2019 13 13 2 131 1 0 131 05/30/2018 17 14 6 195 1 0 195 2017-03-20 11 11 0 1 72 0 72 142.5 5 11 3 701429.00 3 6 11515 TROOST KANSAS CITY, MO 64131 (38.917376, -94.579319) 02/01/2020
3052 3052 1561 COLD SPRING ROAD WILLIAMSTOWN, MA 01267 42.677742 -73.234834 0   225189 SWEET BROOK OF WILLIAMSTOWN REHABILITATION & N CTR 1561 COLD SPRING ROAD WILLIAMSTOWN MA 1267 4134588127 10 Berkshire For profit - Corporation 146 67.1 Medicare and Medicaid false SB OPERATING COMPANY LLC 07/29/1969 false SFF true false false Resident Yes   18   18   18   18   18   18   18     2.70451 0.83223 0.53277 1.365 4.0695 0.0463 1.85523 0.61098 0.27829 2.7445 3.02974 1.02423 0.72057 4.75478 06/18/2019 42 31 11 610 3 427 1037 03/15/2018 18 17 2 88 1 0 88 2017-02-01 29 11 18 1 618 0 618 650.833 6 8 3 359765.00 3 6 1561 COLD SPRING ROAD WILLIAMSTOWN, MA 01267 (42.677742, -73.234834) 02/01/2020
3363 3363 911 S 3RD ST NILES, MI 49120 41.819191 -86.251737 0   235361 CHALET OF NILES, LLC 911 S 3RD ST NILES MI 49120 2696844320 100 Berrien For profit - Individual 100 54.6 Medicare and Medicaid false CHALET OF NILES LLC 07/01/1978 false   false false false Resident Yes 2   2   4   5   3   2   2       1.49935 0.84183 0.33979 1.18161 2.68097 0.02973 2.03126 0.70772 0.32533 3.06431 1.5341 0.89443 0.39311 2.80551 02/21/2019 17 10 7 88 2 44 132 09/13/2018 15 9 6 80 1 0 80 2018-03-30 28 19 15 1 342 0 342 149.667 17 35 2 406151.00 4 6 911 S 3RD ST NILES, MI 49120 (41.819191, -86.251737) 02/01/2020
4164 4164 621 W 21st St, Andover, KS 67002, USA 37.72251 -97.1414099 1 ROOFTOP 175157 LIFE CARE CENTER OF ANDOVER 621 W 21ST, PO BOX 100 ANDOVER KS 67002 3167331349 70 Butler For profit - Corporation 154 76.8 Medicare and Medicaid false ANDOVER MEDICAL INVESTORS, LLC 10/31/1986 true SFF false false false Resident Yes   18   18   18   18   18   18   18     2.13408 0.98012 0.32956 1.30968 3.44377 0.14483 2.04491 0.73652 0.3436 3.12503 2.16897 1.00064 0.36101 3.53372 02/07/2019 41 26 22 434 2 217 651 03/06/2018 32 26 15 256 1 0 256 2016-09-06 36 27 9 2 364 182 546 501.833 3 28 5 350261.00 1 6   02/01/2020
5268 5268 2121 WEST 19TH STREET SIOUX CITY, IA 51103 42.510173 -96.435929 0   165174 CASA DE PAZ HEALTH CARE CENTER 2121 WEST 19TH STREET SIOUX CITY IA 51103 7122333127 960 Woodbury For profit - Corporation 71 48 Medicare and Medicaid false PREMIER ESTATES 510, LLC 10/28/1992 false SFF Candidate false false false Resident Yes 1   1   2   1   3   3   4       1.62509 0.6385 0.89818 1.53668 3.16178 0.05624 1.88735 0.7703 0.39473 3.05239 1.78954 0.62328 0.85643 3.32158 09/10/2019 13 9 7 123 1 0 123 06/21/2018 30 9 21 368 1 0 368 2017-04-20 25 5 25 1 392 0 392 249.5 2 58 5 201452.00 1 6 2121 WEST 19TH STREET SIOUX CITY, IA 51103 (42.510173, -96.435929) 02/01/2020
5349 5349 3201 BEECHER RD FLINT, MI 48532 43.008589 -83.728504 0   235363 HERITAGE MANOR HEALTHCARE CENT G 3201 BEECHER RD FLINT MI 48532 8107329200 240 Genesee For profit - Corporation 167 129.7 Medicare and Medicaid false Legal Business Name Not Available 03/01/1978 false   false false false Both Yes 2   1   5   5   5   2   2       2.40235 0.84663 0.43241 1.27905 3.6814 0.12704 2.07679 0.75224 0.35805 3.18708 2.40414 0.8463 0.45455 3.70402 04/04/2019 24 11 13 380 1 0 380 05/10/2018 30 8 24 228 1 0 228 2017-06-07 23 11 15 1 184 0 184 296.667 10 51 4 84025.00 2 6 3201 BEECHER RD FLINT, MI 48532 (43.008589, -83.728504) 02/01/2020
5524 5524 90 N MICHIGAN AVE COLDWATER, MI 49036 41.940512 -84.980906 0   235302 LAURELS OF COLDWATER,THE 90 N MICHIGAN AVE COLDWATER MI 49036 5172799808 110 Branch For profit - Corporation 169 112.7 Medicare and Medicaid false OAK HEALTH CARE INVESTORS OF COLDWATER, INC 07/01/1976 false SFF Candidate true false false Resident Yes 2   1   5   5   4   4   4       2.35626 0.7578 0.73 1.4878 3.84406 0.08029 2.06814 0.69747 0.33673 3.10234 2.36788 0.81699 0.81596 3.97332 05/28/2019 28 22 16 172 2 86 258 06/12/2018 25 18 7 271 2 136 407 2017-02-23 36 32 12 2 430 215 645 372.167 21 20 3 168151.00 3 6 90 N MICHIGAN AVE COLDWATER, MI 49036 (41.940512, -84.980906) 02/01/2020
6006 6006 1901 N TELEGRAPH RD WATERFORD, MI 48328 42.667677 -83.328788 0   235260 REGENCY AT WATERFORD 1901 N TELEGRAPH RD WATERFORD MI 48328 2488361000 620 Oakland For profit - Corporation 150 135 Medicare and Medicaid false NORTHERN OAK MANAGEMENT COMPANY, LLC 01/01/1976 false   false false false Both Yes 2   1   4   4   4   4   4       2.22503 0.9856 0.86901 1.85462 4.07964 0.16339 2.19748 0.76145 0.3489 3.30783 2.10439 0.97329 0.93748 3.95487 03/20/2019 17 13 6 156 1 0 156 03/08/2018 23 17 11 207 1 0 207 2017-02-02 17 12 8 1 148 0 148 171.667 3 43 5 42988.00 1 6 1901 N TELEGRAPH RD WATERFORD, MI 48328 (42.667677, -83.328788) 02/01/2020
6223 6223 563 KAUMANA DRIVE HILO, HI 96720 19.7042 -155.111039 0   125065 LEGACY HILO REHABILITATION & NURSING CENTER 563 KAUMANA DRIVE HILO HI 96720 8084980184 10 Hawaii For profit - Partnership 100 72.3 Medicare and Medicaid false KAUMANA DRIVE PARTNERS LLC 01/20/2016 false SFF true false false Both Yes   18   18   18   18   18   18   18 6 6                             08/09/2019 6 0 6 155 1 0 155 02/08/2019 22 10 12 144 1 0 144 2018-08-16 9 9 0 1 36 0 36 131.5 1 10 4 232031.00 2 6 563 KAUMANA DRIVE HILO, HI 96720 (19.7042, -155.111039) 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
7191 7191 2160 ZINNIA LANE LIBERAL, KS 67901 37.064107 -100.924909 0   175334 GOOD SAMARITAN SOCIETY - LIBERAL 2160 ZINNIA LANE LIBERAL KS 67901 6206243831 870 Seward Non profit - Corporation 45 35.8 Medicare and Medicaid false THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY 05/01/1995 false   false false false Resident Yes 1   1   2   2   2   1 12 1 12     2.84919 0.27007 0.44155 0.71161 3.56081 0.00929 2.05848 0.65543 0.29216 3.00607 2.87667 0.30983 0.56883 3.79841 08/08/2019 11 6 11 124 1 0 124 06/14/2018 7 0 7 186 0 0 186 2016-04-11 8 8 0 1 205 0 205 158.167 4 3 3 87380.00 3 6 2160 ZINNIA LANE LIBERAL, KS 67901 (37.064107, -100.924909) 02/01/2020
7811 7811 26505 POWERS AVE DEARBORN HEIGHTS, MI 48125 42.272116 -83.298344 0   235514 IMPERIAL, A VILLA CENTER 26505 POWERS AVE DEARBORN HEIGHTS MI 48125 3132916200 810 Wayne For profit - Corporation 265 232 Medicare and Medicaid false DETROIT NURSING CENTER LLC 03/13/1992 false   true false false Resident Yes 1   1   3   2   4   2   3       1.22472 0.95429 0.41426 1.36855 2.59327 0.03959 1.88983 0.68062 0.29935 2.8698 1.34688 1.05429 0.52087 2.89767 08/08/2019 32 17 18 212 1 0 212 09/14/2018 16 9 10 100 1 0 100 2017-06-21 21 13 11 1 132 0 132 161.333 7 92 5 142113.00 1 6 26505 POWERS AVE DEARBORN HEIGHTS, MI 48125 (42.272116, -83.298344) 02/01/2020
9594 9594 4006 VISTA RD PASADENA, TX 77504 29.658511 -95.182941 0   675365 PASADENA CARE CENTER 4006 VISTA RD PASADENA TX 77504 7139431592 610 Harris For profit - Limited Liability company 116 89.2 Medicare and Medicaid false RABER CORPORATION 08/03/1994 false SFF Candidate false false false Resident Yes 1   1   2   5   1   2   2       2.00503 0.86037 0.41109 1.27146 3.27649 0.06971 2.00418 0.7388 0.35592 3.0989 2.07922 0.87567 0.43473 3.39043 09/27/2019 15 10 8 92 1 0 92 10/26/2018 12 5 7 430 1 0 430 2017-10-15 26 14 20 1 879 0 879 335.833 3 27 3 38589.00 3 6 4006 VISTA RD PASADENA, TX 77504 (29.658511, -95.182941) 02/01/2020
10124 10124 Highway 64 E, Warner, OK 74469, USA 35.4930193 -95.29581209999999 1 ROOFTOP 375341 COUNTRYSIDE ESTATES HIGHWAY 64 EAST WARNER OK 74469 9184635143 500 Muskogee For profit - Corporation 111 81 Medicare and Medicaid false COUNTRYSIDE HEALTH SERVICES LLC 07/01/1998 false   false false false Resident Yes 1   1   1   3   1   2   1       2.96189 1.67019 0.18368 1.85387 4.81576 0.00315 2.24326 0.86379 1.16101 4.26806 2.74414 1.45392 0.05955 3.61816 11/29/2018 1 1 0 16 1 0 16 09/05/2017 16 3 16 394 1 0 394 2016-06-09 25 9 16 1 502 0 502 223 2 8 3 404232.00 3 6   02/01/2020
10251 10251 414 S UNIVERSITY RD SPOKANE, WA 99206 47.652768 -117.261386 0   505114 GARDENS ON UNIVERSITY, THE 414 S UNIVERSITY RD SPOKANE WA 99206 5099244650 310 Spokane For profit - Corporation 124 104.5 Medicare and Medicaid false GARDENS ON UNIVERSITY - SPOKANE VALLEY, LLC 01/06/1967 false   true false false Resident Yes 2   1   4   4   4   4   4       2.0309 0.56985 0.92009 1.48994 3.52084 0.09659 2.02667 0.7383 0.37048 3.13544 2.08268 0.58038 0.93474 3.60081 09/27/2019 43 32 15 328 1 0 328 11/19/2018 41 25 18 252 2 126 378 2018-01-17 47 33 16 1 454 0 454 365.667 18 24 5 113957.00 1 6 414 S UNIVERSITY RD SPOKANE, WA 99206 (47.652768, -117.261386) 02/01/2020
10499 10499 649 MCMURRY BLVD HARTSVILLE, TN 37074 36.389698 -86.146042 0   445256 HARTSVILLE CONVALESCENT CENTER 649 MCMURRY BLVD HARTSVILLE TN 37074 6153742167 840 Trousdale For profit - Individual 95 43.5 Medicare and Medicaid false NURSING CENTERS UNLIMITED INC 08/20/1990 false SFF Candidate true false false Resident Yes 1   1   3   2   4   2   2       1.78152 1.29381 0.37556 1.66937 3.45089 0.01298 1.82825 0.69801 0.3145 2.84075 2.02521 1.39377 0.44947 3.89538 12/12/2018 20 12 8 465 2 233 698 11/15/2017 6 6 0 56 1 0 56 2016-08-24 15 9 6 1 76 0 76 380.333 8 3 4 65790.00 2 6 649 MCMURRY BLVD HARTSVILLE, TN 37074 (36.389698, -86.146042) 02/01/2020
11523 11523 1116 E LAURIDSEN BOULEVARD PORT ANGELES, WA 98362 48.103507 -123.4195 0   505185 CRESTWOOD HEALTH AND REHABILITATION CENTER 1116 E LAURIDSEN BOULEVARD PORT ANGELES WA 98362 3604529206 40 Clallam For profit - Limited Liability company 101 81.9 Medicare and Medicaid false CRESTWOOD CONVALESCENT - PORT ANGELES, LLC 07/18/1968 false   true false false Resident Yes 1   1   2   3   2   3   4       1.64091 0.45856 0.91395 1.37251 3.01342 0.06162 2.13707 0.76449 0.39305 3.29462 1.59581 0.45104 0.87519 2.93297 03/28/2019 46 31 15 284 1 0 284 05/08/2018 30 13 17 276 1 0 276 2017-03-15 10 7 3 1 112 0 112 252.667 15 32 5 124077.00 1 6 1116 E LAURIDSEN BOULEVARD PORT ANGELES, WA 98362 (48.103507, -123.4195) 02/01/2020
11611 11611 710 15-401 BYPASS BENNETTSVILLE, SC 29512 34.60693 -79.713207 0   425118 DUNDEE MANOR, LLC 710 15-401 BYPASS, WEST BENNETTSVILLE SC 29512 8434796251 340 Marlboro For profit - Corporation 110 103 Medicare and Medicaid false DUNDEE MANOR, LLC 07/01/1978 false   true false false Resident Yes 1   1   2   4   1   2   2       2.185 1.12588 0.26232 1.3882 3.5732 0.04585 2.03343 0.66532 0.28846 2.98721 2.23325 1.27247 0.34228 3.8357 09/19/2019 5 5 0 64 2 32 96 07/13/2018 10 10 0 44 1 0 44 2017-03-23 23 12 11 1 244 0 244 103.333 0 1 4 38300.00 2 6 710 15-401 BYPASS BENNETTSVILLE, SC 29512 (34.60693, -79.713207) 02/01/2020
12607 12607 316 GENERAL CAVAZOS BLVD KINGSVILLE, TX 78363 27.491227 -97.86623 0   675494 KLEBERG COUNTY NURSING AND REHABILITATION LP 316 GENERAL CAVAZOS BLVD KINGSVILLE TX 78363 3615929366 743 Kleberg For profit - Partnership 146 92.9 Medicare and Medicaid false KLEBERG COUNTY NURSING AND REHABILITATION LP 06/07/1995 false SFF Candidate false false false Resident Yes 1   1   1   1   1   1   1       1.90377 1.19804 0.24042 1.43846 3.34223 0.02521 2.01566 0.80625 0.43388 3.2558 1.96296 1.11734 0.20856 3.29179 03/29/2019 24 21 6 220 1 0 220 04/28/2018 29 21 8 327 1 0 327 2017-05-26 29 19 24 1 404 0 404 286.333 3 5 5 152522.00 1 6 316 GENERAL CAVAZOS BLVD KINGSVILLE, TX 78363 (27.491227, -97.86623) 02/01/2020
13196 13196 230 EAST PRESNELL STREET ASHEBORO, NC 27203 35.71458 -79.808406 0   345155 ALPINE HEALTH AND REHABILITATION OF ASHEBORO 230 EAST PRESNELL STREET ASHEBORO NC 27203 3366291447 750 Randolph For profit - Corporation 238 119.6 Medicare and Medicaid false ALPINE HEALTH AND REHABILITATION OF ASHEBORO 05/21/1976 false SFF Candidate false false false Resident Yes 1   1   2   3   2   1 12 1 12 6 6                             04/05/2019 6 4 2 32 1 0 32 02/01/2018 30 18 13 364 1 0 364 2017-02-09 21 17 20 1 296 0 296 186.667 0 17 4 157249.00 2 6 230 EAST PRESNELL STREET ASHEBORO, NC 27203 (35.71458, -79.808406) 02/01/2020
13323 13323 10435 SE CORA STREET PORTLAND, OR 97266 45.490695 -122.554732 0   385264 SECORA REHABILITATION OF CASCADIA 10435 SE CORA STREET PORTLAND OR 97266 5037601737 250 Multnomah For profit - Corporation 53 43.4 Medicare and Medicaid false PORTLAND OF CASCADIA LLC 08/01/2001 false SFF Candidate false false false Resident Yes 2   1   4   4     2 5   5       2.67126 0.65677 1.00193 1.6587 4.32996 0.13554 1.87663 0.64542 0.29051 2.81256 2.95837 0.76516 1.29812 4.93669 08/19/2019 14 13 14 100 1 0 100 01/12/2018 45 17 28 885 2 443 1328 2016-09-30 35 17 18 1 232 0 232 531.333 7 19 4 339089.00 2 6 10435 SE CORA STREET PORTLAND, OR 97266 (45.490695, -122.554732) 02/01/2020
13379 13379 5201 S WILLOW DR HOUSTON, TX 77035 29.655504 -95.470321 0   675612 THE WESTBURY PLACE 5201 S WILLOW DR HOUSTON TX 77035 7137210297 610 Harris For profit - Partnership 112 113.2 Medicare and Medicaid false OAKBEND MEDICAL CENTER 07/09/1996 false SFF true false false Resident Yes   18   18   18   18   18   18   18     2.0846 0.77902 0.56352 1.34254 3.42714 0.04765 2.16383 0.85954 0.45608 3.47946 2.00223 0.6815 0.46505 3.15845 07/12/2019 16 11 5 128 1 0 128 01/31/2019 10 6 4 48 1 0 48 2018-04-12 38 11 37 1 1371 0 1371 308.5 11 30 3 188064.00 3 6 5201 S WILLOW DR HOUSTON, TX 77035 (29.655504, -95.470321) 02/01/2020
13426 13426 315 LILIENTHAL STREET CINCINNATI, OH 45204 39.083541 -84.584481 0   365925 BROOKSIDE HEALTHCARE CENTER 315 LILIENTHAL STREET CINCINNATI OH 45204 5134718667 310 Hamilton For profit - Corporation 65 51.7 Medicare and Medicaid false PRESERVE OPERATING CO LLC 07/28/1993 false   false false true Resident Yes 1   1   4   4     2 2   2       1.60175 0.48229 0.48653 0.96882 2.57057 0.02836 1.88174 0.77571 0.41159 3.06903 1.7691 0.46751 0.44492 2.68585 11/26/2019 13 10 3 64 1 0 64 02/13/2019 29 11 18 382 1 0 382 2018-01-05 22 15 7 1 132 0 132 181.333 1 12 4 147954.00 2 6 315 LILIENTHAL STREET CINCINNATI, OH 45204 (39.083541, -84.584481) 02/01/2020
13871 13871 44 GOETHALS DRIVE RICHLAND, WA 99352 46.261454 -119.281667 0   505070 LIFE CARE CENTER OF RICHLAND 44 GOETHALS DRIVE RICHLAND WA 99352 5099431117 20 Benton For profit - Limited Liability company 104 45.1 Medicare and Medicaid false RICHLAND MEDICAL INVESTORS, LLC 07/10/1979 false   false false false Resident Yes 5   3   5   5   4   4   4       2.42927 0.78134 1.06426 1.84561 4.27488 0.23764 2.20052 0.83445 0.4175 3.45247 2.29439 0.70409 0.95946 3.97052 08/29/2019 21 13 8 152 1 0 152 09/18/2018 13 6 7 80 1 0 80 2017-08-30 11 7 4 1 120 0 120 122.667 6 15 5 123232.00 1 6 44 GOETHALS DRIVE RICHLAND, WA 99352 (46.261454, -119.281667) 02/01/2020
14006 14006 250 BELLEBROOK RD BRISTOL, TN 37620 36.556952 -82.188447 0   445190 CAMBRIDGE HOUSE, THE 250 BELLEBROOK RD BRISTOL TN 37620 4239684123 810 Sullivan For profit - Corporation 130 54.9 Medicare and Medicaid false Legal Business Name Not Available 10/02/1986 false SFF Candidate false false false Resident Yes 1   1   1   2   1   2   3       1.73147 0.48168 0.5211 1.00278 2.73425 0.0067 2.19514 0.65772 0.29778 3.15064 1.63934 0.55068 0.65864 2.78286 04/26/2019 7 7 0 245 1 0 245 05/16/2018 11 9 5 112 2 56 168 2017-03-02 7 7 6 1 329 0 329 233.333 3 1 4 282571.00 2 6 250 BELLEBROOK RD BRISTOL, TN 37620 (36.556952, -82.188447) 02/01/2020
14174 14174 2430 NORTH 13TH STREET SHELTON, WA 98584 47.22765 -123.112641 0   505230 FIR LANE HEALTH AND REHAB CTR 2430 NORTH 13TH STREET SHELTON WA 98584 3604261651 220 Mason For profit - Corporation 135 93.3 Medicare and Medicaid false FIR LANE HEALTH - SHELTON, LLC 01/01/1980 false   true false false Resident Yes 1   1   3   3   4   2   2       1.84589 0.95528 0.43455 1.38984 3.23572 0.05793 2.0367 0.68324 0.32872 3.04866 1.88363 1.05133 0.49756 3.40341 02/28/2019 26 21 5 220 1 0 220 04/11/2018 22 18 4 132 1 0 132 2017-03-31 25 12 13 1 531 0 531 242.5 8 18 6 239353.00 0 6 2430 NORTH 13TH STREET SHELTON, WA 98584 (47.22765, -123.112641) 02/01/2020
15107 15107 NC-177, Hamlet, NC, USA 34.8920793 -79.7027708 1 GEOMETRIC_CENTER 345293 RICHMOND PINES HEALTHCARE AND REHABILITATION CENTE HIGHWAY 177 S BOX 1489 HAMLET NC 28345 9105820021 760 Richmond For profit - Corporation 105 88.5 Medicare and Medicaid false SPRUCE LTC GROUP, LLC 01/18/1989 false SFF false false false Both Yes   18   18   18   18   18   18   18     2.10043 0.82314 0.55654 1.37969 3.48012 0.0587 1.94029 0.73343 0.36447 3.03819 2.24987 0.84392 0.57474 3.6731 10/03/2019 15 15 1 72 1 0 72 04/04/2019 25 19 12 132 1 0 132 2018-10-18 34 22 15 1 355 0 355 139.167 1 44 4 133263.00 2 6   02/01/2020
15348 15348 1000 EAST ELEP STREET COLVILLE, WA 99114 48.539714 -117.892449 0   505275 PRESTIGE CARE & REHABILITATION - PINEWOOD TERRACE 1000 EAST ELEP STREET COLVILLE WA 99114 5096842573 320 Stevens For profit - Corporation 92 71.2 Medicare and Medicaid false CARE CENTER COLVILLE INC. 09/01/1983 false   true false false Resident Yes 2   1   3   3   3   5   5       2.60504 0.46008 0.86041 1.32049 3.92553 0.0321 2.01986 0.64269 0.29967 2.96222 2.68045 0.53829 1.08069 4.24947 07/19/2019 31 20 16 188 1 0 188 06/26/2018 26 13 13 322 1 0 322 2017-05-15 17 11 17 1 116 0 116 220.667 21 11 6 75105.00 0 6 1000 EAST ELEP STREET COLVILLE, WA 99114 (48.539714, -117.892449) 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
);