National Spreadsheets The spreadsheets are in Microsoft Excel format (Mac/PC) and are compatible with the '97, '98, '00, '01 versions. The following worksheets are included in each file:
|
National, County, and Town Tab Metadata (Column lettering may vary by year) State Tab Column Title Data A State State Name B Elec Vote Total Electoral Vote C Popular Vote Total Popular Vote D D Democratic Electoral Vote E R Republican Electoral Vote F O Other Electoral Vote G D Rank of Democratic Candidate H R Rank of Republican Candidate I I Rank of Independent Candidate J Votes Vote Margin between the winning candidate and second place candidate K Margin % Percentage of total vote for the margin between the winning candidate and second place candidate L <Name/Dem> Democratic Popular Vote M <Name/Dem> Percentage of total popular votes cast for Democratic Candidate N <Name/Rep> Republican Popular Vote O <Name/Rep> Percentage of total popular votes cast for Republican Candidate P <Name/Ind> Independent Popular Vote Q <Name/Ind> Percentage of total popular votes cast for Independent Candidate R-BI <Name/Pty> Popular Vote and Percentage of popular vote for all other candidates BK State State Name BL State Abbreviation BM EV Total Electoral Vote BN-BP Rank of 4th - 7th candidates BS State Code State FIPS Code County Tab Column Title Data A County or State Name B County or State Two-Character Abbreviation C Total Vote Total popular vote cast for candidates D <abbrev> Rank of Democratic Candidate E <abbrev> Rank of Republican Candidate F <abbrev> Rank of Independent Candidate G Margin Vote Margin between the winning candidate and second place candidate H Margin % Percentage of total vote for the margin between the winning candidate and second place candidate I No Data J <name> Percentage of total votes cast for Democratic Candidate K <name> Percentage of total votes cast for Republican Candidate L <name> Percentage of total votes cast for Independent Candidate M Other Percentage of total votes cast for remaining candidates N <name> Democratic Candidate Popular Vote O <name> Republican Candidate Popular Vote P <name> Independent Candidate Popular Vote Q-AL <name> Popular vote for Candidate listed in row 1 AM No Data AN-AQ <abbrev> Rank of 4th - 7th candidates AR-AU <name> Percentage of total vote for candidates 4 through 7 AW County or State Name AX County or State Two-Character Abbreviation AY CD Congressional District (if blank, county is split amongst multiple districts) AZ No Data BA ST State FIPS code BB CTY County FIPS code BC FIPS Five-number combined state and county FIPS Code BD No Data BE LSAD_TRANS Shape type (county, state, city, parish) BM-BP Fusion Votes Pre-fused votes for candidates (e.g. NY Democratic, Working Families, Republican, Conservative party votes) BR Total Write-ins Total Write-in Votes cast BS-CF Qualified Write-ins Qualified write-in votes for registered write-in candidates Town Tab Column Title Data A County Subdivision or State Name B State Two-Character Abbreviation C Total Vote Total popular vote cast for candidates D <abbrev> Rank of Democratic Candidate E <abbrev> Rank of Republican Candidate F <abbrev> Rank of Independent Candidate G Margin Vote Margin between the winning candidate and second place candidate H Margin % Percentage of total vote for the margin between the winning candidate and second place candidate I No Data J <name> Percentage of total votes cast for Democratic Candidate K <name> Percentage of total votes cast for Republican Candidate L <name> Percentage of total votes cast for Independent Candidate M Other Percentage of total votes cast for remaining candidates N <name> Democratic Candidate Popular Vote O <name> Republican Candidate Popular Vote P <name> Independent Candidate Popular Vote Q-AL <name> Popular vote for Candidate listed in row 1 AM No Data AN County Subdivision or State Name AO County Name AP CD Congressional District (if blank, County Subdivision is split amongst multiple districts) AQ No Data AR ST State FIPS code AS CTY County FIPS code AT MCD Census MCD code AU COUSUBF County Subdivision FIPS code AV FIPS Five-number combined state and county FIPS Code AW Subdivision County Subdivision Shape type (town, city, unincorporated territory (UT), etc.) AX Town FIPS Seven-number combined State and County Subdivision FIPS Code