@utopian-io - Voting Analysis: User reputation and vote weight
utopian-io·@abh12345·
0.000 HBD@utopian-io - Voting Analysis: User reputation and vote weight
This is an analysis of the voting of @utopian-io from inception to present day. **Sections** 1. Vote numbers - previous 7 days, 30 days, since first vote cast on the 29th September 2017 2. Votes against reputation of author 3. Votes weight against reputation of author. 4. Popular authors - previous 7 days, 30 days, since first vote 5. Summary 6. Tools used to gather data and compile report <center>  </center> --------------------- ## General ## @utopian-io is the new kid on the Steem block, and has amassed **3.7 million Steem power** through delegations. At the time of writing: a 25% up-vote is worth $ 72.62 a 50% up-vote is worth $145.23 a 75% up-vote is worth $216.27 a 100% up-vote is worth $288.88 [source](https://steemworld.org/@utopian-io) Utopian is now a STEEM Witness - You can vote for Witnesses [here](https://steemit.com/~witnesses) --------------------------- ## 1. Vote Counts ## To extract this data, the following SQL query has been used:  <sub>It would also be valid to join the TxVotes table and add to the WHERE clause to check if 'parent_author' = 0.</sub> ---------------- <br> Total number of votes given in the past 7 days: **766** Number of votes given in the past 7 days for comments: **9** Daily average: **109** ---------------- <br> Total number of votes given in the past 30 days: **1749** Number of votes given in the past **30** days for comments: **9** Daily average: **58** ----------------------------- <br> Total number of votes given since 29th September (first vote): **1903** Number of votes given since 29th September for comments: **19** Daily average: **35.9**  ## 2. Votes and Reputation ## The vote count is on the vertical axis, and the reputation range on the horizontal axis. --------------------- #### Votes across Reputation over the past **7** days #### To extract this data, the following SQL query has been used:  <sub>Note the calculation to refine the user reputation, and the joining of the 'Accounts' table and 'TxVotes' table.</sub> ------------ <center>  </center> The average reputation here is **57** ------------------- #### Votes across Reputation over the past **30** days <center>  </center> The average reputation here is **57.9** ------------------- #### Votes across Reputation since **29th September** (first vote) <center>  </center> The average reputation here is **57.9**  ## 3. Vote Weight and Reputation ## The vote weight is on the vertical axis, and the reputation range on the horizontal axis. --------------- #### Weight (Strength) of votes cast across reputation over the past **7** days <center>  </center> ------------------- #### Weight (Strength) of votes cast across Reputation over the past **30** days <center>  </center> -------------------- #### Weight (Strength) of votes cast across Reputation since **29th September** (first vote) <center>  </center>  ---------------------------- ## 4. Popular Authors ## To extract this first set of data, the following SQL query has been used:  --------------------------- <br>Most popular authors voted on in the past **7** days  ----------------------- <br>Most popular authors voted on in the past **30** days  ------------------------ <br>Most popular authors voted on since **29th September 2017** (first vote)   ## 5. Summary ## The number of average daily votes has risen impressively since inception date. This shows the number of author posts relating to @utopian-io increasing, and the accounts' willingness to support them. The average reputation of post owner voted on is steady at 57 and has even fallen a little since day 1. This shows a good level of commitment to newer members of the Steem Blockchain who are producing work for @utopian-io. Vote weight is fallen in line with the increasing amount of Steem Power the account holds. This is sensible and good to see, and most votes over the past week are in the 0 - 25% weight range. Author popularity is changing from week to week, another good sign of rewards being spread and new contributors arriving. Overall, I think @utopian-io are using their Steem Power delegations well, rewarding many authors and content with a sensible weight of vote. --------------------- ## 6. Tools used to gather this report ## The data is sourced from SteemSQL - A [publicly available SQL database](https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data) with all the blockchain data held within (Data is normally 1/2 hours delayed from live) The SQL queries to extra to the data have been produced in both SQL Server Personal Edition and LINQPAD 5. The charts used to present the data were produced using MS Excel. <sub>This data was compiled on the 21st November at 8:30 am CET</sub> --------------------- <br> Thanks Asher @abh12345 <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@abh12345/utopian-io-voting-analysis-user-reputation-and-vote-weight">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>
👍 rafiulrohan, ridaazhar, andresfnl, aftabkhan10, helmirenggrik, enginewitty, thealliance, stsl, mkt, choogirl, michaeldavid, steemitbc, dandesign86, infoworld, spiz0r, rosatravels, trueart, xervantes, funkit, costanza, rulesforrebels, blevley, bruja, rmz, avesa, lexiconical, raphma, steemmeupscotty, biophil, gentlebot, robrigo, snowflake, ojaber, thing-2, rok-sivante, freeyourmind, someonewhoisme, luna33, karencarrens, mcfarhat, johleen, deaconlee, msp-lovebot, muxxybot, ethandsmith, thinknzombie, jasonbu, kam.ila, abh12345, osm0sis, halcyondaze, maarnio, yuxi, stackin, surfermarly, aafeng, crimsonclad, ausbitbank, umami, natra, ddangerwu, anwarabdullah, shadowspub, d646d19cf, mrkstn1, lawyerup, honolulu, crokkon, sarmizegetusa, carlgnash, marshalllife, wxzurd, lyxng, safat, idlebright, adasq, mllg, rusinho027, teamsteem, turymenecier, berkah, mrs.agsexplorer, pnc, hitmeasap, lamech-m, greenstar, utopian-io, aarkay, kupi, ahridoy, nepo, aamjad, tenzel, antoinemonf, malipather, justatouchfey, therealwolf,