Wikidata:WikiProject Clinical Trials/Query

Home

Model

Query

Curate

About

Discuss

These example queries for the Wikidata Query Service can assist with accessing Wikidata's clinical trials data.

Model profiles

Each of these queries generates a list of clinical trials associated with another concept.

• 
  medical condition treated (P2175)
• 
  research intervention (P4844)
• 
  principal investigator (P8329)
• 
  research site (P6153)
• 
  funder (P8324)

Clinical trials for Zika fever

The following query uses these:

• Items: clinical trial (Q30612)   , Zika fever (Q8071861)   , Zika virus infection (Q27043680)   

• Properties: instance of (P31)   , medical condition treated (P2175)   

  SELECT ?trial ?trialLabel  WHERE {
    ?trial wdt:P31 wd:Q30612 .
    { ?trial wdt:P2175 wd:Q8071861. }
    UNION
    { ?trial wdt:P2175 wd:Q27043680. }
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Clinical trials using COVID-19 vaccine

The following query uses these:

• Items: clinical trial (Q30612)   , COVID-19 vaccine (Q87719492)   

• Properties: instance of (P31)   , research intervention (P4844)   , subclass of (P279)   

  SELECT ?trial ?trialLabel  WHERE {
    ?trial wdt:P31 wd:Q30612 .
    ?trial wdt:P4844 ?intervention. 
    ?intervention wdt:P31/wdt:P279* wd:Q87719492 .
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Clinical trials at Vanderbilt University

The following query uses these:

• Items: clinical trial (Q30612)   , Vanderbilt University (Q29052)   

• Properties: instance of (P31)   , research site (P6153)   , parent organization (P749)   

  SELECT ?trial ?trialLabel WHERE {
    ?trial wdt:P31 wd:Q30612 .
    { ?trial wdt:P6153 [ wdt:P749* wd:Q29052  ] .}
    
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Clinical trials with Julie McElrath as principal investigator

The following query uses these:

• Items: clinical trial (Q30612)   , Julie McElrath (Q22006776)   

• Properties: instance of (P31)   , principal investigator (P8329)   

  SELECT ?trial ?trialLabel WHERE {
    ?trial wdt:P31 wd:Q30612 .
    { ?trial wdt:P8329 wd:Q22006776 .}
    
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Clinical trials funded by Patient-Centered Outcomes Research Institute

• examples:
  • Aspirin Dosing: A Patient-Centric Trial Assessing Benefits and Long-term (Q65392692) (sponsor (P859))
  • Comparing the Benefits and Harms of Three Types of Weight Loss Surgery -- The PCORnet® Bariatric Study (Q93611889) (funder (P8324))
• draft query:

The following query uses these:

• Items: clinical trial (Q30612)   , Patient-Centered Outcomes Research Institute (Q7144950)   

• Properties: instance of (P31)   , funder (P8324)   , sponsor (P859)   

  SELECT ?trial ?trialLabel ?link WHERE {
    ?trial wdt:P31 wd:Q30612 .
    { ?trial wdt:P8324 wd:Q7144950 .}
    UNION
    { ?trial wdt:P859 wd:Q7144950 .}
    ?trial ?link wd:Q7144950 .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Topics by count of clinical trials

Medical conditions

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: subclass of (P279)   , medical condition (P1050)   , instance of (P31)   

  SELECT DISTINCT ?condition ?conditionLabel (COUNT(?trial) AS ?count) 
  WHERE
  {
     ?trial p:P31/ps:P31/wdt:P279* wd:Q30612.
     ?trial wdt:P1050 ?condition .
     SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  GROUP BY ?condition ?conditionLabel ?count 
  ORDER BY DESC(?count)
  

Try it!

Research interventions

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: subclass of (P279)   , research intervention (P4844)   , instance of (P31)   

  SELECT DISTINCT ?intervention ?interventionLabel (COUNT(?trial) AS ?count) 
  WHERE
  {
     ?trial p:P31/ps:P31/wdt:P279* wd:Q30612.
     ?trial wdt:P4844 ?intervention .
     SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  GROUP BY ?intervention ?interventionLabel ?count 
  ORDER BY DESC(?count)
  

Try it!

Research sites

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: instance of (P31)   , research site (P6153)   , parent organization (P749)   

  SELECT DISTINCT ?research_site ?research_siteLabel ?count
  WITH {
    SELECT ?research_site (COUNT(?trial) AS ?count)  WHERE {
      ?trial wdt:P31 wd:Q30612 .
      { ?trial wdt:P6153 ?research_site . }
      UNION
      { ?trial wdt:P6153 [wdt:P749 ?research_site] . }  
    }
    GROUP BY ?research_site
  } AS %sites
  WHERE {
    INCLUDE %sites
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  GROUP BY ?research_site ?research_siteLabel ?count
  ORDER BY DESC(?count)
  

Try it!

Principal investigators

Bubble chart version:

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: instance of (P31)   , principal investigator (P8329)   , employer (P108)   , affiliation (P1416)   

Features: BubbleChart (Q24515280)   

#defaultView:BubbleChart
SELECT (COUNT(DISTINCT ?trial) AS ?count) ?PI ?PILabel 
WHERE {
  ?trial wdt:P31 wd:Q30612 .
  { ?trial wdt:P8329 ?PI .}

  { ?PI wdt:P108 ?org }  
  UNION
  { ?PI wdt:P1416 ?org }  

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?PI ?PILabel 
ORDER BY DESC(?count)

Try it!

Funders

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: subclass of (P279)   , sponsor (P859)   , funder (P8324)   , instance of (P31)   

  SELECT DISTINCT ?funder ?funderLabel (COUNT(?trial) AS ?count) 
  WHERE
  {
     ?trial p:P31/ps:P31/wdt:P279* wd:Q30612.
    { ?trial wdt:P859 ?funder .}
    UNION
    { ?trial wdt:P8324 ?funder .}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  GROUP BY ?funder ?funderLabel ?count 
  ORDER BY DESC(?count)
  

Try it!

Organizational affiliations

Clinical trials with principal investigator and their affiliation

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: instance of (P31)   , principal investigator (P8329)   , employer (P108)   , affiliation (P1416)   

  SELECT ?trial ?trialLabel ?PI ?PILabel ?org ?orgLabel  WHERE {
    ?trial wdt:P31 wd:Q30612 .
    { ?trial wdt:P8329 ?PI .}
  
    { ?PI wdt:P108 ?org }  
    UNION
    { ?PI wdt:P1416 ?org }  
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Clinical trials where principal investigator has Vanderbilt University affiliation

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: instance of (P31)   , principal investigator (P8329)   , employer (P108)   , parent organization (P749)   , affiliation (P1416)   

  # Q29052 is Vanderbilt University
  PREFIX target: <http://www.wikidata.org/entity/Q29052>
  
  SELECT ?trial ?trialLabel ?PI ?PILabel  WHERE {
    ?trial wdt:P31 wd:Q30612 .
    { ?trial wdt:P8329 ?PI .}
  
    { ?PI wdt:P108 [ wdt:P749* target: ] }  
    UNION
    { ?PI wdt:P1416 [ wdt:P749* target: ] }  
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Chart of organizations by count of clinical trials

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: instance of (P31)   , principal investigator (P8329)   , employer (P108)   , affiliation (P1416)   

Features: BubbleChart (Q24515280)   

#defaultView:BubbleChart
SELECT (COUNT(DISTINCT ?trial) AS ?count) ?org ?orgLabel 
WHERE {
  ?trial wdt:P31 wd:Q30612 .
  { ?trial wdt:P8329 ?PI .}

  { ?PI wdt:P108 ?org }  
  UNION
  { ?PI wdt:P1416 ?org }  

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?org ?orgLabel 
ORDER BY DESC(?count)

Try it!

Clinical trials where the sponsor was Pfizer

The following query uses these:

• Items: clinical trial (Q30612)   , Pfizer (Q206921)   

• Properties: instance of (P31)   , sponsor (P859)   , funder (P8324)   

  SELECT ?trial ?trialLabel  WHERE {
    ?trial wdt:P31 wd:Q30612 .
    { ?trial wdt:P859 wd:Q206921 .}
    UNION
    { ?trial wdt:P8324 wd:Q206921 .}
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Researcher demographics

Count of principal investigators by gender

SELECT (COUNT(?trial) AS ?count) ?gender ?genderLabel WHERE {
  ?trial wdt:P31 wd:Q30612 .
  ?trial wdt:P8329 ?pi .
  ?pi wdt:P21 ?gender .
  ?pi wikibase:sitelinks ?sl .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?count  ?gender ?genderLabel

Try it!

Clinical trials where the principal investigator is female

The following query uses these:

• Items: clinical trial (Q30612)   , female (Q6581072)   

• Properties: instance of (P31)   , principal investigator (P8329)   , sex or gender (P21)   

  SELECT ?trial ?trialLabel ?pi ?piLabel ?sl WHERE {
    ?trial wdt:P31 wd:Q30612 .
    ?trial wdt:P8329 ?pi .
    ?pi wdt:P21 wd:Q6581072 .
    ?pi wikibase:sitelinks ?sl .
    
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Principal investigators by occupation

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: instance of (P31)   , principal investigator (P8329)   , occupation (P106)   

  SELECT DISTINCT ?occupation ?occupationLabel (COUNT(?trial) AS ?count) ?sl WHERE {
    ?trial wdt:P31 wd:Q30612 .
    ?trial wdt:P8329 ?pi .
    ?pi wdt:P106 ?occupation .
    ?occupation wikibase:sitelinks ?sl .
    
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  GROUP BY ?count ?occupation ?occupationLabel ?sl
  ORDER BY DESC(?count)
  

Try it!

Scope of Wikidata's clinical trials content

List of clinical trials

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: subclass of (P279)   , ClinicalTrials.gov ID (P3098)   , start time (P580)   , end time (P582)   , clinical trial phase (P6099)   , number of participants (P1132)   , instance of (P31)   

  # List of clinical trials
  SELECT ?item ?nct_id ?itemLabel ?phaseLabel ?enrollment ?start_date ?primary_completion_date
  WHERE
  {
     ?item p:P31/ps:P31/wdt:P279* wd:Q30612.
     ?item wdt:P3098 ?nct_id .
     OPTIONAL { ?item wdt:P580  ?start_date }
     OPTIONAL { ?item wdt:P582 ?primary_completion_date }
     OPTIONAL { ?item wdt:P6099 ?phase }
     OPTIONAL { ?item wdt:P1132 ?enrollment }
     SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Count of clinical trials

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: subclass of (P279)   , instance of (P31)   

  # Count clinical trials
  SELECT (count(distinct ?item) as ?count)
  WHERE {?item p:P31/ps:P31/wdt:P279* wd:Q30612}
  

Try it!

Most common properties applied to clinical trials

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: instance of (P31)   , subclass of (P279)   

  SELECT DISTINCT ?property ?propertyLabel ?count
  WITH {
    SELECT DISTINCT ?item WHERE {
      ?item wdt:P31*/wdt:P279* wd:Q30612 .
    }
    LIMIT 400000
    } AS %items 
  WITH {
    SELECT DISTINCT ?property (COUNT(*) AS ?count) WHERE {
    INCLUDE %items.
      ?item ?p [ ] .
      ?property a wikibase:Property;
                  wikibase:claim ?p.
    }
    GROUP BY ?property 
    LIMIT 200
    } AS %results 
  WHERE {
    INCLUDE %results.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  }
  ORDER BY DESC(?count)
  LIMIT 200
  

Try it!

Count of statements in clinical trial records

The following query uses these:

• Items: clinical trial (Q30612)   

• Properties: instance of (P31)   , subclass of (P279)   

  #defaultView:AreaChart
  SELECT ?st ?ct {
    {
     BIND (0 AS ?ct)
     BIND (0 AS ?st)
    }
    UNION {
      SELECT ?st (COUNT(*) as ?ct)
      {
        ?item wdt:P31*/wdt:P279* wd:Q30612 ; wikibase:statements ?st
      }
      GROUP BY ?st
      ORDER BY ?st
    }
  }
  

Try it!

Count of trial records in Wikidata per clinical trial registry

The following query uses these:

• Items: clinical trial (Q30612)   , clinical trials registry (Q2138567)   

• Properties: instance of (P31)   , used by (P1535)   , Wikidata item of this property (P1629)   

  SELECT DISTINCT ?registry ?registryLabel ?count
  WITH {
    SELECT DISTINCT ?item WHERE {
      ?item wdt:P31 wd:Q30612 ;
    }
    LIMIT 400000
  } AS %items 
  WITH {
    SELECT DISTINCT ?registry ?registryIDitem WHERE {
      ?registry wdt:P31 wd:Q2138567 .
      ?registryIDitem wdt:P1535 ?registry .
    }
    GROUP BY ?registry ?registryIDitem
    LIMIT 100
  } AS %registries 
  WITH {
    SELECT DISTINCT ?registry (COUNT(*) AS ?count) WHERE {
      INCLUDE %items.
      INCLUDE %registries.
      ?item ?p [ ] .
      ?property wdt:P1629 ?registryIDitem;
                wikibase:claim ?p.
      ?property wikibase:propertyType wikibase:ExternalId .
    }
    GROUP BY ?registry 
    LIMIT 100
  } AS %results 
  WHERE {
    INCLUDE %results.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  }
  ORDER BY DESC(?count)
  LIMIT 100
  

Try it!

Scholia queries

Scholia can display clinical trial-related information.

• Overview: https://scholia.toolforge.org/clinical-trial/
• Example: https://scholia.toolforge.org/clinical-trial/Q17148583 (for PARAMOUNT trial (Q17148583))