If open data means anything, it applies to elections. But yet here we are, a week after the results, and open data around the results is hard to find. It matters because having that data allows us to understand the results better, and what they say about America today. It also means that the data can be visualised too.
There are some bright lights: David Wasserman at the Cook Report is waging a one-person mission to count up all the popular votes, as late counting comes in, state-by-state. You can see the results here, on this Google Spreadsheet.
But if you’re after county-level data, it’s tricky to find.
However, one person has been doing just that. Tony McGovern has scraped Townhall.com’s excellently-formatted results to collate the US results, county by county.
Download the county results here >>
John Guerra has used the data already to produce this rather lovely map.
Here we are, nearly eight years after data.gov became a reality, and we have to rely on the community to provide data we should all have access to, as of right.
Can you please add 2020 to this ASAP? I’m very curious of the trends since the total number of votes has increased by such a large margin. It points to possible foul play, in my opinion
Great data source for county data – good job!!!
The 2012 Romney vs Obama results by county can actually be found on data.gov, I think, at https://catalog.data.gov/dataset/presidential-general-election-results-2012-direct-download . When you download and extract the .tar file there, the package includes a .dbf file with all the data, and it comes with a shapefile etc for making maps. Plus the data seems to be more inclusive than the (preliminary?) data from The Guardian – a couple of random counties I checked had slightly higher vote totals than the Guardian data.
Used this data to show my introductory quantitative social science students how to map the (most recent) 2016 election results in R. Thanks so much for sharing these links!
Great info! Thanks for posting.
Hi, thanks for the county link !! Awesome.
I have built a Power BI dashboard so you can easily visualise the data and make your own analysis.
See here : bit.ly/2eLE8qM
I will add the county-level analysis soon 🙂
Thanks
If these poor losers get their way and
Figure out a way to eliminate the Electoral College, we should then change the Popular vote to a by County
Vote. This would give all Citizens a fair chance to elect their favorite candidate rather than the Liberal cities doing it for us. The Electoral College is in place to offset this very thing.
Any idea where to find the county level registered voter numbers?
This seems to be the place, not sure how up to date it is though.
Reblogged this on lyndamk's reads and commented:
Access county level data for election 2016
This is awesome- and thank you! Any idea if Townhall.com is also pulling registered voter turnout data? I’m having a hard time finding that in one place- and don’t want to scrape every single county’s web listing