<center><img src="https://ipfs.busy.org/ipfs/QmXJhVPswQTmrxHTmBgrP6niN7VegqAwiad7eoVuWfot7N">
</center>
***
<center><sup>Visit https://flags.dpoll.xyz to see it live</sup></center>
### Backstory
***

HF21 increased the overall downvote ratio in the network. However, we don't have the right tools to track the downvotes. Originally, @transisto asked a similar interface and I thought it should be considerably easy with [Hivemind](https://github.com/steemit.hivemind).

Even though Hivemind doesn't store the negative rshares in a straight forward column in the posts table, there is something we can use for ordering: **[flag_weight](https://github.com/steemit/hivemind/blob/300d5384c2f15229419cd33b044ad7440d69b83a/hive/utils/post.py#L162)**

```
# take negative rshares, divide by 2, truncate 10 digits (plus neg sign),
#   and count digits. creates a cheap log10, stake-based flag weight.
#   result: 1 = approx $400 of downvoting stake; 2 = $4,000; etc
#  flag_weight = max((len(str(neg_rshares / 2)) - 11, 0))
```
***

Seems like it's used by Condenser in the past but it also lets you order the posts by negative rshares in an indirect way. 

So a simple query like this:
```
"SELECT * FROM hive_posts_cache WHERE is_paidout=False and total_votes != up_votes and created_at > now() - interval '1 week' ORDER BY flag_weight DESC LIMIT 500;")
```
***

gets the all active posts, and orders by its flag weight and limits the result set to 500 rows. From that point, it's possible to traverse the "votes" field of the post table (CSV string) and calculate the rshares for each post.

Anyways, let me know if the interface is helpful in any way. I'll open source it once I settle things up. It's basically a single page Flask-app built in two hours, atm. Feel free to shoot in the comments for potential feature ideas. (Result set is limited to 500 rows to keep the page generation time fast.)

