Name: Tweets On T20 World Cup 2022
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Tweets On T20 World Cup 2022

Context

Tweets from around the world on the T20 world cup just after the India v/s Pakistan match on 23 October 2022.

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

T20

@kaggle.aneeshtickoo_tweets_on_t20_world_cup_2022.t20

9.49 MB
52,675 rows
36 columns

CREATE TABLE t20 (
  "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
);