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

33 rows where Most Recent Health Inspection More Than 2 Years Ago = "true"

✎ 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, avg_residents, prvdr_type, Legal Business Name, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, With a Resident and Family Council, Overall Rating, Health Inspection Rating, 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, 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, Rating Cycle 3 Standard Health Survey Date (date)

Most Recent Health Inspection More Than 2 Years Ago ✖

  • true · 33 ✖
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
34 34 736 HEYLMAN STREET FORT SCOTT, KS 66701 37.832805 -94.71812 0   175384 FORT SCOTT MANOR 736 HEYLMAN STREET FORT SCOTT KS 66701 6202233120 50 Bourbon For profit - Corporation 45   Medicare and Medicaid false Legal Business Name Not Available 08/01/1996 false SFF Candidate false true false Resident Yes 1   1     2   2   2 1 12 1 12 6 6                             10/30/2017 15 15 14 116 2 58 174 03/18/2016 26 16 10 349 2 175 524 2014-12-05 17 16 1 1 128 0 128 283 4 5 0 0.00 2 2 736 HEYLMAN STREET FORT SCOTT, KS 66701 (37.832805, -94.71812) 02/01/2020
68 68 1170 LINKHAW ROAD LUMBERTON, NC 28358 34.644218 -78.989713 0   345315 HIGHLAND ACRES NURSING AND REHABILITATION CENTER 1170 LINKHAW ROAD LUMBERTON NC 28358 9106711163 770 Robeson For profit - Corporation 90   Medicare and Medicaid false MAPLE LTC GROUP, LLC 04/05/1990 false   false true false Both Yes 3   4   1   2   1     2   2 6 6                             01/25/2018 5 5 1 32 1 0 32 01/27/2017 0 0 0 0 0 0 0 2016-03-11 0 0 0 0 0 0 0 16 0 1 0 0.00 0 0 1170 LINKHAW ROAD LUMBERTON, NC 28358 (34.644218, -78.989713) 02/01/2020
141 141 271 NAHANT ROAD NAHANT, MA 01908 42.425947 -70.91972 0   225471 JESMOND NURSING HOME 271 NAHANT ROAD NAHANT MA 1908 7815810420 40 Essex For profit - Corporation 57 50.6 Medicare and Medicaid false WELLESLEY HEALTHCARE SOLUTIONS LLC 07/01/1990 false   false true false Resident Yes 2   2   4   5   3   2   2       2.12632 0.68886 0.39464 1.08349 3.20981 0.01144 2.19629 0.73896 0.31851 3.25377 2.01212 0.70096 0.46634 3.16334 12/07/2017 13 13 0 72 1 0 72 02/17/2017 4 4 0 16 1 0 16 2016-03-24 0 0 0 0 0 0 0 41.333 0 0 0 0.00 0 0 271 NAHANT ROAD NAHANT, MA 01908 (42.425947, -70.91972) 02/01/2020
1165 1165 531 STEVENSON LANE TOWSON, MD 21286 39.384138 -76.6037 0   215204 HOLLY HILL HEALTHCARE CENTER 531 STEVENSON LANE TOWSON MD 21286 4108235310 20 Baltimore For profit - Corporation 75 69.7 Medicare and Medicaid false HOLLY HILL NURSING, LLC 06/01/1989 true   false true false Both Yes 3   2   3   3   3   4   4       2.09463 0.83562 0.91426 1.74988 3.84452 0.07574 2.17655 0.807 0.42726 3.4108 2.00012 0.77861 0.80539 3.61441 12/13/2017 23 17 7 88 1 0 88 12/02/2016 23 9 14 144 1 0 144 2015-09-21 16 15 1 1 92 0 92 107.333 6 14 0 0.00 0 0 531 STEVENSON LANE TOWSON, MD 21286 (39.384138, -76.6037) 02/01/2020
1707 1707 184 MAIN STREET FAIRHAVEN, MA 02719 41.646205 -70.908388 0   225117 ROYAL OF FAIRHAVEN NURSING CENTER 184 MAIN STREET FAIRHAVEN MA 2719 5089973193 20 Bristol For profit - Partnership 100 81.8 Medicare and Medicaid false Legal Business Name Not Available 11/01/1970 false   false true false Resident Yes 5   4   5   5   5   2   2       2.00466 1.00027 0.36428 1.36455 3.36921 0.07214 2.05775 0.65299 0.30742 3.01816 2.02472 1.15185 0.446 3.57964 06/29/2017 0 0 0 0 1 0 0 04/13/2016 6 5 1 56 1 0 56 2015-02-11 2 1 1 1 12 0 12 20.667 1 0 1 6125.00 0 1 184 MAIN STREET FAIRHAVEN, MA 02719 (41.646205, -70.908388) 02/01/2020
1860 1860 5 REDLANDS ROAD W ROXBURY, MA 02132 42.287639 -71.151199 0   225429 STONEHEDGE HEALTH CARE CENTER 5 REDLANDS ROAD W ROXBURY MA 2132 6173276325 160 Suffolk For profit - Corporation 79 76.5 Medicare and Medicaid false STONEHEDGE MA SNF LLC 07/01/1990 false   false true false Resident Yes 1   2   1   1   2   2   2       1.98346 0.81464 0.31582 1.13047 3.11393 0.14636 2.00643 0.67071 0.29834 2.97548 2.05455 0.9133 0.39844 3.35586 10/17/2017 20 19 5 116 1 0 116 12/07/2016 3 3 0 12 1 0 12 2015-12-23 5 3 2 1 24 0 24 66 0 3 1 71689.00 0 1 5 REDLANDS ROAD W ROXBURY, MA 02132 (42.287639, -71.151199) 02/01/2020
1956 1956 260 EASTHAMPTON ROAD HOLYOKE, MA 01040 42.225911 -72.646613 0   225236 CARE ONE AT HOLYOKE 260 EASTHAMPTON ROAD HOLYOKE MA 1040 4135389733 70 Hampden For profit - Corporation 164 156.9 Medicare and Medicaid false 260 EASTHAMPTON ROAD OPERATING COMPANY LLC 06/26/1975 false   false true false Resident Yes 5   5   2   4   1   3   3       1.89308 0.90123 0.49013 1.39136 3.28444 0.03148 1.57937 0.59365 0.26958 2.4426 2.49117 1.14154 0.6843 4.31184 01/18/2018 2 2 0 8 1 0 8 11/18/2016 3 3 0 12 1 0 12 2015-09-15 0 0 0 0 0 0 0 8 0 0 0 0.00 0 0 260 EASTHAMPTON ROAD HOLYOKE, MA 01040 (42.225911, -72.646613) 02/01/2020
2079 2079 750 DUAL HIGHWAY HAGERSTOWN, MD 21740 39.635491 -77.705618 0   215336 HAGERSTOWN HEALTHCARE CENTER 750 DUAL HIGHWAY HAGERSTOWN MD 21740 3017974020 210 Washington For profit - Corporation 140 108.8 Medicare and Medicaid false DUAL LEASING CO., LLC 11/06/2000 false SFF Candidate false true false Resident Yes 1   1   2   2   2   2   2       1.8632 0.76238 0.50831 1.27069 3.13389 0.10726 2.15639 0.87137 0.46951 3.49726 1.79576 0.65789 0.40749 2.87348 10/26/2017 54 15 53 443 1 0 443 09/20/2016 50 25 25 348 1 0 348 2015-07-17 12 9 3 1 52 0 52 346.167 2 26 0 0.00 1 1 750 DUAL HIGHWAY HAGERSTOWN, MD 21740 (39.635491, -77.705618) 02/01/2020
2105 2105 1027 E Hwy 98, Panama City, FL 32401, USA 30.15668359999999 -85.64594819999999 1 ROOFTOP 105775 GLENCOVE HEALTH AND REHABILITATION CENTER 1027 E HWY 98 PANAMA CITY FL 32401 8508721438 20 Bay For profit - Corporation 115   Medicare and Medicaid false NF GLEN COVE LLC 09/16/1992 false   false true false Resident Yes 5   4   5   5   5     2   2 6 6                             01/10/2018 4 4 0 16 1 0 16 03/10/2017 3 2 1 8 1 0 8 2015-12-04 2 2 0 1 8 0 8 12 0 1 0 0.00 0 0   02/01/2020
2162 2162 320 MAPLE AVENUE GREAT BARRINGTON, MA 01230 42.181195 -73.375506 0   225495 TIMBERLYN HEIGHTS NURSING AND REHABILITATION 320 MAPLE AVENUE GREAT BARRINGTON MA 1230 4135282650 10 Berkshire For profit - Corporation 71 61.7 Medicare and Medicaid false BEAR MOUNTAIN 320 OPERATING LLC 07/01/1990 false   false true false Resident Yes 3   4   4   4     2 1 12 1 12 6 6                             11/16/2017 2 2 0 8 1 0 8 08/15/2016 5 5 0 24 1 0 24 2015-05-12 14 8 6 1 76 0 76 24.667 1 1 1 6500.00 0 1 320 MAPLE AVENUE GREAT BARRINGTON, MA 01230 (42.181195, -73.375506) 02/01/2020
3164 3164 701 EDMONDSON AVENUE CATONSVILLE, MD 21228 39.277076 -76.734008 0   215252 FOREST HAVEN NURSING AND REHABILITATION CTR 701 EDMONDSON AVENUE CATONSVILLE MD 21228 4107477425 20 Baltimore For profit - Corporation 167 149.2 Medicare and Medicaid false CATONSVILLE HEALTH CARE LLC 08/01/1993 false   true true false Resident Yes 2   2   4   5   4   2   2       2.50018 0.73447 0.41204 1.14652 3.6467 0.03661 1.99272 0.8169 0.43555 3.24517 2.6076 0.67607 0.35607 3.60343 05/12/2017 4 0 4 32 1 0 32 02/26/2016 17 12 5 100 1 0 100 2014-11-13 10 6 4 1 52 0 52 58 20 13 0 0.00 0 0 701 EDMONDSON AVENUE CATONSVILLE, MD 21228 (39.277076, -76.734008) 02/01/2020
5118 5118 1442 BUCKHORN ROAD SYKESVILLE, MD 21784 39.432936 -77.049096 0   215247 BRINTON WOODS NURSING & REHABILITATION CENTER 1442 BUCKHORN ROAD SYKESVILLE MD 21784 4107952737 60 Carroll For profit - Partnership 60 49.2 Medicare and Medicaid false BRINTON WOODS HEALTH CARE CENTER LLC 04/01/1993 false   false true false Resident Yes 3   2   5   4   5   3   3       2.46673 0.80726 0.74044 1.5477 4.01443 0.19505 2.40148 0.84798 0.42313 3.67258 2.1348 0.71584 0.65864 3.50513 11/16/2017 22 22 0 136 1 0 136 09/13/2016 8 1 7 32 1 0 32 2015-07-24 11 7 4 1 40 0 40 85.333 0 3 0 0.00 0 0 1442 BUCKHORN ROAD SYKESVILLE, MD 21784 (39.432936, -77.049096) 02/01/2020
5980 5980 390 ORLEANS ROAD NORTH CHATHAM, MA 02650 41.70068 -69.965861 0   225330 LIBERTY COMMONS 390 ORLEANS ROAD NORTH CHATHAM MA 2650 5089454611 0 Barnstable For profit - Corporation 132 125.4 Medicare and Medicaid false BROAD REACH OF CHATHAM INC 02/02/1989 false   false true false Resident Yes 5   4   5   5   5   4   5       2.23568 0.60631 1.06715 1.67347 3.90914 0.14749 2.05587 0.73896 0.35651 3.15134 2.26011 0.61696 1.12665 3.97777 11/08/2017 0 0 0 0 0 0 0 09/01/2016 6 3 3 56 1 0 56 2015-06-05 0 0 0 0 0 0 0 18.667 0 1 1 7963.00 0 1 390 ORLEANS ROAD NORTH CHATHAM, MA 02650 (41.70068, -69.965861) 02/01/2020
6063 6063 282 CABOT STREET HOLYOKE, MA 01040 42.206726 -72.619426 0   225232 HOLYOKE HEALTHCARE CENTER 282 CABOT STREET HOLYOKE MA 1040 4135387470 70 Hampden For profit - Corporation 102 93.1 Medicare and Medicaid false HOLYOKE HEALTHCARE CENTER LLC 03/31/1974 false   false true false Resident Yes 2   2   4   4   5   3   3       2.09809 1.0049 0.39616 1.40106 3.49915 0.0532 2.14789 0.64775 0.28943 3.08507 2.03015 1.16655 0.51518 3.63707 10/17/2017 10 5 5 104 1 0 104 10/05/2016 11 8 3 68 1 0 68 2015-07-22 0 0 0 0 0 0 0 74.667 4 1 3 26286.00 0 3 282 CABOT STREET HOLYOKE, MA 01040 (42.206726, -72.619426) 02/01/2020
6152 6152 1937 JENKS AVE PANAMA CITY, FL 32401 30.183905 -85.66269 0   105391 SEA BREEZE HEALTH CARE 1937 JENKS AVE PANAMA CITY FL 32401 8507697686 20 Bay For profit - Corporation 120   Medicare and Medicaid false Legal Business Name Not Available 08/01/1981 false   false true false Both Yes 2   2   3   4   1     2   2 6 6                             09/28/2017 7 7 0 28 1 0 28 11/04/2016 15 8 7 68 1 0 68 2015-08-20 6 3 3 1 24 0 24 40.667 0 6 0 0.00 0 0 1937 JENKS AVE PANAMA CITY, FL 32401 (30.183905, -85.66269) 02/01/2020
7094 7094 545 MAIN STREET FALMOUTH, MA 02540 41.552382 -70.608177 0   225459 ROYAL NURSING CENTER, LLC 545 MAIN STREET FALMOUTH MA 2540 5085483800 0 Barnstable For profit - Corporation 121 103.7 Medicare and Medicaid false ROYAL NURSING CENTER LLC 07/01/1990 false   false true false Resident Yes 4   4   2   2   3   3   3       1.72828 0.95692 0.54089 1.49782 3.22609 0.08014 2.10839 0.74618 0.33532 3.18989 1.70365 0.96431 0.60712 3.24305 08/08/2017 1 0 1 4 2 2 6 07/27/2016 8 7 1 52 1 0 52 2015-04-16 2 2 0 1 8 0 8 21.667 0 2 1 14079.00 0 1 545 MAIN STREET FALMOUTH, MA 02540 (41.552382, -70.608177) 02/01/2020
7475 7475 Chinle, AZ 86503, USA 36.1544483 -109.5526072 1 APPROXIMATE 35242 CHINLE NURSING HOME PO BOX 910 CHINLE AZ 86503 9286745216 0 Apache Non profit - Other 79 56.6 Medicare and Medicaid false NAVAJOLAND NURSING HOMES INC 07/10/1997 false SFF Candidate false true false Resident Yes 2   1   3   3     2 4   4       2.71606 0.40745 0.7381 1.14555 3.86161 0.03178 1.8047 0.60295 0.29618 2.70383 3.12789 0.50813 0.93796 4.57975 09/29/2017 25 21 14 317 2 159 476 08/25/2016 5 5 0 20 1 0 20 2014-11-21 31 30 1 2 403 202 605 345.5 8 2 0 0.00 2 2   02/01/2020
7603 7603 50 MANSION DRIVE ROWLEY, MA 01969 42.73727 -70.88174 0   225688 SEA VIEW CONVALESCENT AND NURSING HOME 50 MANSION DRIVE ROWLEY MA 1969 9789482552 40 Essex For profit - Corporation 62 46.7 Medicare and Medicaid false SEAVIEW RETREAT INC 09/01/1995 false   false true false Resident Yes 5   5   3   5   1   3   3       2.13471 0.7294 0.48407 1.21347 3.34817 0.15994 2.28753 0.69908 0.33512 3.32174 1.93949 0.78455 0.54367 3.23218 08/10/2017 0 0 0 0 0 0 0 07/01/2016 0 0 0 0 0 0 0 2015-07-29 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0 50 MANSION DRIVE ROWLEY, MA 01969 (42.73727, -70.88174) 02/01/2020
7875 7875 40 MARTIN STREET MELROSE, MA 02176 42.456878 -71.074708 0   225329 MELROSE HEALTHCARE 40 MARTIN STREET MELROSE MA 2176 7816657050 90 Middlesex For profit - Corporation 106 88 Medicare and Medicaid false 40 MARTIN STREET OPERATOR LLC 02/13/1989 false   false true false Resident Yes 1   1   3   3   2   3   3       1.50066 0.77704 0.50587 1.2829 2.78357 0.01716 1.90021 0.62371 0.26569 2.78961 1.64134 0.93679 0.71662 3.19972 11/08/2017 3 2 1 16 1 0 16 10/25/2016 6 3 3 72 3 50 122 2015-11-12 14 7 7 2 176 88 264 92.667 3 4 3 90919.00 0 3 40 MARTIN STREET MELROSE, MA 02176 (42.456878, -71.074708) 02/01/2020
8380 8380 2187 SACATON AZ 85247 33.375366 -111.860236 0   35216 CARING HOUSE PO BOX 2187 SACATON AZ 85247 5205627400 100 Pinal Government - Federal 100 86.4 Medicare and Medicaid false THE CARING HOUSE 06/19/1993 false SFF Candidate false true false Resident Yes 2   1   2   3   2   5   5       4.33898 1.62196 1.09558 2.71753 7.05651 0.11517 2.03464 0.72046 0.32363 3.07873 4.43216 1.69283 1.27416 7.34973 12/15/2017 19 19 2 176 1 0 176 09/15/2016 14 14 0 76 1 0 76 2014-10-31 23 23 0 2 172 86 258 156.333 1 0 0 0.00 1 1 2187 SACATON AZ 85247 (33.375366, -111.860236) 02/01/2020
8496 8496 925 WEST MANGUM AVENUE MENDENHALL, MS 39114 31.968387 -89.885456 0   255150 BEDFORD CARE CENTER OF MENDENH 925 WEST MANGUM AVENUE MENDENHALL MS 39114 6018471311 630 Simpson For profit - Corporation 60   Medicare and Medicaid false BEDFORD CARE CENTER OF MENDENHALL LLC 11/01/1992 false   false true false Resident Yes 2   2   3   3     2   2   2 6 6                             10/12/2017 5 5 0 36 1 0 36 01/06/2017 4 3 1 16 1 0 16 2015-12-04 1 1 0 1 16 0 16 26 2 0 0 0.00 0 0 925 WEST MANGUM AVENUE MENDENHALL, MS 39114 (31.968387, -89.885456) 02/01/2020
9423 9423 1801 CAMELOT DRIVE VIRGINIA BEACH, VA 23454 36.868128 -76.027199 0   495237 VA BEACH HEALTHCARE AND REHAB 1801 CAMELOT DRIVE VIRGINIA BEACH VA 23454 7574813500 921 Virginia Beach City For profit - Corporation 180 168.5 Medicare and Medicaid false MEDICAL FACILITIES OF AMERICA VI & XIII 04/05/1991 false   false true false Resident Yes 3   4   4   3   5   1   1       1.74243 1.05187 0.24551 1.29737 3.0398 0.10966 1.9795 0.75363 0.3601 3.09323 1.82942 1.0495 0.25661 3.15127 09/21/2017 2 2 2 8 1 0 8 08/04/2016 8 8 0 36 1 0 36 2015-08-20 8 8 0 1 28 0 28 20.667 0 3 0 0.00 0 0 1801 CAMELOT DRIVE VIRGINIA BEACH, VA 23454 (36.868128, -76.027199) 02/01/2020
9695 9695 11141 WARWICK BLVD NEWPORT NEWS, VA 23601 37.049355 -76.475927 0   495368 THE NEWPORT 11141 WARWICK BLVD NEWPORT NEWS VA 23601 7575953733 622 Newport News City For profit - Corporation 60 44.3 Medicare false VIRGINIA HEALTH SERVICES, INC 05/29/2003 false   false true false Resident Yes 5   5   4   3   4   2   2       2.08552 1.13812 0.55186 1.68998 3.7755 0.12365 2.29044 0.8239 0.4352 3.54954 1.89239 1.03871 0.47729 3.41079 10/12/2017 4 4 0 16 1 0 16 09/09/2016 5 5 0 20 1 0 20 2015-10-01 2 2 0 1 8 0 8 16 0 0 0 0.00 0 0 11141 WARWICK BLVD NEWPORT NEWS, VA 23601 (37.049355, -76.475927) 02/01/2020
9729 9729 901 EAST PRINCESS ANNE ROAD NORFOLK, VA 23504 36.856824 -76.274339 0   495210 NORFOLK HEALTH AND REHABILITATION CENTER 901 EAST PRINCESS ANNE ROAD NORFOLK VA 23504 7576261642 641 Norfolk City For profit - Partnership 180 148.3 Medicare and Medicaid false MEDICAL FACILITIES OF AMERICA XLI 05/04/1990 false   false true false Resident Yes 2   2   4   4   3   2   2       1.67814 0.87667 0.35563 1.2323 2.91044 0.03804 1.87936 0.69788 0.32479 2.90203 1.85581 0.94458 0.41213 3.21595 08/17/2017 12 9 7 64 1 0 64 07/14/2016 12 12 0 80 1 0 80 2015-05-29 12 12 0 1 56 0 56 68 0 5 0 0.00 0 0 901 EAST PRINCESS ANNE ROAD NORFOLK, VA 23504 (36.856824, -76.274339) 02/01/2020
11927 11927 1739 KIRBY ROAD MC LEAN, VA 22101 38.920087 -77.154866 0   495410 ARLEIGH BURKE PAVILION 1739 KIRBY ROAD MC LEAN VA 22101 7035066900 290 Fairfax Non profit - Corporation 49 45.3 Medicare false VINSON HALL LLC 12/17/2012 true   false true false Family Yes 4   4   4   4   5   4   3       2.86775 1.56756 0.68543 2.25299 5.12074 0.19495 2.29365 0.78705 0.3885 3.4692 2.59854 1.49764 0.66405 4.73322 11/15/2017 3 3 0 28 1 0 28 11/16/2016 2 2 0 16 1 0 16 2015-11-13 2 2 0 1 20 0 20 22.667 0 0 0 0.00 0 0 1739 KIRBY ROAD MC LEAN, VA 22101 (38.920087, -77.154866) 02/01/2020
12425 12425 1 JANSEN ROAD NEW PALTZ, NY 12561 41.727759 -74.099097 0   335188 NEW PALTZ CENTER FOR REHABILITATION AND NURSING 1 JANSEN ROAD PO BOX 909 NEW PALTZ NY 12561 8452550830 740 Ulster For profit - Corporation 79 74.6 Medicare and Medicaid false CLR NEW PALTZ LLC 01/01/1967 false   false true false Resident Yes 3   3   3   2   3   3   3       2.11389 1.10852 0.65867 1.76719 3.88108 0.1625 2.12837 0.86069 0.43561 3.42466 2.0642 0.96846 0.56912 3.63402 01/29/2018 3 3 0 20 1 0 20 10/28/2016 7 7 0 28 1 0 28 2015-10-26 0 0 0 0 0 0 0 19.333 0 0 1 6845.00 0 1 1 JANSEN ROAD NEW PALTZ, NY 12561 (41.727759, -74.099097) 02/01/2020
12688 12688 550 SOUTH CARLIN SPRINGS ROAD ARLINGTON, VA 22204 38.860725 -77.128667 0   495102 MANORCARE HEALTH SERVICES-ARLINGTON 550 SOUTH CARLIN SPRINGS ROAD ARLINGTON VA 22204 7033797200 60 Arlington For profit - Corporation 161 139.4 Medicare and Medicaid false MANOR CARE OF ARLINGTON VA LLC 01/03/1977 false   false true false Resident Yes 3   2   5   5   4   3   3       1.82071 1.22825 0.54079 1.76904 3.58975 0.14185 2.0618 0.75016 0.34416 3.15613 1.83531 1.23116 0.59142 3.64723 10/04/2017 9 2 8 123 1 0 123 09/22/2016 2 2 0 12 1 0 12 2015-08-06 7 7 0 2 44 22 66 76.5 0 9 0 0.00 0 0 550 SOUTH CARLIN SPRINGS ROAD ARLINGTON, VA 22204 (38.860725, -77.128667) 02/01/2020
12796 12796 2131 WEST 3RD STREET LOS ANGELES, CA 90057 34.06319 -118.273665 0   555437 SAINT VINCENT MED CTR DP SNF 2131 WEST 3RD STREET LOS ANGELES CA 90057 2134847111 200 Los Angeles Non profit - Corporation 27   Medicare and Medicaid false Legal Business Name Not Available 09/28/1990 false   false true false None Yes 3   4     2   2   2 1 12 1 12 6 6                             09/10/2017 7 7 0 24 1 0 24 09/18/2016 6 5 1 52 1 0 52 2015-05-31 7 7 0 1 28 0 28 34 0 1 0 0.00 0 0 2131 WEST 3RD STREET LOS ANGELES, CA 90057 (34.06319, -118.273665) 02/01/2020
13805 13805 245 NORTH STREET BRISTOL, VA 24201 36.596025 -82.217858 0   495131 NHC HEALTHCARE,BRISTOL 245 NORTH STREET BRISTOL VA 24201 2766694711 111 Bristol City For profit - Corporation 120 106.5 Medicare and Medicaid false NHC HEALTHCARE-BRISTOL LLC 09/29/1982 false   false true false Resident Yes 5   5   4   5   4   3   3       2.18228 1.27099 0.49268 1.76367 3.94595 0.11147 2.13726 0.73747 0.34626 3.22099 2.12211 1.29594 0.53554 3.92839 05/18/2017 3 3 0 12 1 0 12 05/25/2016 0 0 0 0 0 0 0 2015-06-25 3 3 0 1 24 0 24 10 0 0 0 0.00 0 0 245 NORTH STREET BRISTOL, VA 24201 (36.596025, -82.217858) 02/01/2020
14034 14034 46 HARRIMAN DRIVE GOSHEN, NY 10924 41.389389 -74.319656 0   335684 SAPPHIRE NURSING AND REHAB AT GOSHEN 46 HARRIMAN DRIVE GOSHEN NY 10924 8453601200 540 Orange For profit - Corporation 120 112.4 Medicare and Medicaid false GOSHEN OPERATIONS LLC 09/18/1985 false   false true false Both Yes 1   1   2   2   2   2   2       1.81285 0.71868 0.57428 1.29296 3.10582 0.12758 2.25367 0.87701 0.49057 3.62125 1.67181 0.61619 0.44061 2.75024 01/29/2018 14 13 4 76 1 0 76 12/15/2016 5 0 5 36 0 0 36 2015-11-19 2 2 0 1 8 0 8 51.333 4 8 1 145022.00 0 1 46 HARRIMAN DRIVE GOSHEN, NY 10924 (41.389389, -74.319656) 02/01/2020
14244 14244 100 ANNA GOODE WAY SUFFOLK, VA 23434 36.787041 -76.619645 0   495366 LAKE PRINCE WOODS, INC 100 ANNA GOODE WAY SUFFOLK VA 23434 7579235500 892 Suffolk City Non profit - Corporation 40 26.5 Medicare false LAKE PRINCE CENTER, INC. 01/14/2003 true   false true false Resident Yes 4   3   3   3   3   4   4       2.73757 1.92288 0.98063 2.90351 5.64108 0.28076 2.32969 0.78142 0.39962 3.51072 2.44221 1.85035 0.92362 5.15251 11/16/2017 10 10 0 72 1 0 72 11/10/2016 0 0 0 0 0 0 0 2016-01-28 2 2 0 1 20 0 20 39.333 0 0 0 0.00 0 0 100 ANNA GOODE WAY SUFFOLK, VA 23434 (36.787041, -76.619645) 02/01/2020
14867 14867 127 EARLY AVENUE PETERSBURG, WV 26847 38.999853 -79.133346 0   515151 GRANT REHABILITATION AND CARE CENTER 127 EARLY AVENUE PETERSBURG WV 26847 3042574233 110 Grant Government - County 110 103.3 Medicare and Medicaid false GRANT COUNTY NURSING HOME 04/01/1997 false   false true false Resident Yes 3   3   3   3   4   2   2       2.89388 0.53452 0.51784 1.05236 3.94624 0.04677 2.12383 0.74872 0.3922 3.26474 2.83189 0.53683 0.49696 3.87604 01/25/2018 10 10 0 48 1 0 48 09/29/2016 9 9 0 88 1 0 88 2015-07-30 5 5 0 1 28 0 28 58 0 0 0 0.00 0 0 127 EARLY AVENUE PETERSBURG, WV 26847 (38.999853, -79.133346) 02/01/2020
15198 15198 812 SHEPARD STREET MOREHEAD CITY, NC 28557 34.719585 -76.713555 0   345244 HARBORVIEW HEALTH CARE CENTER 812 SHEPARD STREET MOREHEAD CITY NC 28557 2527266855 150 Carteret For profit - Corporation 122   Medicare and Medicaid false SENIOR CARE PROPERTIES, INC. 12/11/1984 false   false true false Resident Yes 4   4   2   3   2     2   2 6 6                             10/26/2017 2 2 0 8 1 0 8 11/03/2016 5 1 4 20 1 0 20 2016-01-14 2 2 0 1 12 0 12 12.667 0 1 0 0.00 0 0 812 SHEPARD STREET MOREHEAD CITY, NC 28557 (34.719585, -76.713555) 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
);