Growth of non-English communities on Steem

in #analysis6 years ago (edited)

Introduction

There are many communities on the Steem network that use a different language than English. For example, I am actively involved in the #polish community using the @jacekw account. This post is an update of the entry added 4 months ago.

As we can see, there are different naming conventions:

Tools

Queries

Full script as Jupyter Notebook

Posts:

query = lambda month, tag: """\
SELECT COUNT(*)
FROM Comments (NOLOCK)
WHERE depth = 0 AND
    YEAR(created) = 2018 AND MONTH(created) = {0} AND 
    (category = '{1}' OR (CONTAINS(json_metadata, '{1}') AND json_metadata LIKE '%"{1}"%'))
""".format(month, tag)

Authors

query = lambda month, tag: """\
SELECT COUNT(DISTINCT author)
FROM Comments (NOLOCK)
WHERE depth = 0 AND
    YEAR(created) = 2018 AND MONTH(created) = {0} AND 
    (category = '{1}' OR (CONTAINS(json_metadata, '{1}') AND json_metadata LIKE '%"{1}"%'))
""".format(month, tag)

Author rewards

query = lambda month, tag: """\
SELECT SUM(author_rewards) / 1000.0
FROM Comments (NOLOCK)
WHERE depth = 0 AND
    YEAR(created) = 2018 AND MONTH(created) = {0} AND 
    (category = '{1}' OR (CONTAINS(json_metadata, '{1}') AND json_metadata LIKE '%"{1}"%'))
""".format(month, tag)

Stats

Posts

.TagPosts
1spanish376988
2indonesia349542
3kr329146
4aceh287072
5cervantes200904
6deutsch102436
7cn96038
8castellano81456
9venezuela75407
10tr70699
11polish42829
12japanese27865
13fr27411
14ita25568
15ru25378
16pt25374
17myanmar25263
18thai21737
19ua20269
20morocco10551
21steemit-austria10177
22pilipinas9150
23arab8490
24mexico6926
25rusteemteam6203
26cesky5643
27russian3047
28hindi2855
29br2377
30arabic1873

1-10


11-20


21-30


Authors

.TagAuthors
1spanish66605
2indonesia50213
3aceh47108
4cervantes42175
5kr33829
6venezuela23967
7castellano20165
8deutsch12656
9cn11754
10tr8837
11polish6811
12japanese4327
13fr3999
14myanmar3631
15ita3401
16ru2806
17pt2731
18thai2727
19mexico2683
20steemit-austria1398
21arab1378
22morocco1348
23ua1279
24pilipinas1160
25russian969
26hindi954
27rusteemteam606
28cesky560
29arabic540
30br450

1-10


11-20


21-30


Author rewards

.TagAuthor rewards
1kr551369
2spanish280600
3cn233027
4cervantes168769
5deutsch142705
6indonesia131283
7tr106531
8ita88228
9castellano62107
10japanese60855
11fr58440
12aceh56124
13pt38845
14polish36453
15venezuela32841
16myanmar26748
17ru25741
18steemit-austria23106
19ua22217
20thai19768
21mexico14234
22morocco12438
23arab10099
24br9451
25cesky6230
26pilipinas4978
27rusteemteam3279
28hindi2614
29arabic1458

1-10


11-20


21-30


Average author rewards

.TagAverage author rewards per post
1br3.976
2ita3.451
3cn2.426
4steemit-austria2.270
5japanese2.184
6fr2.132
7mexico2.055
8kr1.675
9pt1.531
10tr1.507
11deutsch1.393
12arab1.190
13morocco1.179
14cesky1.104
15ua1.096
16myanmar1.059
17ru1.014
18hindi0.916
19thai0.909
20polish0.851
21cervantes0.840
22arabic0.778
23castellano0.762
24spanish0.744
25pilipinas0.544
26rusteemteam0.529
27venezuela0.436
28indonesia0.376
29russian0.360
30aceh0.196

1-10


11-20


21-30


Conclusions

In the analysis, 30 non-English communities, were taken into account . There are probably more, but the process of finding them is not a simple one, because of the different tagging conventions that have been adopted. All these communities are probably waiting for the appearance of the functionality Communities, because this will make it easier for them to function.

Despite the general downward trend in terms of the number of posts or the amount of rewards, in the last month we have seen a kind of trend break in the last month.

Sort:  

There is also #ita the italian community

Thanks for the info, I will update post as soon as possible :)

Thanks to you for the great report!

These are some fascinating statistics - it is encouraging to see that this platform is reaching the entire world. Thank you for taking the time to put this together and share it, I hope to see more human beings interacting with steemit from all over the planet in the future! Cheers.

Hello! Your post has been resteemed and upvoted by @ilovecoding because we love coding! Keep up good work! Consider upvoting this comment to support the @ilovecoding and increase your future rewards! ^_^ Steem On!

Reply !stop to disable the comment. Thanks!

#cervantes is not the name of a mother tongue but the the name of zhe bigest spanish speaking communiy we support with our @cervantes witness)

Congratulations @jacekw.dev! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You made more than 2000 upvotes. Your next target is to reach 3000 upvotes.

Click here to view your Board of Honor
If you no longer want to receive notifications, reply to this comment with the word STOP

Support SteemitBoard's project! Vote for its witness and get one more award!

🏆 Hi @jacekw.dev! You have received 0.2 SBD reward for this post from the following subscribers: @cardboard
More about the subscription feature can be found here :)

The Israeli community is really lagging in terms of #hebrew content...

Congratulations @jacekw.dev! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You made more than 1250 upvotes. Your next target is to reach 1500 upvotes.

Click here to view your Board of Honor
If you no longer want to receive notifications, reply to this comment with the word STOP

Do not miss the last post from @steemitboard:

Meet the Steemians Contest - The results, the winners and the prizes
Meet the Steemians Contest - Special attendees revealed
Meet the Steemians Contest - Intermediate results

Support SteemitBoard's project! Vote for its witness and get one more award!

Coin Marketplace

STEEM 0.18
TRX 0.18
JST 0.032
BTC 87512.19
ETH 3031.52
USDT 1.00
SBD 2.72