Evaluating democracy: The witness race [OC] by remuslord

View this thread on steempeak.com
· @remuslord · (edited)
$5.01
Evaluating democracy: The witness race [OC]
**Before I begin the analysis, I have to give endless credit to @arcange, the creator of the http://steemsql.com/ database. Without making this amazing project free, I could not have done this analysis. All the data used here is extracted from the SteemSQL database by Tableau. If you like analyses like these, please go and support him if you can, even in the smallest way, so that people can continue to produce transparent and interesting analyses about the world of Steem.**

### Let's evaluate democracy: Looking for patterns in the witness voting data.
(provided by the SteemSQL database)

## Witness vote accumulation over time:
The size of the bubble shows the amount of votes that day (range 1-500 in a day). The gradient from red to green has it's midpoint at 1000 votes (to see how quickly witnesses earned their first 1000 votes) and maximum at 8478 votes.

![](https://steemitimages.com/DQmf3rQdam5bYYhGSJ1YEj1NNpRsCop1i2u24gddWN77uJM/image.png) ![](https://steemitimages.com/DQmWrVzZg65nk348c4M244LDzfoNgEGPFG9Fpz1gnXhNDTX/image.png)
![](https://steemitimages.com/DQmawRGqBhQshhbSPXuoYiWvXpMUV95fPntiPeLcmiT9K7P/image.png)

Ok, so what kind of patterns can we see from the data?

1. The barriers to entry seem to be quite tough since witnesses that have been successful for over a year are very likely to be successful today. 
The only notable exceptions to this pattern are @ausbitbank, @aggroed, @jerrybanfield in the top 30.
2.  The most meteoric rise can be attributed to @utopian-io. Most other witnesses among the top 30 have been around since 2016. 
3. Most witnesses among the top gained their first 1000 votes in mid 2017, and they continue to grow steadily all together - one might say "with the market". 

### Conclusion: I'm tempted to infer from this quick analysis that much of the success of the top witnesses is largely due to them already being popular and seen. However, it is possible to break through as we've seen with the notable exceptions mentioned above. 

All signs of a healthy and stable democratic environment some might argue. What do you think?

#

https://steemitimages.com/DQmehTDgLpQghT7ZWRnfYZAgK4VkGKZXgQUH476xivXaiZf/circles.png

<center>
![](https://steemitimages.com/DQmcH5NJMY2jT9NgGx5xZaJqspSoAZrXC8ecVF4bjzLSXhY/image.png)
</center>

## If you like these kind of posts, I would be super duper happy about a follow: @remuslord
Since these analyses take time, I don't post much, so you don't have to be afraid of me spamming up your feed :)

Thank you and happy steeming! :)
👍  , , , , , , , , , , , , , , ,
properties (23)
post_id24,403,214
authorremuslord
permlinkevaluating-democracy-the-witness-race-oc
categoryblockchainbi
json_metadata"{"format": "markdown", "links": ["http://steemsql.com/"], "app": "steemit/0.1", "tags": ["blockchainbi", "witness", "statistics", "steemit-austria", "stats"], "users": ["arcange", "ausbitbank", "aggroed", "jerrybanfield", "utopian-io", "remuslord"], "image": ["https://steemitimages.com/DQmf3rQdam5bYYhGSJ1YEj1NNpRsCop1i2u24gddWN77uJM/image.png"]}"
created2018-01-08 17:20:15
last_update2018-01-09 15:25:06
depth0
children13
net_rshares462,018,915,679
last_payout2018-01-15 17:20:15
cashout_time1969-12-31 23:59:59
total_payout_value3.886 SBD
curator_payout_value1.125 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length2,528
author_reputation296,634,883,917
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (16)
@sco ·
$0.03
nice analysis!
maybe you should team up with @witnesswatch
👍  
properties (23)
post_id24,410,069
authorsco
permlinkre-remuslord-evaluating-democracy-the-witness-race-oc-20180108t180235326z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "users": ["witnesswatch"], "tags": ["blockchainbi"]}"
created2018-01-08 18:02:36
last_update2018-01-08 18:02:36
depth1
children2
net_rshares3,319,096,065
last_payout2018-01-15 18:02:36
cashout_time1969-12-31 23:59:59
total_payout_value0.028 SBD
curator_payout_value0.005 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length58
author_reputation26,034,878,518,689
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@witnesswatch ·
$0.10
We would be very open to that! This is cool!
👍  
properties (23)
post_id24,454,144
authorwitnesswatch
permlinkre-sco-re-remuslord-evaluating-democracy-the-witness-race-oc-20180108t230524037z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "tags": ["blockchainbi"]}"
created2018-01-08 23:05:24
last_update2018-01-08 23:05:24
depth2
children0
net_rshares10,151,076,073
last_payout2018-01-15 23:05:24
cashout_time1969-12-31 23:59:59
total_payout_value0.080 SBD
curator_payout_value0.023 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length44
author_reputation868,738,140,464
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@remuslord ·
Good idea! :)
properties (22)
post_id24,559,400
authorremuslord
permlinkre-sco-re-remuslord-evaluating-democracy-the-witness-race-oc-20180109t112144921z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "tags": ["blockchainbi"]}"
created2018-01-09 11:21:42
last_update2018-01-09 11:21:42
depth2
children0
net_rshares0
last_payout2018-01-16 11:21:42
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_length13
author_reputation296,634,883,917
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@witnesswatch ·
$0.10
>Since these analyses take time, I don't post much, so you don't have to be afraid of me spamming up your feed :)

