Tweets On T20 World Cup 2022

40,000+ tweets on the world cup T20 just after the India v/ Pakistan match

@kaggle.aneeshtickoo_tweets_on_t20_world_cup_2022

Table List

1 table(9.05 MB)

T20

@kaggle.aneeshtickoo_tweets_on_t20_world_cup_2022.t20

9.05 MB
52675 rows
36 columns

id Id	conversation_id Conversation Id	created_at Created At	date Date	time Time	timezone Timezone	user_id User Id	username Username	name Name	place Place	tweet Tweet	language Language	mentions Mentions	urls Urls	photos Photos	hashtags Hashtags	cashtags Cashtags	link Link	quote_url Quote Url	video Video	thumbnail Thumbnail	reply_to Reply To
1584182773178241024	1584005070357925888	2022-10-23 19:29:40 IST	Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:29:40	530	608507914	rjm_53	Rod	nan	@SalmondG @ScottyCricket @Greav_o @CricketScotland @T20WorldCup @cpbats It’s not a squad - it’s a team - they never utilise the strengths of their squad	en	[]	[]	[]	[]	[]	https://twitter.com/rjm_53/status/1584182773178241024	nan		nan	[{'screen_name': 'SalmondG', 'name': 'George Salmond', 'id': '1048994828'}, {'screen_name': 'ScottyCricket', 'name': 'Scottish Cricket Past Present and Future', 'id': '935827088875184128'}, {'screen_name': 'Greav_o', 'name': 'Chris Greaves', 'id': '278710062'}, {'screen_name': 'CricketScotland', 'na…
1584182769898655745	1584182769898655745	2022-10-23 19:29:39 IST	Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:29:39	530	823102174540480512	iamubaidrehman	Ubaid Ur Rehman	nan	India won by cheating as usual. Well paid india What a shame! #Melbourne #PakVsInd #PakistanVsIndia #ICCT20WorldCup2022 #iccrankings #icc #ViratKohli #T20WorldCup	en	[]	[]	[]	['melbourne', 'pakvsind', 'pakistanvsindia', 'icct20worldcup2022', 'iccrankings', 'icc', 'viratkohli', 't20worldcup']	[]	https://twitter.com/Iamubaidrehman/status/1584182769898655745	nan		nan	[]
1584182768635740160	1584182768635740160	2022-10-23 19:29:39 IST	Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:29:39	530	875641	sanjaykalra	Sanjay Kalra, DX Sherpa 📈 🚀	nan	Early #Diwali for #India as ⁦@imVkohli⁩ leads India to a thrilling history over Pakistan in this key #T20WorldCup match. https://t.co/kmlGF8zJyX	en	[{'screen_name': 'imvkohli', 'name': 'virat kohli', 'id': '71201743'}]	['https://www.t20worldcup.com/video/2869705']	[]	['diwali', 'india', 't20worldcup']	[]	https://twitter.com/sanjaykalra/status/1584182768635740160	nan		nan	[]
1584182765775646720	1584182662561792001	2022-10-23 19:29:38 IST	Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:29:38	530	1558460974830874624	sindhiyachoudh2	sindhiya Choudhary	nan	@JM_Scindia चक दे इंडिया 🇮🇳 भारतीय क्रिकेट टीम ने #T20WorldCup के #INDvPAK रोमांचक मैच में पाकिस्तान को 4 विकेट से हराकर शानदार विजय हासिल की है। इस ऐतिहासिक जीत के लिए #TeamIndia को हार्दिक बधाई।	hi	[]	[]	[]	['t20worldcup', 'indvpak', 'teamindia']	[]	https://twitter.com/sindhiyaChoudh2/status/1584182765775646720	nan		nan	[{'screen_name': 'JM_Scindia', 'name': 'Jyotiraditya M. Scindia', 'id': '2892809359'}]
1584182763351343108	1584182763351343108	2022-10-23 19:29:38 IST	Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:29:38	530	738683931520798720	asianetnewstm	Asianetnews Tamil	nan	தோற்க வேண்டிய மேட்ச்சை ஜெயித்து கொடுத்த கோலி.. இதுதான் நண்பா உன்னோட பெஸ்ட் இன்னிங்ஸ்! கோலியை தூக்கி கொண்டாடிய ரோஹித் #T20WorldCup #INDvsPAK #IndiaWin #TeamIndia #ViratKohli #RohitSharma #AsianetNewsTamil https://t.co/MS5h5oJLiB	ta	[]	['https://tamil.asianetnews.com/sports-cricket/india-captain-rohit-sharma-praises-virat-kohli-for-his-amazing-innings-against-pakistan-in-t20-world-cup-rk7leb']	[]	['t20worldcup', 'indvspak', 'indiawin', 'teamindia', 'viratkohli', 'rohitsharma', 'asianetnewstamil']	[]	https://twitter.com/AsianetNewsTM/status/1584182763351343108	nan		nan	[]
1584182762965458946	1584182762965458946	2022-10-23 19:29:38 IST	Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:29:38	530	2178465835	mayuri_19s	⫷ Mⱥℽบri༒꧂ bleedblue 🇮🇳	nan	can't get over these images for a long time 🥺😩 #ViratKohli𓃵 #T20WorldCup #INDvPAK https://t.co/GnUcTmMcqd	en	[]	[]	['https://pbs.twimg.com/media/Ffwl0r2WQAAJ5-1.jpg', 'https://pbs.twimg.com/media/Ffwl0r5XwAA_cVz.jpg', 'https://pbs.twimg.com/media/Ffwl0r4WYAQioeR.jpg', 'https://pbs.twimg.com/media/Ffwl0r9XEAInvUl.jpg']	['viratkohli𓃵', 't20worldcup', 'indvpak']	[]	https://twitter.com/mayuri_19s/status/1584182762965458946	nan	1	https://pbs.twimg.com/media/Ffwl0r2WQAAJ5-1.jpg	[]
1584182761895604224	1584174430607265793	2022-10-23 19:29:37 IST	Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:29:37	530	554961989	sudharshanaim	sudharshan	nan	@ArfaSays_ The normalisation of cricketing relations between India and Pakistan demands minus Terrorism. You being a journalist, ask your Govt(of course Military) to stop funding Terrorism mate! Then India normalises cricket relations! #T20WorldCup	en	[]	[]	[]	['t20worldcup']	[]	https://twitter.com/SudharshanAim/status/1584182761895604224	nan		nan	[{'screen_name': 'ArfaSays_', 'name': 'Arfa Feroz Zake', 'id': '153801695'}]
1584182751938301952	1584182751938301952	2022-10-23 19:29:35 IST	Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:29:35	530	1239834232505004033	anchorradhika	Radhika Choudhary	nan	दीपावली पर टीम इंडिया का सभी भारतीयों को तोहफा! इंडिया को हार्दिक शुभकामनाएं। #T20WorldCup #इंद्वीस्पाक https://t.co/H7f7WuNt2o	hi	[]	[]	['https://pbs.twimg.com/media/Ffwlx2BVEAAG8_q.jpg']	['t20worldcup', 'इंद्वीस्पाक']	[]	https://twitter.com/anchorradhika/status/1584182751938301952	nan	1	https://pbs.twimg.com/media/Ffwlx2BVEAAG8_q.jpg	[]
1584182745559105541	1584148642767994880	2022-10-23 19:29:33 IST	Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:29:33	530	1456081639	hastimals	Hastimal Solanki	nan	@letscinema IND vs Pakistan T20 world cup 23-10-22	en	[]	[]	[]	[]	[]	https://twitter.com/HastimalS/status/1584182745559105541	nan		nan	[{'screen_name': 'letscinema', 'name': 'LetsCinema', 'id': '1090513571581091840'}]
1584182743776174082	1584173763758678016	2022-10-23 19:29:33 IST	Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:29:33	530	1581771944046735360	hiiiipowerrr	.	nan	@prateekr9_ @PrashantMUFC Which t20 World Cup please remind me?	en	[]	[]	[]	[]	[]	https://twitter.com/HiiiiPowerrr/status/1584182743776174082	nan		nan	[{'screen_name': 'prateekr9_', 'name': 'prateek', 'id': '2175690954'}, {'screen_name': 'PrashantMUFC', 'name': 'Prashant', 'id': '1415932069'}]


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
);