query-48d02347d6140491e706824c9e6b8a43

rq turtle/ttl

501 (auxiliary) WFM Dictionary No.

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Aviation accidents and incidents, since 1950, sorted by operator.
#defaultView:AreaChart
SELECT ?operator (str(SAMPLE(?year)) AS ?year ) (COUNT(*) AS ?count) ?operatorLabel
WHERE 
{   
  ?item wdt:P31 wd:Q744913 .
  ?item wdt:P137 ?operator .
  ?item wdt:P585 ?time.


  BIND ( YEAR(?time) AS ?year )
  FILTER( BOUND(?operator)  )
  FILTER( BOUND(?year)  )
  FILTER( ?year > 1950 )
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
        }
  GROUP BY ?operator ?operatorLabel ?year

Query found at