Fun Poster Data

No Mr. Zuckerberg

3 Likes

Pretty much everything is available in JSON format under the URL you’d expect to find it at.

1 Like

why not post user post counts? any reason not to? have we discussed this?

1 Like

Found this: Discourse API Docs

Give me some ideas of something fun to build for this forum. Or maybe I will collect some stats. What do you guys want to see?

1 Like

wtb updated likes/post graph as I feel I’ve been putting in work

my cat has cancer

5 Likes

1991 Kathy Ireland poster

3 Likes

I came across this post from last year

In further proof that we are living in a simulation it turns out that me and the Dog live a couple of miles apart in the same town

27 Likes

but did he like your first post?

11 Likes

I’m trying

Clipboard01

18 Likes

Here is a little bash script to get all the user data from the site:

#!/bin/bash

initialize()
{
    # dependencies:
    which jq >/dev/null
    [[ $? -ne 0 ]] && echo "please install jq" && exit 1
    which curl >/dev/null
    [[ $? -ne 0 ]] && echo "please install curl" && exit 1

    set -e
    base_url=https://unstuckpolitics.com
    order_by="likes_received"
    data_dir="$(pwd)/data"
    set +e; mkdir $data_dir; set -e
}

get_all_user_data()
{
    # get first page
    local i=0
    api_path="/directory_items.json?period=all&order=$order_by"
    curl_str="${base_url}${api_path}"
    curl $curl_str > $data_dir/data$i.json
    next_path=$(cat $data_dir/data$i.json | jq '.meta.load_more_directory_items' | tr -d "\"")

    # loop until directory_items is empty
    i=$((i+1))
    while [[ $i -gt 0 ]] 
    do
        curl_str="${base_url}${next_path}"
        curl $curl_str > $data_dir/data$i.json
        dir_items=$(cat $data_dir/data$i.json | jq '.directory_items[]')
        if [[ -z $dir_items ]]
        then
            set -u
            rm -f $data_dir/data$i.json
            set +u
            break
        fi
        next_path=$(cat $data_dir/data$i.json | jq '.meta.load_more_directory_items' | tr -d "\"")
        i=$((i+1))
    done
}

main()
{
    initialize
    get_all_user_data
}

main

This will create files in data/data*.json that contains all of the user data that is publicly available. There should be 10 files total. The ordering is sorted by likes_received, but you can sort by any other metric listed here:

“likes_received” “likes_given” “topic_count” “post_count” “topics_entered” “posts_read” “days_visited”

Just change the “order_by” variable in the initialize function. I could take it in as an argument but I’m lazy right now.

Here are the top posters ordered by likes received (cut out the people with zero likes):

