query-3e045913d6299968555a305b42766931

rq turtle/ttl

Town that have changed of name in the past ]reply[20:56, 7 June 2020 (UTC)) talk (Bouzinac (P1448)official name with its (Q190118)La Roche-sur-Yon Hello, I'd like to list towns/cities that have changed at least 3 times in the past, with their dates ? See for instance : This query will list cities etc. with more than 3 officiel names. It doesn't distinguish between names at different times and names in different languages at the same time.Bouzinac@

Use at

• https://query.wikidata.org/sparql

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/>
SELECT ?item ?name ?language_tag ?rank ?start ?end
WHERE
{

{
  # Select items with more than 3 official names, i.e. it has changed at least 3 times.
  SELECT ?item
  WHERE
  {
    ?item p:P1448 []. # Officiel name
  }
  GROUP BY ?item
  HAVING (COUNT(?item) > 3)
}  ?item wdt:P31 / wdt:P279 wd:Q486972. # ?item is a settelement
  ?item p:P1448 ?name_statement.
  ?name_statement wikibase:rank ?rank.
  ?name_statement ps:P1448 ?name.
  BIND (LANG(?name) AS ?language_tag).
  OPTIONAL { ?name_statement pq:P580 ?start. }
  OPTIONAL { ?name_statement pq:P582 ?end. }
}
ORDER By ?item ?start

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/06