The Brit List: March 2024

in Hive Statistics11 months ago

Introduction

beem to generate this post, but that is not in active development and I found HiveSQL could do it much quicker. I use Python for most things. 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 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. I was using

Logo by @barge

Discord to discuss it or drop me a comment.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 @teamuksupport

Those based in the UK can use the #teamuk tag for an extra vote. If you see people using it on non-relevant posts then drop them a friendly comment to point out that is not encouraged.

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.

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.

Previous editions

What it means

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

  • a list for the Netherlands using a version of my scripts. He improved the account levels chart and I have taken that code to use here.@michelmake does

Commentary

I was not sure if I would be able to put out the list this weekend as @hivesql has been out of action due to malicious hackers and I rely on it to get all the data. I am happy to report that @arcange has been working hard and it is back today.

Of course I ran my script to look for any Brits I might have missed. It found a few with a couple of false positives. Some people in Ukraine use UK as their location and place names can be duplicated, especially in the USA. It is not really worth making my script smarter as I can easily check these manually. I was able to add a few people to the list. A couple look like SEO attempts that usually seem to come via InLeo. I suspect someone is creating those accounts on behalf of clients. The are unlikely to post again, but I count them anyway.

The overall numbers are down a little despite some people coming back. We need to keep working to recruit new users and encourage the existing ones to stay active. Half the people in Wales who posted in January did not do so in February.

We gained an Orca and two Dolphins this time, so people are powering up.

I had another person ask to be de-listed and so moved them to the anonymous category. Maybe they do not want to be notified of these posts, but it will only be once each month. I try to avoid having to edit the posts as that would notify everyone again.

The Numbers

London and the South East (60/40/46)

Posting: @adetorrent (London), @alonicus (Hampshire), @andy4475 (Woking @andy-jahm @andy-vibes @andy-cine), @anna-newkey (Cambridgeshire @steve.and.anke), @assassyn (Reading), @awah, @basilmarples (Norwich), @benthomaswwd (Northampton @heartbeatonhive @benthomasuk @pulsation @pfsonhive), @benwesterham (Northamptonshire), @blockchainfpl (Eastbourne @the-gorilla @fplcanary), @bombaycrypto (London), @cezary-io, @charliesmith11 (Hampshire), @chris-uk (Norwich), @daniellemurray (Herts @radioliquorice), @dannyshine, @davidthompson57 (West Sussex), @devosdevosi (London), @donatello, @dubble (London), @dunsky (London), @edenmichelle, @elmerlin (London @liketu), @gillianpearce (Brighton), @goforma (London), @greenjhon (London), @greensmile, @has-k (London), @imfarhad, @jgiordi (London), @lloyddavis (@steemcampuk @lloyd-social), @maneco64, @maryanamurat (London), @mcsamm (Milton Keynes), @mhel (London), @michealclark (London), @mightyrocklee (Bedfordshire @heruvim1978), @molometer (@mopal London), @monivis (Chertsey), @nicklewis (Berkshire), @notaboutme, @purplesinger (Bedfordshire), @pvmihalache (Bedford), @raymondspeaks, @revisesociology, @risingstargame (@atomcollector @juxtamusic @jux), @robbieallenart, @samsmith1971, @sergiomendes (@thesassysergio), @spectrumecons, @steevc (Bedfordshire @tenkminnows @swing47), @stevermac1966 (Crystal Palace), @stickupboys (Brighton @stickupcurator @stickupcash), @stickupmusic (Brighton), @talesfrmthecrypt, @tdctunes (London), @teooo (Brighton), @tonybad (London), @ura-soul (Norfolk or elsewhere), @winkandwoo

Voting: @archatlas (Shoreditch), @audiohive-me (@riverstage), @bellou61 (Brighton), @bleepcoin, @blockchainyouth, @cryptogee, @cryptosneeze, @d3p0, @dashfit, @digna, @ezzy, @greatvideos, @holisticmom, @icepee, @ifeherart (London), @immarojas, @jaxsonmurph, @kaazoom (East Sussex), @kabir88, @liverehab, @matildamoment, @mattniblock, @nakedverse, @nanzo-scoop, @nicolcron, @pepskaram (London), @pizzadalek, @rafique, @redrica, @reviewed, @richardslater (Brighton), @rmsbodybuilding, @slayerkm, @stickchumpion, @stimp1024, @theessexfunko (Essex), @tricki, @trippymane, @wilfredn, @zoltarian

