The 2004-2008 County Presidential True Vote Database Model

The 2004-2008 County Presidential True Vote Database Model

March 23, 2012

The 2004-2008 County True Vote Database Model has been restructured. Just enter the state code in cell A2 of the new “Input” sheet.

The objective of the model is to determine the most fraudulent counties in 2008. No model is perfect, but the TVM provides a good estimate of election fraud as measured by vote share and vote count discrepancies in margin from the recorded vote.

The following states are currently in the database. More states will be added:
AZ CA CO FL GA IA IL IN MA MI MO NC NM NV NY OH OR PA TN TX WI

In 2004, Kerry lost the national recorded vote by 50.7-48.3%. He had 51.1% in the unadjusted state exit polls (76,000 respondents) and 51.7% in the unadjusted National Exit Poll (a subset with 13,660 respondents). The True Vote Model sensitivity analysis provides convincing evidence that Kerry won the election easily.

In 2008, Obama won the national recorded vote by a 52.9-45.6% margin. He had a 58% share in the unadjusted state exit polls (83,000 respondents) and a whopping 61% in the unadjusted National Exit Poll (a subset with 17,836 respondents).

The key stats are shown in the “Input” sheet. These include the state True Vote table and discrepancies between Obama’s True county vote margin and the recorded margin. Calculation details are displayed in the “Model” sheet.

The 2008 Election Model projection exactly matched Obama’s 365 electoral votes and was within 0.2% of his 52.9% share (a 9.5 million margin).

But the model understated his True Vote. The forecast was based on final likely voter (LV) polls that had Obama leading by 7%. The registered voter (RV) polls had him up by 13% – before undecided voter allocation. The landslide was denied.

The Final 2008 National Exit Poll was forced to match the recorded vote by indicating an impossible 103% turnout of living Bush 2004 voters and 12 million more returning Bush than Kerry voters. Given Kerry’s 5% unadjusted 2004 exit poll and 8% True Vote margin, one would expect 7 million more returning Kerry than Bush voters – a 19 million discrepancy from the Final 2008 NEP. Another anomaly: The Final 2008 NEP indicated there were 5 million returning third party voters – but only 1.2 million were recorded in 2004. Either the 2008 NEP or the 2004 recorded third-party vote share (or both) was wrong.

The True Vote Model determined that Obama won by over 22 million votes with 420 EV. His 58% share was within 0.1% of the unadjusted state exit poll aggregate (83,000 respondents).

True Vote margins are calculated based on the returning voter method: The default method is that 2004 voters return to vote in 2008 in proportion to the 2004 state exit poll shares. Optionally, set code 1 in cell A5 to calculate returning voters in proportion to the 2004 recorded vote shares.

If the recorded vote option is used, county vote discrepancies will be lower than they would be if the default method was used. But since the 2004 recorded votes were fraudulent, unadjuted 2004 exit polls (the default) should be used to calculate returning voters to provide a better estimate of the true discrepancy.

The model automatically adjusts state and county vote shares based on the differential between the unadjusted state and national exit polls.

The user has the option of overriding the returning voter mix as well as the vote shares. Enter incremental percentage changes to a) Kerry’s returning vote counts (an automatic offsetting change is made to Bush’s vote count) and b) to Obama’s shares of new and returning voters (an automatic offsetting change is made to McCain’s vote shares.

Default 2004 living voter turnout in 2008 is set to 97%.

The model indicates that the following counties were the most fraudulent:
Wisconsin
Obama recorded share: 56.2%, Exit Poll: 63.3%, True Vote Model: 58.8%
Waukesha,Sheboygan,Washington,Milwaukee

Ohio
Obama recorded share: 51.4%, Exit Poll: 56.3%, True Vote Model: 56.2%
Cuyahoga,Franklin,Hamilton,Montgomery,Summit

Florida
Obama recorded share: 50.9%, Exit Poll: 52.1%, True Vote Model: 54.7%
Palm Beach, Miami-Dade, Broward, Brevard, Hillsborough

New York
Obama recorded share: 62.8%, Exit Poll: 71.5%, True Vote Model: 68.3%
Nassau, Suffolk, Erie, Queens, Westchester

Pennsylvania
Obama recorded share: 54.5%, Exit Poll: 63.8%, True Vote Model: 62.0%
Philadelphia, Allegheny, Bucks, Westmoreland, Montgomery, Delaware

The correlation ratio is a statistical measure of the relationship between Obama’s recorded vote share and the True Vote discrepancy. In general, there is a strong negative correlation between the two variables. This indicates that as Obama’s recorded county vote share increases (decreases) the discrepancy decreases (increases). This is an indication that GOP counties are the most fraudulent (measured by vote share margin discrepancy).

The correlation ratio is in the range from -1 to +1 (-1 is a perfectly negative correlation and +1 is perfectly positive). A near zero correlation indicates little or no relationship. A positive value indicates that the variables generally move in the same direction: as one variable increases (decreases), the other also increases (decreases). A negative value indicates the opposite: as one variable increases (decreases) the other decreases (increases). The correlation is a strong one if it is higher than 0.50 (positive) or lower than -0.50 (negative).

For example, in Ohio 2004 the -0.82 correlation indicated that Bush counties were more fraudulent than Kerry counties (based on vote share margin discrepancies). In 2008, the -0.50 correlation was not as strong but still significant.

North Carolina was an unusual exception. In 2004 there was a near-zero (-.01) correlation, indicating no relationship between county partisanship and election fraud. But in 2008, the strong negative (-0.72) correlation indicates that election fraud was more prevalent in GOP than Democratic counties.

County Correlation Ratios between the Democratic Recorded Vote and
the True Vote Share Margin Discrepancy
State 2004 2008
NC -0.01 -0.72
WI -0.70 -0.50
OH -0.82 -0.50
NY -0.62 -0.45
FL -0.43 -0.79

 

2000-2004 Presidential Elections County True Vote Model

2000-2004 Presidential Elections County True Vote Model

Richard Charnin

March 28, 2012

The database has been restructured for easier use. It is based on county recorded vote changes and 2000 and 2004 as well as National Exit Poll vote shares. It now calculates the approximate 2004 True Vote for counties in 21 states.

The 2004 County True Vote Model:
https://docs.google.com/spreadsheet/ccc?key=0AjAk1JUWDMyRdDNzZWhMcF9sS3pHRWdUZE8zdEs4aGc#gid=23

In 2000, Gore won the unadjusted state exit polls by 50.8-44.4%. He won the National Exit Poll by 48.5-46.3%

In 2004, Kerry won the unadjusted state exit polls by 51.1-47.6%. He won the National Exit Poll by 51.7-47.0%%

The database contains Election Day recorded votes. In 2000 approximately 2.7 million votes were recorded after Election Day; in 2004 approximately 6 million were. Gore and Kerry each had 55% of the late two-party vote.

In 2000, there were approximately 6 million uncounted votes. In 2004, there were approximately 4 million. Gore and Kerry had 70-80%. Total Votes Cast, which includes uncounted votes, are not available by county and therefore not included in the County True Vote calculations. Therefore, the Democratic County True Vote is conservative (uncounted votes are 70-80% Democratic). Total votes cast are included in the National and State True Vote models.

The number of returning 2000 voters is calculated assuming 5% voter mortality over the four year period. The default turnout assumption is that 98% of living 2000 voters voted in 2004.

The number of new voters is calculated as the difference between the 2004 recorded vote and the number of returning 2000 voters. This is just an approximation since the recorded 2000 county vote is used – not the True Vote based on total votes cast .

The Model uses adjusted 12:22am National Exit Poll vote shares as a basis for calculating total state and county vote shares. The adjusted shares are applied to each county’s estimated share of new voters and returning Gore, Bush and Other voters. The weighted average of the county vote shares should closely match the calculated state True Vote.

State and county vote shares are calculated based on the differential between the unadjusted state and national exit poll shares.

The Input sheet is for data entry. Enter the state code in cell A2.

The default assumption is that 2000 voters return to vote in proportion to the 2000 unadjusted exit poll. Enter code 1 to use the 2000 recorded vote as the returning voter option. Since the unadjusted 2000 exit poll is close to the True Vote, the default option is a better choice.

The user has the option of incrementing the returning Gore voter mix percentage. The Bush share will decrease (increase) by the same percentage.

The living 2000 voter turnout rate is set to 98%, but can be changed if desired.

In order to gauge the impact of changes in vote shares, incremental changes to Kerry’s base case vote shares can be input. Bush’s shares will adjust automatically in the opposite direction (the total must equal 100%). Other third-party vote shares are unchanged.

Analyzing the results
The data is sorted by 2004 county vote. The discrepancies are displayed as vote margin (in thousands) and a percentage. The probability of fraud increases as the discrepancy increases. The county True Vote is only an estimate. It can only be determined if the ballots are hand-counted.

The correlation statistic shows the relationship between two variables and ranges from -1 to +1, where -1 is a perfectly negative correlation and +1 is perfectly positive. A near-zero correlation indicates that there is no relationship. A positive correlation indicates that both variables move in the same direction: as one variable increases (decreases), the other also increases (decreases). A negative correlation indicates just the opposite: as one variable increases (decreases) the other decreases (increases).

The model calculates the correlation statistic (relationship) between Kerry’s recorded vote share and the True Vote discrepancy. In general, there is a strong negative correlation between the variables, indicating that as Obama’s recorded county vote share increases (decreases) the discrepancy decreases (increases). This is an indication that the GOP counties are the most fraudulent (as measured by vote share margin discrepancy).

For example, in Ohio, the -0.82 correlation was very strong indicating that Bush counties were extremely fraudulent relative to Kerry counties (based on vote share margin discrepancies).

County Correlation Ratios between the Democratic Recorded Vote and
the True Vote Share Margin Discrepancy
State 2004 2008
NC -0.01 -0.72
WI -0.70 -0.50
OH -0.82 -0.50
NY -0.62 -0.45
FL -0.43 -0.79

Florida
At 8:40pm CNN showed that of 2846 exit polled, Bush led by 49.8-49.7%.
Kerry won the unadjusted exit poll (2862 respondents) by 50.8-48.0%.
But at 1:41am, the poll flipped to Bush (52.1-47.9%) for the SAME 2862 RESPONDENTS, matching the recorded vote a 381,000 vote margin.
Kerry won the True Vote by 52.7-46.1%, a 500,000 vote margin.

Kerry’s largest discrepancies from the True Vote were in DRE counties:
Broward, Hillsborough, Palm Beach, Dade, Pinellas.
Most fraudulent counties based on…
Votes: Dade Broward Palm Beach
Margin: Broward Palm Beach Volusia Polk

Ohio
At 7:30pm CNN showed that of 1963 exit polled, Kerry led by 52.1-47.9%
Kerry won the unadjusted exit poll (2020 respondents) by 54.1-45.9%.
At 1:41am, the poll flipped to Bush (50.9-48.6%) for the SAME 2020 RESPONDENTS, matching the recorded vote, a 119,000 vote margin.
Kerry won the True Vote by 53.1-45.5%, a 426,000 vote margin.

Ohio used Punched card machines, DREs and Optical Scanners.
Most fraudulent counties based on…
Votes: Cuyahoga Franklin Montgomery Butler
Margin: Butler Warren Clermont

New York
All counties Lever machines.
Kerry won the recorded vote by 58.4-40.1%, a 1,251,000 vote margin.
Kerry won the Exit Poll by 62.1-36.2%.
Kerry won the True Vote by 63.0-35.1%, a 2,060,000 vote margin.
Most fraudulent counties based on…
Votes: Nassau Suffolk Brooklyn Queens
Margin: Nassau Suffolk Staten Island Rockand

Wisconsin
Kerry won the recorded vote by 49.7-49.3%, an 11,000 vote margin.
Kerry won the Exit Poll by 52.0-46.8%.
Kerry won the True Vote by 52.8-45.6%, a 217,000 vote margin.
Most fraudulent counties based on…
Votes: Waukesha Brown Sheboygan
Margin: Waukesha Brown Sheboygan Washington

Arizona
In 2000 Gore won the exit poll (47.2-46.4%) but lost the vote by 50.9-44.7%.
In 2004, Bush won the exit poll (52.8-46.3%) and the recorded vote (54.9-44.4%).

But Kerry won the True Vote by 52.0-46.2% (assuming 2000 voters returned in proportion to the 2000 exit poll). If the model is correct, there was massive election fraud (a 16% discrepancy).

Pennsylvania
Most fraudulent counties based on…
Votes: Allegheny Montgomery Bucks
Margin: Northampton York Westmoreland

 

The 2000-2004 Presidential County Recorded Vote Database

Richard Charnin
March 1, 2012
Updated: Oct.27, 2015

The 2000-2004 Presidential County Recorded Vote Database

Matrix of Deceit: Forcing Pre-election and Exit Polls to Match Fraudulent Vote Counts
LINKS TO WEB/BLOG POSTS FROM 2004

The 2000-2004 Presidential County Vote Database is a forensic spreadsheet tool for viewing, filtering, sorting and comparing county vote changes from 2000 to 2004. It is important to note that the database contains Election Day recorded votes. The state True Vote is calculated as well. The 2004 county voting machine type is indicated.

The database consists of two worksheets:
Part 1 (AK-MN):https://docs.google.com/spreadsheet/ccc?key=0AjAk1JUWDMyRdGFHdkloa0FUeUp0dmlRbFl6bjViQkE#gid=1

Part 2 (NC-WY): https://docs.google.com/spreadsheet/ccc?key=0AjAk1JUWDMyRdEMxYmxrWElBeTdZWWhtMHZrSEZQa0E#gid=1

Filtering and sorting the database:
1. Click the arrow in cell A13
2. Click the Clear button
3. Enter the state code to filter the 2000-2004 county votes.
4. Click OK
5. Sort Option (optional):
Sort any column by clicking the arrow in row 13 of the column.
Choose A-Z for low to high or Z-A for high to low.
Examples: Filter for a state, then sort by county vote, vote share, machine type, etc.

In 2000 Gore won the recorded vote by 540,000. But there were nearly 6 million uncounted votes. Gore won the unadjusted exit poll by 50-44% – a six million vote margin that was close to the True Vote Model.

In 2004, Bush won the recorded vote by 3 million. There were nearly 4 million uncounted votes. Kerry  won the unadjusted exit poll by 51-47.5%. The True Vote model indicates that he had 53.5% and won by 10 million votes.

Why bother to analyze state and county recorded votes? What if a county had a near-zero percentage increase in Bush’s 2004 margin from 2000? In other words, if there was nearly equal fraud in both elections, how would we know? If we have evidence of 2004 fraud in a given county, but there was no change in margin from 2000, then we can hypothesize that fraud also occurred in 2000. Conversely, if there was a change in margin in 2004, we could hypothesize that there was an increase in the fraud factor. Since Election Fraud is systemic, the 2000/2004 county vote database has applicability in other state and presidential elections.

New York

New York had the highest level of fraud; there was a 55% average difference between comparable Kerry and Bush correlations. Florida was next at 49%, Ohio had 35%. Oregon, the only vote-by-mail 100% paper ballot state with mandated random county hand-recounts, had just a 4% difference. The results confirmed a prior analysis which indicated a) that Oregon stood alone as the only fraud-free Battleground state and b) confirmed that election fraud caused the large exit poll discrepancies in New York, Florida and Ohio- and many other states.

