​ on Nostr: nprofile1q…6wawj agency=# select data->>'type', count(data->>'type') as count from ...

nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqu3w2hvj4pdheskj0ukhje3sphf2xspsv8q4axcqjgsu6l5455w2sf6wawj (nprofile…wawj)
agency=# select data->>'type', count(data->>'type') as count from activities group by data->>'type' order by count desc;
?column? | count
------------+----------
Create | 20877732
Announce | 2837909
Like | 1189087
EmojiReact | 701261
Update | 614204
Undo | 114771
Listen | 87105
Follow | 10845
Accept | 9278
Delete | 4162
Remove | 3038
Add | 1439
Block | 1126
Reject | 866
Flog | 135
Move | 61
(16 rows)
Only three million creates more than last year. Also 87 thousand scrobbles, I wonder who's doing that still.