I wrote a short python script to load the e621 database exports and rank the pools by it's posts ( https://gist.github.com/Tony-Goat/2cdabeb4b2ff8c8a7b08ebfdb5111204 ). I did this mostly because I was looking for the real good shit but there wasn't any way to sort the pools by score on the website. So I present to you, the best and the worst of e621 by 3 different ranking systems based on the June 22nd 2023 database export.

Admin, if this isn't the right place for this post, let me know, and I can relocate it.

Top 10 Best Pools by Cumulative Post Score:
1) [126050] Shedding_Inhibitions_-_The_Complete_Series_by_Atrolux https://e621.net/pools/27177
2) [109879] A_Tale_of_Tails_by_Feretta https://e621.net/pools/2912
3) [103182] ashraely_eeveelutions https://e621.net/pools/25047
4) [86443] Oversexed_Evolutions:_The_Comic_(kuroodod) https://e621.net/pools/18153
5) [84082] Pokemon:_Oversexed_Eeveelutions:_The_Comic_(Kuroodod) https://e621.net/pools/7064
6) [73743] Silver_Soul_by_Matemi https://e621.net/pools/11563
7) [73111] "Good"_Parenting_by_Atrolux https://e621.net/pools/21347
8) [70386] A_Night_With_Loona https://e621.net/pools/23886
9) [65979] Exploring_Wanderlust https://e621.net/pools/24007
10) [60287] Under(her)tail_by_TheWill https://e621.net/pools/7416

Top 10 Worst Pools by Cumulative Score:
1) [-1844] Cock_Dogs https://e621.net/pools/17166
2) [-1489] Ankha's_fate_by_e254e https://e621.net/pools/22846
3) [-1459] Everybody_Hates_Anais https://e621.net/pools/25829
4) [-1330] Born_to_be_Alive https://e621.net/pools/15517
5) [-1222] Edible_Sylveon https://e621.net/pools/23386
6) [-886] Zootopia:_Never_Say_Goodbye_-_by_borba https://e621.net/pools/20219
7) [-831] No_Silksong_by_e254e https://e621.net/pools/26667
8) [-803] A_Cute_Eevee_by_e254e https://e621.net/pools/24129
9) [-765] From_Butterflies_to_Monsters https://e621.net/pools/20368
10) [-685] Game_of_Life_by_Zooshi https://e621.net/pools/19130

Top 10 Best Pools by Mean Post Score:
1) [3448.0] Heat_in_the_Savannah_by_Zackary911 https://e621.net/pools/26539
2) [3216.0] Prey_and_Predator_-_Zackary911 https://e621.net/pools/30651
3) [3195.75] Meru_the_succubus_OVA_series_by_SkuddButt https://e621.net/pools/25043
4) [3026.8] LOPUNNY;_THICC_BOOTY_SEX https://e621.net/pools/34162
5) [2916.3333333333335] Succumbing_to_Urges_-_Zackary911 https://e621.net/pools/30687
6) [2846.5] Project_21 https://e621.net/pools/34025
7) [2651.75] Cafe_Date_by_fizzystevie https://e621.net/pools/27514
8) [2544.0] Lil_Red_Ridin'_-_Zackary911 https://e621.net/pools/30686
9) [2503.0] Unnamed_Animation_by_Elicitie https://e621.net/pools/31445
10) [2427.875] Riverside_-_By_Seibrxan https://e621.net/pools/28729

Top 10 Worst Pools by Mean Score:
1) [-244.4] Edible_Sylveon https://e621.net/pools/23386
2) [-222.66666666666666] Isabelle_surviving_NAKED_AND_AFRAID https://e621.net/pools/29001
3) [-162.11111111111111] Everybody_Hates_Anais https://e621.net/pools/25829
4) [-114.71428571428571] A_Cute_Eevee_by_e254e https://e621.net/pools/24129
5) [-103.875] No_Silksong_by_e254e https://e621.net/pools/26667
6) [-96.25] Rouge's_Execution_by_e254e https://e621.net/pools/23385
7) [-87.58823529411765] Ankha's_fate_by_e254e https://e621.net/pools/22846
8) [-78.0] Basketball_with_Lola_Bunny_by_E254e https://e621.net/pools/23448
9) [-72.0] Never_Say_Goodbye:_Extra https://e621.net/pools/25859
10) [-72.0] Gutting_Braixen_by_e254e https://e621.net/pools/25755

