query-800286640ab12e6f451f07134484640a

rq turtle/ttl

Film, TV, and Video Games set in Seattle by Release Year

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#>
#first line for testing, second for bar chart
#SELECT ?item ?itemLabel ?typeLabel ?year_ ?locationLabel Where {
SELECT (str(SAMPLE(?year_)) AS ?year ) (COUNT( ?item) as ?count) ?typeLabel WHERE {
  VALUES ?type {wd:Q11424 wd:Q7889 wd:Q15416}
  ?item wdt:P31/wdt:P279* ?type.
  ?item wdt:P840 ?location.
  ?location wdt:P131* wd:Q5083.
  ?item wikibase:sitelinks ?linkcount.
  ?item wdt:P577 ?releaseDate.
  BIND(YEAR(?releaseDate) as ?year_).           
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,es,ar,fr" }
  FILTER( ?year_ > 1900)
}
#first line for testing, second for bar chart
#GROUP BY ?item ?itemLabel ?typeLabel ?year_ ?locationLabel
GROUP BY ?year_ ?count ?typeLabel
ORDER BY ASC(?year_)
#defaultView:BarChart

Query found at