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

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?

Edit: I am the original poster. This doesn't seem to have been associated with my account when I registered for Metastackoverflow. 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 stackoverflow would contain some such data.

share|improve this question

migrated from stackoverflow.com Mar 5 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 at 0:18
7  
Deleted post are not included in the SEDE. –  Braiam Mar 1 at 22:23
    
Just my curiosity, but why would you like to read spam? –  Mołot Mar 5 at 13:14
2  
@Mołot, training a bayesian filter, maybe. –  Frédéric Hamidi Mar 5 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 at 14:18

You must log in to answer this question.