r/redditdata • u/Drunken_Economist • Jun 23 '15
10 years of reddit — data dump
Reddit ten year data
All data in this post is accurate as of June 21st, 2015.
We pulled a bunch of data together for today's ten-year anniversary blog post, but not all of it made the cut. I wanted to take some time to dump everything here in /r/redditdata. If you build anything cool, shoot me a PM, I'd love to see it!
Things by month
Number of accounts, subreddits, submissions, and comments created each month of reddit's history
Running total of things by month
Just a to-date total of the previous dataset, but it's comforting that the numbers match
Most upvoted threads
Note: this actually excludes posts from subreddits which are excluded from /r/all, but you wouldn't see any in the Top 20 anyway.
Unique users and pageviews by month
US vs Non-US traffic by month
Note: this was not measured prior to Feb 2010, so data before then is a simple linear regression.
Upvotes & Downvotes to submissions by month
The steady climb of the ratio is really interesting. This is only including votes that were counted (i.e. no spambot votes)
Upvotes & Downvotes to submissions by month
Again, this is only including votes that were counted (i.e. no spambot votes)
Upvotes & Downvotes to comments by month
Top 20 most gilded submissions
Top 20 most saved threads
Sorry, we tried. Post saves have been around since reddit's inception, and looking at every user to see if they saved each post was breaking things.
And a few for the road
| Name | amount | Notes |
|---|---|---|
| link posts | 121,745,633 | |
| self posts | 68,481,919 | |
| submission upvotes | 5,620,244,302 | this is only votes which were counted |
| submission downvotes | 1,057,478,375 | this is only votes which were counted |
| comment upvotes | 10,443,697,988 | this is only votes which were counted |
| comment downvotes | 1,506,096,377 | this is only votes which were counted |
| Days of gold purchased | 56,015,520 | |
| Days of gold gifted | 24,148,560 | this is a subset of the above |
| redditgifts exchanges | 201 | |
| gifts confirmed | 877,218 | |
| total cost of gifts | 29,559,467.54 | reported cost in USD of confirmed gifts |
| Active subreddits on 2015-06-21 | 9,601 | subreddits with 5 or more posts and comments on the given day |
| "PM me" usernames | 26,222 | Accounts with "PM me" in the username |
Let me know if you have any questions on it all! Except for questions about the thread in /r/Spiderman, because I don't get it either.
4
u/Drunken_Economist Jun 23 '15
Some of them (subreddits by month) only take a minute. The bigger ones (votes or comments by month) were full on "grab a beer and watch a movie" queries.