I started compiling these lists in December 2020 to continue something @pennsif used to do as I think it helps bring the community together. Since then I have found lots more people to include. @HiveSQL has been really useful for this and I use Python for my scripts. Some of the post is manual as I like to include some commentary and I will keep tweaking it. I am open to suggestions for improvements. I aim to do a fresh list on the first Saturday of each month.
I also rely on the community to let me know of more people to include who may not have obvious account metadata. You can find me in the @teamuksupportDiscord to discuss it or drop me a comment.
The #teamuk tag has been used to show you are in the UK and was earning extra votes from a bot, but that has not been active lately. Using the tag may still help me to find you, but please contact me if you think you should be on the list.
The list will include anyone living in the UK as well as Brits who have moved abroad. Inclusion on this list does not mean I recommend people, but I will remove accounts if they are known to be abusing Hive or are falsely reporting their location. I can also remove anyone who asks me to. If you have lost control of your account through phishing or other means then let me know so that I can update your entry. There is the option to be counted without being tagged on these posts if you want that.
The code to produce this post is on Github. People are welcome to use it for their own regional version. I can help you with that if necessary.
The numbers above are for those who had posted or commented in the previous month. In the lists below I break each region into three lists:
Active as above.
Just voting. I will guess that a lot of these use automatic votes, e.g. HiveVote. Previously there were some that appear to have been compromised as they vote for known abusers. Those are now excluded until I hear that they have recovered control.
Inactive in the last month, but most have done something since Hive started. We can hope to bring them back.
I want to count people rather than accounts as some have several. I can include those in brackets if you want. Let me know if you want me to update your listing. You can be as specific as you like about your location. Otherwise I will use what is on your profile or what I am told or can deduce from your posts.
Other Countries
I have produced similar lists for the following countries. Active numbers are from the last time I ran them. These have used simpler queries than what I use for the UK, so they are likely to miss people. What it needs is for local communities to take up this work. The data and scripts are all on my Github for anyone to make use of. I can do other lists on demand.
I expect the low $HIVE price is having some impact on whether people stay active. We have not been under 100 since I started doing this list and I have found a lot more people since then. I have about 900 in my file and the script checks each of them for activity.
The good news is that we have a UK whale again and I think someone else became an orca. A couple more people joined, but one of those created a new account as they lost their keys after years of inactivity. As always we are in need of new people as well as keeping the existing ones engaged.
I know Hive has various issues, but I see it as a good alternative to some other platforms. We have a lot of freedom here and anyone can build on it. We are seeing lots of new games and apps lately with ongoing development on the established ones so people obviously feel it is a good place to develop. We have lost @risingstargame, but it is planned to get it going again with fresh code.
I know this post is a bit late, but I just got a new PC and had some issues getting the script working. To access @hivesql I needed to install the Microsoft ODBC SQL package on Ubuntu Linux and there were some extra steps to that this time. I have to say that the script runs really quickly now (less than a minute), so it does not seem that HiveSQL was the bottleneck.
@bencwarmer has done a more comprehensive list.
@michelmake
@proofofbrian