Skip to content

Instantly share code, notes, and snippets.

@urfolomeus
Last active March 9, 2022 20:36
Show Gist options
  • Save urfolomeus/b04140d48aaafab093e2efac3fa79131 to your computer and use it in GitHub Desktop.
Save urfolomeus/b04140d48aaafab093e2efac3fa79131 to your computer and use it in GitHub Desktop.
SELECT DISTINCT ?item ?itemLabel ?height
WHERE
{
VALUES ?o {
wd:Q48352
wd:Q2285706
}
?item wdt:P21 wd:Q6581097;
wdt:P39 ?postition.
?postition wdt:P279 ?o.
?item wdt:P2048 ?height.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC (?height)
query = """
SELECT DISTINCT ?item ?itemLabel ?height
WHERE
{
VALUES ?o {
wd:Q48352
wd:Q2285706
}
?item wdt:P21 wd:Q6581097;
wdt:P39 ?postition.
?postition wdt:P279 ?o.
?item wdt:P2048 ?height.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC (?height)
"""
result = mkwikidata.run_query(query)
leaders = result['results']['bindings']
c = {}
leader_names = ["Robert Mugabe", "Vladimir Lenin", "Adolf Hitler", "Vladimir Putin", "Joseph Stalin"]
for leader in leaders:
name = leader['itemLabel']['value']
height = leader['height']['value']
if name in leader_names:
c[name] = float(height)
c
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment