Very detailed post. I want to add, that voting itself does not necessary mean "active" a lot of users use bots to vote. Another detail, you didn't count accounts that were never active, they are about half of all accounts. And if you count unique account holders that's even less.
You are viewing a single comment's thread from:
I will look at a way to filter some of the bots. Accounts that were never active will be filtered out anyway by the query. Finding unique account holders is not possible with querying the database in the current set up and may require more manual firepower.
You can find accounts that were never active when "last_vote_time" is equal to "created"
That's right. There are some info in the post, like @noganoo - if I spelled it right - has over 1000 accounts. @berniesanders has at least 55 accounts. There was a spammer here that looks like he owns 2700 accounts: https://steemit.com/steemit-abuse/@patrice/2700-accounts-love-spam-comments-is-this-a-case-of-gaming-the-system-or-abuse
And more... When you filter all these accounts, you will see that there is a small percentage of active Steemit accounts.
How about pooling these account names together into a common Google sheet so that users can update there directly and avoid duplicating their labor? I will try to curate this next week.
Good idea!