Some jq fun

twitter_archive_fun.sh

# Most interactions / mentions, excluding myself. 

{ sed -e '1s/.*/[/' -e '$d'  tweets.js && sed '1s/.*/,/' tweets-part1.js; } | \
jq  '
  [.[].tweet.entities.user_mentions[] | select(.screen_name != "rotnroll666") | {handle: .screen_name}] |
  group_by(.handle) | map(.[0] + {"count": length}) |
  sort_by(-.count,.handle|=ascii_downcase) | limit(20;.[]) |
  "@\(.handle) (\(.count))"
'

# "Best" tweets by RT (turns out, that retweets are in the archive, but prefixed only with RT @... 
# and not a proper info

{ sed -e '1s/.*/[/' -e '$d'  tweets.js && sed '1s/.*/,/' tweets-part1.js; } | \
jq -r '
  [.[] | select(.tweet.full_text | startswith("RT @") | not)] |
  sort_by(.tweet.retweet_count|tonumber) |reverse | limit(3;.[]) |
  "\(.tweet.retweet_count|tonumber): https://twitter.com/rotnroll666/status/\(.tweet.id_str)"
'

# Same but by fav

{ sed -e '1s/.*/[/' -e '$d'  tweets.js && sed '1s/.*/,/' tweets-part1.js; } | \
jq -r '
  [.[] | select(.tweet.full_text | startswith("RT @") | not)] |
  sort_by(.tweet.favorite_count|tonumber) |reverse | limit(3;.[]) |
  "\(.tweet.favorite_count|tonumber): https://twitter.com/rotnroll666/status/\(.tweet.id_str)"
'