create account

A little rant about analyzing location data by demotruk

View this thread on: hive.blogpeakd.comecency.com
· @demotruk · (edited)
$8.69
A little rant about analyzing location data
The United States *should* be almost the size of the largest (if not **the** largest) bubble on this chart of Active Hive users per Country in February, but for the fact that I haven't fully accounted for the myriad of ways US Americans represent their locations in their profiles.


![5s4dzRwnVbzGY5ssnCE4wXzkeAEXyVtgk1ApQTwHMTp6y5PvEo1yenn97zWGHTMV6VQN7gfuAEdaVYmZajhSptxBC1FTh5jkSEpUTZLvDAbU4Mcz2a5SLnXunqPAmbqZMPLen9hXH9883QuPqGDmqfkakUQDnhGpUFfqGia.png](https://files.peakd.com/file/peakd-hive/demotruk/23tmmjqSSj4tLXYoVk1c1pWc58JbidppJxYwp9zfUJZu1WZXtw25Rm58uKX7bkYiTYvia.png)


Before I continue, please let me preface my rant that I do not fault users for how they choose to represent their location. The 'location' field in the user profile is not primarily intended for analytics, it is simply a way of representing your location (true or fictional) to fellow users on the site. In truth my frustration here comes from the complexity of converting data intended for humans into something that can be organized and parsed by queries in a spreadsheet. I expect it would be easier with the assistance of a Chat-GPT subscription.

Anyways, aside from the differences between...

America,
United States of America
US
USA
U.S.A.
etc.

... there's the fact that most US Americans appear not to even mention the name of their country in their location. They are more likely than people nearly everywhere else to just mention their state or even just their city. As such, the bubble for the USA in this chart only represents 272 users, where I suspect if I combined all the state, city and even broad US locations like "midwest" in the raw data, it could easily double that.

If you're interested, here's a bar chart of the top 20 countries in the same dataset. Also a usual caveat that most users don't have location data in their profiles at all.

![Top 20 Countries.png](https://files.peakd.com/file/peakd-hive/demotruk/23uRL6YZfcEyWquGEg9zFR6nPEzhnupVQe4kDieQoYcJq7YcdhjCa2WgTLi2Se1VEuyxX.png)

It is quite noteworthy that 5 South American countries are present in the top 20, despite the fact that South America only has 1 country among the top 20 most populace in the world (Brazil). Hive's center of gravity is moving ever more towards South America.
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
authordemotruk
permlinka-little-rant-about-analyzing-location-data
categoryhive-133987
json_metadata{"app":"peakd/2023.3.5","format":"markdown","tags":["hive","statistics"],"users":[],"image":["https://files.peakd.com/file/peakd-hive/demotruk/23tmmjqSSj4tLXYoVk1c1pWc58JbidppJxYwp9zfUJZu1WZXtw25Rm58uKX7bkYiTYvia.png","https://files.peakd.com/file/peakd-hive/demotruk/23uRL6YZfcEyWquGEg9zFR6nPEzhnupVQe4kDieQoYcJq7YcdhjCa2WgTLi2Se1VEuyxX.png"]}
created2023-03-30 19:24:36
last_update2023-03-30 21:02:15
depth0
children15
last_payout2023-04-06 19:24:36
cashout_time1969-12-31 23:59:59
total_payout_value4.350 HBD
curator_payout_value4.341 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2,259
author_reputation268,382,980,896,242
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,118,268
net_rshares15,692,138,550,873
author_curate_reward""
vote details (46)
@cst90 ·
$0.41
I feel like the Netherlands were once a big community, but I guess that changed.
👍  , ,
properties (23)
authorcst90
permlinkre-demotruk-2023330t2275872z
categoryhive-133987
json_metadata{"tags":["hive-133987","hive","statistics"],"app":"ecency/3.0.39-mobile","format":"markdown+html"}
created2023-03-30 20:07:06
last_update2023-03-30 20:07:06
depth1
children1
last_payout2023-04-06 20:07:06
cashout_time1969-12-31 23:59:59
total_payout_value0.205 HBD
curator_payout_value0.205 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length80
author_reputation6,426,088,801,975
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,119,504
net_rshares741,711,599,826
author_curate_reward""
vote details (3)
@demotruk ·
24 active in February, but I haven't pulled historic data for comparison.
properties (22)
authordemotruk
permlinkre-cst90-rscpqy
categoryhive-133987
json_metadata{"tags":["hive-133987"],"app":"peakd/2023.3.5"}
created2023-03-30 20:47:21
last_update2023-03-30 20:47:21
depth2
children0
last_payout2023-04-06 20:47:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length73
author_reputation268,382,980,896,242
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,121,104
net_rshares0
@djbravo ·
Pakistan's users are very less as we can see that there are only a 8 users in it. I and some of my friends are working on this platform and we are trying to bring more people to it because it is a good platform and original content is highly appreciated. One day Pakistan's community also got very strong on top of the hive. 
properties (22)
authordjbravo
permlinkre-demotruk-2023331t163817895z
categoryhive-133987
json_metadata{"tags":["hive","statistics"],"app":"ecency/3.0.31-vision","format":"markdown+html"}
created2023-03-31 11:38:18
last_update2023-03-31 11:38:18
depth1
children0
last_payout2023-04-07 11:38:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length325
author_reputation193,364,012,608,000
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,138,252
net_rshares0
@galberto ·
$0.26
Give me the salvadoream users please here i am Alone.
👍  
properties (23)
authorgalberto
permlinkre-demotruk-rscorl
categoryhive-133987
json_metadata{"tags":["hive-133987"],"app":"peakd/2023.3.5"}
created2023-03-30 20:26:12
last_update2023-03-30 20:26:12
depth1
children1
last_payout2023-04-06 20:26:12
cashout_time1969-12-31 23:59:59
total_payout_value0.128 HBD
curator_payout_value0.129 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length53
author_reputation264,667,189,450,799
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,120,276
net_rshares467,896,971,942
author_curate_reward""
vote details (1)
@demotruk ·
Be the change you want to see in the world.

FYI, it's you and one other.
properties (22)
authordemotruk
permlinkre-galberto-rscppb
categoryhive-133987
json_metadata{"tags":["hive-133987"],"app":"peakd/2023.3.5"}
created2023-03-30 20:46:24
last_update2023-03-30 20:46:24
depth2
children0
last_payout2023-04-06 20:46:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length73
author_reputation268,382,980,896,242
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,121,078
net_rshares0
@itwithsm ·
Venezuela is on the top,  I have heard that inflation in Venezuela is worst and many people are using the hive to cope with this rising inflation.  is it a good thing or a bad thing? What are your views on this?  Still we are far away from the real adoption.  
properties (22)
authoritwithsm
permlinkre-demotruk-2023330t132916690z
categoryhive-133987
json_metadata{"tags":["hive","statistics"],"app":"ecency/3.0.31-vision","format":"markdown+html"}
created2023-03-30 19:29:15
last_update2023-03-30 19:29:15
depth1
children2
last_payout2023-04-06 19:29:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length260
author_reputation179,219,734,046,411
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,118,385
net_rshares0
@demotruk ·
It is a good thing for Hive. In the long run we have much greater likelihood of survival if we are embedded in a local economy where it truly adds value and has even become part of ordinary life.
properties (22)
authordemotruk
permlinkre-itwithsm-rscmng
categoryhive-133987
json_metadata{"tags":["hive-133987"],"app":"peakd/2023.3.5"}
created2023-03-30 19:40:27
last_update2023-03-30 19:40:27
depth2
children1
last_payout2023-04-06 19:40:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length195
author_reputation268,382,980,896,242
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,118,683
net_rshares0
@itwithsm ·
Agree with you on that, Earning money is a very positive side of the Hive Ecosystem, but still, we are lacking behind when it comes to real adoption.  is the lack of promotion is cause of this ? 
properties (22)
authoritwithsm
permlinkre-demotruk-2023330t13471991z
categoryhive-133987
json_metadata{"tags":["hive-133987"],"app":"ecency/3.0.31-vision","format":"markdown+html"}
created2023-03-30 19:47:03
last_update2023-03-30 19:47:03
depth3
children0
last_payout2023-04-06 19:47:03
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length195
author_reputation179,219,734,046,411
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,118,880
net_rshares0
@itwithsm ·
I can't find Pakistan here 😗
properties (22)
authoritwithsm
permlinkre-demotruk-2023330t145236785z
categoryhive-133987
json_metadata{"tags":["hive","statistics"],"app":"ecency/3.0.31-vision","format":"markdown+html"}
created2023-03-30 20:52:36
last_update2023-03-30 20:52:36
depth1
children4
last_payout2023-04-06 20:52:36
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length29
author_reputation179,219,734,046,411
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,121,268
net_rshares0
@demotruk ·
![image.png](https://files.peakd.com/file/peakd-hive/demotruk/23tmm5sE2Gpw5qUtMPTC6mjtnN8sJ9E33Z6U1orW1z9V5wHjhv7CbNUnAbS2SpZgcVq1A.png)
properties (22)
authordemotruk
permlinkre-itwithsm-rscqgx
categoryhive-133987
json_metadata{"tags":["hive-133987"],"app":"peakd/2023.3.5"}
created2023-03-30 21:02:57
last_update2023-03-30 21:02:57
depth2
children3
last_payout2023-04-06 21:02:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length138
author_reputation268,382,980,896,242
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,121,578
net_rshares0
@itwithsm ·
So only two users from Pakistan? one is me and who is the other one?  
properties (22)
authoritwithsm
permlinkre-demotruk-2023330t15423575z
categoryhive-133987
json_metadata{"tags":["hive-133987"],"app":"ecency/3.0.31-vision","format":"markdown+html"}
created2023-03-30 21:04:24
last_update2023-03-30 21:04:24
depth3
children2
last_payout2023-04-06 21:04:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length70
author_reputation179,219,734,046,411
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,121,624
net_rshares0
@jacobtothe ·
$0.28
I've been listing my location as just "Sector ZZ9 Plural Z Alpha" since ~~Steemit~~ *Hive 1.0.*
👍  
properties (23)
authorjacobtothe
permlinkre-demotruk-rsd2uq
categoryhive-133987
json_metadata{"tags":["hive-133987"],"app":"peakd/2023.3.5"}
created2023-03-31 01:30:30
last_update2023-03-31 01:30:30
depth1
children0
last_payout2023-04-07 01:30:30
cashout_time1969-12-31 23:59:59
total_payout_value0.142 HBD
curator_payout_value0.142 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length95
author_reputation484,417,735,298,600
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,126,941
net_rshares504,088,975,208
author_curate_reward""
vote details (1)
@steevc ·
$0.27
I feel your pain. I've also been running geographical queries for the Brit List and other stats. I have a long list of search terms for the UK (no, not Ukraine). A machine learning solution might help and I expect there are libraries that already do this to some extent. I tend to do some checking as people will lie about where they are. I just found one in 'United Kingdoms' and that extra letter makes me suspicious.

I have played with various apps that let people geotag themselves and it can be really useful if you want to meet them in person. We have @pinmapple, but that locates posts rather than people.

You are still generating some interesting statistics even if they cannot be totally relied on for accuracy due to the underlying data.
👍  
properties (23)
authorsteevc
permlinkre-demotruk-rsdkp7
categoryhive-133987
json_metadata{"tags":["hive-133987"],"app":"peakd/2023.3.5"}
created2023-03-31 07:55:57
last_update2023-03-31 07:55:57
depth1
children0
last_payout2023-04-07 07:55:57
cashout_time1969-12-31 23:59:59
total_payout_value0.134 HBD
curator_payout_value0.133 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length749
author_reputation1,046,262,300,967,423
root_title"A little rant about analyzing location data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,134,920
net_rshares481,210,921,246
author_curate_reward""
vote details (1)