twitter mentions
This table includes the Twitter data on tweets that include mentions that Deck collects (approximately 12.8 million rows).
Field | Description |
|---|---|
twitter mention id | Unique ID maintained by Deck given to the mention. |
mentioned handle | The Twitter handle of the user mentioned |
mention type | The type of mention: recent or popular |
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 tweet is a retweet. |
favorite count | The number of favorites that the give tweet has received. |
retweet count | The number of retweets that the given tweet has received. |
text | The text of the tweet. |
tweet created at | The timestamp of the 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_mention_id": "0af13d5b-2397-49f1-a40f-50fa6f4a7473",
"mentioned_handle": "kimKBaltimore",
"mention_type": "recent",
"twitter_user_id": "117bfdd2-5f93-4fec-acfb-bc7a01ed1b6f",
"status_id": "1349867024399405057",
"user_id": "893114873814568960",
"handle": "MARichardson18",
"is_retweet": "false",
"favorite_count": "0",
"retweet_count": "0",
"text": "@kimKBaltimore The backstory! https://t.co/5vV94RAJxl",
"tweet_created_at": "2021-01-14 23:52:32.000000 UTC",
"status_id_orig": null,
"user_id_orig": null,
"twitter_user_id_orig": "42b0e7b4-afd0-413f-ac5f-ec2d2653fa96",
"last_updated_at": null
}
]
Last modified 1mo ago