Name: Reddit Data Huge
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Reddit Data Huge

What is Reddit?

Reddit is a collection of forums where people can share news and content as a thread or comment on other people’s posts. Reddit is broken up into more than a million communities known as “subreddits,” each of which covers a different topic. The name of a subreddit begins with /r/, which is part of the URLs that Reddit uses. For example, /r/nba is a subreddit where people talk about the National Basketball Association, while /r/boardgames is a subreddit for people to discuss board games.

Content

In this dataset, I have added data from many different subreddits. This will act as an NLP gold mine for Social Media Analysis. This can help people understand what the youth is talking about.

Acknowledgements

I have collected it on my own using this article.

Tables

Adviceforteens Data

@kaggle.prakharrathi25_reddit_data_huge.adviceforteens_data

966.1 kB
818 rows
12 columns

CREATE TABLE adviceforteens_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Anxiety Reddit Data

@kaggle.prakharrathi25_reddit_data_huge.anxiety_reddit_data

550.26 kB
1,000 rows
12 columns

CREATE TABLE anxiety_reddit_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Applyingtocollege Data

@kaggle.prakharrathi25_reddit_data_huge.applyingtocollege_data

807.56 kB
995 rows
12 columns

CREATE TABLE applyingtocollege_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Astrology Data

@kaggle.prakharrathi25_reddit_data_huge.astrology_data

552.36 kB
983 rows
12 columns

CREATE TABLE astrology_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Business Data

@kaggle.prakharrathi25_reddit_data_huge.business_data

282.29 kB
989 rows
12 columns

CREATE TABLE business_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Careerguidance Data

@kaggle.prakharrathi25_reddit_data_huge.careerguidance_data

1.08 MB
1,000 rows
12 columns

CREATE TABLE careerguidance_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

College

@kaggle.prakharrathi25_reddit_data_huge.college

652.78 kB
884 rows
11 columns

CREATE TABLE college (
  "id" VARCHAR,
  "title" VARCHAR,
  "body" VARCHAR,
  "subreddit" VARCHAR,
  "upvotes" BIGINT,
  "url" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

College Data

@kaggle.prakharrathi25_reddit_data_huge.college_data

670.24 kB
885 rows
12 columns

CREATE TABLE college_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Colombia Reddit Data

@kaggle.prakharrathi25_reddit_data_huge.colombia_reddit_data

225 kB
1,000 rows
12 columns

CREATE TABLE colombia_reddit_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Computer Science Data

@kaggle.prakharrathi25_reddit_data_huge.computer_science_data

517.23 kB
984 rows
12 columns

CREATE TABLE computer_science_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Covid19 Data

@kaggle.prakharrathi25_reddit_data_huge.covid19_data

323.85 kB
992 rows
12 columns

CREATE TABLE covid19_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Dating Data

@kaggle.prakharrathi25_reddit_data_huge.dating_data

1.1 MB
993 rows
12 columns

CREATE TABLE dating_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Depression Reddit Data

@kaggle.prakharrathi25_reddit_data_huge.depression_reddit_data

847.01 kB
1,000 rows
12 columns

CREATE TABLE depression_reddit_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Employment Reddit Data

@kaggle.prakharrathi25_reddit_data_huge.employment_reddit_data

2.26 MB
2,495 rows
12 columns

CREATE TABLE employment_reddit_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Engineering Data

@kaggle.prakharrathi25_reddit_data_huge.engineering_data

308.2 kB
994 rows
12 columns

CREATE TABLE engineering_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Entrepreneur Data

@kaggle.prakharrathi25_reddit_data_huge.entrepreneur_data

2.92 MB
999 rows
12 columns

CREATE TABLE entrepreneur_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Feminism Data

@kaggle.prakharrathi25_reddit_data_huge.feminism_data

241.25 kB
1,000 rows
12 columns

CREATE TABLE feminism_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Gradschool Data

@kaggle.prakharrathi25_reddit_data_huge.gradschool_data

630.79 kB
769 rows
12 columns

CREATE TABLE gradschool_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

High School

@kaggle.prakharrathi25_reddit_data_huge.high_school

450.77 kB
998 rows
11 columns

CREATE TABLE high_school (
  "id" VARCHAR,
  "title" VARCHAR,
  "body" VARCHAR,
  "subreddit" VARCHAR,
  "upvotes" BIGINT,
  "url" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Kidsrights Data

@kaggle.prakharrathi25_reddit_data_huge.kidsrights_data

118.92 kB
471 rows
12 columns

CREATE TABLE kidsrights_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Merged Reddit Data

@kaggle.prakharrathi25_reddit_data_huge.merged_reddit_data

3.33 MB
8,401 rows
8 columns

CREATE TABLE merged_reddit_data (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "id" VARCHAR,
  "flair" VARCHAR,
  "subreddit" VARCHAR,
  "text" VARCHAR,
  "sentiment" VARCHAR,
  "creation_date" TIMESTAMP,
  "upvotes" BIGINT
);

Mexico Spanishlanguage Reddit Data

@kaggle.prakharrathi25_reddit_data_huge.mexico_spanishlanguage_reddit_data

202.28 kB
998 rows
12 columns

CREATE TABLE mexico_spanishlanguage_reddit_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Neutralpolitics Data

@kaggle.prakharrathi25_reddit_data_huge.neutralpolitics_data

1.26 MB
1,000 rows
12 columns

CREATE TABLE neutralpolitics_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Povertyfinance Data

@kaggle.prakharrathi25_reddit_data_huge.povertyfinance_data

669.2 kB
990 rows
12 columns

CREATE TABLE povertyfinance_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);

Science Data

@kaggle.prakharrathi25_reddit_data_huge.science_data

382.1 kB
991 rows
12 columns

CREATE TABLE science_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" VARCHAR,
  "is_original" BOOLEAN,
  "flair" VARCHAR,
  "num_comments" BIGINT,
  "title" VARCHAR,
  "subreddit" VARCHAR,
  "body" VARCHAR,
  "url" VARCHAR,
  "upvotes" BIGINT,
  "comments" VARCHAR,
  "creation_date" TIMESTAMP
);