The hottest authors to follow - by data

Image: shedquarters, CC0

There were a couple of posts lately about finding decent authors to follow and a lot of lists with various great author were filled (and hopefully followed). Let's take another approach here: why not check the blockchain data to find out who gained the most followers lately?

Wisdom of the crowd, what could possibly go wrong?

Boy, was I wrong...

Here's the list of the top 20 accounts that gained the most followers since Oct. 1st 2019, so within the last ~8 weeks:

Author new followers
steemyoda 1594
raise-me-up 1106
voteme 735
tipu 701
marcusmalone 654
sp-group 642
therising 562
dtube 552
anomaly 534
merlin7 527
followforupvotes 511
haccolong 489
pasie15 481
crypto.piotr 471
hoaithu 470 468
aekraj 464
puncakbukit 463
tuanis 459
big-whale 447

There we go, highly dominated by bots. Help me - Which is the highest ranked "human" account in this list?

  • steemyoda has ~700k SP, hasn't posted for months and has a buggy bot script but seems to give out generous votes. but 1500+ follows based on this?
  • raise-me-up/voteme/tipu/therising - maybe also follows due to votes given out?
  • marcusmalone wasn't posting for months and seems to run a script to follow anybody, which may get them follow-backs
  • sp-group: a polish curation group - is this the winner here?
  • dtube: no need to explain I guess
  • anomaly and merlin7 look like curation bots
  • followforupvotes and haccolong: follow for upvotes...
  • pasie15: their daily inspirational quote certainly isn't the reason for 400+ new followers...

OK, this approach didn't work very well - at least not to find authors worth to follow :D

This post was possible with the free hivemind database access given out by @emrebeyler:

Thanks a lot for this!

Hivemind stores all follow and un-follow operations in a table called hive_follows, with the state (follow/unfollow), the user ids of following and followed account as well as a timestamp. Here's the query used to get the top 20 list above:

select, count( as following, hive_follows."following"
from hive_follows 
join hive_accounts a1 on hive_follows.follower =
join hive_accounts a2 on hive_follows.following =
where hive_follows.created_at > '2019-10-01' and hive_follows.state = 1
group by a2."name", hive_follows."following"
order by count( desc
limit 20; 

Note that this query might double-count situations where users follow another account while already following it or unfollow->follow situations.

Any particular data you'd like to see from a hivemind DB access? Leave a comment below and I'll evaluate.

Comments 23

To listen to the audio version of this article click on the play image.

Brought to you by @tts. If you find it useful please consider upvoting this reply.

23.11.2019 13:41

Nice one @crookon!
Emrebeyler was nice and gave me access to the database as well, but havent test yet :) Hope to do it soon.

Your results are interesting .... not want we want :)
I think authors with the most comments are maybe something to recomend.... Will try to do something like it

23.11.2019 13:53

thanks @dalz! Most comments is tricky, that is likely very much biased by bots... You might have to apply some kind of blacklist. Looking forward to your results!

23.11.2019 13:56

Yes ... a lot of comments by bots as well... some workaround will be needed!

23.11.2019 14:47

Have you seen my comment bot API?

30.11.2019 07:59

oh great! will have a look, thanks!

01.12.2019 14:44

Follow the money?!

23.11.2019 14:54

certainly! who knows, maybe it helps? Most of the bots don't post anyway, so no garbage in the feed... :D

23.11.2019 16:47

Used to converse with @merlin7, but that’s only possible off chain.

@crypto.piotr is likely the most human one out there. Then, it’s @hoaithu, which is linked to @haccolong. They both comment back if you talk to them.

23.11.2019 16:13

oh, thanks for the additional info! I agree on crypto-piotr, he's very active with comments and memos.

23.11.2019 16:53

So is there anyway to see who are the real humans that have gained the most followers? Maybe by looking at their posts and comments that are not automated content?

23.11.2019 18:00

I think it's hard to come up with an algorithm which can detect that. There are a couple of 'blacklists' out there which list known bots and I think steemplus also has a classification built in. Combining follower data with those lists may give a better picture. But maintaining those lists is tedious, so they are not necessarily always up to date.

23.11.2019 18:18

Thanks for the data... I think I have 1 or 2 new followers since october, haha... no more people around?!? Maybe I'm too weird, hahahaaaaa

23.11.2019 18:32

Make that 2 or 3 now ^_^

23.11.2019 18:39

Hahaha, yeah!!! My goal is 2020 followers by 2020... but it's kind of impossible in these days :-(

23.11.2019 18:43

you actually had 24 new followers since October - all others must be following you already ;)

23.11.2019 18:46

Oh not that bad... 2k is closer, oh yeah :-)
Thanks for the accurate numbers.

23.11.2019 18:49


23.11.2019 22:13

View or trade BEER.

Hey @steemitri, here is a little bit of BEER from @freebornangel for you. Enjoy it!

23.11.2019 22:13

Why are you flagging me?

29.11.2019 19:00

my account is trailing @steemflagrewards. These guys usually have a reason for calling the trail.

29.11.2019 19:29

Look at my last hidden post you and others flagged. I guess if i do not write a novel @jacobtothe is going to report me if I am upvoted wasting a few pennies of the reward pool cause he dislikes me or just a bully like @azircon who flagged this comment. @azircon you may need to give 100% bully power my comments are resurfacing....

29.11.2019 19:34