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

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:

Method: SQL queries + Excel 2013 (See here).

Bless yhu

Nice compliation @engrbrain...
Keep it up

Great analysis keep it up brother.

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

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.

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!

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.

Wow...this is a whole lot of work,weldone @engrbrain1👏👏👏👏👏

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.

That is really fascinating, keep it up.

You must have done a great work getting out much details as this...

You did a great work. Nigerians are really doing very well on steemit.

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