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'd love to see if there are trends over time, patterns of improving behaviour after being flagged, consistent reoffenders, most misused types of flag, etc.

I understand the who-said-what-about-who aspect would most likely cause this to be denied, but even anonymised data would be interesting to dig through.

share|improve this question
up vote 3 down vote accepted

Well, this would be nice to have, but the data needed to do the analysis isn't available publicly.

The vast majority of the data is deleted content -- either spammy posts that have been flagged into the stone age, or simply flags that have decayed away. None of that is included in the data dump. The only part that can be had are the "in progress" spam/offensive flags, which have been flagged very recently relative to when the data dump was produced.

So as I said, doing a trend analysis would be nice to do here, but at this point it's not possible. I wouldn't say it will never be possible... though you'll have to argue for deleted content to be available in the data dump, which is a pretty tall order.

share|improve this answer
Hmmm... Interesting. Is there remit for the data dump to be extended to some rudimentary post information (not body text for example), for reasonably recent flagged posts? A day/week? – Stuart Pegg Mar 22 '11 at 22:37
I guess a deleted data is deleted data, thinking about it. Troublesome. – Stuart Pegg Mar 22 '11 at 22:39
@Stuart: Well, as I said, some of this data does exist in the dump -- flags that aren't deleted. But the few of those won't really be much help in the analysis you want to do. – Jon Seigel Mar 23 '11 at 16:33
Indeed. As in any analysis, useful conclusions can rarely be drawn from incomplete data. Thanks for looking into it anyway. – Stuart Pegg Mar 23 '11 at 16:53
@Stuart: You're welcome. – Jon Seigel Mar 23 '11 at 16:54
@JonSeigel : it already exist. Did you also know that link to deleted questions were available in data Dumps? – user2284570 May 25 '15 at 19:49

It’s already available.

Just look at the PendingFlags table


  • Id
  • FlagTypeId (listed in the FlagTypes table)
    13. canned flag for closure
    14. vote to close
    15. vote to reopen
  • PostId
  • CreationDate
  • CloseReasonTypeId (listed in the CloseReasonTypes table)
  • CloseAsOffTopicReasonTypeId, if CloseReasonTypeId = 102 (off-topic) (listed in the CloseAsOffTopicReasonTypes table)
  • DuplicateOfQuestionId, if CloseReasonTypeId is 1 or 101 (old duplicate or current duplicate)
  • BelongsOnBaseHostAddress, for votes to close and migrate

I already used it in some of my queries when I thought it was good to tool for finding question that should be closed.

share|improve this answer

You must log in to answer this question.

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