Legal entities: pharma legal-entities

An organization record beneath a company: a registered legal entity or a sponsor resolved by name.

Id: An organization record id: a registered legal entity (edgar:..., ror:...) or a name-resolved sponsor (sponsor:...). Sponsor ids are resolved from a filed name, not from a registration, and the legal_entities dataset flags them.

Commands

Legal entities commands
Command	Reads
`pharma legal-entities list`	Legal entities
pharma legal-entities get <id>	One legal entity and the datasets reachable from it
`pharma legal-entities get <id> company-assets`	Company assets (approved and marketed drugs)
`pharma legal-entities get <id> company-programs`	Company programs
`pharma legal-entities get <id> drug-patent-cliff`	Patent-cliff exposure
`pharma legal-entities get <id> institutional-holdings`	Institutional holdings (SEC Form 13F)
`pharma legal-entities get <id> ownership-positions`	Ownership and control positions
`pharma legal-entities get <id> pdufa-dates`	FDA decision dates (PDUFA) and catalysts
`pharma legal-entities get <id> sponsor-recruitment-by-phase`	Trial recruitment duration by sponsor and phase
`pharma legal-entities get <id> sponsor-recruitment-duration`	Trial recruitment duration by sponsor
`pharma legal-entities get <id> sponsor-trial-start-forecast`	Trial-start forecast by sponsor
`pharma legal-entities get <id> sponsor-trials`	Sponsor trials

Every command takes the paging, sorting and output flags described on the CLI page; the CLI prints the source credit with every result.

Pharma Observatory CLI

Legal entities

pharma legal-entities list

The legal_entities object type's primary dataset: every organization record beneath a company, keyed on the organization id.

One row per: organization record (a registered legal entity or a name-resolved sponsor)
Key columns: org_id

Source: Research Organization Registry (ROR) (CC0); Global Legal Entity Identifier Foundation (GLEIF) (CC0); US SEC EDGAR; ClinicalTrials.gov via AACT, CTTI (CC BY)

Columns 20

Legal entities columns
Column	Type	Unit	Description
org_id	text		The organization record id: a registered legal entity (edgar:, ror:) or a name-resolved sponsor (sponsor:).
org_name	text		The organization's name.
is_name_resolved_sponsor	boolean		True for a sponsor resolved from a filed name alone rather than from a registration.
org_origin	text		How the organization record was minted.
country	text		Country as the source states it.
org_type	text		Organization type: Academic, Government, Hospital, Industry, Nonprofit or Other (from the ROR record or the filing), or the lowercase tags investor and manufacturer that mark a minted adviser or manufacturer record.
edgar_cik	text		Central index key (CIK) in EDGAR, the US Securities and Exchange Commission (SEC) filing system, when it files.
edgar_ticker	text		Exchange ticker, when listed.
ror_id	text		Research Organization Registry id, when it has one.
lei	text		Legal Entity Identifier, when it has one.
lifecycle_status	text		Lifecycle status from the registry sources.
num_lead_trials	bigint	trials	Trials the organization leads.
num_trials	bigint	trials	Trials the organization leads or collaborates on.
total_lead_enrollment	numeric	participants	Planned enrollment across led trials.
num_recent_lead_trials	bigint	trials	Led trials started in the recent window.
activity_score	numeric		Trial activity score.
company_id	text		Company level: the company the organization belongs to (null when unresolved).
company_name	text		Display name of the company.
group_id	text		Group level: the company's current ultimate parent; a root's group is itself.
group_name	text		Display name of the group.

Company assets (approved and marketed drugs)

pharma legal-entities get <id> company-assets

Approved and marketed drugs by lead sponsor: one row per sponsor organization and drug, with the sponsor's company and group keys and the trial counts behind the drug.

One row per: lead sponsor organization and approved or marketed drug
Key columns: sponsor_org_id, drug_id

Source: ClinicalTrials.gov via AACT, CTTI (CC BY); ChEMBL, EMBL-EBI (CC BY-SA 3.0)

Columns 13

