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)	24131
SARSr-CoV (edit)	2487
Middle East respiratory syndrome coronavirus (edit)	1051
Human coronavirus OC43 (edit)	114
Human coronavirus 229E (edit)	107
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.