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 @arcjen, your contribution shows huge tables with data, but there is not much analysis of this data involved. Some tables are not even described. It is unclear at several stages what you actually did and you did not include the SQL queries that were used.

The time frame is only roughly given. You write it's from Jan 2017 to Jan 2018. From the numbers of post+comments this rather seems to be from Jan 1st 2017 to Feb 1st 2018?!

You write you have queried for accounts with "Nigeria" as their location, but looking into the location table there are location entries without "Nigeria". This looks to me like you queried the whole json_metadata field for this keyword instead of the location field?

If you plan to do further steem blockchain analysis posts, please use the repository steemit/steem instead of condenser for your next contribution.

You can contact us on Discord.
[utopian-moderator]