About this Dataset

Twitter Posts

The dataset consists of structured records of posts collected from X (formerly Twitter), capturing social media interactions at scale. Each entry includes post content, timestamp, author identifier (anonymized), engagement metrics such as likes, reposts, and replies, as well as contextual metadata like hashtags and mentions. Organized longitudinally, it forms a comprehensive time-series dataset supporting analysis of social discourse, sentiment dynamics, trend emergence, and the training of AI models for language understanding and social behavior prediction.

Tables

Tweets

@pjsousa.twitter_posts.tweets

108.5 kB
2,866 rows
10 columns

CREATE TABLE tweets (
  "handle" VARCHAR,
  "user_id" VARCHAR,
  "tweet_id" VARCHAR,
  "text" VARCHAR,
  "created_at" TIMESTAMP,
  "likes" BIGINT,
  "retweets" BIGINT,
  "replies" BIGINT,
  "quotes" BIGINT,
  "subtweet_id" VARCHAR
);