Dave Leip's Atlas of U.S. Presidential Elections

Information on Spreadsheets

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:

Candidates - candidate names and party ballot listing per state
Vote Data by State - summarizes vote totals by state for each candidate - with boundary file information (fips)
Vote Data by County - vote data for all counties of all states plus DC - with boundary file information (fips)
Vote Data by Town - vote data for New England towns (ME, MA, CT, RI, VT, NH) - with boundary file information (fips)
Vote Data by Congressional District - vote data for all congressional districts of all states
Graphs - pie charts for each state and national total.
Party - data sorted by strength at the state level for the major parties.
Statistics - page of statistics includes closest states, max, min, counties, etc.
Voter Turnout by State - voting age population data and voter turnout by state.
Data Sources - a list of data sources used to compile the spreadsheet.

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-AE		<name>		Popular vote for Candidate listed in row 1
AF				No Data
AG-AJ		<abbrev>	Rank of 4th - 7th candidates
AK-AN		<name>		Percentage of total vote for candidates 4 through 7
AP				County or State Name
AQ				County or State Two-Character Abbreviation
AR		CD		Congressional District (if blank, county is split amongst multiple districts)
AS				No Data
AT		ST		State FIPS code
AU		CTY		County FIPS code
AV		FIPS		Five-number combined state and county FIPS Code
AW				No Data
AX		LSAD_TRANS	Shape type (county, state, city, parish)

Cong Dist Tab
(Note: the congressional district tab includes both the summary of votes by congressional district and the complete list of votes by county split out by congressional district)
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-AE		<name>		Popular vote for Candidate listed in row 1
AF				No Data
AG-AJ		<abbrev>	Rank of 4th - 7th candidates
AK-AN		<name>		Percentage of total vote for candidates 4 through 7
AP				County or State Name
AQ				County or State Two-Character Abbreviation
AR		CD		Congressional District (if blank, county is split amongst multiple districts)
AS				No Data
AT		ST		State FIPS code
AU		CTY		County FIPS code
AV		FIPS		Five-number combined state and county FIPS Code
AW		Type


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-AE		<name>		Popular vote for Candidate listed in row 1
AF				No Data
AG				County Subdivision or State Name
AH				County Name
AI		CD		Congressional District (if blank, County Subdivision is split amongst multiple districts)
AJ				No Data
AK		ST		State FIPS code
AL		CTY		County FIPS code
AM		MCD		Census MCD code
AN		COUSUBF		County Subdivision FIPS code
AO		FIPS		Five-number combined state and county FIPS Code
AP		Subdivision	County Subdivision Shape type (town, city, unincorporated territory (UT), etc.)
AQ		Town FIPS	Seven-number combined State and County Subdivision FIPS Code