What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 133 Stack Exchange communities.

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

share|improve this question

1 Answer 1

up vote 12 down vote accepted

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.)

share|improve this answer
1  
Would appreciate your input here: meta.stackexchange.com/questions/208806/… –  Shog9 Nov 24 '13 at 20:57

You must log in to answer this question.

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