twitter tweets
This table includes all tweets from 2006 (approximately 35.9 million rows).
Field | Description |
|---|---|
twitter tweet id | Unique ID maintained by Deck representing a given tweet. |
twitter user id | Unique ID maintained by Deck representing a given Twitter user. |
status id | The tweet ID. |
user id | The user ID maintained by Twitter. |
handle | The Twitter handle of the user. |
is retweet | Boolean if the given tweet is a retweet. |
favorite count | The number of times the given tweet has been favorited. |
retweet count | The number of times the given tweet has been retweeted. |
text | The text of the given tweet. |
tweet created at | Timestamp of the given tweet. |
status id orig | If this is a retweet, this is the ID of the original tweet. |
user id orig | If this tweet is a retweet, this is the Twitter generated user ID of the Tweet's author. |
twitter user id orig | If this is a retweet, Deck's own unique user ID for the original Twitter user. |
last updated at | The timestamp of the last time Deck updated the data. |
[
{
"twitter_tweet_id": "ff17f4a8-e36f-4c0a-9ac8-adeea09cad25",
"twitter_user_id": null,
"status_id": "1418025324948992004",
"user_id": "939977297330876416",
"handle": "MattforMichigan",
"is_retweet": "false",
"favorite_count": "11",
"retweet_count": "0",
"text": "Great night at the @CantonDems picnic. It is so rewarding to see a group so energized and ready to go for 2022! https://t.co/seC51vx1dI",
"tweet_created_at": "2021-07-22 01:49:17.000000 UTC",
"status_id_orig": null,
"user_id_orig": null,
"twitter_user_id_orig": null,
"last_updated_at": "2022-05-16 15:06:46.000000 UTC"
}
]
Last modified 1mo ago