Coachella 2019 Tweets
@kaggle.pdp2600_coachella_2019_tweets
@kaggle.pdp2600_coachella_2019_tweets
CREATE TABLE coachella_2019_tweets_weekend_1_2019_04_07_to_2019_04_16 (
"created_at" VARCHAR,
"id_str" BIGINT,
"text" VARCHAR,
"truncated" BIGINT,
"reply_to_tweet_id" DOUBLE,
"reply_to_user_id" DOUBLE,
"reply_to_screen_name" VARCHAR,
"is_quote_status" BIGINT,
"retweet_count" BIGINT,
"favorite_count" BIGINT,
"user_id_str" BIGINT,
"user_name" VARCHAR,
"user_screen_name" VARCHAR,
"user_location" VARCHAR,
"user_description" VARCHAR,
"user_profile_url" VARCHAR,
"user_follower_count" BIGINT,
"user_friends_count" BIGINT,
"user_created_at" VARCHAR,
"user_statuses_count" BIGINT,
"user_language" VARCHAR,
"tweet_url" VARCHAR,
"full_tweet_text" VARCHAR,
"tweeted_at_pst" TIMESTAMP
);
CREATE TABLE coachella_2019_tweets_weekend_2_2019_04_14_to_2019_04_23 (
"created_at" VARCHAR,
"id_str" BIGINT,
"text" VARCHAR,
"truncated" BIGINT,
"reply_to_tweet_id" DOUBLE,
"reply_to_user_id" DOUBLE,
"reply_to_screen_name" VARCHAR,
"is_quote_status" BIGINT,
"retweet_count" BIGINT,
"favorite_count" BIGINT,
"user_id_str" BIGINT,
"user_name" VARCHAR,
"user_screen_name" VARCHAR,
"user_location" VARCHAR,
"user_description" VARCHAR,
"user_profile_url" VARCHAR,
"user_follower_count" BIGINT,
"user_friends_count" BIGINT,
"user_created_at" VARCHAR,
"user_statuses_count" BIGINT,
"user_language" VARCHAR,
"tweet_url" VARCHAR,
"full_tweet_text" VARCHAR,
"tweeted_at_pst" TIMESTAMP
);
Anyone who has the link will be able to view this.