query-a5b779412a3cfea1b367cbd7bf79836a

rq turtle/ttl

Bar chart grouped by decade

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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#>
#defaultView:BarChart
SELECT (STR(?decade) AS ?decade) (COUNT(DISTINCT ?taxon) AS ?number_of_new_taxa)
WHERE 
{
  {?taxon wdt:P31 wd:Q16521 } UNION {?taxon wdt:P31 wd:Q310890} UNION {?taxon wdt:P31 wd:Q23038290} UNION {?taxon wdt:P31 wd:Q47487597 } UNION {?taxon wdt:P31 wd:Q98961713} UNION {?taxon wdt:P31 wd:Q2568288} .
  MINUS { ?taxon p:P1403 ?status. }
  ?taxon p:P225 ?name .
  ?name ps:P225 []; pq:P574 ?date FILTER (?date > "1819-12-31T00:00:00Z"^^xsd:dateTime) .
  ?name ps:P225 []; pq:P405 ?author .
  {?author wdt:P108 wd:Q663025 } UNION {?author wdt:P937 wd:Q663025} .
  BIND(YEAR(?date) AS ?year)
  BIND(FLOOR(?year / 10) * 10 AS ?decade)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?decade
ORDER BY ?decade

Query found at