Skip to content

Instantly share code, notes, and snippets.

@paulsonnentag

paulsonnentag/query

Created December 28, 2016 15:17
Show Gist options
  • Save paulsonnentag/b34a6c8b50a481e057fd2a7faee352fc to your computer and use it in GitHub Desktop.
Save paulsonnentag/b34a6c8b50a481e057fd2a7faee352fc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query
SElECT ?federalStateLabel ?countryLabel ?postalCode WHERE {
bind (wd:Q1022 as ?city)
?city wdt:P131* ?federalState .
?federalState wdt:P31/wdt:P279* wd:Q107390 .
?federalState wdt:P131* ?country .
?country wdt:P31 wd:Q6256 .
?city wdt:P281 ?postalCode .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment