query-e9e2c7e346e0439cb8f732ef51fb450e
Cancer deaths per year and cancer type Cancer deaths per year and cancer type Cancer deaths per year and cancer type Cancer deaths per year and cancer type Cancer deaths per year and cancer type Décès du cancer par an et par type de cancer Cancer deaths per year and cancer type Cancer deaths per year and cancer type Cancer deaths per year and cancer type 年および癌の種類ごとの癌による死亡 De sterfte per jaar aan kanker per type kanker Cancer deaths per year and cancer type Cancerdödsfall per år och cancertyp Cancer deaths per year and cancer type Cancer deaths per year and cancer type Cancer deaths per year and cancer type
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:AreaChart
SELECT ?cid (STR(SAMPLE(?year)) AS ?year) (COUNT(*) AS ?count) ?cause WHERE {
?pid wdt:P31 wd:Q5; # instance of human
wdt:P509 ?cid; # cause of death
wdt:P570 ?_date_of_death.
?cid wdt:P279* wd:Q12078. # type of cancer
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?cid rdfs:label ?cause. }
BIND ( YEAR(?_date_of_death) AS ?year )
FILTER( ?year > 1960 )
}
GROUP BY ?cid ?cause ?year
Query found at
- 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