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 "pt,en". }
} GROUP BY ?intervention ?interventionLabel
  ORDER BY DESC(?trials) ASC(?intervention)

run or edit

Output

intervention trials
Hidroxicloroquina (edit) 43
cloroquina (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
tocilizumabe (edit) 6
interferon (edit) 4
óxido nítrico (edit) 4
antiviral agent (edit) 4
losartan (edit) 4
paracetamol (edit) 4
prednisolona (edit) 3
azitromicina (edit) 3
ácido ascórbico (edit) 3
methylprednisolone acetate (edit) 3
prednisolone acetate (edit) 3
methylprednisolone hemisuccinate (edit) 3
prednisolone 21-phosphate (edit) 3
prednisolone hemisuccinate (edit) 3
Inibidor da enzima de conversão da angiotensina (edit) 3
Siltuximab (edit) 3
metilprednisolona (edit) 3
budesonida (edit) 3
nivolumab (edit) 3
mRNA-1273 (edit) 3
tenofovir (edit) 2
Janus kinase inhibitors (edit) 2
talidomida (edit) 2
coal tar pitch volatiles (edit) 2
interferão beta-1a (edit) 2
dexamethasone acetate (edit) 2
Remdesivir (edit) 2
Sargramostim (edit) 2
ciclofosfamida (edit) 2
Bevacizumab (edit) 2
anakinra (edit) 2
emtricitabine (edit) 2
ruxolitinib (edit) 2
Bacillus Calmette-Guérin (edit) 2
gloriosine (edit) 2
naproxeno (edit) 1
ácido cítrico (edit) 1
anti-inflamatório não esteroides (edit) 1
thymalfasin (edit) 1
oseltamivir (edit) 1
bromexina (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
Colchicina (edit) 1
darunavir (edit) 1
lopinavir/ritonavir (edit) 1
citrato trissódico (edit) 1
levamisol (edit) 1
deferoxamina (edit) 1
fentolamina (edit) 1
Ergocalciferols (edit) 1
Angiotensin II (edit) 1
ciclesonida (edit) 1
gabexate (edit) 1
recém-nascido (edit) 1
Imunoglobulina (edit) 1
atorvastatina (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/>+pt+' > 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.