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

Which current national Heads of State have been in office for the longest time?

Manually update list

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:P1906 ?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	57
	Carl XVI Gustaf of Sweden	Sweden	51
	Teodoro Obiang	Equatorial Guinea	45
	Paul Biya	Cameroon	41
	Yoweri Museveni	Uganda	38
	Mswati III	Eswatini	38
	Ali Khamenei	Iran	35
	Hans-Adam II, Prince of Liechtenstein	Liechtenstein	34
	Harald V of Norway	Norway	33
	Isaias Afwerki	Eritrea	31
	Alexander Lukashenko	Belarus	30
	Emomali Rahmon	Tajikistan	29
	Letsie III of Lesotho	Lesotho	28
	Denis Sassou-Nguesso	Republic of the Congo	26
	Abdullah II of Jordan	Jordan	25
	Hamad II of Bahrain	Bahrain	25
	Ismail Omar Guelleh	Djibouti	25
	Mohammed	Morocco	25
	Paul Kagame	Rwanda	24
	Bashar al-Assad	Syria	24
	Henri, Grand Duke of Luxembourg	Luxembourg	24
	Joan Enric Vives Sicília	Andorra	21
	Ilham Aliyev	Azerbaijan	20
	Norodom Sihamoni	Cambodia	20
	Albert II, Prince of Monaco	Monaco	19
	Faure Essozimna Gnassingbé	Togo	19
	Jigme Khesar Namgyel Wangchuck	Bhutan	17
	Daniel Ortega	Nicaragua	17
	Mahmoud Abbas	State of Palestine	16
	Patrick Allen	Jamaica	15

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:P1906 ?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!