Inactive: @adamaslam, @bboxonhive (Northamptonshire), @beccss (London), @bettymorgan (London), @biggmusic (Brighton), @breadcentric (Bedfordshire), @brotherbhunru (St. Albans), @bxbridal (Watford), @carvalhochris (London), @chrinnox (Londom), @daine-cherry, @davvvespr (London), @dolphinartuk (Essex), @egilles (London), @eigeneggi (London), @frostdrop (Hampshire), @greendecoreuk (London), @jasonfarrelll (London), @jimwenda (London), @karwol (London), @knelstrom, @kph (Ipswich), @lifeofbrownshuga (London), @markangeltrueman, @ministickupboy (Brighton), @moemanmoesly, @neilxg (London), @nickyhavey, @oliveotamz (London), @onalazyday (London), @philsaatchi (Brighton), @queenoftheworld, @quentincc (London), @reviewer28 (London), @richlyblk (Shoreditch), @robpye (London), @sally-notbright (Kent), @sepehrheidarian (London), @stav (Norfolk), @steve-o2023, @stickupofficial1 (Brighton), @stormkeepergu (East London @stormkeepersmdk), @sudeginsiu (Brighton), @thecogent (London), @todayslight (Bedfordshire @roaminglewis), @wrobellek (Oxford)

The Midlands (15/8/13)

Posting: @alicjavfs (Birmingham), @article61, @bbphotography (Lincoln), @beautifulbullies (Nottingham), @belemo (Nottingham), @dannewton (@earthsea), @dawnsart, @dickturpin, @ellenripley, @fastchrisuk (Nottinghamshire), @jin-out (Birmingham), @neopch, @shanibeer (@susie-saver Leicester), @shmoogleosukami (Lincolnshire), @wolfofnostreet (Nottingham)

Voting: @kryptoe, @leighscotford, @michelle.gent (Sherwood Forest), @mscleaning (Birmingham), @skaarl, @snowboarderpete (North Lincolnshire), @tamiapt6, @zeeshannaqvi72

Inactive: @awakingelements, @bettynoir, @fizogphotography, @gribbles, @grottbags (Northamptonshire), @levelcompeteuk (Nottingham), @redfeend (Lincolnshire), @renaessanceman, @rimicane, @rthelly, @s0u1 (Nottinghamshire), @unkidrik (Lincolnshire), @vanbliss (Northamptonshire)

The South West (12/8/8)

Posting: @davidlionfish (Bristol), @diveratt, @dontcare89 (Newquay), @kathrynkw (Somerset), @livinguktaiwan (@lut-studio), @nockzonk, @pompeylad (South Coast), @riverflows (Somerset), @stevienics (Truro), @stuartcturnbull (Cornwall), @theworldaroundme, @ukbitcoinmaster

Voting: @blade7 (Cornwall), @countrysid (Somerset), @cubapl (Bristol), @grizzle, @jimbobbill, @sharpshot, @thomaskatan, @wolven-znz

Inactive: @francesleader (Dorset), @groovy828 (Cornwall), @killerkev (Bristol), @leafculture (Exeter), @newtonclassics, @nurseflo (Bath), @perceptualflaws, @snakelicker (Cornwall)

The North (18/19/21)

Posting: @alessandrawhite (USA and Leeds), @bobbylewis2002 (Rotherham), @c0ff33a (Halifax @whiterosecoffee @teamuksupport), @chisdealhd (Newcastle Upon Tyne @alloyxuast @thencsshifters @chisfund @alloyxuastcur @chisuploads), @dadspardan, @darrenflinders, @davidwilson01 (Manchester), @demotruk (Isle of Man), @karenb54, @keithtaylor (Shipley Yorkshire), @llag, @onw (@b8l), @pcste, @planetauto (Lancashire), @raj808 (Liverpool), @slobberchops, @socialmediaseo, @youloseagain (Yorkshire)

Voting: @ambrosechappel (Southport), @artonmysleeve, @bingbabe, @cryptocurator, @digitaldan, @dismayedworld, @goblinknackers, @jphamer1, @jskitty, @lastravage, @makerhacks (York), @makrotheblack (Liverpool), @mattbrown.art (Isle of Man), @richgaynor, @someguy123, @steddyman, @stevenwood, @viajeracebuana (Berwick-Upon-Tweed), @yunnie (Isle of Man)

Inactive: @alanwood (Yorkshire), @ashtv (Yorkshire), @dizzydiscovery, @fabrications (Sheffield), @iamdarrenclaxton (Derbyshire @darrenclaxton @mrbloom), @inksurgeon (Sheffield), @introvert-dime, @johnmatthias (Sheffield), @leetodd, @mckeever, @oliviaava (Manchester), @osohotwater (Gateshead), @paritae (Newcastle), @powertherm (Sheffield), @rob-c (Heywood Greater Manchester), @sam1965uk, @sisygoboom, @streetwize (Bradford), @teamhumble, @thebudfather (Stockport), @vibeof100monkeys (Lancashire)

