Great effort, but unfortunately, this kind of stat is all but accurate and therefore a bit useless.
Users can put what they want in the location field of their settings, even words like "somewhere" or "planet earth" (like I did).
We can just say that "3,806 users pretend coming from India or would like to be from India or love India or ..."
And I really can't believe there are far more users from India than from US!
Yup. From the query I did yesterday I got it's 357 users whose location after conversion to uppercase reads PLANET EARTH (51st most popular) ;) Higher is WORLDWIDE (778 users, 19th position) - right above my country's English name (POLAND, 735 users).
Another thing is USA is 2394 (5th), US - 664 (24th), CALIFORNIA - 728 (22nd), TEXAS - 486 (33rd) and few other US locations that have no "United States" in it's name, yet are used by more people.
Most common location that is not a country name is at 8th (ACEH, 1723 users), while INDONESIA is 6th with 2349 users). Most common city - LONDON with 1046 (14th), right behind UK (1108, 13th).
@ekonugraha - interesting blog entry nonetheless. Inspired me to take a look at user's statistics myself and also arcange's blog.
Thanks @arcange . Yes, there is bias. Now I realize that analyzing users demography in Steem will lead to missing information.