1. Change Log Update : I've spent some time going through the data to get a better understanding of the relationships between the rows, and how to identify batches of votes that were loaded into the system. I focused on the largest batches in CD-1, CD-10, and CD-11.
2. I was particularly focused on batches that had both Dem and Rep candidates for Prez, Senate, and House. The purpose was to compare the votes across the ballots. Expecting to see Prez with the largest numbers, and the Senate / House being lower numbers.
3. Well, this is true for the Dem candidates, but not for Rep candidates. I haven't manually checked all the batches, but this tends to hold true for smaller batches (less than 50K). Here is an example of what I mean for this unusual trend in the votes of these batches.
4. This example is a batch of votes that was loaded on 11/3 @ 9:44PM. This batch is restated / updated on 11/6 @ 4:31PM. The bold outlines represent the batch. You can see how Dems go from largest number to smallest as you go down ballot. However, for Reps it's reversed. Odd. 
5. I don't have an explanation for this, but, in a presentation by Dr. Shiva, he explains how election software can improperly count ballots votes. Since this data shows us the voting results of specific batches of ballots, this dataset might be useful in analyze these patters
6. The presentation was at the precinct level, but I think batch specific results would be helpful in determining that. Since we have these batches at the county / district level (these are absentee ballots), it could help hone in on areas where such calculation issues come from.
7. In the examplle I showed, the batch was in Loudoun County / 10 district. From the smaller batches I've checked from other counties / districts, this skewing doesn't seem to happen. Suggests this wasn't present in all places. Here's one more example.
8. This is a small batch example. Caroline County / District 1. Batch was loaded on 11/3 @ 8:35PM. Same batch was updated on 11/6 @ 4:03PM. Same trend as the large batch example. Dem goes large to small going down ballot. Rep small to large. Why?
9. While these examples relate to odd patterns in the batches, I've also spent some time looking in other areas. One is "tabulation errors" to see if there is anything unusual. I tweeted earlier about VA-7 Spanberger, and looked at the batches for this race closer.
10. In this example, we follow two updates. The first has no votes because this appears to be a preloaded entry in preparation for the election. First update : 11/4 @ 1:45AM. Second update : 11/4 @ 4:20PM. Both candidates show increases, but Spanberger +9000. More on that next
11. When I look at other "tabulation errors", the adjustments are normally very small as a percentage of the votes. This could be because not all ballots were run through, but it's not clear why this tabulation was so much larger than others in the dataset.
12. One note on the "ChangeReason" field, this appears to be a drop down that users select. "Change Comments" are free text fields that are optional. As you can see in the example, the bottom two rows has the user note "late arriving ballots added". Some users add longer notes
13. such as "post marked 11/3/2020 or before". I've not spent much time looking through these. But it is interesting to see some explanation related to the changes. I'll keep going through this, but now that's what I have to share.
@threadreaderapp unroll
• • •
Missing some Tweet in this thread? You can try to
force a refresh