Company assets (approved and marketed drugs) columns
Column	Type	Description
sponsor_org_id	text	Legal-entity level: the lead sponsor's organization record.
sponsor_name	text	The sponsor's organization name.
sponsor_company_id	text	Company level: the sponsor's company (null when unresolved).
sponsor_company_name	text	Display name of the sponsor's company.
sponsor_group_id	text	Group level: the sponsor's current ultimate parent; a root's group is itself.
sponsor_group_name	text	Display name of the sponsor's group.
drug_id	text	The drug key.
drug_name	text	The drug's name.
max_phase	integer	Highest phase the sponsor reached on the drug: 0 early phase 1 through 6 for phase 4 (marketed); -1 when unstated.
n_trials	bigint	Distinct trials this sponsor leads on the drug. Counted once per trial within the sponsor organization, so it is not additive across a company's organizations.
n_active	bigint	Of those trials, the number recruiting, not yet recruiting, active or enrolling by invitation.
last_year	integer	Latest start year among those trials.
withdrawn	boolean	True when the drug has been withdrawn from the market.

Company programs

pharma legal-entities get <id> company-programs

Development programs by sponsor, with the condition's global burden as a gated column.

One row per: lead sponsor, drug and indication (a development program)
Key columns: sponsor_org_id, drug_id, condition_id

Source: ClinicalTrials.gov via AACT, CTTI (CC BY); IHME Global Burden of Disease 2021 (CC BY-NC 4.0)

Columns 17

Company programs columns
Column	Type	Unit	Description
sponsor_org_id	text		Legal-entity level: the lead sponsor's organization record.
sponsor_name	text		The sponsor's organization name.
sponsor_company_id	text		Company level: the sponsor's company (null when unresolved).
sponsor_company_name	text		Display name of the sponsor's company.
sponsor_group_id	text		Group level: the sponsor's current ultimate parent; a root's group is itself.
sponsor_group_name	text		Display name of the sponsor's group.
drug_id	text		The drug key.
drug_name	text		The drug's name.
condition_id	text		The condition key, a MeSH (Medical Subject Headings) descriptor id (D followed by six to nine digits).
condition_name	text		The condition's name.
max_phase	integer		Highest phase reached: 0 early phase 1 through 6 for phase 4 (marketed); -1 when unstated.
n_trials	bigint	trials	Lead-sponsored trials in the program.
n_active	bigint	trials	Of those, trials in an active status.
last_year	integer	calendar year	Latest trial start year.
withdrawn	boolean		True when the drug has been withdrawn.
lifecycle	text		approved, active or abandoned.
dalys_millions	double	millions of DALYs	Disability-adjusted life years (DALYs, millions) of the condition's global burden, from the Global Burden of Disease (GBD) 2021 study of the Institute for Health Metrics and Evaluation (IHME). Null for a caller without the licence for this column; see withheld_columns.

Patent-cliff exposure

pharma legal-entities get <id> drug-patent-cliff

Drugs whose loss of exclusivity is still in the future, with the brand applicant's company and group keys: the patent-cliff exposure of a company or a drug.

One row per: drug whose exclusivity ends in the future
Key columns: drug_id

Source: FDA Orange Book and Purple Book, USPTO; CMS Medicare Part B and Part D spending; US SEC EDGAR 10-K and 20-F filings

Columns 26

