223

• License: https://www.gnu.org/licenses/gpl-3.0

• Uses method in: https://github.com/WDscholia/scholia/tree/master/scholia/app/templates/venue_top-topics-through-time.sparql

rq turtle/ttl

Venue aspect: top topics through time

Use at

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

PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
#defaultView:AreaChart

PREFIX target: <http://www.wikidata.org/entity/Q6294930>

SELECT
  ?year
  ?works
  ?topic ?topicLabel
WITH {
  SELECT 
    ?work
  WHERE {
    ?work wdt:P1433 target: .
  }
} AS %works
WITH {
  SELECT
    (COUNT(?work) AS ?count)
    ?topic
  WHERE {
    INCLUDE %works
    ?work wdt:P921 ?topic .
  }
  GROUP BY ?topic
  ORDER BY DESC(?count)
  LIMIT 5
} AS %topics
WITH {
  SELECT
    ?year 
    (COUNT(?work) AS ?works)
    ?topic
  WHERE {
    INCLUDE %works
    INCLUDE %topics
    ?work wdt:P921 ?topic ;
          wdt:P577 ?publication_datetime .
    BIND(STR(YEAR(?publication_datetime)) AS ?year)
  }
  GROUP BY ?year ?topic
} AS %result
WHERE {
  INCLUDE %result
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
ORDER BY ?year

graph TD