open_targets.clinical_indication

Python

In [1]:

import bedrock_bio as bb

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

df = rel.limit(5).pl()  # Polars
df = rel.limit(5).df()  # Pandas
df.head()

Out[1]:

	id	maxClinicalStage	clinicalReportIds	diseaseId	drugId	version
0	bcae49c2072f6bce9286dcced5374756568bbc17c3c389...	APPROVAL	[00011703-bc55-4c0c-858c-149dc674bc3c, 006095a...	EFO_0000544	CHEMBL4	26.09
1	df2ffa13f012d1eb1938575935f121d406e68257746740...	APPROVAL	[0002ad27-779d-42ab-83b5-bc65453412a1]	MONDO_0008903	CHEMBL2105741	26.09
2	ae47cca0541b69749b687cb246f1dc942734d45d87400e...	APPROVAL	[0002eded-a283-4590-a78c-b6ff2027e684, 2ef99c3...	HP_0001250	CHEMBL940	26.09
3	af0953f786255487c4dc3852c77c7e1e756f21f9e53758...	APPROVAL	[0002eded-a283-4590-a78c-b6ff2027e684, 01aafb0...	MONDO_0005027	CHEMBL940	26.09
4	8b1223c9af56ff52a4603bacc2c591f65124974a5a5407...	APPROVAL	[0003458f-352a-46fa-9d99-230daa76ae29, 07ad436...	MONDO_0005148	CHEMBL1481	26.09

R

In [1]:

library(bedrockbio)

lf <- load_table("open_targets.clinical_indication")
df <- head(lf, 5) |> collect()

head(df)

Out[1]:

Sample output (5 rows, showing 5 of 6 columns)
   id                       | maxClinicalStage | diseaseId     | drugId        | version
   ------------------------ | ---------------- | ------------- | ------------- | -------
0  bcae49c2072f6bce9286dcc… | APPROVAL         | EFO_0000544   | CHEMBL4       | 26.09
1  df2ffa13f012d1eb1938575… | APPROVAL         | MONDO_0008903 | CHEMBL2105741 | 26.09
2  ae47cca0541b69749b687cb… | APPROVAL         | HP_0001250    | CHEMBL940     | 26.09
3  af0953f786255487c4dc385… | APPROVAL         | MONDO_0005027 | CHEMBL940     | 26.09
4  8b1223c9af56ff52a4603ba… | APPROVAL         | MONDO_0005148 | CHEMBL1481    | 26.09

Description

Approved and investigational indications for drug molecules, capturing the maximum clinical stage reached for each drug-disease pair [Drug, Disease]

Partitions

Not partitioned.

Schema

Column	Type	Description
id	TEXT	Unique identifier for the clinical indication
maxClinicalStage	TEXT	Maximum clinical stage reached for this drug-disease indication
clinicalReportIds	TEXT[]	List of clinical report identifiers associated with this indication
diseaseId	TEXT	Open Targets disease identifier
drugId	TEXT	Open Targets molecule identifier
version	TEXT	Open Targets Platform release version (major.minor), e.g. 26.09. Added during ingest.