Analyzing the CCommons.Art in Steem Blockchain
Through my first article in the analysis field I would like to thank @arcange who has developed Steem SQL server and @paulag which has made many writings about analysis and has become a place for me to learn. once again thank you very much
One month ago, exactly on 26 January 2018 at 21:06 my friend @alexandaravart created the first post for this creative commons project via @ccommons.art account . the goal of this extraordinary project is to inspire you to support amazing artists in the arts who use creative commons licenses with sound and resteem, as they give away their work for free, for all of us to use
If you missed the @ ccommons.art entry that made its first Wall of Fame, you can read it here
https://steemit.com/ccommonsart/@ccommons.art/wall-of-fame-creative-commons-content
The purpose of this analysis is to look at the extent of reach and define some voting behavior from @ccommons.art and post within the #creativecommons , #creative-commons ,and #ccommonsart
For this analysis I have taken data from the Steemsql database for 2018 only - you can find the full details of the query after the analysis.
Vote Analysis from @ccommons.art
No of Authors | No of Vote | No of post |
---|---|---|
129 | 536 | 536 |
Let's take a look at this Daily Top Tost and Author in 30 days Charts
Since early 2018 @ccommons.art has selected 536 times for 129 different authors in 536 posts. Value of SBD $ Vote given in the form of direct reward not from vote value. the sound weight given 100%. Total Reward provided by @ccommons.art is $ 122 SBD
Conclusion
The ccommons.art project is ongoing and continues to reward good contributions, as the average post payments for this tag are still lower than Steemit in general. We hope this project will continue to work especially the @globalscool activity implemented by @jnmarteu with @alexandravart
The Data and Query
I used LYNQPAD to connect to the Steemsql database. The SQL query used to get the voting data from Steemsql was
SELECT *
FROM Txvotes (NOLOCK)
WHERE [voter] in ('ccommons.art')
and YEAR (timestamp) = 2018
The query used to get the tranfer was
SELECT * FROM
TxTransfers (NOLOCK)
WHERE [from] in ('ccommons.art'
The query used to get the daily top post and author in 30 days was
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 = 'creativecommons' and
parent_author = '' and datediff (day, created, GETDATE ()) between 0 and 30
group by
author
order by
pending_payout_value desc
After collecting the data from the Sql query, I then used Microsoft excel to carry out calculations and analysis across the tables.
Posted on Utopian.io - Rewarding Open Source Contributors
Your contribution cannot be approved because it is not as informative as other contributions. See the Utopian Rules. Contributions need to be informative and descriptive in order to help readers and developers understand them.
Hi @irwanumpal, welcome to the utopian anlysis section, great to see new contributors here. Unfortunately, your contribution misses a few aspects to be accepted for utopian. Your post is mainly a visualization of the current state and lacks analysis aspects. Several graphs are not mentioned or explained. There are only few conclusions drawn, and those presented cannot be derived from the data you show.
You can contact us on Discord.
[utopian-moderator]
Hey @crokkon, I just gave you a tip for your hard work on moderation. Upvote this comment to support the utopian moderators and increase your future rewards!
Thank you @crockon for your advice...can a know how to be approve by utopian...
you are the best
Thank you @alexandravart for your support.... nice to be @ccommons.art team...
well done on your first data post. I was not aware of this @ccommons.art initiative. There really is a lot of communities and support networks on steemit.
Thank you @paulag for you support.... i will learn much about analysis..
Nice work and reporting my friend! I'll be glad if you could organize a steem sql and utopian workshop for the globalschool participants (including me :P) someday would be awesome! =)
of course my friend @jnmarteau .... hopefully we can continue to build ccommon.art and global school together
Good job. I also just recently started contributing to the analysis section.
Trying to master my sql skills. Data mining is a big area to be explored. Also learning from @paulag the boss of Blockchain data analysis
Thank you @jingis07
Visit utopian-io website and view topics that have been accepted in the last 10 days and see how it they present their data and analysis
The analysis section is challenging, you have to be a critical thinker and open your mind to data mining.
My first 2 post were rejected too and I felt terrible because it took me hours or days to compile the data and graphs but I didn't give up
yes you are right @jingis07