Bush’s 2004 recorded NY county vote gain over 2000 is indeed an Urban Legend. His percentage gain in the 15 largest NY urban and suburban (Democratic) counties far exceeded those of Kerry. In 2000, Gore won the NY recorded vote by 60-35% with 5% to third parties. But Kerry won by just 58-40%, a 7% decrease in margin. NY voted exclusively on Lever machines which had the highest discrepancies (11%) of all voting machine types.

In 2004, Nader had less than 0.5% of the vote nationally. Since returning Nader voters preferred Kerry over Bush by 64-17%, Kerry should have won NY by 63-36% (assuming zero net defections of returning voters). In fact, he won the unadjusted exit poll by 62.1-36.2%. But his recorded margin exceeded Gore in just 6 of 62 counties.

Columbia was the ONLY COUNTY where Bush had fewer votes than he did in 2000 – an indication of zero fraud. Bush had 12,100 votes in 2000 and 11,200 in 2004.
This graph shows Bush and Kerry percentage gains over 2000 in the 15 largest NY counties.http://www.richardcharnin.com/TIACountyVoteDatabase_24111_image001.png

The Bush Urban Legend is also illustrated in this graph which shows the implausible high (0,61) correlation between NY county population size and Bush percentage gain from 2000.http://richardcharnin.com/TIACountyVoteDatabase_14517_image001.gif

