Dataset: Public Opinion On Climate Change (Updated Daily)

About this Dataset

Public Opinion On Climate Change (Updated Daily)

Climate change is a critical issue that affects the global community.

This dataset provides valuable insights into public opinions and discussions surrounding climate change.

It is specifically derived from Reddit, a popular online platform known for its diverse communities and extensive discussions.

This dataset is updated daily to proivde the latest comments on the latest reddit posts

If you find this dataset valuable, don't forget to hit the upvote button! 😊💝

Interesting Task Ideas:

Analyze overall sentiment towards climate change topics on Reddit over time.
Identify the most active subreddits and users discussing climate change.
Investigate controversial climate change discussions and analyze the key arguments from different perspectives.
Examine the impact of various factors (e.g., post score, upvote ratio) on the engagement and visibility of climate change-related posts.
Explore the behavior and trends of Reddit users involved in these discussions, such as their account age, karma distribution, and activity levels.
Utilize natural language processing techniques to identify key topics and themes within climate change discussions.
Predict the popularity of climate change-related posts based on metadata features.

Photo by Li-An Lim on Unsplash

Tables

Reddit Opinion Climate Change

@kaggle.asaniczka_public_opinion_on_climate_change_updated_daily.reddit_opinion_climate_change

227.76 MB
979234 rows
24 columns


CREATE TABLE reddit_opinion_climate_change (
  "comment_id" VARCHAR,
  "score" BIGINT,
  "self_text" VARCHAR,
  "subreddit" VARCHAR,
  "created_time" TIMESTAMP,
  "post_id" VARCHAR,
  "author_name" VARCHAR,
  "controversiality" BIGINT,
  "ups" BIGINT,
  "downs" BIGINT,
  "user_is_verified" BOOLEAN,
  "user_account_created_time" TIMESTAMP,
  "user_awardee_karma" DOUBLE,
  "user_awarder_karma" DOUBLE,
  "user_link_karma" DOUBLE,
  "user_comment_karma" DOUBLE,
  "user_total_karma" DOUBLE,
  "post_score" BIGINT,
  "post_self_text" VARCHAR,
  "post_title" VARCHAR,
  "post_upvote_ratio" DOUBLE,
  "post_thumbs_ups" BIGINT,
  "post_total_awards_received" BIGINT,
  "post_created_time" TIMESTAMP
);