US1 user location stats

[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]

      1 Anonymous Proxy

Win.

[Pazuzu]

      4 VT

Yeah! Green Mountain State represent!

[Lakitu7]

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.

Anchorage,AK,United States|15

Surprising... Do they have the whole Palin family playing or something?

[Qrntz]

,,Ukraine|8

This is a lie. We have no , nor we do have .
But seriously, your geolocation database is incomplete (I guess).

[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?

[Menace13]

Countries
   1200 United States

Exactly 1200? lolwut

Let's try for 1337!

[SlackerLinux]

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

[Meisseli]

Hah, nice country that one, "Espoo".

[gimhael]

     1 Bielefeld

OMG, THEY have infiltrated tremulous !!

[Nux]

     1 Bielefeld

OMG, THEY have infiltrated tremulous !!

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]

40 IL

Too bad none of those kids are active other than me.

[swamp-cecil]

     1 Quebec

Quebec isnt a serperate country. Its part of canada.

[mooseberry]

     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.

[kharnov]

     1 Quebec

Quebec isnt a serperate country. Its part of canada.

You try to tell that to a Quebecois nationalist.

[A Spork]

      1 Quebec

Quebec isnt a serperate country. Its part of canada.

You try to tell that to a Quebecois nationalist.

yeah...

also, from wikipedia:

In 2006, the Canadian House of Commons passed a symbolic motion recognizing the "Québécois as a nation within a united Canada."

[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?

[A Spork]

Likely. I know hes french Canadian, so chances are Quebec is his land.

[CorSair]

Hah, nice country that one, "Espoo".

Rofl, probably someone managed to install some brand new hardware to turn Espoo into a country.

[Pazuzu]

"Primary Export: Children Of Bodom"

[swamp-cecil]

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)

[A Spork]

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