DataFest Tbilisi 2020 Challenge
Data challenge - Data analysis at DataFest Tbilisi 2020
@kaggle.thedfrlab_datafest_tbilisi_2020
Data challenge - Data analysis at DataFest Tbilisi 2020
@kaggle.thedfrlab_datafest_tbilisi_2020
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
);
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
);
CREATE TABLE ghana_trending_topics_200401_200519 (
"row_id" VARCHAR,
"n" BIGINT,
"time_hh_mm" VARCHAR,
"date" TIMESTAMP,
"trending_topic" VARCHAR
);
CREATE TABLE nigeria_trending_topics_200401_200519 (
"row_id" VARCHAR,
"n" BIGINT,
"time_hh_mm" VARCHAR,
"date" TIMESTAMP,
"trending_topic" VARCHAR
);
Anyone who has the link will be able to view this.