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
Hassanal Bolkiah I of Brunei Brunei Darussalam 57
Isaías Fortis Eritrea 31
Ralph Gonsalves Saint Vincent and the Grenadines 23
Roosevelt Skerrit Dominica 21
Mohammed bin Rashid Al Maktoum United Arab Emirates 19
Daniel Ortega Nicaragua 18
Viktor Orbán Hungary 14
Salva Kiir Mayardit South Sudan 13
Nicolás Maduro Venezuela 12
Abdoulkader Kamil Mohamed Djibouti 11
Edi Rama Albania 11
Kokhir Rasulzoda Tajikistan 11
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 9
Taneti Maamau Kiribati 9
Patrice Talon Benin 8
Ulisses Correia e Silva Cape Verde 8
Abdel-Aziz bin Habtour Yemen 8
Andrej Plenković Croatia 8
Abdulla Nigmatovich Aripov Uzbekistan 8
Adama Barrow The Gambia 8
Pravind Jugnauth Mauritius 8
Édouard Ngirente Rwanda 7
João Lourenço Angola 7
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!