DataFest Tbilisi 2020 Challenge

Data challenge - Data analysis at DataFest Tbilisi 2020

@kaggle.thedfrlab_datafest_tbilisi_2020

Table List

4 tables(5.35 MB)

Ghana Nigeria Takedown Tweets

Ghana Nigeria Takedown Users

Ghana Trending Topics 200401–200519

Nigeria Trending Topics 200401–200519

Ghana Nigeria Takedown Tweets

@kaggle.thedfrlab_datafest_tbilisi_2020.ghana_nigeria_takedown_tweets

5.19 MB
37800 rows
22 columns

tweetid Tweetid	userid Userid	tweet_language Tweet Language	tweet_text Tweet Text	tweet_time Tweet Time	tweet_client_name Tweet Client Name	in_reply_to_userid In Reply To Userid	quoted_tweet_tweetid Quoted Tweet Tweetid	retweet_userid Retweet Userid	latitude Latitude	longitude Longitude	quote_count Quote Count	reply_count Reply Count	like_count Like Count	retweet_count Retweet Count	hashtags Hashtags	urls Urls	user_mentions User Mentions
1224994660919259136	Cdilt65wnJiBlxkJd9dUDOuROKqyMjK9p3kk+cYugXo=	en	HBO Max plans to back a documentary film on the women accusing hip-hop mogul Russell Simmons of sexual misconduct and assault: https://t.co/JqbHMiEH1N https://t.co/johsEdOnjP	Wed Feb 05 2020 09:54:00 GMT+0000 (Coordinated Universal Time)	Twitter for Android	nan		nan	absent	absent			2		[]	['https://trib.al/eE6R702']	[]
1160853188129566720	Cdilt65wnJiBlxkJd9dUDOuROKqyMjK9p3kk+cYugXo=	en	This kid is amazing 🤯🔥🔥🔥 https://t.co/xmB9SnZRpB	Mon Aug 12 2019 09:59:00 GMT+0000 (Coordinated Universal Time)	Twitter for Android	nan		nan	absent	absent	1		53	33	[]	[]	[]
1230057290713182208	WZ1W77WloUuz4jbjw8j5omNlBCFy7+WC2ruepmhAP3o=	en	Remembering one of the greatest groups to walk this earth #Abba with hits like (take a chance, money money money, dancing queen, chiquitita, Fernando,mamma mia, S.O.S and many more) #AbbaTribute #70smusic #GreatestHits	Wed Feb 19 2020 09:11:00 GMT+0000 (Coordinated Universal Time)	Twitter for Android	nan	931168666812600400	nan	absent	absent					['Abba', 'AbbaTribute', '70smusic', 'GreatestHits']	[]	[]
1219009387601256450	WZ1W77WloUuz4jbjw8j5omNlBCFy7+WC2ruepmhAP3o=	en	Protect your knowledge, don't let it get corrupted. #history #travel #ww #art #photography #architecture #culture #s #museum #love #nature #heritage #historia #photooftheday #italy #ig #instagood #europe #war #vintage #instagram #historical #india #photo #bhfyp #explore #bhfyp https://t.co/pxu2pK…	Sun Jan 19 2020 21:31:00 GMT+0000 (Coordinated Universal Time)	Twitter for Android	nan		nan	absent	absent			1	1	['history', 'travel', 'ww', 'art', 'photography', 'architecture', 'culture', 's', 'museum', 'love', 'nature', 'heritage', 'historia', 'photooftheday', 'italy', 'ig', 'instagood', 'europe', 'war', 'vintage', 'instagram', 'historical', 'india', 'photo', 'bhfyp', 'explore', 'bhfyp']	[]	[]
1209121656830144512	WZ1W77WloUuz4jbjw8j5omNlBCFy7+WC2ruepmhAP3o=	en	Would we call this a racist act or an act of the devil? It makes no sense sending a threat letter to a church, or may be it's fine to say the devil is a racist. “We will not back down," said Pastor Dorian.We will stand as a community. https://t.co/lPpwC6MgpQ. https://t.co/BAWqR05rG7	Mon Dec 23 2019 14:40:00 GMT+0000 (Coordinated Universal Time)	Twitter for Android	nan		nan	absent	absent		1			[]	['https://www.wect.com/2019/12/23/local-church-responds-racially-charged-hate-mail/']	[]
1225680912861384704	WZ1W77WloUuz4jbjw8j5omNlBCFy7+WC2ruepmhAP3o=	en	Speaks truth through music. Poetic justice #music #voice #TruthMatters #FridayMorning #BeTheChange #FridayMotivation #Racisme #AllLivesMatter https://t.co/h40m2nAqxn	Fri Feb 07 2020 07:21:00 GMT+0000 (Coordinated Universal Time)	Twitter for Android	nan		nan	absent	absent			1	3	['music', 'voice', 'TruthMatters', 'FridayMorning', 'BeTheChange', 'FridayMotivation', 'Racisme', 'AllLivesMatter']	[]	[]
1216618050771914752	WZ1W77WloUuz4jbjw8j5omNlBCFy7+WC2ruepmhAP3o=	en	“Drumfolk” — a celebration of community, resilience and determination — will feature Step Afrika!’s first presentation of traditional masked dances from West Africa; a choreographic investigation of the ring shout. https://t.co/SmIRqQ9XLE #BlackHistoryMonth #blacklivesmatter https://t.co/Bkq9s0r1Ci	Mon Jan 13 2020 07:08:00 GMT+0000 (Coordinated Universal Time)	Twitter for Android	nan		nan	absent	absent		1	2		['BlackHistoryMonth', 'blacklivesmatter']	['https://bit.ly/2FJ4vu3']	[]
1231854720547000320	WZ1W77WloUuz4jbjw8j5omNlBCFy7+WC2ruepmhAP3o=	en	We have been educated by a racist school system that teaches about #white contributions. #BlackHistoryMonth #BlackTwitter #AfricanAmerican https://t.co/Yp2nKk79Zk	Mon Feb 24 2020 08:13:00 GMT+0000 (Coordinated Universal Time)	Twitter for Android	nan		nan	absent	absent			2	1	['white', 'BlackHistoryMonth', 'BlackTwitter', 'AfricanAmerican']	[]	[]
1201896202444398593	H2PSIOTcR8CxyUWzDi8EsKl9ViwEVOz5TpLD93G0C8=	en	What the hell is wrong with this lady? He doesn't want to talk to you, don't you get it!!!! This sh*t is a mess. #Racist #racisme #Diversity #FantasyGold #RacismeAntiBlancs https://t.co/738KAns09u	Tue Dec 03 2019 16:09:00 GMT+0000 (Coordinated Universal Time)	Twitter for Android	nan		nan	absent	absent					['Racist', 'racisme', 'Diversity', 'FantasyGold', 'RacismeAntiBlancs']	[]	[]
1154030763853012994	5FVVz+n2OId1GWqLGknVenFXodQrdBb8toPcBwDiKik=	en	People living outside Africa think Africa is just a small country and we all know each other. Well, Africa is made up of 54 beautiful countries but the love we show to each other makes us more united and stronger #WednesdayThoughts #proudafrican #BlackLove	Wed Jul 24 2019 14:09:00 GMT+0000 (Coordinated Universal Time)	Twitter for Android	nan		nan	absent	absent					['WednesdayThoughts', 'proudafrican', 'BlackLove']	[]	[]


CREATE TABLE ghana_nigeria_takedown_tweets (
  "tweetid" BIGINT,
  "userid" VARCHAR,
  "tweet_language" VARCHAR,
  "tweet_text" VARCHAR,
  "tweet_time" TIMESTAMP,
  "tweet_client_name" VARCHAR,
  "in_reply_to_userid" VARCHAR,
  "in_reply_to_tweetid" DOUBLE,
  "quoted_tweet_tweetid" DOUBLE,
  "is_retweet" BOOLEAN,
  "retweet_userid" VARCHAR,
  "retweet_tweetid" DOUBLE,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "quote_count" DOUBLE,
  "reply_count" DOUBLE,
  "like_count" DOUBLE,
  "retweet_count" DOUBLE,
  "hashtags" VARCHAR,
  "urls" VARCHAR,
  "user_mentions" VARCHAR,
  "poll_choices" VARCHAR
);