HIVE user counts by countries based on profile location data

I prepared this analysis result a couple weeks ago but haven't published since we have been quite busy recently working on ecency. It's better to publish before i forget this small project ever existed :)

Analysis result is based on "location" field in account data.

Although not all users fill that field or some of them enter non-location text, the result provides a general overview.

Input

Data source comes from hivemind's db with query below:

SELECT location from hive_accounts where location != '';

Result dataset size was 249465 while i was working on the project.

Code

Project source code is here. It uses geopy and OpenStreetMap's Nominatim API for location detection from raw text.

You can see lots of caching mechanisms in code. Since it is a long running script, i didn't want to start over to data collection from zero every time it crashes or stalls.

It took almost 32 hours to complete it at background and extracted 234117 country out of raw dataset.

Result 🎉

Of course US in the top of the list. Surprisingly Venezuela is second. Also Turkey surprised me. It is quite top of the list. I didn't know that amount of users from my country around here.

Hive on!