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.
author | demotruk |
---|---|
permlink | a-little-rant-about-analyzing-location-data |
category | hive-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"]} |
created | 2023-03-30 19:24:36 |
last_update | 2023-03-30 21:02:15 |
depth | 0 |
children | 15 |
last_payout | 2023-04-06 19:24:36 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 4.350 HBD |
curator_payout_value | 4.341 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 2,259 |
author_reputation | 268,382,980,896,242 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,118,268 |
net_rshares | 15,692,138,550,873 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
demotruk | 0 | 936,248,015,978 | 100% | ||
felixxx | 0 | 1,983,802,116,325 | 100% | ||
steevc | 0 | 1,310,954,434,810 | 50% | ||
jacobtothe | 0 | 499,278,533,989 | 50% | ||
abh12345 | 0 | 436,083,854,855 | 15% | ||
edb | 0 | 18,691,674,686 | 15% | ||
dyrt88 | 0 | 3,334,399,608 | 100% | ||
freebornsociety | 0 | 16,147,496,475 | 10% | ||
deirdyweirdy | 0 | 54,925,994,627 | 21% | ||
uadigger | 0 | 145,401,808,440 | 100% | ||
aleister | 0 | 13,752,523,208 | 9% | ||
galberto | 0 | 303,085,844,786 | 100% | ||
jayna | 0 | 18,639,053,712 | 3% | ||
joeyarnoldvn | 0 | 561,616,776 | 1.68% | ||
toofasteddie | 0 | 452,315,795,408 | 100% | ||
eturnerx | 0 | 26,767,059,736 | 1.4% | ||
abdulmanan | 0 | 3,664,992,686 | 100% | ||
zirochka | 0 | 166,679,552,676 | 30% | ||
votehero | 0 | 26,976,392,310 | 6% | ||
malos10 | 0 | 53,541,863,565 | 100% | ||
wiseagent | 0 | 27,755,888,344 | 5% | ||
abitcoinskeptic | 0 | 2,190,451,394 | 7.5% | ||
deepresearch | 0 | 437,114,284,133 | 38% | ||
znnuksfe | 0 | 5,710,970,891,170 | 50% | ||
tryskele | 0 | 776,471,547 | 3% | ||
piotrgrafik | 0 | 673,338,395,170 | 80% | ||
philnewton | 0 | 599,985,190 | 7.5% | ||
sbi4 | 0 | 42,658,554,076 | 3.87% | ||
fw206 | 0 | 475,201,125,882 | 10% | ||
akdx | 0 | 51,806,736,135 | 25% | ||
we-are-lucky | 0 | 16,293,947,249 | 43.7% | ||
dalz | 0 | 930,382,065,268 | 100% | ||
erica005 | 0 | 5,858,863,993 | 40% | ||
misterengagement | 0 | 1,162,020,611 | 15% | ||
bluerobo | 0 | 229,880,937,125 | 100% | ||
djbravo | 0 | 7,241,843,410 | 100% | ||
todayslight | 0 | 2,919,104,230 | 25% | ||
leighscotford | 0 | 5,849,344,484 | 7.5% | ||
gloriaolar | 0 | 4,209,473,532 | 4.5% | ||
oleksii.tkachuk | 0 | 18,785,942,447 | 100% | ||
mattbrown.art | 0 | 608,667,000 | 7.5% | ||
pishio | 0 | 547,797,441,338 | 10% | ||
trasto | 0 | 5,762,078,195 | 50% | ||
techguard | 0 | 1,311,714,911 | 19% | ||
isabel-vihu | 0 | 4,477,487,457 | 15% | ||
awildovasquez | 0 | 16,331,811,926 | 50% |
I feel like the Netherlands were once a big community, but I guess that changed.
author | cst90 |
---|---|
permlink | re-demotruk-2023330t2275872z |
category | hive-133987 |
json_metadata | {"tags":["hive-133987","hive","statistics"],"app":"ecency/3.0.39-mobile","format":"markdown+html"} |
created | 2023-03-30 20:07:06 |
last_update | 2023-03-30 20:07:06 |
depth | 1 |
children | 1 |
last_payout | 2023-04-06 20:07:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.205 HBD |
curator_payout_value | 0.205 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 80 |
author_reputation | 6,426,088,801,975 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,119,504 |
net_rshares | 741,711,599,826 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
demotruk | 0 | 463,346,542,587 | 50% | ||
cst90 | 0 | 278,313,598,101 | 100% | ||
nbabets | 0 | 51,459,138 | 100% |
24 active in February, but I haven't pulled historic data for comparison.
author | demotruk |
---|---|
permlink | re-cst90-rscpqy |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2023.3.5"} |
created | 2023-03-30 20:47:21 |
last_update | 2023-03-30 20:47:21 |
depth | 2 |
children | 0 |
last_payout | 2023-04-06 20:47:21 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 73 |
author_reputation | 268,382,980,896,242 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,121,104 |
net_rshares | 0 |
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.
author | djbravo |
---|---|
permlink | re-demotruk-2023331t163817895z |
category | hive-133987 |
json_metadata | {"tags":["hive","statistics"],"app":"ecency/3.0.31-vision","format":"markdown+html"} |
created | 2023-03-31 11:38:18 |
last_update | 2023-03-31 11:38:18 |
depth | 1 |
children | 0 |
last_payout | 2023-04-07 11:38:18 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 325 |
author_reputation | 193,364,012,608,000 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,138,252 |
net_rshares | 0 |
Give me the salvadoream users please here i am Alone.
author | galberto |
---|---|
permlink | re-demotruk-rscorl |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2023.3.5"} |
created | 2023-03-30 20:26:12 |
last_update | 2023-03-30 20:26:12 |
depth | 1 |
children | 1 |
last_payout | 2023-04-06 20:26:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.128 HBD |
curator_payout_value | 0.129 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 53 |
author_reputation | 264,667,189,450,799 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,120,276 |
net_rshares | 467,896,971,942 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
demotruk | 0 | 467,896,971,942 | 50% |
Be the change you want to see in the world. FYI, it's you and one other.
author | demotruk |
---|---|
permlink | re-galberto-rscppb |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2023.3.5"} |
created | 2023-03-30 20:46:24 |
last_update | 2023-03-30 20:46:24 |
depth | 2 |
children | 0 |
last_payout | 2023-04-06 20:46:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 73 |
author_reputation | 268,382,980,896,242 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,121,078 |
net_rshares | 0 |
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.
author | itwithsm |
---|---|
permlink | re-demotruk-2023330t132916690z |
category | hive-133987 |
json_metadata | {"tags":["hive","statistics"],"app":"ecency/3.0.31-vision","format":"markdown+html"} |
created | 2023-03-30 19:29:15 |
last_update | 2023-03-30 19:29:15 |
depth | 1 |
children | 2 |
last_payout | 2023-04-06 19:29:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 260 |
author_reputation | 179,219,734,046,411 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,118,385 |
net_rshares | 0 |
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.
author | demotruk |
---|---|
permlink | re-itwithsm-rscmng |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2023.3.5"} |
created | 2023-03-30 19:40:27 |
last_update | 2023-03-30 19:40:27 |
depth | 2 |
children | 1 |
last_payout | 2023-04-06 19:40:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 195 |
author_reputation | 268,382,980,896,242 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,118,683 |
net_rshares | 0 |
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 ?
author | itwithsm |
---|---|
permlink | re-demotruk-2023330t13471991z |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"ecency/3.0.31-vision","format":"markdown+html"} |
created | 2023-03-30 19:47:03 |
last_update | 2023-03-30 19:47:03 |
depth | 3 |
children | 0 |
last_payout | 2023-04-06 19:47:03 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 195 |
author_reputation | 179,219,734,046,411 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,118,880 |
net_rshares | 0 |
I can't find Pakistan here 😗
author | itwithsm |
---|---|
permlink | re-demotruk-2023330t145236785z |
category | hive-133987 |
json_metadata | {"tags":["hive","statistics"],"app":"ecency/3.0.31-vision","format":"markdown+html"} |
created | 2023-03-30 20:52:36 |
last_update | 2023-03-30 20:52:36 |
depth | 1 |
children | 4 |
last_payout | 2023-04-06 20:52:36 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 29 |
author_reputation | 179,219,734,046,411 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,121,268 |
net_rshares | 0 |
![image.png](https://files.peakd.com/file/peakd-hive/demotruk/23tmm5sE2Gpw5qUtMPTC6mjtnN8sJ9E33Z6U1orW1z9V5wHjhv7CbNUnAbS2SpZgcVq1A.png)
author | demotruk |
---|---|
permlink | re-itwithsm-rscqgx |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2023.3.5"} |
created | 2023-03-30 21:02:57 |
last_update | 2023-03-30 21:02:57 |
depth | 2 |
children | 3 |
last_payout | 2023-04-06 21:02:57 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 138 |
author_reputation | 268,382,980,896,242 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,121,578 |
net_rshares | 0 |
So only two users from Pakistan? one is me and who is the other one?
author | itwithsm |
---|---|
permlink | re-demotruk-2023330t15423575z |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"ecency/3.0.31-vision","format":"markdown+html"} |
created | 2023-03-30 21:04:24 |
last_update | 2023-03-30 21:04:24 |
depth | 3 |
children | 2 |
last_payout | 2023-04-06 21:04:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 70 |
author_reputation | 179,219,734,046,411 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,121,624 |
net_rshares | 0 |
I've been listing my location as just "Sector ZZ9 Plural Z Alpha" since ~~Steemit~~ *Hive 1.0.*
author | jacobtothe |
---|---|
permlink | re-demotruk-rsd2uq |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2023.3.5"} |
created | 2023-03-31 01:30:30 |
last_update | 2023-03-31 01:30:30 |
depth | 1 |
children | 0 |
last_payout | 2023-04-07 01:30:30 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.142 HBD |
curator_payout_value | 0.142 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 95 |
author_reputation | 484,417,735,298,600 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,126,941 |
net_rshares | 504,088,975,208 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
demotruk | 0 | 504,088,975,208 | 51% |
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.
author | steevc |
---|---|
permlink | re-demotruk-rsdkp7 |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2023.3.5"} |
created | 2023-03-31 07:55:57 |
last_update | 2023-03-31 07:55:57 |
depth | 1 |
children | 0 |
last_payout | 2023-04-07 07:55:57 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.134 HBD |
curator_payout_value | 0.133 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 749 |
author_reputation | 1,046,262,300,967,423 |
root_title | "A little rant about analyzing location data" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 122,134,920 |
net_rshares | 481,210,921,246 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
demotruk | 0 | 481,210,921,246 | 50% |