Riverman - 17704
RiskyFlush - 14795
JohnnyTruant - 12390
microbet - 11423
beetlejuice - 11372
Trolly - 11016
Smacc_25 - 9940
cuserounder - 9150
suzzer99 - 9023
kre8tive - 8833
Marksman - 7326
WichitaDM - 7044
Namath - 6920
zikzak - 6586
skydiver8 - 6348
ggoreo - 5977
eyebooger - 5530
mosdef - 5053
Danspartan - 4728
ChrisV - 4682
otatop - 4652
simplicitus - 4573
6ix - 4263
hokie - 4243
jalfrezi - 4186
CanadaMatt3004 - 4184
clovis8 - 4156
MrWookie - 4081
tabbaker - 3958
dlk9s - 3952
Jbro - 3907
superuberbob - 3876
NotBruceZ - 3842
goofyballer - 3731
boredsocial - 3699
Coasterbrad - 3681
StimAbuser - 3656
smrk4 - 3578
geewhysee - 3542
cassette - 3329
catfacemeowmers - 3270
MattyLice - 3238
LFS - 3184
imjosh - 3059
PocketChads - 3005
LouisCyphre - 2963
Lawnmower_Man - 2958
SenorKeeed - 2950
MichaelDavis - 2834
All-InFlynn - 2828
oneeyedtripping - 2827
wirelessgrinder - 2756
Goebs80 - 2618
ViridianDreams - 2582
TheDuker - 2480
jwax13 - 2451
jman220 - 2393
Fatboy8 - 2352
jmakin - 2346
StrontiumDog - 2335
Devil - 2326
Rivaldo - 2235
TrueNorth32 - 2191
Vict0ar - 2090
Rexx - 2083
wheatrich - 2061
marty - 2045
spidercrab - 2026
seities - 2021
Yuv - 1993
champ - 1924
nunnehi - 1907
pyatnitski - 1865
Chuckleslovakian - 1803
econophile - 1760
King_of_NY - 1750
Bigoldnit - 1728
meb - 1713
prana - 1647
nonfiction - 1642
grue - 1598
DrChesspain - 1571
Crunchyblack - 1544
zarapochka - 1542
Huehuecoyotl - 1535
DodgerIrish - 1479
Watevs - 1461
MimosaDef - 1456
mjiggy - 1456
Thin_Slicing - 1451
AllTheCheese - 1446
Rugby - 1431
Mr_Unstoppable - 1412
ripdog - 1394
Nicholasp27 - 1392
hobbes9324 - 1338
Tilted - 1238
Melkerson - 1175
Deuce - 1121
m_reed05 - 1111
JordanIB - 1101
Sabo - 1099
AOC - 1089
iron81 - 1087
Chippa58 - 1085
fidgetUK - 1080
Fossilkid93 - 1024
SirOsis - 1023
Will1530 - 1014
bobman0330 - 1010
pvn - 980
Pauwl - 969
TheHip41 - 953
IrishRunner - 940
feedthabeast - 936
sriracha - 903
jerry - 901
MasterofthePwn - 892
MysteryConman - 872
nobody - 822
Aofrantic - 812
poopypants - 795
Kep - 775
00cooler00 - 766
anachronistic - 760
Nononocantsleep - 732
GermanGuy - 729
Preet_Bharara - 723
SwankyWilder - 710
kerowo - 698
Lostrich - 696
whosnext - 695
realDonaldTrump - 691
SensiblePerson - 683
chupacabre - 648
Twist - 638
TheNewT50 - 611
olink - 590
TJ_Eckleburg12 - 588
Supwithbates - 562
miliboo - 552
hey_you - 551
RegretS - 543
Ikioi - 518
Bryce - 509
Canada - 507
d2_e4 - 499
eeAWW - 484
atrupar - 483
BillHaywood - 481
R.C - 463
churchill - 458
MaxCut - 455
Koss - 450
tomrh3 - 449
Soulman - 435
amead - 426
d10 - 424
DUCY - 419
NhlNut - 411
alex - 410
MikeLikesOrgies - 405
ddale8 - 399
ElSapo - 393
Nozetradamus - 391
dbvm - 386
LodenPants - 384
Cactus - 379
Sean - 360
Hired_Goons - 342
FuncrusherPlus - 334
Superleeds - 325
bigt2k4 - 315
JonnyA - 309
Spinetta - 298
vaya1 - 296
outdrawed - 290
joltinjake - 285
gman42 - 276
Sogge - 238
Narrator - 238
EmpireMan - 233
Krayz - 225
von_Internet - 223
LongtimeLurker - 214
lovemuffin - 213
L.Washington - 212
Habsfan09 - 208
TimBuktuuf - 207
MakeHaste - 205
mukdukaluk - 200
corvette24 - 197
darksideofthewall - 196
suzzers_ghost - 186
Surf - 186
Loading.000 - 184
Slighted - 182
davmcg - 171
JimHammer - 170
CaffeineNeeded - 168
JackBando - 157
MonsterJMcGee - 154
klingbard - 150
Dutch101 - 148
Guillotine - 145
Catastrophe - 138
wiper - 137
SPIFF - 137
bbb7979 - 134
edc5036 - 125
Theorangone - 122
PabloHoney - 120
brons1 - 119
KSR - 112
Boardgamer - 111
Arbytoras - 109
McLovin - 109
rockfsh - 109
DudeImBetter - 107
Mendoza - 106
dadbud - 105
dogsballs - 104
TrollyWantACracker - 103
Kennywawa - 101
vincent - 97
monetary_expert - 96
DrModern - 96
anon - 96
Formula72 - 95
Cornboy - 91
ThirdAndChancellor - 88
proudfather - 88
Feltstein - 87
fluff - 87
sumey - 79
Tych - 76
Effen - 76
EpicWestern - 75
baddis - 75
runout - 74
SteveHarvey - 74
WAR - 73
PapaSmurf - 72
HamishMcBagpipe - 72
Hallia - 71
dreamcrusher28 - 67
badpostingdog - 66
GoingViral - 65
SJCX - 65
PaulMcSwizzle - 59
goofball - 58
m_hood115 - 56
Inso0 - 54
ThisGuy - 54
Narrator_Voice - 49
Urasofty - 49
bowens - 47
ParlaySlow - 46
BestOf - 44
KingTaxLV - 43
Hoaya - 42
john_smith - 41
limitguy - 40
thebeercow - 38
Tiptopdaddy - 36
CashComplex - 36
Caliban - 33
fjbourne - 33
Twadds - 31
BadPokerAnalogy - 30
plexiq - 29
that_pope - 28
oscark - 28
Dudd - 27
Jake7777 - 27
cilldroichid - 27
David_Sklansky - 26
Alchemist - 25
danby - 25
JBrosBoss - 24
Quartermaster - 24
Txdome - 23
Uethym - 23
patron - 23
dinopoker - 23
aceforbrains - 22
TempletonFearrariIII - 21
ing - 21
Buddha - 21
Face_Eating_Leopard - 21
MikeHoncho - 20
Bro - 20
NYTimes - 19
Beluga - 18
russonafarm - 17
zaah1 - 17
DavidS - 16
Needle - 15
SeattleLou - 15
ctr123 - 14
vaya - 14
defnotJ - 14
Meraxes - 13
la2sb91 - 13
Psithurism - 13
badpostingcat - 13
Triceratops - 12
Heritagenothate - 12
WesleyC - 12
LuckyLuke01 - 11
Triceracops - 11
ChipsAhoy - 11
Galerider - 10
Face_Eating_Leopord - 10
goreo - 10
Thin_Slicing_Fan - 10
RubbishCards - 10
DTD - 10
Bobnewton - 10
GooseHinson - 10
UNCLECLIMAX - 9
extrafox - 9
freddbird - 9
Incorporeal - 9
PokerBandito - 9
VeryJosie - 8
BUIDS - 8
masonstaint - 8
Mullen - 7
hemstock - 7
JiveLady - 7
anatta - 7
mousemat - 7
Tortuous - 7
GuyIncognito - 6
craptor - 6
breakin - 6
Vajennasguy - 6
Face_Eating_Leapord - 6
UAW - 6
Charlie - 5
FARGOpoker - 5
CS04 - 4
arkman - 4
LoonsAndLFC - 4
Top_Dog - 4
emmpee - 3
beyeond - 3
synapse - 3
pueblo - 3
bode - 3
Tut - 3
SLP - 3
blackize - 3
Montecore - 3
counterspell - 3
admin - 3
anonymous - 2
clubsoda - 2
nyc - 2
onelifetotilt - 2
anonymous1 - 2
jjshabado - 2
Feldman - 2
DuecePounder - 1
mindtrixx - 1
CounterpointCritic - 1
Fingerspitzengefuehl - 1

