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)	24131
SARS-CoV (edit)	2487
coronavírus da síndrome respiratória do Oriente Médio (edit)	1051
Coronavírus humano OC43 (edit)	114
Coronavírus humano 229E (edit)	107
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.