SARS-CoV-2-Queries

surfaces.rq

コード例: curl

SPARQL

SELECT ?virus ?virusLabel ?work ?workLabel WITH {
  SELECT ?virus ?work 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 ;
          wdt:P921 wd:Q484298 .
  }
} AS %ARTICLES WHERE {
  INCLUDE %ARTICLES
  SERVICE wikibase:label { bd:serviceParam wikibase:language "ja,en". }
}
ORDER BY ?virusLabel ?workLabel

実行 もしくは 編集

結果

virus work
MERSコロナウイルス (edit) Middle East respiratory syndrome coronavirus on inanimate surfaces: A risk for health care transmission. (edit)
SARSコロナウイルス2 (edit) Aerosol and Surface Stability of SARS-CoV-2 as Compared with SARS-CoV-1 (edit)
SARSコロナウイルス2 (edit) Aerosol and surface stability of HCoV-19 (SARS-CoV-2) compared to SARS-CoV-1 (edit)
SARSコロナウイルス2 (edit) Exaggerated risk of transmission of COVID-19 by fomites (edit)
ヒトコロナウイルス229E (edit) Exaggerated risk of transmission of COVID-19 by fomites (edit)
ヒトコロナウイルス229E (edit) Human Coronavirus 229E Remains Infectious on Common Touch Surface Materials. (edit)
ヒトコロナウイルス229E (edit) Isolation and identification of human coronavirus 229E from frequently touched environmental surfaces of a university classroom that is cleaned daily (edit)
ヒトコロナウイルス229E (edit) Survival of human coronaviruses 229E and OC43 in suspension and after drying on surfaces: a possible source of hospital-acquired infections (edit)
ベータコロナウイルス1 (edit) Exaggerated risk of transmission of COVID-19 by fomites (edit)
ベータコロナウイルス1 (edit) Survival of human coronaviruses 229E and OC43 in suspension and after drying on surfaces: a possible source of hospital-acquired infections (edit)

コード例

curl

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

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

本SPARQLクエリはCC0ライセンスで利用可能です。