. by crokkon

View this thread on steempeak.com
· @crokkon · (edited)
$53.55
properties (23)
post_id68,320,674
authorcrokkon
permlinkhow-frequently-do-witness-ranks-change-1546552028773
categoryutopian-io
json_metadata{"app":""}
created2019-01-03 21:47:09
last_update2022-03-11 15:02:06
depth0
children12
net_rshares103,377,036,053,325
last_payout2019-01-10 21:47:09
cashout_time1969-12-31 23:59:59
total_payout_value40.563 SBD
curator_payout_value12.987 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length1
author_reputation75,470,595,669,689
root_title.
beneficiaries
0.
accountutopian.pay
weight500
max_accepted_payout100,000.000 SBD
percent_steem_dollars0
author_curate_reward""
vote details (178)
@revisesociology ·
$0.04
Very interesting indeed! I would also have expected things to be more static. 

It'd be inteteresting to add in a further layer about how often new people enter the top 20. Or something on how often there's change of the top 20 rather than change within.

Great analysis as always!

Posted using [Partiko Android](https://steemit.com/@partiko-android)
πŸ‘  , ,
properties (23)
post_id68,321,889
authorrevisesociology
permlinkrevisesociology-re-crokkon-how-frequently-do-witness-ranks-change-1546552028773-20190103t222449238z
categoryutopian-io
json_metadata{"app":"partiko"}
created2019-01-03 22:24:48
last_update2019-01-03 22:24:48
depth1
children2
net_rshares71,679,531,843
last_payout2019-01-10 22:24:48
cashout_time1969-12-31 23:59:59
total_payout_value0.029 SBD
curator_payout_value0.006 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length351
author_reputation219,336,602,045,061
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (3)
@crokkon ·
$0.05
Thanks for your comment and the resteem! The set of accounts within a certain rank range, or how often this set changes, is a good point! This is partly already available from the graph with the witness rankings. Take any rank limit and count how many lines go in or out of this rank range in the graph. Changes on these sets are clearly on a slower time scale.
πŸ‘  
properties (23)
post_id68,322,598
authorcrokkon
permlinkre-revisesociology-revisesociology-re-crokkon-how-frequently-do-witness-ranks-change-1546552028773-20190103t224329259z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"app":"steemit\/0.1"}
created2019-01-03 22:43:30
last_update2019-01-03 22:43:30
depth2
children1
net_rshares88,673,459,581
last_payout2019-01-10 22:43:30
cashout_time1969-12-31 23:59:59
total_payout_value0.036 SBD
curator_payout_value0.012 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length361
author_reputation75,470,595,669,689
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@revisesociology ·
OK cheers...I'll have a closer look when I'm on my top... my phone's not the best thing for viewing images on (combined with my eyes at least!).

