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

39 rows where Health Inspection Rating = 2 and Total Number of Penalties = 4

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Continuing Care Retirement Community, Abuse Icon, With a Resident and Family Council, Overall Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing Footnote, 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 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 Revisit Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, Number of Payment Denials, 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
347 347 3860 DOBIE RD OKEMOS, MI 48864 42.692251 -84.410335 0   235015 INGHAM COUNTY MEDICAL CARE FAC 3860 DOBIE RD OKEMOS MI 48864 5173816100 320 Ingham Government - County 236 215.7 Medicare and Medicaid false INGHAM COUNTY MEDICAL CARE FACILITY 01/01/1967 false   true false false Resident Yes 4   2   5   5   4   5   5       3.27177 0.856 0.87704 1.73303 5.0048 0.05442 2.03655 0.65483 0.28873 2.98011 3.3389 0.98293 1.1433 5.38527 11/13/2019 10 7 3 68 1 0 68 12/18/2018 11 9 5 68 1 0 68 2017-08-30 9 9 2 2 100 50 150 81.667 11 12 3 63642.00 1 4 3860 DOBIE RD OKEMOS, MI 48864 (42.692251, -84.410335) 02/01/2020
958 958 3011 KENILWORTH BLVD SEBRING, FL 33870 27.485775 -81.436646 0   105352 KENILWORTH CARE & REHABILITATION CENTER 3011 KENILWORTH BLVD SEBRING FL 33870 8633822153 270 Highlands For profit - Limited Liability company 104 72.2 Medicare and Medicaid false LP SEBRING LLC 09/03/1979 false   false false false Resident Yes 2   2   4   5   2   3   2       2.57143 1.20581 0.51183 1.71765 4.28908 0.1798 2.14843 0.81898 0.42191 3.38932 2.48754 1.10711 0.45661 4.05793 06/07/2019 10 7 3 44 1 0 44 04/13/2018 8 7 1 32 1 0 32 2017-04-14 6 1 5 1 24 0 24 36.667 0 7 3 28281.00 1 4 3011 KENILWORTH BLVD SEBRING, FL 33870 (27.485775, -81.436646) 02/01/2020
1002 1002 13230 MANCHESTER ROAD DES PERES, MO 63131 38.601502 -90.465079 0   265834 QUARTERS AT DES PERES, THE 13230 MANCHESTER ROAD DES PERES MO 63131 3148212886 940 St. Louis For profit - Corporation 147 103.2 Medicare and Medicaid false DES PERES HEALTHCARE LLC 03/04/2010 false   false false false Resident Yes 1   2   4   4   5   1 12 1 12     1.99413 1.14455 0.19825 1.34279 3.33692 0.04252 2.07836 0.78783 0.38671 3.2529 1.99411 1.0924 0.19295 3.28948 12/06/2019 15 13 2 92 1 0 92 01/29/2019 7 7 1 40 2 20 60 2018-03-26 8 7 3 1 135 0 135 88.5 2 8 2 48055.00 2 4 13230 MANCHESTER ROAD DES PERES, MO 63131 (38.601502, -90.465079) 02/01/2020
1034 1034 548 ELM STREET NORTHAMPTON, MA 01060 42.327947 -72.657658 0   225257 CARE ONE AT NORTHAMPTON 548 ELM STREET NORTHAMPTON MA 1060 4135863150 80 Hampshire For profit - Corporation 125 103.1 Medicare and Medicaid false 548 ELM STREET OPERATING COMPANY, LLC 02/01/1978 false   false false false Resident Yes 2   2   3   4   3   3   3       1.79228 0.97166 0.62572 1.59739 3.38967 0.05406 2.1685 0.74505 0.34627 3.25983 1.71775 0.98065 0.68014 3.33438 05/06/2019 7 7 0 28 1 0 28 01/18/2018 12 8 4 88 1 0 88 2016-10-18 8 3 5 1 84 0 84 57.333 4 1 4 76217.00 0 4 548 ELM STREET NORTHAMPTON, MA 01060 (42.327947, -72.657658) 02/01/2020
1356 1356 38200 SCHOENHERR ROAD STERLING HEIGHTS, MI 48312 42.57578 -82.989357 0   235665 HEARTLAND HEALTH CARE CENTER - STERLING HEIGHTS 38200 SCHOENHERR ROAD STERLING HEIGHTS MI 48312 5862749044 490 Macomb Non profit - Other 120 157.1 Medicare and Medicaid false MANORCARE HEALTH SERVICES LLC 07/12/2013 false   false false false None Yes 2   2   2   2   3   2   2       1.91812 1.47053 0.50285 1.97338 3.8915 0.38575 2.25281 0.89755 0.44954 3.5999 1.76957 1.23196 0.42101 3.46641 06/19/2019 21 13 10 156 1 0 156 04/19/2018 16 15 4 132 1 0 132 2017-06-14 10 8 2 1 68 0 68 133.333 5 29 3 46637.00 1 4 38200 SCHOENHERR ROAD STERLING HEIGHTS, MI 48312 (42.57578, -82.989357) 02/01/2020
1454 1454 1551 FRANKLIN STREET GRAND RAPIDS, MI 49506 42.94826 -85.630228 0   235401 CLARK RETIREMENT COMMUNITY 1551 FRANKLIN STREET, SE GRAND RAPIDS MI 49506 6164521568 400 Kent Non profit - Corporation 39 36 Medicare and Medicaid false CLARK RETIREMENT COMMUNITY INC. 10/01/1979 true   false false false Both Yes 2   2   5   5     2 1 12 1 12     3.05427 1.22129 0.51337 1.73466 4.78894 0.00343 2.1431 0.60382 0.25637 3.00328 2.96198 1.52089 0.7537 5.11324 09/25/2019 12 8 4 60 1 0 60 08/09/2018 16 11 5 104 1 0 104 2017-06-29 24 20 9 2 224 112 336 120.667 10 16 3 136591.00 1 4 1551 FRANKLIN STREET GRAND RAPIDS, MI 49506 (42.94826, -85.630228) 02/01/2020
1676 1676 1505 E SPRUCE STREET GARDEN CITY, KS 67846 37.967705 -100.855683 0   175175 GARDEN VALLEY RETIREMENT VILLAGE 1505 E SPRUCE STREET GARDEN CITY KS 67846 6202759651 270 Finney For profit - Corporation 78 56.8 Medicare and Medicaid false GARDEN VALLEY RETIREMENT VILLAGE, LLC 09/06/1988 false   false false false Resident Yes 2   2   4   3   4   3   3       2.52888 0.40036 0.60705 1.00741 3.53629 0.06272 2.20154 0.77741 0.39041 3.36936 2.38735 0.38725 0.58524 3.36553 10/21/2019 9 9 0 48 1 0 48 06/04/2019 7 6 1 44 1 0 44 2019-03-21 14 1 13 1 338 0 338 95 3 4 2 126463.00 2 4 1505 E SPRUCE STREET GARDEN CITY, KS 67846 (37.967705, -100.855683) 02/01/2020
2293 2293 3003 W GRAND RIVER HOWELL, MI 48843 42.620394 -83.973171 0   235330 MEDILODGE OF LIVINGSTON 3003 W GRAND RIVER HOWELL MI 48843 5175464210 460 Livingston For profit - Corporation 125 73 Medicare and Medicaid false HOWELL OPCO LLC 04/01/1978 false   false false false Both Yes 3   2   2   3   2   4   4       2.65401 0.76387 1.36557 2.12944 4.78345 0.02429 2.15959 0.78539 0.6272 3.57218 2.55415 0.73134 0.81948 4.29399 08/29/2019 10 10 0 44 2 22 66 03/06/2019 7 5 2 40 1 0 40 2018-05-03 43 35 8 2 413 207 620 149.667 2 14 3 132219.00 1 4 3003 W GRAND RIVER HOWELL, MI 48843 (42.620394, -83.973171) 02/01/2020
2311 2311 2133 S ELIZABETH STREET WICHITA, KS 67213 37.655689 -97.357291 0   175487 HOMESTEAD HEALTH CENTER 2133 S ELIZABETH STREET WICHITA KS 67213 3162624473 860 Sedgwick Non profit - Corporation 62 55.5 Medicare and Medicaid false HOMESTEAD HEALTH CENTER, INC. 01/01/2006 false   false false false Resident Yes 2   2   5   5   5   1 12 1 12 6 6                             10/10/2019 7 6 1 119 1 0 119 08/06/2018 3 3 0 36 1 0 36 2017-01-11 12 7 5 1 140 0 140 94.833 3 1 2 17046.00 2 4 2133 S ELIZABETH STREET WICHITA, KS 67213 (37.655689, -97.357291) 02/01/2020
2917 2917 180 NORTH JACKSON AVENUE SAN JOSE, CA 95116 37.36251 -121.847382 0   56082 CANYON SPRINGS POST-ACUTE 180 NORTH JACKSON AVENUE SAN JOSE CA 95116 4082598700 530 Santa Clara For profit - Corporation 199 160.3 Medicare and Medicaid false DRAGONFRUIT HOLDINGS LLC 12/30/1994 false   false false false Resident Yes 3   2   5   5   4   3   3       2.45388 0.90114 0.57746 1.4786 3.93248 0.15279 2.16451 0.71882 0.32558 3.20892 2.35618 0.94266 0.66757 3.92972 04/05/2019 18 14 4 104 1 0 104 03/09/2018 12 9 4 84 1 0 84 2017-03-02 20 18 2 2 124 62 186 111 4 3 3 70802.00 1 4 180 NORTH JACKSON AVENUE SAN JOSE, CA 95116 (37.36251, -121.847382) 02/01/2020
4275 4275 2100 MIDWAY ST COLUMBUS, IN 47201 39.218966 -85.891416 0   155133 COLUMBUS TRANSITIONAL CARE AND REHABILITATION 2100 MIDWAY ST COLUMBUS IN 47201 8123728447 20 Bartholomew Government - County 212 84.8 Medicare and Medicaid false COLUMBUS REGIONAL HOSPITAL 09/01/1972 false   false false false Resident Yes 1   2   2   1   2   1   1       2.31207 1.11997 0.32575 1.44572 3.75779 0.09487 2.1062 0.89671 0.48716 3.49007 2.28149 0.93916 0.25168 3.45264 04/16/2019 11 9 2 48 1 0 48 05/15/2018 10 8 2 40 1 0 40 2017-12-20 25 7 18 1 184 0 184 68 1 12 3 32425.00 1 4 2100 MIDWAY ST COLUMBUS, IN 47201 (39.218966, -85.891416) 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
6382 6382 14900 MIDDLEBELT RD LIVONIA, MI 48154 42.394064 -83.334268 0   235479 REGENCY AT LIVONIA 14900 MIDDLEBELT RD LIVONIA MI 48154 7344254200 810 Wayne For profit - Corporation 142 123.6 Medicare and Medicaid false MIDDLEBELT HOPE ACQUISTION COMPANY INC 01/06/1989 false   true false false Resident Yes 3   2   5   5   5   2   2       1.84955 0.87591 0.4075 1.28341 3.13296 0.07253 2.12861 0.70427 0.31301 3.14589 1.80586 0.93521 0.49 3.19348 08/28/2019 16 10 6 124 1 0 124 09/27/2018 12 10 5 112 1 0 112 2017-07-20 19 13 9 1 128 0 128 120.667 8 19 4 85444.00 0 4 14900 MIDDLEBELT RD LIVONIA, MI 48154 (42.394064, -83.334268) 02/01/2020
7078 7078 1220 Ww II Memorial Dr, Winfield, KS 67156, USA 37.2607767 -96.96890440000001 1 ROOFTOP 175516 KANSAS VETERANS HOME 1220 WORLD WAR II MEMORIAL DRIVE WINFIELD KS 67156 6202219479 170 Cowley Government - State 142 86.5 Medicare and Medicaid false STATE OF KANSAS ACCOUNTING SERVICES 09/01/2010 false   false false false Both Yes 2   2   1   1     2 4   4       3.68551 1.06603 0.79352 1.85955 5.54506 0.01222 2.12737 0.67248 0.30317 3.10303 3.60055 1.19199 0.98514 5.73025 04/03/2019 7 7 0 48 1 0 48 06/01/2018 16 15 1 112 1 0 112 2016-09-27 16 14 2 1 148 0 148 86 3 3 3 26275.00 1 4   02/01/2020
7340 7340 29270 MORLOCK LIVONIA, MI 48152 42.439839 -83.334193 0   235365 SKLD LIVONIA 29270 MORLOCK LIVONIA MI 48152 2484760555 810 Wayne For profit - Individual 110 102.9 Medicare and Medicaid false LIVONIA SNF LLC 01/01/1979 false   false false false None Yes 1   2   3   3   4   1 12 1 12 6 6                             12/11/2019 20 11 10 203 1 0 203 10/04/2018 10 7 3 96 1 0 96 2017-08-10 8 6 4 1 84 0 84 147.5 6 22 4 59653.00 0 4 29270 MORLOCK LIVONIA, MI 48152 (42.439839, -83.334193) 02/01/2020
7884 7884 25375 KELLY RD ROSEVILLE, MI 48066 42.483235 -82.927375 0   235491 ADVANTAGE LIVING CENTER - ROSEVILLE 25375 KELLY RD ROSEVILLE MI 48066 5867736022 490 Macomb For profit - Corporation 169 120.4 Medicare and Medicaid false RHEMA-ROSEVILLE OPERATING LLC 10/06/1989 false   false false false Resident Yes 2   2   3   4   2   3   2       2.66226 1.25525 0.281 1.53625 4.19851 0.05254 1.99262 0.69309 0.29932 2.98503 2.77677 1.36184 0.35336 4.51024 06/26/2019 17 13 4 100 1 0 100 04/26/2018 21 14 7 136 1 0 136 2017-06-14 27 13 19 1 208 0 208 130 13 56 4 88749.00 0 4 25375 KELLY RD ROSEVILLE, MI 48066 (42.483235, -82.927375) 02/01/2020
8461 8461 5245 N SOCRUM LOOP RD LAKELAND, FL 33809 28.109594 -81.94714 0   105482 CONSULATE HEALTH CARE OF LAKELAND 5245 N SOCRUM LOOP RD LAKELAND FL 33809 8638591446 520 Polk For profit - Corporation 120 111.3 Medicare and Medicaid false LAKELAND FACILITY OPERATIONS LLC 12/28/1984 false   false false false Resident Yes 2   2   4   4   5   2   1       2.48837 0.99808 0.2052 1.20328 3.69165 0.08147 2.16331 0.7315 0.34221 3.23703 2.39062 1.02597 0.22569 3.65702 08/09/2019 3 1 2 12 1 0 12 04/19/2018 14 7 7 68 2 34 102 2017-03-31 7 5 2 1 28 0 28 44.667 0 12 3 24410.00 1 4 5245 N SOCRUM LOOP RD LAKELAND, FL 33809 (28.109594, -81.94714) 02/01/2020
8720 8720 721 OTIS AVENUE SUNNYSIDE, WA 98944 46.312883 -120.010885 0   505226 PRESTIGE CARE & REHABILITATION - SUNNYSIDE 721 OTIS AVENUE SUNNYSIDE WA 98944 5098372122 380 Yakima For profit - Corporation 80 65.2 Medicare and Medicaid false CARE CENTER SUNNYSIDE, INC 06/01/1974 false   false false false Resident Yes 3   2   2   2   2   4   4       2.38632 0.7097 0.81132 1.52102 3.90735 0.1176 2.22618 0.76816 0.33763 3.33197 2.22784 0.69472 0.90446 3.7604 04/18/2019 26 17 11 208 1 0 208 03/22/2018 11 9 3 92 1 0 92 2017-05-11 4 1 3 1 36 0 36 140.667 11 9 4 57490.00 0 4 721 OTIS AVENUE SUNNYSIDE, WA 98944 (46.312883, -120.010885) 02/01/2020
8784 8784 877 HILL EVERHART ROAD LEXINGTON, NC 27295 35.851182 -80.227497 0   345333 ABBOTTS CREEK CENTER 877 HILL EVERHART ROAD LEXINGTON NC 27295 3362486644 280 Davidson For profit - Corporation 64 60 Medicare and Medicaid false SUNBRIDGE REGENCY - NORTH CAROLINA, LLC 11/15/1990 false   false false false Resident Yes 2   2   3   3   4   2   2       1.8822 0.91587 0.48577 1.40163 3.28383 0.12198 2.03643 0.76082 0.4007 3.19795 1.92093 0.90517 0.45629 3.29278 04/11/2019 5 5 0 40 1 0 40 03/01/2018 7 4 3 119 1 0 119 2017-01-26 1 1 0 1 16 0 16 62.333 0 2 3 24138.00 1 4 877 HILL EVERHART ROAD LEXINGTON, NC 27295 (35.851182, -80.227497) 02/01/2020
8805 8805 211 N MAIN BREMOND, TX 76629 32.126055 -96.945277 0   675132 BREMOND NURSING AND REHABILITATION CENTER 211 N MAIN BREMOND TX 76629 2547467666 878 Robertson For profit - Partnership 37 37.6 Medicare and Medicaid false LIBERTY COUNTY HOSPITAL DISTRICT NO 1 02/01/1993 false   false false false Resident Yes 1   2   4   4     2 1 12 1 12     2.08316 0.78009 0.25221 1.0323 3.11546 0.01164 2.14141 0.80243 0.42281 3.36664 2.0218 0.73101 0.22452 2.96742 02/06/2019 1 0 1 4 1 0 4 02/07/2018 7 5 2 261 1 0 261 2017-02-08 6 3 3 1 52 0 52 97.667 2 1 3 57308.00 1 4 211 N MAIN BREMOND, TX 76629 (32.126055, -96.945277) 02/01/2020
9260 9260 917 7TH AVENUE LONGVIEW, WA 98632 46.129113 -122.929172 0   505361 AMERICANA HEALTH & REHAB CTR 917 7TH AVENUE LONGVIEW WA 98632 3604255910 70 Cowlitz For profit - Corporation 74 54.9 Medicare and Medicaid false EVERGREEN WASHINGTON HEALTHCARE AMERICANA, L.L.C. 01/01/1990 false   false false false Resident Yes 2   2   2   2   2   3   3       2.0817 0.89112 0.51891 1.41003 3.49173 0.09269 1.97405 0.68751 0.31813 2.97969 2.19168 0.97463 0.61393 3.75771 05/29/2019 28 24 4 200 1 0 200 07/31/2018 23 20 3 204 1 0 204 2017-06-14 12 6 7 1 116 0 116 187.333 11 8 4 54773.00 0 4 917 7TH AVENUE LONGVIEW, WA 98632 (46.129113, -122.929172) 02/01/2020
10240 10240 1737 N LOOP W HOUSTON, TX 77008 29.811997 -95.432375 0   675793 BROOKHOLLOW HEIGHTS TRANSITIONAL CARE CENTER 1737 N LOOP W HOUSTON TX 77008 7138695551 610 Harris For profit - Corporation 200 132.9 Medicare and Medicaid false PINNACLE HEALTH FACILITIES XV LP 06/16/1999 false   false false false Resident Yes 1   2   2   4   1   1   1       1.81918 0.77984 0.28275 1.06259 2.88177 0.06345 2.1386 0.79454 0.42156 3.3547 1.76792 0.73803 0.25245 2.7546 02/08/2019 13 8 7 120 1 0 120 02/23/2018 8 6 2 76 1 0 76 2017-01-26 2 0 2 0 24 0 24 89.333 3 10 2 23807.00 2 4 1737 N LOOP W HOUSTON, TX 77008 (29.811997, -95.432375) 02/01/2020
10557 10557 709 NORTH LOWE HOBART, OK 73651 35.034853 -99.099891 0   375279 HOBART NURSING & REHAB 709 NORTH LOWE HOBART OK 73651 5807263381 370 Kiowa For profit - Partnership 58 29.4 Medicare and Medicaid false HOBART NURSING AND REHAB 09/01/1996 false   false false false Resident Yes 3   2   2   2   2   4   3       2.6455 0.8495 0.41281 1.26231 3.90781 0.00407 1.90111 0.65023 0.27602 2.82736 2.89212 0.98238 0.56292 4.43206 06/12/2019 2 0 2 48 0 0 48 04/05/2018 6 6 0 44 2 22 66 2017-02-13 17 17 0 1 183 0 183 76.5 0 2 1 3973.00 3 4 709 NORTH LOWE HOBART, OK 73651 (35.034853, -99.099891) 02/01/2020
10698 10698 1600 MURCHISON RD EL PASO, TX 79902 31.780298 -106.480909 0   455471 MOUNTAIN VIEW HEALTH & REHABILITATION 1600 MURCHISON RD EL PASO TX 79902 9155442002 480 El Paso For profit - Limited Liability company 187 141.6 Medicare and Medicaid false EL PASO III ENTERPRISES, LLC 04/15/1982 false   false false false Resident Yes 1   2   4   4   3   1 12 1 12     2.06761 1.22992 0.13196 1.36189 3.4295 0.0086 2.20098 0.8272 0.43405 3.46223 1.9524 1.11802 0.11443 3.17634 11/16/2018 4 0 4 44 1 0 44 01/26/2018 16 12 5 148 1 0 148 2017-03-23 19 9 10 1 180 0 180 101.333 4 1 3 24126.00 1 4 1600 MURCHISON RD EL PASO, TX 79902 (31.780298, -106.480909) 02/01/2020
11245 11245 6025 N Assembly St, Spokane, WA 99205, USA 47.7139931 -117.4771961 1 ROOFTOP 505322 MANOR CARE HEALTH SERVICES-SPO NORTH 6025 ASSEMBLY SPOKANE WA 99205 5093268282 310 Spokane For profit - Corporation 125 88.3 Medicare and Medicaid false MANOR CARE OF SPOKANE WA LLC 10/19/1988 false   false false false Resident Yes 4   2   5   5   5   4   4       2.06788 0.7845 0.66711 1.45161 3.5195 0.13526 2.06046 0.74672 0.34095 3.14814 2.08582 0.78999 0.73644 3.58493 08/05/2019 24 21 3 160 1 0 160 06/11/2018 22 15 10 116 1 0 116 2017-08-30 20 7 19 1 132 0 132 140.667 8 15 4 126926.00 0 4   02/01/2020
11311 11311 2818 NORTHEAST 145TH STREET SEATTLE, WA 98155 47.73379 -122.297228 0   505262 SHORELINE HEALTH AND REHABILITATION 2818 NORTHEAST 145TH STREET SEATTLE WA 98155 2064182900 160 King For profit - Individual 114 81.9 Medicare and Medicaid false NORTH LAKE 5-O LLC 04/01/1982 false   false false false Resident Yes 1   2   4   4   5   1 12 1 12 6 6                             12/05/2019 36 30 6 228 0 0 228 09/26/2018 16 14 3 100 1 0 100 2017-10-12 36 28 23 1 379 0 379 210.5 10 22 4 106865.00 0 4 2818 NORTHEAST 145TH STREET SEATTLE, WA 98155 (47.73379, -122.297228) 02/01/2020
11315 11315 19525 W NORTH AVE BROOKFIELD, WI 53045 43.061321 -88.155074 0   525528 FRANCISCAN WOODS 19525 W NORTH AVE BROOKFIELD WI 53045 2627851114 660 Waukesha Non profit - Corporation 110 80.3 Medicare and Medicaid false WHEATON FRANCISCAN HEALTHCARE TERRACE AT ST FRANCIS INC 12/30/1993 false   false false false Both Yes 3   2   4   3   5   4   4       2.44652 0.82867 1.03508 1.86376 4.31028 0.11991 2.21179 0.7872 0.37619 3.37518 2.29891 0.79155 1.03563 4.09507 05/22/2019 8 8 2 48 2 24 72 06/13/2018 5 5 0 52 1 0 52 2017-04-06 9 9 0 1 102 0 102 70.333 1 0 4 44814.00 0 4 19525 W NORTH AVE BROOKFIELD, WI 53045 (43.061321, -88.155074) 02/01/2020
11953 11953 7804 VIRGIL ANTHONY BLVD WATAUGA, TX 76148 32.887853 -97.257558 0   675963 NORTH POINTE NURSING AND REHABILITATION LP 7804 VIRGIL ANTHONY BLVD WATAUGA TX 76148 8174987220 910 Tarrant For profit - Partnership 126 77.9 Medicare and Medicaid false NORTH POINTE NURSING AND REHABILITATION LP 04/10/2003 false   false false false Resident Yes 1   2   3   4   3   1   1       1.7363 1.04268 0.30125 1.34393 3.08022 0.00817 2.12427 0.78635 0.37888 3.2895 1.69875 0.99705 0.29926 3.00265 11/06/2019 2 0 2 8 0 0 8 11/16/2018 15 6 9 132 1 0 132 2017-10-20 9 0 9 0 308 0 308 99.333 4 12 2 73790.00 2 4 7804 VIRGIL ANTHONY BLVD WATAUGA, TX 76148 (32.887853, -97.257558) 02/01/2020
12214 12214 3695 HOT SPRINGS BOULEVARD LAS VEGAS, NM 87701 35.609277 -105.242343 0   325104 NM BEHAVIORAL HEALTH INSTITUTE AT LAS VEGAS(THE) 3695 HOT SPRINGS BOULEVARD LAS VEGAS NM 87701 5054542100 230 San Miguel Government - State 176 122.6 Medicare and Medicaid false STATE OF NEW MEXICO 09/29/1995 false   false false false Both Yes 1   2   3   3     2 1 12 1 12 6 6                             06/06/2019 13 8 5 104 1 0 104 03/29/2018 17 14 4 251 1 0 251 2017-08-01 6 6 0 1 44 0 44 143 2 1 2 50585.00 2 4 3695 HOT SPRINGS BOULEVARD LAS VEGAS, NM 87701 (35.609277, -105.242343) 02/01/2020
13231 13231 310 BROOKSIDE DRIVE MADILL, OK 73446 34.079252 -96.775016 0   375235 BROOKSIDE NURSING CENTER 310 BROOKSIDE DRIVE MADILL OK 73446 5807952100 470 Marshall For profit - Corporation 140 47.2 Medicare and Medicaid false SCG MADILL BROOKSIDE LLC 09/01/1995 false   false false false Resident Yes 3   2   2   3   2   4   4       2.22972 0.57891 0.62733 1.20623 3.43595 0.03014 1.84393 0.6544 0.29655 2.79489 2.51317 0.66519 0.7962 3.94218 04/10/2019 1 1 0 8 1 0 8 06/28/2018 13 10 3 84 1 0 84 2017-07-06 22 15 8 1 330 0 330 87 0 6 3 116628.00 1 4 310 BROOKSIDE DRIVE MADILL, OK 73446 (34.079252, -96.775016) 02/01/2020
13308 13308 400 EAST 33RD STREET VANCOUVER, WA 98663 45.64523 -122.667592 0   505206 THE OAKS AT TIMBERLINE 400 EAST 33RD STREET VANCOUVER WA 98663 3606962561 50 Clark For profit - Corporation 98 88 Medicare and Medicaid false THIRTY THREE OAKS LLC 11/09/1970 false   false false false Resident Yes 3   2   3   3   2   4   4       1.90889 0.82329 0.76278 1.58608 3.49496 0.05345 1.8871 0.67182 0.29696 2.85588 2.10234 0.92147 0.96678 3.92424 07/16/2019 34 23 11 212 1 0 212 09/12/2018 24 20 4 160 1 0 160 2017-10-10 9 7 2 1 64 0 64 170 8 15 4 28590.00 0 4 400 EAST 33RD STREET VANCOUVER, WA 98663 (45.64523, -122.667592) 02/01/2020
13818 13818 300 NORTH ST COLUMBUS, TX 78934 29.715874 -96.538244 0   675996 COLUMBUS OAKS HEALTHCARE COMMUNITY 300 NORTH ST COLUMBUS TX 78934 9797322347 312 Colorado For profit - Corporation 137 51.3 Medicare and Medicaid false DHC OPCO-COLUMBUS, LLC 12/08/2003 false   false false false Both Yes 1   2   1   1   1   1 12 1 12     3.38461 0.93542 0.47255 1.40796 4.79258 0.07695 2.07657 0.83702 0.4432 3.35679 3.3875 0.84034 0.40131 4.57824 06/07/2019 12 12 0 84 1 0 84 05/10/2018 16 13 4 100 1 0 100 2017-04-27 16 13 3 1 164 0 164 102.667 4 5 3 57684.00 1 4 300 NORTH ST COLUMBUS, TX 78934 (29.715874, -96.538244) 02/01/2020
13824 13824 1015 NORTH GARRISON ROAD VANCOUVER, WA 98664 45.628966 -122.591546 0   505269 VANCOUVER SPECIALTY AND REHAB CARE 1015 NORTH GARRISON ROAD VANCOUVER WA 98664 3606947501 50 Clark For profit - Individual 104 89.5 Medicare and Medicaid false 1015 NORTH GARRISON LLC 07/01/1982 false   false false false Resident Yes 2   2   2   2   3   2   2       2.51893 0.93069 0.74996 1.68065 4.19958 0.06843 2.2056 0.89432 0.65845 3.75837 2.37359 0.78252 0.4287 3.58311 05/10/2019 19 12 7 128 1 0 128 07/18/2018 17 16 1 124 1 0 124 2017-08-31 22 17 8 1 382 0 382 169 2 12 4 129840.00 0 4 1015 NORTH GARRISON ROAD VANCOUVER, WA 98664 (45.628966, -122.591546) 02/01/2020
13998 13998 51 N MAIN ST INMAN, SC 29349 35.050076 -82.091344 0   425122 INMAN HEALTHCARE 51 N MAIN ST INMAN SC 29349 8644729370 410 Spartanburg For profit - Corporation 40 34.5 Medicare and Medicaid false INMAN OPERATIONS LLC 07/01/1978 false   false false false Resident Yes 2   2   3   3     2 3   4       1.92172 0.37607 0.8053 1.18136 3.10309 0.01523 2.13441 0.77733 0.3267 3.23843 1.87124 0.36378 0.92778 3.07264 03/07/2019 10 7 3 44 1 0 44 04/17/2018 6 6 0 40 1 0 40 2017-02-09 10 10 0 1 84 0 84 49.333 0 0 3 219671.00 1 4 51 N MAIN ST INMAN, SC 29349 (35.050076, -82.091344) 02/01/2020
14203 14203 650 WEST HEMLOCK ST SEQUIM, WA 98382 48.07511 -123.115536 0   505128 SEQUIM HEALTH & REHABILITATION 650 WEST HEMLOCK ST SEQUIM WA 98382 3605822400 40 Clallam For profit - Corporation 100 96.6 Medicare and Medicaid false SEQUIM HEALTH, LLC 10/01/1969 false   true false false Both Yes 2   2   3   3   4   3   4       1.9169 0.56238 0.86141 1.4238 3.3407 0.14056 2.24374 0.84277 0.42236 3.50888 1.77559 0.50177 0.76764 3.05297 10/09/2019 28 24 6 196 1 0 196 11/14/2018 23 23 0 136 1 0 136 2018-01-26 17 13 9 1 196 0 196 176 7 7 4 109280.00 0 4 650 WEST HEMLOCK ST SEQUIM, WA 98382 (48.07511, -123.115536) 02/01/2020
14632 14632 920 ANDERSON DRIVE ABERDEEN, WA 98520 46.980005 -123.846366 0   505016 GRAYS HARBOR HEALTH & REHABILITATION CENTER 920 ANDERSON DRIVE ABERDEEN WA 98520 3605325122 130 Grays Harbor For profit - Corporation 105 67.1 Medicare and Medicaid false AVALON CARE CENTER - ABERDEEN, LLC 01/01/1967 false   false false false Resident Yes 3   2   5   5   5   3   2       2.74412 0.65878 0.44055 1.09933 3.84345 0.06854 2.01194 0.70796 0.33158 3.05148 2.83467 0.69971 0.50007 4.0389 07/15/2019 19 13 7 144 1 0 144 08/29/2018 25 17 8 120 1 0 120 2017-09-18 20 13 10 1 160 0 160 138.667 8 18 4 145289.00 0 4 920 ANDERSON DRIVE ABERDEEN, WA 98520 (46.980005, -123.846366) 02/01/2020
14931 14931 222 EAST FIFTH SPOKANE, WA 99202 47.651772 -117.40645 0   505509 SPOKANE VETERANS HOME 222 EAST FIFTH SPOKANE WA 99202 5093445770 310 Spokane Government - State 100 96.4 Medicare and Medicaid false DEPARTMENT OF VETERANS AFFAIRS SPOKANE VETERANS HOME 11/21/2001 false   true false false Resident Yes 3   2   4   3   4   5   5       2.45191 0.02074 1.35157 1.37231 3.82423 0.06017 2.01803 0.68297 0.30033 3.00133 2.52518 0.02284 1.69384 4.08586 04/05/2019 24 12 14 140 1 0 140 05/07/2018 18 14 4 124 1 0 124 2017-06-13 14 8 6 1 80 0 80 124.667 10 19 4 108706.00 0 4 222 EAST FIFTH SPOKANE, WA 99202 (47.651772, -117.40645) 02/01/2020
15078 15078 955 GARDEN LAKE PKWY TOLEDO, OH 43614 41.621155 -83.596769 0   365704 ADVANCED HEALTHCARE CENTER 955 GARDEN LAKE PKWY TOLEDO OH 43614 4193822200 490 Lucas For profit - Corporation 99 83.2 Medicare and Medicaid false PARKWAY OPERATING CO LLC 10/07/1987 false   false false false Resident Yes 3   2   5   5   4   2   2       2.02936 0.92951 0.64107 1.57058 3.59995 0.03514 2.17269 0.90285 0.70534 3.78088 1.94123 0.77415 0.34209 3.05321 07/11/2019 10 4 7 56 1 0 56 06/21/2018 19 13 6 100 1 0 100 2017-05-04 8 4 4 1 64 0 64 72 0 13 3 74087.00 1 4 955 GARDEN LAKE PKWY TOLEDO, OH 43614 (41.621155, -83.596769) 02/01/2020
15243 15243 534 BOYER AVENUE WALLA WALLA, WA 99362 46.070644 -118.325099 0   505421 WASHINGTON ODD FELLOWS HOME 534 BOYER AVENUE WALLA WALLA WA 99362 5095256463 350 Walla Walla Non profit - Corporation 117 100.6 Medicare and Medicaid false WASHINGTON ODD FELLOWS HOME 01/01/1992 true   true false false Resident Yes 4   2   5   4   5   4   5       2.56407 0.45964 0.94603 1.40566 3.96974 0.04307 2.43364 0.73515 0.31252 3.48131 2.18973 0.47014 1.13935 3.65655 09/27/2019 21 17 4 160 1 0 160 08/31/2018 13 9 4 80 1 0 80 2017-07-21 12 11 1 1 68 0 68 118 6 3 4 49774.00 0 4 534 BOYER AVENUE WALLA WALLA, WA 99362 (46.070644, -118.325099) 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
);