I wrote Activity During a Bounty Period to try and get the date range for when a bounty is active on Stack Overflow. My aim is to see what other activity there was on the post while the bounty was active. You can see that the last few columns are coming from the Votes table. Note that the "Bount...

When a bounty is awarded, the vote is cast on the answer that receives the bounty, but you're always joining to question posts by virtue of having the join to the bounty start vote. This will, in effect, only return bounty completion information for bounties where no answer was chosen (either by ...