Analysis for steemit account Nigeria on their profile.

in #utopian-io4 years ago (edited)

This analysis is based on the Nigerian users on steem blockchain who have "Nigeria" as their location in the profile section.

Details of the analysis.

  • Data gathered 2nd February 2018
  • Extracted data through steemsql .Thanks to @arcange
  • Checking steemit accounts with "Nigeria" as their location.
  • Scope of Report Jan 2017 - Jan 2018
  • Method: SQL queries + Excel 2013. See here.

Outline

In this study:

  • I identified the number of accounts found with Nigeria in the profile settings.
  • I examine the accounts of activeness by checking the if the account made any upvote in January 2018.
  • Next i did an analysis on the STEEM POWER Distribution of Nigerian accounts.
  • Then another analysis on reputation score distribution.
  • Finally, an analysis on post including, post count and posting rewards.

Scope of Analysis

  • Data gathered 2nd February 2018
  • Extracted data through steemsql .Thanks to @arcange
  • Checking steemit accounts with "Nigeria" as their location.
  • Scope of Report Jan 2017 - Jan 2018
  • Method: SQL queries + Excel 2013. See here.

Tools

I used arcange's Steem SQL Public Database to acquire the data-points related to the variables studied in this analysis under the Account table. I ran a simple query in a Microsoft Excel spreadsheet to get all the variables used

Results

NUMBER OF ACCOUNT FOUND

A total of 4101 accounts was found with Nigeria in the profile settings.

wcctlfdklqo4y0ieo7dm.png

From the results above it is evident that Steemit marks all time high registration from Nigeria as a region which can be associated to the number of publicity done by Nigerians as seen in the visibility category of utopian.

NUMBER OF ACTIVE ACCOUNTS
2280 accounts upvoted at least once in 2018 showing activeness.

y0dmazerp7sywbqgtuok.png

Judging from the chart above, it can be said that 44% of the Nigerian accounts open before January 2018 is not active.

Steem Power Distribution:
Nigerian accounts holds a total of 65.242,87379 STEEM POWER

zrynmnq4ggd9d2gz4gie.png

From the chart above a huge cut of the Nigerian population on steemit have a steem power lesser than 100. on the averagee it can be said that all nigerian account on steemit.com have a steem power lesser than 100.

Steem Power Ranking
TOP 100 STEEM POWER:

m0wq2cjlzb7knkydlqc7.png

Reputation Distribution:

mfjeyguhwgfnpl62u92p.png

From the chart above, a huge number of Nigerian account have a reputation of 25 while a larger number of Nigerian account have a reputation score less than 25 and majority of Nigerian accounts have a reputation score within the range of 25 to 45.
Reputation Ranking
TOP 200 in REPUTATION

glfep4beau6jfjv1e7ay.png

Post Count:
Nigeria accounts a have a total post count of 388.853 post including comments.

TOP 100 in Post Count:

h9nv36ebv1ax6eripstx.png

Rewards:
All Nigeria accounts posting rewards = 104.952,201 STU
All Nigeria accounts curation rewards = 4.540,963 STU

TOP 100 Accounts Posting Rewards:

lx6thusti3xc5bji3xqy.png

TOP 50 POSTS in POST PAYOUT - January 2018:

kjzxk1nmmkn8uj8lgvww.png

Thanks for your time.



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

@arcjen, I always try to support who contribute to open source project, upvote you.

Its a good thing you do.
Thanks for visiting. @steemitstats

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]