Scotland (10/10/7)

Posting: @actaylor (Edinburgh), @camuel (@acousticguitar), @celticheartbeat (@jubei333), @eveningart (Orkney), @hoosie (Edinburgh), @joshuaslane, @kevmcc, @meesterboom (@b00m), @slothlydoesit (Edinburgh @slothbuzzcurator @slothbuzz @sloth.buzz @slothburn ), @tengolotodo (@tengogaming @tengolotodo.leo)

Voting: @barge (@krunkypuram), @btcvenom, @cadawg, @fiftysixnorth, @howiemac, @myskye, @natubat, @rafalforeigner, @sc0tsman (Fife), @wisbeech

Inactive: @acidtiger, @agrestic, @beardoin, @cottonlazarus (Edinburgh), @danaidhbee, @gguy773, @shannar (Eyemouth)

Wales (3/4/9)

Posting: @cassi, @grindle, @welshstacker

Voting: @gazbaz4000, @nozzy, @stevelivingston, @theturtleproject

Inactive: @alishas, @decourceys (Cardiff), @jonboka, @louisthomas, @newlifeninja, @p-props, @pumpkinsandcats, @realitymaster (Swansea), @ruckmesideways

Northern Ireland (2/0/3)

Posting: @silverstackeruk, @strega.azure

Inactive: @besold, @enzibatavia, @northernheretic

Somewhere in the UK... (24/39/35)

Posting: @alzee, @artysteps, @brofund (@brofund-1up), @brucegryllis, @candy49, @charliesmith11, @collinz, @danwhodoesart, @fantagira, @frugal-fun, @gonzo, @heartsofoakuk (England), @jmehta, @kirhyip, @learningpages, @millycf1976, @music-beatcz, @nockzonk, @nooblogger, @platinum-blue, @royalestones, @scubahead, @tobias-g, @vtravels

Voting: @alheath, @anarchojeweler, @bigjammin (England), @blue.panda, @britcoins (England and SE Asia), @brothershield, @cryptosneeze, @cynicalcake, @damianjayclay, @ddsexyauto, @english-ant, @eternalsuccess, @filmmaking4hive (England), @haitch, @hive.curation, @hopehuggs, @iansart, @imbartley, @imbritish, @johngreenfield, @kennybobs, @lefty619, @ninjakitten, @owenwat, @realjohnaziz, @rmcaesthetics (England), @rokasimir, @steemboat-steve, @stephyymullen, @stevieboyes, @stickupfilm, @tazbaz, @tggr.trb, @thedeltron (England), @tkolpaczek, @tomatom, @trading-tokens (England), @utopia-hope (England), @webdeals

Inactive: @amadea, @amidlifecrypto, @anarcodave, @b1tm31st3r, @basejumper (@bitcoinbeast), @brianhphotos, @british-bulldog, @clivemartin, @coincerberus, @elliotjgardner, @feralblowfish, @forbesdav, @foundabargain, @freespiritwriter, @goldstreet, @ibadullah, @immigrationlaw1, @incojim, @karolsongin, @lordavatarii, @marcusbraeburn, @mumshies, @primaudia, @quickthen, @quirk-it, @remystar93, @rogeredwards, @sirens-lust, @sparkyontherum (@sparkyontherun), @sterlingux, @stewielockwood, @thencsshifters, @tommyrobinson, @triority, @zedcell

Anonymous (2/0/0)

Some people ask not to be listed, but they will still be counted

Expats (22/6/8)

Posting: @abdex9, @abh12345 (Spain), @adambarratt (@abtv Spain), @annasworddancer (Mallorca), @atma.love (Bulgaria), @cryptoandcoffee (South Africa), @ctrpch (Australia), @eco-alex (Planet Earth), @elricmoonslayer (Spain), @felt.buzz (France), @hadrianwild (Thailand), @hirohurl (Japan), @mangomayhem (Philippines), @minismallholding (Australia), @momogrow (Netherlands), @namiks (Armenia), @nathen007 (@leedsunited Thailand), @samstonehill (France), @sebcam (USA), @starkerz (Cyberspace), @sunsethunter (New Zealand), @trucklife-family (The Earth)

