News:

Come Chat with us live! Learn how HERE!

Main Menu

US1 user location stats

Started by Lakitu7, March 27, 2011, 10:48:02 PM

Lakitu7

Stats compiled for this phase so far, on US1. Each unique GUID is counted once. EU1 will get these stats eventually after various things are finished and approved.

There are some small bugs in this (like 2 people getting a country code of "Reno") but those are in the free geoip database and not my fault :)

Countries

  1200 United States
   184 Canada
   145 Poland
   138 France
   123 Australia
    87 Germany
    74 Philippines
    73 United Kingdom
    72 Brazil
    59 Russian Federation
    53 Peru
    52 Finland
    47 Italy
    36 Hong Kong
    34 New Zealand
    33 Singapore
    31 Mexico
    31 Belgium
    30 Czech Republic
    27 Sweden
    27 Netherlands
    26 Spain
    22 Hungary
    18 Israel
    16 Ukraine
    16 Taiwan
    15 Switzerland
    14 South Africa
    14 Portugal
    14 Japan
    14 Argentina
    13 Malaysia
    12 Romania
    10 Venezuela
     9 Korea, Republic of
     9 India
     9 China
     9 Chile
     8 Colombia
     7 Austria
     6 Slovakia
     6 Ireland
     6 Denmark
     5 Panama
     4 Vietnam
     4 Norway
     4 Kuwait
     4 Greece
     4 Estonia
     4 Croatia
     4 Costa Rica
     3 Turkey
     3 Iran, Islamic Republic of
     3 Indonesia
     2 United Arab Emirates
     2 Reno
     2 Lithuania
     2 Hillsboro
     2 Belarus
     1 South Richmond Hill
     1 Sosnowiec
     1 Slovenia
     1 San Giorgio A Cremano
     1 Quebec
     1 Prairieville
     1 Poznan
     1 Pittsburgh
     1 Perris
     1 Paraguay
     1 Palm Bay
     1 North Hollywood
     1 Neuostheim
     1 Morocco
     1 Macau
     1 Luxembourg
     1 Libyan Arab Jamahiriya
     1 Jordan
     1 Iceland
     1 Guatemala
     1 French Guiana
     1 Espoo
     1 El Salvador
     1 Ecuador
     1 Ebermannstadt
     1 Dominican Republic
     1 Bulgaria
     1 Bielefeld
     1 Bangladesh
     1 Anonymous Proxy

Lakitu7

States and Canadian Provinces
     236 CA
     80 NY
     67 TX
     64 WA
     61 ON
     49 QC
     45 FL
     43 NJ
     40 MI
     40 IL
     39 PA
     37 VA
     37 OH
     28 UT
     24 OR
     24 MD
     24 KS
     24 BC
     23 MA
     23 AZ
     22 GA
     22 CO
     21 MB
     21 AK
     20 ME
     19 TN
     18 NC
     18 MN
     18 IN
     17 WI
     14 NV
     14 MO
     14 ID
     12 AB
     10 LA
      9 WY
      9 NS
      8 CT
      7 OK
      6 SK
      6 SC
      6 HI
      6 AL
      5 KY
      4 WV
      4 VT
      4 IA
      4 AR
      3 NM
      3 NH
      3 MS
      3 DE
      2 NE
      2 MT
      2 DC
      1 SD
      1 RI
      1 NL
      1 ND
      1 NB
      1 AE

Lakitu7

