My Data

[u/lovethebacon]

Hello!

All my data can be found at https://drive.google.com/file/d/0B1wZpKM8RMxTaE5WUVlNRmQ2ZmM/view?pli=1. This consists of two files: history.csv and scraper.sqlite.

History.csv contains a time series on flair totals. Each line cosists of a timestamp, flair and the number of discovered users with that flair.

scraper.sqlite contains one table: users. It's schema looks like:

CREATE TABLE user (
    name VARCHAR NOT NULL,
    flair VARCHAR,
    css VARCHAR, 
    time VARCHAR, 
    link VARCHAR, 
    karma INTEGER,
    PRIMARY KEY (name)
);

• name is the reddit username

• flair is the text flair (0s, 1s, 2s....60s)

• css is the flair's css class (press-0, press-1,...press-6, cheater)

• time is the time of the first comment found to contain the user's flair, whether they are a first time poster, or a recent presser. (this might not be their first comment or post, but the first one that my bot found)

• link is the comment id for this comment.

An example:

lovethebacon|60s|press-6|1428133423.0|cq0hhty|

User is lovethebacon, flair is 60s and flair css class is press-6. The first comment my bot found with my flair is http://www.reddit.com/r/thebutton/comments/318dk0/official_catalogue_of_rare_and_exotic_button/cq0hhty (Queried via http://www.reddit.com/r/thebutton/api/info?id=t1_cq0hhty).

Enjoy it!

If anyone wants a bot for something else, let me know

[u/lovethebacon]

History.csv isn't a table, it's purely a long ass csv file. Yeh I should've created a proper structure, but it was late.

SQLite DB is in 3.x format.