Patent-cliff exposure columns
Column	Type	Unit	Description
drug_id	text		The drug key.
drug_name	text		The drug's name.
pharm_class	text		The drug's pharmacologic class.
atc_class	text		The drug's Anatomical Therapeutic Chemical (ATC) class.
brand	text		The brand name.
candidate_brands	text		Other candidate brand names, comma separated.
cliff_date	date		The date exclusivity is expected to end (loss of exclusivity); always in the future when the dataset is built.
cliff_year	integer	calendar year	The year of cliff_date.
cliff_basis	text		Which regime set the date: curated_loe, orange_book_patent, pte_expiry or bpcia_exclusivity.
cliff_source	text		Source of a curated date (null on the other bases).
cliff_confidence	text		Confidence of a curated date (null on the other bases).
has_generic	boolean		True when a generic is already marketed.
biosimilar_available	boolean		True when a biosimilar is already marketed.
applicant_name	text		The brand or originator applicant as the Orange Book or Purple Book names it.
applicant_org_id	text		Legal-entity level: the organization record the applicant resolved to (null when unresolved).
applicant_company_id	text		Company level: the company the applicant belongs to (null when unresolved).
applicant_company_name	text		Display name of the applicant's company.
applicant_group_id	text		Group level: the applicant's current ultimate parent company; a root company's group is itself.
applicant_group_name	text		Display name of the applicant's group.
applicant_match_scope	text		How the applicant name matched an organization record.
medicare_spend	numeric	US dollars	Latest-year Medicare Part B and D spend for the drug, in US dollars.
medicare_spend_year	integer	calendar year	The year of medicare_spend.
disclosed_revenue_usd_millions	numeric	US millions of dollars	Latest full-year disclosed worldwide revenue, in US millions.
disclosed_revenue_year	integer	fiscal year	The fiscal year of the disclosed revenue.
size_usd	numeric	US dollars	The single size axis in US dollars: disclosed revenue when present, else Medicare spend.
size_basis	text		Which source size_usd used: disclosed_worldwide_revenue, medicare_spend or none.

Institutional holdings (SEC Form 13F)

pharma legal-entities get <id> institutional-holdings

Which institutions hold a company: the holdings institutional managers report on Form 13F, the quarterly report filed with the US Securities and Exchange Commission (SEC), with company and group keys for issuer and holder.

One row per: institutional manager and issuer security (current standing position)
Key columns: holding_id

Source: US SEC EDGAR Form 13F

Columns 25

Institutional holdings (SEC Form 13F) columns
Column	Type	Unit	Description
holding_id	text		The holding line id.
issuer_name	text		The security issuer as filed.
issuer_org_id	text		Legal-entity level: the issuer's organization record (null when unresolved).
issuer_company_id	text		Company level: the issuer's company (null when unresolved).
issuer_company_name	text		Display name of the issuer's company.
issuer_group_id	text		Group level: the issuer's current ultimate parent; a root's group is itself.
issuer_group_name	text		Display name of the issuer's group.
security_ref	text		The security's CUSIP (Committee on Uniform Securities Identification Procedures) identifier.
holder_name	text		The institutional manager's name.
holder_identity_key	text		The institutional manager's stable identity (an SEC registration number), the key that groups all of one manager's holdings.
holder_kind	text		Manager kind.
holder_org_id	text		Legal-entity level: the manager's organization record (null when unresolved).
holder_company_id	text		Company level: the manager's company (null when unresolved).
holder_company_name	text		Display name of the manager's company.
holder_group_id	text		Group level: the manager's current ultimate parent.
holder_group_name	text		Display name of the manager's group.
reported_value_amount	numeric		Reported value of the position.
reported_value_currency	text		Currency of the reported value.
shares	numeric	shares	Shares standing.
percent_basis	text		The basis the percent is measured on.
reported_percent	numeric		Reported share of the issuer.
edge_state	text		State of the position (standing, ceased, no longer reported).
first_observed_date	date		First filing date the position was observed.
last_filing_date	date		Latest filing date the position was reported.
contains_personal_data	boolean		Whether the holder is a natural person.

Ownership and control positions

pharma legal-entities get <id> ownership-positions

Who is reported to own or control a company: one row per owner and filing family, from insider reports (Forms 3, 4 and 5), beneficial-owner schedules (13D and 13G), investment adviser control persons (Form ADV) and proxy-statement tables (DEF 14A), with company and group keys for the owned company and the owner. Institutional managers filing Form 13F are the institutional_holdings dataset.

