Name: Reddit Premier League - Big Four
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Reddit Premier League - Big Four

Context

r/RedDevils, r/Chelseafc, r/LiverpoolFC & r/Gunners are subreddits for the premier league big fours - Manchester United, Chelsea FC, Liverpool FC and Arsenal.

Content

Reddit posts from subreddits , downloaded using praw

title - post title
score - based on impact, number of comments
id - unique id for posts
subreddit - subreddit name
url - url of post thread
num_comments - number of comments to post
body - body text of the post
created - date of creation

Tables

Arsenal

@kaggle.yash161101_reddit_premier_league_big_four.arsenal

169.86 kB
865 rows
9 columns

CREATE TABLE arsenal (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "title" VARCHAR,
  "score" BIGINT,
  "id" VARCHAR,
  "subreddit" VARCHAR,
  "url" VARCHAR,
  "num_comments" BIGINT,
  "body" VARCHAR,
  "created" DOUBLE
);

Chelseafc

@kaggle.yash161101_reddit_premier_league_big_four.chelseafc

174.26 kB
859 rows
9 columns

CREATE TABLE chelseafc (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "title" VARCHAR,
  "score" BIGINT,
  "id" VARCHAR,
  "subreddit" VARCHAR,
  "url" VARCHAR,
  "num_comments" BIGINT,
  "body" VARCHAR,
  "created" DOUBLE
);

Liverpoolfc

@kaggle.yash161101_reddit_premier_league_big_four.liverpoolfc

173.31 kB
784 rows
9 columns

CREATE TABLE liverpoolfc (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "title" VARCHAR,
  "score" BIGINT,
  "id" VARCHAR,
  "subreddit" VARCHAR,
  "url" VARCHAR,
  "num_comments" BIGINT,
  "body" VARCHAR,
  "created" DOUBLE
);

Manu

@kaggle.yash161101_reddit_premier_league_big_four.manu

233.28 kB
816 rows
9 columns

CREATE TABLE manu (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "title" VARCHAR,
  "score" BIGINT,
  "id" VARCHAR,
  "subreddit" VARCHAR,
  "url" VARCHAR,
  "num_comments" BIGINT,
  "body" VARCHAR,
  "created" DOUBLE
);