Wikidata:WikiProject Heads of state and government/Newest Heads of Government
Jump to navigation
Jump to search
Try it!
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 ?weeks 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)/7) AS ?weeks) } ORDER BY DESC(?start_date) LIMIT 30
End of automatically generated list.
The underlying query that generates this report is:
SELECT DISTINCT ?item ?itemLabel ?country ?countryLabel ?weeks
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)/7) AS ?weeks)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?start_date)
LIMIT 30