Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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