query-b1b5dc47d6a1f53f12258744fddf6f79
Chart of humans pronouns on Wikidata
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#defaultView:BarChart
SELECT ?display (COUNT(*) AS ?count)
WHERE {
?item wdt:P31 wd:Q5 .
?item wdt:P6553 ?pronoun .
# get the human readable part of a lexeme
?pronoun wikibase:lemma ?label .
# get the language of the lexeme
BIND( LANG(?label) AS ?language )
# create a string to display
BIND(CONCAT(STR(?label), " [", STR(?language), "]") AS ?display)
}
GROUP BY ?display
ORDER BY DESC(?count)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v7("?count")
v6("?display"):::projected
v2("?item")
v4("?label")
v5("?language")
v3("?pronoun")
c2(["wd:Q5"]):::iri
v2 --"wdt:P31"--> c2
v2 --"wdt:P6553"--> v3
v3 --"wikibase:lemma"--> v4
bind0[/"?label"/]
v4 --o bind0
bind0 --as--o v5
bind1[/"concat(str(?label),' #91;',str(?language),'#93;')"/]
v4 --o bind1
v5 --o bind1
bind1 --as--o v6
bind3[/"count(*)"/]
bind3 --as--o v7