stats

The Something Awful Forums > Archives > Comedy Goldmine > The Goodmine > stats

«‹›3 »

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

http://awful.fyi/

will add more pages... some time.

BurgerQuest fucked around with this message at 13:21 on Oct 2, 2019

# ¿ Sep 29, 2019 11:28

Adbot: ADBOT LOVES YOU

# ¿ May 21, 2024 14:55

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Yea ok I had some issues so here are the stats for the 190k+ bans

Radium - to be excluded - 5310 permabans

Top 40 sorted by bans since um, around 2005 according to what's on the lepers colony

# ¿ Sep 29, 2019 14:50

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

# ¿ Sep 29, 2019 15:08

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

top 40 spenders

# ¿ Sep 29, 2019 15:32

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Plutonis posted:

I could have used that money to buy Astral Chain and Dragon Quest 11

double shame

# ¿ Sep 29, 2019 15:53

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

yeah i just pulled this from the lepers colony. not sure what other available pages might yield good *stats* without too much effort. There was an admin a while ago who ran some sql queries to get some similar info.

# ¿ Sep 30, 2019 00:28

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

found the old ban/stats thread from 2015

https://forums.somethingawful.com/showthread.php?threadid=3741319#post450082887

code:

MariaDB [test]> SELECT 
 TargetUserName, 
 COUNT(*) * 10 AS wallet_damage 
 FROM lepers WHERE BanType = 'ban' 
 GROUP BY TargetUserName ORDER BY wallet_damage DESC LIMIT 30;
+-----------------------+---------------+
| TargetUserName        | wallet_damage |
+-----------------------+---------------+
| Kingsbury2            |           350 |
| vilepilot             |           310 |
| IzzyFnStradlin        |           290 |
| Kyoon_                |           270 |
| DB_Cooper             |           260 |
| TenementFunster       |           200 |
| Marxux                |           190 |
| Avshalom              |           180 |
| big duck equals goose |           160 |
| Orc-Slayer 6000       |           160 |
| Kyoon__               |           160 |
| Narciss               |           140 |
| quite the fucker      |           130 |
| Jezza                 |           130 |
| A Major Fucker        |           130 |
| Pipe Dreamer          |           130 |
| Zeitgueist            |           120 |
| autopsy-turvey        |           120 |
| Black Baby Goku       |           120 |
| I.N.R.I               |           120 |
| Bum the Sad           |           110 |
| rivetz                |           110 |
| Teabiscuit            |           110 |
| a creepy colon        |           110 |
| WEED LORD             |           110 |
| circ dick soleil      |           110 |
| NULL                  |           110 |
| ArfJason              |           110 |
| M. Discordia          |           110 |
| fishmech              |           100 |
+-----------------------+---------------+

code:

MariaDB [test]> SELECT 
 TargetUserName, 
 COUNT(BanType) AS count, 
 SUM(IF(BanType = 'ban', 1, 0)) AS bans, 
 SUM(IF(BanType = 'probation', 1, 0)) AS `probations`, 
 SUM(IF(BanType = 'permaban', 1, 0)) As permabans 
 FROM lepers GROUP BY TargetUserName ORDER BY count DESC LIMIT 30;
+---------------------+-------+------+------------+-----------+
| TargetUserName      | count | bans | probations | permabans |
+---------------------+-------+------+------------+-----------+
| drilldo squirt      |   216 |    4 |        212 |         0 |
| Big Milton Fan Here |   196 |    2 |        194 |         0 |
| Never Post Again    |   189 |    4 |        185 |         0 |
| I.N.R.I             |   122 |   12 |        110 |         0 |
| TenementFunster     |   104 |   20 |         83 |         1 |
| psyopmonkey         |   101 |    3 |         98 |         0 |
| circ dick soleil    |    96 |   11 |         85 |         0 |
| Black Baby Goku     |    84 |   12 |         71 |         1 |
| TheLovablePlutonis  |    84 |    4 |         80 |         0 |
| Cole                |    81 |    0 |         81 |         0 |
| Surprisingly Dope   |    80 |    6 |         74 |         0 |
| Suicide Sam E.      |    75 |    0 |         74 |         1 |
| Al Borland          |    75 |    2 |         73 |         0 |
| Dr. Gitmo Moneyson  |    73 |    5 |         68 |         0 |
| why the ____ ____   |    69 |    7 |         62 |         0 |
| a Loving Dog        |    69 |    7 |         62 |         0 |
| Iseeyouseemeseeyou  |    67 |    9 |         58 |         0 |
| ANIME MONSTROSITY   |    65 |    2 |         62 |         1 |
| tbp                 |    64 |    8 |         56 |         0 |
| Avshalom            |    64 |   18 |         46 |         0 |
| Grass Effect        |    63 |    0 |         63 |         0 |
| The Taint Reaper    |    62 |    0 |         62 |         0 |
| IzzyFnStradlin      |    60 |   29 |         31 |         0 |
| OMFG PTSD LOL PBUH  |    60 |   10 |         50 |         0 |
| ArfJason            |    60 |   11 |         49 |         0 |
| garbage owl         |    58 |    2 |         56 |         0 |
| El GiNGiS           |    58 |    1 |         57 |         0 |
| Whirlwind Jones     |    58 |    3 |         55 |         0 |
| Breath Ray          |    57 |    4 |         53 |         0 |
| Nonviolent J        |    57 |    8 |         49 |         0 |
+---------------------+-------+------+------------+-----------+

