Dataset: Top American Universities On Reddit

About this Dataset

Top American Universities On Reddit

Context

It is common knowledge that college life has a flavour of its own. From vibrant nightlife to student competitions to campus clubs, the day to day life of a student is a special one. This dataset aims to capture that, collecting data on subreddits of the 10 best American colleges, according to the 2019 Forbes list.

Content

The following dataset is a comprehensive list of all the posts and comments made on several of Reddit's college boards up to February 21 of 2022. The data includes the subreddits of the 10 colleges ranked best in the Forbes' 2019 listing.

The dataset was procured using SocialGrep.

To preserve users' anonymity and to prevent targeted harassment, the data does not include usernames.

Acknowledgements

We would like to thank Zhanhui Li for generously providing the cover image used for this dataset.

Inspiration

It's an open dataset - an answer without a question. Maybe you'd like to see which college's students stay up the latest? Have the most fun studying? Talk about data science the most?

Textual data is notoriously hard to quantify - but we wish you good luck nonetheless 💯

Tables

Top American Universities On Reddit Comments

@kaggle.pavellexyr_top_american_universities_on_reddit.top_american_universities_on_reddit_comments

56.75 MB
338231 rows
10 columns


CREATE TABLE top_american_universities_on_reddit_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
);

Top American Universities On Reddit Posts

@kaggle.pavellexyr_top_american_universities_on_reddit.top_american_universities_on_reddit_posts

15.51 MB
78113 rows
12 columns


CREATE TABLE top_american_universities_on_reddit_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
);