turbot/twitter

GitHub
steampipe plugin install twittersteampipe plugin install twitter

Table: twitter_search_recent

Search the last 7 days of public tweets using the Twitter search syntax and operators.

Notes:

  • The query field must be set in the where clause.
  • To prevent excess API quota use, results are limited to max_results_per_query by default.

Examples

Tweets matching a hashtag

select
*
from
twitter_search_recent
where
query = '#rowscoloredglasses'

Tweets mentioning a user

select
*
from
twitter_search_recent
where
query = '@steampipeio'

Tweets by a given author

select
*
from
twitter_search_recent
where
query = 'from:steampipeio'

Tweets in reply to a user

select
*
from
twitter_search_recent
where
query = 'to:steampipeio'
select
*
from
twitter_search_recent
where
query = 'url:steampipe.io'

Place, author, and text for tweets about the weather in Vermont

select
place ->> 'full_name' as place,
author ->> 'username' as author,
text
from
twitter_search_recent
where
query = 'weather'
and place ->> 'full_name' ~* ' vt$' -- regex matches 'Barre VT' etc

Tweets about weather within 10 miles of a lat/lon location

Note: point_radius and related operators are not available with a basic ("Essential") account, see operators by product.

select
*
from
twitter_search_recent
where
query = 'weather point_radius:[-105.292778 40.019444 10mi]'

.inspect twitter_search_recent

Search public Tweets posted over the last 7 days.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
attachment_pollsjsonbPolls attached to the Tweet.
attachmentsjsonbSpecifies the type of attachments (if any) present in this Tweet.
authorjsonbAuthor of the Tweet.
author_idtextUnique identifier of the author of the Tweet.
cashtagsjsonbList of cashtags (e.g. $TWTR) mentioned in the Tweet.
context_annotationsjsonbContains context annotations for the Tweet.
conversation_idtextThe Tweet ID of the original Tweet of the conversation (which includes direct replies, replies of replies).
created_attimestamp with time zoneCreation time of the Tweet.
entitiesjsonbContains details about text that has a special meaning in a Tweet.
geojsonbContains details about the location tagged by the user in this Tweet, if they specified one.
hashtagsjsonbList of hashtags (e.g. #sql) mentioned in the Tweet.
idtextUnique identifier of this Tweet.
in_reply_to_user_idtextIf this Tweet is a Reply, indicates the user ID of the parent Tweet's author.
in_reply_userjsonbUser the Tweet was in reply to.
langtextLanguage of the Tweet, if detected by Twitter. Returned as a BCP47 language tag.
mentionsjsonbList of users (e.g. steampipeio) mentioned in the Tweet.
mentions_objjsonbUsers mentioned in the Tweet.
placejsonbPlace where the Tweet was created.
possibly_sensitivebooleanIndicates if this Tweet contains URLs marked as sensitive, for example content suitable for mature audiences.
public_metricsjsonbEngagement metrics for the Tweet at the time of the request.
querytextQuery string for the exploit search.
quotedtextIf this Tweet is a Quote Tweet, indicates the ID of the original Tweet.
referenced_tweetsjsonbTweets referenced in this Tweet.
replied_totextIf this Tweet is a Reply, indicates the ID of the Tweet it is a reply to.
retweetedtextIf this Tweet is a Retweet, indicates the ID of the orginal Tweet.
sourcetextThe name of the app the user Tweeted from.
texttextThe content of the Tweet.
urlsjsonbList of URLs (e.g. https://steampipe.io) mentioned in the Tweet.
withheldjsonbContains withholding details for withheld content.