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
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
author | post | votes | pending payout value |
---|---|---|---|
stellabelle | 2 | 429 | 103,45 |
daltono | 6 | 122 | 79,25 |
kalemandra | 3 | 113 | 60,188 |
alexandravart | 12 | 463 | 50,021 |
mimulusamsterdam | 2 | 32 | 29,172 |
slothicorn | 6 | 368 | 27,232 |
ivanusaur | 4 | 108 | 26,932 |
federacion45 | 16 | 206 | 23,303 |
bym | 15 | 168 | 21,628 |
jnmarteau | 17 | 282 | 21,626 |
drawingly | 18 | 597 | 20,419 |
fabiyamada | 9 | 281 | 20,299 |
trishy | 7 | 168 | 17,925 |
ediah | 9 | 251 | 17,119 |
inksanity | 3 | 19 | 17,051 |
jepoyasinas | 10 | 226 | 14,526 |
khansa | 13 | 181 | 14,228 |
matytan | 19 | 280 | 12,606 |
richforever | 1 | 24 | 11,844 |
iqbalhood | 5 | 127 | 11,772 |
trangpu | 6 | 45 | 11,567 |
anonimous | 1 | 16 | 11,377 |
cryptocomic | 4 | 60 | 11,203 |
marpa | 13 | 527 | 10,622 |
debart | 21 | 259 | 8,973 |
mfestra | 2 | 35 | 8,724 |
photoquest | 6 | 43 | 8,54 |
rayne122 | 2 | 110 | 8,077 |
bryanlornemez | 3 | 94 | 7,931 |
journeyu | 5 | 73 | 7,661 |
summary | 240 | 5707 | 695,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.
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
the account that bought the vote in the #slothicorn tag has closed the chance for another artist to appear at the top
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You are right @khansa
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank you @ghulammujtaba i will check my DM
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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 :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank you @pbock ..... i am still learning how to make useful analysis for everything ...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit