query-fe4db4db38d8ce8fcbe3b2c9c4316dff

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#title:Publications by year
#defaultView:BubbleChart
SELECT (str(?year_) as ?year) (count(*) as ?count)
WHERE
{
  VALUES ?place {wd:Q8692 wd:Q10313 wd:Q497801 wd:Q14318}
  ?item wdt:P291 ?place.
  ?item wdt:P577 ?publishing_date . 
  FILTER(?publishing_date >= "1700-01-01"^^xsd:date && ?publishing_date <= "1799-12-31"^^xsd:dat)
  BIND(YEAR(?publishing_date) as ?year_)
}
GROUP BY ?year_ ORDER BY DESC(?count)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?count") v4("?item") v3("?place") v2("?publishing_date") v6("?year") v5("?year_"):::projected f0[["?publishing_date >= '1700-01-01^^xsd:date'?publishing_date <= s1799-12-31^^<http://www.w3.org/2001/XMLSchema#dat>'"]] f0 --> v2 bind1[/VALUES ?place/] bind1-->v3 bind10(["wd:Q8692"]) bind10 --> bind1 bind11(["wd:Q10313"]) bind11 --> bind1 bind12(["wd:Q497801"]) bind12 --> bind1 bind13(["wd:Q14318"]) bind13 --> bind1 v4 --"wdt:P291"--> v3 v4 --"wdt:P577"--> v2 bind2[/"year-from-dateTime(?publishing_date)"/] v2 --o bind2 bind2 --as--o v5 bind4[/"str(?year_)"/] v5 --o bind4 bind4 --as--o v6 bind5[/"count(*)"/] bind5 --as--o v7