Over the weekend I had a major mishap in my understanding what the Votes table in the Stack Exchange Data Explorer actually contains.
For the last 6 to 8 years I assumed the schema only contains data for not deleted posts with a few exceptions, PostsWithDeleted and PostLinks. So when Jon Ericson shared a query that joined Votes and PostsWitdDeleted I told him that couldn't be correct. I convinced myself being right because a slightly adapted query by me showed way lower numbers. I did expect those to be zero, so I checked a few and all seemed to be related to roomba deletion, so I blamed the roomba script, put it to rest and called it a day.
On a revisit today I ran this query and that taught me that there are way more votes for deleted posts still in the votes table than can be explained by a roomba issue:
The conclusion so far: the votes for deleted posts are somewhat in the Votes table after handchecking a good 30 posts.
What is the story of these Votes for deleted posts? Is this meant to be this way or is there something broken in the sanitizing script?