Cricket Tweets

Twitter posts on the great game of cricket

@kaggle.gpreda_cricket_tweets

Table List

1 table(9.3 MB)

Cricket Tweets

@kaggle.gpreda_cricket_tweets.cricket_tweets

9.3 MB
60862 rows
16 columns

id Id	user_name User Name	user_location User Location	user_description User Description	user_created User Created	user_followers User Followers	user_friends User Friends	user_favourites User Favourites	user_verified User Verified	date Date	text Text	hashtags Hashtags	source Source	retweets Retweets	favorites Favorites
1433440359477096453	Cricket World	Global	Official Twitter account of Cricket World - news, photos and more from grass roots to international level.	Fri Jan 23 2009 10:49:02 GMT+0000 (Coordinated Universal Time)	58699	9834	90829	true	Thu Sep 02 2021 14:43:08 GMT+0000 (Coordinated Universal Time)	🏏 Rizwan Cheema has been named team captain of the Premium Paks Cricket Club in the American Premiere League (APL).… https://t.co/PIDguciKFH	nan	Twitter Web App
1433438874995343361	Ⓜ️ithun	मुंबई, भारत	Cricket 🏏 Photography📷 Wildlife🐅 Nature🌳	Sat Jan 09 2010 15:38:06 GMT+0000 (Coordinated Universal Time)	7	97	343		Thu Sep 02 2021 14:37:14 GMT+0000 (Coordinated Universal Time)	Virat Kohli being fixated on retaining specific players with average performances so far in the series is something… https://t.co/gH8qDsXS5I	nan	Twitter for Android
1433436646645501956	Akram Khan	nan	BLOGGER \| ＣＲＩＣＫＥＴＬＯＶＥＲ \| Fond of full forms	Tue Jul 08 2014 00:39:28 GMT+0000 (Coordinated Universal Time)	1455	39	8486		Thu Sep 02 2021 14:28:23 GMT+0000 (Coordinated Universal Time)	My tribute to the world's fastest bowler ever, @shoaib100mph with a unique full form. #shoaibakhtarpeaceambassador… https://t.co/O3Ni946zpg	['shoaibakhtarpeaceambassador']	Twitter Web App	1	3
1433433904438931474	Mr.P	Mumbai, India	nothing	Sun Aug 25 2013 10:07:10 GMT+0000 (Coordinated Universal Time)	15	675	4590		Thu Sep 02 2021 14:17:29 GMT+0000 (Coordinated Universal Time)	this guy's life is incomplete without Kohli's failure. Maybe Kohli fu*ked his mom in 2017 srilanka tour. carry on d… https://t.co/d4LRNHfPs0	nan	Twitter for Android		5
1433433383024005131	Cricket_Kith	nan	Crick, Crick, Cricket🏏 Don't Throw Your Wicket. Savage Tweet From Sports💯	Wed Sep 01 2021 11:39:18 GMT+0000 (Coordinated Universal Time)		6	27		Thu Sep 02 2021 14:15:25 GMT+0000 (Coordinated Universal Time)	When Rishabh Pant Stepped Out Robinson 😂 Whole Nation To Pant #ENGvIND #Cricket #BCCI #Ovaltest #Nottingham… https://t.co/73wg1HlDbm	['ENGvIND', 'Cricket', 'BCCI', 'Ovaltest', 'Nottingham']	Twitter for Android		1
1433431241873772554	The Dibbly Dobblers Cricket Podcast	Perth, Scotland	We are a cricket podcast. Long live the lost art of the dibbly dobblers.	Tue Aug 24 2021 19:15:49 GMT+0000 (Coordinated Universal Time)	2	170			Thu Sep 02 2021 14:06:54 GMT+0000 (Coordinated Universal Time)	A new #cricket podcast, you say? Well, why not?! Episode 1 👉🏻 https://t.co/kUr0J1oAXP We'll be on all the usual… https://t.co/Sg8X3EVJE6	['cricket']	Twitter for Android		1
1433427448922734603	Hridyansh Khandal	nan	nan	Fri Jul 02 2021 08:16:41 GMT+0000 (Coordinated Universal Time)	1	153	26		Thu Sep 02 2021 13:51:50 GMT+0000 (Coordinated Universal Time)	Classic 50* by @imVkohli well played boy. #Cricket #ViratKohli #IndvsEng #INDvsEND	['Cricket', 'ViratKohli', 'IndvsEng', 'INDvsEND']	Twitter for Android
1433423147647127560	Rahul Kumar Srivastava	nan	nan	Fri Aug 27 2021 17:32:32 GMT+0000 (Coordinated Universal Time)	1	13	18		Thu Sep 02 2021 13:34:44 GMT+0000 (Coordinated Universal Time)	Kohli looks in a sublime touch.. #IndvsEng #Ashwin #Cricket #IndiaBouncesBack	['IndvsEng', 'Ashwin', 'Cricket', 'IndiaBouncesBack']	Twitter for Android
1433422713574600704	Abdul Manaf Sukhera	Pakistan	Be honest rather than impressive 🥰🥰🥰🥰🥰 cricket expert 🥰🥰 💚💚💚	Wed Aug 18 2021 04:47:37 GMT+0000 (Coordinated Universal Time)	636	1032	506		Thu Sep 02 2021 13:33:01 GMT+0000 (Coordinated Universal Time)	𝐅𝐚𝐬𝐭𝐞𝐬𝐭 𝐭𝐨 𝐬𝐜𝐨𝐫𝐞 𝟐𝟑,𝟎𝟎𝟎 𝐢𝐧𝐭𝐞𝐫𝐧𝐚𝐭𝐢𝐨𝐧𝐚𝐥 𝐫𝐮𝐧𝐬 🙌 Virat Kohli for you 🤩 #ENGvIND #Cricket #ViratKohli https://t.co/zrvjJqrmJ9	['ENGvIND', 'Cricket', 'ViratKohli']	Twitter for Android
1433412918918348809	LIGER	India	professional bettor 13 years experience in betting 🌎 Telegram group: https://t.co/CVRc7Mxe0W whatsapp https://t.co/nQjWTM2a3h	Sat Dec 01 2018 13:36:50 GMT+0000 (Coordinated Universal Time)	270	195	4196		Thu Sep 02 2021 12:54:06 GMT+0000 (Coordinated Universal Time)	#live #odi #cricket Srilanka score under 290.5 runs at 1.83 ODDS 2 stakes bet Srilanka vs South Africa	['live', 'odi', 'cricket']	Twitter for Android


CREATE TABLE cricket_tweets (
  "id" BIGINT,
  "user_name" VARCHAR,
  "user_location" VARCHAR,
  "user_description" VARCHAR,
  "user_created" TIMESTAMP,
  "user_followers" BIGINT,
  "user_friends" BIGINT,
  "user_favourites" BIGINT,
  "user_verified" BOOLEAN,
  "date" TIMESTAMP,
  "text" VARCHAR,
  "hashtags" VARCHAR,
  "source" VARCHAR,
  "retweets" BIGINT,
  "favorites" BIGINT,
  "is_retweet" BOOLEAN
);