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

29 rows where Number of Fines = 5

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_city, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, Provider Resides in Hospital, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, 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 Physical Therapist Staffing Hours per Resident Per Day, Rating Cycle 1 Standard Survey Health Date, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 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 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, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Payment Denials, Total Number of Penalties, Location, Rating Cycle 3 Standard Health Survey Date (date)

Number of Fines ✖

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
188 188 3200 STATE ST SAGINAW, MI 48602 43.436632 -83.985897 0   235250 SAMARITAS SENIOR LIVING SAGINAW 3200 STATE ST SAGINAW MI 48602 9897991902 720 Saginaw Non profit - Church related 98 58.8 Medicare and Medicaid false SAMARITAS - LUTHERAN SOCIAL SERVICES OF MICHIGAN 12/01/1975 false SFF Candidate true false false Resident Yes 1   1   2   1   4   3   2       2.56619 1.3568 0.44244 1.79924 4.36543 0.09823 2.135 0.79244 0.39171 3.31915 2.49808 1.28745 0.42513 4.21748 04/25/2019 30 17 14 307 1 0 307 06/06/2018 24 10 14 359 2 180 539 2017-03-23 25 15 11 1 188 0 188 364.5 28 39 5 191846.00 2 7 3200 STATE ST SAGINAW, MI 48602 (43.436632, -83.985897) 02/01/2020
1359 1359 4220 S HOSPITAL DR EAST CHINA, MI 48054 42.784762 -82.480005 0   235370 MEDILODGE OF ST CLAIR 4220 S HOSPITAL DR EAST CHINA MI 48054 8103294736 730 St. Clair For profit - Corporation 172 119.8 Medicare and Medicaid false ST. CLAIR OPCO, LLC 11/01/1978 false   false false false Resident Yes 2   2   4   4   4   3   3       2.0244 0.90788 0.49426 1.40214 3.42654 0.04455 1.96803 0.73544 0.35288 3.05635 2.13786 0.92825 0.52717 3.59505 10/30/2019 16 7 11 108 1 0 108 12/20/2018 14 7 7 92 1 0 92 2017-09-20 24 6 19 1 196 0 196 117.333 10 58 5 81548.00 0 5 4220 S HOSPITAL DR EAST CHINA, MI 48054 (42.784762, -82.480005) 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
1671 1671 222 RIVER ROAD LEEDS, MA 01053 42.359791 -72.701416 0   225466 HIGHVIEW OF NORTHAMPTON 222 RIVER ROAD LEEDS MA 1053 4135848457 80 Hampshire For profit - Corporation 120 92.5 Medicare and Medicaid false LEEDS MA SNF LLC 07/01/1990 false   false false false Resident Yes 2   1   4   4   3   4   3       2.46735 0.82767 0.50791 1.33558 3.80293 0.06603 1.78928 0.62854 0.2839 2.70172 2.86595 0.99016 0.67336 4.51367 09/20/2019 15 11 4 104 1 0 104 06/07/2018 30 19 11 302 2 151 453 2017-04-13 11 5 6 1 92 0 92 218.333 6 6 5 163741.00 0 5 222 RIVER ROAD LEEDS, MA 01053 (42.359791, -72.701416) 02/01/2020
2941 2941 33904 US Hwy 63, Marked Tree, AR 72365, USA 35.5266218 -90.4375834 1 ROOFTOP 45391 THREE RIVERS HEALTHCARE AND REHABILITATION 33904 HIGHWAY 63 E MARKED TREE AR 72365 8703582432 550 Poinsett For profit - Limited Liability company 110 102.6 Medicare and Medicaid false THREE RIVERS NURSING AND REHABILITATION LLC 11/29/2003 false   false false false Resident Yes 2   2   2   4   1   2   1       2.78557 0.94506 0.22225 1.16731 3.95288 0.0426 2.15407 0.71269 0.30658 3.17335 2.68763 0.99711 0.27285 3.99438 09/27/2019 4 4 0 32 1 0 32 10/19/2018 6 2 4 52 1 0 52 2017-08-11 8 2 6 1 260 0 260 76.667 3 4 5 85802.00 0 5   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
5566 5566 2475 WINNE AVE HELENA, MT 59601 46.581443 -111.99859 0   275044 BIG SKY CARE CENTER 2475 WINNE AVE HELENA MT 59601 4064421350 240 Lewis And Clark For profit - Limited Liability company 108 39.6 Medicare and Medicaid false KISMET HLN2, LLC 09/18/1973 false SFF Candidate true false false Resident Yes 1   1   3   2   4   3   3       1.96163 1.01019 0.49752 1.50771 3.46934 0.04447 1.97381 0.73271 0.33678 3.0433 2.06551 1.0367 0.55603 3.65558 02/21/2019 34 23 22 311 1 0 311 12/11/2017 29 22 9 349 1 0 349 2016-12-14 9 9 0 1 60 0 60 281.833 1 15 5 209556.00 0 5 2475 WINNE AVE HELENA, MT 59601 (46.581443, -111.99859) 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
6849 6849 309 RAILROAD STREET HULL, IA 51239 43.186844 -96.143408 0   165248 PLEASANT ACRES CARE CENTER 309 RAILROAD STREET HULL IA 51239 7124392758 830 Sioux For profit - Corporation 60 42.5 Medicare and Medicaid false PREMIER ESTATES 505, LLC 01/01/1995 false SFF Candidate false false false Both Yes 1   1   3   3   4   3   4       1.89848 0.23222 0.67873 0.91096 2.80944 0.01788 1.88515 0.65432 0.31708 2.85655 2.09303 0.26687 0.80568 3.15378 10/24/2019 22 18 6 187 1 0 187 08/16/2018 27 8 19 140 1 0 140 2017-05-11 16 2 14 1 175 0 175 169.333 8 34 5 140200.00 2 7 309 RAILROAD STREET HULL, IA 51239 (43.186844, -96.143408) 02/01/2020
7358 7358 1955 S VERNON ST WABASH, IN 46992 40.778459 -85.82917 0   155810 VERNON HEALTH & REHABILITATION 1955 S VERNON ST WABASH IN 46992 2605638438 840 Wabash Non profit - Corporation 119 65.3 Medicare and Medicaid false PUTNAM COUNTY HOSPITAL 10/12/2013 false   true false false Resident Yes 1   1   4   4     2 1 12 1 12     3.17714 0.7453 0.41295 1.15824 4.33539 0.01254 2.36635 0.90516 0.46627 3.73778 2.79045 0.61914 0.33334 3.71935 10/11/2019 9 2 7 44 1 0 44 04/26/2019 11 7 4 294 1 0 294 2018-11-15 11 8 3 1 255 0 255 162.5 9 10 5 220658.00 0 5 1955 S VERNON ST WABASH, IN 46992 (40.778459, -85.82917) 02/01/2020
7731 7731 10040 HILLVIEW ROAD PENSACOLA, FL 32514 30.540282 -87.217787 0   105445 UNIVERSITY HILLS HEALTH AND REHABILITATION 10040 HILLVIEW ROAD PENSACOLA FL 32514 8504740570 160 Escambia For profit - Corporation 120 110 Medicare and Medicaid false 10040 HILLVIEW ROAD OPERATIONS LLC 01/03/1984 false SFF Candidate false false false Both Yes 1   1   4   3   5   3   2       2.65994 0.92309 0.41513 1.33822 3.99816 0.04889 1.85148 0.67801 0.32229 2.85177 2.98586 1.02375 0.48481 4.49572 04/19/2019 22 10 12 200 2 100 300 04/27/2018 8 8 0 32 1 0 32 2017-05-11 14 4 10 1 140 0 140 184 1 19 5 236871.00 3 8 10040 HILLVIEW ROAD PENSACOLA, FL 32514 (30.540282, -87.217787) 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
7899 7899 5211 MARSH RD OKEMOS, MI 48864 42.732497 -84.41105 0   235647 MEDILODGE OF OKEMOS 5211 MARSH RD OKEMOS MI 48864 5173191400 320 Ingham For profit - Limited Liability company 100 66.5 Medicare and Medicaid false OKEMOS OPCO LLC 10/09/2009 false   false false false Resident Yes 2   1   4   4   5   5   5       2.62852 0.69587 1.40245 2.09832 4.72683 0.0713 2.10324 0.73004 0.34679 3.18007 2.5974 0.71675 1.52211 4.76636 03/13/2019 22 18 6 148 1 0 148 01/19/2018 28 17 15 204 1 0 204 2016-10-27 20 16 4 2 148 74 222 179 8 21 5 112906.00 0 5 5211 MARSH RD OKEMOS, MI 48864 (42.732497, -84.41105) 02/01/2020
8098 8098 43533 ELIZABETH RD MOUNT CLEMENS, MI 48043 42.617368 -82.887711 0   235155 MARTHA T BERRY MCF 43533 ELIZABETH RD MOUNT CLEMENS MI 48043 5864695265 490 Macomb Government - County 217 206.4 Medicare and Medicaid false COUNTY OF MACOMB 04/22/1968 false   false false false Both Yes 2   1   2   4   1   4   3       3.13098 1.3947 0.45013 1.84483 4.97581 0.01989 2.13055 0.7132 0.32412 3.16787 3.05424 1.47047 0.52271 5.03674 04/04/2019 15 14 2 104 1 0 104 02/09/2018 25 20 5 235 1 0 235 2017-05-17 24 16 8 1 346 0 346 188 13 16 5 146483.00 2 7 43533 ELIZABETH RD MOUNT CLEMENS, MI 48043 (42.617368, -82.887711) 02/01/2020
8355 8355 750 FULLER AVE NE GRAND RAPIDS, MI 49503 42.976109 -85.639838 0   235075 SPECTRUM HEALTH REHAB & NURSING CENTER-FULLER AVE 750 FULLER AVE NE GRAND RAPIDS MI 49503 6164863001 400 Kent Non profit - Corporation 250 195.6 Medicare and Medicaid true SPECTRUM HEALTH HOSPITALS 01/03/1967 false   false false false Resident Yes 3   2   3   2   4   5   5       2.80919 1.00551 1.18789 2.19339 5.00258 0.2847 2.05067 0.70146 0.32525 3.07738 2.84709 1.07787 1.37464 5.21274 10/30/2019 18 8 10 116 0 0 116 08/30/2018 20 17 4 136 1 0 136 2017-10-12 29 11 19 1 260 0 260 146.667 40 47 5 166739.00 2 7 750 FULLER AVE NE GRAND RAPIDS, MI 49503 (42.976109, -85.639838) 02/01/2020
9512 9512 820 NORTHWEST 95TH STREET SEATTLE, WA 98117 47.697847 -122.367086 0   505042 BALLARD CENTER 820 NORTHWEST 95TH STREET SEATTLE WA 98117 2067820100 160 King For profit - Corporation 142 116 Medicare and Medicaid false SUNBRIDGE HEALTHCARE LLC 01/01/1967 false SFF Candidate false false false Resident Yes 2   1   4   3   4   4   4       2.2273 0.43912 0.9109 1.35002 3.57732 0.08494 2.09438 0.71577 0.33344 3.14358 2.21024 0.46131 1.02823 3.64911 11/07/2018 39 32 10 530 1 0 530 11/03/2017 30 24 6 338 1 0 338 2016-08-04 19 13 6 1 140 0 140 401 10 19 5 138415.00 0 5 820 NORTHWEST 95TH STREET SEATTLE, WA 98117 (47.697847, -122.367086) 02/01/2020
9625 9625 555 16TH AVENUE SEATTLE, WA 98122 47.607477 -122.311546 0   505311 SEATTLE MEDICAL POST ACUTE CARE 555 16TH AVENUE SEATTLE WA 98122 2063248200 160 King For profit - Corporation 103 88.5 Medicare and Medicaid false EVERGREEN WASHINGTON HEALTHCARE SEATTLE, L.L.C. 04/03/1987 false   false false false Resident Yes 1   1   3   4   3   2   1       2.97254 1.14137 0.67517 1.81654 4.78908 0.01387 2.23535 0.92034 0.84355 3.99924 2.76374 0.93254 0.30125 3.83997 03/13/2019 22 21 1 188 1 0 188 02/20/2018 17 11 6 278 1 0 278 2016-11-01 14 11 3 1 372 0 372 248.667 7 4 5 63706.00 0 5 555 16TH AVENUE SEATTLE, WA 98122 (47.607477, -122.311546) 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
10362 10362 1500 3RD AVENUE LONGVIEW, WA 98632 46.137485 -122.921385 0   505276 FRONTIER REHAB & EXTENDED CARE 1500 3RD AVENUE LONGVIEW WA 98632 3604238800 70 Cowlitz For profit - Corporation 140 100.6 Medicare and Medicaid false EVERGREEN WASHINGTON HEALTHCARE FRONTIER, L.L.C. 07/01/1983 false   false false false Both Yes 1   2   4   5   2   1 12 1 12     2.43929 0.61548 0.56833 1.18381 3.6231 0.11996 2.0703 0.75201 0.36068 3.18299 2.44876 0.61542 0.59306 3.65004 09/24/2019 26 21 5 200 1 0 200 08/13/2018 36 29 7 236 1 0 236 2017-07-18 16 13 3 1 152 0 152 204 7 7 5 116035.00 0 5 1500 3RD AVENUE LONGVIEW, WA 98632 (46.137485, -122.921385) 02/01/2020
10777 10777 16357 AURORA AVENUE NORTH SHORELINE, WA 98133 47.748091 -122.345577 0   505214 THE OAKS AT FOREST BAY 16357 AURORA AVENUE NORTH SHORELINE WA 98133 2065423103 160 King For profit - Limited Liability company 90 64 Medicare and Medicaid false AURORA OAKS LLC 09/01/1971 false SFF Candidate true false false Resident Yes 2   1   4   3   4   4   4       2.05148 0.62997 0.81384 1.44382 3.4953 0.01319 2.06115 0.71059 0.33244 3.10418 2.06859 0.66663 0.92143 3.61069 03/11/2019 47 38 17 558 2 279 837 01/25/2018 53 39 14 562 1 0 562 2017-02-24 27 16 11 1 439 0 439 679 18 28 5 111142.00 0 5 16357 AURORA AVENUE NORTH SHORELINE, WA 98133 (47.748091, -122.345577) 02/01/2020
10905 10905 21400 72ND AVENUE WEST EDMONDS, WA 98026 47.804558 -122.330144 0   505236 ALDERCREST HEALTH & REHAB CENTER 21400 72ND AVENUE WEST EDMONDS WA 98026 4257751961 300 Snohomish For profit - Corporation 128 86 Medicare and Medicaid false ALDERCREST HEALTH - EDMONDS, LLC 08/01/1977 false   true false false Resident Yes 1   1   2   2   2   3   3       1.59608 1.16099 0.63838 1.79937 3.39545 0.02935 2.1984 0.75566 0.36009 3.31415 1.50891 1.15528 0.66726 3.28532 09/13/2019 40 25 16 280 1 0 280 07/19/2018 27 20 9 180 2 90 270 2017-08-02 26 16 13 1 208 0 208 264.667 14 37 5 130469.00 0 5 21400 72ND AVENUE WEST EDMONDS, WA 98026 (47.804558, -122.330144) 02/01/2020
11422 11422 2702 FARRELL ROAD SANFORD, NC 27330 35.568944 -79.125356 0   345534 SANFORD HEALTH & REHABILITATION CO 2702 FARRELL ROAD SANFORD NC 27330 9197769602 520 Lee For profit - Corporation 131 117.4 Medicare and Medicaid false SANFORD HEALTH AND REHABILITATION CO LLC 06/08/2005 false SFF Candidate true false false Resident Yes 1   1   2   2   2   1   1       2.21078 0.98156 0.29411 1.27567 3.48645 0 2.21756 0.84837 0.46482 3.53075 2.07198 0.86999 0.23816 3.16643 08/08/2019 10 6 4 92 1 0 92 08/09/2018 25 14 15 508 1 0 508 2017-08-17 9 3 6 1 60 0 60 225.333 4 17 5 444928.00 2 7 2702 FARRELL ROAD SANFORD, NC 27330 (35.568944, -79.125356) 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
11692 11692 311 NORTHEAST 3RD STREET COUPEVILLE, WA 98239 48.215676 -122.681392 0   505309 CAREAGE OF WHIDBEY 311 NORTHEAST 3RD STREET COUPEVILLE WA 98239 3606782273 140 Island For profit - Individual 112 54.6 Medicare and Medicaid false RON HAYES & ASSOCIATES INC 01/27/1987 false SFF Candidate true false false Resident Yes 2   1   3   3   3   4   4       2.76045 1.43443 0.66318 2.09761 4.85806 0 2.19893 0.74828 0.3229 3.2701 2.60906 1.44144 0.77304 4.76381 02/14/2019 42 40 12 540 2 270 810 01/17/2018 40 38 2 248 2 124 372 2016-10-21 29 22 7 1 216 0 216 565 9 6 5 175295.00 0 5 311 NORTHEAST 3RD STREET COUPEVILLE, WA 98239 (48.215676, -122.681392) 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
13212 13212 430 LILLY ROAD NORTHEAST OLYMPIA, WA 98506 47.053145 -122.844368 0   505243 OLYMPIA TRANSITIONAL CARE AND REHABILITATION 430 LILLY ROAD NORTHEAST OLYMPIA WA 98506 3604919700 330 Thurston For profit - Corporation 135 81.4 Medicare and Medicaid false WOODARD CREEK HEALTHCARE INC 07/07/1976 false   false false false Resident Yes 1   1   2   2   2   3   3       2.42878 1.05415 0.55354 1.60769 4.03648 0.06538 2.11565 0.77913 0.39668 3.29146 2.38595 1.01736 0.52522 3.93248 09/09/2019 13 10 3 68 1 0 68 10/09/2018 32 22 11 192 1 0 192 2017-12-15 44 29 24 1 869 0 869 242.833 12 25 5 226646.00 0 5 430 LILLY ROAD NORTHEAST OLYMPIA, WA 98506 (47.053145, -122.844368) 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
14150 14150 1103 WEST CHEROKEE LINDSAY, OK 73052 34.837492 -97.620786 0   375206 LINDSAY NURSING & REHAB 1103 WEST CHEROKEE LINDSAY OK 73052 4057564334 240 Garvin For profit - Individual 106 49.2 Medicare and Medicaid false LINDSAY NURSING & REHABILITATION LLC 02/01/1995 false   false false false Resident Yes 1   1   3   3     2 3   3       1.8332 0.8353 0.3904 1.22571 3.05891 0.00562 1.58452 0.61732 0.28879 2.49063 2.40452 1.01747 0.50882 3.93832 09/05/2019 6 6 0 56 1 0 56 06/27/2018 34 15 19 487 1 0 487 2017-05-01 14 3 11 1 140 0 140 213.667 1 16 5 142019.00 3 8 1103 WEST CHEROKEE LINDSAY, OK 73052 (34.837492, -97.620786) 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
);