Introduction
This post is my attempt to provide some insight in the Dutch Hive community. All the data is extracted using the @HiveSQL API and my own flavour of the Jupyter notebooks @steevc provides on his
GitHub. Hence this post is actually inspired by his Brit list posts.
I took the curtesy to create some sort of logo inspired, by the one used in the regular Brit List posts (I hope you don't mind Steve..).
Dutch Users by Province
To see how the users are distributed over the country they are ordered by province. The image below shows the provinces in the Netherlands. Note that not all users have set a city or province. In that case they are listed separately. At a later stage I might also add the special municipalities in the Caribbean. Let me know if you are from that region if you want to be added.
The Netherlands and its 12 provinces. Image source: wikikids.nl
The list below contains all users that voted or posted in the past year. Inactive users have not done so in the past month and are not listed but only counted in the totals.
Noord Holland (Active: 1/2)
Posting (1):
@wikaatje (Haarlem, The Netherlands )
Voting (2):
@petrajordan (Amsterdam, Netherlands)
@roelandp (Amsterdam, NL)
Zuid Holland (Active: 4/4)
Posting (4):
@brittandjosie (ROTTERDAM, the Netherlands)
@marjoleinsch (Saint Hippolyte du Fort, France et Leiden, The Netherlands)
@waltermulder (Rotterdam)
@zippy1975 (Rotterdam, Netherlands)
Voting only (4):
@elbrava (Zoeterwoude, the Netherlands)
@greendeliverence (Den haag, Netherlands)
@greendelivernl (den Haag, the Netherlands)
@k64 (The Hague, the Netherlands)
Overijssel (Active: 2/0)
Posting (2):
@erikklok (Hengelo, Netherlands)
@invest4free (Vriezenveen, the Netherlands)
Voting only (0):
No actively voting users in this region
Noord Brabant (Active: 0/0)
Posting (0):
No actively posting users in this region
Voting only (0):
No actively voting users in this region
Utrecht (Active: 1/0)
Posting (1):
@edb (Utrecht, Netherlands)
Voting only (0):
No actively voting users in this region
Groningen (Active: 0/1)
Posting (0):
No actively posting users in this region
Voting only (1):
@oaldamster (Winschoten, Oldambt, Nederland)
Limburg (Active: 1/0)
Posting (1):
@michelmake (Limburg, The Netherlands)
No actively posting users in this region
Voting only (0):
Anywhere else in NL (Active: 29/20)
Posting (29):
@blockchainboyroy (Netherlands)
@chatgptxonlinenl (Nederlands)
@cooperclub (Netherlands )
@dboontje (Netherlands)
@eijffelbridge (The Netherlands)
@fernwehninja (Netherlands)
@friendlymoose (The Netherlands)
@ftlob (Netherlands)
@haastrecht (Netherlands)
@heygio (The Netherlands)
@karinxxl (Netherlands)
@leelektrik (Netherlands)
@loonatic (the netherlands)
@meraki7578 (The Netherlands)
@mightyluna (The Netherlands)
@nozem01 (The Netherlands)
@oudekrijger (Netherlands)
@patrycjabart (The Netherlands)
@pibara (Netherlands)
@pieternijmeijer (The Netherlands)
@primalamusica (The Netherlands)
@pundito (The Netherlands)
@soyrosa (The Netherlands)
@stresskiller (Netherlands)
@vazthink (Netherlands)
@vindiesel1980 (Netherlands, Germany, Portugal)
@wappie (The Netherlands)
@littlebee4 (Ireland)
Voting only (20):
@casting-metal (Netherlands)
@crypto-econom1st (Netherlands )
@dutchchemist (Netherlands)
@guchtere (Netherlands)
@jager567 (The Netherlands)
@larkin36 (The Netherlands )
@lion200 (The Netherlands)
@mavassie (Netherlands)
@minigunner (the Netherlands)
@misterro (Netherlands)
@musicapoetica (Netherlands)
@nobyeni (Netherlands)
@p4ragon (The Netherlands)
@sanderjansenart (Netherlands)
@sinzzer (Netherlands)
@slacktmusic (Netherlands)
@smasssh (Netherlands, Sweden and France)
@steef-05 (Netherlands)
@tijntje (the Netherlands)
@wazza84 (The Netherlands)
Totals
Total active Commenting: 37, Voting Only: 27, Inactive the past year: 27
Charts
To give some insight into the size of the active accounts and how old the accounts are, some additional stats are given below. First the number of accounts of the individual Hivebuzz levels are given below, where the levels are based on the number of VESTS:
| Level | Number | Threshold |
|---|---|---|
| Redfish | 34 | |
| Minnow | 17 | 573.70 HP |
| Dolphin | 10 | 5737.02 HP |
| Orca | 2 | 57370.17 HP |
| Whale | 0 | 573701.69 HP |
Next the total number of accounts by age of the Dutch users is given below. Here also inactive accounts are accounted for. It clearly shows that we could improve on user growth in the Netherlands. Assuming my scripts are bug free of course :D
| Age | Number |
|---|---|
| 1 Month | 0 |
| 2 Months | 1 |
| 3 Months | 0 |
| Year | 2 |
| Older | 60 |
Final Note
The metrics in this post were generated in a semi-automated fashion. The lists was generated based on the given location of the individual accounts. Accounts that do not have a location specified, obviously, are not taken into consideration. There are for sure more Dutch users within the Hive ecosphere. If you are not on the list and want to be added, just let me know. The same holds for the other way around. If you would like to be removed, just let me know :)