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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @diamondrich
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That among the limitation, any user whose name is not here is not using Nigeria on he/her location. @samstickkz
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Many people are missing. @gbenga too isnt there
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
There are a lot of names not there. But @gbenga na biggest boss ooo
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You are my boss man....
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Kuku kee me
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@gbenga is not using Nigeria on his location rather he using steemit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I do not think @Afro-naija-trail is also using Nigeria as a location, either ways, I am a Nigerian
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Sure sir @gbenga and a respected one @egetex is your real fan
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks boss
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That among the limitation, any user whose name is not here is not using Nigeria on he/her location. @samstickkz
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Daddy epp ur son.
Sting me with ur bee pawa
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
They probably don't have the location tag. Well done sir.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You tried, but it's very inaccurate.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You cannot call it inaccurate. He used Sql. It is always accurate
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
wow, at least I made one of the lists( no of posts), lol...this is really good work @engrbrain1 ..cheers
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @davidekpin
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
you welcome
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
So i am not a Nigerian? Oh wow, my country now rejected me... SA i'm coming🚶🚶🚶🚶🚶🚶🚶🚶
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Searched fo you too mum
Did you use Nigeria as location in your profile?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I used planet but i still see those who didnt but were counted... Lol
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Lmao. Planet 😂
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
😫😪😂
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Sorry about that @sweetestglo-eu
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Its fine. :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
you will be in earth stat...yar international ..
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Lmao... 😂😫ok
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Lol
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
wow nice analysis...I wonder how you managed to come up with this.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I made a mistake upvoting you.. Lmao.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
How? I don't get...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wooow thank you @dante31 I will do well to implement all the corrections, am happy you visited my blog
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I appeared once. That means I'm doing something right. Nice work sir!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @the23chronicles
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great analysis @engrbrain1...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @hornblende
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
How did you manage to come up with this facts?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
He mentioned it here:
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Bless yhu
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great analysis keep it up brother.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @dayjee
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Could not find my name there but great work keep it up
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you sir am sure you will find it on the next one
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is quite beautiful.
Great work @engrbrain1
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @hpabiola
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Fascinating stuff. Good analysis - although it left me out because I used Naija instead of Nigeria as my location 😁
Also, I need to look into this SQL query thing. Seems like it's a very useful technique.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @edumurphy you can change it for next week own
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great analysis... Many people didn't make the list even when they were supposed to top many others. Well, probably because they not using the Nigeria location.
I must give it to you. Great effort
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I'm surprised that some sees this as a sort of contest. He presented data using SQL. In this regard only queried data, in this case Nigeria, would be the data that would be out for analysis. No data presentation is perfectly accurate, unless in rare circumstances. Even in blockchain, you may query a data of the biggest SP holders, as soon as you finished query, one whale may decide to buy 20,000,000 SP rendering whatever results you have inaccurate.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
It actually true @greenrun and that what has happened here.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @prechi
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I love this though it is not a true representation of activities of Nigerians on Steemit but it's something that's worthy of Commendations. Resteemed
@eurogee, the Host, Show Us Your Witnesses Weekly Contest
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you boss @eurogee I will try and make it a weekly post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice compliation @engrbrain...
Keep it up
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @alisonudeme dear
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good job. Rome wasn't built in a day. At least a good attempt at something great. If not perfect now, there is always a room for improvement.
Keep up the good work bro.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you sir
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Awesome,this is a very informative analysis. So profound. Good work. Can't help but keep smiling seeing @tojukaka among those toping the chat. Its encouraging, they all started somewhere. Im sure coming.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yes even me am happy for him @tojukaka he one of my boss
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey @engrbrain1,
This is really very good. You should have posted it on Utopian Analysis section.
I like to see unique posts like this from our community.
Keep steeming!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you sir I will do that one my next post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations! This post has been upvoted from the communal account, @minnowsupport, by engrbrain1 from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews, and netuoso. The goal is to help Steemit grow by supporting Minnows. Please find us at the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.
If you would like to delegate to the Minnow Support Project you can do so by clicking on the following links: 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP.
Be sure to leave at least 50SP undelegated on your account.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice analysis, smart work will always pay off. make sure your name is on the next list, lets all work together.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@akiripromise thank you
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wow...this is a whole lot of work,weldone @engrbrain1👏👏👏👏👏
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @mapetit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This analysis is awesome
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @marvel1206
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good job, you did so well...soon i will be @thetop *winks
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Sure you will be @facesteem with hard work
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wow, this is so great, found this analysis useful. Thumbs up.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @setapart
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That is really fascinating, keep it up.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @autofreak
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You must have done a great work getting out much details as this...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you @mr-aaron
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You did a great work. Nigerians are really doing very well on steemit.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This post has received a 0.09 % upvote from @drotto thanks to: @banjo.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Really amazing job here....
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great data analysis @engrbrain1 .working towards hitting to the top, Steemon!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hello, please follow the rules of the group Steemit for Resteem ↕ with more than 19000 members and you will be resteemed by the most active members in the group.
You have to resteem someone from the group and pay 0.15 steem or steem dollar to clixmoney and then post in the group and you will be approved, upvoted by clixmoney with an upvote worth 0.15 and active members of the group, and resteemed by other members.
If you pay 0.75 steem or steem dollar you get all of that + my resteem to more than 3000 followers and you don't have to resteem anyone in this case.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice work
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wow!
This must be stressful for you.
U did a great job here.
I must commend you
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit