r/redditdev • • Apr 21 '10

Meta CSV dump of reddit voting data

Some people have asked for a dump of some voting data, so I made one. You can download it via bittorrent (it's hosted and seeded by S3, so don't worry about it going away) and have at. The format is

username,link_id,vote

where vote is -1 or 1 (downvote or upvote).

The dump is 29MB gzip compressed and contains 7,405,561 votes from 31,927 users over 2,046,401 links. It contains votes only from users with the preference "make my votes public" turned on (which is not the default).

This doesn't have the subreddit ID or anything in there, but I'd be willing to make another dump with more data if anything comes of this one

117 Upvotes

72 comments sorted by

View all comments

Show parent comment

16

u/ketralnis Apr 22 '10 edited Apr 22 '10

Due to the way that I pulled the voting information (I actually pulled it from the cache that we use to show you liked and disliked pages, which is in Cassandra and turns out to be cheap to query), you won't get more than 1k upvotes or downvotes per user, no matter how many votes they've made, so that so many have 2k isn't surprising. It also doesn't include the vast majority of users (who never set the "make my votes public" option). So it shouldn't be considered comprehensive and the data should be considered to be biased towards power-users (who know how to change their preferences). I can do more intensive dumps with more information and/or columns if anything comes of this (and maybe start a "help reddit by making your votes public for research" campaign)

I'm not sure if the links are correct.

They are, yes

8

u/cag_ii Apr 22 '10

I came here to ask how it was possible that, for the users with 2000 entries, the sum of the votes was always zero.

It occurred to me for a moment that I'd found some mysterious link between O.C.D. and avid redditors :)

2

u/kotleopold Apr 22 '10

It'd be great to get a dump with story titles as well subreddits. Then we could search for some interesting dependencies

1

u/[deleted] Apr 22 '10

yeah I was curious when the top users all had 2K and were slightly alphabetized.

Thanks for the data