SARS-CoV-2-Queries

clinicalTrialsByIntervention.rq

Ejemplos de código: 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 "es,en". }
} GROUP BY ?intervention ?interventionLabel
  ORDER BY DESC(?trials) ASC(?intervention)

ejecutar o editar

Resultados

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
tocilizumab (edit) 6
interferón (edit) 4
óxido nítrico (edit) 4
agente antiviral (edit) 4
Losartán (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
Inhibidor de la enzima convertidora de angiotensina (edit) 3
Siltuximab (edit) 3
metilprednisolona (edit) 3
Budesonida (edit) 3
Nivolumab (edit) 3
MRNA-1273 (edit) 3
Tenofovir (edit) 2
Inhibidor de la quinasa Janus (edit) 2
talidomida (edit) 2
coal tar pitch volatiles (edit) 2
interferon beta-1a (edit) 2
dexamethasone acetate (edit) 2
remdesivir (edit) 2
Sargramostim (edit) 2
ciclofosfamida (edit) 2
Bevacizumab (edit) 2
anakinra (edit) 2
emtricitabina (edit) 2
ruxolitinib (edit) 2
Vacuna BCG (edit) 2
gloriosine (edit) 2
naproxeno (edit) 1
ácido cítrico (edit) 1
antiinflamatorio no esteroideo (edit) 1
thymalfasin (edit) 1
Oseltamivir (edit) 1
Bromhexina (edit) 1
inmunosupresor (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 de trisodio (edit) 1
levamisol (edit) 1
deferoxamina (edit) 1
Fentolamina (edit) 1
Ergocalciferols (edit) 1
Angiotensin II (edit) 1
Ciclesonida (edit) 1
gabexate (edit) 1
neonato (edit) 1
immunoglobulin (edit) 1
atorvastatina (edit) 1
Xuebijing (edit) 1
AZD1222 (edit) 1
COVAX-19 (edit) 1
tozinamerán (edit) 1

Ejemplos de código

curl

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

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

Esta consulta SPARQL está disponible en CCZero.