Name: Breaking News From Twitter 2010-2021
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Breaking News From Twitter 2010-2021

Content

This dataset contains tweets from the Twitter accounts of BBC, CNN and the Economist from 2010-2021.

Tables

Tweets Bbc

@kaggle.ruchi798_breaking_news_from_twitter_20102021.tweets_bbc

5.37 MB
34,547 rows
36 columns

CREATE TABLE tweets_bbc (
  "id" BIGINT,
  "conversation_id" BIGINT,
  "created_at" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "timezone" BIGINT,
  "user_id" BIGINT,
  "username" VARCHAR,
  "name" VARCHAR,
  "place" VARCHAR,
  "tweet" VARCHAR,
  "language" VARCHAR,
  "mentions" VARCHAR,
  "urls" VARCHAR,
  "photos" VARCHAR,
  "replies_count" BIGINT,
  "retweets_count" BIGINT,
  "likes_count" BIGINT,
  "hashtags" VARCHAR,
  "cashtags" VARCHAR,
  "link" VARCHAR,
  "retweet" BOOLEAN,
  "quote_url" VARCHAR,
  "video" BIGINT,
  "thumbnail" 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
);

Tweets Cnn

@kaggle.ruchi798_breaking_news_from_twitter_20102021.tweets_cnn

8.78 MB
55,236 rows
36 columns

CREATE TABLE tweets_cnn (
  "id" BIGINT,
  "conversation_id" BIGINT,
  "created_at" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "timezone" BIGINT,
  "user_id" BIGINT,
  "username" VARCHAR,
  "name" VARCHAR,
  "place" VARCHAR,
  "tweet" VARCHAR,
  "language" VARCHAR,
  "mentions" VARCHAR,
  "urls" VARCHAR,
  "photos" VARCHAR,
  "replies_count" BIGINT,
  "retweets_count" BIGINT,
  "likes_count" BIGINT,
  "hashtags" VARCHAR,
  "cashtags" VARCHAR,
  "link" VARCHAR,
  "retweet" BOOLEAN,
  "quote_url" VARCHAR,
  "video" BIGINT,
  "thumbnail" 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
);

Tweets Eco

@kaggle.ruchi798_breaking_news_from_twitter_20102021.tweets_eco

38.75 MB
254,413 rows
36 columns

CREATE TABLE tweets_eco (
  "id" BIGINT,
  "conversation_id" BIGINT,
  "created_at" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "timezone" BIGINT,
  "user_id" BIGINT,
  "username" VARCHAR,
  "name" VARCHAR,
  "place" VARCHAR,
  "tweet" VARCHAR,
  "language" VARCHAR,
  "mentions" VARCHAR,
  "urls" VARCHAR,
  "photos" VARCHAR,
  "replies_count" BIGINT,
  "retweets_count" BIGINT,
  "likes_count" BIGINT,
  "hashtags" VARCHAR,
  "cashtags" VARCHAR,
  "link" VARCHAR,
  "retweet" BOOLEAN,
  "quote_url" VARCHAR,
  "video" BIGINT,
  "thumbnail" 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
);