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.
We have another decrease in the active user numbers again, but then I have met up with a few Brits recently and that gives me hope. I have said many times that a meetup just needs a time and a place. A few weeks ago three of us met up in a London pub and it was fun.
I had to put in some work to get the post done this month. I reinstalled Linux on my PC recently and needed to get back the database access required for @hivesql. I managed to sort that out, but then some parts of the script were not working. Those were using the beem library that is no longer supported, so I re-wrote them using HiveSQL. Not only did that fix it, but it also made it much quicker and so I can generate the list in under two minutes. I will update the code on GitHub for others to use. I think it is useful to get lists for different countries so people know who is around and active. I do not have the time and local knowledge to compile those lists, but I could help to generate the posts.
The $HIVE price is not great now, but we can be earning every day. You can show your support on the price list sites to give a good impression. I know on @coingecko you can only vote every few days.
This will be the last #britlist of 2025. I hope 2026 will bring better times for Hive, but that is up to us all.
@bencwarmer has done a more comprehensive list.
@michelmake
@proofofbrian