The Reddit /r/Place Dataset
The written history or /r/Place, in posts and comments.
@kaggle.pavellexyr_the_reddit_place_dataset
The written history or /r/Place, in posts and comments.
@kaggle.pavellexyr_the_reddit_place_dataset
For a moment, starting April 1st, 2022, Reddit became the talk of the entire internet as they reopened /r/Place - a collaborative pixel canvas stemming all the way from 2017.
Join us in following the recorded history of /r/Place and its related discussion, from the first pixels placed to its inevitable erasure.
This dataset contains all the posts and comments made on /r/Place from from the first of January, 2022, to the fourth of April, 2022.
The dataset was procured using SocialGrep.
To preserve users' anonymity and to prevent targeted harassment, the data does not include usernames.
We would like to thank the Reddit user /u/prosto_sanja for recording the timelapse data. We would also like to thank all Redditors who participated in the canvas. Here's to another good April Fools.
The place raises many questions, some of them surprisingly serious.
Which artpieces were most frequently accused of botting? Do the accusations match their behaviour - can we infer a "botted" picture somehow, even without looking at its users' Reddit histories?
The "amogus" is one of the smallest units of individual contribution, surprisingly resilient due to its cheeky, non-intrusive nature. How did their numbers change over time - does this match any shift in the players' moods as they feel more empowered or disenfranchised to create together?
Which areas ended up the most talked about?
CREATE TABLE the_reddit_place_dataset_comments (
"type" VARCHAR,
"id" VARCHAR,
"subreddit_id" VARCHAR,
"subreddit_name" VARCHAR,
"subreddit_nsfw" BOOLEAN,
"created_utc" BIGINT,
"permalink" VARCHAR,
"body" VARCHAR,
"sentiment" DOUBLE,
"score" BIGINT
);CREATE TABLE the_reddit_place_dataset_posts (
"type" VARCHAR,
"id" VARCHAR,
"subreddit_id" VARCHAR,
"subreddit_name" VARCHAR,
"subreddit_nsfw" BOOLEAN,
"created_utc" BIGINT,
"permalink" VARCHAR,
"domain" VARCHAR,
"url" VARCHAR,
"selftext" VARCHAR,
"title" VARCHAR,
"score" BIGINT
);Anyone who has the link will be able to view this.