query-d7f4d61a5439dbb2411489bfac5ca2cb

rq turtle/ttl

| Query: Recent changes | Find images | TABernacle | PetScan | WDQS . Manual changes to the list will be removed on the next update! a botThis list is periodically updated by Manually update list Kausea Natano Feleti Teo Prime Minister of Tuvalu Feleti Teo Tuvalu David Adeang David Adeang President of Nauru Russ J Kun Nauru Didier Guillaume Pierre Dartout Minister of State of Monaco Didier Guillaume Monaco David Kabua Hilda C. HeineDavid Kabua President of the Marshall Islands Hilda C. Heine Marshall Islands Hu'akavameiliku Hu'akavameiliku Prime Minister of Tonga Pohiva Tuʻiʻonetoa Tonga Dickon Mitchell Dickon Mitchell Prime Minister of Grenada Keith Mitchell Grenada Philip Pierre Philip Pierre Prime Minister of Saint Lucia Allen Chastanet Saint Lucia Fiamē Naomi Mataʻafa Fiamē Naomi Mataʻafa Prime Minister of Samoa Tuila'epa Sa'ilele Malielegaoi Samoa Charlot Salwai Prime Minister of Vanuatu Bob Loughman Vanuatu Philip "Brave" Davis Philip "Brave" Davis Prime Minister of the Bahamas Hubert Minnis The Bahamas Luc Frieden Luc Frieden Prime Minister of Luxembourg Xavier Bettel Luxembourg Tshering Tobgay Prime Minister of Bhutan Lotay Tshering Bhutan Manuela RokaManuel Osa Nsue Nsua Manuel Osa Nsue Nsua Prime Minister of Equatorial Guinea Manuela Roka Equatorial Guinea Kristen Michal Kristen Michal Prime Minister of Estonia Kaja Kallas Estonia Rui Duarte de Barros Rui Duarte de Barros Prime Minister of Guinea-Bissau Nuno Nabiam Guinea-Bissau Irakli Garibashvili Irakli Kobakhidze Prime Minister of Georgia Irakli Kobakhidze Georgia Laurentino Cortizo José Raúl Mulino President of Panama José Raúl Mulino Panama Ahmad Al Abdullah Al Sabah Ahmad Al Abdullah Al Sabah Prime Minister of Kuwait Sabah Al-Khalid Al-Sabah Kuwait Mohamed Ould Bilal Moctar Ould Diay Prime Minister of Mauritania Mohamed Ould Bilal Mauritania Simon Harris Simon Harris Taoiseach Leo Varadkar Ireland Joseph Boakai George Weah President of Liberia George Weah Liberia Mohammad Mustafa Mohammad Shtayyeh Prime Minister of the State of Palestine Mohammad Shtayyeh State of Palestine Anatole Collinet Makosso Anatole Collinet Makosso Prime Minister of the Republic of the Congo Clément Mouamba Republic of the Congo Fathi Bashagha Abdulhamid Dbeibeh Prime Minister of Libya Abdulhamid Dbeibeh Libya Sonexay Siphandone Phankham Viphavan Prime Minister of Laos Phankham Viphavan Laos Dimitar Glavchev Dimitar Glavchev Prime Minister of Bulgaria Nikolay Denkov Bulgaria Miloš Vučević Ana Brnabić Prime Minister of Serbia Miloš Vučević Serbia Viola Amherd Viola Amherd President of the Swiss Confederation Swiss Federal Council Switzerland Luís Montenegro Luís Montenegro Prime Minister of Portugal António Costa Portugal Jafar A Hassan Bisher Al-Khasawneh Prime Minister of Jordan Bisher Al-Khasawneh Jordan Garry Conille Prime Minister of Haiti Claude Joseph Haiti Hamza Abdi Barre Hamza Abdi Barre Prime Minister of Somalia Mohamed Hussein Roble Somalia Kamel Madouri Elyes FakhfakhYoussef ChahedHichem MechichiNajla Bouden Prime Minister of Tunisia Ahmed Hachani Tunisia Mahamat Déby Itno President of Chad Idriss Déby Chad Bassirou Diomaye Diakhar Faye Macky Sall President of Senegal Bassirou Diomaye Diakhar Faye Senegal Hakainde Hichilema Hakainde Hichilema President of Zambia Edgar Lungu Zambia Dick Schoof Dick Schoof Prime Minister of the Netherlands Mark Rutte Kingdom of the Netherlands Oljas Bektenov Oljas Bektenov Prime Minister of Kazakhstan Älihan Smaiylov Kazakhstan Anura Kumara Dissanayake Ranil Wickremesinghe President of Sri Lanka Harini Amarasuriya Sri Lanka Mohammad Ghazi al-Jalali Mohammad Ghazi al-Jalali Prime Minister of Syria Hussein Arnous Syria Chen Chien-jen Cho Jung-tai Premier of the Republic of China Cho Jung-tai Taiwan Kim Tok-hun Kim Tok-hun Premier of North Korea Kim Jae-ryong North Korea Abdel-Aziz bin HabtourAhmad Awad Bin MubarakMaeen Abdulmalik Saeed Ahmad Awad Bin Mubarak Prime Minister of Yemen Maeen Abdulmalik Saeed Yemen Khadga Prasad Sharma Oli Khadga Prasad Sharma Oli Prime Minister of Nepal Pushpa Kamal Dahal Nepal Mohammed bin Salman Mohammed bin Salman Prime Minister of Saudi Arabia Salman bin Abdulaziz Al Saud Saudi Arabia Osman Hussein Osman Bakri Hassan Saleh Prime Minister of Sudan Abdalla Hamdok Sudan Aung Lin DweMoe AungTin Aung SanMya Tun OoZaw Min Tun Aung San Suu Kyi State Administration CouncilState Counsellor of Myanmar Min Aung Hlaing Myanmar Samia Hassan Suluhu John Magufuli President of Tanzania Samia Hassan Suluhu Tanzania Judith Tuluka Suminwa Judith Tuluka Suminwa Prime Minister of the Democratic Republic of the Congo Ilunga Ilunkamba Sylvestre Democratic Republic of the Congo Claudia Sheinbaum Claudia Sheinbaum President of Mexico Andrés Manuel López Obrador Mexico On Person On Office Office On Country Country End of automatically generated list.--- The underlying query behind this report is:

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?country ?countryLabel ?head ?headLabel ?office ?officeLabel ?officeholder ?officeholderLabel ?person ?personLabel   
WHERE {      
  ?country wdt:P31 wd:Q3624078 ; # find all countries
           wdt:P1313 ?office . # and the office held by head of government
  FILTER NOT EXISTS { ?office wdt:P576 ?end_date } . # (non-dissolved)
  FILTER (?country != wd:Q238) # ignoring San-Marino's co-heads

  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
          FILTER (?start_date < NOW()) .   #   but not in the future

    OPTIONAL { ?posn pq:P582 ?end_date }  
    FILTER ( !bound(?end_date) || isBLANK(?end_date) ) . # but with no end date
  }

  OPTIONAL { ?country wdt:P6 ?head }  # and compare with the Head of Government on the country
  OPTIONAL { ?office wdt:P1308 ?officeholder } # and the holder of the HoG office
  OPTIONAL { ?country wdt:P1082 ?population }

  FILTER ((?officeholder != ?head) || (?head != ?person) )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
