States, Provences, Counties

[Med Air]

France:
(73, 'Nord-Pas-De-Calais') (73, 'Picardie') (73, 'Haute-Normandie') (73, 'Ile-De-France') (73, 'Champagne-Ardenne') (73, 'Lorraine') (73, 'Alsace') (73, 'Basse-Normandie') (73, 'Bretagne') (73, 'Pays De La Loire') (73, 'Centre') (73, 'Bourgogne') (73, 'Franche-Comte') (73, 'Poitou-Charentes') (73, 'Limousin') (73, 'Auvergne') (73, 'Rhone-Alpes') (73, 'Aquitaine') (73, 'Midi-Pyrenees') (73, 'Languedoc-Roussillon') (73, 'Alpes-Cote d'Azur') (73, 'Corse')

Japan:
(109, 'Sapporo-ken') (109, 'Nemuro-ken') (109, 'Kagoshima-ken') (109, 'Iwate-ken') (109, 'Fukushima-ken') (109, 'Nagano-ken') (109, 'Niigata-ken') (109, 'Akita-ken') (109, 'Gifu-ken') (109, 'Aomori-ken') (109, 'Yamagata-ken') (109, 'Hy?go-ken') (109, 'Miyagi-ken') (109, 'Ishikawa-ken') (109, 'Hiroshima-ken') (109, 'Hakodate-ken') (109, 'Shizuoka-ken') (109, 'Kumamoto-ken') (109, 'K?chi-ken') (109, 'Ehime-ken') (109, 'Shimane-ken') (109, 'Okayama-ken') (109, 'Tochigi-ken') (109, 'Gunma-ken') (109, '?ita-ken') (109, 'Nagasaki-ken') (109, 'Yamaguchi-ken') (109, 'Ibaraki-ken') (109, 'Mie-ken') (109, 'Chiba-ken') (109 'Fukuoka-ken') (109 '?saka-fu') (109, 'Aichi-ken') (109, 'Wakayama-ken') (109, 'Ky?to-fu') (109, 'Yamanashi-ken') (109, 'Fukui-ken') (109, 'Tokushima-ken') (109 'Saitama-ken') (109, 'Shiga-ken') (109, 'Kanagawa-ken') (109, 'Tottori-ken') (109, 'Okinawa-ken') (109, 'T?ky?-fu')

Sweden:
(209, 'Stockholm') (209, 'Vasterbotten') (209, 'Norrbotten') (209, 'Uppsala') (209, 'Sodermanland') (209, 'Ostergotland') (209, 'Jonkoping') (209, 'Kronoberg') (209, 'Kalmar') (209, 'Gotland') (209, 'Blekinge') (209, 'Skane') (209, 'Halland') (209, 'Vastra Gotaland') (209, 'Varmland') (209, 'Orebro') (209, 'Vastmanland') (209, 'Dalarna') (209, 'Gavleborg') (209, 'Vasternorrland') (209, 'Jamtland')

[Med Air]

Japan:

"(109 '?saka-fu')"

I apologise for the question marks, it doesn't recognise accented letters. Most of the question marks replaced o's

[Med Air]

Continuing from my list above...

Sweden:
AGH - 'Gotland'
AJR - 'Norrbotten'
BLE - 'Dalarna'
GSE - 'Vastra Gotaland' (Please note inconsistency in the airport's city list here. Gothenburg and Goteborg are the same city. Goteborg is the Swedish spelling.)
GOT - 'Vastra Gotaland' (Please note inconsistency in the airport's city list here. Gothenburg and Goteborg are the same city. Goteborg is the Swedish spelling.)
HFS - 'Varmland'
HAD - 'Halland'
EVG - 'Jamtland'
HMV - 'Vasterbotten'
HLF - 'Kalmar'
JKG - 'Jonkoping'
KLR - 'Kalmar'
KSD - 'Varmland'
KRN - 'Norrbotten'
KRF - 'Vasternorrland'
KID - 'Skane'
GEV - 'Norrbotten'
LPI - 'Ostergotland'
LLA - 'Norrbotten'
LYC - 'Vasterbotten'
MMX - 'Skane'
MXX - 'Dalarna'
NRK - 'Ostergotland'
ORB - 'Orebro'
OER - 'Vasternorrland'
OSK - 'Kalmar'
OSD - 'Jamtland'
PJA - 'Norrbotten'
RNB - 'Blekinge'
VHM - 'Vasterbotten' (I believe the airport is called 'Vilhelmina' not 'Sagadal')
SFT - 'Vasterbotten'
VXO - 'Kronoberg' (I believe the airport is called 'Vaxjo-Smaland' not just 'Smaland' hence where the IATA 'VXO' comes from.)
NYO - 'Sodermanland' (Continuity error, add hyphen in name between 'Stockholm' and 'Skavsta')
ARN - 'Stockholm'
BMA - 'Stockholm'
VST - 'Vastmanland'
SQO - 'Vasterbotten' (I believe the airport is called 'Storuman' not 'Storumans')
SDL - 'Vasternorrland'
TYF - 'Varmland'
THN - 'Vastra Gotaland'
UME - 'Vasterbotten'
VBY - 'Gotland'

Please note that the Counties have accents, which I have not added.
I will do the same for French and Japanese airports soon.

[norge]

Italy (107)

(38, 'Abruzzo'), (38, 'Aosta Valley'), (38, 'Apulia'), (38, 'Basilicata'), (38, 'Calabria'), (38, 'Campania'), (38, 'Emilia–Romagna'), (38, 'Friuli–Venezia Giulia'), (38, 'Lazio'), (38, 'Liguria'), (38, 'Lombardy'), (38, 'Marche'), (38, 'Molise'), (38, 'Piedmont'), (38, 'Sardinia'), (38, 'Sicilia'), (38, 'Tuscany'), (38, 'Trentino-Alto Adige/Südtirol'), (38, 'Umbria'), (38, 'Veneto')

Airports in the regions:
Abruzzo: 1441
Aosta Valley: 2274
Apulia: 2275, 1453, 1454, 3786
Basillicata: no airport
Calabria: 1276, 2267, 2276
Campania: 153, 3785
Emilia-Romagna: 1458, 2266, 154, 1457
Friuli-Venezia Giulia: 1459
Lazio: 1102, 149
Liguria: 2272, 2108
Lombardy: 2263, 151, 150, 155
Marche: 1452
Molise: no airport
Piedmont: 3787, 2271, 854
Sardinia: 1278, 1455, 1456, 3117
Sicilia: 1105, 1106, 2264, 2265, 1104
Tuscany: 152, 3340, 859, 3341, 2273
Trentino-Alto Adige/Südtiro: 2268
Umbria: 2270
Veneto: 3342, 636, 1190, 1460

[sallu]

India:

(100, 'Andaman and Nicobar Islands'), (100, 'Andhra Pradesh'), (100, 'Arunachal Pradesh'), (100, 'Assam'), (100, 'Bihar'), (100, 'Chandigarh'), (100, 'Chhattisgarh'), (100, 'Daman and Diu'), (100, 'Delhi'), (100, 'Goa'), (100, 'Gujarat'), (100, 'Haryana'), (100, 'Himachal Pradesh'), (100, 'Jammu and Kashmir'), (100, 'Jharkhand'), (100, 'Karnataka'), (100, 'Kerala'), (100, 'Lakshadweep'), (100, 'Madhya Pradesh'), (100, 'Maharashtra'), (100, 'Manipur'), (100, 'Meghalaya'), (100, 'Mizoram'), (100, 'Nagaland'), (100, 'Orissa'), (100, 'Pondicherry'), (100, 'Punjab'), (100, 'Rajasthan'), (100, 'Tamil Nadu'), (100, 'Tripura'), (100, 'Uttar Pradesh'), (100, 'Uttarakhand'), (100, 'West Bengal')

Andaman and Nicobar Islands: 2254
Andhra Pradesh: 1496, 2407, 2415, 2417, 2342
Arunachal Pradesh: 2414
Assam: 2379, 508, 2390, 2411, 2413, 3517
Bihar: 3519, 2055
Chandigarh: 2378
Chhattisgarh: 2408
Daman and Diu: 2380
Delhi: 506
Goa: 507
Gujarat: 503, 2335, 2375, 2416, 2389, 2392, 2395, 2406, 2409, 2412, 2416
Himachal Pradesh: 2393, 2397, 2410
Jammu and Kashmir: 2388, 2400, 2339
Jharkhand: 2401
Karnataka: 2385, 876, 2376, 2278
Kerala: 1499, 504, 1781
Lakshadweep: 2372
Madhya Pradesh: 2377, 2384, 2387, 2391, 2338
Maharashtra: 2374, 2396, 511, 3518, 2279, 2404
Manipur: 2386
Mizoram: 2373
Nagaland: 2382
Orissa: 2336,
Pondicherry: 2405
Punjab: 1517, 2402, 3516
Rajasthan: 509, 2337, 2341
Tamil Nadu: 505, 2054, 2403, 2340
Uttar Pradesh: 2333, 2371, 2383, 2394, 2280, 2343
Uttarakhand: 2381, 3515
West Bengal: 510, 2334



Missing ones at AirlineMogul
Andaman and Nicobar Islands: VOCX
Andhra Pradesh: VOCP, VODK, VODG, VOHS, VOPN, VOBZ, VOWA
Arunachal Pradesh: VEAN, VEDZ, VEPG, VEZO
Assam: VECA, VEKR, VERU
Bihar: VEMZ, VEPU, VERL
Chhattisgarh: VABI
Daman and Diu: VADN
Delhi: VIDD
Gujarat: VASN, VIUT
Haryana: VIAM
Jammu and Kashmir: VISR, VIUX
Jharkhand: VECK, VEJS
Karnataka: VOBL, VOYK, VOBI, VOBR, VOMY
Kerala: VOCC
Madhya Pradesh: VAKD, VIST
Maharashtra: VAAK, VAND, VANR, VAOZ, VARG, VASL
Meghalaya: VEBI
Orissa: VEHK, VEJH, VEKN, VERK
Punjab: VIAX, VIBT, VIHX, VIPL
Rajasthan: VIBK, VIJR, VIKO
Tamil Nadu: VOAR, VOTX, VO95, VOSM, VOSX, VOTJ, VOVR
Tripura: VEKR, VEKM, VEKW
Uttar Pradesh: VIBL, VIBY, VIJN, VICX, VILP
West Bengal: VEBG, VEBR, VEBA, VECO, VEHX, VEDX, VEMH, VEPH, VETK

[pck]

YAY! I contributed through the Malaysian list.

Sorry, I just had to celebrate because I've finally actually done something for the community for the 3 years I've been playing.

[barmansky]

Poland (without special polish marks, because database have problems with it):

(175, 'Dolnoslaskie'), (175, 'Kujawsko-Pomorskie'), (175, 'Lubelskie'), (175, 'Lubuskie'), (175, 'Lodzkie'), (175, 'Malopolskie'), (175, 'Mazowieckie'), (175, 'Opolskie'), (175, 'Podkarpackie'), (175, 'Podlaskie'), (175, 'Pomorskie'), (175, 'Slaskie'), (175, 'Swietokrzyskie'), (175, 'Warminsko-Mazurskie'), (175, 'Wielkopolskie'), (175, 'Zachodniopomorskie')

Airports:
Dolnoslaskie: 182
Kujawsko-Pomorskie: 171
Lubelskie: (none)
Lubuskie: 2038
Lodzkie: 175
Malopolskie: 173
Mazowieckie: 180
Opolskie: (none)
Podkarpackie: 178
Podlaskie: (none)
Pomorskie: 172
Slaskie: 174
Swietokrzyskie: (none)
Warminsko-Mazurskie: 2039
Wielkopolskie: 177
Zachodniopomorskie: 179

And the correct names of towns (1st) and airports (2nd):
BZG: Bydgoszcz, Port Lotniczy im. Ignacego Jana Paderewskiego
GDN: Gdansk, Port Lotniczy Gdansk im. Lecha Walesy
KRK: Krakow-Balice, Miedzynarodowy Port Lotniczy im. Jana Pawla II
KTW: Katowice-Pyrzowice, Miedzynarodowy Port Lotniczy Katowice
LCJ: Lodz, Port Lotniczy Lodz im. Wladyslawa Reymonta
POZ: Poznan, Port Lotniczy Poznan-Lawica
RZE: Rzeszow-Jasionka, Port Lotniczy Rzeszow-Jasionka
SZZ: Goleniow, Port Lotniczy Szczecin-Goleniow im. NSZZ Solidarnosc
SZY: Szczytno-Szymany, Port Lotniczy Mazury
WAW: Warszawa, Lotnisko Chopina w Warszawie
WRO: Wroclaw, Port Lotniczy Wroclaw
IEG: Babimost, Port Lotniczy Zielona Gora/Babimost

[clarkjordan12345]

Can I do the United Kingdom again but put it into the proper counties rather than just Scotland, England, Northern Ireland and Wales?

[Cloudscraper]

Can I do the United Kingdom again but put it into the proper counties rather than just Scotland, England, Northern Ireland and Wales?

The United Kingdom does need doing again. Regional government in England (the regional  development agencies) is being abolished. The proper top level division is into England, Scotland, Wales and Northern Ireland anyway.

(229, 'Scotland'), (229, 'Wales'), (229, 'England'), (229, 'Northern Ireland')


Scotland: 40, 41, 47, 49, 60, 66, 70, 71, 73, 2229, 2215, 2429, 2430, 2433, 2436, 2440, 2441,
Wales: 53, 1391, 2795,
England: 46, 61, 2432, 7, 35, 37, 39, 51, 2431, 43, 45, 54, 36, 64, 1399, 3072, 3128, 52, 67, 1425, 2438, 2439, 2936, 42, 55, 56, 65, 69, 72, 2428, 2434, 2435, 38, 58, 48, 59, 62,
Northern Ireland: 44, 50, 68,

[germanpaparoni]

Venezuela: 235

(235, 'Amazonas'), (235, 'Apure'), (235, 'Aragua'), (235, 'Anzoátegui'), (235, 'Barinas'), (235, 'Bolivar'), (235, 'Carabobo'), (235, 'Cojedes'), (235, 'Delta Amacuro'), (235, 'Dependencias Federales'), (235, 'Distrito Capital'), (235, 'Falcón'), (235, 'Guárico'), (235, 'Lara'), (235, 'Mérida'), (235, 'Miranda'), (235, 'Monagas'), (235, 'Nueva Esparta'), (235, 'Portuguesa'), (235, 'Sucre'), (235, 'Táchira'), (235, 'Trujillo'), (235, 'Vargas'), (235, 'Yaracuy'), (235, 'Zulia')

Amazonas: 1888
Apure: 1938, 1943, 1939
Aragua: 1942
Anzoátegui: 1944, 1881
Barinas: 1887
Bolivar: 1933, 1884, 1886
Carabobo: 1870
Cojedes: (none)
Delta Amacuro: (none)
Dependencias Federales: 1941
Distrito Capital: (none)
Falcón: 1935, 1940
Guárico: (none)
Lara: 1882
Mérida: 1883, 1937
Miranda: (none)
Monagas: 1885
Nueva Esparta: 1671
Portuguesa: 1932
Sucre: 1936, 1934
Táchira: 1877, 1879, 1878, 1880
Trujillo: 1946
Vargas: 351
Yaracuy: (none)
Zulia: 1672, 1945

 

[1993matias]

Is it possible for you to update the list of done countries? I see Denmark is listed as undone, but in the game it already has provinces.

[StephenM]

Is it possible for you to update the list of done countries? I see Denmark is listed as undone, but in the game it already has provinces.

I think I put that off due to the tediousness of the task. It should really be updated though alright.

[Ghiby]

180    Romania

(180, 'Muntenia'), (180, 'Moldova'), (180, 'Transilvania'), (180, 'Dobrogea'), (180. 'Banat')

Airports

Muntenia 622, 2456
Moldova 2459, 3205, 3206
Translivania 3423, 1495, 2460, 3386, 2457
Banat 1494
Dobrogea 2458

my little 2 cents on this project

[A380YURY]

Disclaimer - Leningrad region, Sverdlovsk region are real names of these regions, not cities! No need to worry about them.

181 Russian Federation

(181, 'Moscowskaja oblast'), (181,'Leningradskaja oblast'), (181, 'Pskovskaja oblast'), (181, 'Novgorodskaja oblast'), (181, 'Tverskaja oblast'), (181, 'Smolenskaja oblast'), (181, 'Bryanskaja oblast'), (181, 'Kaluzhskaja oblast'), (181, 'Tulskaja oblast'), (181, 'Orlovskaja oblast'), (181, 'Kurskaja oblast'), (181, 'Lipetskaja oblast'), (181, 'Belgorodskaja oblast'), (181, 'Tambovskaja oblast'), (181, 'Voronezhskaja oblast'), (181, 'Volgogradskaja oblast'), (181, 'Rostovskaja oblast'), (181, 'Astrakhanskaja oblast'), (181, 'Kalmykija'), (181, 'Krasnodarsky kraj'), (181, 'Stavropolsky kraj'), (181, 'Adygeja'), (181, 'Karachaevo-Cherkessija'), (181, 'Kabardino - Balkarija'), (181, 'Severnaja Osetia'), (181, 'Ingushetija'), (181, 'Chechnja'), (181, 'Dagestan'), (181, 'Murmanskaja oblast'), (181, 'Karelija'), (181, 'Arkhangelskaja oblast'), (181, 'Vologodskaja oblast'), (181, 'Yaroslavskaja oblast'), (181, 'Kostromskaja oblast'), (181, 'Ivanovskaja oblast'), (181, 'Vladimirskaja oblast'), (181, 'Nizhegorodskaja oblost'), (181, 'Ryazanskaja oblast'), (181, 'Mordovija'), (181, 'Penzenskaja oblast'), (181, 'Saratovskaja oblast'), (181, 'Samarskaja oblast'), (181, 'Uljanovskaja oblast'), (181, 'Tatarstan'), (181, 'Chuvashija'), (181, 'Marij El'), (181, 'Kirovskaja oblast'), (181, 'Udmurtija'), (181, 'Komi'), (181, 'Nenets autonomous district'), (181, 'Permsky kraj'), (181, 'Bashkortostan'), (181, 'Orenburzhskaja oblast'), (181, 'Chelyabinskaja oblast'), (181, 'Kurganskaja oblast'), (181, 'Sverdlovskaja oblast'), (181, 'Tumenskaja oblast'), (181, 'Khanty-Mansijsky autonomous district'), (181, 'Yamalo-Nenets autonomous district'), (181, 'Tomskskaja oblast'), (181, 'Novosibirskaja oblast'), (181, 'Kemerovo district'), (181, 'Altajsky kraj'), (181, 'Altaj'), (181, 'Tuva'), (181, 'Khakasija'), (181, 'Krasnoyarsky kraj'), (181, 'Irkutskaja oblast'), (181, 'Buryatija'), (181, 'Chitinskaja oblast'), (181, 'Sakha (Yakutija)'), (181, 'Amurskaja oblast'), (181, 'Khabarovsky kraj'), (181, 'Primorsky kraj'), (181, 'Jewish autonomous district'), (181, 'Sakhalinskaja oblast'), (181, 'Magadanskaja oblast'), (181, 'Chukotsky autonomous district'), (181, 'Kamchatsky kraj')

Airports are still to go)

08/08 - corrected some names. Regions are renamed to 'Oblast'

P.S. Noobish question - where can I get the list of airports with their ID's?

[Shawa]

Oblast looks better imho.