👍 ahmeterbay, bulent1976, stmdev, nancybriti, cunigarro, amahovac93, backinblackdevil, emrebeyler, maximize, jacekw, alexis555, garrettwallace, shaunmza, chorock, muratkbesiroglu, isnochys, bilimkurgu, busy.pay, kanrat, thomasthewolf, evilest-fiend, not-a-bird, mercadosaway, gtg, joythewanderer, etherpunk, sam99, edicted, david-grant, elchin, ydavgonzalez, sereze, tyramisoux, murattatar, gokos, aydant, tinowhale, samedb, jumbot, baycan, coinmeria, agememnon, ruh, hayirhah, fromhell2sky, unforgettable, hahajin, intelligencer, berkerpeksag, firatozbek, lastozgur, muradovv, tipitip, transisto, felixxx, ahmetmertugrul, ruel.cedeno, forkonti, googletr, tdogvoid, turkolog, ataturk, seanlloyd, decebal2dac, senseofhumor, malay11, uzerebru, uzercanan, opinizeunltd, cardboard, cfminer, steemitqa, aditus, mcfarhat, whatsup, b00m, disregardfiat, missk, steemfeed, waphilip, murdermystery, roundhere, adoptaminnow, edb, d00k13, masterthematrix, da-dawn, bitshares-r-us, we-are-oceania, howo, hope-on-fire, mytechtrail, we-are-asia, aggroed, thekittygirl, leongkhan, ausbitbank, asgarth, sambillingham, kargul09, maarnio, jaydih, kyju, scorer, haejin, ranchorelaxo, roelandp, talaxy, mruniverse, thefactfactory, cryptonewsblog, sacrumlux, jonnislav, kinglui, asena, jabulai, ipekhanim, cengizhan, timucin, tengribizmenen, samanthabarolli, der-mysteryblog, ravenruis, pennsif, steevc, spectrumecons, bashadow, jacobtothe, slobberchops, kryptonia, heimindanger, timcliff, witnessbot, steem.observer, frasier, promobot, yury-vas, barton26, arcange, raphaelle, tattoodjay, drakos, ozchartart, z8teyb289qav9z, llfarms, nateaguila, acidyo, zer0hedge, steem.lol, finprep, lightproject, dzivenu, pladozero, bigbraincciuto, crypto-wisdom, assasin, mrix, weberh8, musicfromsoul, sanja-cash, scorzmania, nashvegas, lrd, rampagejr, hbhades, blue-pencil, sawyn, ahmadmanga, husaini, derosnec, imp.unity, alibaba987, frsvp, altruisticbot, saintopic, astrizak, seyiodus, zapzap, gamma00, sidwaterman, eitja, ol-crazy-eyes, wisher, careassaktart, loic.ronsse, anarcist69, sidp715, r1s2g3, kisom1, bekkababy, fermion, oneshot, sancti, xyzashu, akbarbadsha, rmsbodybuilding, echowhale, saadmehmood, micros2411, toka, steem-lagos, myklovenotwar, armageddonparty, sirgun, mdmostofa, shafay, truthtrader, shawnvanderveer, gheghenrv, ederaleng, phlatattak, ivar1aldana, see5staar, iobates, devrajsinghrawat, diana.catherine, fetch, jumpmaster, riezky, steembusiness, grooming, bitcoinshirtz, memesplease, meher04, anekdotes, mahassan, preferansist, pharm.steemit, randyw, beesteem, pangur-ban, kult300, welcometonepal, ankapolo, echosupport, meninblock, julietisrael, gijoge, thephotographers, kentzz001, zemiatin, steemitbingo, dora.dora, fucktime, ninaflowers, freetousesounds, szabolcs, morocroft, drifter1, theia7, park.bom, steemmaster, pickoum, misomaniac, nirob, donzet, hooiyewlim, ahmedjadan, cryptoprofessor, moneyroad, ragnarokdel, bayarau, fede93g, thehoneys, fatema105, malos10, devilsdad, insteem, lupo, steemplayroom, steemql, jiminykricket, touristpk, rishi556, jansher, zipsardinia, ullikume, cristinamoronta, realblockchain, samotonakatoshi, nrg, th3voter, fbslo, khussan, ajanphoto, samboy, amirtheawesome1, zaxan, rashkin.dima, mycryd, jennwyant, dragraff, eroma, garylachance, dream.trip, whitedynasty, tudors, dipom98, cryptomurph, cleverclogs, phabulu, promote.helper, hursh, moneyinfant, samve, leyargoz, eirik, heyimsnuffles, procaptainjoe, fortunex, vishalsingh4997, lifecruiser, rzs, tyzzzz, pipiczech, tj4real, dimarss, callme, onlineprds, buildawhale, uplus, colinbrazendale, heartbeat, gamemusic, steemengines, tammyfit95, xiaoyinzi, unversehrt, yensesa, grintsch, anyadan, sola3097, djoi, nguoiviet, safedeposit, aafrin, heaterville, navx, naijaboost, gbenga, blessing97, lisamalletart, drsinmongwong, goodway, bear8photo, blto83, gaminghd, harryp3, omersurer, savagebits, blessedman939, giddyupngo, dmitryorelopt, gainer, gary911, pardeepkumar, thenaller, errajesh, detlef-s, mrelliwood, spykakos, nba05, masterroshi, movement19, erik-lopez, gammagooblin, jeronimorubio, armshippie, gringo211985, beers, ety001, ribbitingscience, joshua-golbuu, bigapplebo, maverickinvictus, rehanji50, shakilkhan, biffybirdcam, jasimg, stugalaxy, alexko-steemit, artoftherhyme, vandrei.razvan, jozef230, cryptoeater, kassixo, coffeelovers, wig319, robi, knackart, dhrms, gisi, masummim50, armadillocreek, kabolo, kouloumos, linnyplant, kookmin, marty-art, beauknows, silverstackeruk, steemnews-fr, aperterikk, makhzar, bestone, nzpriya, hannesl, earthnation, dickdeepdog, akshaykumar12257, mahtabansari370, theprism, stewsak, maurocostarica, md3, randumb, zoltarian, believeme, midnight-snack, layra, maykolcontreras, idas4you, votebank, kevmcc, thesimpson, miketr, seckorama, rantar, lyubovbar, charlesx, deadzy, erodedthoughts, adenijiadeshina, aniestudio, springlining, tezcatlipoka, honeybee, nil1511, amylee, michaelleeld, maysun, twinkledrop, trendylife, sherrychan, thecatfiles, serenawu, ashely056, helgachen, allanlong, wisemansays, brianlam, noelboensel, jawnz, adzrobinson, jerre-nl, knightwarrior, whentone, oredebby, machnbirdsparo, gypsyfortune, stiant, ninolatino, petrescue, bigmike420, ladysalsa, hdmed, enjgold, morwhale, morwhaleplus, zidfabour, abdoramon, marofat, morwhalebox, abdohrich, morwhalered, headbreaker, borntobe, leesinn, wriler, aminamarchalik, mardibachir, najat, clm, anasjen, bamomed, bensaid, salaho, safro, majjido, morwhalelive, morwhaletrail, mryana, steemwild, feedme, nwijoo, nadiirsafaa, morwhaletip, morwhaletips, rewardshare, rewardsshare, katchoro, morwhalear, morwhalefr, bnonawalter, jurdan, sarmitirajaa, wardin, ganzo, raghifjamila, solosteem, sbdup, malihamoussa, anoirelgama, elhajjasaidia, sakanijalal, olivaw, steemorocco, theredshark, wahedkado, zakdour, atfkamal, morwhalebonus, akirano, najmaoui, makirano, morwhalelife, blamer, teammorocco, hachmanisabir, katty-milk, agentsql, steemox, zouhalsana, ramanisafwan, moroccoteam, hdmed.dev, kamalamezwar, mydicebot, folke, darkmrmystic, jbp, code91, amikphoto, taldor, chronogn, hossainbd, lizette, smileyinvest, millionfist, zainalbakri, nadilchairi, ssh3158, jacopo.eth, goforthegoldy, uncommonriad, albertjester, spencercoffman, chanych85, iqbaladan, khalifaimaman, anech512, farq, snrm, unplanned, rimicane, mrlazy, zoef, consciousangel7, lokilaufeyson, robertomarinello, engchitchat, ligit, sparkofphoenix, amanjain2k, earlmonk, rebeccabe, ifartrainbows, sakhone, scrmcduck, infinitelearning, aghunter, gan.bot, funder, joele, fmd, spoylerbg, cryptofarmer, fatkat, yhoh, steemisthebest, sustainablyyours, sameer777, gingerninja, dropahead, hellroute, epic-fail, honolulu, thecastle, jjcali, walkinharmony, skenan, fakj94, sjennon, safehan, sagarthukral, hvr, airmatti, goge-vandire, ribalinux, soufianechakrouf, oluwoleolaide, aibolit66, spirits4you, taifkhan, heidi71, stempede, spaghettiscience, francis.melville, steemhelpinghand, prasanna, investyourvote, gwilberiol, theprempredictor, eztechwin, hasmez, bunnychum, anacristinasilva, sensigo, calisay, pearlymarly705, cryptolife1, atmospheric-haze, andrewgenaille, federacion45, mikemoi, mattuk, machv, kryptoblogger, jiangzemin, honeychum, dunite, calimeatwagon, jrungi, binislam0, overmedia, thisbejake, naruitchi, aceaeterna, gamesjoyce, tricki, ajaxalot, r3ap3r, melissakellie, mynaturebody, smolalit, patelsneh96, jorgedr0id, qberry, bscrypto, florian-glechner, soteyapanbot, steinhammer, michaelmorcos, rawpride, senseibabs, bil.prag, hatoto, mohamed-shebl, dj123, tobetada, soufiani, luckythebard, miroslavrc, wolfje, sarasate, luigo, tazbaz, heathergirl, stefanymathias, ange.nkuru, whatsyourname, emekasegun, bennie-13, johnycrypto, neneandy, armadilloman, teardrops, sobluecloud, rwilday, eyemon1, gogriffs, depot69, habibb, jumaidafajar, bitsignal, helix, turtle-trader, juliank, trenz, quicksnake, steemgg, whd, damla, jstajok, r351574nc3, takosdiary, coffeex, bassuniverse, katteasis, krischy, ivan-perez-anies, theb0red1, zaragast, teungkulik, ansharphoto, future24, foxon, taliakerch, mxzn, mysupport, kyuubi, sanevys, inciter, ccoin, sebhofmann, anikaa, najoh, upvotewhale, teukumukhlis, sozdemir, solips, zipporah, janusface, canadianbacon, eqko, wakeupjohnny, moisesmcardona, foreveraverage, travoved, achim86, i-d, towfique, sourovafrin, shrazi, forykw, vinzie1, briggsy, ricbo, sandyspictures, incarn, nebuladream, misbitcap, awesomegames007, steemit-turkey, turkish-trail, spawnband, hafiz34, indigoocean, dineroconopcion, djkrad, joseforo, itzunknown, azwarrangkuti, ubikalo, danieelab, fsegredo1, osmi, wihol89, better-life-tips, zonabitcoin, alexanderlara, aballarde53, alejandroortega, carlospzo, dgcarlosleon, bibiuz, oral23, bekirsolak, jpphotography, mulletwang, leslierevales, dvf, birdinc, faizan-ashraf, jatinhota, nicestbot, boxmining, rajib2k5, steemmeupscotty, vladimir-simovic, deandaniel, iui, yeaho, aro.steem, lordjames, veritasvav, slider2990, rivalzzz, elena-singer, jaforce, rynergy, codingdefined, elevator09, supersoju, braxton101, starzy, dexter-k, walhallo777, nicolemoker, thedarkhorse, owain82220, chbartist, trueonot, s3rg3, brandonp, liuye, carlpei, pbgreenpoint, ngc, bumper, globetrottergcc, zappluder, madtv, igster, shadowspub, bobsrepair, steem.services, florenceboens, ikrahch, dynamicrypto, tizswa, candyboy, markus.light, ludorum, concorde, shikika, maryfavour, sheuan, betbet, superledger, cindycam, roseri, lasocia, carmenl, minerthreat, ojap02, swissclive, roguewriter, ezravandi, accelerator, headcrypto, aamirijaz, angelinafx, bobdos, freshfund, aboutcoolscience, nasgu, buttcoins, robmolecule, grampo, rndness222, ourdailyboard, imisstheoldkanye, roomservice, carilinger, clio, lays, robinhaney, tradingideas, warjar, ozphil, bunnypuncher, laputis, xiaoliang, johnquake, jkramer, violetmed, slickwilly, rigaronib, pjau, lstack, ediya, makinstuff, wwwfernand, avhyaceulip, everydaycoach, maxg, immanuel94, abwasserrohr, skyroad, tincho, crescendoofpeace, flyerchen, trentox, make-a-whale, discovereurovelo, sc5tt, cheftony, powerupsteem, carrinm, sorin.cristescu, chitty, smy, meno, hasoon, steemjet, gascap9000, znaffe, camerongray, podnikatel, jonny-clearwater, profit-shooter, bestbroplayer, roncoejr, lafona5, d-pend, foruni73, pi50000, pi1000, deisip67, polaleye50, apoloo1, bitcoinflood, franklinjgc, lamorena, gunthertopp, mcoinz79, unchainedio, intrepidphotos, kingscrown, sock, josephcraig289, pozitivityspace, kingsmind, pboc, salma.ali, dexpartacus, tuoficinavirtual, samlee2018, shahabudin, boatymcboatface, theshell, igl00, bigdaddy, magicinvesting, mindstabber, dan-bn, jdevora, beeridiculous, silversteem, darthnava, doodleman, dancingwolves, mommydays, rokhani, freecrypto, arnel, cryptorg, recenzent, yoo1900, organduo, ai-channel, organplaying, queenmountain, cryptomeeks, cryptofuwealth, gutzygwin, enm1, jodipamungkas, jcsteem, eathekaos, boddhisattva, matt-a, rubenalexander, seajai, warrensteem, incomepal, adrianbucks, erikkun28, aburashed, scoora82, mgzayyar, wishmaiden, minnowvotes, booster, djennyfloro, boomerang, ticopurelife, drillith, bue, slowwalker, oldstone, wisdomandjustice, mamqmuqit, rombtc, andreasgrubhofer, coinchaos, pastzam, binkyprod, anthonyadavisii,