As sort of a companion to
Alcon's project, and a followup to the Swing State Project's own
Presidential Results by CD project, I wanted to see which states make their precinct-level election data available at the state level. In other words, where can you get this data from the Secretary of State or state Board of Elections, and where do you have to go
grubbing county-by-county?
I already knew, thanks to the Pres-by-CD project, that the latter category was frustratingly large. Fortunately, though, it turns out that 34 states (or dedicated folks) have posted 2008 election results by precinct. However, there's a wide variety of ways in which this data is offered. Some states make it easily available in a single spreadsheet for the whole state (eg, Wisconsin). Others force you to look at inconsistently formatted PDFs on a county-by-county basis (eg, Iowa). I therefore decided to download everything I could get my hands on, compile it as best I could, and upload the results. (Sorry, I haven't converted the PDFs into Excel files, but I have done a lot of compiling and organizing.)
Below are the 30 states which make some form of precinct file available. (The files for a 31st state, California, are too extensive to re-post.) The first link is to the compiled file(s) I've uploaded to a hosting service. In parens is the type of file (most of the ZIPs are collections of text files, except for IA, which is a very large PDF). The second link is to the source I used for the docs. In all cases, the files include at least the presidential numbers, though usually there is a lot more (such as governor, Senate, House, state lege, etc.) Without further ado:
AK (PDF) - Source
AZ (ZIP) - Source
AR (XLS) - Source
CA (DBF)
DE (TXT) - Source
GA (PDF) - Source
HI (XLS) - Source
ID (XLS) - Source
IA (ZIP) - Source
KS (XLS) - Source
LA (XLS) - Source
ME (XLS) - Source
MD (XLS) - Source
MI (ZIP) - Source
MN (ZIP) - Source
MS (PDF) - Source
MT (XLS) - Source
NH (XLS) - Source
NM (PDF) - Source
ND (XLS) - Source
OH (XLS) - Source
OK (XLS) - Source
PA (ZIP) - Source
RI (XLS) - Source
SD (XLS) - Source
TN (PDF) - Source
TX (CSV) - Source
VT (XLS) - Source
WA (ZIP) - Source
WI (XLS) - Source
WY (PDF) - SourceThree states make precinct-level results available through database-driven web interfaces, but I couldn't find a reasonable way to download the data. If you can figure out how to tap the following three states, please let me know.
North Carolina
South Carolina
VirginiaAnd finally, Alabama has claimed they will upload precinct results (and has in past years), but they have not yet done so for 2008 (or even 2006). If they ever do, I would expect the file(s) to
appear on this page.
The remaining states (listed below) don't appear to offer precinct results at the state level anywhere that I've been able to find, though I've heard tell that Colorado offers something like this for somewhere in the vicinity of $300. Anyhow, if I'm wrong about any of these states,
please post links to data sources:
Colorado
Connecticut
Florida
Illinois
Indiana
Kentucky
Massachusetts
Missouri
Nebraska
Nevada
New Jersey
New York
Oregon
Utah
West Virginia
I hope this is helpful to someone out there!
UPDATE: Links to new sources for CA, OK & WA added.