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 am looking at the Data Explorer and attempting to get a listing of tags flagged as spam (I'd like to use them to help build a spam identifier eventually, but that is not relevant to this question).

This query shows that 12 is the VoteType associated with spam

select * from votetypes 

This shows the most recent spam flags

select creationdate, count(*) 
from votes where votetypeid = 12 
group by creationdate order by creationdate desc

But, it is showing a very low number of spam flags (at least what I'd expect). Is this not an accurate way to detect which posts are flagged and removed as spam? Or are these particular questions not included in the data on the Data Explorer?

I am the original poster. This doesn't seem to have been associated with my account when I registered for Meta Stack Overflow. If that could be done, that would be helpful.

To answer the question below about why I'd like the spam posts - I am attempting to train a spam filter using a few different corupuses (corpii?). I had been hoping that the data dump provided by Stack Overflow would contain some such data.

share|improve this question

migrated from Mar 5 '14 at 12:51

This question came from our site for professional and enthusiast programmers.

This type of question belongs on Meta. I flagged it to be moved there – Andy Feb 28 '14 at 0:18
Deleted post are not included in the SEDE. – Braiam Mar 1 '14 at 22:23
Just my curiosity, but why would you like to read spam? – Mołot Mar 5 '14 at 13:14
@Mołot, training a bayesian filter, maybe. – Frédéric Hamidi Mar 5 '14 at 13:39
@NewGuy: you must've created a new login here with a different OpenID account or email address. See How can one link/merge/combine/associate two accounts/users? (Anonymous/unregistered/cookie or OpenID/registered) for assistance. – Martijn Pieters Mar 5 '14 at 14:18

Spam posts are eventually (...obviously) deleted. And, since there are no deleted posts kept in the SEDE, you won't be able to filter on or find these.

share|improve this answer

You must log in to answer this question.