I ran this query

select distinct CreationDate
from votes
where (VoteTypeId = 6 OR VoteTypeId = 7)
order by CreationDate desc

and got

enter image description here

(That's showing the top of the list.) What's going on? I know SEDE data isn't updated in real-time, but I remember reading somewhere that a dump was uploaded at least monthly. There are 1,269,633 close and reopen votes in the Votes table, but none after June 25th, 2013:

select count(*)
from votes
where (VoteTypeId = 6 OR VoteTypeId = 7) AND CreationDate > DateAdd(dd, -151, GetDate())

Removing the VoteTypeId constraints, it's clear there are votes for other types.

I wrote a query that displays the CreationDate of the most recent Vote record per VoteTypeId:

enter image description here


This is a side-effect of the recent close vote changes. Specifically, there was a major refactoring of how flags and close votes work behind the scenes that happened along with the introduction of custom off-topic close reasons.

Close votes and flags are now stored in a different table, and unfortunately those database changes haven't made it into SEDE yet. I'll see what we can do about that.

(As a side note, the review data isn't available through SEDE yet either. We should probably include that, too.)

| improve this answer | |

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .