Even though Twitter's statuses/retweets API endpoint is limited to the last 100 retweets it is possible to use the search/tweets endpoint to search for the retweets using the text of the tweet. Caveat: This is only possible for tweets that have happened in the last 7 days, which is furthest back Twitter allow you to search for tweets in.
For example here is how you can get the retweets for this tweet and analyze the users in a spreadsheet.
-
First install twarc for interacting with the Twitter API from the command line. If you don't have Python yet you'll need to go get that first.
pip install twarc -
Now you are ready to tell twarc about your Twitter API keys. Go over to apps.twitter.com, create an app and note the keys down so you can tell twarc about them:
twarc configure -
Collect the tweets using twarc's search command using some identifying text of the tweet in question, then write them to a file:
twarc search 'Bring on the bots and sock puppet accounts Amazing how a tweet about Putin' > krebs.jsonl -
If you want to be absolutely sure the file only includes retweets of that specific tweet you can use jq to filter them using the tweet id of the original tweet:
jq -cr 'select(.retweeted_status.id_str = "902545914304319491")' krebs.jsonl > krebs-filtered.jsonl -
Now that you have the JSON for the retweets you can do analysis of the users by creating a CSV file of information about them. For example:
jq -r '[.user.screen_name, .user.followers_count, .user.friends_count, .user.statuses_count, .user.created_at, .user.lang] | @csv' krebs-filtered.jsonl > users.csv