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

23 rows where Number of Facility Reported Incidents = 6 and Overall Rating = 4

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: prvdr_city, prvdr_state, prvdr_cnty, ownership, nmbr_beds, prvdr_type, Continuing Care Retirement Community, Abuse Icon, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, RN Staffing Rating, 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, Total Weighted Health Survey Score, 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)

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
501 501 3200 BAKER CIRCLE ADAMSTOWN, MD 21710 39.320699 -77.42612 0   215329 BUCKINGHAM'S CHOICE 3200 BAKER CIRCLE ADAMSTOWN MD 21710 3016441636 100 Frederick For profit - Corporation 42 27.6 Medicare and Medicaid false BUCKINGHAM'S CHOICE, INC. 03/18/2000 true   false false false Resident Yes 4   3   4   5   4   5   5       2.77916 0.34742 1.88874 2.23616 5.01532 0.11061 2.17502 0.78348 0.38651 3.34501 2.65562 0.33344 1.83924 4.80789 08/19/2019 16 13 5 92 1 0 92 06/22/2018 13 10 3 40 1 0 40 2017-03-10 6 6 6 1 32 0 32 64.667 6 0 0 0.00 0 0 3200 BAKER CIRCLE ADAMSTOWN, MD 21710 (39.320699, -77.42612) 02/01/2020
801 801 6600 RIDGE ROAD BALTIMORE, MD 21237 39.342577 -76.485287 0   215109 MANOR CARE HEALTH SERVICES - ROSSVILLE 6600 RIDGE ROAD BALTIMORE MD 21237 4105744950 20 Baltimore For profit - Corporation 172 133.2 Medicare and Medicaid false MANOR CARE-ROSSVILLE MD LLC 09/01/1977 false   false false false Resident Yes 4   3   5   4   5   2   3       1.66611 0.85438 0.6122 1.46658 3.1327 0.12562 2.14361 0.74006 0.35145 3.23511 1.61538 0.8681 0.65563 3.10514 03/29/2019 24 14 11 100 1 0 100 10/30/2017 5 3 5 16 1 0 16 2016-08-30 6 6 0 1 20 0 20 58.667 6 2 0 0.00 0 0 6600 RIDGE ROAD BALTIMORE, MD 21237 (39.342577, -76.485287) 02/01/2020
1387 1387 1161 CIRBY WAY ROSEVILLE, CA 95661 38.729508 -121.273938 0   55886 ROSEVILLE CARE CENTER 1161 CIRBY WAY ROSEVILLE CA 95661 9167821238 410 Placer For profit - Corporation 210 173.8 Medicare and Medicaid false CROCUS HOLDINGS, LLC 02/19/1968 false   false false false Resident Yes 4   3   5   5   5   2   2       2.4798 1.00046 0.43242 1.43288 3.91268 0.23334 2.20533 0.75638 0.35584 3.31756 2.337 0.99458 0.45739 3.7819 11/16/2018 9 4 5 40 1 0 40 11/17/2017 9 6 3 92 1 0 92 2016-12-09 6 6 0 1 48 0 48 58.667 6 7 1 7153.00 0 1 1161 CIRBY WAY ROSEVILLE, CA 95661 (38.729508, -121.273938) 02/01/2020
1667 1667 6000 BELLONA AVENUE BALTIMORE, MD 21212 39.364277 -76.615292 0   215074 HOMEWOOD CENTER 6000 BELLONA AVENUE BALTIMORE MD 21212 4103234223 30 Baltimore City For profit - Corporation 112 82.6 Medicare and Medicaid false 6000 BELLONA AVENUE OPERATIONS LLC 02/17/1970 false   false false false Resident Yes 4   3   3   3   3   4   4       2.00489 0.69258 0.8828 1.57538 3.58028 0.03825 2.0462 0.72343 0.36527 3.13489 2.03639 0.71988 0.90966 3.66224 12/11/2018 21 21 0 104 1 0 104 08/07/2017 12 8 5 44 1 0 44 2016-06-20 12 12 0 1 36 0 36 72.667 6 2 0 0.00 0 0 6000 BELLONA AVENUE BALTIMORE, MD 21212 (39.364277, -76.615292) 02/01/2020
2589 2589 467 E GILBERT ST SAN BERNARDINO, CA 92404 34.126803 -117.275356 0   56436 MEDICAL CENTER CONVALESCENT HOSPITAL 467 E GILBERT ST SAN BERNARDINO CA 92404 9098844781 460 San Bernardino For profit - Limited Liability company 99 89.3 Medicare and Medicaid false SAN BERNARDINO CARE COMPANY 04/11/1974 false   false false false Resident Yes 4   3   5   5   4   2   2       2.34207 0.93271 0.26882 1.20152 3.5436 0.07013 2.00719 0.68007 0.30467 2.99193 2.42509 1.03128 0.33209 3.79793 06/13/2019 10 8 2 52 1 0 52 05/25/2018 20 16 4 100 1 0 100 2017-05-26 7 6 1 1 48 0 48 67.333 6 1 0 0.00 0 0 467 E GILBERT ST SAN BERNARDINO, CA 92404 (34.126803, -117.275356) 02/01/2020
3447 3447 2571 GUTHRIE AVENUE DES MOINES, IA 50317 41.61498 -93.569112 0   165507 VALLEY VIEW VILLAGE 2571 GUTHRIE AVENUE DES MOINES IA 50317 5152652571 760 Polk Non profit - Corporation 79 73.9 Medicare and Medicaid false EVANGELICAL RETIREMENT HOMES, INC. 05/01/2004 true   false false false Both Yes 4   2   5   4   5   4   4       3.15427 0.73088 0.7563 1.48718 4.64145 0.05955 2.01332 0.61974 0.27542 2.90848 3.25613 0.88679 1.03354 5.1173 01/10/2019 10 10 0 40 1 0 40 09/28/2017 8 6 4 56 1 0 56 2016-09-15 4 3 1 1 20 0 20 42 6 5 0 0.00 0 0 2571 GUTHRIE AVENUE DES MOINES, IA 50317 (41.61498, -93.569112) 02/01/2020
3785 3785 515 N MAIN ST AVILLA, IN 46710 41.374503 -85.239982 0   155512 PRESENCE SACRED HEART HOME 515 N MAIN ST AVILLA IN 46710 2608972841 560 Noble Non profit - Corporation 133 83.7 Medicare and Medicaid false ADAMS COUNTY MEMORIAL HOSPITAL 05/01/1994 false   false false false Resident Yes 4   2   5   4   5   4   4       2.29903 0.78709 0.81194 1.59903 3.89806 0.06276 2.10989 0.71575 0.33139 3.15704 2.26464 0.82688 0.92217 3.95932 02/25/2019 14 9 5 56 1 0 56 03/23/2018 6 3 3 24 1 0 24 2017-02-21 8 2 7 1 103 0 103 53.167 6 17 1 10000.00 0 1 515 N MAIN ST AVILLA, IN 46710 (41.374503, -85.239982) 02/01/2020
4011 4011 731 STARKWEATHER DR LANSING, MI 48917 42.742509 -84.654365 0   235285 MEDILODGE OF LANSING 731 STARKWEATHER DR LANSING MI 48917 5173239133 220 Eaton For profit - Corporation 101 60.6 Medicare and Medicaid false LANSING OPCO LLC 04/01/1976 false   false false false Resident Yes 4   2   5   4   5   5   5       2.72275 0.40564 1.30609 1.71173 4.43449 0.07177 1.90557 0.64964 0.29917 2.85438 2.96961 0.46952 1.64319 4.98179 03/27/2019 7 7 0 40 1 0 40 04/19/2018 22 13 9 156 2 78 234 2017-01-25 23 19 4 2 188 94 282 145 6 14 0 0.00 0 0 731 STARKWEATHER DR LANSING, MI 48917 (42.742509, -84.654365) 02/01/2020
4402 4402 805 WEST AVE BIG RAPIDS, MI 49307 43.713086 -85.497882 0   235459 ALTERCARE OF BIG RAPIDS CTR FOR REHAB & NURSING CA 805 WEST AVE BIG RAPIDS MI 49307 2317963185 530 Mecosta For profit - Corporation 100 78.5 Medicare and Medicaid false ALTERCARE OF BIG RAPIDS CENTER FOR REHABILITATION & NURSING CARE, INC. 01/15/1987 false   false false false Resident Yes 4   2   5   5   5   4   5       2.26094 0.41893 1.10451 1.52344 3.78437 0.031 2.0624 0.65171 0.31196 3.02607 2.27841 0.48336 1.33262 4.01023 02/05/2019 4 3 1 36 2 18 54 12/08/2017 13 10 3 76 2 38 114 2016-12-07 23 20 3 2 204 102 306 116 6 15 0 0.00 1 1 805 WEST AVE BIG RAPIDS, MI 49307 (43.713086, -85.497882) 02/01/2020
6124 6124 702 CEDAR AVENUE LAUREL, NE 68745 42.423061 -97.088586 0   285178 HILLCREST CARE CENTER 702 CEDAR AVENUE LAUREL NE 68745 4022563961 130 Cedar Government - City 36 24.6 Medicare and Medicaid false HILLCREST CARE CENTER 02/01/1996 false   false false false Resident Yes 4   3   4   4     2 5   5       2.9243 0.97521 0.77512 1.75033 4.67463 0.03132 2.05496 0.62011 0.24602 2.92108 2.95757 1.18254 1.18585 5.13165 03/25/2019 8 8 5 60 1 0 60 01/09/2018 7 6 1 36 1 0 36 2016-10-04 6 6 0 1 28 0 28 46.667 6 2 0 0.00 0 0 702 CEDAR AVENUE LAUREL, NE 68745 (42.423061, -97.088586) 02/01/2020
6539 6539 6700 WESTSIDE SAGINAW ROAD BAY CITY, MI 48706 43.543699 -83.961082 0   235635 CARETEL INNS OF TRI-CITIES 6700 WESTSIDE SAGINAW ROAD BAY CITY MI 48706 9896679800 80 Bay For profit - Corporation 60 25.2 Medicare false WOOD CARE VIII INC 10/25/2007 false   false false false Resident Yes 4   3   3     2 3   5   5       2.83718 1.02284 2.03244 3.05528 5.89246 0.1773 2.27349 1.05576 0.57425 3.9035 2.59364 0.7285 1.33213 4.84056 03/28/2019 9 7 2 92 1 0 92 04/30/2018 10 8 2 88 1 0 88 2017-03-09 10 10 0 1 64 0 64 86 6 3 1 16016.00 0 1 6700 WESTSIDE SAGINAW ROAD BAY CITY, MI 48706 (43.543699, -83.961082) 02/01/2020
7075 7075 1425 LAUREL AVENUE POMONA, CA 91767 34.06386 -117.773563 0   05A137 LAUREL PARK BEHAVIORAL HEALTH CENTER 1425 LAUREL AVENUE POMONA CA 91767 9096221069 200 Los Angeles For profit - Corporation 43 43 Medicaid false Legal Business Name Not Available 02/01/1975 false   false false false Resident Yes 4   3   5   5     2 2   2       1.55928 0.73345 0.2276 0.96106 2.52033 0 1.28757 0.53745 0.23684 2.06186 2.51691 1.02617 0.3617 3.91969 10/04/2019 15 14 1 60 1 0 60 10/30/2018 9 8 1 56 1 0 56 2017-10-14 11 10 2 1 52 0 52 57.333 6 0 0 0.00 0 0 1425 LAUREL AVENUE POMONA, CA 91767 (34.06386, -117.773563) 02/01/2020
7573 7573 1949 GRANT ROAD MOUNTAIN VIEW, CA 94040 37.373416 -122.077722 0   55315 GRANT CUESTA SUB-ACUTE AND REHABILITATION CENTER 1949 GRANT ROAD MOUNTAIN VIEW CA 94040 6509682990 530 Santa Clara For profit - Corporation 102 96.4 Medicare and Medicaid false COVENANT CARE CALIFORNIA, LLC 01/01/1979 false   false false false Resident Yes 4   2   5   5   5   4   5       2.31409 0.41136 1.13553 1.5469 3.86098 0.13414 2.08317 0.74702 0.36189 3.19207 2.30871 0.41407 1.18103 3.87863 08/16/2019 22 16 6 92 1 0 92 07/19/2018 13 9 4 52 1 0 52 2017-07-20 18 11 8 1 72 0 72 75.333 6 9 0 0.00 0 0 1949 GRANT ROAD MOUNTAIN VIEW, CA 94040 (37.373416, -122.077722) 02/01/2020
8038 8038 700 FOULK ROAD WILMINGTON, DE 19803 39.788146 -75.534211 0   85028 MANORCARE HEALTH SERVICES - WILMINGTON 700 FOULK ROAD WILMINGTON DE 19803 3027640181 10 New Castle Non profit - Other 138 119.8 Medicare and Medicaid false MANOR CARE OF WILMINGTON DE LLC 07/23/1984 false   false false false Resident Yes 4   2   5   4   5   4   4       1.90303 1.03001 0.77202 1.80203 3.70506 0.10631 2.10299 0.74344 0.34602 3.19245 1.88071 1.04179 0.83976 3.72155 11/25/2019 9 5 4 56 1 0 56 10/02/2018 24 18 6 241 1 0 241 2017-08-17 14 14 0 1 60 0 60 118.333 6 13 1 41662.00 0 1 700 FOULK ROAD WILMINGTON, DE 19803 (39.788146, -75.534211) 02/01/2020
9847 9847 5601 S ORCHARD STREET TACOMA, WA 98409 47.205657 -122.50462 0   505289 MANOR CARE OF TACOMA WA, LLC 5601 S ORCHARD STREET TACOMA WA 98409 2534748421 260 Pierce Non profit - Other 124 86.5 Medicare and Medicaid false MANOR CARE OF TACOMA WA LLC 07/01/1984 false   false false false Resident Yes 4   2   5   5   5   5   5       2.19652 0.76029 1.12867 1.88895 4.08547 0.10007 2.00853 0.73354 0.34181 3.08388 2.27286 0.77936 1.24283 4.24813 03/15/2019 31 16 15 192 1 0 192 01/12/2018 25 8 17 108 1 0 108 2017-01-24 13 7 6 1 68 0 68 143.333 6 38 2 81884.00 0 2 5601 S ORCHARD STREET TACOMA, WA 98409 (47.205657, -122.50462) 02/01/2020
10093 10093 1045 SOUTH 308TH STREET FEDERAL WAY, WA 98003 47.326024 -122.319324 0   505188 LIFE CARE CENTER OF FEDERAL WAY 1045 SOUTH 308TH STREET FEDERAL WAY WA 98003 2539462273 160 King For profit - Limited Liability company 93 91.5 Medicare and Medicaid false CONSOLIDATED RESOURCES HEALTH CARE FUND I, L.P. 09/17/1968 false   false false false Resident Yes 4   2   5   5   4   4   4       2.30906 0.76583 0.64936 1.41519 3.72425 0.1084 2.12839 0.72282 0.32657 3.17777 2.25476 0.79668 0.74842 3.75811 05/23/2019 28 26 2 160 1 0 160 03/22/2018 28 26 3 160 1 0 160 2016-11-22 21 13 8 1 160 0 160 160 6 8 1 16595.00 0 1 1045 SOUTH 308TH STREET FEDERAL WAY, WA 98003 (47.326024, -122.319324) 02/01/2020
11326 11326 800 NORTH MEDCALF MONTESANO, WA 98563 46.988672 -123.585824 0   505503 MONTESANO HEALTH & REHABILITATION 800 NORTH MEDCALF MONTESANO WA 98563 3602492273 130 Grays Harbor For profit - Corporation 94 81.8 Medicare and Medicaid false 800 MEDCALF LANE NORTH OPERATIONS LLC 07/23/1997 false   false false false None Yes 4   4   4   4   4   3   3       1.98273 0.83766 0.55113 1.3888 3.37152 0.1395 2.14767 0.7914 0.39123 3.3303 1.91872 0.7959 0.53022 3.24635 03/25/2019 9 0 9 36 1 0 36 04/22/2018 7 5 2 32 1 0 32 2017-05-12 17 7 12 1 120 0 120 48.667 6 16 2 30907.00 0 2 800 NORTH MEDCALF MONTESANO, WA 98563 (46.988672, -123.585824) 02/01/2020
11564 11564 262 POPLAR STREET WOONSOCKET, RI 02895 42.008072 -71.48806 0   415041 WOONSOCKET HEALTH CENTRE 262 POPLAR STREET WOONSOCKET RI 2895 4017652100 30 Providence For profit - Corporation 150 123.5 Medicare and Medicaid false CON-V-CARE, INC 06/26/1975 false   false false false Both Yes 4   2   5   5   5   4   4       2.27315 0.33084 0.77634 1.10718 3.38034 0.04578 1.83679 0.62862 0.29363 2.75904 2.57208 0.39574 0.99513 3.92875 07/31/2019 5 5 5 40 1 0 40 09/17/2018 1 1 1 20 1 0 20 2017-07-31 0 0 0 0 0 0 0 26.667 6 1 1 6893.00 0 1 262 POPLAR STREET WOONSOCKET, RI 02895 (42.008072, -71.48806) 02/01/2020
13192 13192 3830 MUSTANG ROAD ALVIN, TX 77511 29.389041 -95.235784 0   675495 LAUREL COURT 3830 MUSTANG ROAD ALVIN TX 77511 2815858484 180 Brazoria For profit - Corporation 125 79.9 Medicare and Medicaid false SWEENY HOSPITAL DISTRICT 06/12/1995 false   false false false Resident Yes 4   4   3   3   4   2   2       1.69289 1.17944 0.39365 1.57309 3.26597 0.13369 2.01911 0.80486 0.41483 3.23881 1.74254 1.10189 0.35717 3.23356 01/18/2019 3 1 2 16 1 0 16 02/16/2018 5 0 5 40 0 0 40 2017-04-06 3 3 0 1 32 0 32 26.667 6 4 0 0.00 0 0 3830 MUSTANG ROAD ALVIN, TX 77511 (29.389041, -95.235784) 02/01/2020
13591 13591 895 POWERS BLVD WAVERLY, TN 37185 36.102536 -87.782135 0   445251 AHC WAVERLY 895 POWERS BLVD WAVERLY TN 37185 9312967552 420 Humphreys For profit - Corporation 100 54.8 Medicare and Medicaid false WAVERLY HEALTH CARE AND REHABILITATION CENTER INC 04/09/1990 false   false false false Both Yes 4   5   1   1   3   4   3       2.33261 1.23983 0.5069 1.74673 4.07933 0.05204 1.97762 0.67035 0.30084 2.94881 2.4514 1.39074 0.63418 4.43604 09/11/2019 0 0 0 0 0 0 0 10/17/2018 4 4 0 16 1 0 16 2017-11-01 0 0 0 0 0 0 0 5.333 6 0 0 0.00 0 0 895 POWERS BLVD WAVERLY, TN 37185 (36.102536, -87.782135) 02/01/2020
13698 13698 1150 WEST FAIRVIEW ROAD COLFAX, WA 99111 46.869634 -117.374179 0   505251 WHITMAN HEALTH & REHAB CENTER 1150 WEST FAIRVIEW ROAD COLFAX WA 99111 5093974603 370 Whitman For profit - Corporation 55 36.7 Medicare and Medicaid false EVERGREEN WASHINGTON HEALTHCARE WHITMAN, L.L.C. 12/15/1977 false   false false false Resident Yes 4   4   4   4   4   4   4       2.18883 0.46423 1.2209 1.68513 3.87396 0.18219 2.0792 0.85579 0.44186 3.37685 2.18792 0.4079 1.03999 3.67872 08/05/2019 18 15 3 96 1 0 96 09/27/2018 11 7 4 72 1 0 72 2017-08-15 5 4 1 1 40 0 40 78.667 6 3 0 0.00 0 0 1150 WEST FAIRVIEW ROAD COLFAX, WA 99111 (46.869634, -117.374179) 02/01/2020
14634 14634 17121 EIGHTH AVENUE SPOKANE VALLEY, WA 99016 47.649615 -117.172948 0   505099 GOOD SAMARITAN SOCIETY - SPOKANE VALLEY EAST 17121 EIGHTH AVENUE SPOKANE VALLEY WA 99016 5099246161 310 Spokane Non profit - Corporation 97 88.2 Medicare and Medicaid false THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY 01/01/1967 true   false false false Resident Yes 4   3   3   2   5   5   5       2.56277 0.54432 1.18138 1.7257 4.28847 0.08714 2.16238 0.69144 0.30893 3.16275 2.46316 0.59195 1.43933 4.34801 08/21/2019 8 8 0 32 1 0 32 07/23/2018 23 14 11 183 1 0 183 2017-04-26 11 11 0 1 52 0 52 85.667 6 3 2 37544.00 0 2 17121 EIGHTH AVENUE SPOKANE VALLEY, WA 99016 (47.649615, -117.172948) 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
);