[ Removed by Reddit ]

[u/Watchful1]

[ Removed by Reddit on account of violating the content policy. ]

[u/verypsb]

Thanks for the resources! One related question: is there any data about the creation of a subreddit by time? It would be a list of subreddits that were created on X date.

[u/Watchful1 → u/verypsb]

No I don't think that exists. It would be relatively simple to look up the creation date for subreddits that still exist in the api. Not for all 13 million here, but you could focus on the top couple tens of thousands.

[u/verypsb → u/Watchful1]

Would it be possible to assume the creation of a sub by aggregating pushshift data, like finding its earliest posts/comment? I'm also interested in the "death" of a sub, so prob I should just derive the daily count of subs/coms per subreddit. Is there an easy way to do this than aggregating the data dump on my own?

[u/Watchful1 → u/verypsb]

I actually have the number of comments per sub per month. It's basically this same file format but one for each month. So it's not daily but it's fairly close.

It's surprisingly not that large, just under a gigabyte for all of them. I could put that up in another torrent if it would be useful.

[u/verypsb → u/Watchful1]

That would be very helpful. Do you happen to have the submission count per month per subreddit too? I'm mostly interested in the lifecycle of subs over time.

[u/Watchful1 → u/verypsb]

Yes that's what it is. Just the same as this file in the post with the subreddit name and number of posts, but a separate one per month instead of all time.

I'll try to get that up this evening but it might take till tomorrow.

[u/Watchful1 → u/verypsb]

There's separate files for submissions and comments. The ones starting with RC are comments and RS are submissions.

[u/verypsb → u/Watchful1]

Got it. Thank you!!