Skip to content
bedrock.bio

open_targets.clinical_report

import bedrock_bio as bb

rel = bb.load_table('open_targets.clinical_report')

df = rel.limit(5).pl()  # Polars
df = rel.limit(5).df()  # Pandas
df.head()
id clinicalStage origin type source provider drugs countries trialDescription phaseFromSource ... qualityControls trialPrimaryPurpose title trialNumberOfArms trialOverallStatus year trialStopReasonCategories url trialStartDate version
0 00011703-bc55-4c0c-858c-149dc674bc3c APPROVAL DRUG_LABEL INDICATION DailyMed ChEMBL [{'drugFromSource': 'OFLOXACIN', 'drugId': 'CH... <NA> None APPROVAL ... <NA> None Report in Approval stage for Ofloxacin and Inf... <NA> None <NA> <NA> https://dailymed.nlm.nih.gov/dailymed/drugInfo... NaT 26.09
1 0002ad27-779d-42ab-83b5-bc65453412a1 APPROVAL DRUG_LABEL INDICATION DailyMed ChEMBL [{'drugFromSource': 'TRAMETINIB DIMETHYL SULFO... <NA> None APPROVAL ... <NA> None Report in Approval stage for Trametinib Dimeth... <NA> None <NA> <NA> https://dailymed.nlm.nih.gov/dailymed/drugInfo... NaT 26.09
2 0002eded-a283-4590-a78c-b6ff2027e684 APPROVAL DRUG_LABEL INDICATION DailyMed ChEMBL [{'drugFromSource': 'GABAPENTIN', 'drugId': 'C... <NA> None APPROVAL ... <NA> None Report in Approval stage for Gabapentin and 2 ... <NA> None <NA> <NA> https://dailymed.nlm.nih.gov/dailymed/drugInfo... NaT 26.09
3 0003458f-352a-46fa-9d99-230daa76ae29 APPROVAL DRUG_LABEL INDICATION DailyMed ChEMBL [{'drugFromSource': 'GLIMEPIRIDE', 'drugId': '... <NA> None APPROVAL ... <NA> None Report in Approval stage for Glimepiride and T... <NA> None <NA> <NA> https://dailymed.nlm.nih.gov/dailymed/drugInfo... NaT 26.09
4 0005e2a8-3ab9-4173-a46f-9c53881379e2 APPROVAL DRUG_LABEL INDICATION DailyMed ChEMBL [{'drugFromSource': 'CLOPIDOGREL BISULFATE', '... <NA> None APPROVAL ... <NA> None Report in Approval stage for Clopidogrel Bisul... <NA> None <NA> <NA> https://dailymed.nlm.nih.gov/dailymed/drugInfo... NaT 26.09

Description

Section titled “Description”

Clinical trial and regulatory reports from multiple sources, capturing trial metadata, associated drugs, diseases, side effects, and trial outcomes [Drug, Disease]

Partitions

Section titled “Partitions”

Not partitioned.

Schema

Section titled “Schema”
Column Type Description
id TEXT Unique identifier for the clinical report
clinicalStage TEXT Clinical stage of the report
origin TEXT Nature of the record the report originates from (e.g. CLINICAL_TRIAL, DRUG_LABEL, REGULATORY_AGENCY, CURATED_RESOURCE)
type TEXT Kind of evidence the report describes: INDICATION for a drug/disease claim, SAFETY for a drug warning
source TEXT Source database or registry from which the clinical report was obtained
provider TEXT Resource or organisation that distributes the data fetched from the primary source (e.g. AACT, ChEMBL, EMA, PMDA, TTD)
drugs STRUCT(drugFromSource TEXT, drugId TEXT)[] Drugs associated with the clinical report
countries TEXT[] Countries associated with the clinical report
trialDescription TEXT Brief description of the clinical trial
phaseFromSource TEXT Clinical phase as reported in the source
trialOfficialTitle TEXT Official title of the clinical trial as registered
trialSponsor STRUCT(agencyClass TEXT, name TEXT) Lead sponsor associated with the clinical trial
diseases STRUCT(diseaseFromSource TEXT, diseaseId TEXT)[] Diseases associated with the clinical report
trialLiterature STRUCT(id TEXT, type TEXT)[] Literature references associated with the clinical trial
sideEffects STRUCT(diseaseId TEXT, diseaseFromSource TEXT)[] Side effects or adverse events associated with the clinical report
trialPhase TEXT Phase of the clinical trial
trialWhyStopped TEXT Reason provided for stopping the clinical trial
trialStudyType TEXT Type of clinical study (e.g. Interventional, Observational)
qualityControls TEXT[] Quality control flags or notes for the clinical report
trialPrimaryPurpose TEXT Primary purpose of the clinical trial (e.g. Treatment, Prevention)
title TEXT Title of the clinical report
trialNumberOfArms INT Number of arms in the clinical trial
trialOverallStatus TEXT Overall status of the clinical trial (e.g. Completed, Terminated)
year INT Year the report was registered or published
trialStopReasonCategories TEXT[] Categories describing reasons why the trial was stopped
url TEXT URL linking to the source record
trialStartDate DATE Start date of the clinical trial
version TEXT Open Targets Platform release version (major.minor), e.g. 26.09. Added during ingest.