Voting: @accelerator (@rycharde Thailand), @biggypauls (Philippines), @eftnow (Spain), @juliamulcahy (Ireland), @tggr (Singapore), @willmington-w (Philippines/UK)

Inactive: @chewsk1 (Gibraltar), @cristina-zac (Spain), @jeffandhisguitar (SE Asia), @justinchicken (Japan), @newtonclassics (Thailand), @ripebanana (Trinidad and Tobago), @shepz1 (Poland), @wanderlust7 (Canada)

Totals

Total active UK: 146, Expats: 22

Charts

This shows the numbers in each category of the active and voting accounts. Level is based on 'VESTS' with Minnow equating to a million VESTS.

Levels

Minnow is currently at 576 HP.

This shows when people joined Hive. The last few months are shown separately to make any changes obvious.

Ages

AgeNumber
1 month4
2 months0
3 months1
Year10
Older287

UK Witnesses

Please support your local witnesses:
@liketu, @ura-soul, @shmoogleosukami, @c0ff33a, @whiterosecoffee, @chisdealhd, @someguy123, @cadawg, @brofund, @ctrpch

The man behind:

@tenkminnows: Helping good Hivers level up @proofofbrian: A bot that checks for tag typos #BritList: A monthly list of Hivers in the UK
Sort:  

Hello to all uk expats. I am living in oz, also very close to making orca. Perhaps next month I will.

If anyone has spare witness votes please send them over. I appreciate all of them.

Voted. All the best @ctrpch.

Thank you

Per usual, well done @steevc - always a great #BritList summary. 💫 And glad you found a solution to the hacking problem! But sad to learn the issue with HiveSQL is still on the periphery... Why some people feel the need to corrupt a good thing, I have no idea...

I think anyone running an online service is at risk as the crooks will try to extort money from them. It's not like HiveSQL is a massive earner, but we need it. I am hoping this encourage more people to look into decentralising it.

@riverflows is currently UK, thougj you'll need to check on permanence

I have them on the list. I have to rely on people to tell me if they move.


Always a good read and interesting that we have a few new accounts.
!ALIVE
!COFFEE
!LOLZNice work @steevc 👏

You just received 0.05 COFFEE! Good coffee my friend

number of commands left: 0

If you also want to send COFFEE buy them here on hive-engine

You Are Alive so I just staked 0.1 $ALIVE to your account on behalf of @ davidthompson57. (1/20)@steevc!

The tip has been paid for by the We Are Alive Tribe
through the earnings on @alive.chat, feel free to swing by our daily chat any time you want, plus you can win Hive Power (2x 50 HP) and Alive Power (2x 500 AP) delegations (4 weeks), and Ecency Points (4x 50 EP), in our chat every day.

Want to here a joke about pizza?
It's a little cheesy.

Credit: boboman
$LOLZ on behalf of davidthompson57

(1/10)
ENTER @WIN.HIVE'S DAILY DRAW AND WIN HIVE!@steevc, I sent you an

Great that @HiveSQL is back @arcange & @steevc. Well done!

A lot of things depend on it. Some projects may look to have their own server after this incident.

I reckon it would be good if there was a way for HiveSQL to have multiple copies in some way, to provide redundancy if (or when) this happens again. With any luck it might save @arcange a huge amount of work (which I know we all appreciate !)

I'm not technical enough to know if there's a way to create an air-gapped copy with more recent data uploaded a couple of times a day after enough time had passed to intercept any hacks or other issues. It might mean less data to reconstruct. But I'm thinking like a mechanic not an IT person, so I could be totally wrong, lol.


Without going into details, the HiveSQL infrastructure has been completely revised to improve it, particularly in terms of backups. This might be the subject of a future post, if I find some free time.

Thank you for your kind words @alonicus.

Thank you ! If I was you'd I'd have the mother of all lie-ins, and maybe a holiday, after what you've just had to go through 😁 Posts about stuff like that are interesting, but can wait until you've recovered a bit....

Yes, a good rest is definitely in order.

It ought to be possible to run multiple servers. I expect arcange has reviewed his backup strategy. You need offline copies to be safer as these crooks are cunning.

I expect arcange has reviewed his backup strategy.

Done! ✅

I was going to write that @alessandrawhite might be a more permanent fixture there, but I see you have already accounted for her. Still leaving the comment as I am too bored to backspace :D

You two are hilarious!

Thanks for the information
I hope I get to see the Nigerian list someday

As I have said before, if someone compiles the list then I can help produce a post like this. Things don't happen unless someone takes the initiative. Hoping doesn't get it done :) Talk to the Nigerian community to make it happen.

Very useful information,