The author’s analysis of the Wisconsin election database, based on data from the November 10 election, reveals many problems with the state’s database, including missing information, mismanagement, no effective mechanism to prevent duplicate ballots, and the ability to create voter counts at any time.
Skyrocketing Download Fees Justice Citizen Open Database
At the beginning of this article, I will briefly discuss the history of this database.
When a Wisconsin citizen heard about fraud in his local election, he was concerned that his ballot had been tampered with and wanted to check the government database. The election database website is publicly available (https://badgervoters.wi.gov/) and anyone can check it, but he was shocked when he opened the site and was told that it cost $12,500 to download the voter list data, $12,500 to download the mail-in ballot data, and $25,000 to buy the entire data set.
The cost to download a single form from the Wisconsin Election Database is $12,500. (Screenshot from the Wisconsin Elections website)
He was furious that a database that could be downloaded for free or at most a few tens of dollars out of state was as expensive as buying a new car in Wisconsin! If voters don’t have that kind of money, don’t they deserve to see the state’s database?! This is not Venezuela, China, or Cuba, this is the United States of America!
He turned his anger into action and decided to defend his right to the truth, literally spending $25,000 to download the entire file. When he finally opened the database, he was shocked again – the extreme confusion of information, the huge gaps in numbers, how to sort through it all? So, he put the database up on the Internet for free public download.
The author thus gained access to this hard-to-get database.
As I write this, it occurs to me that I am pitching a book to a news media outlet, so it has to be newsworthy! The changing face of the big times is news, but how can the thoughts and actions of the little people who shape the big times not be news? The author asked the editor to let this description remain here. Hopefully, this citizen will know that we are using the database he bought and that his dedication was not in vain. Here’s to this citizen’s dedication!
Basic Database Information
The analysis of this dataset snapshot of the November 10 Wisconsin election begins below.
First, the data underlying the material, the database provides two tables, Voter Vote History and Registered Voter List.
The voter ballot history table contains 36 attributes, one of which is the Election Name, which, when labeled as the “2020 General Election,” is the Record of “mail-in” ballots sent out for this year’s election. One by one, 2,152,453 ballots were counted, indicating that 2,152,453 ballots were mailed.
Excluding misaddressed, damaged, unreturned, and duplicate ballots, only 1,949,121 ballots were returned. In other words, 1,949,121 people voted by postal ballot.
The voter registration form contains 120 attributes and contains approximately 6,994,368 voters (the database is not properly maintained, so it can only be an approximation).
The voter list includes an attribute called “November 2020”, which records the two methods of voting in the election: Absentee ballots, which totaled 745,405, and At Polls, which numbered 485,135.
Adding together the votes cast by the two voting methods, the author found that 1,230,540 people voted in the election.
Database Information Asymmetry Data Gap is Huge
The ballot history table shows 1,949,121 people voted by mail, while the registered voter list table shows 745,405 people voted by mail. Even if you add in the 485,135 people who voted in-person, only 1,230,540 people on the voter registration forms voted in this election! Between the two tables, which poll number is true?
Also, the voter registration forms clearly show 1,230,540 people have voted, yet CNBC News reported on November 4 that over 3.1 million people in Wisconsin had voted and Biden had won!
What are the valid ballot data released to the news media by the State of Wisconsin? Where did CNBC News get the figure of more than 3.1 million votes cast in Wisconsin?
The author recommends that the State of Wisconsin and CNBC News explain to the public, openly and honestly, that they are legally obligated to do so.
In my analysis of the fraud in the Pennsylvania database, I have explained in detail that if the number of voters in the database is significantly lower than the number reported in the news at the same time, the “update polling day” feature is not working and it is impossible to tell whether a person has voted or not.
Again, the author emphasizes that databases that do not have the “update voting day” feature are intentionally designed to allow repeated voting.
Wisconsin is worse off in this regard than Pennsylvania in terms of the ratio of the numbers in the database to the numbers reported in the news.
There are more voters in the database than the total population of Wisconsin.
How can there be 6,994,368 voter records in the database when the total population of Wisconsin is only 5,860,000, and excluding the population under 18 (20%), there are only 4,680,000 adults?
The difference is 2,314,368, which means that a third of the registered voters in the database should not exist. If such a database were used for elections, no election in Wisconsin would ever again be fair.
As an example: From the 1,230,540 voters counted on the voter registration form for this election, I see that the same person had two voter numbers and voted (note: the voter information and address in the comparison below is the same, so it is confirmed to be the same person, but the address is not listed here for privacy reasons): the same person had two voter numbers and voted. (Data source: the Wisconsin Election Database)
Database Management Chaos Questions Trustworthiness
I also see 558 Inactive voters in this database who have voted. The State of Wisconsin requires that an inactive voter becomes an “Inactive Voter” after four years. However, an Inactive voter can become an Active voter by showing an ID. So the 558 inactive voters who have already voted should actually be counted as active voters. Whether this is an arbitrary addition or an administrative mess is unknown.
When I augmented the two forms into the database, thousands of voters were each screened out by the parsing program: there were blank voter numbers, garbled codes, broken lines, blank application dates that could not be added, etc. It took a lot of time to get most of the voters’ information into the database. It took a lot of time to successfully enter most of the voter information, but some of it could not be fixed. This is the true deplorable nature of this expensive database.
Will deceased people come to vote in such a ridiculous database? Yes, here it comes. Look at this line of record in the database, this woman voted using a mail-in ballot.
The database shows that a Wisconsin woman who died in 2018 participated in a mail-in ballot in this year’s general election. (Data source: the Wisconsin Election Database)
However, the database shows that she is Deceased, and as you can search online, this woman did die in January 2018.
I also found that there are more than 550,000 voters marked as “deceased” in the database for “Voter Status Reason,” a total of 559,201 voters, which accounts for more than 50% of the total number of voters in the database. 7.995%.
This database makes this writer completely lose faith in Wisconsin’s ability to have a fair election! I don’t see an effective mechanism to prevent duplicate ballots, two numbers for a registered voter, even the number of voters can be created at any time….
Wisconsin’s voter database is one of the most baffling that I have seen so far in state databases. It can take a long time to fix, even longer than it would take to rebuild one.
Recent Comments