Skip to content
bedrock.bio

clinical_report

Identifier

Section titled “Identifier”
open_targets.clinical_report

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”
  • release
    • '26.06'

Schema

Section titled “Schema”
Column Type Description
id TEXT Unique identifier for the clinical report
clinicalStage TEXT Clinical stage of the report
type TEXT Type classification of the clinical report
source TEXT Source database or registry from which the clinical report was obtained
drugs STRUCT(drugFromSource TEXT, drugId TEXT)[] Drugs associated with the clinical report
trialDescription TEXT Brief description of the clinical trial
countries TEXT[] Countries associated with the clinical report
phaseFromSource TEXT Clinical phase as reported in the source
trialOfficialTitle TEXT Official title of the clinical trial as registered
diseases STRUCT(diseaseFromSource TEXT, diseaseId TEXT)[] Diseases associated with the clinical report
trialNumberOfArms INT Number of arms in the clinical trial
hasExpertReview BOOLEAN Flag indicating whether the clinical report has undergone expert review
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
trialLiterature 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
url TEXT URL linking to the source record
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)
trialStartDate DATE Start date of the clinical trial
title TEXT Title of the clinical report
release TEXT Partition column. Open Targets Platform release version (major.minor), e.g. 26.06. [Added during ingest.]