Steemit Analysis of Nigerian Accounts

in #steemit7 years ago

Hello everyone, today I will be sharing this Analysis of Nigerian accounts. The objective here is provide to steemians a bigger picture about users from Nigeria

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.

NUMBER OF ACCOUNT

4101 Accounts found with Nigeria in the profile settings

NiZ9PH3.png

Looking at the data is shows that January, 2018 record the highest number of new accounts sign up (1463)

2280 upvoted at least once in 2018 (Actives)

biP1i6d.png
Looking at the image above approximately 2280 account upvote atleast once in a day and 1821 account are inactive.

Steem Power Ranking
Nigerian accounts Holds: 65.242,87379 STEEM POWER

STEEM POWER Distribution:

mwE9e4Z.png

Analysis shows that the number of account with steem power less that 100 (3984) are greater than the number of accounts with steem power greater that 2000 (3)

TOP 100 STEEM POWER:

DQmcxkFRRdsgue3zZaAjAbpSYAzY3QVFH5T1aLZiPvXwRcj.png
The first eleven(11) account with the highest steem power in Nigeria are: @stach @ogochukwu @onequality @greenrun @jaff8 @tojukaka @steemlifestyle @trillex @destinysaid @fisteganos @nairadaddy.

Reputation Ranking

TOP 200 in REPUTATION

DQmbot7ZADufjAs5hCKUFH1PybysXeAUR6ZMwcvnEVCnGH9.png
The first eleven (11) account with the highest Reputation in Nigeria are: @stach @fisteganos @ogochukwu @tojukaka @greenrun @jaff8 @destinysaid @bania @illuminatus @outhori5ed @ewuoso

Reputation Distribution:

fyxtl3O.png

Nigeria Accounts - Post Count:
Nigeria accounts post count TOTAL - 388.853 inclunding comments
TOP 100 in Post Count:

DQmScmv75L3kEXVS1ob13mXUmuXnjo2Y1u1Tfpsv7GDoMW3.png

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:

DQmYEHYfwe5QAAeynsXbb9ghywV92QLz5kS2YHUzXLwh4eZ.png

TOP 50 POSTS in POST PAYOUT - January 2018 - Nigerian Accounts:

DQmWL7rHLq49qdCp8MMdnJ7Ri1XcpMREG48EywSdxYgLS3v.png
First seven account with highest post payout in Nigeria are:@stach @tojukaka @fisteganos @sistem @ewuoso @rachelrick @yourmercury

Thank to @lpessin for the all the assist on these post he one of the best friend gave meet on steemit platform, also follow me for more weekly posts payout ranking for Nigerian Accounts.

Sort:  

Brain storming work! You made a good call on this post...though my name appeared ones.

And its a good thing that Nigerians got a place on steemit....nice job and well done @engrbrain1

Nice one bro, very nice but i dont think this is all because am not seeing someone i know very much in that list, like ewuosu said @samstikkz @ gbenga too isnt there.

That among the limitation, any user whose name is not here is not using Nigeria on he/her location. @samstickkz
Screenshot_20180205-130114.png

this is a nice analysis and i am glad to see my name in all and almost at the top but then i think there are some people missing. someone like @samstikkz

Many people are missing. @gbenga too isnt there

There are a lot of names not there. But @gbenga na biggest boss ooo

You are my boss man....

Kuku kee me

@gbenga is not using Nigeria on his location rather he using steemit
Screenshot_20180205-130703.png

I do not think @Afro-naija-trail is also using Nigeria as a location, either ways, I am a Nigerian

Sure sir @gbenga and a respected one @egetex is your real fan

Thanks boss

That among the limitation, any user whose name is not here is not using Nigeria on he/her location. @samstickkz
Screenshot_20180205-130114.png

Daddy epp ur son.
Sting me with ur bee pawa

They probably don't have the location tag. Well done sir.

You tried, but it's very inaccurate.

You cannot call it inaccurate. He used Sql. It is always accurate

@ogoowinner, he queried the parameters using Nigeria, so the post is accurate as the queried parameters. But like all things this way, there are limitations to it. He did a great job analysing the data. Data analysis is always a tricky thing. My friend @abh12345 could attest to that.

Whatever he used should be better than what I'm seeing here. That's passing out a wrong information about Nigerians and their activities here.

I still maintain it is inaccurate.

wow, at least I made one of the lists( no of posts), lol...this is really good work @engrbrain1 ..cheers

So i am not a Nigerian? Oh wow, my country now rejected me... SA i'm coming🚶🚶🚶🚶🚶🚶🚶🚶

Searched fo you too mum
Did you use Nigeria as location in your profile?

I used planet but i still see those who didnt but were counted... Lol

Lmao. Planet 😂

you will be in earth stat...yar international ..

wow nice analysis...I wonder how you managed to come up with this.

I made a mistake upvoting you.. Lmao.

How? I don't get...

This is a good one. Keep it up.

First seven account with highest post payout in Nigeria are:@stach @tojukaka @fisteganos @sistem @ewuoso @rachelrick @yourmercury.

Thanks for this information. Now I know who is who in Steemit Nigeria.

@engrbrain1

This is an excellent stuff. The data/information shows that there have been significant activities on the steem blockchain from Nigeria. Also the influx of people that came in January 2018 has shown that the steemit promotions in Nigeria has made some impact.

I am surprised at the comment section tho. I think you stated that only accounts that thier location is stated as Nigeria are used from the SQL data base to draw the information.

I don't think there is any simpler method to track this data except you can track every phone number or ip address of each user as the the time of registration. If by any devlish miracle that is achieved the next milestone is to track the username of each person lol

Perhaps next time . You enlighten us more on what it is SQL is. Not everyone is tech savy. That said. I really appreciate this thoughtful effort. This must have taking some time and energy

Great job

I can remember some months ago when i joined initially i had to change my location to Nigeria and also my avartar(January 2018) cause alot of people were mistaking me for an European. Haha

Cheers

Wooow thank you @dante31 I will do well to implement all the corrections, am happy you visited my blog

I appeared once. That means I'm doing something right. Nice work sir!

Coin Marketplace

STEEM 0.22
TRX 0.24
JST 0.038
BTC 95076.63
ETH 3277.51
USDT 1.00
SBD 3.26