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 Users

@kaggle.thedfrlab_datafest_tbilisi_2020.ghana_nigeria_takedown_users

23.42 KB
70 rows
10 columns

userid Userid	user_display_name User Display Name	user_screen_name User Screen Name	user_reported_location User Reported Location	user_profile_description User Profile Description	user_profile_url User Profile Url	follower_count Follower Count	following_count Following Count	account_creation_date Account Creation Date	account_language Account Language
jfHc+PR1RAcWZbVeokGvHkppdJhVd1URHnz981PHHVc=	jfHc+PR1RAcWZbVeokGvHkppdJhVd1URHnz981PHHVc=	jfHc+PR1RAcWZbVeokGvHkppdJhVd1URHnz981PHHVc=	African	African my pride. Power To The People 💪🏾💪🏿	nan	1771	1829	Wed Jul 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	en
BQSd6HG5pCEX3Vbw28UJIbW6cDXtu4bgejnAfZmnlKc=	BQSd6HG5pCEX3Vbw28UJIbW6cDXtu4bgejnAfZmnlKc=	BQSd6HG5pCEX3Vbw28UJIbW6cDXtu4bgejnAfZmnlKc=	nan	Racism springs from Ignorance Say No To Racism.	nan	60	76	Mon Jul 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	en
wIC9Jo2WdkBTapeMXo6zeX57hvpxs4IJqQU0OMJfvM=	wIC9Jo2WdkBTapeMXo6zeX57hvpxs4IJqQU0OMJfvM=	wIC9Jo2WdkBTapeMXo6zeX57hvpxs4IJqQU0OMJfvM=	nan	nan	nan		25	Mon Aug 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	en
MrAqJYr2xk9TuxpWT7HvbRTiH02zJ4i4RKeWaGP+31A=	MrAqJYr2xk9TuxpWT7HvbRTiH02zJ4i4RKeWaGP+31A=	MrAqJYr2xk9TuxpWT7HvbRTiH02zJ4i4RKeWaGP+31A=	Accra, Ghana	Black woman passionate about my root #BlackLivesMatter #PoliceBrutality #Racism #RacialProfiling #AllLivesMatter #RacialEquality	nan	4584	4641	Sat Jul 13 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	en
a735pdxuZ9tyTJOsgpvGWXKU+BZj9UXhjmXRtvPKi0=	a735pdxuZ9tyTJOsgpvGWXKU+BZj9UXhjmXRtvPKi0=	a735pdxuZ9tyTJOsgpvGWXKU+BZj9UXhjmXRtvPKi0=	Ghana	I stand for truth and project the image of humanity.	nan	98	186	Fri Jul 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	en
jABJdRs3DsnvqL1EboMltuFxbycEVwNGySXzeIKcv4=	jABJdRs3DsnvqL1EboMltuFxbycEVwNGySXzeIKcv4=	jABJdRs3DsnvqL1EboMltuFxbycEVwNGySXzeIKcv4=	nan	Campaigning To End All Forms Of Violence Against Women❗ Sharing Stories And Solutions To Improve Life For Women x Girls👭 Equality For All	nan	1811	4354	Tue Jul 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	en
aRM5dH4TX8EPW5RUf0UsslawRqL4O9hnfbdDhO8sY=	aRM5dH4TX8EPW5RUf0UsslawRqL4O9hnfbdDhO8sY=	aRM5dH4TX8EPW5RUf0UsslawRqL4O9hnfbdDhO8sY=	somewhere in The World	man utd Glory Glory Music Art Lifestyle. You Dream I Act	nan	6	127	Sat Jul 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	en
PvMtU8hSwydfwGdw7yuVC5yBPXjIE7+pZi0m0X7UtQ=	PvMtU8hSwydfwGdw7yuVC5yBPXjIE7+pZi0m0X7UtQ=	PvMtU8hSwydfwGdw7yuVC5yBPXjIE7+pZi0m0X7UtQ=	Everywhere	We are creating awareness to eliminate barriers affecting the rights of Queer( Lesbians, bisexuals and Trans)Women through Social Media activism Globally.	nan	1251	1168	Sun Sep 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	en
Mb41Eha8m3pQ2Wjmdzm1Jh+jitjvaTD7gtoyGH3bDTM=	Mb41Eha8m3pQ2Wjmdzm1Jh+jitjvaTD7gtoyGH3bDTM=	Mb41Eha8m3pQ2Wjmdzm1Jh+jitjvaTD7gtoyGH3bDTM=	nan	Beauty in Africans	nan	13	71	Tue Feb 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	en
pWAgwQT6pZlN8cd5rhH17NF9SMU3t1oqVJiTxTjCrM=	pWAgwQT6pZlN8cd5rhH17NF9SMU3t1oqVJiTxTjCrM=	pWAgwQT6pZlN8cd5rhH17NF9SMU3t1oqVJiTxTjCrM=	nan	Passionate about my black roots	nan	66	112	Tue Aug 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	en


CREATE TABLE ghana_nigeria_takedown_users (
  "userid" VARCHAR,
  "user_display_name" VARCHAR,
  "user_screen_name" VARCHAR,
  "user_reported_location" VARCHAR,
  "user_profile_description" VARCHAR,
  "user_profile_url" VARCHAR,
  "follower_count" BIGINT,
  "following_count" BIGINT,
  "account_creation_date" TIMESTAMP,
  "account_language" VARCHAR
);