ShackStats

Visit the ShackStats website.

Data files

These files are generated daily and available at https://shackstats.com/data/. A full file listing is available in files.csv.

files.csv

1. filename (PK)

file_hashes.csv

1. filename (PK)
2. sha256
3. size

users.csv

1. user_id (PK)
2. username (unique)

users_info.csv

1. user_id (PK)
2. username (unique)
3. first_post_id
4. first_post_date
5. post_count

daily_post_counts.csv

1. date (PK)
2. total_post_count
3. ontopic_post_count
4. nws_post_count
5. stupid_post_count
6. political_post_count
7. tangent_post_count
8. informative_post_count

daily_post_counts_for_user_(user id).csv

1. date (PK)
2. user_id (PK)
3. total_post_count
4. ontopic_post_count
5. nws_post_count
6. stupid_post_count
7. political_post_count
8. tangent_post_count
9. informative_post_count

post_counts_by_user_for_(day|week|month|year)_(YYYYMMDD).csv

1. interval (PK)
2. interval_start_date (PK)
3. user_id (PK)
4. total_post_count
5. ontopic_post_count
6. nws_post_count
7. stupid_post_count
8. political_post_count
9. tangent_post_count
10. informative_post_count

(daily|weekly|monthly|yearly)_poster_counts.csv

1. period (PK)
2. date (PK)
3. poster_count

(daily|weekly|monthly|yearly)_new_poster_counts.csv

1. period (PK)
2. date (PK)
3. new_poster_count

(daily|weekly|monthly|yearly)_new_10plus_poster_counts.csv

1. period (PK)
2. date (PK)
3. new_10plus_poster_count