Inconsistent values in 2020 Hood County general source file

[warwickmm]

The source file for the 2020 Hood County general results contains values that are inconsistent. It is often the case where the sum of the components (mail, early voting, election day, provisional) is not equal to the total votes.

For example, the total ballots cast should be 288 + 1809 + 474 + 16 = 2587 instead of 2585. In fact, many of the totals appear to be off by 2.

Headers: ['county', 'precinct', 'office', 'district', 'candidate', 'party', 'votes', 'mail', 'early_voting', 'election_day', 'provisional']:
Row 479: ['Hood', 'Precinct 2', 'Ballots Cast', '', '', '', '2585', '288', '1809', '474', '16']
Row 480: ['Hood', 'Precinct 2', 'President / Vice President', '', 'Donald J. Trump / Michael R. Pence', 'REP', '2002', '165', '1434', '396', '9']
Row 487: ['Hood', 'Precinct 2', 'U.S. Senate', '', 'John Cornyn', 'REP', '1949', '170', '1396', '375', '10']
Row 494: ['Hood', 'Precinct 2', 'U.S. House', '11', 'August Pfluger', 'REP', '1941', '154', '1393', '386', '10']
Row 496: ['Hood', 'Precinct 2', 'U.S. House', '11', 'Wacey Alpha Cody', 'LIB', '53', '2', '31', '20', '2']
Row 499: ['Hood', 'Precinct 2', 'Railroad Commissioner', '', 'James "Jim" Wright', 'REP', '1937', '166', '1387', '376', '10']
Row 505: ['Hood', 'Precinct 2', 'State Senate', '22', 'Brian Birdwell', 'REP', '2012', '163', '1440', '399', '12']
Row 509: ['Hood', 'Precinct 2', 'State Representative', '60', 'Glenn Rogers', 'REP', '2164', '187', '1539', '428', '12']

[warwickmm]

Is there another source for this, or is this something we would want to reach out to the county for clarification?

[dwillis]

@warwickmm Probably need to talk to the county for clarification. Thanks for surfacing this.

[warwickmm]

No problem. The vote breakdown totals test is turning out to be more useful than I anticipated.

[dwillis]

I am both happy and sad about this.

[warwickmm]

Yes. I'm also afraid that since it's difficult to test for totals that are greater than the component sum, we're only catching half of these types of issues.

[JCinTX]

Note that the totals for President in this example shows Overvotes = 2 (apparently both in mail ballots.) Need to clarify with the county how that may occur and how they handle it in computing the total votes. Rather than recounting all the ballots it's possible they ignore it if the overvotes do not affect the election outcome. This is not an unusual occurrence. I've seen it in every election in my county (Collin). Undervotes, on the other hand, are easier to explain. Not everyone casts a vote for every office on the ballot.

…

On Tue, Sep 14, 2021, 12:25 PM warwickmm ***@***.***> wrote: No problem. The vote breakdown totals test is turning out to be more useful than I anticipated. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#373 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AMU23MJD2ZLI4EO6M4QLV4LUB6APLANCNFSM5EATWRVA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.