When I use the Stack Exchange Data Explorer (SEDE), the results I get don't reflect recent activity. Sometimes the data I get back are two months out of date. What's wrong?

This is intended to be a canonical reference for questions about SEDE not reflecting real-time results.

Return to FAQ index


1 Answer 1


SEDE does not query the production database in real time. It queries a data dump that is updated weekly.

Updates used to be monthly, and manual. For real-time data, Jeff suggests using the API; see Stack Apps for more information about that.

Note that the SEDE data dump is not the same thing as the Creative Commons data dumps.

  • 2
    Why isn't it updated more often? I presume you do database backups; restoring the backups should be part of the process to ensure that the backups are usable and complete. Couldn't those restorations power the SEDE site? Commented Apr 30, 2012 at 21:25
  • @MarkRansom SEDE's data are not an exact snapshot of the live data, for example votes are anonymized before the data find their way into SEDE.
    – yannis
    Commented May 1, 2012 at 2:18
  • @YahooAnswersenthusiast, you could probably achieve that by exposing views rather than the raw tables. Commented May 1, 2012 at 2:22

You must log in to answer this question.

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