Odd WCA stats/ Stats request Thread

[Schmidt]

That's why I'm so proud of it

 

[Cale S]

List of all the times when the single and average WRs of an event were broken in the same round? (As in, the same person broke both single and average WRs within one round)
I can only think of Kevin Hays' 6x6 WR and some early WRs

I went through the WCA records page, and I found 87 times that this happened (3 are the current WRs). Here are the number of times I found for each event:
3x3 - 4
4x4 - 8
5x5 - 12
2x2 - 4
3BLD - 6
OH - 5
FMC - 0
Feet - 4
mega - 8
pyra - 3
sq1 - 8
clock - 3
skewb - 1
6x6 - 8
7x7 - 13

I might have missed a few that were from the same competition but different rounds (I found two of these for 7x7 and counted both rounds as separate), but I know it's happened at least 87 times. I have the details for each time it happened (name, single time, average time, competition, and round) written down, but I don't want to have to type it all.

 

[Robert-Y]

How about this one:
We consider everyone with at least 2 competitions. (This is to exclude meaningless one-time-results). The first unofficial world champion is defined as the person who was the fastest in the first competition. And you become unofficial world champion by beating the current unofficial world champion in a competition. This means winning the final of a competition, in that the current unofficial world champion participates in. E.g. the first one is Guus Razoux Schultz (we exclude Minh Thai for competing only once) in World Championships 1982. He then got beaten by Lars Vandenbergh in Euro 2004, who got beaten by Ron van Bruchem (Dutch Open 2005) and so on...
Who is the current unofficial world champion? What about other events? Lists of all the persons would be nice

Spoiler

Guus Razoux Schultz
Lars Vandenbergh
Ron Van Bruchem
Joel Van Noort
Jean Pons
Thibaut Jacquinot
Joel Van Noort
Ron Van Bruchem
Lars Vandenbergh
Thibaut Jacquinot
Edouard Chambon
Joel Van Noort
Erik Akkersdijk
Yu Nakajima
Mitsuki Gunji
Yu Nakajima
Yumu Tabuchi
Breandan Vallance
Robert Yau
Erik Akkersdijk
Mats Valk
Erik Akkersdijk
Mats Valk
Erik Akkersdijk
Sergey Ryabko
Erik Akkersdijk
Cornelius Dieckmann
Mats Valk
Erik Akkersdijk
Michal Pleskowicz
Sergey Ryabko
Daniil Lee
Sergey Ryabko
Nikolay Evdokimov
Sergey Ryabko
Ivan Vynnyk
Mats Valk

This just for 3x3x3. Wow Feliks is not on this list XD

EDIT: Thanks Moritz, this is quite an interesting statistic to me

And now Collin is the unofficial world champion

It is interesting to note that this is Feliks second opportunity to become the unofficial world champion, but he did not manage to win US nats unfortunately. His first chance was to beat Erik Akkersdijk at the World Championships 2011 in Thailand but Michal won instead.

 

[guysensei1]

Most number of WRs broken in a single comp? Most number of NRs? CRs? What about all of them combined?

 

[Stefan]

Spoiler: Cities with most competitions

