query-29f503d267cc465446b6e7567641c253
Overall causes of death ranking Overall causes of death ranking Overall causes of death ranking Overall causes of death ranking Overall causes of death ranking Classement des causes générales de mortalité Rang de toutes les causes de mort Overall causes of death ranking Overall causes of death ranking Overall causes of death ranking 死因の総合ランキング Algemene rangschikking van doodsoorzaken Rangschikken op oorzaak overlijden Overall causes of death ranking Övergripande dödsorsaker rankade Overall causes of death ranking Overall causes of death ranking Overall causes of death ranking Overall causes of death ranking 死因排名概览
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/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:BubbleChart
#TEMPLATE={"template":"Overall causes of death ranking of ?thing ","variables":{"?thing": {"query":"SELECT ?id (COUNT(?id) AS ?count) WHERE { ?sub wdt:P509 ?y. ?sub wdt:P31 ?id. } GROUP BY ?id "} } }
SELECT ?cid ?cause (COUNT(*) AS ?count) WHERE {
BIND(wd:Q5 AS ?thing)
?pid wdt:P31 ?thing;
wdt:P509 ?cid.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?cid rdfs:label ?cause}
}
GROUP BY ?cid ?cause
ORDER BY DESC(?count) ?cause
Query found at
- https://www.wikidata.org/wiki/User:Duesentrieb/WDQL
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/en
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/es
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/fr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/hy
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/ja
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/nl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/sv
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/tr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/uk
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/zh
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/ar
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/arz
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/da
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/en
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/es
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/fr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/hy
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/id
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/it
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/ja
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/nl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/pl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/sv
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/th
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/uk
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/human/zh
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?cause"):::projected
v5("?cid"):::projected
v6("?count")
v4("?pid")
v3("?thing")
c4(["bd:serviceParam"]):::iri
c6(["#91;AUTO_LANGUAGE#93;,en"]):::literal
bind0[/"'wd:Q5'"/]
bind0 --as--o v3
v4 --"wdt:P31"--> v3
v4 --"wdt:P509"--> v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c4 --"wikibase:language"--> c6
v5 --"rdfs:label"--> v2
end
bind2[/"count(*)"/]
bind2 --as--o v6