Dataset: Tweets After Queen Elizabeth II's Death

About this Dataset

Tweets After Queen Elizabeth II's Death

Context

Tweets from around the world on Queen Elizabeth 2. Queen passed away on September 8, 2022. This dataset can be used to analyze the sentiments of people all around the globe.

Content

Columns: ['id', 'conversation_id', 'created_at', 'date', 'time', 'timezone', 'user_id', 'username', 'name', 'place', 'tweet', 'language', 'mentions', 'urls', 'photos', 'replies_count', 'retweets_count', 'likes_count', 'hashtags', 'cashtags', 'link', 'retweet', 'quote_url', 'video', 'thumbnail', 'near', 'geo', 'source', 'user_rt_id', 'user_rt', 'retweet_id', 'reply_to', 'retweet_date', 'translate', 'trans_src', 'trans_dest']

Acknowledgement

Twint has been a helpful library to scrape tweets without getting stuck in the limitations of the Twitter API.

Tables

Queen

@kaggle.aneeshtickoo_tweets_after_queen_elizabeth_iis_death.queen

39.51 MB
190325 rows
36 columns


CREATE TABLE queen (
  "id" BIGINT,
  "conversation_id" BIGINT,
  "created_at" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "timezone" BIGINT,
  "user_id" BIGINT,
  "username" VARCHAR,
  "name" VARCHAR,
  "place" VARCHAR,
  "tweet" VARCHAR,
  "language" VARCHAR,
  "mentions" VARCHAR,
  "urls" VARCHAR,
  "photos" VARCHAR,
  "replies_count" BIGINT,
  "retweets_count" BIGINT,
  "likes_count" BIGINT,
  "hashtags" VARCHAR,
  "cashtags" VARCHAR,
  "link" VARCHAR,
  "retweet" BOOLEAN,
  "quote_url" VARCHAR,
  "video" BIGINT,
  "thumbnail" VARCHAR,
  "near" VARCHAR,
  "geo" VARCHAR,
  "source" VARCHAR,
  "user_rt_id" VARCHAR,
  "user_rt" VARCHAR,
  "retweet_id" VARCHAR,
  "reply_to" VARCHAR,
  "retweet_date" VARCHAR,
  "translate" VARCHAR,
  "trans_src" VARCHAR,
  "trans_dest" VARCHAR
);