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 thewhere
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_recentwhere query = '#rowscoloredglasses'
Tweets mentioning a user
select *from twitter_search_recentwhere query = '@steampipeio'
Tweets by a given author
select *from twitter_search_recentwhere query = 'from:steampipeio'
Tweets in reply to a user
select *from twitter_search_recentwhere query = 'to:steampipeio'
Tweets using a URL (matches expanded form inside short links)
select *from twitter_search_recentwhere 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_recentwhere 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_recentwhere 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. |