query-7c3ecfef88d1e148711b6d9acd781eea

rq turtle/ttl

: The query by Jura is a good starting point, but it counts parliament member multiple times if they have multiple position statement for a certain year. For instance all reelected members are counted twice in the election years. That can be difficult to see because the graph is shown as percentages. To fix that I made another subquery (called %memberyears) with the DISTINCT keyword in the SELECT clause. If you remove that DISTINCT you will see a big change especially in election years. My query has a line chart as default view and uses the absolute numbers instead of percentages: Popperipopp, Jura1@

Use at

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

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/>
#defaultView:AreaChart
SELECT
  ?month 
  # (COUNT(DISTINCT ?m) as ?count_m)
  # (COUNT(DISTINCT ?f) as ?count_f)  (COUNT(DISTINCT ?item) as ?count_all)
  ( ROUND( COUNT(DISTINCT ?f) / COUNT(DISTINCT ?item) * 100) as ?pc_f) 
WHERE
{

{
   SELECT DISTINCT ?month { [] wdt:P31 wd:Q47018478 ; wdt:P585 ?month . 
                           FILTER( YEAR(?month) > 1980 && YEAR(?month) < 2000 )  }
}  
  ?pos ps:P39 wd:Q10655178 ; pq:P580 ?start .
  OPTIONAL { ?pos pq:P582 ?end0 }
  BIND( COALESCE( ?end0, NOW() ) as ?end) 
  FILTER( ?month >= ?start && ?month <= ?end ) 
  ?item p:P39 ?pos .
  OPTIONAL { ?item wdt:P21 wd:Q6581072 . BIND(?item as ?f) }
  # OPTIONAL { ?item wdt:P21 wd:Q6581097 . BIND(?item as ?m) }  
}
GROUP BY ?month 
ORDER BY ?month

Query found at

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