US_County_Level_Election_Results_08-20 icon indicating copy to clipboard operation
US_County_Level_Election_Results_08-20 copied to clipboard

add "state" name for Alaska and District of Columbia, and update 2016 data for Alaska

Open almccon opened this issue 3 years ago • 2 comments

almccon avatar Nov 12 '20 19:11 almccon

Thanks for your work @almccon. A few questions and comments:

2016_US_County_Level_Presidential_Results.csv

Where do the results for Alaska come from? Did you re-run any of the notebooks on this repo to get those results? If not, how do we validate your results?

2020_US_County_Level_Presidential_Results.csv

Most of the FIPS codes in this file represent U.S. counties or county-equivalents. The sources of the data --including the NYT and Politico -- also report other geographic areas that as far as I can tell, may represent voting districts as well. For example, according to the latest gazetteer files from the U.S. Census, there is no county-equivalent in Alaska with a FIPS 02901.

But if we look at the Alaska Division of Elections website, they show 40 House Districts that align with the 40 Alaska results in this file (02901 - 02940). I believe some newspapers are reporting election totals at the House District level for Alaska and decompose the 5-digit FIPS code this way:

  • ssSdd, where ss is the state FIPS code, S is a catch-all statewide code, and dd is the house district.

So 02901 represents the state FIPS code for Alaska (02), for all statewide (9), for House District 01 (01).

For the District of Columbia, I think those results are reported on the ward level, given that D.C. has 8 wards and we have 8 rows of results for D.C.

We'll need a notebook that allows us to reproduce these results and also capture the common names of all voting districts/wards as well.

Can you separate out the 2020_US_County_Level_Presidential_Results.csv changes and resubmit your PR? I'll merge that into the main file right away. We'll have to revisit the results of the 2016_US_County_Level_Presidential_Results.csv in another PR.

tonmcg avatar Nov 19 '20 15:11 tonmcg

@almccon I merged #21 to the master branch, which solves the ward- and district-level results for DC and Alaska, respectively. For DC results, I aggregated all ward-level results to the state level. For Alaska results, I kept the district level-results as is and added state and district names for each row.

tonmcg avatar Nov 25 '20 16:11 tonmcg