I'm pleased to finally be able to bring you my comprehensive guide to the 113th Congress members and their districts. After tirelessly collecting data from the relevant state election boards and thanks to the work of Daily Kos Elections' own jeffmd on calculating the 2012 presidential votes by congressional district, this work is now complete barring subsequent minor updates.
You can find the excel spreadsheet here available for download and if you want to look at the individual downballot percentages rather than just the average by district you can find them all available here, as well as the county and statewide totals.
So here's the complete rundown of everything I've included in the guide itself:
Elections Data (all two-party)
1. All 435 districts and 50 states have 2008 and 2012 presidential data, with the CD data again courtesy of jeffmd.
2. Calculated Partisan Voter Index scores for both single years of 2008 and 2012 as well as the combined two cycle Cook PVI.
3. All 435 districts have the 2012 House Vote and 97 senators have their last election results.
4. All 435 congressional districts have downballot (i.e. non-presidential) partisan election averages, mostly from 2006-2012 (though in some cases just 2010, etc.). Many of these are estimated based on county results, which introduces minute error for small split counties, but larger error for larger ones, so states like New York only have data for years such as 2010 via the elections board.
5. All congressional districts have a partisan average PVI that treats the state as Even.
District Demographic Data
1. All districts and states have total population and voting age population census figures for the White, Black, Hispanic, Asian, Native American/Pacific Islander, and Other categories via the census numbers from
Dave's Redistricting App. These have a small amount of error to them, but I didn't want to use the census numbers with "two or more races" utterly screwing with the numbers. Hopefully I'll find a fix in the future using Census ACS estimates.
2. Voting Age Population percentages, colored by majority (non-white=gray, Black=blue, Hispanic=green, Asian=purple, Native=yellow)
Member of Congress Biographical Data
1. Congress member's name color coded by party organized by district number or senate class.
2. Pronunciation guide with both phonetic and IPA compiled by myself by listening to countless audio/video sources and transcribing the name in the member's own accent.
3. Year first elected, with senate appointments and special elections noted
4. Member's year of birth (warning, from wikipedia)
5. Member's religion (warning, from wikipedia)
Note, some members are missing pronunciation guides because I could not find appropriate audio of the person themselves saying their name. For the vast majority of the names, I used campaign ads where they state "I'm __ and approve this message" as their name, regardless of whether that uses a nick name or not. If you know of audio/video recordings for the remaining dozen or so names, feel free to let me know. Same goes for missing religion data for members, or if you find any errors since that and birth year were the two things I used from wikipedia.
Finally, all of this data can be easily sorted if you have any familiarity with excel, though you might want to copy and paste special the whole sheet to get rid of formulas first if you're not. The downballot averages in particular are very useful, especially for states such as Arkansas or Kentucky where downballot performance diverges wildly and unevenly from the presidential results.
Now if you have any experience working on the Hill (which I don't) there's probably an official one of these or parts of it out there, but I couldn't find it online. So this is for all of the nerdy political junkies and armchair pundits out there. Enjoy.