query-b3d7b4be9feb13144d2a744a4af8eca0

rq turtle/ttl

Count by birth year of male versus female Finnish artists starting in 1760

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#defaultView:LineChart
SELECT ?year (COUNT(?_gender) AS ?count)  (SAMPLE(?_genderLabel) AS ?_genderLabel)  WHERE {
 ?item wdt:P27 wd:Q33.
   ?item wdt:P106/wdt:P279* wd:Q483501.
 ?item wdt:P569 ?_date.
 ?item wdt:P21 ?_gender.
 ?_gender rdfs:label ?_genderLabel.
 BIND(str(YEAR(?_date)) AS ?year)
 FILTER((LANG(?_genderLabel)) = "en")
 FILTER(?_date >= "1760-00-00T00:00:00Z"^^xsd:dateTime)
}
GROUP BY ?_genderLabel ?year
HAVING (?count > 1)

Query found at