HIVE user counts by countries based on profile location data by talhasch

View this thread on: hive.blog | peakd.com | ecency.com

hive-133987 · @talhasch · Jul 13 '20

$10.56

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](https://github.com/talhasch/hive-account-location). It uses [geopy](https://github.com/geopy/geopy) and OpenStreetMap's [Nominatim](https://nominatim.org) 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 🎉

| Country     | Count    |  Percent |
| -------- | -------- | -------- |
| 🇺🇸 United States | 43051 | 18.39% |
| 🇻🇪 Venezuela, Bolivarian Republic of | 20380 | 8.71% |
| 🇮🇩 Indonesia | 18221 | 7.78% |
| 🇮🇳 India | 12047 | 5.15% |
| 🇳🇬 Nigeria | 9479 | 4.05% |
| 🇩🇪 Germany | 9051 | 3.87% |
| 🇬🇧 United Kingdom | 8816 | 3.77% |
| 🇰🇷 Korea, Republic of | 7443 | 3.18% |
| 🇨🇦 Canada | 7372 | 3.15% |
| 🇧🇩 Bangladesh | 6906 | 2.95% |
| 🇵🇭 Philippines | 6496 | 2.77% |
| 🇦🇺 Australia | 4584 | 1.96% |
| 🇵🇰 Pakistan | 4454 | 1.90% |
| 🇹🇷 Turkey | 3455 | 1.48% |
| 🇫🇷 France | 3415 | 1.46% |
| 🇵🇱 Poland | 3313 | 1.42% |
| 🇨🇳 China | 2959 | 1.26% |
| 🇪🇸 Spain | 2749 | 1.17% |
| 🇳🇱 Netherlands | 2602 | 1.11% |
| 🇮🇹 Italy | 2459 | 1.05% |
| 🇧🇷 Brazil | 2253 | 0.96% |
| 🇷🇺 Russian Federation | 2249 | 0.96% |
| 🇲🇾 Malaysia | 2156 | 0.92% |
| 🇿🇦 South Africa | 2155 | 0.92% |
| 🇲🇽 Mexico | 2005 | 0.86% |
| 🇳🇿 New Zealand | 1990 | 0.85% |
| 🇨🇴 Colombia | 1872 | 0.80% |
| 🇩🇴 Dominican Republic | 1765 | 0.75% |
| 🇷🇴 Romania | 1639 | 0.70% |
| 🇻🇳 Viet Nam | 1425 | 0.61% |
| 🇯🇵 Japan | 1402 | 0.60% |
| 🇦🇷 Argentina | 1314 | 0.56% |
| 🇦🇹 Austria | 1255 | 0.54% |
| 🇹🇭 Thailand | 1145 | 0.49% |
| 🇺🇦 Ukraine | 1135 | 0.48% |
| 🇨🇭 Switzerland | 1110 | 0.47% |
| 🇬🇷 Greece | 1073 | 0.46% |
| 🇧🇪 Belgium | 931 | 0.40% |
| 🇵🇹 Portugal | 919 | 0.39% |
| 🇸🇪 Sweden | 912 | 0.39% |


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!

👍 esteemapp, ecency, tipu, spectrumecons, nuthman, good-karma, likwid, actnearn, holger80, fredrikaa, frot, jeenger, hamismsf, penguinpablo, steevc, captainhive, jpbliberty, sanjeevm, mahdiyari, drax, livinguktaiwan, jacobtothe, xels, apshamilton, dalz, revisesociology, reazuliqbal, foxkoit, igel2017, chrisbolten, techcoderx, masterthematrix, toofasteddie, enforcer48, tomaszs77, src3, oivas, goldkey, steemaction, rubenalexander, omra-sky, davidlionfish, sgerhart, raiseup, udezee, yaelg, hijosdelhombre, markkujantunen, thomasthewolf, jesusjacr, tsnaks, neupanedipen, happy-soul, m2nnari, idkpdx, dunsky, jeanlucsr, ichbins, vegoutt-travel, flurgx, oniemaniego, sinochip, silvervault, goldvault, and 49 others
👎 dein-problem

properties (23)vote details (114)

voter	rshares	pct
good-karma	1,327,758,410,399	100%
rmach	8,119,824,120	50%
rubenalexander	75,347,883,221	30%
steevc	545,213,109,026	40%
foxkoit	155,233,682,744	84%
penguinpablo	551,058,621,240	10%
jacobtothe	356,569,099,815	100%
esteemapp	6,065,181,083,235	100%
mow	1,677,243,939	100%
markkujantunen	39,959,961,573	33%
fredrikaa	1,014,341,167,016	100%
varunpinto	3,376,672,610	100%
xels	348,234,906,166	50%
flurgx	14,253,248,470	100%
tomaszs77	102,770,461,613	100%
masterthematrix	134,119,557,415	100%
mxzn	799,015,433	2.5%
mahdiyari	443,991,372,510	100%
saintopic	767,207,169	50%
spectrumecons	1,401,463,074,588	30%
livinguktaiwan	425,551,484,002	31%
toofasteddie	118,245,070,334	29%
goldkey	78,730,975,288	30%
sanjeevm	463,154,143,793	50%
martibis	1,243,654,722	6.2%
jeanlucsr	15,245,679,791	100%
ahlawat	870,256,319	25%
lowlevel	169,554,452	100%
nuthman	1,339,328,039,120	50%
dunsky	16,534,856,211	100%
tipu	1,949,836,720,718	5%
jaalig	1,388,966,137	81%
oivas	86,098,833,377	100%
drax	437,880,269,894	100%
revisesociology	241,292,698,053	20%
omra-sky	67,803,944,070	40%
vegoutt-travel	14,335,624,231	30%
joetunex	1,061,209,643	0.5%
fourfourfun	6,677,717,683	25%
bartheek	6,565,557,758	2.5%
neupanedipen	23,973,738,204	100%
jesusjacr	36,140,842,043	21%
hijosdelhombre	47,549,758,109	50%
sinochip	13,161,997,878	40%
igel2017	137,175,682,865	100%
jeenger	738,197,118,310	100%
holger80	1,053,390,216,836	25%
udezee	50,973,273,793	100%
happy-soul	22,834,394,388	2.5%
thomasthewolf	38,954,542,705	59%
idkpdx	18,076,355,354	100%
reazuliqbal	210,434,674,286	40%
goldvault	11,293,636,085	33%
jazmins	922,737,121	100%
mini-zephalexia	6,455,112,034	80%
m2nnari	19,116,029,023	100%
gifty-e	845,900,633	100%
jazzman123	0	100%
tsnaks	25,566,999,382	100%
dodolzk	959,459,016	50%
promobot	10,627,285,471	8.75%
mrs.goldkey	2,845,614,516	33%
techcoderx	135,442,326,947	100%
enforcer48	108,767,741,319	15%
chrisbolten	136,030,061,100	100%
apshamilton	329,290,888,646	100%
longer	560,346,922	1.25%
yayan	2,504,064,464	50%
hamismsf	572,024,731,462	100%
dalz	265,571,341,334	100%
ekafao	917,843,240	50%
yaelg	48,436,575,381	90%
raiseup	52,484,928,736	10%
steemaction	76,817,052,199	10%
fullnodeupdate	6,351,389,414	25%
frot	901,348,051,595	50%
laissez-faire	1,604,328	100%
silverkey	2,898,594,848	33%
silvervault	12,470,654,756	33%
cryptycoon	4,804,059,307	33%
cryptoclerk	5,092,580,723	33%
esteemapp.rus	877,065,018	100%
actnearn	1,238,300,572,644	100%
dein-problem	0	-0.25%
jpbliberty	524,357,406,342	100%
steemitmonsters	643,125,396	100%
landshutbrauhaus	5,568,913,546	100%
ichbins	14,835,977,019	100%
src3	89,043,550,308	100%
meliamau	1,410,315,259	100%
likwid	1,240,918,276,734	8.75%
lrekt01	2,721,617,229	100%
oniemaniego	13,432,779,083	73%
katrin-lux	0	100%
bcm	4,406,498,084	3.75%
redwarbull	2,845,551,546	33%
der-fahrlehrer	970,022,613	99%
davidlionfish	56,523,573,842	100%
novum	9,232,911,346	100%
kailac	9,949,835,371	21%
sgerhart	54,998,299,738	100%
hivebuzz	2,839,450,264	2%
nachofigx	3,469,362,984	100%
captainhive	543,833,225,878	30%
artgrafiken	1,036,707,322	25%
tht1	3,729,702,697	100%
ninnu	545,447,877	10%
ecency	2,043,208,598,904	100%
aanjz09123	0	100%
olllieeee	52,804,520	100%
rahmatulyaa24	78,168,957	100%
yusron	0	100%
crypto.preneur	0	100%
layde	0	100%

@balman · Nov 20 '22

With the help of the location, you can really collect a lot of information. Sometimes such accessibility and opportunities even scare. [GPS phone tracker](https://heylocate.mobi/track-phone-number/) showed all available features in this question. I realized that even with minimal information, you can do an advanced search and find out a lot of details about a person of interest.

properties (22)

`author`	balman
`permlink`	rln1b8
`category`	hive-133987
`json_metadata`	{"links":["https://heylocate.mobi/track-phone-number/"],"app":"hiveblog/0.1"}
`created`	2022-11-20 08:37:57
`last_update`	2022-11-20 08:37:57
`depth`	1
`children`	0
`last_payout`	2022-11-27 08:37: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`	381
`author_reputation`	-10,704,803,437
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	118,474,936
`net_rshares`	0

@chekohler · Jul 13 '20

Wohoooo south africa lol almost at 1%

👍 talhasch, chrisbolten

`author`	chekohler
`permlink`	re-talhasch-qdevso
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2020.07.1"}
`created`	2020-07-13 14:19:39
`last_update`	2020-07-13 14:19:39
`depth`	1
`children`	0
`last_payout`	2020-07-20 14:19:39
`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`	37
`author_reputation`	524,332,427,393,665
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,498,265
`net_rshares`	1,613,260,928
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,613,260,928	100%
chrisbolten	0 B		0	24.2%

@dalz · Jul 13 '20

Nice one.
We still have some Koreans around :)

👍 talhasch

`author`	dalz
`permlink`	qdev9t
`category`	hive-133987
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2020-07-13 14:08:15
`last_update`	2020-07-13 14:08:15
`depth`	1
`children`	1
`last_payout`	2020-07-20 14:08: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`	46
`author_reputation`	1,902,327,698,470,308
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,498,105
`net_rshares`	1,681,726,638
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,681,726,638	100%

@talhasch · Jul 13 '20

:)

👍 chrisbolten

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
chrisbolten	0 B		0	100%

@dunsky · Jul 13 '20

Eh, so unpopular in Russia!

👍 talhasch, chrisbolten

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,491,824,879	100%
chrisbolten	0 B		0	24.2%

@enforcer48 · Jul 13 '20

> Surprisingly Venezuela is second.

I am not surprised by that at all. Neither by Indonesia and Nigeria.

👍 alexbalan, talhasch, freezepeach
👎 fersher

`author`	enforcer48
`permlink`	re-talhasch-qdexe1
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2020.07.1"}
`created`	2020-07-13 14:54:00
`last_update`	2020-07-13 14:54:00
`depth`	1
`children`	0
`last_payout`	2020-07-20 14:54:00
`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`	105
`author_reputation`	426,233,073,731,239
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,498,696
`net_rshares`	-1,086,054,179
`author_curate_reward`	""

properties (23)vote details (4)

voter	rshares	pct
freezepeach	326,161,968	0.24%
fersher	-5,740,987,114	-15%
talhasch	1,752,692,638	100%
alexbalan	2,576,078,329	100%

@frot · Jul 20 '20 (edited)

1990 Kiwis?

Have to admit I couldn't name 10 active ones...

properties (22)

`author`	frot
`permlink`	re-talhasch-qdqjf9
`category`	hive-133987
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2020-07-19 21:23:36
`last_update`	2020-07-20 23:26:03
`depth`	1
`children`	0
`last_payout`	2020-07-26 21:23: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`	60
`author_reputation`	94,148,415,747,890
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,610,527
`net_rshares`	0

@hivebuzz · Jul 13 '20

Congratulations @talhasch! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

<table><tr><td><img src="https://images.hive.blog/60x70/http://hivebuzz.me/@talhasch/upvoted.png?202007131503"></td><td>You received more than 200 upvotes. Your next target is to reach 300 upvotes.</td></tr>
</table>

<sub>_You can view [your badges on your board](https://hivebuzz.me/@talhasch) And compare to others on the [Ranking](https://hivebuzz.me/ranking)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>


To support your work, I also upvoted your post!


**Do not miss the last post from @hivebuzz:**
<table><tr><td><a href="/hive-139531/@hivebuzz/api"><img src="https://images.hive.blog/64x128/https://i.imgur.com/4qjwaYD.png"></a></td><td><a href="/hive-139531/@hivebuzz/api">Introducing the HiveBuzz API for applications and websites</a></td></tr></table>

###### Support the HiveBuzz project. [Vote](https://hivesigner.com/sign/update_proposal_votes?proposal_ids=%5B%22109%22%5D&approve=true) for [our proposal](https://peakd.com/me/proposals/109)!

properties (22)

`author`	hivebuzz
`permlink`	hivebuzz-notify-talhasch-20200713t152426000z
`category`	hive-133987
`json_metadata`	{"image":["http://hivebuzz.me/notify.t6.png"]}
`created`	2020-07-13 15:24:24
`last_update`	2020-07-13 15:24:24
`depth`	1
`children`	0
`last_payout`	2020-07-20 15:24: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`	1,163
`author_reputation`	369,201,194,112,997
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,499,170
`net_rshares`	0

@idkpdx · Jul 13 '20

I'm actually surprised to see the United States as number 1. I live in the states, but have noticed that interactions on Hive and the discord see more conversations during the night instead of the day.

👍 talhasch, chrisbolten

`author`	idkpdx
`permlink`	re-talhasch-qdfa3o
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2020.07.1"}
`created`	2020-07-13 19:28:36
`last_update`	2020-07-13 19:28:36
`depth`	1
`children`	0
`last_payout`	2020-07-20 19:28: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`	202
`author_reputation`	22,053,987,631,299
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,502,922
`net_rshares`	1,523,252,370
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,523,252,370	100%
chrisbolten	0 B		0	24.2%

@jaalig · Jul 13 '20

Interesting stats. Wonder how participation will delope over time?

👍 talhasch, chrisbolten

`author`	jaalig
`permlink`	re-talhasch-qdeuf2
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2020.07.1"}
`created`	2020-07-13 13:49:51
`last_update`	2020-07-13 13:49:51
`depth`	1
`children`	1
`last_payout`	2020-07-20 13:49:51
`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`	66
`author_reputation`	4,180,103,709,809
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,497,853
`net_rshares`	1,516,472,295
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,516,472,295	100%
chrisbolten	0 B		0	24.2%

@talhasch · Jul 13 '20

No idea. We'll see...

👍 chrisbolten

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
chrisbolten	0 B		0	100%

@livinguktaiwan · Jul 13 '20

I'm surprised UK has that many people!!  As to Turkey, a while ago I spoke to someone from Turkey and he reckons there's only about 20 to 30 users in the country.

👍 talhasch

`author`	livinguktaiwan
`permlink`	re-talhasch-qdfiqr
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2020.07.1"}
`created`	2020-07-13 22:35:18
`last_update`	2020-07-13 22:35:18
`depth`	1
`children`	2
`last_payout`	2020-07-20 22:35: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`	162
`author_reputation`	1,656,445,302,570,807
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,505,419
`net_rshares`	1,555,308,464
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,555,308,464	100%

@tht · Jul 14 '20

The number of people writing in Turkish is few. Since Turkish articles have very low upvote value, everyone writes non-Turkish articles.

👍 talhasch

`author`	tht
`permlink`	qdfug9
`category`	hive-133987
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2020-07-14 02:48:12
`last_update`	2020-07-14 02:48:12
`depth`	2
`children`	1
`last_payout`	2020-07-21 02:48:12
`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`	136
`author_reputation`	107,807,724,217,243
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,508,346
`net_rshares`	1,588,018,765
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,588,018,765	100%

@talhasch · Jul 14 '20

That makes sense

👍 chrisbolten

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
chrisbolten	0 B		0	100%

@looftee · Jul 19 '20

Lol, where are all those Indians?

Why can't I see them.

👍 talhasch

`author`	looftee
`permlink`	qdpy9r
`category`	hive-133987
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2020-07-19 13:46:39
`last_update`	2020-07-19 13:46:39
`depth`	1
`children`	0
`last_payout`	2020-07-26 13:46:39
`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`	56
`author_reputation`	22,447,007,592,745
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,604,002
`net_rshares`	1,752,731,428
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,752,731,428	100%

@revisesociology · Jul 13 '20

Interesting - does the code recognise that 'Manchester' and 'Swansea' are both from Britain? 

It's interesting how many people misfilled that section in!

It does take a long time to scour the entire chain I guess!

👍 talhasch

`author`	revisesociology
`permlink`	re-talhasch-qdeym0
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2020.07.1"}
`created`	2020-07-13 15:20:24
`last_update`	2020-07-13 15:20:24
`depth`	1
`children`	2
`last_payout`	2020-07-20 15:20: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`	215
`author_reputation`	2,259,716,985,207,714
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,499,110
`net_rshares`	1,621,383,848
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,621,383,848	100%

@talhasch · Jul 14 '20

 Yes, it recognizes that 'Manchester' and 'Swansea' are both from UK. You can check on [OpenStreetMap](https://www.openstreetmap.org/#map=11/51.6199/-3.9459) manually. The code uses  Nominatim API. So same data as on openstreetmap.org.

👍 chrisbolten

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
chrisbolten	0 B		0	100%

@revisesociology · Jul 14 '20

OK cheers, I don't know too much about Python and what it connects too, thanks for clarification!

properties (22)

`author`	revisesociology
`permlink`	re-talhasch-qdg7v9
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2020.07.1"}
`created`	2020-07-14 07:37:54
`last_update`	2020-07-14 07:37:54
`depth`	3
`children`	0
`last_payout`	2020-07-21 07:37:54
`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`	98
`author_reputation`	2,259,716,985,207,714
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,511,233
`net_rshares`	0

@steevc · Jul 13 '20 (edited)

I am surprised that many accounts had a location and many will not have a real value there. I would expect Korea to be higher as they seem to have a lot of active users for Steem. Most of these will have joined before Hive started anyway.

These are web stats [for hive](https://hypestat.com/info/hive.blog) for contrast. 

![image.png](https://files.peakd.com/file/peakd-hive/steevc/DlWkoKNL-image.png)

and [Steemit](https://hypestat.com/info/steemit.com)

![image.png](https://files.peakd.com/file/peakd-hive/steevc/M2RZs5lk-image.png)

👍 talhasch

`author`	steevc
`permlink`	re-talhasch-qdevgg
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2020.07.1"}
`created`	2020-07-13 14:12:18
`last_update`	2020-07-13 14:12:54
`depth`	1
`children`	0
`last_payout`	2020-07-20 14:12: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`	540
`author_reputation`	1,369,314,525,272,334
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,498,157
`net_rshares`	1,647,192,255
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,647,192,255	100%

@toofasteddie · Jul 13 '20

I am sure STEEM users are from Korea and China mainly now.
Good stats!
@tipu curate

👍 talhasch

`author`	toofasteddie
`permlink`	re-talhasch-qdeulu
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2020.07.1"}
`created`	2020-07-13 13:54:00
`last_update`	2020-07-13 13:54:00
`depth`	1
`children`	2
`last_payout`	2020-07-20 13:54:00
`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`	84
`author_reputation`	662,651,564,024,151
`root_title`	"HIVE user counts by countries based on profile location data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	98,497,933
`net_rshares`	1,548,415,569
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
talhasch	0 B		1,548,415,569	100%

@talhasch · Jul 13 '20

Yeah, thats for sure. Thanks!

properties (22)

@tipu · Jul 13 '20

<a href="https://tipu.online/hive_curator?toofasteddie" target="_blank">Upvoted  &#128076;</a> (Mana: 0/5)

properties (22)

@tsnaks · Jul 13 '20

Thanks for very interesting statistics

Sad that Estonia didn't make the list

👍 talhasch

properties (23)vote details (1)