search

ElectionDataAnalysis / electiondata

Tools for consolidation and analysis of raw election results from the most reliable sources -- the election agencies themselves.
Other
20 stars 5 forks source link

Importing information from MIT file has discrepancies with actual results (2018 General) #700

Closed toddgraham121 closed 3 years ago

toddgraham121 commented 3 years ago

In the [wrong_by_at_least_0.05.xlsx](https://github.com/ElectionDataAnalysis/electiondata/files/6958112/wrong_by_at_least_0.05.xlsx) file, one of the column headers is Database_Count which corresponds to our internal database while the values that I acquired to test against are under the Reference_Count header.

The Reference_Count values for Minnesota were acquired using MN’s SOS site. The Reference_Count for both MN;Cass and MN;Stearns were calculated by summing the number of votes under the US Senator race.

The discrepancy between the Reference_Count and Database_Count (14024 vs 28009 for Cass County) is due to not including the US Senator Special Election results in the sum. By including the votes from both the US Senator and US Senator Special Election the sum of the total votes is 28014 which is still 5 off of the Database_Count. There was 1 Write-in vote for the US Senator race and 4 Write-in votes for the US Senator Special Election race. By subtracting those off, we would have 28009 votes which matches the Database_Count column.

sfsinger19103 commented 3 years ago

These errors are all internal to the MIT file (county2018.csv)