
CREATE TABLE city (
	"ID" INTEGER NOT NULL, 
	"Name" CHAR(35) DEFAULT '' NOT NULL, 
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"District" CHAR(20) DEFAULT '' NOT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	PRIMARY KEY ("ID"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)


CREATE TABLE country (
	"Code" CHAR(3) DEFAULT '' NOT NULL, 
	"Name" CHAR(52) DEFAULT '' NOT NULL, 
	"Continent" TEXT DEFAULT 'Asia' NOT NULL, 
	"Region" CHAR(26) DEFAULT '' NOT NULL, 
	"SurfaceArea" FLOAT DEFAULT '0.00' NOT NULL, 
	"IndepYear" INTEGER DEFAULT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	"LifeExpectancy" FLOAT DEFAULT NULL, 
	"GNP" FLOAT DEFAULT NULL, 
	"GNPOld" FLOAT DEFAULT NULL, 
	"LocalName" CHAR(45) DEFAULT '' NOT NULL, 
	"GovernmentForm" CHAR(45) DEFAULT '' NOT NULL, 
	"HeadOfState" CHAR(60) DEFAULT NULL, 
	"Capital" INTEGER DEFAULT NULL, 
	"Code2" CHAR(2) DEFAULT '' NOT NULL, 
	PRIMARY KEY ("Code")
)


CREATE TABLE countrylanguage (
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"Language" CHAR(30) DEFAULT '' NOT NULL, 
	"IsOfficial" TEXT DEFAULT 'F' NOT NULL, 
	"Percentage" FLOAT DEFAULT '0.0' NOT NULL, 
	PRIMARY KEY ("CountryCode", "Language"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)

CREATE TABLE city (
	"ID" INTEGER NOT NULL, 
	"Name" CHAR(35) DEFAULT '' NOT NULL, 
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"District" CHAR(20) DEFAULT '' NOT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	PRIMARY KEY ("ID"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)

/*
2 rows from city table:
ID	Name	CountryCode	District	Population
1	Kabul	AFG	Kabol	1780000
2	Qandahar	AFG	Qandahar	237500
*/


CREATE TABLE country (
	"Code" CHAR(3) DEFAULT '' NOT NULL, 
	"Name" CHAR(52) DEFAULT '' NOT NULL, 
	"Continent" TEXT DEFAULT 'Asia' NOT NULL, 
	"Region" CHAR(26) DEFAULT '' NOT NULL, 
	"SurfaceArea" FLOAT DEFAULT '0.00' NOT NULL, 
	"IndepYear" INTEGER DEFAULT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	"LifeExpectancy" FLOAT DEFAULT NULL, 
	"GNP" FLOAT DEFAULT NULL, 
	"GNPOld" FLOAT DEFAULT NULL, 
	"LocalName" CHAR(45) DEFAULT '' NOT NULL, 
	"GovernmentForm" CHAR(45) DEFAULT '' NOT NULL, 
	"HeadOfState" CHAR(60) DEFAULT NULL, 
	"Capital" INTEGER DEFAULT NULL, 
	"Code2" CHAR(2) DEFAULT '' NOT NULL, 
	PRIMARY KEY ("Code")
)

/*
2 rows from country table:
Code	Name	Continent	Region	SurfaceArea	IndepYear	Population	LifeExpectancy	GNP	GNPOld	LocalName	GovernmentForm	HeadOfState	Capital	Code2
ABW	Aruba	North America	Caribbean	193.0000000000	None	103000	78.4000000000	828.0000000000	793.0000000000	Aruba	Nonmetropolitan Territory of The Netherlands	Beatrix	129	AW
AFG	Afghanistan	Asia	Southern and Central Asia	652090.0000000000	1919	22720000	45.9000000000	5976.0000000000	None	Afganistan/Afqanestan	Islamic Emirate	Mohammad Omar	1	AF
*/


CREATE TABLE countrylanguage (
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"Language" CHAR(30) DEFAULT '' NOT NULL, 
	"IsOfficial" TEXT DEFAULT 'F' NOT NULL, 
	"Percentage" FLOAT DEFAULT '0.0' NOT NULL, 
	PRIMARY KEY ("CountryCode", "Language"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)

/*
2 rows from countrylanguage table:
CountryCode	Language	IsOfficial	Percentage
ABW	Dutch	T	5.3000000000
ABW	English	F	9.5000000000
*/
What are the names of cities in Europe for which English is not the official language?
SELECT DISTINCT T2.Name FROM country AS T1 JOIN city AS T2 ON T2.CountryCode  =  T1.Code WHERE T1.Continent  =  'Europe' AND T1.Name NOT IN (SELECT T3.Name FROM country AS T3 JOIN countrylanguage AS T4 ON T3.Code  =  T4.CountryCode WHERE T4.IsOfficial  =  'T' AND T4.Language  =  'English')
[{'Name': 'Amsterdam'}, {'Name': 'Rotterdam'}, {'Name': 'Haag'}, {'Name': 'Utrecht'}, {'Name': 'Eindhoven'}, {'Name': 'Tilburg'}, {'Name': 'Groningen'}, {'Name': 'Breda'}, {'Name': 'Apeldoorn'}, {'Name': 'Nijmegen'}, {'Name': 'Enschede'}, {'Name': 'Haarlem'}, {'Name': 'Almere'}, {'Name': 'Arnhem'}, {'Name': 'Zaanstad'}, {'Name': '´s-Hertogenbosch'}, {'Name': 'Amersfoort'}, {'Name': 'Maastricht'}, {'Name': 'Dordrecht'}, {'Name': 'Leiden'}, {'Name': 'Haarlemmermeer'}, {'Name': 'Zoetermeer'}, {'Name': 'Emmen'}, {'Name': 'Zwolle'}, {'Name': 'Ede'}, {'Name': 'Delft'}, {'Name': 'Heerlen'}, {'Name': 'Alkmaar'}, {'Name': 'Tirana'}, {'Name': 'Andorra la Vella'}, {'Name': 'Antwerpen'}, {'Name': 'Gent'}, {'Name': 'Charleroi'}, {'Name': 'Liège'}, {'Name': 'Bruxelles [Brussel]'}, {'Name': 'Brugge'}, {'Name': 'Schaerbeek'}, {'Name': 'Namur'}, {'Name': 'Mons'}, {'Name': 'Sarajevo'}, {'Name': 'Banja Luka'}, {'Name': 'Zenica'}, {'Name': 'Sofija'}, {'Name': 'Plovdiv'}, {'Name': 'Varna'}, {'Name': 'Burgas'}, {'Name': 'Ruse'}, {'Name': 'Stara Zagora'}, {'Name': 'Pleven'}, {'Name': 'Sliven'}, {'Name': 'Dobric'}, {'Name': 'Šumen'}, {'Name': 'Madrid'}, {'Name': 'Barcelona'}, {'Name': 'Valencia'}, {'Name': 'Sevilla'}, {'Name': 'Zaragoza'}, {'Name': 'Málaga'}, {'Name': 'Bilbao'}, {'Name': 'Las Palmas de Gran Canaria'}, {'Name': 'Murcia'}, {'Name': 'Palma de Mallorca'}, {'Name': 'Valladolid'}, {'Name': 'Córdoba'}, {'Name': 'Vigo'}, {'Name': 'Alicante [Alacant]'}, {'Name': 'Gijón'}, {'Name': 'L´Hospitalet de Llobregat'}, {'Name': 'Granada'}, {'Name': 'A Coruña (La Coruña)'}, {'Name': 'Vitoria-Gasteiz'}, {'Name': 'Santa Cruz de Tenerife'}, {'Name': 'Badalona'}, {'Name': 'Oviedo'}, {'Name': 'Móstoles'}, {'Name': 'Elche [Elx]'}, {'Name': 'Sabadell'}, {'Name': 'Santander'}, {'Name': 'Jerez de la Frontera'}, {'Name': 'Pamplona [Iruña]'}, {'Name': 'Donostia-San Sebastián'}, {'Name': 'Cartagena'}, {'Name': 'Leganés'}, {'Name': 'Fuenlabrada'}, {'Name': 'Almería'}, {'Name': 'Terrassa'}, {'Name': 'Alcalá de Henares'}, {'Name': 'Burgos'}, {'Name': 'Salamanca'}, {'Name': 'Albacete'}, {'Name': 'Getafe'}, {'Name': 'Cádiz'}, {'Name': 'Alcorcón'}, {'Name': 'Huelva'}, {'Name': 'León'}, {'Name': 'Castellón de la Plana [Castell'}, {'Name': 'Badajoz'}, {'Name': '[San Cristóbal de] la Laguna'}, {'Name': 'Logroño'}, {'Name': 'Santa Coloma de Gramenet'}, {'Name': 'Tarragona'}, {'Name': 'Lleida (Lérida)'}, {'Name': 'Jaén'}, {'Name': 'Ourense (Orense)'}, {'Name': 'Mataró'}, {'Name': 'Algeciras'}, {'Name': 'Marbella'}, {'Name': 'Barakaldo'}, {'Name': 'Dos Hermanas'}, {'Name': 'Santiago de Compostela'}, {'Name': 'Torrejón de Ardoz'}, {'Name': 'Tórshavn'}, {'Name': 'Longyearbyen'}, {'Name': 'Reykjavík'}, {'Name': 'Roma'}, {'Name': 'Milano'}, {'Name': 'Napoli'}, {'Name': 'Torino'}, {'Name': 'Palermo'}, {'Name': 'Genova'}, {'Name': 'Bologna'}, {'Name': 'Firenze'}, {'Name': 'Catania'}, {'Name': 'Bari'}, {'Name': 'Venezia'}, {'Name': 'Messina'}, {'Name': 'Verona'}, {'Name': 'Trieste'}, {'Name': 'Padova'}, {'Name': 'Taranto'}, {'Name': 'Brescia'}, {'Name': 'Reggio di Calabria'}, {'Name': 'Modena'}, {'Name': 'Prato'}, {'Name': 'Parma'}, {'Name': 'Cagliari'}, {'Name': 'Livorno'}, {'Name': 'Perugia'}, {'Name': 'Foggia'}, {'Name': 'Reggio nell´ Emilia'}, {'Name': 'Salerno'}, {'Name': 'Ravenna'}, {'Name': 'Ferrara'}, {'Name': 'Rimini'}, {'Name': 'Syrakusa'}, {'Name': 'Sassari'}, {'Name': 'Monza'}, {'Name': 'Bergamo'}, {'Name': 'Pescara'}, {'Name': 'Latina'}, {'Name': 'Vicenza'}, {'Name': 'Terni'}, {'Name': 'Forlì'}, {'Name': 'Trento'}, {'Name': 'Novara'}, {'Name': 'Piacenza'}, {'Name': 'Ancona'}, {'Name': 'Lecce'}, {'Name': 'Bolzano'}, {'Name': 'Catanzaro'}, {'Name': 'La Spezia'}, {'Name': 'Udine'}, {'Name': 'Torre del Greco'}, {'Name': 'Andria'}, {'Name': 'Brindisi'}, {'Name': 'Giugliano in Campania'}, {'Name': 'Pisa'}, {'Name': 'Barletta'}, {'Name': 'Arezzo'}, {'Name': 'Alessandria'}, {'Name': 'Cesena'}, {'Name': 'Pesaro'}, {'Name': 'Wien'}, {'Name': 'Graz'}, {'Name': 'Linz'}, {'Name': 'Salzburg'}, {'Name': 'Innsbruck'}, {'Name': 'Klagenfurt'}, {'Name': 'Beograd'}, {'Name': 'Novi Sad'}, {'Name': 'Niš'}, {'Name': 'Priština'}, {'Name': 'Kragujevac'}, {'Name': 'Podgorica'}, {'Name': 'Subotica'}, {'Name': 'Prizren'}, {'Name': 'Athenai'}, {'Name': 'Thessaloniki'}, {'Name': 'Pireus'}, {'Name': 'Patras'}, {'Name': 'Peristerion'}, {'Name': 'Herakleion'}, {'Name': 'Kallithea'}, {'Name': 'Larisa'}, {'Name': 'Zagreb'}, {'Name': 'Split'}, {'Name': 'Rijeka'}, {'Name': 'Osijek'}, {'Name': 'Riga'}, {'Name': 'Daugavpils'}, {'Name': 'Liepaja'}, {'Name': 'Schaan'}, {'Name': 'Vaduz'}, {'Name': 'Vilnius'}, {'Name': 'Kaunas'}, {'Name': 'Klaipeda'}, {'Name': 'Šiauliai'}, {'Name': 'Panevezys'}, {'Name': 'Luxembourg [Luxemburg/Lëtzebuerg]'}, {'Name': 'Skopje'}, {'Name': 'Chisinau'}, {'Name': 'Tiraspol'}, {'Name': 'Balti'}, {'Name': 'Bender (Tîghina)'}, {'Name': 'Monte-Carlo'}, {'Name': 'Monaco-Ville'}, {'Name': 'Oslo'}, {'Name': 'Bergen'}, {'Name': 'Trondheim'}, {'Name': 'Stavanger'}, {'Name': 'Bærum'}, {'Name': 'Lisboa'}, {'Name': 'Porto'}, {'Name': 'Amadora'}, {'Name': 'Coímbra'}, {'Name': 'Braga'}, {'Name': 'Warszawa'}, {'Name': 'Lódz'}, {'Name': 'Kraków'}, {'Name': 'Wroclaw'}, {'Name': 'Poznan'}, {'Name': 'Gdansk'}, {'Name': 'Szczecin'}, {'Name': 'Bydgoszcz'}, {'Name': 'Lublin'}, {'Name': 'Katowice'}, {'Name': 'Bialystok'}, {'Name': 'Czestochowa'}, {'Name': 'Gdynia'}, {'Name': 'Sosnowiec'}, {'Name': 'Radom'}, {'Name': 'Kielce'}, {'Name': 'Gliwice'}, {'Name': 'Torun'}, {'Name': 'Bytom'}, {'Name': 'Zabrze'}, {'Name': 'Bielsko-Biala'}, {'Name': 'Olsztyn'}, {'Name': 'Rzeszów'}, {'Name': 'Ruda Slaska'}, {'Name': 'Rybnik'}, {'Name': 'Walbrzych'}, {'Name': 'Tychy'}, {'Name': 'Dabrowa Górnicza'}, {'Name': 'Plock'}, {'Name': 'Elblag'}, {'Name': 'Opole'}, {'Name': 'Gorzów Wielkopolski'}, {'Name': 'Wloclawek'}, {'Name': 'Chorzów'}, {'Name': 'Tarnów'}, {'Name': 'Zielona Góra'}, {'Name': 'Koszalin'}, {'Name': 'Legnica'}, {'Name': 'Kalisz'}, {'Name': 'Grudziadz'}, {'Name': 'Slupsk'}, {'Name': 'Jastrzebie-Zdrój'}, {'Name': 'Jaworzno'}, {'Name': 'Jelenia Góra'}, {'Name': 'Paris'}, {'Name': 'Marseille'}, {'Name': 'Lyon'}, {'Name': 'Toulouse'}, {'Name': 'Nice'}, {'Name': 'Nantes'}, {'Name': 'Strasbourg'}, {'Name': 'Montpellier'}, {'Name': 'Bordeaux'}, {'Name': 'Rennes'}, {'Name': 'Le Havre'}, {'Name': 'Reims'}, {'Name': 'Lille'}, {'Name': 'St-Étienne'}, {'Name': 'Toulon'}, {'Name': 'Grenoble'}, {'Name': 'Angers'}, {'Name': 'Dijon'}, {'Name': 'Brest'}, {'Name': 'Le Mans'}, {'Name': 'Clermont-Ferrand'}, {'Name': 'Amiens'}, {'Name': 'Aix-en-Provence'}, {'Name': 'Limoges'}, {'Name': 'Nîmes'}, {'Name': 'Tours'}, {'Name': 'Villeurbanne'}, {'Name': 'Metz'}, {'Name': 'Besançon'}, {'Name': 'Caen'}, {'Name': 'Orléans'}, {'Name': 'Mulhouse'}, {'Name': 'Rouen'}, {'Name': 'Boulogne-Billancourt'}, {'Name': 'Perpignan'}, {'Name': 'Nancy'}, {'Name': 'Roubaix'}, {'Name': 'Argenteuil'}, {'Name': 'Tourcoing'}, {'Name': 'Montreuil'}, {'Name': 'Bucuresti'}, {'Name': 'Iasi'}, {'Name': 'Constanta'}, {'Name': 'Cluj-Napoca'}, {'Name': 'Galati'}, {'Name': 'Timisoara'}, {'Name': 'Brasov'}, {'Name': 'Craiova'}, {'Name': 'Ploiesti'}, {'Name': 'Braila'}, {'Name': 'Oradea'}, {'Name': 'Bacau'}, {'Name': 'Pitesti'}, {'Name': 'Arad'}, {'Name': 'Sibiu'}, {'Name': 'Târgu Mures'}, {'Name': 'Baia Mare'}, {'Name': 'Buzau'}, {'Name': 'Satu Mare'}, {'Name': 'Botosani'}, {'Name': 'Piatra Neamt'}, {'Name': 'Râmnicu Vâlcea'}, {'Name': 'Suceava'}, {'Name': 'Drobeta-Turnu Severin'}, {'Name': 'Târgoviste'}, {'Name': 'Focsani'}, {'Name': 'Târgu Jiu'}, {'Name': 'Tulcea'}, {'Name': 'Resita'}, {'Name': 'Stockholm'}, {'Name': 'Gothenburg [Göteborg]'}, {'Name': 'Malmö'}, {'Name': 'Uppsala'}, {'Name': 'Linköping'}, {'Name': 'Västerås'}, {'Name': 'Örebro'}, {'Name': 'Norrköping'}, {'Name': 'Helsingborg'}, {'Name': 'Jönköping'}, {'Name': 'Umeå'}, {'Name': 'Lund'}, {'Name': 'Borås'}, {'Name': 'Sundsvall'}, {'Name': 'Gävle'}, {'Name': 'Berlin'}, {'Name': 'Hamburg'}, {'Name': 'Munich [München]'}, {'Name': 'Köln'}, {'Name': 'Frankfurt am Main'}, {'Name': 'Essen'}, {'Name': 'Dortmund'}, {'Name': 'Stuttgart'}, {'Name': 'Düsseldorf'}, {'Name': 'Bremen'}, {'Name': 'Duisburg'}, {'Name': 'Hannover'}, {'Name': 'Leipzig'}, {'Name': 'Nürnberg'}, {'Name': 'Dresden'}, {'Name': 'Bochum'}, {'Name': 'Wuppertal'}, {'Name': 'Bielefeld'}, {'Name': 'Mannheim'}, {'Name': 'Bonn'}, {'Name': 'Gelsenkirchen'}, {'Name': 'Karlsruhe'}, {'Name': 'Wiesbaden'}, {'Name': 'Münster'}, {'Name': 'Mönchengladbach'}, {'Name': 'Chemnitz'}, {'Name': 'Augsburg'}, {'Name': 'Halle/Saale'}, {'Name': 'Braunschweig'}, {'Name': 'Aachen'}, {'Name': 'Krefeld'}, {'Name': 'Magdeburg'}, {'Name': 'Kiel'}, {'Name': 'Oberhausen'}, {'Name': 'Lübeck'}, {'Name': 'Hagen'}, {'Name': 'Rostock'}, {'Name': 'Freiburg im Breisgau'}, {'Name': 'Erfurt'}, {'Name': 'Kassel'}, {'Name': 'Saarbrücken'}, {'Name': 'Mainz'}, {'Name': 'Hamm'}, {'Name': 'Herne'}, {'Name': 'Mülheim an der Ruhr'}, {'Name': 'Solingen'}, {'Name': 'Osnabrück'}, {'Name': 'Ludwigshafen am Rhein'}, {'Name': 'Leverkusen'}, {'Name': 'Oldenburg'}, {'Name': 'Neuss'}, {'Name': 'Heidelberg'}, {'Name': 'Darmstadt'}, {'Name': 'Paderborn'}, {'Name': 'Potsdam'}, {'Name': 'Würzburg'}, {'Name': 'Regensburg'}, {'Name': 'Recklinghausen'}, {'Name': 'Göttingen'}, {'Name': 'Bremerhaven'}, {'Name': 'Wolfsburg'}, {'Name': 'Bottrop'}, {'Name': 'Remscheid'}, {'Name': 'Heilbronn'}, {'Name': 'Pforzheim'}, {'Name': 'Offenbach am Main'}, {'Name': 'Ulm'}, {'Name': 'Ingolstadt'}, {'Name': 'Gera'}, {'Name': 'Salzgitter'}, {'Name': 'Cottbus'}, {'Name': 'Reutlingen'}, {'Name': 'Fürth'}, {'Name': 'Siegen'}, {'Name': 'Koblenz'}, {'Name': 'Moers'}, {'Name': 'Bergisch Gladbach'}, {'Name': 'Zwickau'}, {'Name': 'Hildesheim'}, {'Name': 'Witten'}, {'Name': 'Schwerin'}, {'Name': 'Erlangen'}, {'Name': 'Kaiserslautern'}, {'Name': 'Trier'}, {'Name': 'Jena'}, {'Name': 'Iserlohn'}, {'Name': 'Gütersloh'}, {'Name': 'Marl'}, {'Name': 'Lünen'}, {'Name': 'Düren'}, {'Name': 'Ratingen'}, {'Name': 'Velbert'}, {'Name': 'Esslingen am Neckar'}, {'Name': 'Serravalle'}, {'Name': 'San Marino'}, {'Name': 'Bratislava'}, {'Name': 'Košice'}, {'Name': 'Prešov'}, {'Name': 'Ljubljana'}, {'Name': 'Maribor'}, {'Name': 'Helsinki [Helsingfors]'}, {'Name': 'Espoo'}, {'Name': 'Tampere'}, {'Name': 'Vantaa'}, {'Name': 'Turku [Åbo]'}, {'Name': 'Oulu'}, {'Name': 'Lahti'}, {'Name': 'Zürich'}, {'Name': 'Geneve'}, {'Name': 'Basel'}, {'Name': 'Bern'}, {'Name': 'Lausanne'}, {'Name': 'København'}, {'Name': 'Århus'}, {'Name': 'Odense'}, {'Name': 'Aalborg'}, {'Name': 'Frederiksberg'}, {'Name': 'Praha'}, {'Name': 'Brno'}, {'Name': 'Ostrava'}, {'Name': 'Plzen'}, {'Name': 'Olomouc'}, {'Name': 'Liberec'}, {'Name': 'Ceské Budejovice'}, {'Name': 'Hradec Králové'}, {'Name': 'Ústí nad Labem'}, {'Name': 'Pardubice'}, {'Name': 'Kyiv'}, {'Name': 'Harkova [Harkiv]'}, {'Name': 'Dnipropetrovsk'}, {'Name': 'Donetsk'}, {'Name': 'Odesa'}, {'Name': 'Zaporizzja'}, {'Name': 'Lviv'}, {'Name': 'Kryvyi Rig'}, {'Name': 'Mykolajiv'}, {'Name': 'Mariupol'}, {'Name': 'Lugansk'}, {'Name': 'Vinnytsja'}, {'Name': 'Makijivka'}, {'Name': 'Herson'}, {'Name': 'Sevastopol'}, {'Name': 'Simferopol'}, {'Name': 'Pultava [Poltava]'}, {'Name': 'Tšernigiv'}, {'Name': 'Tšerkasy'}, {'Name': 'Gorlivka'}, {'Name': 'Zytomyr'}, {'Name': 'Sumy'}, {'Name': 'Dniprodzerzynsk'}, {'Name': 'Kirovograd'}, {'Name': 'Hmelnytskyi'}, {'Name': 'Tšernivtsi'}, {'Name': 'Rivne'}, {'Name': 'Krementšuk'}, {'Name': 'Ivano-Frankivsk'}, {'Name': 'Ternopil'}, {'Name': 'Lutsk'}, {'Name': 'Bila Tserkva'}, {'Name': 'Kramatorsk'}, {'Name': 'Melitopol'}, {'Name': 'Kertš'}, {'Name': 'Nikopol'}, {'Name': 'Berdjansk'}, {'Name': 'Pavlograd'}, {'Name': 'Sjeverodonetsk'}, {'Name': 'Slovjansk'}, {'Name': 'Uzgorod'}, {'Name': 'Altševsk'}, {'Name': 'Lysytšansk'}, {'Name': 'Jevpatorija'}, {'Name': 'Kamjanets-Podilskyi'}, {'Name': 'Jenakijeve'}, {'Name': 'Krasnyi Lutš'}, {'Name': 'Stahanov'}, {'Name': 'Oleksandrija'}, {'Name': 'Konotop'}, {'Name': 'Kostjantynivka'}, {'Name': 'Berdytšiv'}, {'Name': 'Izmajil'}, {'Name': 'Šostka'}, {'Name': 'Uman'}, {'Name': 'Brovary'}, {'Name': 'Mukatševe'}, {'Name': 'Budapest'}, {'Name': 'Debrecen'}, {'Name': 'Miskolc'}, {'Name': 'Szeged'}, {'Name': 'Pécs'}, {'Name': 'Györ'}, {'Name': 'Nyiregyháza'}, {'Name': 'Kecskemét'}, {'Name': 'Székesfehérvár'}, {'Name': 'Minsk'}, {'Name': 'Gomel'}, {'Name': 'Mogiljov'}, {'Name': 'Vitebsk'}, {'Name': 'Grodno'}, {'Name': 'Bobruisk'}, {'Name': 'Baranovitši'}, {'Name': 'Borisov'}, {'Name': 'Pinsk'}, {'Name': 'Orša'}, {'Name': 'Mozyr'}, {'Name': 'Novopolotsk'}, {'Name': 'Lida'}, {'Name': 'Soligorsk'}, {'Name': 'Molodetšno'}, {'Name': 'Città del Vaticano'}, {'Name': 'Moscow'}, {'Name': 'St Petersburg'}, {'Name': 'Novosibirsk'}, {'Name': 'Nizni Novgorod'}, {'Name': 'Jekaterinburg'}, {'Name': 'Samara'}, {'Name': 'Omsk'}, {'Name': 'Kazan'}, {'Name': 'Ufa'}, {'Name': 'Tšeljabinsk'}, {'Name': 'Rostov-na-Donu'}, {'Name': 'Perm'}, {'Name': 'Volgograd'}, {'Name': 'Voronez'}, {'Name': 'Krasnojarsk'}, {'Name': 'Saratov'}, {'Name': 'Toljatti'}, {'Name': 'Uljanovsk'}, {'Name': 'Izevsk'}, {'Name': 'Krasnodar'}, {'Name': 'Jaroslavl'}, {'Name': 'Habarovsk'}, {'Name': 'Vladivostok'}, {'Name': 'Irkutsk'}, {'Name': 'Barnaul'}, {'Name': 'Novokuznetsk'}, {'Name': 'Penza'}, {'Name': 'Rjazan'}, {'Name': 'Orenburg'}, {'Name': 'Lipetsk'}, {'Name': 'Nabereznyje Tšelny'}, {'Name': 'Tula'}, {'Name': 'Tjumen'}, {'Name': 'Kemerovo'}, {'Name': 'Astrahan'}, {'Name': 'Tomsk'}, {'Name': 'Kirov'}, {'Name': 'Ivanovo'}, {'Name': 'Tšeboksary'}, {'Name': 'Brjansk'}, {'Name': 'Tver'}, {'Name': 'Kursk'}, {'Name': 'Magnitogorsk'}, {'Name': 'Kaliningrad'}, {'Name': 'Nizni Tagil'}, {'Name': 'Murmansk'}, {'Name': 'Ulan-Ude'}, {'Name': 'Kurgan'}, {'Name': 'Arkangeli'}, {'Name': 'Sotši'}, {'Name': 'Smolensk'}, {'Name': 'Orjol'}, {'Name': 'Stavropol'}, {'Name': 'Belgorod'}, {'Name': 'Kaluga'}, {'Name': 'Vladimir'}, {'Name': 'Mahatškala'}, {'Name': 'Tšerepovets'}, {'Name': 'Saransk'}, {'Name': 'Tambov'}, {'Name': 'Vladikavkaz'}, {'Name': 'Tšita'}, {'Name': 'Vologda'}, {'Name': 'Veliki Novgorod'}, {'Name': 'Komsomolsk-na-Amure'}, {'Name': 'Kostroma'}, {'Name': 'Volzski'}, {'Name': 'Taganrog'}, {'Name': 'Petroskoi'}, {'Name': 'Bratsk'}, {'Name': 'Dzerzinsk'}, {'Name': 'Surgut'}, {'Name': 'Orsk'}, {'Name': 'Sterlitamak'}, {'Name': 'Angarsk'}, {'Name': 'Joškar-Ola'}, {'Name': 'Rybinsk'}, {'Name': 'Prokopjevsk'}, {'Name': 'Niznevartovsk'}, {'Name': 'Naltšik'}, {'Name': 'Syktyvkar'}, {'Name': 'Severodvinsk'}, {'Name': 'Bijsk'}, {'Name': 'Niznekamsk'}, {'Name': 'Blagoveštšensk'}, {'Name': 'Šahty'}, {'Name': 'Staryi Oskol'}, {'Name': 'Zelenograd'}, {'Name': 'Balakovo'}, {'Name': 'Novorossijsk'}, {'Name': 'Pihkova'}, {'Name': 'Zlatoust'}, {'Name': 'Jakutsk'}, {'Name': 'Podolsk'}, {'Name': 'Petropavlovsk-Kamtšatski'}, {'Name': 'Kamensk-Uralski'}, {'Name': 'Engels'}, {'Name': 'Syzran'}, {'Name': 'Grozny'}, {'Name': 'Novotšerkassk'}, {'Name': 'Berezniki'}, {'Name': 'Juzno-Sahalinsk'}, {'Name': 'Volgodonsk'}, {'Name': 'Abakan'}, {'Name': 'Maikop'}, {'Name': 'Miass'}, {'Name': 'Armavir'}, {'Name': 'Ljubertsy'}, {'Name': 'Rubtsovsk'}, {'Name': 'Kovrov'}, {'Name': 'Nahodka'}, {'Name': 'Ussurijsk'}, {'Name': 'Salavat'}, {'Name': 'Mytištši'}, {'Name': 'Kolomna'}, {'Name': 'Elektrostal'}, {'Name': 'Murom'}, {'Name': 'Kolpino'}, {'Name': 'Norilsk'}, {'Name': 'Almetjevsk'}, {'Name': 'Novomoskovsk'}, {'Name': 'Dimitrovgrad'}, {'Name': 'Pervouralsk'}, {'Name': 'Himki'}, {'Name': 'Balašiha'}, {'Name': 'Nevinnomyssk'}, {'Name': 'Pjatigorsk'}, {'Name': 'Korolev'}, {'Name': 'Serpuhov'}, {'Name': 'Odintsovo'}, {'Name': 'Orehovo-Zujevo'}, {'Name': 'Kamyšin'}, {'Name': 'Novotšeboksarsk'}, {'Name': 'Tšerkessk'}, {'Name': 'Atšinsk'}, {'Name': 'Magadan'}, {'Name': 'Mitšurinsk'}, {'Name': 'Kislovodsk'}, {'Name': 'Jelets'}, {'Name': 'Seversk'}, {'Name': 'Noginsk'}, {'Name': 'Velikije Luki'}, {'Name': 'Novokuibyševsk'}, {'Name': 'Neftekamsk'}, {'Name': 'Leninsk-Kuznetski'}, {'Name': 'Oktjabrski'}, {'Name': 'Sergijev Posad'}, {'Name': 'Arzamas'}, {'Name': 'Kiseljovsk'}, {'Name': 'Novotroitsk'}, {'Name': 'Obninsk'}, {'Name': 'Kansk'}, {'Name': 'Glazov'}, {'Name': 'Solikamsk'}, {'Name': 'Sarapul'}, {'Name': 'Ust-Ilimsk'}, {'Name': 'Štšolkovo'}, {'Name': 'Mezduretšensk'}, {'Name': 'Usolje-Sibirskoje'}, {'Name': 'Elista'}, {'Name': 'Novošahtinsk'}, {'Name': 'Votkinsk'}, {'Name': 'Kyzyl'}, {'Name': 'Serov'}, {'Name': 'Zelenodolsk'}, {'Name': 'Zeleznodoroznyi'}, {'Name': 'Kinešma'}, {'Name': 'Kuznetsk'}, {'Name': 'Uhta'}, {'Name': 'Jessentuki'}, {'Name': 'Tobolsk'}, {'Name': 'Neftejugansk'}, {'Name': 'Bataisk'}, {'Name': 'Nojabrsk'}, {'Name': 'Balašov'}, {'Name': 'Zeleznogorsk'}, {'Name': 'Zukovski'}, {'Name': 'Anzero-Sudzensk'}, {'Name': 'Bugulma'}, {'Name': 'Novouralsk'}, {'Name': 'Puškin'}, {'Name': 'Vorkuta'}, {'Name': 'Derbent'}, {'Name': 'Kirovo-Tšepetsk'}, {'Name': 'Krasnogorsk'}, {'Name': 'Klin'}, {'Name': 'Tšaikovski'}, {'Name': 'Novyi Urengoi'}, {'Name': 'Tallinn'}, {'Name': 'Tartu'}]