Category Archives: Data

New Election Data Sets for U.S. House 1992-1998

Excel Icon

Now available for purchase are election data sets for U.S. House of Representatives by county, congressional district, and state in the general elections of 1992, 1994, 1996, and 1998. There have been many requests for these data, and after several months of compilation, the files are now available for purchase on the store page.

Note that the status of the files is listed as “Preliminary” because the Commonwealth of Pennsylvania did not publish official results by county for U.S. House of Representatives in those years.  The data included in the files in a mix of official results obtained from a few individual counties and compiled results from a precinct-level database provided by the Pennsylvania Bureau of Commissions, Elections and Legislation - but like many such databases, there are many discrepancies.  It will take several more months to track down the individual results from each of the county election agencies.  The data as-is is quite usable since most of the discrepancies are a small percentage of the totals.

As always, updates to purchased data sets are free.

New CSV Download for Election Data Spreadsheets

Purchased spreadsheet files from the Dave Leip’s Election Atlas store now include a new option to download county-level comma-separated value (csv) files that include the FIPS codes, county names, total vote, and vote data from each party/candidate – for the entire nation in one text-based file.  These new files are currently available by county for all general election vote results data sets for U.S. Senate, U.S. Representative, Governor.  The csv files are also available for general elections for President back to 1936.  The csv and Excel versions of any purchased files may be downloaded on your myatlas page.

Updated 2012 Results in Saguache County, CO

Saguache County, CO

Saguache County, CO

The Colorado Office of the Secretary of State publishes a biennial report of official election results for the several elections held in the preceding two years.  Often the results presented within this abstract differ from the on-line reports published on the agency website shortly after the election. The 2012 Abstract of Votes Cast has only small deviations in the votes for Saguache County relative to the results published in the January 2012 on-line report.  The differences are Barack Obama (D) +1, Roseanne Barr (P&F) +2, Anderson (Jus) -2, Tittle (WTP) +1, Miller (ATP) -1. The Atlas database has been updated with this minor change.  Full results of the Colorado 2012 General Election Results for President are available on the Atlas here.

Atlas adds 8,510 Election 2000 Votes for President

Upon a detailed review of all official county election publications for the state of New York 2000 General Election results for President, the Atlas database has been updated with 8,510 more votes not included in the New York State Board of Elections 2000 General Election certified results.  Overall, the atlas results in New York include 44 corrections to the certified results by county for President.  This database update replaces the official certified vote counts in three counties with those published in the following documents: Official Canvass and Statement of Votes Cast, published by the Nassau County Board of Elections (732 more votes than reported in the statewide certified results) and the City of New York Statement and Return of the Votes for the Office of President and Vice President of the United States (corrections in Kings and New York Counties), published by the New York City Board of Elections on February 21, 2001 (7,778 more votes than reported in the statewide certified results).  Given that this update is from heavily democratic counties, the net result of these corrections is an increase in the vote margin for Al Gore over George W. Bush of 3,582 votes (bringing the total popular vote margin to 547,398 votes).

West Virginia 2012 Write-in Votes

The 2012 General Election results for President officially reported in the West Virginia Certificate of Ascertainment include a total of 229 votes cast for 26 declared write-in candidates.  The vote data for the write-in candidates are not included by the West Virginia Secretary of State in their online election results database.  To date, the Election Atlas database only had the statewide totals available, including 119 votes for Virgil Goode, 31 votes for Roseanne Barr, 12 votes for Rocky Anderson, etc. Recently, I received the full county-level data for these candidates from the West Virginia Secretary of State’s office and incorporated them into the atlas.

1,053 Vote Error in MA Official 2010 Gubernatorial Results

Massachusetts Map Highlighting Middlesex County

Middlesex County, MA

The official general election results for Governor as published in the 2010 Public Document #43 Massachusetts Election Statistics (a book printed by the Massachusetts Secretary of the Commonwealth, with an online edition located here) contains an error in the City of Cambridge, Middlesex County. With 1,076 votes for “All Others” as a red flag, an investigation reveals that the PD#43 tabulation scrambled the results in Ward 5 Precinct 1 - where the published table has Democrat Deval Patrick with 1 vote, Republican Charlie Baker with 23, Independent Tim Cahill with 31, Green-Rainbow Jill Stein with 10, “All Others” with 1,054 and 108 blanks.  The official result as published by the City of Cambridge has Deval Patrick with 1,054 votes, Charlie Baker with 108, Tim Cahill with 23, Jill Stein with 31, 10 Blank votes, and 1 write-in vote. The corrected totals as published from the City of Cambridge has been incorporated in the Election Atlas database, resulting in an increase in total vote for Deval Patrick of 1,053 votes, an increase of 85 votes for Charlie Baker, a decrease of 8 votes for Tim Cahill, an increase of 21 votes for Jill Stein, and a decrease of 1,053 votes for “All Others”.

