Query users who are followers of the specified user ID.
user_id field must be provided.
List followers for a user
select*fromtwitter_user_followerwhereuser_id = '1318177503995985921' -- @steampipeio
List followers by username
selectuf.id,uf.usernamefromtwitter_user_follower as ufwhereuf.user_id in(selectidfromtwitter_userwhereusername = 'steampipeio')
selectuf.id,uf.usernamefromtwitter_user_follower as uf,twitter_user as uwhereuf.user_id = u.idand u.username = 'steampipeio'
Find the top 10 followers for a user
selectuf.id,uf.username,(uf.public_metrics ->> 'followers_count')::int as follower_countfromtwitter_user_follower as uf,twitter_user as uwhereuf.user_id = u.idand u.username = 'steampipeio'order byfollower_count desclimit10
List of users the specified user ID is follower.
|created_at||timestamp without time zone||The UTC datetime that the user account was created on Twitter.|
|description||text||The text of this user's profile description (also known as bio), if the user provided one.|
|entities||jsonb||Entities are JSON objects that provide additional information about hashtags, urls, user mentions, and cashtags associated with the description.|
|id||text||The unique identifier of this user.|
|location||text||The 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.|
|name||text||The name of the user, as they’ve defined it on their profile. Not necessarily a person’s name.|
|pinned_tweet||jsonb||Contains withholding details for withheld content, if applicable.|
|pinned_tweet_id||text||Unique identifier of this user's pinned Tweet.|
|profile_image_url||text||The URL to the profile image for this user, as shown on the user's profile.|
|protected||text||Indicates if this user has chosen to protect their Tweets (in other words, if this user's Tweets are private).|
|public_metrics||jsonb||Contains details about activity for this user.|
|url||text||The URL specified in the user's profile, if present.|
|user_id||text||ID of the user who is followed by these users.|
|username||text||The Twitter screen name, handle, or alias that this user identifies themselves with. Usernames are unique but subject to change.|
|verified||boolean||Indicates if this user is a verified Twitter User.|
|withheld||jsonb||Contains withholding details for withheld content, if applicable.|