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
dexamethasone acetate (edit)	2
Janus kinase inhibitors (edit)	2
thalidomide (edit)	2
coal tar pitch volatiles (edit)	2
interferon beta-1a (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
Pfizer–BioNTech COVID-19 vaccine (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.