Wikidata:WikiProject Heads of state and government/Longest Heads of Government
Jump to navigation
Jump to search
Try it!
Which current national Heads of Government have been in office for the longest time?
(Compare also those in office for the shortest time.)
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 ?country ?years WHERE { ?country wdt:P31 wd:Q3624078 ; wdt:P1313 ?office . ?item wdt:P31 wd:Q5 ; p:P39 ?posn . ?posn ps:P39 ?office ; pq:P580 ?start_date . FILTER NOT EXISTS { ?posn pq:P582 ?end_date } BIND(ROUND((NOW() - ?start_date)/365.2425) AS ?years) } ORDER BY ?start_date LIMIT 30
End of automatically generated list.
The underlying query that generates this report is:
SELECT DISTINCT ?item ?itemLabel ?country ?countryLabel ?years
WHERE {
?country wdt:P31 wd:Q3624078 ; wdt:P1313 ?office .
?item wdt:P31 wd:Q5 ; p:P39 ?posn .
?posn ps:P39 ?office ; pq:P580 ?start_date .
FILTER NOT EXISTS { ?posn pq:P582 ?end_date }
BIND(ROUND((NOW() - ?start_date)/365.2425) AS ?years)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?start_date
LIMIT 30