Skip to main content

Useful Diaspora* jq recipes: Finding your most-engaged peers


One question I've had on Diaspora* is who it is I'm interacting with most often.

This is an extract to a Linux / Unix pipeline which will show the most frequent users within the "others_data.relayables" data.
jq -r '.others_data.relayables[].entity_data.author' |
    sort | uniq -c | sort -k1nr | cat -n | less

For those unfamiliar with scripting: after extractng the data, I'm passing it through a set of Linux utilities. "sort | uniq" is something of an idiom for tallying frequencies.

These indicate any 'like', 'comment', or 'poll' interactions, but not reshares, best I can tell. For the record, the summary:
$  jq -r '.others_data.relayables[].entity_type' archive.json |
    sort | uniq -c | sort -k1nr | cat -n
1  16319 like
 2  7979 comment
 3    67 poll_participation

I will allow that the profile most frequently interacting ... was something of a surprise.

I feel I can share my top 20 hosts / pods:
     1    15937 pluspora.com
     2     2802 diasp.org
     3     2019 diaspora.glasswings.com
     4      996 joindiaspora.com
     5      666 social.isurf.ca
     6      361 diasp.eu
     7      206 diasporing.ch
     8      104 framasphere.org
     9       99 pod.geraspora.de
    10       92 hub.libranet.de
    11       64 diaspora.psyco.fr
    12       64 diaspora.ty-penguin.org.uk
    13       64 hey.iseeamess.com
    14       48 social.c-r-t.tk
    15       44 diaspora-fr.org
    16       42 nerdpol.ch
    17       40 pod.orkz.net
    18       39 diaspora.permutationsofchaos.com
    19       31 protagio.social
    20       30 societas.online

Some expected results and a few surprises there. Note that Pluspora provides an overwhelming amount of traffic, and Joindiaspora, despite its 300k members and 10 year history ranks only 4th overall. The recently-departed social.isurf.ca hit a rather storied number and ranked 5th overall.

And as I've mentioned previously, jq itself is an extraordinarily useful, if occasionally opaque, command-line tool for processing and parsing JSON data. Which happens to be how Diaspora* delivers much of its content.

# # # # #

jq

stedolan.github.io
#diaspora #Tips #jq #json #UsefulJqRecipes
⇧