query-7b097dccf7330c6438751169a97f25f4

rq turtle/ttl

Result elections table, which shows the historical results evolution of political parties in one city/municipality. Don't mind about the nice (or not) format. The problems I have are: User:Amadalvarez/election tableHi. I need to build a result table like intersection.party x year qualifier of each P991. It must be shown in its (P1114)quantity The values for table cells comes from the (the winner political parties in any election defined by the "select".(P991)successful candidate the values to show as a header are the collection of different values of all entries of To get all values I do:

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/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?year ?party ?partyLabel ?seats WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?item wdt:P31 wd:Q152450;
    wdt:P1001 wd:Q1233527;
    p:P991 _:b56.
  _:b56 ps:P991 ?party;
    pq:P1114 ?seats.
  ?item wdt:P585 ?data. Bind(year(?data) as ?year)
  Filter (?seats > 0)
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/09