query-26804a54443b5077b216c758e29aef9c

rq turtle/ttl

Show bubble chart by place, gender of printer and/or languageHi everyone, Last month I requested a bubble chart to show results for printed matter (Q1261026) and publication (Q732577) items by year for the period 1700 to 1799. Now I upgraded my attempt to a somewhat more complex level. I attempted the easy way to get "places of publication" bubbles instead of years, by replacing years with places, but that obviously did not work. by place of publication, by gender of the printer (Q175151 or) and language of printed work (P407 > Q?), three different graphs really, if that is possible. I add below the base to get year bubbles (proportion of printed matter or publications published each year) in the places of publication specified, which may help. Thank you in advance for your time printed matter (Q1261026) and publication (Q732577)So my goal would be for the same period to show a count of

Use at

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

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 (Basque Country)
#defaultView:BubbleChart
SELECT (str(?year_) as ?year) (count(*) as ?count)
WHERE
{
  VALUES ?place {wd:Q8692 wd:Q10313 wd:Q497801 wd:Q14318 wd:Q10282 wd:Q134674}
  ?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)

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/09