Posted using [Partiko Android](https://steemit.com/@partiko-android)
properties (22)
post_id68,336,443
authorrevisesociology
permlinkrevisesociology-re-crokkon-re-revisesociology-revisesociology-re-crokkon-how-frequently-do-witness-ranks-change-1546552028773-20190104t061505278z
categoryutopian-io
json_metadata{"app":"partiko"}
created2019-01-04 06:15:06
last_update2019-01-04 06:15:06
depth3
children0
net_rshares0
last_payout2019-01-11 06:15:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length214
author_reputation219,336,602,045,061
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@abh12345 ·
$11.15
Hi @crokkon

Great work on building your own dataset for this (another!) analysis, some history I would like to be available in SteemSQL isn't present and DIY is a good alternative for sure.

>  personally perceived the witness ranking list as rather static, at least in the upper positions.

Same.  The gaps in MVESTS between the top 10 being much larger than lower down the ranks, although individual accounts voting in the top 10 do hold large, vote-swinging stake.

> I have not correlated the changes with blockchain "events", but I'm pretty sure there would be connections to announcements and posts.

In the case of @therealwolf, I think the state of the dapps work may have cause some good publicity, and a move on this witness.

Being a witness and lying outside the top 50, I would selfishly have liked to see this expanded to top 100/all witnesses, but understand the addition effort being quite sizable.  Also, your original idea may not have been looking at lower ranks, and so I understand the scope not including all witnesses.

Cheers

Happy New Year!

Asher [CM - Analysis]

Your contribution has been evaluated according to [Utopian policies and guidelines](https://join.utopian.io/guidelines), as well as a predefined set of questions pertaining to the category.

To view those questions and the relevant answers related to your post, [click here](https://review.utopian.io/result/0/1-1-2-1-1-1-3-).

---- 
Need help? Write a ticket on https://support.utopian.io/. 
Chat with us on [Discord](https://discord.gg/uTyJkNm). 
[[utopian-moderator]](https://join.utopian.io/)
πŸ‘  , , , , , , , , , , , ,
properties (23)
post_id68,341,222
authorabh12345
permlinkre-crokkon-how-frequently-do-witness-ranks-change-1546552028773-20190104t085900851z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"app":"steemit\/0.1","users":["crokkon","therealwolf"],"links":["https:\/\/join.utopian.io\/guidelines","https:\/\/review.utopian.io\/result\/0\/1-1-2-1-1-1-3-","https:\/\/support.utopian.io\/","https:\/\/discord.gg\/uTyJkNm","https:\/\/join.utopian.io\/"]}
created2019-01-04 08:59:03
last_update2019-01-04 08:59:03
depth1
children4
net_rshares20,471,185,478,945
last_payout2019-01-11 08:59:03
cashout_time1969-12-31 23:59:59
total_payout_value8.444 SBD
curator_payout_value2.710 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length1,588
author_reputation590,352,098,179,351
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars0
author_curate_reward""
vote details (13)
@arcange · (edited)
$0.03
> ...some history I would like to be available in SteemSQL isn't present...

What kind of history would you like to be available?

> Being a witness and lying outside the top 50, I would selfishly have liked to see this expanded to top 100/all witnesses...

He he, I guess you want to see your own witness rank evolution... here it is ;)

![](https://cdn.steemitimages.com/DQmNpFzQDRnrNBghX8eKsVxTBvfRBrPcKyBoQKLBx9V9B3y/image.png)
πŸ‘  
properties (23)
post_id68,346,226
authorarcange
permlinkre-abh12345-re-crokkon-how-frequently-do-witness-ranks-change-1546552028773-20190104t114033982z
categoryutopian-io
json_metadata{"image":["https:\/\/cdn.steemitimages.com\/DQmNpFzQDRnrNBghX8eKsVxTBvfRBrPcKyBoQKLBx9V9B3y\/image.png"],"tags":["utopian-io"],"app":"steemit\/0.1"}
created2019-01-04 11:40:33
last_update2019-01-04 12:21:18
depth2
children2
net_rshares58,781,112,267
last_payout2019-01-11 11:40:33
cashout_time1969-12-31 23:59:59
total_payout_value0.024 SBD
curator_payout_value0.007 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length431
author_reputation231,443,210,169,699
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@abh12345 ·
Hey!

How did you pull that together?  Maybe there is more in SteemSQL than I am aware of, and i just don't have the knowledge of the DB.

Can you do an SP evolution per account in the same way?
properties (22)
post_id68,348,734
authorabh12345
permlinkre-arcange-re-abh12345-re-crokkon-how-frequently-do-witness-ranks-change-1546552028773-20190104t125040077z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"app":"steemit\/0.1"}
created2019-01-04 12:50:39
last_update2019-01-04 12:50:39
depth3
children1
net_rshares0
last_payout2019-01-11 12:50:39
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length194
author_reputation590,352,098,179,351
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars0
@utopian-io ·
Thank you for your review, @abh12345! Keep up the good work!
properties (22)
post_id68,465,251
authorutopian-io
permlinkre-re-crokkon-how-frequently-do-witness-ranks-change-1546552028773-20190104t085900851z-20190107t010052z
categoryutopian-io
json_metadata{"app":"beem\/0.20.9"}
created2019-01-07 01:00:54
last_update2019-01-07 01:00:54
depth2
children0
net_rshares0
last_payout2019-01-14 01:00:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length60
author_reputation152,913,012,544,965
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@steem-ua ·
#### Hi @crokkon!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your post is eligible for our upvote, thanks to our collaboration with @utopian-io!
**Feel free to join our [@steem-ua Discord server](https://discord.gg/KpBNYGz)**
properties (22)
post_id68,341,496
authorsteem-ua
permlinkre-how-frequently-do-witness-ranks-change-1546552028773-20190104t090904z
categoryutopian-io
json_metadata{"app":"beem\/0.20.14"}
created2019-01-04 09:09:06
last_update2019-01-04 09:09:06
depth1
children0
net_rshares0
last_payout2019-01-11 09:09:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length286
author_reputation23,203,609,903,979
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@utopian-io ·
Hey, @crokkon!

**Thanks for contributing on Utopian**.
We’re already looking forward to your next contribution!

**Get higher incentives and support Utopian.io!**
 Simply set @utopian.pay as a 5% (or higher) payout beneficiary on your contribution post (via [SteemPlus](https://chrome.google.com/webstore/detail/steemplus/mjbkjgcplmaneajhcbegoffkedeankaj?hl=en) or [Steeditor](https://steeditor.app)).

**Want to chat? Join us on Discord https://discord.gg/h52nFrV.**

<a href='https://steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1'>Vote for Utopian Witness!</a>
properties (22)
post_id68,355,535
authorutopian-io
permlinkre-how-frequently-do-witness-ranks-change-1546552028773-20190104t153132z
categoryutopian-io
json_metadata{"app":"beem\/0.20.9"}
created2019-01-04 15:31:33
last_update2019-01-04 15:31:33
depth1
children0
net_rshares0
last_payout2019-01-11 15:31:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length589
author_reputation152,913,012,544,965
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@pennsif ·
This post has been included in today's  [**SOS Daily News**](https://steemit.com/steem/@pennsif/sosdailynewsnewsaboutthestateofsteem3january2019-prmwufl7f6) - a digest of all you need to know about the State of Steem.

***

* *Editor of the [**The State of Steem SoS Daily News**](https://steemit.com/steem/@pennsif/sosdailynewsnewsaboutthestateofsteem3january2019-prmwufl7f6).*

* *Promoter of [**The State of Steem SoS Weekly Forums**](https://steemit.com/dtube/@pennsif/amwntxt3).*

* *Editor of the [**weekly listing of steem radio shows, podcasts & social broadcasts**](https://steemit.com/mspwaves/@pennsif/schedule-of-radio-shows-podcasts-and-social-broadcasts-supported-by-dsound-week-beginning-31-december-2018).*

* *Founder of the [**A Dollar A Day**](https://steemit.com/adollaraday/@adollaraday/a-dollar-a-day-charitable-giving-project-ususd-5000-donated-in-8-months-we-made-it) charitable giving project.*

https://pennsif.com/wp-content/uploads/2018/08/adollaraday-linear-400x98.jpg

***
properties (22)
post_id68,363,007
authorpennsif
permlinkre-crokkon-how-frequently-do-witness-ranks-change-1546552028773-20190104t184504314z
categoryutopian-io
json_metadata{"image":["https:\/\/pennsif.com\/wp-content\/uploads\/2018\/08\/adollaraday-linear-400x98.jpg"],"tags":["utopian-io"],"app":"steemit\/0.1","links":["https:\/\/steemit.com\/steem\/@pennsif\/sosdailynewsnewsaboutthestateofsteem3january2019-prmwufl7f6","https:\/\/steemit.com\/dtube\/@pennsif\/amwntxt3","https:\/\/steemit.com\/mspwaves\/@pennsif\/schedule-of-radio-shows-podcasts-and-social-broadcasts-supported-by-dsound-week-beginning-31-december-2018","https:\/\/steemit.com\/adollaraday\/@adollaraday\/a-dollar-a-day-charitable-giving-project-ususd-5000-donated-in-8-months-we-made-it"]}
created2019-01-04 18:45:03
last_update2019-01-04 18:45:03
depth1
children0
net_rshares0
last_payout2019-01-11 18:45:03
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length1,002
author_reputation1,136,463,666,385,724
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@lostmine27 · (edited)
Very interesting content. Thank you.

Intuitively, there seems to have been more fluctuations than usual after the plunge in STEEM prices.

In my memory, there is usually a change between 17th and 22nd, and sometimes one or two TOP witnesses seem to change.

Other big fluctuations seem to be rare. The long-term influence of top-witnesses, the strong influence of freedom and blocktrades accounts seems to be the main reason, and mutual voting among top-witnesses seems to work partly.

Stability of witness status is an important factor in job performance, but since their term is not fixed, more active ranking changes seem desirable.
properties (22)
post_id68,394,824
authorlostmine27
permlinkre-crokkon-how-frequently-do-witness-ranks-change-1546552028773-20190105t124856873z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"app":"steemit\/0.1"}
created2019-01-05 12:48:57
last_update2019-01-05 12:55:03
depth1
children0
net_rshares0
last_payout2019-01-12 12:48:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length637
author_reputation52,346,649,432,500
root_title"How frequently do witness ranks change?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000