2000-2004 County Vote Data Part 1
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEF
1
2
2000-2004 Presidential County Vote Database 1 (AK-MN)
3
Updated: March 9, 2012
4
5
6
The database is a spreadsheet tool for viewing, filtering and sorting county vote election data.
7
Part 1 includes states AK-MN.
8
9
Ab approximate 2004 True Vote is calculated for each. counties. The model is based on estimated turnout of 2000 voters, calculated assuming either the 2000 recorded vote or exit poll. The 2004 National Exit Poll is adjusted based on the state/national vote share ratio. Due to memory size restrictions, the database had to be split into two Google spreadsheet docs.
10
11
Click for County Vote Database Part 2 (MO-WY)
12
https://docs.google.com/spreadsheet/ccc?key=0AjAk1JUWDMyRdEMxYmxrWElBeTdZWWhtMHZrSEZQa0E#gid=0
13
14
The values in the database are Election Day recorded votes. In 2000 approximately 2.7 million votes were recorded after Election Day. In 2004 approximately 6 million were recorded late. Gore and Kerry each had 55% of the late two-party vote.
15
16
In 2004, there were approximately 4 million uncounted votes. Kerry had 70-80%. Uncounted votes (Total Votes Cast) are not included in the database..
17
18
The number of returning 2000 voters in each county is calculated assuming 5% voter mortality over the four year period and a 98% turnout of living 2000 voters in 2004. .
19
20
The number of new voters in each county is the difference between the 2004 recorded vote and the number of returning 2000 voters.
21
22
The 2004 National Exit Poll 'How Voted in 2000' crosstab is used for calculating the True Vote.The vote shares are adjusted for each state. The county vote shares are assumed to be identical to the state shares. The returning voter mix is based on the change in county recorded votes from 2000 to 2004. The mix of returning voters as well as the vote shares can be adjusted by the user (i.e. to match the unadjusted state exit poll).
23
24
FILTERING THE DATABASE
25
To view FL 2000 and 2004 vote data:.
26
1) click the down arrow in cell A13
27
2) Click the state code that displays with a check mark to remove the mark
28
3) Enter FL in the input box.
29
4) Click over "FL" displayed below the box. A check mark will appear to indicate FL. was selected.
30
5) Click OK.
31
It takes a few seconds to bring up the county data.
32
33
IMPORTANT!
34
6) scroll to the right and enter FL in cell AC1 to calculate the True Vote for FL and its 67 counties.
35
36
Vote: Any column can be sorted in ascending or descending numerical or alphabetical order,
37
38
THE TRUE VOTE
39
The True Vote Model assumes identical state-level shares of returning and new voters. Obviously, there will be differences in Kerry’s share of returning Gore, Bush, Other (third-party) and New voters from his actual (unknowable) shares. But the approximations will generally be close. The weighted average of the county vote shares will closely match the True Vote. The state returning voter mix will display in the table along with the National Exit Poll vote shares. As stated above, the state returning voter mix and the vote shares can be changed to more closely reflect the state.
40
41
The user has the option of having the model force a match to the unadjusted 2004 state exit poll by automatically adjusting Kerry (57%) and Bush (41%) default national exit poll shares of new voters. The corresponding national shares of returning Gore, Bush and new voters are unchanged.
42
For example, Kerry had 62.1% in the NY unadjusted exit poll, but only 58.4% in the recorded vote recorded. He required 69.1% of new voters to match the exit poll.
43
44
WHAT-IF ANALYSIS
45
AB3 Incremental percentage change in the returning Gore voter percentage mix of the 2004 electorate.
46
AB4 enter 1 to use the unadjusted 2000 exit poll as the basis for returning Gore and Bush voters
47
AB6 Target Kerry's vote share: For example, enter '=AK6' to target the unadjusted exit poll provided in cell AK6.
48
AB7 Living 2000 voter turnout in 2004 is set to to 98%.
49
50
Incremental change in Kerry's share of
51
AI2 New voters
52
AI3 Gore voters
53
AI4 Bush voters
54
AI5 Other (third-party) voters
55
56
KEY RESULTS
57
Column W contains the change in Bush votes from 2000 to 2004
58
Column X contains the change in Bush margin from 2000 to 2004
59
Column AM contains the difference in margin between the True Vote and 2004 recorded vote. Again, this is just an approximation. We can never know the True Votes unless the ballots are hand counted. But the magnitude of the difference is a possible indicator of vote miscounts. In general, the probability of fraud increases as the difference in margin increases. But this is not always the case.
60
61
62
63
-4% (Election Supervisor: Leon Sancho)
64
-3% (Election Supervisor: Virginia Martin)
65
2% (100% paper ballots; random hand re counts)
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
Loading...