ORDER BY DESC(?population)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?country"):::projected v7("?end_date") v3("?head"):::projected v6("?office"):::projected v2("?officeholder"):::projected v4("?person"):::projected v1("?population") v9("?posn") v8("?start_date") c17(["en"]):::literal c4(["wd:Q3624078"]):::iri c15(["bd:serviceParam"]):::iri c7(["wd:Q5"]):::iri f0[["(?officeholder != ?head || ?head != ?person)"]] f0 --> v2 f0 --> v3 f0 --> v4 f1[["?country != 'wd:Q238'"]] f1 --> v5 f2[["not "]] subgraph f2e0["Exists Clause"] e0v1 --"p:direct/P576"--> e0v2 e0v2("?end_date"):::projected e0v1("?office"):::projected end f2--EXISTS--> f2e0 f2 --> v6 f2 --> c2 f2 --> v7 v6 --"p:direct/P576"--> v7 v5 --"p:direct/P31"--> c4 v5 --"p:direct/P1313"--> v6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:P39".-> v9 v4 --"p:direct/P31"--> c7 v9 --"p:statement/P39"--> v6 v9 --"p:qualifier/P580"--> v8 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v9 -."p:qualifier/P582".-> v7 end end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P6".-> v3 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P1308".-> v2 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P1082".-> v1 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end