Tweets Of The Top 5 Banks In South Africa
Tweets related to Capitec, Standard Bank, ABSA, FNB, Nedbank for 2019-2021 Sept
@kaggle.slythe_twitter_scrape_of_the_top_5_banks_in_south_africa
Tweets related to Capitec, Standard Bank, ABSA, FNB, Nedbank for 2019-2021 Sept
@kaggle.slythe_twitter_scrape_of_the_top_5_banks_in_south_africa
CREATE TABLE full_2019 (
"unnamed_0" BIGINT,
"id" DOUBLE,
"conversation_id" DOUBLE,
"created_at" DOUBLE,
"date" TIMESTAMP,
"timezone" BIGINT,
"place" VARCHAR,
"base_tweet" VARCHAR,
"cleaned_tweet" VARCHAR,
"language" VARCHAR,
"hashtags" VARCHAR,
"cashtags" VARCHAR,
"user_id" DOUBLE,
"user_id_str" DOUBLE,
"username" VARCHAR,
"name" VARCHAR,
"day" BIGINT,
"hour" BIGINT,
"link" VARCHAR,
"urls" VARCHAR,
"photos" VARCHAR,
"video" BIGINT,
"thumbnail" VARCHAR,
"retweet" BOOLEAN,
"nlikes" BIGINT,
"nreplies" BIGINT,
"nretweets" BIGINT,
"quote_url" VARCHAR,
"search" 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
);
CREATE TABLE full_2020 (
"unnamed_0" BIGINT,
"id" DOUBLE,
"conversation_id" DOUBLE,
"created_at" DOUBLE,
"date" TIMESTAMP,
"timezone" BIGINT,
"place" VARCHAR,
"base_tweet" VARCHAR,
"cleaned_tweet" VARCHAR,
"language" VARCHAR,
"hashtags" VARCHAR,
"cashtags" VARCHAR,
"user_id" DOUBLE,
"user_id_str" DOUBLE,
"username" VARCHAR,
"name" VARCHAR,
"day" BIGINT,
"hour" BIGINT,
"link" VARCHAR,
"urls" VARCHAR,
"photos" VARCHAR,
"video" BIGINT,
"thumbnail" VARCHAR,
"retweet" BOOLEAN,
"nlikes" BIGINT,
"nreplies" BIGINT,
"nretweets" BIGINT,
"quote_url" VARCHAR,
"search" 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
);
CREATE TABLE full_2021 (
"unnamed_0" BIGINT,
"id" DOUBLE,
"conversation_id" DOUBLE,
"created_at" DOUBLE,
"date" TIMESTAMP,
"timezone" BIGINT,
"place" VARCHAR,
"base_tweet" VARCHAR,
"cleaned_tweet" VARCHAR,
"language" VARCHAR,
"hashtags" VARCHAR,
"cashtags" VARCHAR,
"user_id" DOUBLE,
"user_id_str" DOUBLE,
"username" VARCHAR,
"name" VARCHAR,
"day" BIGINT,
"hour" BIGINT,
"link" VARCHAR,
"urls" VARCHAR,
"photos" VARCHAR,
"video" BIGINT,
"thumbnail" VARCHAR,
"retweet" BOOLEAN,
"nlikes" BIGINT,
"nreplies" BIGINT,
"nretweets" BIGINT,
"quote_url" VARCHAR,
"search" 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
);
Anyone who has the link will be able to view this.