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
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!
Thank you sir I will do that one my next post
How did you manage to come up with this facts?
He mentioned it here:
Bless yhu
Nice compliation @engrbrain...
Keep it up
Thank you @alisonudeme dear
Great analysis @engrbrain1...
Thank you @hornblende
Great analysis keep it up brother.
Thank you @dayjee
Could not find my name there but great work keep it up
Thank you sir am sure you will find it on the next one
This is quite beautiful.
Great work @engrbrain1
Thank you @hpabiola
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.
Thank you @edumurphy you can change it for next week own
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
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.
It actually true @greenrun and that what has happened here.
Thank you @prechi
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
Thank you boss @eurogee I will try and make it a weekly post
I appeared once. That means I'm doing something right. Nice work sir!
Thank you @the23chronicles
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.
Thank you sir
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.
Yes even me am happy for him @tojukaka he one of my boss
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.
Nice analysis, smart work will always pay off. make sure your name is on the next list, lets all work together.
@akiripromise thank you
Wow...this is a whole lot of work,weldone @engrbrain1👏👏👏👏👏
Thank you @mapetit
Good job, you did so well...soon i will be @thetop *winks
Sure you will be @facesteem with hard work
Wow, this is so great, found this analysis useful. Thumbs up.
Thank you @setapart
That is really fascinating, keep it up.
Thank you @autofreak
You must have done a great work getting out much details as this...
Thank you @mr-aaron
You did a great work. Nigerians are really doing very well on steemit.
Thank you
This post has received a 0.09 % upvote from @drotto thanks to: @banjo.
Really amazing job here....
Great data analysis @engrbrain1 .working towards hitting to the top, Steemon!
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.
Nice work
Wow!
This must be stressful for you.
U did a great job here.
I must commend you