code:

MariaDB [test]> SELECT 
 SUM(x.adj_count) * 10 as ban_profit 
 FROM ( SELECT TargetUserName, COUNT(*) - 1 AS adj_count 
 FROM lepers WHERE BanType = "ban" GROUP BY TargetUserName) AS x\G
*************************** 1. row ***************************
ban_profit: 66400

code:

MariaDB [(none)]> SELECT COUNT(*) AS kyoon_bans
    -> FROM test.lepers
    -> WHERE BanType = 'ban'
    -> AND TargetUserName LIKE 'Kyoon%'
    -> OR TargetUserName IN ('MyFire', 'The 11th Fact', 'The Simple Truth', 'TomJerry', 'VERY LAST DISCIPLE', 'Web of Truth', 'Web-of-Truth', 'gold45revolver')\G
*************************** 1. row ***************************
kyoon_bans: 81

# ¿ Sep 30, 2019 00:45

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

according to the data ralp issued 506 bans, 54 permas and 1065 probes.

BurgerQuest fucked around with this message at 02:59 on Sep 30, 2019

# ¿ Sep 30, 2019 02:52

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

i hosed up the first 2 graphs stop looking at them

# ¿ Sep 30, 2019 02:59

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

you gotta pump those numbers up burt, those are rookie numbers

# ¿ Sep 30, 2019 03:04

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Burt Sexual posted:

They�re bullshit, I�ve permd a statistically significant number of goons. Bar chart is crap as well. Lol @ me and FAU being virtually tied on probes.

# ¿ Sep 30, 2019 03:38

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

i just pulled the tables from lepers colony into a 50mbyte CSV file and then gently caress around in excel

i'm do a word cloud from the ban reasons next.

# ¿ Sep 30, 2019 03:43

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Burt Sexual posted:

E and why isn�t Grindcore in this?

gently caress man i gotta draw lines somewhere, for the graph and table it was >1500 ab/ban/pb/probe activities total, GC is around 1200 something.

# ¿ Sep 30, 2019 03:45

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

excluding some obvious high volume words, here is your word cloud burt for something like 2000 reasons

# ¿ Sep 30, 2019 03:54

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Burt Sexual posted:

You�ve got one probe in ten years, and it was just recently

this is a good stat, nice one.

# ¿ Sep 30, 2019 03:55

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

because i removed like the top 10 words because it is less funny with them. you might say i'm skewing the stats to fit my funnies agenda.

removed words/count

1690 posting
1601 loses
1600 privileges
1600 User
1268 hours
150 thread
150 post
115 days
109 day

# ¿ Sep 30, 2019 04:16

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

In Training posted:

drat could you find the one time "loses" was used outside of the phrase User loses posting privileges

that seems like hard work. so no. maybe next weekend i'll have this out of excel and into some kind of web based interface you can all gently caress around with.

EorayMel posted:

The cursive is kinda hard to read for me, could you redo the word cloud in a more neutral font like arial?

Alternatively, can you find/make a word cloud for the words included in posts themselves that were chosen for ban reasons?

yes. and maybe. I'm not scripting anything yet so filters are very basic. see above.

this is just burts ban reasons btw.

BurgerQuest fucked around with this message at 04:25 on Sep 30, 2019

# ¿ Sep 30, 2019 04:20

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

# ¿ Sep 30, 2019 04:38

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

i'm the

prior
bait

# ¿ Sep 30, 2019 04:50

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Eox posted:

can i get FAUs ban reasons in the shape of goatse, thanks in advance

a very good request

# ¿ Sep 30, 2019 05:08

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

