Tweets After Queen Elizabeth II's Death
Close to 2,00,000 tweets on Queen Elizabeth II
@kaggle.aneeshtickoo_tweets_after_queen_elizabeth_iis_death
Close to 2,00,000 tweets on Queen Elizabeth II
@kaggle.aneeshtickoo_tweets_after_queen_elizabeth_iis_death
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.
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']
Twint has been a helpful library to scrape tweets without getting stuck in the limitations of the Twitter API.
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
);
Anyone who has the link will be able to view this.