What graphing tool was used in the OP? I can compile some fun data. Or someone else can take a crack at it. The visualization of this stuff isn’t really my strong suit.

6 Likes

I think likes/post was one graph previously put up that was interesting. Although I assume Riverman runs away with that also.

2 Likes

yea riverman’s ratio is nearly 3.0 likes/posts made. Absolutely absurd especially considering his volume is pretty high too. Namath struck me as also being pretty high up there. I’ll work on that one.

We can also get this data by year, by month, by week, by day, just gotta change the “period” param in the url. I think it would be fun to post weekly stats.

2 Likes

Agreed. Might also keep people thinking about it often enough to come up with some fun ideas for how to look at the data.

1 Like

Lol and I thought I was doing pretty good at better than 1 like/post

writing python script right now to get that data. It’s really relaxing writing sloppy code and having it not matter at all.

4 Likes

Man I hope I’ve retained the top spot. It was the crowning achievement of my existence!

5 Likes

Well sure, but there have also been about eight million remakes of Robin Hood. Most of them aren’t good. It’s in the delivery, but more than that, the whole package. I am most often responding not to Riverman’s point but his style when making that point. Honestly, he very rarely has anything new to say that isn’t obvious, but he’s got his finger on how to get people to engage.

1 Like

Looking forward to seeing some data and workshopping potential accounts of possible results to explain why mine make me cool somehow.

5 Likes

