Top 30 Writer Listings In SLOTHICORN Based on Pending Payout Value

in #slothicorn7 years ago (edited)

In the third study of statistics 2018 for my post, I will look at the numbers for taging slothicorn. Taging slothicorn is one of the taging on the steemit platform that has a lot of art-related content and crypto art.

on this occasion I want to display the figures I get by using steem blockchain database from Steem Sql developed by @arcange. this article I also appreciate to @paulag who has written in the field of analysis and teach many things to many people in online course site that you can see here

https://www.udemy.com/

the following I will show the data in table that I get through the database blockchain in Steem sql.

LIST OF 30 AUTHORS IN SLOTHICORN TAG DURING THE LAST 30 DAYS

authorpostvotespending payout value
stellabelle2429103,45
daltono612279,25
kalemandra311360,188
alexandravart1246350,021
mimulusamsterdam23229,172
slothicorn636827,232
ivanusaur410826,932
federacion451620623,303
bym1516821,628
jnmarteau1728221,626
drawingly1859720,419
fabiyamada928120,299
trishy716817,925
ediah925117,119
inksanity31917,051
jepoyasinas1022614,526
khansa1318114,228
matytan1928012,606
richforever12411,844
iqbalhood512711,772
trangpu64511,567
anonimous11611,377
cryptocomic46011,203
marpa1352710,622
debart212598,973
mfestra2358,724
photoquest6438,54
rayne12221108,077
bryanlornemez3947,931
journeyu5737,661
summary2405707695,266

Based on the above data we can see the composition of the number of post, vote and payment deferred for each of the top 30 authors in the past month.

and we can also see it in the chart that I created with excel as a description of the data above based on the percentage value of each author for each category.

Perinkat Penulis 30 teratas di slothicon .html_001.png

Perinkat Penulis 30 teratas vote slothicorn.html_001.png

Perinkat Penulis 30 teratas panding payout slothicorn.html_001.png

CONCLUSION

of the many posts that go to tagging slothicorn we can see the top 30 writers based on the value of pending payments. in the above data we can also see the number of posts by the top 30 authors as much as 240 posts and get vote number 5707 and overall payment for the top 30 of 695,266 SBD. the average payment for post in the slothicorn tag is 2.89 SBD based on the data of the top 30 authors.

TOOLS

This data is retrieved through the steemsql database using lynqpad personal edition at 03.30am on 03.30.20 at 23:17 (UTC + 07: 00) Bangkok, Hanoi, Jakarta. data processing is done using Microsoft Excel.

select top 30
   author, 
   count(author) as cnt, 
   sum(net_votes) as votes, 
   sum(pending_payout_value) as pending_payout_value 
from 
   Comments 
where 
   title <>'' and 
   dirty = 'False' and  
   category = 'slothicorn' and  
   parent_author = '' and datediff(day, created, GETDATE() between 0 and 30  
group by 
   author 
order by 
   pending_payout_value desc

My Best REGARD @irwanumpal

DQmPonMmcNezsLXCzMvcRpB2tVPK6xwNACo43tGQHEQouKw.png

THANK-YOU-BANNER-IRWAN.gif
download

Sort:  

the account that bought the vote in the #slothicorn tag has closed the chance for another artist to appear at the top

You've received an upvote from @slothicorn! Click Here to Learn More
(@ghulammujtaba)

Superb work @irwanumpal, I have another task for you regarding another report for Slothicorn upvote analysis. Check your DM.

thank you @ghulammujtaba i will check my DM

interesting.

Thanks for the effort you put into this. I'm sure this will be useful, even if just so we can check out the biggest users of the Slothicorn community :)

thank you @pbock ..... i am still learning how to make useful analysis for everything ...