SARS-CoV-2-Queries

clinicalTrialsByIntervention.rq

Code examples: curl

SPARQL

SELECT ?intervention ?interventionLabel (COUNT(?trial) AS ?trials) WHERE {
  VALUES ?topic {
    wd:Q84263196 wd:Q82069695
  }
  ?trial wdt:P31 wd:Q30612 ;
         wdt:P921  ?topic ;
         wdt:P4844 ?intervention .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,en". }
} GROUP BY ?intervention ?interventionLabel
  ORDER BY DESC(?trials) ASC(?intervention)

run or edit

Output

intervention trials
hydroxychloroquine (edit) 43
chloroquine (edit) 15
lopinavir (edit) 15
ritonavir (edit) 15
Chloroquine diphosphate bearing dextran nanoparticles augmented drug delivery and overwhelmed drug resistance in Plasmodium falciparum parasites (edit) 12
COVID-19 (edit) 11
tocilizumab (edit) 6
interferon (edit) 4
nitric oxide (radical) (edit) 4
antiviral agent (edit) 4
losartan (edit) 4
paracetamol (edit) 4
prednisolone (edit) 3
azithromycin (edit) 3
DL-ascorbic acid (edit) 3
methylprednisolone acetate (edit) 3
prednisolone acetate (edit) 3
methylprednisolone hemisuccinate (edit) 3
prednisolone 21-phosphate (edit) 3
prednisolone hemisuccinate (edit) 3
ACE inhibitor (edit) 3
Siltuximab (edit) 3
methylprednisolone (edit) 3
budesonide (edit) 3
nivolumab (edit) 3
mRNA-1273 (edit) 3
tenofovir (edit) 2
Janus kinase inhibitors (edit) 2
thalidomide (edit) 2
coal tar pitch volatiles (edit) 2
interferon beta-1a (edit) 2
dexamethasone acetate (edit) 2
remdesivir (edit) 2
Sargramostim (edit) 2
cyclophosphamide (edit) 2
bevacizumab (edit) 2
anakinra (edit) 2
emtricitabine (edit) 2
ruxolitinib (edit) 2
BCG vaccine (edit) 2
gloriosine (edit) 2
naproxen (edit) 1
citric acid (edit) 1
non-steroidal anti-inflammatory drug (edit) 1
thymalfasin (edit) 1
oseltamivir (edit) 1
bromhexine (edit) 1
immunosuppressive drug (edit) 1
piclidenoson (edit) 1
sildenafil citrate (edit) 1
formoterol fumarate (edit) 1
fingolimod hydrochloride (edit) 1
(5R)-24,25-Dihydroxyvitamin D (edit) 1
chloroquine phosphate (edit) 1
(S)-(−)-colchicine (edit) 1
darunavir (edit) 1
lopinavir/ritonavir (edit) 1
trisodium citrate (edit) 1
levamisole (edit) 1
deferoxamine (edit) 1
phentolamine (edit) 1
Ergocalciferols (edit) 1
Angiotensin II (edit) 1
Ciclesonide (edit) 1
gabexate (edit) 1
neonate (edit) 1
immunoglobulin (edit) 1
atorvastatin (edit) 1
Xuebijing (edit) 1
AZD1222 (edit) 1
COVAX-19 (edit) 1
tozinameran (edit) 1

Code examples

curl

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

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

This SPARQL query is available under CCZero.