Things you really want to see in "Cantr Statististics

[SekoETC]

if this is kept somewhere
5 characters that have killed the most people (i mean the number, not names :-] )

Some information has probably been purged but based on information that's there, the highest kill counts are:
34
31
31
27
23

I've heard of four of them and I think they're all English characters.

Spanish old characters by decade:


Polish old characters:

[Doug R.]

Of dead characters, % of when they died, by decade of age. So, %20s, %30s, etc.

[SekoETC]

There are so many dead characters that it's choking up on it, either that or I wrote the query all wrong.

[xXNathXx]

Oh, oh, and would it be possible to do something like...

The most dangerous islands (deaths by island)?

Please, this would be ultra-awesome.

[javacougar]

1. Largest towns by population
2. Largest towns by buildings
3. Largest port (most ships)
4. Largest transportation hub (most vehicles)
5. Percentage of characters with personal descriptions

[Voltenion]

5. Percentage of characters with personal descriptions

I'm also very interested in this one. Although if it were possible, I'd like to have it all the characters and then only characters who are over 25 years old. To try and not count those born dead characters.

[EchoMan]

1. Largest towns by population

The 20 largest towns by population:

Code: Select all

name                        usersname*
====                        =========
Dom Hofran                  Dom Hofran
Vlotryan                    Vlotryan
Dom Brendaran               Zatoka Urodzaju
Dom Tirilan                 Eden
Eden Majklimburski          Eden Majklimburski
Pwerquiorc Heights (north)  Z?oty Szczyt
Naron Forest                Naron Forest
Dom Aakran                  Rudy Kamieniec
Akypor                      Akypor
Rubinkowo
Davlozhishmos Hills (west)  CECHOWICE
Dom Yilpiran                Ksi??ycowa Dolina
Dom Bojran                  Dom Bojran
Vlouirryan                  Los Liberos
Doim Qurilific              Fortholm
Fu Put Kotan                Port Gallagher
Pwerquiorc                  111
Doimin Hfaroxir             Tartar
Klojt
Dumstiri

I'm not exactly sure how the usersname column was added to the data. Maybe it's known as something completely different now. The data is not a snapshot of this moment either.

[Oasis]

Wow, there are only three english towns in that whole list. Could we get a list of top ten or twenty english towns?

[EchoMan]

It's not easy to define what an English town is. Maybe I could select per island or something. It will have to wait until after work in that case.

[Henkie]

WHoohoo go Dom Hofran!

Towns where the most chars spawn per year?

[EchoMan]

Statistically that would be the same list.

[Henkie]

Wait, so.. Town grow exponentially, taken all chars that spawn stay in the same town and don't die right away?

[EchoMan]

Most characters don't stick around in their spawn town.

[SekoETC]

I think the usersname column was created by counting the most common namings by people at some point in time. And there are 4 English towns on that list, not three, because as far as I know, Dom Hofran is at least mainly English, and there are three towns from the original English regions.

[Chris]

Most characters don't stick around in their spawn town.

Most characters do stay in their spawn towns. Sleepers don't move, and adding in the active characters who stay bumps that percentage over 50%. And I suspect it's quite a bit more than 50%. Perhaps the stats people can give us hard numbers.