How to guide ... accessing drug warning and pharmacovigilance data

Introduction:

When exploring approved drugs and investigational compounds for potential repurposing opportunities, researchers will want to review the pharmacovigilance data and withdrawn and blackbox warning data. This data can be used to determine if there are any safety or adverse event risks to the potential patient population.

For example, rofecoxib (CHEMBL122) was withdrawn from the market in 2004 by Merck due to safety concerns. However, in 2017, Tremeau Pharmaceuticals announced that it was looking to return rofecoxib to the market and repurpose the drug to treat hemophilic arthropathy. It has since registered a Phase III trial - NCT04684511.

Research questions:

  • How do I access pharmacovigilance data and withdrawn and blackbox warnings for rofecoxib?

Solution:

To access the data for rofecoxib, you can use our GraphQL API and access the data through the playground or programmatically using the programming language of choice.

GraphQL API playground

query rofecoxibData{
  drug(chemblId:"CHEMBL122"){
    name
    id
    blackBoxWarning
    hasBeenWithdrawn
    drugWarnings{
      warningType
      description
      toxicityClass
      meddraSocCode
      year
      country
      references{
        url
        source
        id
      }
    }
    adverseEvents{
      count
      criticalValue
      rows{
        name
        count
        meddraCode
        logLR
      }
    }
  }
}

Programmatic access

Alternatively, you can use your programming language of choice to construct the GraphQL API query string. This will allow you to retrieve the data, parse it, and export it to support further downstream analyses.

Python

TBD

1 Like