Companies: pharma companies | Pharma Observatory

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

Companies 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

Companies

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)

Columns 26

Companies columns
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

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

Columns 23

FDA biomarker qualification projects columns
Column	Type	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

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

Columns 17

FDA companion diagnostic assertions columns
Column	Type	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

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

Columns 14

Companies publishing on a biomarker columns
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

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

Columns 27

Biomarker validation ladder columns
Column	Type	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)

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)

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

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

Columns 23

Company funding events columns
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

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

Columns 15

Company funding summary columns
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

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)

Columns 13

Company members columns
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

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)

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.

Targets a company pursues

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)

Columns 11

Targets a company pursues columns
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

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

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

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.

Legal entities

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)

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.

Ownership and control positions

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

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

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

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

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

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

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

Companies

FDA biomarker qualification projects

FDA companion diagnostic assertions

Companies publishing on a biomarker

Biomarker validation ladder

Company assets (approved and marketed drugs)

Company funding events

Company funding summary

Company members

Company programs

Targets a company pursues

Patent-cliff exposure

Institutional holdings (SEC Form 13F)

Legal entities

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