query-1523651a90a3a3da480dc0fc29ed8bb5

rq turtle/ttl

title: Current majors of municipalities of Iceland (should be 64) SELECT ?municipality ?municipalityLabel ?currentMayor ?currentMayorLabel ?startDate WHERE { # Find all municipalities in Iceland ?municipality wdt:P31 wd:Q955655 . ?municipality wdt:P17 wd:Q189 .

# Exclude municipalities with dissolved date (P576) and qualifiers (P1366) MINUS { ?municipality wdt:P576 [] } MINUS { ?municipality wdt:P1366 [] }

# Get the head of government (mayor) statement and its value ?municipality p:P6 ?statement . ?statement ps:P6 ?currentMayor .

# Get the start date (P580) of the mayor's term ?statement pq:P580 ?startDate .

# Get the label of the current mayor ?currentMayor rdfs:label ?currentMayorLabel . FILTER(LANG(?currentMayorLabel) = "en")

# Get the label of the municipality ?municipality rdfs:label ?municipalityLabel . FILTER(LANG(?municipalityLabel) = "en")

# Filter out mayors that do not have the most recent start time FILTER NOT EXISTS { ?municipality p:P6 ?otherStatement . ?otherStatement ps:P6 ?otherMayor . ?otherStatement pq:P580 ?otherStartDate . FILTER (?otherStartDate > ?startDate) } }

Use at

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

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#title: Current majors of municipalities of Iceland (should be 64)
SELECT ?municipality ?municipalityLabel ?currentMayor ?currentMayorLabel ?startDate WHERE {
  # Find all municipalities in Iceland
  ?municipality wdt:P31 wd:Q955655 .
  ?municipality wdt:P17 wd:Q189 .

  # Exclude municipalities with dissolved date (P576) and qualifiers (P1366)
  MINUS { ?municipality wdt:P576 [] }
  MINUS { ?municipality wdt:P1366 [] }

  # Get the head of government (mayor) statement and its value
  ?municipality p:P6 ?statement .
  ?statement ps:P6 ?currentMayor .

  # Get the start date (P580) of the mayor's term
  ?statement pq:P580 ?startDate .

  # Get the label of the current mayor
  ?currentMayor rdfs:label ?currentMayorLabel .
  FILTER(LANG(?currentMayorLabel) = "en")

  # Get the label of the municipality
  ?municipality rdfs:label ?municipalityLabel .
  FILTER(LANG(?municipalityLabel) = "en")

  # Filter out mayors that do not have the most recent start time
  FILTER NOT EXISTS {
    ?municipality p:P6 ?otherStatement .
    ?otherStatement ps:P6 ?otherMayor .
    ?otherStatement pq:P580 ?otherStartDate .
    FILTER (?otherStartDate > ?startDate)
  }
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Government/Queries