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 provides on his
GitHub. Hence this post is actually inspired by his Brit list posts.
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 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.
Posting (1):
(Haarlem, The Netherlands )
Voting (2):
(Amsterdam, Netherlands)
(Amsterdam, NL)
Posting (4):
(ROTTERDAM, the Netherlands)
(Saint Hippolyte du Fort, France et Leiden, The Netherlands)
(Rotterdam)
(Rotterdam, Netherlands)
Voting only (4):
(Zoeterwoude, the Netherlands)
(Den haag, Netherlands)
(den Haag, the Netherlands)
(The Hague, the Netherlands)
Posting (2):
(Hengelo, Netherlands)
(Vriezenveen, the Netherlands)
Voting only (0):
No actively voting users in this region
Posting (0):
No actively posting users in this region
Voting only (0):
No actively voting users in this region
Posting (1):
(Utrecht, Netherlands)
Voting only (0):
No actively voting users in this region
Posting (0):
No actively posting users in this region
Voting only (1):
(Winschoten, Oldambt, Nederland)
Posting (1):
(Limburg, The Netherlands)
No actively posting users in this region
Voting only (0):
Posting (29):
(Netherlands)
(Nederlands)
(Netherlands )
(Netherlands)
(The Netherlands)
(Netherlands)
(The Netherlands)
(Netherlands)
(Netherlands)
(The Netherlands)
(Netherlands)
(Netherlands)
(the netherlands)
(The Netherlands)
(The Netherlands)
(The Netherlands)
(Netherlands)
(The Netherlands)
(Netherlands)
(The Netherlands)
(The Netherlands)
(The Netherlands)
(The Netherlands)
(Netherlands)
(Netherlands)
(Netherlands, Germany, Portugal)
(The Netherlands)
(Ireland)
Voting only (20):
(Netherlands)
(Netherlands )
(Netherlands)
(Netherlands)
(The Netherlands)
(The Netherlands )
(The Netherlands)
(Netherlands)
(the Netherlands)
(Netherlands)
(Netherlands)
(Netherlands)
(The Netherlands)
(Netherlands)
(Netherlands)
(Netherlands)
(Netherlands, Sweden and France)
(Netherlands)
(the Netherlands)
(The Netherlands)
Total active Commenting: 37, Voting Only: 27, Inactive the past year: 27
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 |
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 :)