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)
  • 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.
  • 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-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