So true. I don't know what language you use, but when you get into the weeds with some of this stuff, it can be a slog!
👍  
properties (23)
post_id24,454,563
authorwitnesswatch
permlinkre-remuslord-evaluating-democracy-the-witness-race-oc-20180108t230814725z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "tags": ["blockchainbi"]}"
created2018-01-08 23:08:15
last_update2018-01-08 23:08:15
depth1
children1
net_rshares9,960,743,397
last_payout2018-01-15 23:08:15
cashout_time1969-12-31 23:59:59
total_payout_value0.080 SBD
curator_payout_value0.023 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length234
author_reputation868,738,140,464
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@remuslord ·
This was all in Tableau! I don't know any languages. Just a bit of VBA. I hope that's not my downfall as a data visualiser haha
properties (22)
post_id24,559,478
authorremuslord
permlinkre-witnesswatch-re-remuslord-evaluating-democracy-the-witness-race-oc-20180109t112215061z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "tags": ["blockchainbi"]}"
created2018-01-09 11:22:15
last_update2018-01-09 11:22:15
depth2
children0
net_rshares0
last_payout2018-01-16 11:22:15
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_length127
author_reputation296,634,883,917
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@eroche ·
$0.21
This is a very interesting analysis and a beautiful way to present the results. I am going to do some related analysis on witnesses votes in an upcoming post. This captures a big aspect of what I wanted to look at. I'll be referencing this post. 👍
👍  
properties (23)
post_id24,585,932
authoreroche
permlinkre-remuslord-evaluating-democracy-the-witness-race-oc-20180109t140303016z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "tags": ["blockchainbi"]}"
created2018-01-09 14:03:03
last_update2018-01-09 14:03:03
depth1
children2
net_rshares19,476,105,185
last_payout2018-01-16 14:03:03
cashout_time1969-12-31 23:59:59
total_payout_value0.156 SBD
curator_payout_value0.052 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length247
author_reputation59,490,065,137,068
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@remuslord ·
Cool! thank you! :) glad it was interesting
properties (22)
post_id24,601,105
authorremuslord
permlinkre-eroche-re-remuslord-evaluating-democracy-the-witness-race-oc-20180109t152420174z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "tags": ["blockchainbi"]}"
created2018-01-09 15:24:18
last_update2018-01-09 15:24:18
depth2
children0
net_rshares0
last_payout2018-01-16 15:24:18
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_length43
author_reputation296,634,883,917
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@remuslord ·
Looking forward to reading your analysis. I think there's a lot more to look at definitely :)
properties (22)
post_id24,602,383
authorremuslord
permlinkre-eroche-re-remuslord-evaluating-democracy-the-witness-race-oc-20180109t153113560z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "tags": ["blockchainbi"]}"
created2018-01-09 15:31:12
last_update2018-01-09 15:31:12
depth2
children0
net_rshares0
last_payout2018-01-16 15:31:12
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_length93
author_reputation296,634,883,917
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@marinaart ·
Could you explain to me who is the witnesses and what exactly they do. I know that my question probably sounds little stupid , but I want to understand world of Steemit and how it works. I was looking for plain and simple explanation for the past two weeks on many Steemit structure related subjects and could't fined it.I need hellllpppppppppp!
properties (22)
post_id24,846,055
authormarinaart
permlinkre-remuslord-evaluating-democracy-the-witness-race-oc-20180110t183409886z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "tags": ["blockchainbi"]}"
created2018-01-10 18:34:06
last_update2018-01-10 18:34:06
depth1
children3
net_rshares0
last_payout2018-01-17 18:34: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_length345
author_reputation1,373,339,077,399
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@plushzilla · (edited)
$0.03
@pfunk's post on Steem witnesses is worth a read, although it was from 2 years ago: https://steemit.com/steemit-guides/@pfunk/a-full-steemit-user-s-guide-to-steem-witnesses

Also, a more recent version from @steemitguide: https://steemit.com/steem/@steemitguide/steemitguide-what-is-a-exactly-is-a-steem-witness-and-why-every-user-should-vote
👍  
properties (23)
post_id27,627,589
authorplushzilla
permlinkre-marinaart-re-remuslord-evaluating-democracy-the-witness-race-oc-20180124t005002842z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "users": ["pfunk", "steemitguide"], "links": ["https://steemit.com/steemit-guides/@pfunk/a-full-steemit-user-s-guide-to-steem-witnesses", "https://steemit.com/steem/@steemitguide/steemitguide-what-is-a-exactly-is-a-steem-witness-and-why-every-user-should-vote"], "tags": ["blockchainbi"]}"
created2018-01-24 00:49:51
last_update2018-01-24 00:50:36
depth2
children2
net_rshares3,275,711,047
last_payout2018-01-31 00:49:51
cashout_time1969-12-31 23:59:59
total_payout_value0.028 SBD
curator_payout_value0.005 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length342
author_reputation2,392,703,522,150
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@marinaart ·
Thanks for reply. It is hard to fined info with search.
properties (22)
post_id27,638,010
authormarinaart
permlinkre-plushzilla-re-marinaart-re-remuslord-evaluating-democracy-the-witness-race-oc-20180124t015727915z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "tags": ["blockchainbi"]}"
created2018-01-24 01:57:30
last_update2018-01-24 01:57:30
depth3
children1
net_rshares0
last_payout2018-01-31 01:57:30
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_length55
author_reputation1,373,339,077,399
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@reginaizz ·
what tool do you use ?
properties (22)
post_id25,760,530
authorreginaizz
permlinkre-remuslord-evaluating-democracy-the-witness-race-oc-20180115t051440107z
categoryblockchainbi
json_metadata"{"app": "steemit/0.1", "tags": ["blockchainbi"]}"
created2018-01-15 05:14:39
last_update2018-01-15 05:14:39
depth1
children0
net_rshares0
last_payout2018-01-22 05:14: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_length22
author_reputation0
root_title"Evaluating democracy: The witness race [OC]"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000