Riverman is hilarious and smart, but I also think that someone with a lot of likes now will have even more in the future because people actually read those posts. He also gets right to the point rather than meandering on, so people don’t just scroll past.

3 Likes

.

14 Likes

Here is a breakdown of likes per post, ordered from least to greatest. Minimum of 50 posts. Very interesting stuff in here. I find it hilarious that RealDonaldTrump is one of the most prolific posters on the site and has one of the lowest likes per post. I also find it hilarious that heritagenothate is rock bottom (by a good margin).

The people at the topic of the pack surprised me!

Username                     Likes/Post   Number of Posts
Heritagenothate                0.017        689
Triceratops                    0.046        262
atrupar                        0.096       5020
realDonaldTrump                0.114       6052
ddale8                         0.115       3471
danby                          0.214        117
Inso0                          0.223        242
anachronistic                  0.305       2491
PabloHoney                     0.376        319
nunnehi                        0.436       4373
Cactus                         0.463        818
limitguy                       0.471         85
churchill                      0.483        949
dogsballs                      0.502        207
zarapochka                     0.554       2781
bbb7979                        0.565        237
AOC                            0.578       1883
Melkerson                      0.581       2024
mukdukaluk                     0.593        337
Sean                           0.621        580
Feltstein                      0.621        140
Formula72                      0.633        150
MikeLikesOrgies                0.660        614
wheatrich                      0.661       3120
EpicWestern                    0.688        109
Rivaldo                        0.688       3248
Vict0ar                        0.692       3022
kerowo                         0.695       1005
DodgerIrish                    0.712       2076
brons1                         0.713        167
boredsocial                    0.723       5114
NhlNut                         0.724        568
alex                           0.728        563
clovis8                        0.737       5639
nobody                         0.745       1103
Habsfan09                      0.748        278
superuberbob                   0.751       5163
ParlaySlow                     0.754         61
R.C                            0.767        604
bigt2k4                        0.782        403
FuncrusherPlus                 0.782        427
iron81                         0.784       1386
jalfrezi                       0.791       5293
McLovin                        0.807        135
CaffeineNeeded                 0.812        207
ElSapo                         0.824        477
JonnyA                         0.828        373
NotBruceZ                      0.833       4611
Sabo                           0.850       1293
marty                          0.854       2396
RegretS                        0.870        624
Dutch101                       0.886        167
Aofrantic                      0.890        912
CanadaMatt3004                 0.901       4644
Smacc_25                       0.908      10949
SenorKeeed                     0.947       3116
d10                            0.955        444
Marksman                       0.958       7647
olink                          0.959        615
Chippa58                       0.962       1128
KSR                            0.966        116
jmakin                         0.975       2407
anon                           0.980         98
Jbro                           0.984       3972
lovemuffin                     0.986        216
Loading.000                    0.989        186
jerry                          0.990        910
microbet                       1.007      11344
davmcg                         1.018        168
eeAWW                          1.025        472
Nicholasp27                    1.031       1350
Bryce                          1.037        491
DUCY                           1.040        403
Thin_Slicing                   1.041       1394
Superleeds                     1.048        310
cuserounder                    1.051       8707
L.Washington                   1.055        201
suzzer99                       1.055       8551
d2_e4                          1.073        465
ThirdAndChancellor             1.073         82
corvette24                     1.082        182
MasterofthePwn                 1.083        824
prana                          1.093       1507
dadbud                         1.094         96
dreamcrusher28                 1.098         61
Chuckleslovakian               1.103       1634
monetary_expert                1.103         87
King_of_NY                     1.108       1579
bobman0330                     1.116        905
gman42                         1.127        245
Goebs80                        1.127       2322
sumey                          1.129         70
mjiggy                         1.139       1278
Slighted                       1.152        158
cassette                       1.154       2885
hey_you                        1.158        476
Crunchyblack                   1.184       1304
LouisCyphre                    1.198       2473
wiper                          1.202        114
wirelessgrinder                1.207       2284
Mendoza                        1.218         87
Namath                         1.221       5666
ggoreo                         1.223       4888
jman220                        1.226       1952
MakeHaste                      1.228        167
MattyLice                      1.231       2630
All-InFlynn                    1.233       2293
pyatnitski                     1.235       1510
SensiblePerson                 1.253        545
Hired_Goons                    1.257        272
Canada                         1.261        402
Lawnmower_Man                  1.262       2344
Supwithbates                   1.292        435
smrk4                          1.293       2767
Fossilkid93                    1.299        788
m_reed05                       1.313        846
Yuv                            1.322       1508
00cooler00                     1.323        579
Kep                            1.334        581
LodenPants                     1.347        285
feedthabeast                   1.357        690
Cornboy                        1.358         67
ripdog                         1.382       1009
DrChesspain                    1.385       1134
Deuce                          1.405        798
JackBando                      1.414        111
simplicitus                    1.423       3214
WAR                            1.431         51
ViridianDreams                 1.434       1801
MonsterJMcGee                  1.439        107
grue                           1.445       1106
Twist                          1.450        440
chupacabre                     1.453        446
RiskyFlush                     1.453      10179
6ix                            1.463       2914
outdrawed                      1.465        198
Danspartan                     1.474       3207
TrueNorth32                    1.474       1486
DrModern                       1.477         65
MaxCut                         1.477        308
Trolly                         1.485       7419
Rexx                           1.492       1396
Arbytoras                      1.493         73
Devil                          1.497       1554
TheNewT50                      1.509        405
goofyballer                    1.510       2471
Rugby                          1.521        941
TheHip41                       1.522        626
Surf                           1.525        122
suzzers_ghost                  1.537        121
nonfiction                     1.539       1067
Theorangone                    1.564         78
ChrisV                         1.566       2990
Nozetradamus                   1.583        247
JordanIB                       1.586        694
mosdef                         1.590       3178
econophile                     1.600       1100
Spinetta                       1.602        186
zikzak                         1.619       4068
fidgetUK                       1.619        667
Watevs                         1.620        902
MichaelDavis                   1.620       1749
dbvm                           1.622        238
meb                            1.631       1050
oneeyedtripping                1.643       1721
whosnext                       1.643        423
Pauwl                          1.648        588
eyebooger                      1.668       3315
WichitaDM                      1.682       4189
Bigoldnit                      1.691       1022
kre8tive                       1.691       5223
AllTheCheese                   1.715        843
catfacemeowmers                1.716       1906
champ                          1.724       1116
StimAbuser                     1.726       2118
JimHammer                      1.735         98
skydiver8                      1.736       3657
Koss                           1.737        259
SirOsis                        1.764        580
StrontiumDog                   1.780       1312
tomrh3                         1.796        250
miliboo                        1.798        307
otatop                         1.840       2528
Huehuecoyotl                   1.854        828
MrWookie                       1.861       2193
Mr_Unstoppable                 1.865        757
vincent                        1.865         52
tabbaker                       1.871       2116
MysteryConman                  1.879        464
spidercrab                     1.890       1072
joltinjake                     1.900        150
seities                        1.901       1063
SPIFF                          1.903         72
Tilted                         1.919        645
darksideofthewall              1.941        101
Ikioi                          1.955        265
Guillotine                     1.959         74
Sogge                          1.983        120
vaya1                          1.987        149
MimosaDef                      1.995        730
GermanGuy                      2.003        364
dlk9s                          2.013       1963
hokie                          2.050       2070
amead                          2.068        206
beetlejuice                    2.113       5382
imjosh                         2.118       1444
Catastrophe                    2.123         65
rockfsh                        2.137         51
SwankyWilder                   2.191        324
hobbes9324                     2.201        608
TheDuker                       2.212       1121
Boardgamer                     2.220         50
klingbard                      2.239         67
PocketChads                    2.244       1339
Krayz                          2.250        100
JohnnyTruant                   2.290       5411
von_Internet                   2.299         97
LFS                            2.311       1378
sriracha                       2.321        389
Lostrich                       2.351        296
Coasterbrad                    2.480       1484
jwax13                         2.616        937
IrishRunner                    2.633        357
Riverman                       2.637       6714
pvn                            2.700        363
BillHaywood                    2.749        175
geewhysee                      2.829       1252
TimBuktuuf                     2.836         73
Nononocantsleep                2.837        258
Fatboy8                        3.043        773
Soulman                        3.085        141
Will1530                       3.292        308
EmpireMan                      3.758         62
poopypants                     5.000        159
TJ_Eckleburg12                 8.282         71
Preet_Bharara                  9.037         80
11 Likes