Top 10 Best Pools by Median Post Score:
1) [4067] Meru_the_succubus_OVA_series_by_SkuddButt https://e621.net/pools/25043
2) [3714] Heat_in_the_Savannah_by_Zackary911 https://e621.net/pools/26539
3) [3282] Prey_and_Predator_-_Zackary911 https://e621.net/pools/30651
4) [3073] Project_21 https://e621.net/pools/34025
5) [2924] Succumbing_to_Urges_-_Zackary911 https://e621.net/pools/30687
6) [2766] Cafe_Date_by_fizzystevie https://e621.net/pools/27514
7) [2731] LOPUNNY;_THICC_BOOTY_SEX https://e621.net/pools/34162
8) [2593] My_Shy_Human_Boyfriend https://e621.net/pools/21434
9) [2400] Barn_Date_by_Zackary911 https://e621.net/pools/21911
10) [2351] Lil_Red_Ridin'_-_Zackary911 https://e621.net/pools/30686

Top 10 Worst Pools by Median Score:
1) [-239] Edible_Sylveon https://e621.net/pools/23386
2) [-155] Isabelle_surviving_NAKED_AND_AFRAID https://e621.net/pools/29001
3) [-133] A_Cute_Eevee_by_e254e https://e621.net/pools/24129
4) [-129] Everybody_Hates_Anais https://e621.net/pools/25829
5) [-92] Rouge's_Execution_by_e254e https://e621.net/pools/23385
6) [-85] Ankha's_fate_by_e254e https://e621.net/pools/22846
7) [-82] Basketball_with_Lola_Bunny_by_E254e https://e621.net/pools/23448
8) [-80] Patience_Is_Rewarded https://e621.net/pools/34422
9) [-75] No_Silksong_by_e254e https://e621.net/pools/26667
10) [-72] Beastars_cooking_vore_by_e254e https://e621.net/pools/25722

how did you calculate a pools mode?

cutefox123 said:
how did you calculate a pools mode?

It's in the script, I created an array of a pool's post's scores, integer divided the array's length by 2, and used that to get the mode post's score.

I think it's technically more appropriate to use the middle post's score if there's odd posts, and to average the middle two posts if there's even, but I didn't bother to implement that since I wanted some quicker results.

isnt that the median, not the mode? the mode is the most common value, which is why i was confused.
https://en.wikipedia.org/wiki/Median
https://en.wikipedia.org/wiki/Mode_(statistics)

cutefox123 said:
isnt that the median, not the mode? the mode is the most common value, which is why i was confused.
https://en.wikipedia.org/wiki/Median
https://en.wikipedia.org/wiki/Mode_(statistics)

That's what I get for programming on 2 hours of sleep

These results would probably be more interesting if there was some way of filtering out pools which contain only sets of 3-5 individual images. Maybe require a minimum length, or check for the comic tag on the posts? I'd also be interested to see what the lowest-scoring pools not by e254e are.

wat8548 said:
These results would probably be more interesting if there was some way of filtering out pools which contain only sets of 3-5 individual images. Maybe require a minimum length, or check for the comic tag on the posts? I'd also be interested to see what the lowest-scoring pools not by e254e are.

If you know enough Python, on line 12 where it loads the records in from the export, just throw in an if that finds "e254e" in "record["tags"]" and doesn't append those posts to the dictionary. Then, when it constructs the pools dictionary later, it will skip any nonexistent post IDs and throw away the empty pools, leaving you with only pools that don't have his posts in it. A similar process should work for any other tag as well.

I might improve the script this weekend to let you search the database like you'd search with the search bar, do some cleanup and optimization, and submit it to the tools section.