One row per: owner, owned company, filing family and measured dimension (the owner's consolidated current position)
Key columns: position_id

Source: US SEC EDGAR; US SEC Investment Adviser Public Disclosure

Columns 42

Ownership and control positions columns
Column	Type	Unit	Description
position_id	text		The position id. For a position whose owner name is withheld it is an opaque handle that derives nothing from the owner and is stable only while the other positions of the same owned company, filing family and dimension are unchanged.
source_class	text		The filing family: sec_forms_3_4_5 (insiders), sec_schedules_13d_g (beneficial owners), sec_form_adv (investment adviser control persons) or sec_def_14a (proxy-statement tables).
ownership_dimension	text		What the position measures: insider_reporting, beneficial_ownership, voting_power, economic_interest or control. Positions of different dimensions are different measurements and are not added.
relationship_type	text		The owner's relationship to the company as the filing family states it.
subject_name	text		The owned company as filed.
subject_org_id	text		Legal-entity level: the owned company's organization record.
subject_company_id	text		Company level: the owned company (null when unresolved).
subject_company_name	text		Display name of the owned company.
subject_group_id	text		Group level: the owned company's current ultimate parent; a root's group is itself.
subject_group_name	text		Display name of the owned company's group.
owner_name	text		The owner's name as filed. Null for an owner whose filing does not mark the name public (see owner_name_is_public).
owner_name_is_public	boolean		True when the filing marks the owner's name public. When false every column that could identify the owner is null (name, identity key, person id, investor id, organization and company columns, source_url and the dates); the position and its figures stay.
owner_kind	text		What the owner is: organization, natural_person, reporting_group or unknown.
owner_identity_key	text		The owner's stable identity (an SEC registration number or an adviser registration number); null when the name is withheld.
owner_person_id	text		The key of an owner who is a natural person; null for other owners and when the name is withheld.
owner_investor_id	text		The key of the owner in the investor directory when it is one; null when the name is withheld.
owner_org_id	text		Legal-entity level: the owner's organization record (null when the owner is not an organization, is unresolved or is withheld).
owner_company_id	text		Company level: the owner's company (null when unresolved or when the name is withheld).
owner_company_name	text		Display name of the owner's company.
owner_group_id	text		Group level: the owner's current ultimate parent; a root's group is itself (null when the owner is withheld).
owner_group_name	text		Display name of the owner's group.
shares_basis	text		How the share figure was reached: sum_standing_balances (insider balances), group_reported_maximum (a joint filing's maximum, never a sum of its filers) or no_quantity (the source gives none). Read a share figure with its basis.
shares	numeric	shares	Shares the owner holds, on the shares_basis. Null when the source gives no quantity.
shares_direct	numeric	shares	Of those shares, the part held directly.
shares_indirect	numeric	shares	Of those shares, the part held indirectly.
derivative_underlying_shares	numeric	shares	Shares underlying derivative positions such as options, reported apart and never added to shares.
percent_basis	text		How the percentage was reached, for example single_reporting_person, uniform_group_percent or single_band.
reported_percent	numeric	percent	The percentage the filing reports, on the percentage_basis.
reported_percent_low	numeric	percent	The low end of a reported band, for a source that reports a band.
reported_percent_high	numeric	percent	The high end of a reported band, for a source that reports a band.
percentage_basis	text		What the percentage is of: beneficial_ownership, voting_power or economic_interest. Percentages of different bases are not comparable.
edge_state	text		standing, ceased or no_longer_reported, for the owner's position as a whole.
position_count	integer		Positions the row consolidates.
standing_position_count	integer		Of those, positions still standing.
ceased_position_count	integer		Of those, positions reported ceased.
no_longer_reported_position_count	integer		Of those, positions the filer no longer reports.
first_observed_date	date		Date the position was first reported; null when the owner's name is withheld.
last_activity_date	date		Date of the latest reported activity; null when the owner's name is withheld.
last_filing_date	date		Date of the latest filing; null when the owner's name is withheld.
source_url	text		A link to the latest filing; null when the owner's name is withheld, because the filing names the owner.
contains_personal_data	boolean		True when the row names a natural person.
privacy_status	text		The filing's privacy status for the owner: not_applicable, pending_review, approved_public_fields, restricted or protected.

FDA decision dates (PDUFA) and catalysts

pharma legal-entities get <id> pdufa-dates

Decision dates and catalysts of the US Food and Drug Administration (FDA), entered from a company, a legal entity, a drug or a condition.

One row per: calendar entry
Key columns: pdufa_date_id

Source: Benzinga FDA / PDUFA calendar (Licensed data; not for redistribution); US SEC EDGAR

Columns 25

FDA decision dates (PDUFA) and catalysts columns
Column	Type	Description
pdufa_date_id	text	The calendar entry id.
source	text	Which lane the row came from: benzinga, sec_extraction or both.
restriction_tier	text	none for a row from SEC filings; licensable for a row from the Benzinga calendar (the filings are those made to the US Securities and Exchange Commission).
decision_date	date	The decision date of the US Food and Drug Administration (FDA); a PDUFA date is the goal date under the Prescription Drug User Fee Act.
date_start	date	Start of the date interval the source states.
date_end	date	End of the date interval the source states.
date_precision	text	Precision of the date (day, month, quarter).
date_phrase	text	The date as the source words it.
event_type	text	Event type.
event_category	text	Event category (pdufa, adcomm and so on).
drug_name	text	The drug name as filed.
drug_id	text	The drug key.
molecule_id	text	The molecule key.
sponsor_name	text	The sponsor name as filed.
sponsor_org_id	text	Legal-entity level: the organization record the sponsor resolved to (null when unresolved).
sponsor_company_id	text	Company level: the company the sponsor belongs to (null when unresolved).
sponsor_company_name	text	Display name of the sponsor's company.
sponsor_group_id	text	Group level: the sponsor's current ultimate parent company; a root company's group is itself.
sponsor_group_name	text	Display name of the sponsor's group.
ticker	text	Exchange ticker.
condition_id	text	The condition key.
condition_name	text	The condition's name.
indication_text	text	The indication as the source words it.
source_type	text	Kind of source document.
source_link	text	Link to the source document.

pharma legal-entities get <id> sponsor-recruitment-by-phase

The recruitment duration of an organization's trials by phase bucket, with the prediction error the backtest measured for that bucket.

One row per: organization record and phase bucket
Key columns: sponsor_org_id, phase_bucket

Source: ClinicalTrials.gov via AACT, CTTI (CC BY)

Columns 21

Trial recruitment duration by sponsor and phase columns
Column	Type	Unit	Description
sponsor_org_id	text		Legal-entity level: the organization record the series is for (the lead sponsor).
sponsor_name	text		Display name of the organization record.
sponsor_company_id	text		Company level: the company the organization belongs to (null when unresolved).
sponsor_company_name	text		Display name of the sponsor's company.
sponsor_group_id	text		Group level: the sponsor's current ultimate parent company; a root company's group is itself.
sponsor_group_name	text		Display name of the sponsor's group.
phase_bucket	text		The phase bucket of the trial (one vocabulary for predicted and realized rows).
n_predicted_open	integer		Per phase bucket, the same count as the series column of that name.
n_predicted_at_cap	integer		Per phase bucket, the same count as the series column of that name.
n_predicted_overdue	integer		Per phase bucket, the same count as the series column of that name.
predicted_months_median	numeric	months	Median over the bucket's rows; NULL under min_n.
baseline_months_median	numeric	months	Median over the bucket's rows; NULL under min_n.
n_realized	integer		Per phase bucket, the same count as the series column of that name.
realized_months_median	numeric	months	Median over the bucket's rows; NULL under min_n.
error_phase_mae_months	numeric	months	Backtest mean absolute error in months for this phase bucket; NULL on an unmeasured bucket or one with no open predicted trial.
error_phase_relmae_vs_baseline	numeric		The model's mean absolute error (MAE) over the baseline's MAE in this phase bucket.
error_phase_baseline_mae_months	numeric	months	The baseline's mean absolute error (MAE) in months in this phase bucket.
error_phase_n_trials	integer		Backtest trials behind the phase figure.
error_phase_n_years	integer		Backtest years behind the phase figure.
min_n	integer		The floor applied: a median is withheld below this many trials, carried so a reader sees the floor used.
training_cutoff	date		The date the model's training data ends.

pharma legal-entities get <id> sponsor-recruitment-duration

How long an organization's trials take to recruit: predicted months for trials still open and registered months for finished ones, each median withheld under the floor.

One row per: organization record (the lead sponsor of its trials)
Key columns: sponsor_org_id

Source: ClinicalTrials.gov via AACT, CTTI (CC BY)

Columns 39

Trial recruitment duration by sponsor columns
Column	Type	Unit	Description
sponsor_org_id	text		Legal-entity level: the organization record the series is for (the lead sponsor).
sponsor_name	text		Display name of the organization record.
sponsor_company_id	text		Company level: the company the organization belongs to (null when unresolved).
sponsor_company_name	text		Display name of the sponsor's company.
sponsor_group_id	text		Group level: the sponsor's current ultimate parent company; a root company's group is itself.
sponsor_group_name	text		Display name of the sponsor's group.
n_trials_in_series	integer		Trials the organization leads.
n_evaluated	integer		Of those, trials with a row in the per-trial predictions at the cutoff.
n_not_evaluated	integer		n_trials_in_series - n_evaluated: registered after the cutoff or a coverage gap; the data cannot tell which.
n_out_of_population	integer		Evaluated trials with prediction_status out_of_population.
n_completed	integer		Evaluated trials with prediction_status completed.
n_stopped	integer		Evaluated trials with prediction_status stopped.
n_no_registration_record	integer		Evaluated trials with prediction_status no_registration_record.
n_retrospective_registration	integer		Evaluated trials with prediction_status retrospective_registration.
n_start_not_actual	integer		Evaluated trials with prediction_status start_not_actual.
n_fit_failed	integer		Evaluated trials with prediction_status fit_failed.
n_predicted	integer		Evaluated trials with prediction_status predicted, superseded or not.
n_predicted_superseded	integer		Predicted trials whose CURRENT record shows the outcome (COMPLETED, TERMINATED, WITHDRAWN or an ACTUAL primary completion); kept out of every predicted figure.
n_predicted_open	integer		n_predicted - n_predicted_superseded; the denominator of every predicted figure.
n_predicted_at_cap	integer		Open predicted trials whose figure sits at the horizon cap (an at-cap row contributes the cap to the median).
n_predicted_overdue	integer		Open predicted trials running past their predicted end at the cutoff.
n_predicted_error_measured	integer		Open predicted trials in a phase bucket the backtest measured (error_phase_mae_months not null).
predicted_months_median	numeric	months	Median of the carried predicted months over open predicted trials (capped at horizon_cap_months). NULL under min_n.
predicted_months_p25	numeric	months	25th percentile, same rows and floor.
predicted_months_p75	numeric	months	75th percentile, same rows and floor.
baseline_months_median	numeric	months	Median of the carried baseline months over the same open predicted trials. NULL under min_n.
n_realized	integer		Trials with a registered span (primary completion typed ACTUAL today, plausible start and completion), from the realized-duration input.
realized_months_median	numeric	months	Median registered start to primary completion in months over n_realized trials. NULL under min_n.
realized_months_p25	numeric	months	25th percentile, same rows and floor.
realized_months_p75	numeric	months	75th percentile, same rows and floor.
n_realized_over_cap	integer		Realized spans above horizon_cap_months, so a reader sees how many would have hit the cap.
min_n	integer		The floor applied: a median is withheld below this many trials, carried so a reader sees the floor used.
rollup_status	text		rolled_up (open predicted >= min_n), below_floor (1 <= open < min_n, counts only), none_predicted (evaluated, no open prediction), none_evaluated.
realized_status	text		rolled_up (n_realized >= min_n), below_floor, or none.
training_cutoff	date		The date the model's training data ends.
model_name	text		The recruitment-duration model.
model_version	text		The model version.
horizon_cap_months	integer	months	The cap on predicted months (36 today), from the prediction rows.
method	text		The run's method sentence from the run provenance, never re-authored.

pharma legal-entities get <id> sponsor-trial-start-forecast

The forecast of how many trials an organization will start in each coming year, with the measured backtest error beside every figure.

One row per: organization record and target year
Key columns: sponsor_org_id, target_year

Source: ClinicalTrials.gov via AACT, CTTI (CC BY)

Columns 27

Trial-start forecast by sponsor columns
Column	Type	Unit	Description
sponsor_org_id	text		Legal-entity level: the organization record the forecast series is for.
sponsor_name	text		Display name of the organization record.
sponsor_company_id	text		Company level: the company the organization belongs to (null when unresolved).
sponsor_company_name	text		Display name of the sponsor's company.
sponsor_group_id	text		Group level: the sponsor's current ultimate parent company; a root company's group is itself.
sponsor_group_name	text		Display name of the sponsor's group.
target_year	integer	calendar year	The calendar year forecast.
horizon_offset	integer		Years ahead of the build year (0 is the current year).
months_observed	integer	months	Months of the target year already observed.
months_forecast	integer	months	Months of the target year forecast.
input_observed_through_cutoff	integer		Trials started in the target year up to the training cutoff.
input_planned_remaining	integer		Trials registered as planned to start in the rest of the target year.
forecast_point	numeric	trial starts	The forecast trial starts for the whole target year. A forecast of the eventual count, never an actual count, and it carries no interval.
forecast_status	text		The series' forecast status.
input_trials_window_60m	integer		Trials the organization started in the last 60 months.
input_starts_per_year_60m	numeric	trial starts per year	Average trial starts per year over the last 60 months.
size_bucket	text		The series size bucket the backtest error is measured in.
backtest_horizon	text		The horizon the backtest error was measured at.
backtest_smape_pct	numeric	percent	Backtest symmetric mean absolute percentage error.
backtest_rel_bias	numeric		Backtest relative bias.
backtest_relmae_vs_snaive	numeric		Backtest mean absolute error relative to the seasonal naive baseline.
backtest_n_series	integer		Series the backtest covered.
backtest_ref	text		The backtest run reference.
model_name	text		The forecasting model.
model_version	text		The model version.
training_cutoff	date		The date the model's training data ends.
method	text		How the forecast was produced.

pharma legal-entities get <id> sponsor-trials

Which trials a sponsor runs, one row per trial and sponsor, so group-by phase and year answers the sponsor-pipeline question.

One row per: trial and sponsor as filed (lead sponsor or collaborator)
Key columns: trial_id, sponsor_role, sponsor_name

Source: ClinicalTrials.gov via AACT, CTTI (CC BY)

Columns 22

Sponsor trials columns
Column	Type	Unit	Description
trial_id	text		The trial's ClinicalTrials.gov registry id (NCT, National Clinical Trial, number).
sponsor_role	text		lead or collaborator.
sponsor_name	text		The sponsor name as filed.
sponsor_org_id	text		Legal-entity level: the organization record the sponsor resolved to (null when unresolved).
sponsor_company_id	text		Company level: the company the sponsor belongs to (null when unresolved).
sponsor_company_name	text		Display name of the sponsor's company.
sponsor_group_id	text		Group level: the sponsor's current ultimate parent company; a root company's group is itself.
sponsor_group_name	text		Display name of the sponsor's group.
sponsor_agency_class	text		The funder class the registry declared for the sponsor (INDUSTRY, NIH, FED, OTHER_GOV, NETWORK, OTHER, INDIV, AMBIG, UNKNOWN). UNKNOWN is the registry's own code for a class it does not state.
sponsor_resolution_method	text		How the sponsor name was resolved to an organization record.
trial_title	text		The trial's brief title.
study_type	text		INTERVENTIONAL or OBSERVATIONAL.
phase	text		The registry's phase code (PHASE1, PHASE2, PHASE2/PHASE3, NA and so on). Null when the registry gives no phase (observational and expanded-access trials); phase_label carries the display label for those.
phase_label	text		The trial phase as a display label (Phase 2, Phase 3, Observational, Not applicable, Expanded access, Unknown). The same trial's phase column holds the registry code.
overall_status	text		The registry's overall status.
start_date	date		Trial start date.
start_year	integer	calendar year	Year of the trial start.
primary_completion_date	date		Primary completion date.
enrollment	integer	participants	Enrollment as registered.
were_results_reported	boolean		Whether results are posted.
conditions	text[]		Conditions studied, as registered.
interventions	text[]		Interventions, as registered.

Markdown copy of this page

Commands

Legal entities

Company assets (approved and marketed drugs)

Company programs

Patent-cliff exposure

Institutional holdings (SEC Form 13F)

Ownership and control positions

FDA decision dates (PDUFA) and catalysts

Trial recruitment duration by sponsor and phase

Trial recruitment duration by sponsor

Trial-start forecast by sponsor

Sponsor trials