# Companies: pharma companies

The pharma companies commands, with each dataset's columns, units and source credit.

A company: the resolved business that one or more organization records belong to, with the group it currently sits in. The primary organization object type.

Id: A company key, company:<key>. Its group is the current ultimate parent; dated ownership links are in the company_members dataset.

## Commands

| Command | Reads |
| --- | --- |
| pharma companies list | Companies |
| pharma companies get <id> | One company and the datasets reachable from it |
| pharma companies get <id> biomarker-bqp-assertions | FDA biomarker qualification projects |
| pharma companies get <id> biomarker-cdx-assertions | FDA companion diagnostic assertions |
| pharma companies get <id> biomarker-publishing-companies | Companies publishing on a biomarker |
| pharma companies get <id> biomarker-validation | Biomarker validation ladder |
| pharma companies get <id> company-assets | Company assets (approved and marketed drugs) |
| pharma companies get <id> company-funding-events | Company funding events |
| pharma companies get <id> company-funding-summary | Company funding summary |
| pharma companies get <id> company-members | Company members |
| pharma companies get <id> company-programs | Company programs |
| pharma companies get <id> company-targets | Targets a company pursues |
| pharma companies get <id> drug-patent-cliff | Patent-cliff exposure |
| pharma companies get <id> institutional-holdings | Institutional holdings (SEC Form 13F) |
| pharma companies get <id> legal-entities | Legal entities |
| pharma companies get <id> ownership-positions | Ownership and control positions |
| pharma companies get <id> pdufa-dates | FDA decision dates (PDUFA) and catalysts |
| pharma companies get <id> sponsor-recruitment-by-phase | Trial recruitment duration by sponsor and phase |
| pharma companies get <id> sponsor-recruitment-duration | Trial recruitment duration by sponsor |
| pharma companies get <id> sponsor-trial-start-forecast | Trial-start forecast by sponsor |
| pharma companies 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](https://pharmaobservatory.com/cli)

## Companies

**Command**

```sh
pharma companies list
```

The companies object type's primary dataset: one row per company, with its group and whether it has a public page. Firmographics, ownership and financials are their own datasets, reached by company_id.

One row per: company. Key columns: `company_id`. Scope: `--scope company` or `--scope group`.

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

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| company_id | text |  | The company key (company:<key>). |
| company_name | text |  | The company's display name: its own legal entity's name where one is known. |
| name_basis | text |  | Which source supplied the name: gleif_legal_name, edgar_registrant, ror or sponsor_display_name. |
| country | text |  | Country of the company's own legal entity, as the source states it. |
| org_type | text |  | The organization type of the company's representative record: 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. |
| org_kinds | text[] |  | The roles the company's organizations play (Manufacturer, Sponsor and so on). |
| edgar_cik | text |  | Central index key (CIK) in EDGAR, the US Securities and Exchange Commission (SEC) filing system, of the representative record, when it files. |
| edgar_ticker | text |  | Exchange ticker of the representative record, when listed. |
| representative_org_id | text |  | Legal-entity level: the organization record the company's page shows. |
| parent_company_id | text |  | The direct owner company (part_of), null for a root. |
| parent_company_name | text |  | Display name of the direct owner company. |
| part_of_since | date |  | Date the ownership link began, when every hop is dated. |
| part_of_since_precision | text |  | Precision of part_of_since (day, month or year). |
| group_id | text |  | Group level: the current ultimate parent company; a root company's group is itself. Current ownership only; dated links are in company_members. |
| group_name | text |  | Display name of the group. |
| rollup_depth | integer | levels | Hops from this company to its ultimate parent (0 for a root). |
| n_legal_entities | bigint | legal entities | Registered legal entities that are members of the company. |
| n_member_companies | bigint | companies | Companies folded into this one. |
| num_lead_trials | bigint | trials | Trials the company's organizations lead. |
| num_collaborator_trials | bigint | trials | Trials the company's organizations collaborate on. |
| num_trials | bigint | trials | Trials the company's organizations lead or collaborate on. |
| total_lead_enrollment | bigint | 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 (interventional lead trials and enrollment, weighted toward recent). |
| is_admitted | boolean |  | True when the company is admitted to the company roster (lead-trial activity, more than one legal entity or a recorded manufacturer role); false rows carry null firmographic, trial-count and activity columns. |
| has_public_page | boolean |  | True when the company has a public organization page. |

## FDA biomarker qualification projects

**Command**

```sh
pharma companies get <id> biomarker-bqp-assertions
```

Projects in the US Food and Drug Administration (FDA) Biomarker Qualification Program for a biomarker, with the submitter's company and group keys. Only a source status of exactly qualified is FDA-qualified.

One row per: FDA Biomarker Qualification Program assertion for a biomarker. Key columns: `source_assertion_id`. Scope: `--scope company` or `--scope group`.

Source: US FDA

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| source_assertion_id | text |  | The assertion id. |
| route_key | text |  | The biomarker's route key, the entry key for the biomarkers object type. |
| biomarker_id | text |  | The biomarker key. |
| ddt_number | text |  | The drug development tool number the US Food and Drug Administration (FDA) assigns the project. |
| ddt_project_id | text |  | The FDA project id. |
| project_name | text |  | The project's name. |
| bqp_signal | text |  | The source status of the project. Only qualified means FDA-qualified; every other value is a project status. |
| is_fda_qualified | boolean |  | True only when the source status is exactly qualified. |
| submission_status | text |  | The submission status as the source words it. |
| submission_stage | text |  | The submission stage as the source words it. |
| submitter_name | text |  | The submitter as the source names it. |
| submitter_org_id | text |  | Legal-entity level: the organization record the submitter resolved to (null when unresolved). |
| submitter_company_id | text |  | Company level: the company the submitter belongs to (null when unresolved). |
| submitter_company_name | text |  | Display name of the submitter's company. |
| submitter_group_id | text |  | Group level: the submitter's current ultimate parent company; a root company's group is itself. |
| submitter_group_name | text |  | Display name of the submitter's group. |
| submitter_match_tier | text |  | How the submitter name matched an organization record. |
| submitter_role | text |  | The submitter's role on the project. |
| biomarker_role | text |  | The biomarker's role in the project (for example a diagnostic or a surrogate endpoint). |
| biomarker_role_method | text |  | How the biomarker role was assigned. |
| is_surrogate_endpoint_claim | boolean |  | True when the project claims a surrogate endpoint. |
| source_url | text |  | Link to the FDA project page. |
| snapshot_date | date |  | The date the source list was captured. |

## FDA companion diagnostic assertions

**Command**

```sh
pharma companies get <id> biomarker-cdx-assertions
```

Companion diagnostics of the US Food and Drug Administration (FDA) for a biomarker, one row per assertion, with the manufacturer's company and group keys.

One row per: FDA companion diagnostic assertion for a biomarker. Key columns: `source_assertion_id`. Scope: `--scope company` or `--scope group`.

Source: US FDA

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| source_assertion_id | text |  | The assertion id. |
| route_key | text |  | The biomarker's route key, the entry key for the biomarkers object type. |
| biomarker_id | text |  | The biomarker key. |
| biomarker_token | text |  | The biomarker as the FDA list names it. |
| diagnostic_name | text |  | The companion diagnostic's name. |
| indication | text |  | The indication. |
| sample_type | text |  | The sample type. |
| submission_cell | text |  | The submission number cell as listed. |
| latest_stated_decision_date | date |  | Latest decision date the list states. |
| source_url | text |  | Link to the FDA list. |
| manufacturer_name | text |  | The manufacturer as filed. |
| manufacturer_org_id | text |  | Legal-entity level: the organization record the manufacturer resolved to (null when unresolved). |
| manufacturer_company_id | text |  | Company level: the company the manufacturer belongs to (null when unresolved). |
| manufacturer_company_name | text |  | Display name of the manufacturer's company. |
| manufacturer_group_id | text |  | Group level: the manufacturer's current ultimate parent company; a root company's group is itself. |
| manufacturer_group_name | text |  | Display name of the manufacturer's group. |
| manufacturer_match_tier | text |  | How firmly the manufacturer name matched an organization. |

## Companies publishing on a biomarker

**Command**

```sh
pharma companies get <id> biomarker-publishing-companies
```

The companies that publish on a biomarker, one row per biomarker gene and company, counted from paper-level evidence.

One row per: biomarker gene and company. Key columns: `gene_symbol`, `publisher_company_id`. Scope: `--scope company` or `--scope group`.

Source: PubMed, NCBI/NLM

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| route_key | text |  | The biomarker route key of the gene the papers name (the gene symbol); the entry key for the biomarkers object type. |
| gene_symbol | text |  | The gene symbol. |
| publisher_company_id | text |  | Company level: the publisher's company. |
| publisher_company_name | text |  | Display name of the publisher's company. |
| publisher_group_id | text |  | Group level: the publisher's current ultimate parent company; a root company's group is itself. |
| publisher_group_name | text |  | Display name of the publisher's group. |
| n_publications | integer | papers | Papers that name the gene from the company's organizations (a consortium paper is excluded). |
| n_member_orgs | integer | organization records | The company's organizations the papers reach. |
| best_match_tier | text |  | Strongest affiliation match tier. |
| first_pub_year | integer | calendar year | Earliest publication year. |
| last_pub_year | integer | calendar year | Latest publication year. |
| supporting_pmids | text[] |  | A sample of the supporting PubMed ids. |
| supporting_pmids_truncated | boolean |  | True when the sample is shorter than the paper count. |
| n_papers_excluded_as_consortium | integer |  | Papers left out because they name too many organizations. |

## Biomarker validation ladder

**Command**

```sh
pharma companies get <id> biomarker-validation
```

The validation ladder of a gene: which organizations can supply evidence toward running its assay, in what role, at what tier and citing what, across six kinds of evidence (companion diagnostic authorization, trial endpoint, trial eligibility, trial specimen collection, trial text mention and ClinVar clinical testing).

One row per: evidence assertion on a gene. Key columns: `biomarker_validation_id`. Scope: `--scope company` or `--scope group`.

Source: ClinicalTrials.gov via AACT, CTTI (CC BY); US FDA; ClinVar, NCBI/NLM

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| biomarker_validation_id | text |  | The evidence assertion id. |
| route_key | text |  | The biomarker's route key, the entry key for the biomarkers object type; for a gene it is the gene symbol. |
| gene_symbol | text |  | The gene symbol (HGNC, the HUGO Gene Nomenclature Committee). |
| biomarker_id | text |  | The biomarker key. |
| biomarker_display_name | text |  | The biomarker's display name. |
| biomarker_kind | text |  | The kind of biomarker the evidence is filed against. |
| organization_name | text |  | The organization that can supply the evidence, as the source names it (null when the source names none that resolved). |
| organization_org_id | text |  | Legal-entity level: the organization record (null when unresolved). |
| organization_company_id | text |  | Company level: the organization's company (null when unresolved). |
| organization_company_name | text |  | Display name of the organization's company. |
| organization_group_id | text |  | Group level: the organization's current ultimate parent; a root's group is itself. |
| organization_group_name | text |  | Display name of the organization's group. |
| organization_role | text |  | What the organization is to the evidence: lead_sponsor, collaborator, contract_vendor, assay_manufacturer, qualification_submitter, testing_lab or publishing_org. |
| organization_match_tier | text |  | How the organization name matched an organization record. |
| tier | integer |  | The rung on the validation ladder, 1 to 4. A rung is a kind of evidence, never a score: rows are not ranked across organizations or evidence types. |
| tier_label | text |  | The rung's name, for example fda_authorized_companion_diagnostic or named_in_inclusion_criteria. |
| evidence_type | text |  | The evidence lane: fda_bqp_qualification, fda_cdx_authorization, aact_endpoint_role, aact_eligibility_section, aact_biospecimen, trial_mention or clinvar_clinical_testing. |
| evidence_count | integer |  | Sibling rows sharing this biomarker, organization and role. Not the number of source records behind a ClinVar row (clinvar_scv_count). |
| evidence_ref | text |  | The source reference the row cites. |
| evidence_ref_kind | text |  | What kind of reference evidence_ref is. |
| trial_id | text |  | The trial key (an NCT id) when the evidence is a trial; null otherwise. |
| citation_url | text |  | A link to the cited record. |
| citation_verified | boolean |  | False for the FDA Biomarker Qualification Program arm, whose captured links are known to go stale; true otherwise. A link marked false may not resolve. |
| evidence_snippet | text |  | The text span the evidence rests on, where the source gives one. |
| biomarker_role | text |  | The biomarker's role in the evidence, where the source states it. |
| is_surrogate_endpoint_claim | boolean |  | True when the evidence is a claim that the biomarker is a surrogate endpoint. |
| clinvar_scv_count | integer |  | For a ClinVar row, the number of ClinVar submission records the row collapses; null otherwise. |

## Company assets (approved and marketed drugs)

**Command**

```sh
pharma companies 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`. Scope: `--scope company` or `--scope group`.

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

| 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. |
| 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 funding events

**Command**

```sh
pharma companies get <id> company-funding-events
```

Funding events of a company, one row per event (a grant, a Regulation D offering, a registered offering or an extracted financing), with the issuer's company and group keys and the running total of disclosed amounts. Group by round type, year or source for how a company was capitalized.

One row per: funding event. Key columns: `funding_event_id`. Scope: `--scope company` or `--scope group`.

Source: US SEC EDGAR; NIH RePORTER

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| funding_event_id | text |  | The funding event key. |
| issuer_name | text |  | The issuer's name as filed. |
| issuer_org_id | text |  | Legal-entity level: the issuer's organization record. |
| issuer_company_id | text |  | Company level: the issuer's company (null when the issuer did not resolve to a company). |
| issuer_company_name | text |  | Display name of the issuer's company. |
| issuer_group_id | text |  | Group level: the issuer's current ultimate parent company; a root company's group is itself. |
| issuer_group_name | text |  | Display name of the issuer's group. |
| event_date | date |  | The date the source gives for the event; event_stage says what the date means. |
| fiscal_year | integer | fiscal year | The NIH fiscal year, for a grant; null for the other sources. |
| source | text |  | The source lane: reporter (NIH RePORTER grants), form_d (SEC Form D Regulation D offerings), edgar_offerings (SEC registered offerings) or sec_extracted (financings extracted from SEC filings). |
| round_type | text |  | The kind of round (for example grant_nih, sbir, reg_d_private, ipo, follow_on, public_offering, atm, registered_direct, debt). |
| round_subtype | text |  | A finer type, such as the grant activity code, the Regulation D exemption or the SEC form. |
| is_dilutive | boolean |  | Whether the round dilutes existing equity; null where the instrument is not classified. |
| amount_usd | numeric | USD | The disclosed amount in whole US dollars; null where the amount is not disclosed. |
| currency | text |  | The currency the source reports the amount in. |
| amount_is_disclosed | boolean |  | Whether the source states an amount for the event. |
| capital_treatment | text |  | Whether the event's dollars count as capital raised, and if not why not (for example structured_source, actual_inflow, capacity, committed). |
| is_actual_issuer_inflow | boolean |  | True where the event counts as capital the issuer raised. |
| event_stage | text |  | The lifecycle stage the event's date refers to (for example sold_to_date, funded, closed, registered, announced). |
| administering_ic | text |  | The National Institutes of Health institute or center that administers the grant (for example CA for the National Cancer Institute); null for the other sources. |
| n_awards | bigint | awards | Grant applications folded into the event; 1 for the other sources. |
| cumulative_raised_usd | numeric | USD | The running total of disclosed amounts over the company's own events up to and including this one, in date order; null where the event has no company. |
| source_url | text |  | Link to the filing the event was read from, where the source has one. |

## Company funding summary

**Command**

```sh
pharma companies get <id> company-funding-summary
```

One row per company with a funding event, with the round count, the disclosed totals by kind of capital, the first and last funded dates, the latest round and a stage label read from the mix of round types.

One row per: company with at least one funding event. Key columns: `company_id`. Scope: `--scope company` or `--scope group`.

Source: US SEC EDGAR; NIH RePORTER

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| company_id | text |  | The company key (company:<key>). |
| company_name | text |  | Display name of the company. |
| group_id | text |  | Group level: the current ultimate parent company; a root company's group is itself. |
| group_name | text |  | Display name of the group. |
| n_rounds | bigint | events | Funding events of the company, disclosed or not. |
| total_non_dilutive_usd | numeric | USD | Disclosed non-dilutive amounts (grants, debt, royalty and similar), in whole US dollars. |
| total_dilutive_usd | numeric | USD | Disclosed dilutive amounts (equity-issuing rounds), in whole US dollars. |
| total_unclassified_usd | numeric | USD | Disclosed amounts of events whose instrument is not classified, kept apart from the other two totals. |
| n_unclassified_rounds | bigint | events | Events whose instrument is not classified. |
| total_raised_usd | numeric | USD | All disclosed amounts, the sum of the three totals, in whole US dollars. |
| first_funded_date | date |  | Date of the earliest event. |
| last_funded_date | date |  | Date of the latest event. |
| latest_round_type | text |  | The round type of the latest event. |
| latest_round_date | date |  | The date of the latest event. |
| stage_label | text |  | A coarse reading of the round types: public, growth_private, seed_private, unclassified or non_dilutive_only. |

## Company members

**Command**

```sh
pharma companies get <id> company-members
```

The company hierarchy: one row per member link, with the member, its direct owner and its group.

One row per: member link: a legal entity that is a member of a company. Key columns: `company_id`, `legal_entity_id`. Scope: `--scope company` or `--scope group`.

Source: Global Legal Entity Identifier Foundation (GLEIF) (CC0); US SEC EDGAR; Research Organization Registry (ROR) (CC0)

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| company_id | text |  | The company the legal entity is a member of. |
| company_name | text |  | The company's display name. |
| legal_entity_id | text |  | A registry-scoped legal entity id (edgar:, ror:, lei: or rx_provider:). A registration, not an organization record id. |
| link_basis | text |  | The source that placed the legal entity in the company (gleif, edgar, ror, name_key and so on). |
| parent_company_id | text |  | The company's direct owner, null for a root. |
| parent_company_name | text |  | Display name of the direct owner. |
| parent_link_basis | text |  | The authority of the first ownership hop. |
| since | date |  | Date the ownership link began, when every hop is dated. |
| since_precision | text |  | Precision of since. |
| since_source | text |  | Where the date came from. |
| group_id | text |  | Group level: the current ultimate parent; a root's group is itself. |
| group_name | text |  | Display name of the group. |
| hop_depth | integer | levels | Hops from the company to its ultimate parent (0 for a root). |

## Company programs

**Command**

```sh
pharma companies 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`. Scope: `--scope company` or `--scope group`.

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

| 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. |

## Targets a company pursues

**Command**

```sh
pharma companies get <id> company-targets
```

The targets a company pursues, at company grain: a specific indication with at least two trials, with the phase reached.

One row per: company and target. Key columns: `sponsor_company_id`, `target_id`. Scope: `--scope company` or `--scope group`.

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

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| sponsor_company_id | text |  | Company level: the company whose lead-sponsored trials pursue the target. |
| 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_id | text |  | The target's gene identifier (Ensembl). |
| target_symbol | text |  | The target's gene symbol. |
| target_name | text |  | The target's name. |
| max_phase | integer |  | The furthest phase any qualifying program of the company reached against the target. |
| n_drugs | integer | drugs | Distinct drugs of the company's qualifying programs against the target. |
| n_conditions | integer | conditions | Distinct conditions of the company's qualifying programs against the target. |
| n_trials | integer | trials | Distinct trials the company leads in those programs. |

## Patent-cliff exposure

**Command**

```sh
pharma companies 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`. Scope: `--scope company` or `--scope group`.

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

| 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)

**Command**

```sh
pharma companies 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`. Scope: `--scope company` or `--scope group`.

Source: US SEC EDGAR Form 13F

| 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. |

## Legal entities

**Command**

```sh
pharma companies get <id> legal-entities
```

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`. Scope: `--scope company` or `--scope group`.

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

| 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. |

## Ownership and control positions

**Command**

```sh
pharma companies 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`. Scope: `--scope company` or `--scope group`.

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

| 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

**Command**

```sh
pharma companies 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`. Scope: `--scope company` or `--scope group`.

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

| Column | Type | Unit | 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. |

## Trial recruitment duration by sponsor and phase

**Command**

```sh
pharma companies 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`. Scope: `--scope company` or `--scope group`.

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

| 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. |

## Trial recruitment duration by sponsor

**Command**

```sh
pharma companies 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`. Scope: `--scope company` or `--scope group`.

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

| 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. |

## Trial-start forecast by sponsor

**Command**

```sh
pharma companies 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`. Scope: `--scope company` or `--scope group`.

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

| 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. |

## Sponsor trials

**Command**

```sh
pharma companies 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`. Scope: `--scope company` or `--scope group`.

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

| 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. |