Crowdsourcing Pres-by-CD, 4th Thread

Right now we’re in a bit of a holding pattern with the presidential results by CD project. Most states haven’t yet certified final vote tallies, and some haven’t even finished counting. But the good news is that we have some preliminary numbers for the following states:

Connecticut

Iowa

Kentucky

Minnesota

New Hampshire

Rhode Island

Virginia

West Virginia

You can find these by clicking on the links in the “Calculations” column (column E) in the collaborative spreadsheet.

On the flipside, we still need links to official data sources for the following states:

Alabama

Florida

Indiana

Louisiana

Mississippi

New Jersey

Oklahoma

South Carolina

Tennessee

Utah

If you know the proper links to official results for any of these states, please enter them as a TinyURL on the spreadsheet. Even if official 2008 results haven’t yet been released (and as I say, in most states they have not), links to where you expect the official data to show up at some point would be greatly appreciated.

As always, please share any thoughts about this project in comments. Also, a couple of helpful resources from the US Census Bureau:

19 thoughts on “Crowdsourcing Pres-by-CD, 4th Thread”

  1. You’re going to need a better source for Arizona.  All of the congressional districts partially or totally take in the three largest counties: Maricopa has all of AZ-03, 04, and 05 and large parts of AZ-02 and 06; Pima has large parts of AZ-07 and 08; Pinal has large parts of 01 and 07.  Other than a rough guesstimate about AZ-01, there’s little we can do with county-level data.

    I can’t find jack as far as precinct-level results nor any indication that those will be available after the vote is certified (thank you, future Gov Brewer), and I really don’t know what we can do without those.

  2. for every state to compile this information as it goes along. After all, some–like Virginia–do.

    For states like Pennsylvania, it could take us months to figure out the precinct breakdown in some districts.

  3. Arkansas is the last whole counties one, so I’ll start work on that as soon as I have the time.

    Still no joy finding precinct breakdowns for Missouri. Has anybody emailed elections officials over this? Are they likely to be receptive? Are they legally allowed to share this information and would they be aware of it?

    Also, do we have a list of when states will be certified?

  4. They have copies of all the final reports from every county on their website.  There’s still a lot of data to churn through, but at least everything you need is publicly available.

  5. I was going to do Missouri and Arkansas, but the latter has a couple of uncertified counties and I haven’t yet got precinct boundaries and figures for the former.

    So I decided to do something much more difficult, and try Michigan. The good news is that all bar two of the divided counties report by precinct. The bad news is that one of the ones that doesn’t is Wayne County, so there are a couple of CDs I just can’t do.

    Further bad news: whilst I can work out which precincts go where, I then have to trawl through a lot of information and collate it to get usable figures. And I’m busy with studies, don’t have weekends free and am not the world’s biggest fan of spreadsheets. So whilst I will finish this, it may take some weeks. I’ll try to keep updating my working in case I go too slow and somebody wants to take over from me.

  6. When I click the link for Maine, I get Kentucky. When I click Kentucky, I get Iowa. Click Florida and you get Connecticut. All other spreadsheets appear to work, bar Maryland, where the column is too tall for me to get a clickthrough to the detailed spreadsheet.

    Are these incorrect transpositions, or is the spreadsheet broken for me?

    Also, has Maine just been lost? I was sure somebody had already produced preliminary numbers for that.

Comments are closed.