This dataset is collected by Subnet 0 and organized into two main tables: profiles and tweets.

The profiles table contains information about Twitter user profiles, with the following columns:

Column NameDescription
collect_timestampTimestamp when the profile data was collected
idUnique identifier for the Twitter user profile
nameName of the Twitter user
display_nameDisplay name of the Twitter user
bioBiography of the Twitter user
is_blue_verifiedIndicates if the user is blue verified
created_timestampTimestamp when the Twitter account was created
locationLocation of the Twitter user
profession_typeType of profession of the Twitter user
profession_categoriesCategories related to the user’s profession
followingNumber of accounts the user is following
followersNumber of followers the user has
tweets_countTotal number of tweets made by the user
linksLinks associated with the Twitter user
banner_image_urlURL of the user’s banner image
profile_image_urlURL of the user’s profile image
pinned_tweet_idsIDs of tweets pinned by the user

The tweets table contains information about tweets made by users, with the following columns:

Column NameDescription
collect_timestampTimestamp when the tweet data was collected
idUnique identifier for the tweet
poster_idID of the user who posted the tweet
textContent of the tweet
timestampTimestamp when the tweet was posted
is_noteIndicates if the tweet is a note
imagesImages associated with the tweet
videosVideos associated with the tweet
hashtagsHashtags used in the tweet
tagged_usersUsers tagged in the tweet
repliesNumber of replies to the tweet
repostsNumber of times the tweet has been reposted
likesNumber of likes the tweet has received
viewsNumber of views the tweet has received
quotesNumber of quotes of the tweet
bookmarksNumber of bookmarks of the tweet
quote_parent_idID of the parent tweet if this tweet is a quote
quote_poster_idID of the user who posted the parent tweet
reply_conversation_idID of the conversation this tweet is part of
reply_parent_idID of the parent tweet in the reply conversation
reply_poster_idID of the user who posted the parent tweet
retweet_parent_idID of the parent tweet if this tweet is a retweet
retweet_poster_idID of the user who posted the parent tweet

Utilities for the Twitter dataset

  1. Tweet Id to URL: https://twitter.com/i/web/status/{tweetId}
  2. Profile Id to URL: https://twitter.com/intent/user?user_id={userId}