European Capitals (Virtuoso)

48 European countries and capitals pulled from the Virtuoso-backed Wikidata mirror.

Country	Capital	Capital Population
Albania	Tirana	418,495
Andorra	Andorra la Vella	24,042
Austria	Vienna	1,973,403
Belarus	Minsk	1,996,730
Belgium	City of Brussels	195,546
Bosnia and Herzegovina	Sarajevo	275,524
Bulgaria	Sofia	1,205,548
Croatia	Zagreb	767,131
Cyprus	Nicosia	56,848
Czech Republic	Prague	1,397,880
Denmark	Copenhagen	667,099
Estonia	Tallinn	457,572
Finland	Helsinki	686,595
France	Paris	2,113,705
Georgia	Tbilisi	1,118,035
Germany	Berlin	3,782,202
Greece	Athens	643,452
Hungary	Budapest	1,685,209
Iceland	Reykjavík	139,875
Ireland	Dublin	592,713
Italy	Rome	2,748,109
Kingdom of Denmark	Copenhagen	667,099
Kingdom of the Netherlands	Amsterdam	921,468
Kosovo	Prishtina	198,897
Latvia	Riga	595,053
Liechtenstein	Vaduz	5,668
Lithuania	Vilnius	581,475
Luxembourg	Luxembourg	136,208
Malta	Valletta	6,444
Moldova	Chișinău	567,038
Monaco	Commune of Monaco	39,050
Montenegro	Podgorica	150,977
Netherlands	Amsterdam	921,468
North Macedonia	Skopje	422,540
Norway	Oslo	709,037
Poland	Warsaw	1,862,402
Portugal	Lisbon	545,796
Romania	Bucharest	1,716,961
Russia	Moscow	13,274,285
San Marino	San Marino	4,040
Serbia	Belgrade	1,197,714
Slovakia	Bratislava	479,389
Slovenia	Ljubljana	284,293
Spain	Madrid	3,416,771
Sweden	Stockholm	984,748
Switzerland	Bern	136,988
Ukraine	Kyiv	2,952,301
United Kingdom	London	8,799,728

Run this query on the Virtuoso mirror SPARQL query

PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?country ?countryLabel ?capital ?capitalLabel ?population
WHERE {
  ?country wdt:P30 wd:Q46 ;
           wdt:P31 wd:Q6256 ;
           wdt:P36 ?capital ;
           rdfs:label ?countryLabel .
  ?capital rdfs:label ?capitalLabel .
  FILTER(LANG(?countryLabel) = "en")
  FILTER(LANG(?capitalLabel) = "en")
  OPTIONAL { ?capital wdt:P1082 ?population }
}
ORDER BY ?countryLabel