Evolved08gsr's Voting / Posting Analysis #001 - Full Population
Let's Take A Look At All Voting and Posting Transactions
I want to start off by making it clear that I am a human and not a bot. All of the following has been performed via manual review and my own uniquely developed SQL Queries. I would be able to run the same exact queries at a future date by running the same code, however, I would then need to make new observations about the results.
Now that the boring part is out of the way, let's dive into the fun part!
I started with all of the Accounts and Votes ([TxVotes]) on the blockchain as of around 11:15 AM EST on August 8, 2017.
First Let's Look at the Number of Accounts / Users who are Voting:
![](https://steemitimages.com/640x0/https://steemitimages.com/DQmVCWhT4eJGVWGpETJ7q2NqCxmkZCLfP38btPfQsKDxGVT/image.png)
This rounds us off at 154,710 Accounts who have voted, Less 90,174 Accounts who haven't voted in the past month. So we are left with 64,536 "Actively Voting" Accounts.
Here's a Monthly Breakdown of the 90,174 Accounts Who Haven't Voted Since July 6, 2017 or Earlier:
![](https://steemitimages.com/DQmXGdFaXWjaCH878NP99DhA3eTXshVEf51S3oJgX4cxvUa/image.png)
The fun little outlier from "1970" is the account named @temp. I guess it's true that once you create an account on Steemit, it will live on the blockchain forever!
The majority of Accounts who aren't voting anymore were Created in 2016, However, there is a large number of Accounts that were created in June 2017 who aren't voting either. I wonder how many of these Accounts are earmarked for new bots? That would be a scary thought...
I also thought it would be Interesting to See Some Statistics about Who Voted but Never Received a Vote
![](https://steemitimages.com/640x0/https://steemitimages.com/DQmVL3bVWkfYNVRUTAM4FCGDQEeJY1Zw7HSn8w5eVZWs1ZF/image.png)
And Who Received Votes But Never Voted
![](https://steemitimages.com/DQmNQ4umJcj8rgeBDzbRv3HFmBr55efn6QSuqr6cPkyrZ1Y/image.png)
The last bit of analysis is where I tried to get a bit more creative.
![](https://steemitimages.com/640x0/https://steemitimages.com/DQmb7tpSk5RsHe8twaTs7BjwgJABb7p419meCXNLCKkCZiM/image.png)
# Posts/Comments Authored w/Votes: I looked at the number of unique posts or comments based on the [permlink] field, which contains a portion of the unique URL for every Post or Comment. Specifically, I looked at this number for "Authors" (as opposed to "Voters").
# Votes: Self-Explanatory
# Self-Votes: Any Vote where the "Voter" is the same as the "Author"
Account Post Count: The Accounts table has a [post_count] field, this is simply a sum of that field.
% Self-Votes out of Total Votes: Self-Explanatory
If you enjoyed my analysis, thought it was interesting, or would like to see some more, Please Upvote
![](https://steemitimages.com/DQmeLnAN6qaoSzu1akbYhBi1qqnRCpEC5Bv6ofe6Z7YGTpd/image.png)
![](https://steemitimages.com/640x0/https://steemitimages.com/DQmNh17W4CS1VDA2fST66fZot2ShA8Uw7gF5KShrW2DYu2V/image.png)
![](https://steemitimages.com/DQmfTgZm9XgoGM9uVqqSVPXpfs5vbv24dEeJh2uEihzEbsL/image.png)
![](https://steemitimages.com/640x0/https://steemitimages.com/DQmW2RbYTDdpU8SQeRsQpxCcD4V1UukySTVkyqiopN88jyh/image.png)
Can Anyone Help Me With Adding Earnings To This Analysis?
(I assume I'll need to perform a separate calculation for Posts within the 30-Day Payment Cycle compared to Posts outside of the 30-Day Payment Cycle?)
Any Pointers would be Greatly Appreciated!
If you want to read more, please take a look at some of my other posts:
- Why I'm Saving my Bitcoin Cash
- Evolved08gsr's Crypto Briefing 8/8/2017
- The Epic Failure of Steemit, and Why you Should Care
- It Looks Like Ethereum (ETH) is Climbing while Bitcoin (BTC) is Stagnating
- Evolved08gsr's SteemSQL Analysis - Post #002 - Working to Identify and Eradicate Spam Accounts Follow-Up
- Evolved08gsr's SteemSQL Analysis - Post #001 - Working to Identify and Eradicate Spam Accounts
- Evolved08gsr's Steemit Navigation Tips
- Steemit Goal(s) for this week and beyond!
- Evolved08gsr's Dabbling into Cryptocurrencies
Follow My Daddy Daycare Adventure Here:
Thank you, @albertvhons for your continued support!