turbot/twitter

GitHub
steampipe plugin install twittersteampipe plugin install twitter

Table: twitter_user_follower

Query users who are followers of the specified user ID.

Note: The user_id field must be set in the where clause.

Examples

List followers for a user

select
*
from
twitter_user_follower
where
user_id = '1318177503995985921' -- @steampipeio

List followers by username

Via subselect:

select
uf.id,
uf.username
from
twitter_user_follower as uf
where
uf.user_id in (
select
id
from
twitter_user
where
username = 'steampipeio'
)

Via join:

select
uf.id,
uf.username
from
twitter_user_follower as uf,
twitter_user as u
where
uf.user_id = u.id
and u.username = 'steampipeio'

Find the top 10 followers for a user

Via join:

select
uf.id,
uf.username,
(uf.public_metrics ->> 'followers_count') :: int as follower_count
from
twitter_user_follower as uf,
twitter_user as u
where
uf.user_id = u.id
and u.username = 'steampipeio'
order by
follower_count desc
limit
10

.inspect twitter_user_follower

List of users the specified user ID is follower.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zoneThe UTC datetime that the user account was created on Twitter.
descriptiontextThe text of this user's profile description (also known as bio), if the user provided one.
entitiesjsonbEntities are JSON objects that provide additional information about hashtags, urls, user mentions, and cashtags associated with the description.
idtextThe unique identifier of this user.
locationtextThe location specified in the user's profile, if the user provided one. As this is a freeform value, it may not indicate a valid location, but it may be fuzzily evaluated when performing searches with location queries.
nametextThe name of the user, as they’ve defined it on their profile. Not necessarily a person’s name.
pinned_tweetjsonbContains withholding details for withheld content, if applicable.
pinned_tweet_idtextUnique identifier of this user's pinned Tweet.
profile_image_urltextThe URL to the profile image for this user, as shown on the user's profile.
protectedtextIndicates if this user has chosen to protect their Tweets (in other words, if this user's Tweets are private).
public_metricsjsonbContains details about activity for this user.
urltextThe URL specified in the user's profile, if present.
user_idtextID of the user who is followed by these users.
usernametextThe Twitter screen name, handle, or alias that this user identifies themselves with. Usernames are unique but subject to change.
verifiedbooleanIndicates if this user is a verified Twitter User.
withheldjsonbContains withholding details for withheld content, if applicable.