Florida

Gore won the FL unadjusted exit poll by a whopping 53.4-43.6% (3% to Nader et al), but Bush won by 537 votes. They were tied at 48.8% – only because the Supreme Court stopped the recount. There were nearly 200,000 uncounted spoiled ballots, a combination of undervotes, overvotes, Butterfly ballots, etc.  

Contrary to the conventional wisdom, Kerry led the 2004 pre-election polls.
http://richardcharnin.com/FL04exitpoll_12679_image001.png

In 2004 Bush won again, this time by 52.1-47.9%. Returning Nader 2000 voters broke by nearly 4-1 for Kerry, who also won the unadjusted exit poll by 50.8-48.0%. So how did Bush do it? Well, for one thing FL voting machines were now a mix of unverifiable DREs and Optical scanners. No more punch cards. No more hanging chads. HAVA fixed that problem, so that votes could be stolen cleanly in Cyberspace. No longer would there be blood evidence at the crime scene.

The biggest Democratic counties (Palm Beach, Broward and Dade) showed  virtually no change in Bush’s margin from 2000 to 2004. But changes in county recorded votes can be misleading. Does no change mean that there was no fraud? Obviously not. Election Fraud in both 2000 and 2004 caused Gore and Kerry margins to decline at nearly the same rate. The near-zero net change in margin masks the uniform vote thefts. But the the level of fraud must have increased in counties where Bush gained the most over his 2000 vote (Brevard, Polk, Hillsborough, etc.). Margins increased by 4% in Hillsborough, 7% in Broward and 6% in Palm Beach. These counties used DRE touchscreens in 2004.

