//
you're reading...
Data journalism, Data visualisation, elections, Mapping, Open data

US election 2016: How to download county-level results data

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.

screen-shot-2016-11-16-at-1-16-29-pm

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.

screen-shot-2016-11-16-at-1-12-08-pm

Election map made with the data

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.

UPDATE! Tony has now added comparison data to 2012’s election (based on a dataset I uploaded four years ago…) >>

About Simon Rogers

Data journalist, writer, speaker. Author of 'Facts are Sacred', from Faber & Faber and a new range of infographics for children books from Candlewick. Edited and launched the Guardian Datablog. Now works for Google in California as Data Editor

Discussion

6 thoughts on “US election 2016: How to download county-level results data

  1. 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.

    Posted by Harold Platteborze | November 24, 2016, 4:59 pm
  2. Any idea where to find the county level registered voter numbers?

    Posted by Katie Brinkley | November 19, 2016, 4:52 am
  3. Reblogged this on lyndamk's reads and commented:
    Access county level data for election 2016

    Posted by lyndamk | November 18, 2016, 8:09 pm
  4. 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

    Posted by Katie Brinkley | November 17, 2016, 5:32 am

Trackbacks/Pingbacks

  1. Pingback: Why Clinton won the Popular Vote but Trump won the Electoral College | Cu Deh - December 21, 2016

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: