Wikidata:WikiProject Heads of state and government/Longest Heads of Government

From Wikidata
Jump to navigation Jump to search

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
image Person Country Years
Josef Martin Knüsel Switzerland 163
158
Hassanal Bolkiah I of Brunei Brunei Darussalam 57
Isaias Afwerki Eritrea 31
Ralph Gonsalves Saint Vincent and the Grenadines 23
Roosevelt Skerrit Dominica 20
Lee Hsien Loong Singapore 20
Mohammed bin Rashid Al Maktoum United Arab Emirates 18
Daniel Ortega Nicaragua 17
Sheikh Hasina Bangladesh 15
Viktor Orbán Hungary 14
Mark Rutte Kingdom of the Netherlands 14
Salva Kiir Mayardit South Sudan 13
Nicolás Maduro Venezuela 11
Abdoulkader Kamil Mohamed Djibouti 11
Edi Rama Albania 11
Kokhir Rasulzoda Tajikistan 10
Narendra Modi India 10
Gaston Browne Antigua and Barbuda 10
Recep Tayyip Erdoğan Turkey 10
Joko Widodo Indonesia 10
Saara Kuugongelwa Namibia 9
Keith Rowley Trinidad and Tobago 9
Justin Trudeau Canada 9
Andrew Holness Jamaica 8
Taneti Maamau Kiribati 8
Patrice Talon Benin 8
Ulisses Correia e Silva Cape Verde 8
Abdel-Aziz bin Habtour Yemen 8
Andrej Plenković Croatia 8
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
Try it!