Hello Steemians, I like to share this Analysis of Nigerian accounts I have done. The objective here is provide to steemians a bigger picture about users from this country
There still a lot of data I will like to add in the future, this are just a few overviews and rankings. I want to make periodic reports on the subject, it is ok to do it here at Utopian?
Data Source: SteemSQL ( by @arcange) (See Here)
Method: SQL queries + Excel 2013 (See here)
Limitations of the analysis:
+As this is basic a filter by location, ONLY accounts with location set in the profile will be included! If the account doesn't have the name of the country in the profile, is not included.
+All accounts only. I hope to add active/inactive accounts data on the next update!
4101 Accounts found with Nigeria in the profile settings.
We can see here things start to get hot around Jan/18.
2280 upvoted at least once in 2018 (Actives)
*all accounts(active/inactive) I like to add in the future a chart only with the actives.
Steem Power Ranking
Nigerian accounts Holds: 65.242,87379 STEEM POWER
STEEM POWER Distribution:
TOP 100 STEEM POWER:
Observation: We can see few location inputs that not contain the country name, they are listed because there is a country name somewhere else in the profile, like in 'description' field.
Reputation Ranking
TOP 200 in REPUTATION
Reputation Distribution:
Nigeria Accounts - Post Count:
Nigeria accounts post count TOTAL - 388.853 inclunding comments
TOP 100 in Post Count:
Nigeria Accounts Rewards:
All Nigeria accounts posting rewards - 104.952,201 STU
All Nigeria accounts curation rewards - 4.540,963 STU
TOP 100 Accounts Posting Rewards:
TOP 50 POSTS in POST PAYOUT - January 2018 - Nigerian Accounts:
Posted on Utopian.io - Rewarding Open Source Contributors
Your contribution cannot be approved because it is not as informative as other contributions. See the Utopian Rules. Contributions need to be informative and descriptive in order to help readers and developers understand them.
Dear @bellagreen, I'm sorry, but you only present data, there is no analysis/discussion/conclusion from that data involved. Why do you compare south American user counts with total user counts when the contribution is about Nigeria? Your contribution seems to lack some links and is not properly formatted. The location tag field is highly unreliable because everybody can put whatever they want there. Tags might get a better picture as shown by @steemitph a couple of days ago here.
If you plan to do more blockchain analysis contributions in the future please make sure to set the repository to 'steemit/steem' and include the database queries.
You can contact us on Discord.
[utopian-moderator]
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey @crokkon, I just gave you a tip for your hard work on moderation. Upvote this comment to support the utopian moderators and increase your future rewards!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit