Steemit Analysis of Nigerian Accounts
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
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)
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:
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:
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
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:
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:
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.
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
Thank you @diamondrich
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
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
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
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
Thank you @davidekpin
you welcome
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 😂
😫😪😂
Sorry about that @sweetestglo-eu
Its fine. :)
you will be in earth stat...yar international ..
Lmao... 😂😫ok
Lol
wow nice analysis...I wonder how you managed to come up with this.
Thank you
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!
Thank you @the23chronicles