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 "en,en". }
}
ORDER BY DESC(?count)

run or edit

Output

virus	count
SARS-CoV-2 (edit)	25971
SARSr-CoV (edit)	2492
Middle East respiratory syndrome coronavirus (edit)	1053
Human coronavirus OC43 (edit)	116
Human coronavirus 229E (edit)	110
human Coronavirus NL63 (edit)	94
Human coronavirus HKU1 (edit)	22

Code examples

curl

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