Cities with > 1 person (Note that this is very biased as what "city" an ip number shows up as can be very fragmented.
     52 Brentwood
     23 Moscow
     22 Warsaw
      7 North Hollywood
      7 New York
      5 Willowbrook
      5 Milwaukee
      4 Spanaway
      4 Ottawa
      4 Kuwait
      4 Glasgow
      3 Stewartstown
      3 Rzesz?w
      3 Piotrk?w Trybunalski
      3 Kowloon
      3 Hayward
      3 Clearwater
      3 Caldwell
      3 Braunschweig
      2 Wroclaw
      2 Wahiawa
      2 Twickenham
      2 Tonawanda
      2 Przezmierowo
      2 Oswiecim
      2 Newcastle
      2 New Albin
      2 Morristown
      2 Lewiston
      2 Lawrenceville
      2 Lawrence
      2 Kwai Chung
      2 Kelowna
      2 Brownsburg

CreatureofHell

{NoS}StalKer
Quote<Timbo> posting on the trem forums rarely results in anything good

Pazuzu


Quote from: Tremhelper on September 05, 2011, 09:14:46 PM
ok, can you give me the tool thingy app that can code?

Lakitu7

#5
Might be a more accurate way to do cities:
Here's it as cities, regioncodes/states, country triplets:

Brentwood,CA,United States|51
Lima,15,Peru|51
Poznan,86,Poland|37
Singapore,00,Singapore|32
Bremerton,WA,United States|31
Los Angeles,CA,United States|24
Moscow,48,Russian Federation|23
Montreal,QC,Canada|22
Warsaw,78,Poland|22
Winnipeg,MB,Canada|21
Central District,00,Hong Kong|19
Pasig,50,Philippines|19
Wichita,KS,United States|18
Sydney,02,Australia|16
,,Poland|15
Anchorage,AK,United States|15
Auckland,E7,New Zealand|15
Perth,08,Australia|15
,,United States|14
Brisbane,04,Australia|14
Toronto,ON,Canada|14
Chicago,IL,United States|12
Houston,TX,United States|12
S�o Paulo,27,Brazil|12
,,Russian Federation|11
Drummondville,QC,Canada|11
Helsinki,13,Finland|11
London,H9,United Kingdom|11
Budapest,05,Hungary|10
Las Vegas,NV,United States|10
Melbourne,07,Australia|10
Mexico,09,Mexico|10
Portland,OR,United States|10
Quezon City,F2,Philippines|10
Red Bank,NJ,United States|10
Seattle,WA,United States|10
Buenos Aires,07,Argentina|9
Christchurch,E9,New Zealand|9
North Hollywood,CA,United States|9
Sacramento,CA,United States|9
Taipei,03,Taiwan|9
Valenzuela,53,Philippines|9
,,Ukraine|8
Edmonton,AB,Canada|8
Manila,D9,Philippines|8
Rochester,NY,United States|8
Salt Lake City,UT,United States|8
,,Brazil|7
,,France|7
Adelaide,05,Australia|7


Turns out almost all of the Brentwoods are from one IP; probably one guy that just changes guids every day or whatever.

Pazuzu

Some of the triplets are missing data, like all the Polish players are apparently getting lumped into one region.
Quote from: Lakitu7 on March 27, 2011, 11:29:23 PM
Anchorage,AK,United States|15
Surprising... Do they have the whole Palin family playing or something?

Quote from: Tremhelper on September 05, 2011, 09:14:46 PM
ok, can you give me the tool thingy app that can code?

Qrntz

Quote from: Lakitu7 on March 27, 2011, 11:29:23 PM
,,Ukraine|8
This is a lie. We have no , nor we do have . >:(
But seriously, your geolocation database is incomplete (I guess).

Quote from: {FoT|PeDrO} on December 14, 2011, 02:07:41 PMYou make up Qrntz, u always angry, just calmdown. :police:
Quote from: Loki on March 13, 2013, 10:27:57 AMI am stupid idiot who dares to open mouth and start debating

Lakitu7

Yeah, it's a free database ( http://geolite.maxmind.com/download/geoip/database/ ); not the best / most complete, unsurprisingly.

Only 6 unique IPs from the Anchorage folks and they're probably the same guy too.

janev

I'm guessing there is an epic troll in Brentwood?
Author of "The quick beginner's guide to playing tremulous"
Founding member of the "undefeated in clanwars since 2006" club and narcissist extraordinaire.


"Your quote-tower trolling reminds me of two dogs fighting over a piece of poo." [c] Ingar

Menace13

Quote from: Lakitu7 on March 27, 2011, 10:48:02 PMCountries
  1200 United States

Exactly 1200? lolwut

Let's try for 1337! :D

Quote from: amz181 on September 08, 2011, 12:32:07 PM
but a small twisty barrel will have small pew pew's, and small pew pew's can hurt mr.tyrant.

SlackerLinux

wow didn't expect us1 would have had 123 aussies interesting stats keep em coming latiku7
Slackware64 13.1
SlackersQVM/

Meisseli


gimhael


Nux

Quote from: gimhael on March 28, 2011, 08:43:58 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
     1 Bielefeld

OMG, THEY have infiltrated tremulous !! :o

The fact that the alleged city is in a list of nations such as Belgium and the great nation of Anonymous Proxy only furthers suspicion.

OhaiReapd


swamp-cecil

#16
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
     1 Quebec
Quebec isnt a serperate country. Its part of canada.
Quote from: DraZiLoX on December 28, 2010, 11:31:28 AM
Quote from: Repatition on December 28, 2010, 02:30:30 AM
these are stupid suggestions, don't even waste our time.
I don't like your negative attitude.

mooseberry

Quote from: swamp-cecil on March 29, 2011, 02:57:24 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
     1 Quebec
Quebec isnt a serperate country. Its part of canada.

Yes, and that isn't the only imperfection of the data. It has been said several times it is not perfect.
Bucket: [You hear the distant howl of a coyote losing at Counterstrike.]

मैं हिन्दी का समर्थन

~Mooseberry.

kharnov

Quote from: swamp-cecil on March 29, 2011, 02:57:24 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
     1 Quebec
Quebec isnt a serperate country. Its part of canada.

You try to tell that to a Quebecois nationalist.

A Spork

Quote from: kharnov on March 29, 2011, 05:07:12 AM
Quote from: swamp-cecil on March 29, 2011, 02:57:24 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
      1 Quebec
Quebec isnt a serperate country. Its part of canada.

You try to tell that to a Quebecois nationalist.
yeah...

also, from wikipedia:
Quote from: WikipediaIn 2006, the Canadian House of Commons passed a symbolic motion recognizing the "Québécois as a nation within a united Canada."
Don't shoot friend :basilisk:! Friend :basilisk: only wants to give you hugz and to be your hat

Proud Member of the S.O.B.F.O.B.S.A.D: The Society Of Basilisks For Other Basilisks Safety and Dominance
:basilisk:    :basilisk:    :basilisk:

swamp-cecil

I guess so. Besides, thers much contreversy in Quebec whether it should become a seperate country.
Also: I think i know who that Québéquois is.....Warlock?
Quote from: DraZiLoX on December 28, 2010, 11:31:28 AM
Quote from: Repatition on December 28, 2010, 02:30:30 AM
these are stupid suggestions, don't even waste our time.
I don't like your negative attitude.

A Spork

Likely. I know hes french Canadian, so chances are Quebec is his land.
Don't shoot friend :basilisk:! Friend :basilisk: only wants to give you hugz and to be your hat

Proud Member of the S.O.B.F.O.B.S.A.D: The Society Of Basilisks For Other Basilisks Safety and Dominance
:basilisk:    :basilisk:    :basilisk:

CorSair

Quote from: Meisseli on March 28, 2011, 08:06:34 AM
Hah, nice country that one, "Espoo".
Rofl, probably someone managed to install some brand new hardware to turn Espoo into a country. :laugh:

Pazuzu


Quote from: Tremhelper on September 05, 2011, 09:14:46 PM
ok, can you give me the tool thingy app that can code?

swamp-cecil

Quote from: A Spork on April 01, 2011, 02:25:00 AM
Likely. I know hes french Canadian, so chances are Quebec is his land.
So, the only french canadian place IS quebec and i remember him saying hes from there.
UNLESS he was lying and lives in yellowknife (artic)
Quote from: DraZiLoX on December 28, 2010, 11:31:28 AM
Quote from: Repatition on December 28, 2010, 02:30:30 AM
these are stupid suggestions, don't even waste our time.
I don't like your negative attitude.

A Spork

Quote from: swamp-cecil on April 04, 2011, 01:27:02 AM
Quote from: A Spork on April 01, 2011, 02:25:00 AM
Likely. I know hes french Canadian, so chances are Quebec is his land.
So, the only french canadian place IS quebec and i remember him saying hes from there.
UNLESS he was lying and lives in yellowknife (artic)
No, its just the only large predominately french area. Theres smaller places where french is the primary language, but generally not a large area outside Quebec
Don't shoot friend :basilisk:! Friend :basilisk: only wants to give you hugz and to be your hat

Proud Member of the S.O.B.F.O.B.S.A.D: The Society Of Basilisks For Other Basilisks Safety and Dominance
:basilisk:    :basilisk:    :basilisk: