States, Provences, Counties

[nwadeltaboy]

Kudos to the guy that does the USA!

I'm working on it.  It's gonna be fun!

[iranair777]

Iran:
(102, 'Ardabil'), (102, 'East Azarbaijan'), (102, 'West Azarbaijan'), (102, 'Gilan'), (102, 'Zanjan'), (102, 'Kordestan'), (102, 'Qazvin'), (102, 'Hamadan'), (102, 'Kermanshah'), (102, 'Tehran'), (102, 'Markazi'), (102, 'Qom'), (102, 'Lorestan'), (102, 'Iilam'), (102, 'Golestan'), (102, 'Semnan'), (102, 'Esfahan'), (102, 'Chaharmadhal and Bakhtiari'), (102, 'Khuzestan'), (102, 'North Khorasan'), (102, 'Kohgiluyeh and Boyer Ahmad'), (102, 'Razavi Khorasan'), (102, 'Yasd'), (102, 'Fars'), (102, 'Bushehr'), (102, 'South Khorasan'), (102, 'Kerman'), (102, 'Hormozgan'), (102, 'Sistan and Baluchestan')

Edit: ~ AEB ~ Added after all this time... thanks again

[Kaz]

Lithuania:
(126, 'Alytus'), (126, 'Kaunas'), (126, 'Klaip?da'), (126, 'Marijampol?'), (126, 'Panev?žys'), (126, 'Šiauliai'), (126, 'Taurag?'), (126, 'Telšiai'), (126, '?tena'), (126, 'Vilnius')

They actually have the word county after each name, because each county in Lithuania is named after a bigger city. Hope this helps.  :wink:


Edit: ~ AEB ~ Added after all this time... thanks again

[SeaBlue Pacific Air]

Philippines:
(173, 'National Capital Region'), (173, 'Cordillera Administrative Region'), (173, 'Ilocos Region'), (173, 'Cagayan Valley'), (173, 'Central Luzon'), (173, 'Calabarzon'), (173, 'Mimaropa'), (173, 'Bicol Region'), (173, 'Western Visayas'), (173, 'Central Visayas'), (173, 'Eastern Visayas'), (173, 'Zamboanga Peninsula'), (173, 'Northern Mindanao'), (173, 'Davao Region'), (173, 'Soccsksargen'), (173, 'Caraga'), (173, 'Autonomous Region in Muslim Mindanao')

National Capital Region: 472
Cordillera Administrative Region: 827
Ilocos Region: 803, 1096
Cagayan Valley: 1093, 845
Central Luzon: 793, 904
Mimaropa: 905, 843, 836, 847
Bicol Region: 720, 842, 907, 1099
Western Visayas: 719, 906, 792, 826, 837
Central Visayas: 471, 841, 844
Eastern Visayas: 840
Zamboanga Peninsula: 909, 1097, 838
Northern Mindanao: 1095, 1094, 839, 1098
Davao Region: 470
Soccsksargen: 846, 795
Caraga: 910, 1092
Autonomous Region in Muslim Mindanao: 908

Edit: Added by StephenM

[matheusjaja]

Brazil:

(30, 'Acre'), (30, 'Alagoas'), (30, 'Amapá'), (30, 'Amazonas'), (30, 'Bahia'), (30, 'Ceará'), (30, 'Distrito Federal'), (30, 'Espírito Santo'), (30, 'Goiás'), (30, 'Maranhão'), (30, 'Mato Grosso'), (30, 'Mato Grosso do Sul'), (30, 'Minas Gerais'), (30, 'Pará'), (30, 'Paraíba'), (30, 'Paraná'), (30, 'Pernanbuco'), (30, 'Piauí'), (30, 'Rio de Janeiro'), (30, 'Rio Grande do Norte'), (30, 'Rio Grande do Sul'), (30, 'Rondônia'), (30, 'Roraima'), (30, 'Santa Catarina'), (30, 'São Paulo'), (30, 'Sergipe'), (30, 'Tocantins')

These are the 26 brazilian states, plus "Distrito Federal", that is a district (like Washigton DC, USA) created to place the new capital city in the 50´s/60´s.

I hope this helps.

P.S. If someone tells me how do I get the airport codes, i can try to put then in their respective states when i got some free time.

[AirHanoverInternational]

When you view an airport the ID is shown in the address bar.

[EVA_Air]

101 Indonesia

(101, 'Bali'), (101, 'Bangka-Belitung'), (101, 'Banten'), (101, 'Bengkulu'), (101, 'Central Java'), (101, 'Central Kalimantan'), (101, 'Central Sulawesi'), (101, 'East Java'), (101, 'East Kalimantan'), (101, 'East Nusa Tenggara'), (101, 'Gorontalo'), (101, 'Jakarta Special Capital Region'), (101, 'Jambi'), (101, 'Lampung'), (101, 'Maluku'), (101, 'Nanggroe Aceh Darussalam'), (101, 'North Maluku'), (101, 'North Sulawesi'), (101, 'North Sumatra'), (101, 'Papua'), (101, 'Riau'), (101, 'Riau Islands'), (101, 'South East Sulawesi'), (101, 'South Kalimantan'), (101, 'South Sulawesi'), (101, 'South Sumatra'), (101, 'West Java'), (101, 'West Kalimantan'), (101, 'West Nusa Tenggara'), (101, 'West Papua'), (101, 'West Sulawesi'), (101, 'West Sumatra'), (101, 'Yogyakarta Special Region')

There are four provinces received special status: Nanggroe Aceh Darussalam, Yogyakarta Special Region, Papua, and Jakarta Special Capital Region.

Later on I will try to update those airports in Indonesia that haven't been included in the game. In facts there are several airport that is pretty big and popular here that is not included in the game.
Hope can help!
 

[CHR]

Argentina:
(10, 'Buenos Aires'), (10, 'Buenos Aires Federal Capital'), (10, 'Catamarca'), (10, 'Chaco'), (10, 'Chubut'), (10, 'Cordoba'), (10, 'Corrientes'), (10, 'Entre Rios'), (10, 'Formosa'), (10, 'Jujuy'), (10, 'La Pampa'), (10, 'La Rioja'), (10, 'Mendoza'), (10, 'Misiones'), (10, 'Neuquen'), (10, 'Rio Negro'), (10, 'Salta'), (10, 'San Juan'), (10, 'San Luis'), (10, 'Santa Cruz'), (10, 'Santa Fe'), (10, 'Santiago del Estero'), (10, 'Tierra del Fuego'), (10, 'Tucuman')

Buenos Aires: 1928,373,2071,377,1969,1968
Buenos Aires Federal Capital: 372
Catamarca: 1955
Chaco: 1919
Chubut: 1954,374,1960,1961,1921,1975,1979,1964
Cordoba: 375,1977
Corrientes: 1764,1971
Entre Rios: 1956,1970
Formosa: 1256
Jujuy: 1765
La Pampa: 1953
La Rioja: 1965
Mendoza: 1461,1967,1986
Misiones: 376,1973
Neuquen: 1922,1957,1918
Rio Negro: 1958,1962,1982,1926,380
Salta: 379
San Juan: 1984
San Luis: 1983
Santa Cruz: 1959,1966,1974,378,1985,1972,1963,1980
Santa Fe: 1981,1920,1976
Santiago del Estero: 1925
Tierra del Fuego: 1978,1462
Tucuman: 381

I didn't get the data, but a number of airport's passenger numbers seem to be out for Argentina. There are also a few missing airports.

Aruba:
No divisions (part of the Kingdom of the Netherlands)

Airports: 407

Edit: Added by StephenM - Thanks

[takas]

China:
(44,'Beijing'), (44,'Tianjin'), (44,'Shanghai'), (44,'Chongqing'), (44,'Heilongjiang'), (44,'Jilin'), (44,'Liaoning'), (44,'Qinghai'), (44,'Gansu'), (44,'Shaanxi'), (44,'Shanxi'), (44,'Henan'), (44,'Hebei'), (44,'Sichuan'), (44,'Yunnan'), (44,'Guizhou'), (44,'Hunan'), (44,'Hubei'), (44,'Shandong'), (44,'Anhui'), (44,'Jiangsu'), (44,'Jiangxi'), (44,'Zhejiang'), (44,'Fujian'), (44,'Guangdong'), (44,'Guangxi'), (44,'Hainan'), (44,'Xinjiang'), (44,'Tibet'), (44,'Inner Mongolia'), (44,'Ningxia')

Subdivision are not significant for:
Hong Kong, Macau and Taiwan

[CHR]

Bahamas
(16,'Bahamas')
Bahamas: 408, 409

There are a number of districts in the Bahamas, in fact 21, but as there are only two airports, I don't think it needs dividing.

Similarily, Bahrain (with a grand total of one airport).

Bahrain
(17,'Bahrain')
Bahrain: 488

However, Bangladesh...

Bangladesh
(18,'Barisal'), (18,'Chittagong'), (18,'Dhaka'), (18,'Khulna'), (18,'Rajshahi'), (18,'Sylhet')
Barisal: 2756
Chittagong: 2025
Dhaka: 1594
Khulna: 2757
Rajshahi: 2758, 2759
Sylhet: 1595

Missing: Cox's Bazar Airport, CXB, VGCB (no pax. data can be found), in Chittagong
Also, 2758 and 2759 have exactly the same pax. number - an error?

Barbados
(19,'Barbados')
Barbados: 410

Edit: Added by StephenM - Thanks

[nwadeltaboy]

Will, if you gave me the actual states' keys, I could throw together a query for you for lots of the US airports/states, as well as some other countries as well.

[Svejk]

...

21 Belgium
(21, 'Brussels-Capital Region') (21, 'Flander') (21, 'Walloon')
Brussels-Capital Region: 2202, 1469
Flander:643, 1157
Walloon: 660

This is not entirely correct.

1) Flander and Walloon are incorrect. It's Flanders and Wallonia
2) The airports of Brussels are actually not inside the Brussels Capital Region.

Making this:

21 Belgium
(21, 'Flanders') (21, 'Wallonia') (21, 'Brussels Capitol Region')
Flanders: 643, 1157, 2202
Wallonia: 660, 1469

EDIT: ~ AEB ~ Thanks for the clarification/correction.  Applied.

[asmo26]

Country 155 'Netherlands Antilles' does not excist anymore. 4 islands desided to become an providence of The Netherlands. The others are independent now. All of these islands have one (or more) airports.

[Severnaya]

Country 155 'Netherlands Antilles' does not excist anymore. 4 islands desided to become an providence of The Netherlands. The others are independent now. All of these islands have one (or more) airports.

This has not been officialy been implemented....yet

[DarkPet]

Serbia (193)

(193,'Serbia'), (193,'Vojvodina'), (193,'Kosovo and Metohija')

Serbia: 1191, 1798
Kosovo and Metohija: 1281

Montenegro (146)

(146,'Montenegro')

Montenegro: 1570, 1799

Croatia (54)

(54,'Central Croatia'), (54,'Dalmatia and Istria'), (54,'Slavonia')

Central Croatia: 858
Dalmatia and Istria: 3159, 857, 1841, 1800, 1107, 1279
Slavonia: 3070

Edit: Added by StephenM - Thanks