Updates to 2010 Governor and Senate Results

The Atlas 2010 General Election results for U.S. Senate and Governor have been updated to reflect several official changes in certified data.  In Colorado, the official publication of the “Abstract of Votes Cast” (a printed book, but also available in a pdf version) includes higher figures relative to the Official Results report published on the Colorado Secretary of State’s web site on November 24, 2010 (over five thousand more votes are included in the published Abstract). In New York, the State Board of Elections published an Amended set of certified results on September 13, 2012.  This report actually reduces the number of votes recorded in Westchester County. In Ohio, a slight increase in the vote count in Cuyahoga County is reflected by the most recent report on the Ohio Secretary of State 2010 General Election Official Results page. Lastly, 35 declared write-in votes are included for U.S. Senate in Delaware.

New Election Statistics Tables

The statistics page for each Presidential, US Senatorial, and Gubernatorial Election have been updated to include a new set of eight tables. Four of these highlight the states and counties with the largest swings from the previous election (both in raw votes and percentages). Additional tables also present states and counties with the largest change in total votes cast for the office (both as raw votes and percentages) to highlight some of the fastest growing and shrinking counties or the level of enthusiasm from election to election. An example swing percentage table from the 2012 Presidential Statistics is shown below:

States with Largest Vote Swing Percentage

Republican Democratic
Utah 19.87% Alaska 7.55%
West Virginia 13.65% New Jersey 2.21%
Montana 11.26% Mississippi 1.68%
Indiana 11.21% Louisiana 1.42%
North Dakota 10.97% New York 1.32%

New York City Adds 6,436 more 2012 General Election Votes for President

New York County Map Highlighting Kings CountyOn July 2, 2013, the New York City Board of Elections printed a new “Statement and Return Report for Certification General Election – 11/06/2012” for Kings County (also known as Brooklyn Borough), adding a total of 6,470 ballots to the 2012 General Election tally, including 6,436 valid ballots cast for Presidential Candidates (34 ballots were under votes or over votes – referred to in New York as blanks or voids respectively).

Candidate New Votes %New Votes
Obama 5,497 85.42%
Romney 862 13.40%
Stein 46 0.71%
Johnson 27 0.42%
Lindsay 2 0.03%
Goode 1 0.02%
Ron Paul 1 0.02%

The new votes break down as shown in the table at left (figures for Obama reflect the fusion of Democratic and Working Families party ballot lines and Romney votes reflect the fusion of Republican and Conservative party ballot lines). This amended certification on 07/02/2013 follows previous certifications on 12/31/2012 and 3/19/2013. These latest figures have been incorporated into the Atlas (link to New York 2012 Presidential Summary Page. Thanks to @DKElections for the tip on amended results.

Wilson County, KS Votes are Double-Counted in 2012

Kansas County Map Highlighting Wilson CountyThe 2012 General Election official Vote Totals as reported by the Kansas Secretary of State Elections & Legislative division includes results from Wilson County that are double-counted.  Wilson County has a relatively small population of 9,409 as enumerated by the U.S. Census Bureau in 2010 (estimated population of July 2012 is 9,105) and is located east of Wichita and south of Topeka as shown in the map at right.  The table below shows the officially reported results for President in Wilson County:

Official Reported
Presidential Candidate Vice Presidential Candidate Political Party Popular Vote
Willard Mitt Romney Paul Ryan Republican 5,650 76.00%
Barack H. Obama Joseph R. Biden, Jr. Democratic 1,636 22.01%
Gary Johnson James P. Gray Libertarian 94 1.26%
Chuck Baldwin Joseph Martin Reform 54 0.73%

The sum of the votes cast for President as reported is 7,434. However, the Kansas 2012 General Election Official Turnout Report shows only 3,752 ballots cast and 5,845 registered voters in Wilson County.  Furthermore, the total counted votes for President in 2008 was 4,121.  Upon inspection of the 2012 Kansas General Election Results by Precinct, it becomes clear that the votes for each candidate are counted twice.  The Atlas database has been updated to reflect the correct data.