Name: 3rd T20 Twitter Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

3rd T20 Twitter Data

Context

India has won the T20 series. This is about the tweets during the third and Final match.

Content

It has Timestamps, Tweets, Retweet count but more than that it has real time data collected during the heat of the match so their can be many unknown patterns to be mined.

Acknowledgements

Have to thank my team for making the collection of data the analysis I did possible. Thank to my mentor who provided with ways of collecting insight from this data

Inspiration

Well I had already many analysis on this data but I believe it has much more potential so will be hoping to see exciting patterns mined. best of Luck any one who is using dataset.

Tables

T20–3

@kaggle.upamanyumukherjee_3rd_t20_twitter_data.t20_3

113 MB
30,565 rows
16,384 columns

CREATE TABLE t20_3 (
  "user_id" VARCHAR,
  "status_id" VARCHAR,
  "created_at" VARCHAR,
  "screen_name" VARCHAR,
  "text" VARCHAR,
  "source" VARCHAR,
  "display_text_width" DOUBLE,
  "reply_to_status_id" VARCHAR,
  "reply_to_user_id" VARCHAR,
  "reply_to_screen_name" VARCHAR,
  "is_quote" BOOLEAN,
  "is_retweet" BOOLEAN,
  "favorite_count" BIGINT,
  "retweet_count" BIGINT,
  "quote_count" BIGINT,
  "reply_count" BIGINT,
  "hashtags" VARCHAR,
  "symbols" VARCHAR,
  "urls_url" VARCHAR,
  "urls_t_co" VARCHAR,
  "urls_expanded_url" VARCHAR,
  "media_url" VARCHAR,
  "media_t_co" VARCHAR,
  "media_expanded_url" VARCHAR,
  "media_type" VARCHAR,
  "ext_media_url" VARCHAR,
  "ext_media_t_co" VARCHAR,
  "ext_media_expanded_url" VARCHAR,
  "ext_media_type" VARCHAR,
  "mentions_user_id" VARCHAR,
  "mentions_screen_name" VARCHAR,
  "lang" VARCHAR,
  "quoted_status_id" VARCHAR,
  "quoted_text" VARCHAR,
  "quoted_created_at" VARCHAR,
  "quoted_source" VARCHAR,
  "quoted_favorite_count" DOUBLE,
  "quoted_retweet_count" DOUBLE,
  "quoted_user_id" VARCHAR,
  "quoted_screen_name" VARCHAR,
  "quoted_name" VARCHAR,
  "quoted_followers_count" DOUBLE,
  "quoted_friends_count" DOUBLE,
  "quoted_statuses_count" DOUBLE,
  "quoted_location" VARCHAR,
  "quoted_description" VARCHAR,
  "quoted_verified" VARCHAR,
  "retweet_status_id" VARCHAR,
  "retweet_text" VARCHAR,
  "retweet_created_at" VARCHAR,
  "retweet_source" VARCHAR,
  "retweet_favorite_count" DOUBLE,
  "retweet_retweet_count" DOUBLE,
  "retweet_user_id" VARCHAR,
  "retweet_screen_name" VARCHAR,
  "retweet_name" VARCHAR,
  "retweet_followers_count" DOUBLE,
  "retweet_friends_count" DOUBLE,
  "retweet_statuses_count" DOUBLE,
  "retweet_location" VARCHAR,
  "retweet_description" VARCHAR,
  "retweet_verified" VARCHAR,
  "place_url" VARCHAR,
  "place_name" VARCHAR,
  "place_full_name" VARCHAR,
  "place_type" VARCHAR,
  "country" VARCHAR,
  "country_code" VARCHAR,
  "geo_coords" VARCHAR,
  "coords_coords" VARCHAR,
  "bbox_coords" VARCHAR,
  "status_url" VARCHAR,
  "name" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "url" VARCHAR,
  "protected" BOOLEAN,
  "followers_count" BIGINT,
  "friends_count" BIGINT,
  "listed_count" BIGINT,
  "statuses_count" BIGINT,
  "favourites_count" BIGINT,
  "account_created_at" VARCHAR,
  "verified" BOOLEAN,
  "profile_url" VARCHAR,
  "profile_expanded_url" VARCHAR,
  "account_lang" VARCHAR,
  "profile_banner_url" VARCHAR,
  "profile_background_url" VARCHAR,
  "profile_image_url" VARCHAR,
  "column1" VARCHAR,
  "column2" VARCHAR,
  "column3" VARCHAR,
  "column4" VARCHAR,
  "column5" VARCHAR,
  "column6" VARCHAR,
  "column7" VARCHAR,
  "column8" VARCHAR,
  "column9" VARCHAR,
  "column10" VARCHAR
);