Could you add the Virginia Localitiy codes per the SBE?

[drf5n]

The JSON that comes from the tab on http://results.elections.virginia.gov/vaelections/2017%20November%20General/Site/Governor.html includes a LocalityCode that might be unique within the state:

in R:

    library(jsonlite)
    df_G=fromJSON('http://results.elections.virginia.gov/vaelections/2017%20November%20General/Json/Governor.json')
    head(df_G$Localities)
   

  Locality.LocalityName Locality.LocalityCode PrecinctsReporting PrecinctsParticipating            LastModified
1       ACCOMACK COUNTY                   001                 17                     17  2017-11-07T20:51:17.06
2      ALBEMARLE COUNTY                   003                 29                     29  2017-11-07T21:01:23.93
3       ALEXANDRIA CITY                   510                 29                     29 2017-11-07T20:56:29.647
4      ALLEGHANY COUNTY                   005                 13                     13 2017-11-08T12:29:23.033
5         AMELIA COUNTY                   007                  6                      6 2017-11-07T20:09:50.867
6        AMHERST COUNTY                   009                 12                     12 2017-11-07T22:23:57.363
       ...                                                                                                                                                                                

Could you include LocalityCode as an attribute? It could make it easier to connect the board of elections numbers to the maps.

[jalbertbowden]

those locality codes are unique within the state, those are FIPS codes. you typically see them with the state two digits prefixed though. For example, the table above, the code for Accomack County is 51001.
If you are referring to the Virginia Precincts 2016 JSON file, that data is already included under the key "fips". Prefixing 51 to the LocalityCode keys in your table will provide matches.