Hello,

here are the latests statistics for the people that have registered to Steemit in Uganda, Germany and the rest of the world.
I hope it helps to support the newbies, especially from Uganda.
If someone wants to have other statistics, please give me a reply.

All New Steemit Users:

All New German Steemit Users:

All New Uganda Steemit Users:

Summary Of Monthly Userregistration

SQL-Statements:

select year(a.created) as year, month(a.created) as 'Month', count (*)as 'count of new accounts'
from Accounts a
--join comments c on c.author=a.name
-- where a.json_metada like 'uganda'
--where a.json_metadata like '%deutsch%'
--or a.json_metadata like '%german%'
group by year(a.created), month(a.created)
order by year(a.created), month(a.created)

New Users registered with location = 'Uganda'

year Month Username
2018 1 @brendaokiror
2018 1 @joshthefixer
2018 1 @rukkanovax
2018 1 @mosesmayor
2018 1 @yeamen
2018 1 @yohan2on
2018 1 @musamalijames
2018 1 @musemeza
2018 1 @runorg
2018 1 @jacquesinnocent
2018 1 @joshuadenzel
2018 1 @wanasoloben
2018 1 @kakslamar
2018 1 @emmerson16
2018 1 @gershom
2018 1 @jordanlove
2018 1 @kissaeric
2018 1 @ofwonoapolloyeri
2018 2 @mwebs
2018 2 @izzybec
2018 2 @kiddady
2018 2 @timk14
2018 2 @natsemily
2018 2 @insan8ty
2018 2 @bflorentin
2018 2 @najmasalim
2018 2 @shinejean
2018 2 @steemitkidsworld
2018 2 @ruthnatala
2018 2 @bigknuckles014
2018 2 @mirzahacker
2018 2 @donaldnkengbeza
2018 3 @isaaclakica
2018 3 @conrad-curtis
2018 3 @cserneithan
2018 3 @davisharvey
2018 3 @mayende
2018 3 @ryan12
2018 3 @blaiseochan
2018 3 @bogere
2018 3 @dmitryuwu
2018 3 @forhisglory
2018 3 @menorah
2018 3 @ireneblessing
2018 3 @blessedidah
2018 3 @tabzy
2018 3 @wojegabryan
2018 3 @alioni
2018 3 @wakalukubuka
2018 3 @pangai
2018 3 @joshuaemorut
2018 3 @waludyaba1
2018 3 @habasa
2018 3 @kevinjanvier
2018 3 @aymertens
2018 3 @norabatali
2018 3 @linknixon
2018 3 @mercyfayth
2018 3 @skeelz
2018 3 @kamula2
2018 4 @tysonvega
2018 4 @mwamin7
2018 4 @keddi
2018 4 @hazaharu
2018 4 @evangelistjotham
2018 4 @arinherbz
2018 4 @sebitosi
2018 4 @mastermind70
2018 4 @elmanaa
2018 4 @daveberry
2018 4 @muhenda11
2018 4 @seacrets123
2018 4 @wesongaivan
2018 4 @kihurankuba
2018 4 @julianbonita
2018 4 @olivegift
2018 4 @artdooor
2018 4 @babz-otim
2018 5 @kaleng
2018 5 @kasha256
2018 5 @ogwang
2018 5 @getitright
2018 5 @ericytex
2018 5 @blessings100
2018 5 @brutec
2018 5 @thepoeticmind
2018 5 @sheevan10
2018 5 @kalmz
2018 5 @dinahnana
2018 5 @hydrazine
2018 5 @leotek
2018 5 @rukundodax
2018 5 @alex092014
2018 5 @mariez
2018 6 @weenwacyrus
2018 6 @matendewilson
2018 6 @denno
SQL-Statement:

select year(a.created) as year, month(a.created) as 'Month', '@'+a.name
from Accounts a
--join comments c on c.author=a.name
where a.json_metadata like '%uganda%'
--group by year(a.created), month(a.created)
And year(a.created)= '2018'
order by year(a.created), month(a.created)

Count Of Posts Of New Users From Uganda

@alex092014 2
@arinherbz 55
@artdooor 15
@blessings100 1
@brutec 13
@daveberry 84
@dinahnana 42
@elmanaa 17
@ericytex 1
@evangelistjotham 62
@getitright 1
@hazaharu 248
@hydrazine 22
@julianbonita 8
@kaleng 6
@kalmz 12
@keddi 2
@kihurankuba 4
@leotek 12
@mariez 36
@mastermind70 4
@muhenda11 70
@mwamin7 86
@ogwang 21
@olivegift 3
@rukundodax 5
@seacrets123 28
@sheevan10 29
@thepoeticmind 3
@tysonvega 44
@wesongaivan 12

SQL-Statement:

select '@'+author, count (author) as 'count of posts'
from comments
where author
in
(Select name
from accounts
where
--author like 'achimmertens'
json_metadata like '%uganda%'
and (month(created)='4' or month(created)='5')
and year(created)='2018'
--
)
-- **/
group by author
order by author

Statement to @arcange

Hello @arcange,
sorry for not using CONTAINS(json_metadata, 'uganda') in my SQL-statements. I got an error message:

It seems, that the table "accounts" is not full-text-indexed.

Regards, Achim