here is another version in 3000x2000 for printing and framing

thanks FactsAreUseless for these kind words

# ¿ Sep 30, 2019 05:19

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

for some reason when cleaning up this dataset, there is like a chapter or two from atlas shrugged embedded in a bunch of blank rows. it rules.

# ¿ Sep 30, 2019 05:49

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

they start really late in the set so that kinda makes sense

# ¿ Sep 30, 2019 06:37

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

fun fact. the most popular day for bannings/probing is monday.

presumably the mods are grump and hungover on mondays or it's just when the mod approval queue gets the most attention.

e. please don't ask me about the order of the graphs, i crashed excel 6 times trying to re-arrange it.

BurgerQuest fucked around with this message at 06:41 on Sep 30, 2019

# ¿ Sep 30, 2019 06:39

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

here are all the collected paragraphs

https://pastebin.com/Mv12fjHD

# ¿ Sep 30, 2019 06:49

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

# ¿ Sep 30, 2019 08:04

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

CAT INTERCEPTOR posted:

Kinda puzzled how sigtrap features so much. He was the moderator of AI and not an Admin as far as I know...?

Plus AI is kinda not that much of a high maintenance area for posters.... unlike our cars.

i think i've cracked this one

# ¿ Sep 30, 2019 08:55

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Party Plane Jones posted:

any chance of showing the average probation length given? Sixers in general have become way more common than in previous years I�d think

A shift from 24 hour to 6 hour bans is pretty obvious around 2013/14. Also notable is the massive increase in probes handed out overall starting around the same time.

Also to note there is not much 04 data and 19 isn't finished yet, hence the pinching at each end.

# ¿ Sep 30, 2019 10:23

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Jeffrey of YOSPOS posted:

Can you figure out which users have spent the most time probated, filtering out the 100,000 hour ones?

erm I think I did this sort of right. I took the top 20 users by probe count first, then turned it into hours. assumed '1 month' probes are 30 days so yeah. could be tweaked.

# ¿ Sep 30, 2019 11:12

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

here's the raw prawn on that table. seems to match up when i check NVJ's 5 page long rap sheet.

# ¿ Sep 30, 2019 11:29

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

I'm going to bed now but leave any requests and I'll give them a shot tomorrow.

# ¿ Sep 30, 2019 12:01

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Yeah maybe, if the forum ID is in the URL for the ban type link. I'll check tomorrow. Otherwise probably not based on the current dataset.

Edit - No it just links to a post ID. I'd have to scrape the pages behind the 160k odd links to get forum info which would take a hell of a long time.

I could do it by moderator though, that might give you enough of a sense of the breakdown per forum.

BurgerQuest fucked around with this message at 13:19 on Sep 30, 2019

# ¿ Sep 30, 2019 13:16

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

No controlling for over laps. I litterally just took the last 2 words from every probe reason and then cleaned that up.

To do that and the rest needs a bit of scripting to generate useful data to graph which I won't have time to work on till next weekend. This is just quick and dirty excel and some web apps for the word clouds

# ¿ Sep 30, 2019 14:21

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

They were melted down to be cast into new mods and admins. Very eco friendly.

# ¿ Sep 30, 2019 14:40

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

we build our internet shitpost superstars real good downunder that's for sure

# ¿ Sep 30, 2019 14:58

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Nurge posted:

I'm super mad about this graph because I have way more than 3 months of probes. Your methodology is flawed and sharkface is a loser.

Sorry Nurge you're totally right, you have 3510 hours / 146.24 days / 4.875 months on probation. I hope we can make peace after this.

One of the problems alluded to before is all the work required to generate many many more columns of useful data, like one that turns the probe reasons into raw hours of probation time. I haven't scripted this yet so it's all manual in excel and filtering by top x users on what's easily available.

# ¿ Sep 30, 2019 23:40

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Yeah that's on my list, I figured first and last probe/ban would be good enough to define their term of service.

I was going to do some tables with a metric like SPD (shits per day) to rank mods by activity for various time periods.

# ¿ Oct 1, 2019 00:32

Adbot: ADBOT LOVES YOU

# ¿ May 21, 2024 14:55

BurgerQuest: Mar 17, 2009; by Jeffrey of YOSPOS

Or peak at the end in their inevitable syphilitic death spiral as they become more and more unhinged by the community backslash due to their increasing totalitarian ways.

Or maybe not, I'm just a numbers guy.

# ¿ Oct 1, 2019 00:38

The Something Awful Forums > Archives > Comedy Goldmine > The Goodmine > stats

«‹›3 »