What Cities Have the Most Hive Users

And which have the most potential for Hive?

I have explored similar questions before when I wanted to determine where Hive has the highest penetration rate, but I was thinking today to consider looking more comprehensively at the cities where Hive has a high number of users, so we can see where Hive has the greatest potential to get going. A high penetration rate is a prerequisite for the kind of project that has been going on in Sucre, Venezuela, and perhaps in the near future we will want to replicate that.

The chart below was created with the same query from my post about dormant users earlier today (that post was a side outcome of this one). After ranking all locations by active users, I started to eliminate every location that is not either 1) a city or 2) a province or county-level administrative region in the top 100 or so. I then merged duplicates until I had a top 30 such regions. As a consequence, Maracay features both as a city and a region (Aragua). Aceh, Indonesia also features as a prominent region for Hive.

Apologies for the janky addition of national flags.

If we include inactive users, the ranking changes quite a bit. Aceh, Indonesia starts to stand out as somewhere we once had a large userbase (before the split).

In general, I believe penetration rate is a more useful metric for Hive cities. To get the below chart, I multiplied the active user rate by 5 (an estimate based on how many users include a profile location), and I divided by the population (figures provided by wikipedia, I took the metropolitan area population figure whenever possible).

As has been identified before, Cumaná is by far and away the leader in terms of penetration rate. The runners up are quite interesting though... Brighton??? Cebu also stands out for its penetration rate - unlike Cumaná it is quite a large city and a large population center, which works against it for this metric.

Edit: based on feedback from Hive account@philnews.xyz and rechecking the population statistics for Cebu, here is a revised chart. Cebu drops from 3rd to 7th place with the larger population statistic assuming the Hive userbase is spread across the province as a whole.

When we look at the penetration rate including all users, active or not, the ranking shifts again. Aceh leads overall, Cumaná stays near the top, but Uyo Nigeria is an unexpected result.