Of the 67 Florida counties, Kerry did better than Gore in just five, whereas Bush increased his margin in 62. But in Leon County there was a 10,000 increase in Kerry’s margin, his biggest county gain. Does the fact that Ion Sancho, the Election Integrity activist whose famous “Hursti Hack” demonstrated that Optical Scanners can be rigged and also happens to be the Leon County Election Supervisor, have anything to do with it? 

Oregon

This 100% paper ballot state uses Optical scanners. Vote is by mail or hand-delivery of ballots to a polling site. A hand recount of ballots is mandated for randomly selected counties. Not surprisingly, with the combination of mandated hand counts (a fraud deterrent) and high turnout, Oregon was the only Battleground state that Kerry won by a margin better than Gore.

Gore won Multnomah, Oregon’s largest county, by 104,000 votes (64.3-28.6%). But Kerry did even better. He won it by 152,000 votes (72.5-27.5%) and apparently picked up a large number of returning Nader 2000 voters. It’s very telling to compare Kerry’s expected gains in urban Multnomah to Bush’s impossible, unexpected gains in heavily Democratic NY counties.

Oregon is a 100% paper ballot state, mandates random hand recounts and enjoys heavy voter turnout. Do these factors have anything to do with Oregon being the only Battleground state in which Kerry’s winning vote share exceeded that of Al Gore?

Ohio

In 2000, Bush beat Gore by 50.0-46.5%, but the exit poll was close (48.5-47.4%). In 2004, Kerry won the exit poll by a solid 54.1-45.7% but lost the recorded vote by 50.8-48.7% – quite a red-shift. Although there were many Battleground states and strong Democratic states in which vote miscounts favored Bush, Ohio was the epicenter of election fraud. The majority of its 88 counties voted on punch card machines, the rest on DREs and Optical scanners.

In 2000, Gore won Cuyahoga County (Cleveland) by 63-34%. Kerry did even better; he won by 67-33%. Kerry had a 61,000 net gain in margin. But keeping in mind that these are recorded vote shares. Based on the vast evidence of documented fraud, Gore and Kerry must have done much better than their recorded votes indicate. Bush vote gains from 2000 were highest in Butler, Warren and Clermont counties. All had numerous voting irregularities and anomalies.

Did Ken Blackwell, Secretary of State and co-chair of the Ohio Bush-Cheney campaign, have anything to do with Kerry losing Ohio ?

Look inside the books: 
Reclaiming Science: The JFK Conspiracy 
Matrix of Deceit: Forcing Pre-election and Exit Polls to Match Fraudulent Vote Counts
LINKS TO WEB/BLOG POSTS FROM 2004
JFK Calc Spreadsheet Database