Main question: (was previously secondary question)
How would I get the correct number of close votes currently on a question in Data Explorer (subject to DE caching of course)?
I now believe the below to likely be caused by vote expiration (due to users selecting 'Leave Open' on the review queue) (feel free to say otherwise if this is not the case), so, since this didn't have an (undeleted) answer, I've changed this to ask the above.
Elaboration:
I was just running some Data Explorer queries, but found the vote counts to be inaccurate.
The data explorer query says there are 3 close vote (in total, all after reopening), but the post only says there is one.
The post has less than 100 views (which will probably change a few minutes from now), so the votes shouldn't have expired.
Nothing new in the revision history...
Can someone explain this?
(Note that all activity is more than a year ago, i.e. it's unlikely to be because Data Explorer's results are a bit old)
Here's a query that shows all votes (not just close votes), if that's helpful:
It's seemingly missing the initial moderator close, but, even if the dates are incorrect and one of the later ones are it, there's still one missing vote.