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'

Tweets using a URL (matches expanded form inside short links)

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.

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
attachment_polls	jsonb	Polls attached to the Tweet.
attachments	jsonb	Specifies the type of attachments (if any) present in this Tweet.
author	jsonb	Author of the Tweet.
author_id	text	Unique identifier of the author of the Tweet.
cashtags	jsonb	List of cashtags (e.g. $TWTR) mentioned in the Tweet.
context_annotations	jsonb	Contains context annotations for the Tweet.
conversation_id	text	The Tweet ID of the original Tweet of the conversation (which includes direct replies, replies of replies).
created_at	timestamp with time zone	Creation time of the Tweet.
entities	jsonb	Contains details about text that has a special meaning in a Tweet.
geo	jsonb	Contains details about the location tagged by the user in this Tweet, if they specified one.
hashtags	jsonb	List of hashtags (e.g. #sql) mentioned in the Tweet.
id	text	Unique identifier of this Tweet.
in_reply_to_user_id	text	If this Tweet is a Reply, indicates the user ID of the parent Tweet's author.
in_reply_user	jsonb	User the Tweet was in reply to.
lang	text	Language of the Tweet, if detected by Twitter. Returned as a BCP47 language tag.
mentions	jsonb	List of users (e.g. steampipeio) mentioned in the Tweet.
mentions_obj	jsonb	Users mentioned in the Tweet.
place	jsonb	Place where the Tweet was created.
possibly_sensitive	boolean	Indicates if this Tweet contains URLs marked as sensitive, for example content suitable for mature audiences.
public_metrics	jsonb	Engagement metrics for the Tweet at the time of the request.
query	text	Query string for the exploit search.
quoted	text	If this Tweet is a Quote Tweet, indicates the ID of the original Tweet.
referenced_tweets	jsonb	Tweets referenced in this Tweet.
replied_to	text	If this Tweet is a Reply, indicates the ID of the Tweet it is a reply to.
retweeted	text	If this Tweet is a Retweet, indicates the ID of the orginal Tweet.
source	text	The name of the app the user Tweeted from.
text	text	The content of the Tweet.
urls	jsonb	List of URLs (e.g. https://steampipe.io) mentioned in the Tweet.
withheld	jsonb	Contains withholding details for withheld content.

turbot/twitter