e-shuushuu 2019-2020 rip with ALL metadata

One of the best purely SFW imageboards e-shuushuu.net already ripped in full (unfiltered, unconverted) releases 2005-2014 380 GB 2014-2015 155 GB partially overlap 2016-2018 189 GB Years ago e-shuushuu was very active, now it lost it's leadership and most of activity, but still the best by image selection.

To complete rips to current sate, this release contains:

• 66.618 images for 2019-2020 (ID 979.402-1.046.967) archived by volumes (3 per month) not filtered, not converted
  • files name contain ID - up_to_3_copyrights ~ up_to_5_characters (up_to_2_artists)
• metadata in text TSV format for all 1.030.423 available post (including 1.000.228 from releases mentioned above and current one)
  • tags by category, fav_count, EXIF info, MD5 etc
  • location info (file name, zip name, path) in torrent's structure
  • and also separately parsed 3.253.443 tags for copyrights, characters and artists
• some scripts for DIY activists
  • python grabber by ID range or list
  • SQLs helpful for processing in database

Q: who are the most favorited characters among e-shuushuu popular ones ?

select d.tag, count(*) cnt, round(avg(favn)) favn
from ess_posts l
join ess_tags d on l.id=d.id and tag_cat=4
group by d.tag
having count(*)>=100
order by 3 desc
fetch first 10 rows only

A: Chocola & Vanilla are

P.S. complete list of arranged releases on rutracker (russian torrents site, you can get magnet there even when unregistered) 2018 43 GB 2017 64 GB 2016 83 GB 2015 90 GB 06.2013-2014 101 GB 06.2011-05.2013 part 1 06.2011-05.2013 part 2 59 + 70 GB 2005-05.2011 216 GB

And art stream goes on 2021-2022, stay tuned !