Steemit Blockchain Analysis - Distribution of Post Counts by Users

As promised in a previous post on Steemit developer resources (https://steemit.com/programming/@digimad/developer-resources-for-steem), I've started to have a look at the steem blockchain on the public SQL database available at http://www.steemsql.com/. Its a fantastic resource, many thanks to the person/team behind it.

As a first step I wanted to check out the distribution of posts by users:

• How many users join but then never post?
• Can we spot the bots by singling out unrealistic post counts?
• How many posts do you have to make before you are in the top 80%, 50% or even 10% of Steem users?

This first chart shows the number of users (vertical axis) against the count of posts they've made on Steemit (horizontal axis). I had to use a logarithmic scale as a standard plot just has all the points hugging the axis (skewed by the bots with 0000's of posts).

Here is the same chart, but not logarithmic, and only for the lowest 95% of users (to avoid over-skewing the chart):

Some other interesting observations:

• 67% of users never make a post
• 89.6% of users make 10 posts or less
• if you make more than 11 posts, you are in the top 10% of Steemit users
• to get into the top 5% of steemit users, you have to make 41 posts or more
• to get into the top 1% of steemit users, you have to make 381 posts or more
• only 59 users have made more than 5,000 posts

The top 20 users by post count are:

Username	Post Count
screenname	28569
cheetah	25645
mindhunter	21615
papa-pepper	18985
jlufer	17712
steemitboard	17116
thecryptofiend	16557
ace108	13472
barrydutton	12651
meesterboom	12253
karenb54	11091
doitvoluntarily	10945
karenmckersie	10801
stellabelle	10421
linkback-bot-v0	10067
gringalicious	9303
englishtchrivy	9134
steevc	9014
everittdmickey	8860
virtualgrowth	8636