Search code examples
twitter

Is it possible to search Twitter Users by number of followers?

I would like to find public users on Twitter that have 0 followers. I was thinking of using https://developer.twitter.com/en/docs/accounts-and-users/follow-search-get-users/api-reference/get-users-search, but this doesn't have a way to filter by number of followers. Are there any simple alternatives? (Otherwise, I might have to resort to using a graph/search based approach starting from a random point)

Solution

  • Bird SQL by Perplexity AI allows you to do this simply: https://www.perplexity.ai/sql

    Query: Users with 0 followers, and 0 following, with at least 5 tweets

    SELECT user_url, full_name, followers_count, following_count, tweet_count
FROM users
WHERE (followers_count = 0)
  AND (following_count = 0)
  AND (tweet_count >= 5)
ORDER BY tweet_count DESC
LIMIT 10