[TABLE="class:grid,align:left"]
[TR][TD]competitions[/TD][TD]city[/TD][TD]countryId[/TD][/TR]
[TR][TD="align:right"]31[/TD][TD]Beijing[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]28[/TD][TD]Berkeley[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]26[/TD][TD]Pasadena[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]26[/TD][TD]Toronto[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]24[/TD][TD]Santiago[/TD][TD]Chile[/TD][/TR]
[TR][TD="align:right"]23[/TD][TD]Guangzhou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]20[/TD][TD]Melbourne[/TD][TD]Australia[/TD][/TR]
[TR][TD="align:right"]19[/TD][TD]Tokyo[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]19[/TD][TD]Xi'an[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]18[/TD][TD]Mumbai[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]18[/TD][TD]Osaka[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]17[/TD][TD]Cambridge[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]16[/TD][TD]Shanghai[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]15[/TD][TD]Milan[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]15[/TD][TD]Paris[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]14[/TD][TD]Bogotá[/TD][TD]Colombia[/TD][/TR]
[TR][TD="align:right"]13[/TD][TD]Bangkok[/TD][TD]Thailand[/TD][/TR]
[TR][TD="align:right"]12[/TD][TD]Chennai[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]12[/TD][TD]Gütersloh[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]12[/TD][TD]Kanazawa[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]12[/TD][TD]Moscow[/TD][TD]Russia[/TD][/TR]
[TR][TD="align:right"]12[/TD][TD]Nanjing[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]12[/TD][TD]San Diego[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]12[/TD][TD]Stanford[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]11[/TD][TD]Arequipa[/TD][TD]Peru[/TD][/TR]
[TR][TD="align:right"]11[/TD][TD]Budapest[/TD][TD]Hungary[/TD][/TR]
[TR][TD="align:right"]11[/TD][TD]Gdansk[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]11[/TD][TD]Jakarta[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]10[/TD][TD]Helsinki[/TD][TD]Finland[/TD][/TR]
[TR][TD="align:right"]10[/TD][TD]Taipei[/TD][TD]Taiwan[/TD][/TR]
[TR][TD="align:right"]9[/TD][TD]Eindhoven[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]9[/TD][TD]Essen[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]9[/TD][TD]Madrid[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]9[/TD][TD]Pardubice[/TD][TD]Czech Republic[/TD][/TR]
[TR][TD="align:right"]9[/TD][TD]Rome[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]9[/TD][TD]Stockholm[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]9[/TD][TD]Trondheim[/TD][TD]Norway[/TD][/TR]
[TR][TD="align:right"]8[/TD][TD]Buenos Aires[/TD][TD]Argentina[/TD][/TR]
[TR][TD="align:right"]8[/TD][TD]Lima[/TD][TD]Peru[/TD][/TR]
[TR][TD="align:right"]8[/TD][TD]Pittsburgh[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]8[/TD][TD]Puente Tocinos[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]Amagasaki[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]Columbus[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]Düsseldorf[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]Kanpur[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]Lyon[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]Mantova[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]Minneapolis[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]São Paulo[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]Seoul[/TD][TD]Korea[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]Singapore[/TD][TD]Singapore[/TD][/TR]
[TR][TD="align:right"]7[/TD][TD]Vienna[/TD][TD]Austria[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Aachen[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Ann Arbor[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Bridgeport[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Brussels[/TD][TD]Belgium[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Cebu City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Clarksville[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Dixon[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Ha Noi[/TD][TD]Vietnam[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Hefei[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Hsinchu[/TD][TD]Taiwan[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Hyderabad[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Ithaca[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Kawasaki[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Nantes[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]New Haven[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Poznan[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Princeton[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Quezon City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Rochester[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Santa Ana[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Tallinn[/TD][TD]Estonia[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Tehran[/TD][TD]Iran[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Tianjin[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Vancouver[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Yogyakarta[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Zhengzhou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]6[/TD][TD]Zonhoven[/TD][TD]Belgium[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Bandung[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Basauri (Bilbao)[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Bristol[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Bucharest[/TD][TD]Romania[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Dallet[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Dayton[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Delhi[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Fishers[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Goiânia[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Hangzhou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Hong Kong[/TD][TD]Hong Kong[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Jersey City[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Kaohsiung[/TD][TD]Taiwan[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Kharkiv[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Matsudo[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Mérida[/TD][TD]Venezuela[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Newark[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Oslo[/TD][TD]Norway[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Salt Lake City[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]San Francisco[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Santos[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Shenyang[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Sint Michielsgestel[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Starogard Gdanski[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Tainan[/TD][TD]Taiwan[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Vantaa[/TD][TD]Finland[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Alpharetta[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Auckland[/TD][TD]New Zealand[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Austin[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Berlin[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Castellón de la Plana[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Grudziadz[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Ho Chi Minh City[/TD][TD]Vietnam[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Istanbul[/TD][TD]Turkey[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Kediri[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Kyiv[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Lexington[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Los Angeles[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Makassar[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Maribor[/TD][TD]Slovenia[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Marikina[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Montpellier[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Norwalk[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Odense[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Palmdale[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Patchogue[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Philadelphia[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Rockland[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Skårup[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Taichung[/TD][TD]Taiwan[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Taiyuan[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Uberlândia[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Uppsala[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Valencia[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Wadowice[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Wroclaw[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Alexandria[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Amstelveen[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Amsterdam[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Bialystok[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Cali[/TD][TD]Colombia[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Campinas[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Cannes[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Changsha[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Chiba[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Cluj Napoca[/TD][TD]Romania[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Colorado Springs[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Dallas[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Delft[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Diliman[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Enschede[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Florence[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Fürth[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Gothenburg[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Granada[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Guadalajara[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Guildford[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Hamilton[/TD][TD]New Zealand[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Hanoi[/TD][TD]Vietnam[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Hanover[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Hillsdale[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Jinan[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Johor Bahru[/TD][TD]Malaysia[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Kuala Lumpur[/TD][TD]Malaysia[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Kungsängen[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Kyoto[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]La Montagne[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Lampertheim[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Legnano[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Leicester[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Lodz[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Namur[/TD][TD]Belgium[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]New Albany[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]New Delhi[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Nottingham[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Novo Hamburgo[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Pabianice[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Parthenay[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Pasuruan[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Piscataway[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Providence[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Rennes[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Richmond[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Rio de Janeiro[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Roorkee[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Santo Domingo[/TD][TD]Dominican Republic[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Seattle[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Shantou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Stubbendorf[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Sunnyvale[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Surabaya[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Suzhou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Swierklany[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Trichy[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Trujillo[/TD][TD]Peru[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Urdaneta City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Vårgårda[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Vesoul[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Warsaw[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Waterloo[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Wellington[/TD][TD]New Zealand[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Xining[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Zawiercie[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Zwolle[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD][/TD][TD][/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Allentown[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Anyang[/TD][TD]Korea[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Athens[/TD][TD]Greece[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Atlanta[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Bangalore[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Barcelona[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Barsbüttel[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Belgrade[/TD][TD]Serbia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Bloomington[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Bogor[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Boise[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Boulder[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Brasília[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Burnaby[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Busan[/TD][TD]Korea[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Cambridge[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Canberra[/TD][TD]Australia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Champaign[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Changchun[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Chelyabinsk[/TD][TD]Russia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Chicago[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Chojnice[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Cianjur[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Cincinnati[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Ciudad de Mexico[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Clarksburg[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Clinton[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Cluj-Napoca[/TD][TD]Romania[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Cyberjaya[/TD][TD]Malaysia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Cypress[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Diamond Bar[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Distrito Federal[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Dubai[/TD][TD]United Arab Emirates[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Ecully[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Erfurt[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Frankfurt[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]FuZhou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Gennes[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Gernika[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Guangdong[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Harbin[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Hasselt[/TD][TD]Belgium[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Hem[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Hillerød[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Ichikawa[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Ishikawa[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Khmelnytskyi[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Kirkkonummi[/TD][TD]Finland[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Kose[/TD][TD]Estonia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Kyotanabe[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]La Jolla[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Lanzhou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Las Vegas[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Lejre (Roskilde)[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]León[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Leuven[/TD][TD]Belgium[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Lint[/TD][TD]Belgium[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Lisbon[/TD][TD]Portugal[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Lo Pagan[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Lublin[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Luoyang[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Malang[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Manchester[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Marietta[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Metepec[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Meycauayan City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Milford[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Molina de Segura[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Monticello Conte Otto (Vicenza)[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Montréal[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Munich[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Murcia[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Nagpur[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Norrköping[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Oleksandriia[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Pasig City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Perth[/TD][TD]Australia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Phalsbourg[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Phoenix[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Raleigh[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Reykjavik[/TD][TD]Iceland[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Riga[/TD][TD]Latvia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Rumia[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Rybnik[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Saint Etienne[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Saint John[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Saint-Grégoire[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Samarinda[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Sant Cugat (Barcelona)[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]São Carlos[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Sarpsborg[/TD][TD]Norway[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Semarang[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Shenzhen[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Shepparton[/TD][TD]Australia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Shijiazhuang[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Södertälje[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Subang Jaya[/TD][TD]Malaysia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Surrey[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Suwon[/TD][TD]Korea[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Tampere[/TD][TD]Finland[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Tartu[/TD][TD]Estonia[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Terrassa[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]The Hague[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Toluca[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Toulouse[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Urbana[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Velbert[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Voorburg[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Weifang[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Wuhan[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Xiamen[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Zaragoza[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Aalborg[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Aarhus[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Adelaide[/TD][TD]Australia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Aguascalientes[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Americana[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Amman[/TD][TD]Jordan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Angono[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ankara[/TD][TD]Turkey[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Antipolo City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Anyang[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Aracaju[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Araraquara[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Århus[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Arlington Heights[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Armonk[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Aspe[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Astoria[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Auburn[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Aurora[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Avon Park[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bacau[/TD][TD]Romania[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ballerup[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ballymoney[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Baltimore[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Banjarmasin[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Belfort[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Benevento[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bergamo[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bergen[/TD][TD]Norway[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bergshamra[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Białystok[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bielsko-Biala[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bilbao[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Birmingham[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Blackeberg (Stockholm)[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bluffton[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Boa Vista[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bol'shie Kalmyki[/TD][TD]Russia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bottrop-Kirchhellen[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Brest[/TD][TD]Belarus[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bridgewater[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Brownsville[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Buccinasco (Milan)[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bucheon[/TD][TD]Korea[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Burke[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Bussières[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Cachan[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Cagayan de Oro City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Cainta City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Caldera[/TD][TD]Chile[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Campina Grande[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Catral - Alicante[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Champlitte[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Changzhou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Charlottesville[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chengdu[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Cheonan[/TD][TD]Korea[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chia-yi[/TD][TD]Taiwan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chiclayo[/TD][TD]Peru[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chifeng[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chignahuapan[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chonburi[/TD][TD]Thailand[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chongqing[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chorzow[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chorzów Batory[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Cisarua[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ciudad de Guatemala[/TD][TD]Guatemala[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Clermont-Ferrand[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]College Park[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Constanta[/TD][TD]Romania[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Copenhagen[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Corona Del Mar[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Corsico[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Cupertino[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Czestochowa[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Dabrowa Górnicza[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Daejeon[/TD][TD]Korea[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Dalian[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Decatur[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]DeLand[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Denpasar[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Denver[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Derio (Bilbao)[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Detroit[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Dieppe[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Dnipropetrovsk[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Dresden[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Duisburg[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Edinburgh[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Elblag[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Emmen[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ermita[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Farum[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Firenze[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Floridablanca[/TD][TD]Colombia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Fort Lee[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Fortaleza[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Fox Point[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Fredericia[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Frydman[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Fukuoka[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Fyshwick[/TD][TD]Australia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Galanta[/TD][TD]Slovakia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Geneva[/TD][TD]Switzerland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ghent[/TD][TD]Belgium[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Gijón[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Gilbert[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Glendale[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Gliwice[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Golden[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Graz[/TD][TD]Austria[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Grenoble[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Grinnell[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Groningen[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Guelph[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Guilin[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Guiyang[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Guwahati[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hamburg[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hamedan[/TD][TD]Iran[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hatfield[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hillsborough[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hiroshima[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ho Chi Minh[/TD][TD]Vietnam[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hohhot[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Houston[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hsinchu City[/TD][TD]Taiwan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Huizhou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hvalsø[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hyogo[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ibaraki[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Iligan City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Incheon[/TD][TD]Korea[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Indianapolis[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ipoh[/TD][TD]Malaysia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Isfahan[/TD][TD]Iran[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ispra (VA)[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Jastrzebie-Zdrój[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Jelling[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Jember[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Johannesburg[/TD][TD]South Africa[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kansas City[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kaohsiung City[/TD][TD]Taiwan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kaohsiung City 81157[/TD][TD]Taiwan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Karanglo-Malang[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Karlstad[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Karstula[/TD][TD]Finland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kashiwa[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kearny[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kendari[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kerela[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kharagpur[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Khmelnytskyy[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Khon Kaen[/TD][TD]Thailand[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kielce[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kiev[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kitchener[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kobe[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kollam[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kota Madiun[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kotka[/TD][TD]Finland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kozhikode[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kraków[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kramfors[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kristianstad[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kumamoto[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kurri Kurri[/TD][TD]Australia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Kyiv and Kharkiv[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]København[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]La Coruña[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lagarto[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lake Buena Vista[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lakewood[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lampang[/TD][TD]Thailand[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lancey[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Las Condes[/TD][TD]Chile[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lausanne[/TD][TD]Switzerland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Leeds[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lemgo[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lendava[/TD][TD]Slovenia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Levittown[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lhasa[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lingayen[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Linköping[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ljubljana[/TD][TD]Slovenia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lo Pagán (Murcia)[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lutsk[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lynden[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Lyngby[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Macau[/TD][TD]Macau[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Machida[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Malabon[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Manalapan[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Manaus[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Manila[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Mataró[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Mechanicsburg[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Medan[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Medellin[/TD][TD]Colombia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Melaka[/TD][TD]Malaysia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Mielec[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Milano[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Minsk[/TD][TD]Belarus[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Montcada i Reixac[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Monterotondo (Roma) [/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Monza[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Moratalla[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Morrisville[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Mossoró[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]München[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]München (Unterhaching)[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Murfreesboro[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Mysore[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Nagoya[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Nanchang[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Nanning[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Nantong[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Navenne[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Nelidovo[/TD][TD]Russia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Nettetal-Lobberrich[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Neuss[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]New Brunswick[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Niagara Falls[/TD][TD]Canada[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Nice[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Nirjuli[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Norman[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Novopolotsk[/TD][TD]Belarus[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Nyborg[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Odessa[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Omaha[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Orizaba[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Osijek[/TD][TD]Croatia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ottawa Hills[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Oxford[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Palma de Mallorca[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Pangasinan[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Paris Antony[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Park Ridge[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Pekanbaru[/TD][TD]Indonesia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Phitsanulok[/TD][TD]Thailand[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Pilani[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Piracicaba[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Pleasantville[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Plentzia[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Porto[/TD][TD]Portugal[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Prachuap Khiri Khan[/TD][TD]Thailand[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Puebla[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Pune[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Pushkin[/TD][TD]Russia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Qingdao[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Quetzaltenango[/TD][TD]Guatemala[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Quezon[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Radom[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Rajhasthan[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ramnicu Valcea[/TD][TD]Romania[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ramot Hashavim[/TD][TD]Israel[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Rancho Palos Verdes[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Rancho Viejo[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Reda[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Rehovot[/TD][TD]Israel[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Reims[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Reno[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Resende[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Richland[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Riverdale[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Rodi Garganico[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Roissy[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Rosales[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Rosersberg (Stockholm)[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Roskilde[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Rösrath[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Rovereto[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Rzeszow[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Saarbrücken[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Saint Petersburg[/TD][TD]Russia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Saint-Étienne[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Saint-Etienne-du-Rouvray[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Saitama[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Salerno[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]San Antonio[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]San Martín de la Vega[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]San Pablo City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]San Pedro de Macoris[/TD][TD]Dominican Republic[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]San Sebastian de los Reyes - Madrid[/TD][TD]Spain[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]San Severo (Foggia)[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Santes[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]São Bernardo do Campo[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]São José do Rio Preto[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]São José dos Campos[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]São Luís[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sarajevo[/TD][TD]Bosnia and Herzegovina[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sarasota[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Schaumburg[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Schio[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Seberang Perai[/TD][TD]Malaysia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Seongnam[/TD][TD]Korea[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Serris (Paris)[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sessa Aurunca[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Shiga[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Shinjuku[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Šiauliai[/TD][TD]Lithuania[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sibiu[/TD][TD]Romania[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Skanderborg[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sopot[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]South Sharon[/TD][TD]Israel[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Southlake[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Spørring[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Stalowa Wola[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sumaré[/TD][TD]Brazil[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Surathkal[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Swindon[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sydney[/TD][TD]Australia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tachikawa[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Taoyuan[/TD][TD]Taiwan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tarnowskie Gory[/TD][TD]Poland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tarrytown[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tbilisi[/TD][TD]Georgia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tiruchirapalli[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tommerup[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Toms River[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tomsk[/TD][TD]Russia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Topeka[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tovar[/TD][TD]Venezuela[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Toyama[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Trieste[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Trumbull[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Truskavets[/TD][TD]Ukraine[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tsukuba[/TD][TD]Japan[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tuam[/TD][TD]Ireland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tula[/TD][TD]Russia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tulancingo[/TD][TD]Mexico[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Ulaanbaatar[/TD][TD]Mongolia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Vaasa[/TD][TD]Finland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Valby[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Valencia[/TD][TD]Venezuela[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Valenzuela[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Valenzuela City[/TD][TD]Philippines[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Valga[/TD][TD]Estonia[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Valhalla[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Valparaiso[/TD][TD]Chile[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Vancouver[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Västerås[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Västervik[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Vattholma (Uppsala)[/TD][TD]Sweden[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Vedelago[/TD][TD]Italy[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Vejstrup[/TD][TD]Denmark[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Veldhoven[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Vellore[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Vezin-le-Coquet (Rennes)[/TD][TD]France[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Vlissingen[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Warangal[/TD][TD]India[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Weingarten[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Welwyn Garden City[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Wendlingen am Neckar[/TD][TD]Germany[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Wenzhou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Weston-super-Mare[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Wil[/TD][TD]Switzerland[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Williamsburg[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Williamstown[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Winona[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Winter Park[/TD][TD]USA[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Wuxi[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Xinxiang[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Yingkou[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Yingkou City[/TD][TD]China[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Yongin[/TD][TD]Korea[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Zaandam[/TD][TD]Netherlands[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Zagreb[/TD][TD]Croatia[/TD][/TR]
[/TABLE]

Spoiler: SQL code

select count(*) competitions, substring_index(cityName, ',', 1) city, countryId
from Competitions
where date(year*10000+month*100+day) <= date(now())
group by city, countryId
order by competitions desc, city

 

[guysensei1]

7 Singapore Singapore

Well the only city in Singapore is Singapore... So all of the comps in Singapore have to be held in Singapore.

 

[Stefan]

USA has had by far the most competitions, but most of them were only one day. What about total competition days? Well, they still win:

Spoiler: Competition Days by Country (sorted by CompetitionDays)

[TABLE="class:grid,align:left"]
[TR][TD]Country[/TD][TD]CompetitionDays[/TD][TD]Competitions[/TD][TD]DaysPerCompetition[/TD][/TR]
[TR][TD]USA[/TD][TD="align:right"]393[/TD][TD="align:right"]369[/TD][TD="align:right"]1.07[/TD][/TR]
[TR][TD]China[/TD][TD="align:right"]215[/TD][TD="align:right"]192[/TD][TD="align:right"]1.12[/TD][/TR]
[TR][TD]France[/TD][TD="align:right"]142[/TD][TD="align:right"]83[/TD][TD="align:right"]1.71[/TD][/TR]
[TR][TD]Germany[/TD][TD="align:right"]136[/TD][TD="align:right"]70[/TD][TD="align:right"]1.94[/TD][/TR]
[TR][TD]India[/TD][TD="align:right"]130[/TD][TD="align:right"]75[/TD][TD="align:right"]1.73[/TD][/TR]
[TR][TD]Poland[/TD][TD="align:right"]116[/TD][TD="align:right"]79[/TD][TD="align:right"]1.47[/TD][/TR]
[TR][TD]Japan[/TD][TD="align:right"]115[/TD][TD="align:right"]95[/TD][TD="align:right"]1.21[/TD][/TR]
[TR][TD]Spain[/TD][TD="align:right"]110[/TD][TD="align:right"]64[/TD][TD="align:right"]1.72[/TD][/TR]
[TR][TD]Brazil[/TD][TD="align:right"]106[/TD][TD="align:right"]50[/TD][TD="align:right"]2.12[/TD][/TR]
[TR][TD]Indonesia[/TD][TD="align:right"]91[/TD][TD="align:right"]55[/TD][TD="align:right"]1.65[/TD][/TR]
[TR][TD]Italy[/TD][TD="align:right"]81[/TD][TD="align:right"]56[/TD][TD="align:right"]1.45[/TD][/TR]
[TR][TD]Netherlands[/TD][TD="align:right"]63[/TD][TD="align:right"]38[/TD][TD="align:right"]1.66[/TD][/TR]
[TR][TD]Sweden[/TD][TD="align:right"]57[/TD][TD="align:right"]36[/TD][TD="align:right"]1.58[/TD][/TR]
[TR][TD]Canada[/TD][TD="align:right"]56[/TD][TD="align:right"]52[/TD][TD="align:right"]1.08[/TD][/TR]
[TR][TD]Denmark[/TD][TD="align:right"]53[/TD][TD="align:right"]31[/TD][TD="align:right"]1.71[/TD][/TR]
[TR][TD]Philippines[/TD][TD="align:right"]52[/TD][TD="align:right"]41[/TD][TD="align:right"]1.27[/TD][/TR]
[TR][TD]United Kingdom[/TD][TD="align:right"]49[/TD][TD="align:right"]27[/TD][TD="align:right"]1.81[/TD][/TR]
[TR][TD]Belgium[/TD][TD="align:right"]43[/TD][TD="align:right"]22[/TD][TD="align:right"]1.95[/TD][/TR]
[TR][TD]Chile[/TD][TD="align:right"]41[/TD][TD="align:right"]27[/TD][TD="align:right"]1.52[/TD][/TR]
[TR][TD]Taiwan[/TD][TD="align:right"]40[/TD][TD="align:right"]35[/TD][TD="align:right"]1.14[/TD][/TR]
[TR][TD]Australia[/TD][TD="align:right"]36[/TD][TD="align:right"]30[/TD][TD="align:right"]1.20[/TD][/TR]
[TR][TD]Finland[/TD][TD="align:right"]35[/TD][TD="align:right"]22[/TD][TD="align:right"]1.59[/TD][/TR]
[TR][TD]Russia[/TD][TD="align:right"]35[/TD][TD="align:right"]20[/TD][TD="align:right"]1.75[/TD][/TR]
[TR][TD]Thailand[/TD][TD="align:right"]32[/TD][TD="align:right"]18[/TD][TD="align:right"]1.78[/TD][/TR]
[TR][TD]Ukraine[/TD][TD="align:right"]32[/TD][TD="align:right"]20[/TD][TD="align:right"]1.60[/TD][/TR]
[TR][TD]Peru[/TD][TD="align:right"]31[/TD][TD="align:right"]23[/TD][TD="align:right"]1.35[/TD][/TR]
[TR][TD]Colombia[/TD][TD="align:right"]25[/TD][TD="align:right"]19[/TD][TD="align:right"]1.32[/TD][/TR]
[TR][TD]Malaysia[/TD][TD="align:right"]24[/TD][TD="align:right"]13[/TD][TD="align:right"]1.85[/TD][/TR]
[TR][TD]Hungary[/TD][TD="align:right"]23[/TD][TD="align:right"]11[/TD][TD="align:right"]2.09[/TD][/TR]
[TR][TD]Norway[/TD][TD="align:right"]23[/TD][TD="align:right"]17[/TD][TD="align:right"]1.35[/TD][/TR]
[TR][TD]Mexico[/TD][TD="align:right"]23[/TD][TD="align:right"]18[/TD][TD="align:right"]1.28[/TD][/TR]
[TR][TD]Czech Republic[/TD][TD="align:right"]23[/TD][TD="align:right"]9[/TD][TD="align:right"]2.56[/TD][/TR]
[TR][TD]Korea[/TD][TD="align:right"]21[/TD][TD="align:right"]19[/TD][TD="align:right"]1.11[/TD][/TR]
[TR][TD]Vietnam[/TD][TD="align:right"]21[/TD][TD="align:right"]14[/TD][TD="align:right"]1.50[/TD][/TR]
[TR][TD]Romania[/TD][TD="align:right"]18[/TD][TD="align:right"]14[/TD][TD="align:right"]1.29[/TD][/TR]
[TR][TD]Iran[/TD][TD="align:right"]17[/TD][TD="align:right"]8[/TD][TD="align:right"]2.13[/TD][/TR]
[TR][TD]Estonia[/TD][TD="align:right"]16[/TD][TD="align:right"]11[/TD][TD="align:right"]1.45[/TD][/TR]
[TR][TD]Austria[/TD][TD="align:right"]14[/TD][TD="align:right"]8[/TD][TD="align:right"]1.75[/TD][/TR]
[TR][TD]New Zealand[/TD][TD="align:right"]11[/TD][TD="align:right"]10[/TD][TD="align:right"]1.10[/TD][/TR]
[TR][TD]Slovenia[/TD][TD="align:right"]10[/TD][TD="align:right"]6[/TD][TD="align:right"]1.67[/TD][/TR]
[TR][TD]Venezuela[/TD][TD="align:right"]10[/TD][TD="align:right"]7[/TD][TD="align:right"]1.43[/TD][/TR]
[TR][TD]Singapore[/TD][TD="align:right"]10[/TD][TD="align:right"]7[/TD][TD="align:right"]1.43[/TD][/TR]
[TR][TD]Hong Kong[/TD][TD="align:right"]9[/TD][TD="align:right"]5[/TD][TD="align:right"]1.80[/TD][/TR]
[TR][TD]Argentina[/TD][TD="align:right"]8[/TD][TD="align:right"]8[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Belarus[/TD][TD="align:right"]6[/TD][TD="align:right"]3[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Turkey[/TD][TD="align:right"]6[/TD][TD="align:right"]5[/TD][TD="align:right"]1.20[/TD][/TR]
[TR][TD]Dominican Republic[/TD][TD="align:right"]5[/TD][TD="align:right"]4[/TD][TD="align:right"]1.25[/TD][/TR]
[TR][TD]Switzerland[/TD][TD="align:right"]5[/TD][TD="align:right"]3[/TD][TD="align:right"]1.67[/TD][/TR]
[TR][TD]Israel[/TD][TD="align:right"]4[/TD][TD="align:right"]3[/TD][TD="align:right"]1.33[/TD][/TR]
[TR][TD]Latvia[/TD][TD="align:right"]4[/TD][TD="align:right"]2[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Croatia[/TD][TD="align:right"]4[/TD][TD="align:right"]2[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Portugal[/TD][TD="align:right"]3[/TD][TD="align:right"]3[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Serbia[/TD][TD="align:right"]3[/TD][TD="align:right"]2[/TD][TD="align:right"]1.50[/TD][/TR]
[TR][TD]Greece[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]United Arab Emirates[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Lithuania[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Slovakia[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Ireland[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Bosnia and Herzegovina[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Guatemala[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Iceland[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Macau[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Mongolia[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Jordan[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Georgia[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]South Africa[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD][/TD][TD="align:right"]None[/TD][TD="align:right"]2[/TD][TD="align:right"]None[/TD][/TR]
[/TABLE]

Spoiler: SQL code

SELECT Country, CompetitionDays, Competitions, round(CompetitionDays/Competitions, 2) DaysPerCompetition
FROM
(SELECT
countryId Country,
sum(datediff(year*10000+endMonth*100+endDay,year*10000+month*100+day)+1) CompetitionDays,
count(*) Competitions
FROM Competitions
WHERE date(year*10000+month*100+day) <= date(now())
GROUP BY countryId) tmp
ORDER BY CompetitionDays desc

There are some countries that average more than two days per competition, though:

Spoiler: Competition Days by Country (sorted by DaysPerCompetition)

[TABLE="class:grid,align:left"]
[TR][TD]Country[/TD][TD]CompetitionDays[/TD][TD]Competitions[/TD][TD]DaysPerCompetition[/TD][/TR]
[TR][TD]Czech Republic[/TD][TD="align:right"]23[/TD][TD="align:right"]9[/TD][TD="align:right"]2.56[/TD][/TR]
[TR][TD]Iran[/TD][TD="align:right"]17[/TD][TD="align:right"]8[/TD][TD="align:right"]2.13[/TD][/TR]
[TR][TD]Brazil[/TD][TD="align:right"]106[/TD][TD="align:right"]50[/TD][TD="align:right"]2.12[/TD][/TR]
[TR][TD]Hungary[/TD][TD="align:right"]23[/TD][TD="align:right"]11[/TD][TD="align:right"]2.09[/TD][/TR]
[TR][TD]Belarus[/TD][TD="align:right"]6[/TD][TD="align:right"]3[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Lithuania[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Slovakia[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Ireland[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Latvia[/TD][TD="align:right"]4[/TD][TD="align:right"]2[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Bosnia and Herzegovina[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Croatia[/TD][TD="align:right"]4[/TD][TD="align:right"]2[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Belgium[/TD][TD="align:right"]43[/TD][TD="align:right"]22[/TD][TD="align:right"]1.95[/TD][/TR]
[TR][TD]Germany[/TD][TD="align:right"]136[/TD][TD="align:right"]70[/TD][TD="align:right"]1.94[/TD][/TR]
[TR][TD]Malaysia[/TD][TD="align:right"]24[/TD][TD="align:right"]13[/TD][TD="align:right"]1.85[/TD][/TR]
[TR][TD]United Kingdom[/TD][TD="align:right"]49[/TD][TD="align:right"]27[/TD][TD="align:right"]1.81[/TD][/TR]
[TR][TD]Hong Kong[/TD][TD="align:right"]9[/TD][TD="align:right"]5[/TD][TD="align:right"]1.80[/TD][/TR]
[TR][TD]Thailand[/TD][TD="align:right"]32[/TD][TD="align:right"]18[/TD][TD="align:right"]1.78[/TD][/TR]
[TR][TD]Russia[/TD][TD="align:right"]35[/TD][TD="align:right"]20[/TD][TD="align:right"]1.75[/TD][/TR]
[TR][TD]Austria[/TD][TD="align:right"]14[/TD][TD="align:right"]8[/TD][TD="align:right"]1.75[/TD][/TR]
[TR][TD]India[/TD][TD="align:right"]130[/TD][TD="align:right"]75[/TD][TD="align:right"]1.73[/TD][/TR]
[TR][TD]Spain[/TD][TD="align:right"]110[/TD][TD="align:right"]64[/TD][TD="align:right"]1.72[/TD][/TR]
[TR][TD]France[/TD][TD="align:right"]142[/TD][TD="align:right"]83[/TD][TD="align:right"]1.71[/TD][/TR]
[TR][TD]Denmark[/TD][TD="align:right"]53[/TD][TD="align:right"]31[/TD][TD="align:right"]1.71[/TD][/TR]
[TR][TD]Slovenia[/TD][TD="align:right"]10[/TD][TD="align:right"]6[/TD][TD="align:right"]1.67[/TD][/TR]
[TR][TD]Switzerland[/TD][TD="align:right"]5[/TD][TD="align:right"]3[/TD][TD="align:right"]1.67[/TD][/TR]
[TR][TD]Netherlands[/TD][TD="align:right"]63[/TD][TD="align:right"]38[/TD][TD="align:right"]1.66[/TD][/TR]
[TR][TD]Indonesia[/TD][TD="align:right"]91[/TD][TD="align:right"]55[/TD][TD="align:right"]1.65[/TD][/TR]
[TR][TD]Ukraine[/TD][TD="align:right"]32[/TD][TD="align:right"]20[/TD][TD="align:right"]1.60[/TD][/TR]
[TR][TD]Finland[/TD][TD="align:right"]35[/TD][TD="align:right"]22[/TD][TD="align:right"]1.59[/TD][/TR]
[TR][TD]Sweden[/TD][TD="align:right"]57[/TD][TD="align:right"]36[/TD][TD="align:right"]1.58[/TD][/TR]
[TR][TD]Chile[/TD][TD="align:right"]41[/TD][TD="align:right"]27[/TD][TD="align:right"]1.52[/TD][/TR]
[TR][TD]Serbia[/TD][TD="align:right"]3[/TD][TD="align:right"]2[/TD][TD="align:right"]1.50[/TD][/TR]
[TR][TD]Vietnam[/TD][TD="align:right"]21[/TD][TD="align:right"]14[/TD][TD="align:right"]1.50[/TD][/TR]
[TR][TD]Poland[/TD][TD="align:right"]116[/TD][TD="align:right"]79[/TD][TD="align:right"]1.47[/TD][/TR]
[TR][TD]Italy[/TD][TD="align:right"]81[/TD][TD="align:right"]56[/TD][TD="align:right"]1.45[/TD][/TR]
[TR][TD]Estonia[/TD][TD="align:right"]16[/TD][TD="align:right"]11[/TD][TD="align:right"]1.45[/TD][/TR]
[TR][TD]Venezuela[/TD][TD="align:right"]10[/TD][TD="align:right"]7[/TD][TD="align:right"]1.43[/TD][/TR]
[TR][TD]Singapore[/TD][TD="align:right"]10[/TD][TD="align:right"]7[/TD][TD="align:right"]1.43[/TD][/TR]
[TR][TD]Norway[/TD][TD="align:right"]23[/TD][TD="align:right"]17[/TD][TD="align:right"]1.35[/TD][/TR]
[TR][TD]Peru[/TD][TD="align:right"]31[/TD][TD="align:right"]23[/TD][TD="align:right"]1.35[/TD][/TR]
[TR][TD]Israel[/TD][TD="align:right"]4[/TD][TD="align:right"]3[/TD][TD="align:right"]1.33[/TD][/TR]
[TR][TD]Colombia[/TD][TD="align:right"]25[/TD][TD="align:right"]19[/TD][TD="align:right"]1.32[/TD][/TR]
[TR][TD]Romania[/TD][TD="align:right"]18[/TD][TD="align:right"]14[/TD][TD="align:right"]1.29[/TD][/TR]
[TR][TD]Mexico[/TD][TD="align:right"]23[/TD][TD="align:right"]18[/TD][TD="align:right"]1.28[/TD][/TR]
[TR][TD]Philippines[/TD][TD="align:right"]52[/TD][TD="align:right"]41[/TD][TD="align:right"]1.27[/TD][/TR]
[TR][TD]Dominican Republic[/TD][TD="align:right"]5[/TD][TD="align:right"]4[/TD][TD="align:right"]1.25[/TD][/TR]
[TR][TD]Japan[/TD][TD="align:right"]115[/TD][TD="align:right"]95[/TD][TD="align:right"]1.21[/TD][/TR]
[TR][TD]Australia[/TD][TD="align:right"]36[/TD][TD="align:right"]30[/TD][TD="align:right"]1.20[/TD][/TR]
[TR][TD]Turkey[/TD][TD="align:right"]6[/TD][TD="align:right"]5[/TD][TD="align:right"]1.20[/TD][/TR]
[TR][TD]Taiwan[/TD][TD="align:right"]40[/TD][TD="align:right"]35[/TD][TD="align:right"]1.14[/TD][/TR]
[TR][TD]China[/TD][TD="align:right"]215[/TD][TD="align:right"]192[/TD][TD="align:right"]1.12[/TD][/TR]
[TR][TD]Korea[/TD][TD="align:right"]21[/TD][TD="align:right"]19[/TD][TD="align:right"]1.11[/TD][/TR]
[TR][TD]New Zealand[/TD][TD="align:right"]11[/TD][TD="align:right"]10[/TD][TD="align:right"]1.10[/TD][/TR]
[TR][TD]Canada[/TD][TD="align:right"]56[/TD][TD="align:right"]52[/TD][TD="align:right"]1.08[/TD][/TR]
[TR][TD]USA[/TD][TD="align:right"]393[/TD][TD="align:right"]369[/TD][TD="align:right"]1.07[/TD][/TR]
[TR][TD]Portugal[/TD][TD="align:right"]3[/TD][TD="align:right"]3[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Greece[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Macau[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Mongolia[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]United Arab Emirates[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Argentina[/TD][TD="align:right"]8[/TD][TD="align:right"]8[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Jordan[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Georgia[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Guatemala[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]South Africa[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD]Iceland[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD="align:right"]1.00[/TD][/TR]
[TR][TD][/TD][TD="align:right"]None[/TD][TD="align:right"]2[/TD][TD="align:right"]None[/TD][/TR]
[/TABLE]

Spoiler: SQL code

SELECT Country, CompetitionDays, Competitions, round(CompetitionDays/Competitions, 2) DaysPerCompetition
FROM
(SELECT
countryId Country,
sum(datediff(year*10000+endMonth*100+endDay,year*10000+month*100+day)+1) CompetitionDays,
count(*) Competitions
FROM Competitions
WHERE date(year*10000+month*100+day) <= date(now())
GROUP BY countryId) tmp
ORDER BY DaysPerCompetition desc

 

[vcuber13]

This was originally requested by Robert Yau
How many people don't have a "cubing nemesis"? A nemesis here is someone who beats you in all events that you have a result in. This was a tricky problem due to the amount of data crunching required, but I've managed it with the help of an Excel macro. The events columns below give the number of events that person has a result in, which is also how the table is ordered. I haven't calculated a full list of people with 2+ nemeses because my computer wouldn't appreciate being asked to do it.


106 People with only 1 nemesis
[table="width: 700, class: grid, align: left"]
[tr][td]Brady Metherall[/td] [td]Canada[/td] [td]23[/td] [td]Dan Cohen[/td][/tr]
[/table]

I've beaten Dan in skewb, but it looks like Nathan Dwyer is now my nemesis.

 

[guysensei1]

https://www.worldcubeassociation.org/results/p.php?i=2008MHLS01

This person's surname had a weird character in it so the WCA ID skipped it... How many others like this?

 

[G2013]

I ask again for the person with the ao5 with less standard deviation and the one with most, of any event.

 

[antoineccantin]

How about sum of ALL ranks (single+average)? After Starlight's results

 

[Bunyanderman]

I went a little further and measured consecutive PB averages from round to round.
Here are the best results (for all events that have averages):

Spoiler: PB Average Streaks

[TABLE="class:grid,align:left"]
[TR][TD] Event [/TD][TD] Name [/TD][TD] personId [/TD][TD] Country [/TD][TD] PB Average Streak [/TD][/TR]
[TR][TD] 333 [/TD][TD] Michael Rose [/TD][TD] 2011ROSE03 [/TD][TD] Canada [/TD][TD] 12 [/TD][/TR]
[TR][TD] 333 [/TD][TD] Karl Burkamp [/TD][TD] 2009BURK01 [/TD][TD] Germany [/TD][TD] 10* [/TD][/TR]
[TR][TD] 333 [/TD][TD] Anthony Jacquemin [/TD][TD] 2010JACQ01 [/TD][TD] France [/TD][TD] 10 [/TD][/TR]
[TR][TD] 444 [/TD][TD] Rahul Kadukar [/TD][TD] 2009KADU01 [/TD][TD] India [/TD][TD] 10 [/TD][/TR]
[TR][TD] 444 [/TD][TD] Andy Smith 2 [/TD][TD] 2010SMIT01 [/TD][TD] USA [/TD][TD] 10 [/TD][/TR]
[TR][TD] 333oh [/TD][TD] Nakai Velasquez [/TD][TD] 2008VELA01 [/TD][TD] USA [/TD][TD] 10 [/TD][/TR]
[TR][TD] 333oh [/TD][TD] Daniel Sheppard [/TD][TD] 2009SHEP01 [/TD][TD] United Kingdom [/TD][TD] 10 [/TD][/TR]
[TR][TD] 333oh [/TD][TD] Greg Maziuk [/TD][TD] 2010MAZI01 [/TD][TD] USA [/TD][TD] 10* [/TD][/TR]
[/TABLE]
*current streak (coinciding with total number of averages done in the event)

Can some one do something very similar, top 10 people who has the longest streak of Pbs broken in either single or average in any of the events. So if you did not break a pb in single or average, then your streak is over, only per event. Example: 2x2 if you got a new pb in single or average at the comp then your streak would continue. A new pb in a different event would not count towards your 2x2 streak.

I have a 11 streak in 2x2 and 12 in 4x4.
Edit: Can someone please do this?

 

[Mikel]

Who has been to the most competitions in 2014? (Top 15 people)

I know François Courtès has been to 16 and Kit Clement has been to 15.

 

[Sebastien]

Here you go:

Spoiler

Wojciech Szatanowski 17
François Courtès 16
Tomasz Żołnowski 16
Kit Clement 15
Ryan DeLine 14
Mateusz Cichoracki 13
Przemysław Kaleta 13
Michał Halczuk 13
Olivér Perge 13
James Hildreth 13
Wojciech Knott 13
Sébastien Auroux 12
Nikolett Placskó 12
Laura Ohrndorf 12
Andreas Pohl 11
Paweł Kowol 11
Jan Bentlage 11
Nathan Dwyer 11
Radosław Ciuk 11
István Kocza 10
Lauren Klemz 10
Bence Barát 10
Anders Larsson 10
Sarah Strong 10
Marcin Zalewski 10
Mateusz Fydrych 10
Ming Zheng (郑鸣) 10
Michael Kristel 10
Krzysztof Kuncki 10
Tim Wong 10
Jakub Wolniewicz 10
Rafael Werneck Cinoto 9
Yuhei Takagi (高木佑平) 9
Jakub Wojtaszewski 9
Hunor Bózsing 9
Hideki Niina (新名秀樹) 9
Kevin Costello III 9
Dániel Varga 9
Akash Rupela 9
Enzo Gonçalves Motta 9
Geert Bicler 9
Fangyuan Chang (常方圆) 9
Serhii Koksharov (Сергій Кокшаров) 9
Yihao Zhao (赵羿皓) 9
Artur Kristof 9
Jesús Masanet García 9
Corey Sakowski 9
Fabio Bini Graciose 9
Louis Cormier 9
Nathaniel Berg 9
Noah Arthurs 9
Lorenzo Vigani Poli 9
Błażej Cichy 9
Klaudia Ciuk 9
Javier Tirado Ortiz 8
Ivan Zabrodin 8
Piotr Pojda 8
Marcin Kowalczyk 8
Denys Haidaichuk 8
Alexander Olleta del Molino 8
Kacper Stacha 8
Kalina Brzezińska 8
Bhargav Narasimhan 8
Andrii Vedenov (Андрій Веденьов) 8
Chia-Wei Lu (呂家維) 8
Xusheng Hong (洪旭升) 8
Matteo Provasi 8
Vikram Mada 8
Alain Cormier 8
John Brechon 8
Maria Oey 8
Ihor Bilchenko (Ігор Більченко) 8
Piotr Kuchta 8
Piotr Trząski 8
Thompson Clarke 8
Siva Shanmukh Vetcha 8
Taku Yanai (矢内拓) 8
Leon Schmidtchen 8
Shreyas Nagananda Talamakki 8
Marcin Jakubowski 8
Patrycja Michalska 8
Kamil Mieńko 8
Brandon Mikel 8
Gaurav Taneja 8
Dan Selzer 7
Yuuki Kobayashi (古林祐輝) 7
Blake Thompson 7
Anant Pingle 7
Alessandro Manopulo 7
Qingwei Kong (孔庆玮) 7
Helmut Heilig 7
Patrycja Głodzińska 7
Ryan Lim 7
Eric Limeback 7
Dhanayush Raninga 7
Bruno Galati Paladino Cricelli 7
Shivam Bansal 7
Szymon Mazur 7
Bartosz Jasiewicz 7
Lars Vandenbergh 7

 

[Julian]

Here you go:

Spoiler

Wojciech Szatanowski 17
François Courtès 16
Tomasz Żołnowski 16
Kit Clement 15
Ryan DeLine 14
Mateusz Cichoracki 13
Przemysław Kaleta 13
Michał Halczuk 13
Olivér Perge 13
James Hildreth 13
Wojciech Knott 13
Sébastien Auroux 12
Nikolett Placskó 12
Laura Ohrndorf 12
Andreas Pohl 11
Paweł Kowol 11
Jan Bentlage 11
Nathan Dwyer 11
Radosław Ciuk 11
István Kocza 10
Lauren Klemz 10
Bence Barát 10
Anders Larsson 10
Sarah Strong 10
Marcin Zalewski 10
Mateusz Fydrych 10
Ming Zheng (郑鸣) 10
Michael Kristel 10
Krzysztof Kuncki 10
Tim Wong 10
Jakub Wolniewicz 10
Rafael Werneck Cinoto 9
Yuhei Takagi (高木佑平) 9
Jakub Wojtaszewski 9
Hunor Bózsing 9
Hideki Niina (新名秀樹) 9
Kevin Costello III 9
Dániel Varga 9
Akash Rupela 9
Enzo Gonçalves Motta 9
Geert Bicler 9
Fangyuan Chang (常方圆) 9
Serhii Koksharov (Сергій Кокшаров) 9
Yihao Zhao (赵羿皓) 9
Artur Kristof 9
Jesús Masanet García 9
Corey Sakowski 9
Fabio Bini Graciose 9
Louis Cormier 9
Nathaniel Berg 9
Noah Arthurs 9
Lorenzo Vigani Poli 9
Błażej Cichy 9
Klaudia Ciuk 9
Javier Tirado Ortiz 8
Ivan Zabrodin 8
Piotr Pojda 8
Marcin Kowalczyk 8
Denys Haidaichuk 8
Alexander Olleta del Molino 8
Kacper Stacha 8
Kalina Brzezińska 8
Bhargav Narasimhan 8
Andrii Vedenov (Андрій Веденьов) 8
Chia-Wei Lu (呂家維) 8
Xusheng Hong (洪旭升) 8
Matteo Provasi 8
Vikram Mada 8
Alain Cormier 8
John Brechon 8
Maria Oey 8
Ihor Bilchenko (Ігор Більченко) 8
Piotr Kuchta 8
Piotr Trząski 8
Thompson Clarke 8
Siva Shanmukh Vetcha 8
Taku Yanai (矢内拓) 8
Leon Schmidtchen 8
Shreyas Nagananda Talamakki 8
Marcin Jakubowski 8
Patrycja Michalska 8
Kamil Mieńko 8
Brandon Mikel 8
Gaurav Taneja 8
Dan Selzer 7
Yuuki Kobayashi (古林祐輝) 7
Blake Thompson 7
Anant Pingle 7
Alessandro Manopulo 7
Qingwei Kong (孔庆玮) 7
Helmut Heilig 7
Patrycja Głodzińska 7
Ryan Lim 7
Eric Limeback 7
Dhanayush Raninga 7
Bruno Galati Paladino Cricelli 7
Shivam Bansal 7
Szymon Mazur 7
Bartosz Jasiewicz 7
Lars Vandenbergh 7

I've also been to 7, as of last weekend. Older export I guess.

 

[TMOY]

Not a very old export since Euro is taken into account. Maybe your last comp has not been entered into the database yet.

And wow, the Polish guys are getting hard to beat...

 

[Sebastien]

I've also been to 7, as of last weekend. Older export I guess.

Haha, no. I didn't use any export, I directly used the database, but I just took the Top 100 so the results have surely been cut in the 7s, sorry.

 

[AlexMaass]

most podiums set by a cuber who has only podiumed in one event?

 

[antoineccantin]

Lauren Klemz 10

Man, I wish I was Kit's gf.

 

[Skullush]

Man, I wish I was Kit's gf.

We all do