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
tocilizumab (edit)	6
interferon (edit)	4
nitric oxide (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
remdesivir (edit)	3
ACE inhibitor (edit)	3
siltuximab (edit)	3
methylprednisolone (edit)	3
budesonide (edit)	3
nivolumab (edit)	3
mRNA-1273 vaccine (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
sargramostim (edit)	2
(RS)-cyclophosphamide (edit)	2
bevacizumab (edit)	2
anakinra (edit)	2
emtricitabine (edit)	2
ruxolitinib (edit)	2
BCG vaccine (edit)	2
COVID-19 (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
angiotensin II (edit)	1
levamisole (edit)	1
deferoxamine (edit)	1
phentolamine (edit)	1
Ergocalciferols (edit)	1
ciclesonide (edit)	1
gabexate (edit)	1
immunoglobulin (edit)	1
atorvastatin (edit)	1
Xue-Bi-Jing (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.

This site is open source. Improve this page.