SARS-CoV-2-Queries

litHumanCoronavirusesCounts.rq

Code examples: curl

SPARQL

SELECT ?virus ?virusLabel ?count WITH {
  SELECT ?virus (COUNT(DISTINCT ?work) AS ?count) WHERE {
    VALUES ?virus {
      wd:Q82069695 # SARS-CoV-2
      wd:Q16983360 # HKU1
      wd:Q16991954 # OC43
      wd:Q8351095  # NL63 
      wd:Q16983356 # 229E 
      wd:Q4902157  # MERS-CoV
      wd:Q278567   # SARS-CoV
    }
    ?work wdt:P921 ?virus .
  } GROUP BY ?virus
} AS %ARTICLES WHERE {
  INCLUDE %ARTICLES
  SERVICE wikibase:label { bd:serviceParam wikibase:language "pt,en". }
}
ORDER BY DESC(?count)

run or edit

Output

virus	count
coronavírus da síndrome respiratória aguda grave 2 (edit)	25971
SARS-CoV (edit)	2492
coronavírus da síndrome respiratória do Oriente Médio (edit)	1053
Coronavírus humano OC43 (edit)	116
Coronavírus humano 229E (edit)	110
Coronavírus humano NL63 (edit)	94
Coronavírus humano HKU1 (edit)	22

Code examples

curl

curl -s https://raw.githubusercontent.com/egonw/SARS-CoV-2-Queries/master/sparql/litHumanCoronavirusesCounts.rq | sed 's+<lang/>+pt+' > litHumanCoronavirusesCounts.rq

curl -H "Accept: text/tab-separated-values" -G https://query.wikidata.org/bigdata/namespace/wdq/sparql --data-urlencode query@litHumanCoronavirusesCounts.rq

This SPARQL query is available under CCZero.

This site is open source. Improve this page.