Wikidata:WikiProject Heads of state and government/Report:P1313/P1365
Preceding head of government report This is a list of every country in Wikidata, with the office held by its Head of Government, its current holder, and the person listed as being the previous holder.
A missing ?replaces field can be filled by adding a replaces (P1365) qualifier to the relevant position held (P39) entry on the current officeholder (in the ?person column).
This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!
WDQS | PetScan | TABernacle | Find images | Recent changes | Query:SELECT DISTINCT ?item ?office ?person ?replaces WHERE { ?item wdt:P31 wd:Q3624078 ; wdt:P1313 ?office . FILTER NOT EXISTS { ?office wdt:P576 ?end_date } . OPTIONAL { ?person p:P39 ?posn ; wdt:P31 wd:Q5 . ?posn ps:P39 ?office ; pq:P580 ?start_date . OPTIONAL { ?posn pq:P582 ?end_date } FILTER ( !bound(?end_date)
End of automatically generated list.
The underlying query for this report is:
SELECT DISTINCT ?country ?countryLabel ?office ?officeLabel ?person ?personLabel ?replaces ?replacesLabel
WHERE {
?country wdt:P31 wd:Q3624078 ; # find all countries
wdt:P1313 ?office . # and their "office held by head of government"
FILTER NOT EXISTS { ?office wdt:P576 ?end_date } . # (non-dissolved)
OPTIONAL {
?person p:P39 ?posn ; wdt:P31 wd:Q5 . # find all humans with a position
?posn ps:P39 ?office ; # of that office
pq:P580 ?start_date . # where the position statement has a start date
OPTIONAL { ?posn pq:P582 ?end_date }
FILTER ( !bound(?end_date)|| isBLANK(?end_date) ) . # but no end date
OPTIONAL { ?posn pq:P1365 ?replaces } # and see who they replaced
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
ORDER BY ?countryLabel ?officeLabel