query-16f8cc8eea270abf4dede873f68b7a72
Interactive balloon chart with the places most often mentioned in novels, where the size of the circle is the number of mentions. When you set mouse pointer on the circle, you can see number of places. (ERR)
Use at
- https://query.wikidata.org/sparql
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:BubbleChart
SELECT ?pid ?place (COUNT(*) as ?count)
WHERE {
?novel wdt:P31 wd:Q7725634;
wdt:P840 ?pid;
wdt:P747 ?edition.
?edition wdt:P1433 wd:Q106927517.
# wdt:P123 wd:Q106926624.
OPTIONAL {
?pid rdfs:label ?place
filter (lang(?place) = "sr")}
}
GROUP BY ?pid ?place
ORDER BY DESC(?count) ASC(?place)
Query found at
- https://www.wikidata.org/wiki/Wikidata:WikiProject_ELTeC/Queries
- https://www.wikidata.org/wiki/Wikidata:WikiProject_SrpKor/Queries
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?count")
v5("?edition")
v3("?novel")
v4("?pid"):::projected
v2("?place"):::projected
c7(["wd:Q106927517"]):::iri
c3(["wd:Q7725634"]):::iri
v3 --"wdt:P31"--> c3
v3 --"wdt:P840"--> v4
v3 --"wdt:P747"--> v5
v5 --"wdt:P1433"--> c7
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v4 -."rdfs:label".-> v2
end
bind1[/"count(*)"/]
bind1 --as--o v6