query-e702ddbdc7e02e679a045d639467e827

TODO

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#defaultView:BarChart
SELECT ?part (STR(YEAR(?pit)) AS ?year) (COUNT(*) AS ?counts) 
WHERE 
{
  ?item wdt:P31 wd:Q7604686.
  ?item wdt:P179 ?part.
  ?part wdt:P1001 wd:Q25;
        wdt:P585 ?pit.
}
GROUP BY ?part ?partLabel ?pit

Query found at

https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/10

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?counts") v1("?item") v2("?part"):::projected v3("?pit"):::projected v4("?year") c2(["wd:Q7604686"]):::iri c5(["wd:Q25"]):::iri v1 --"wdt:P31"--> c2 v1 --"wdt:P179"--> v2 v2 --"wdt:P1001"--> c5 v2 --"wdt:P585"--> v3 bind1[/"str(year-from-dateTime(?pit))"/] v3 --o bind1 bind1 --as--o v4 bind2[/"count(*)"/] bind2 --as--o v5