Nigeria Accounts-Steemit Analysis

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 Hive account@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.