Biomedical Data Dictionary | The Data Developers

Data dictionary

Schema Reference

Every data product ships with typed tables, lineage fields, bridge keys, and source authority metadata.

Regulatory

FDA Drug Approval & Submission Intelligence

Table	Column	Type	Description
fda_drug_approval_submission_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
fda_drug_approval_submission_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
fda_drug_approval_submission_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
fda_drug_approval_submission_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
fda_drug_approval_submission_intelligence_facts	application_number	STRING	NDA, ANDA, or BLA number normalized for regulatory joins.

Regulatory

FDA Structured Drug Label Intelligence

View full schema →

Table	Column	Type	Description
fda_structured_drug_label_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
fda_structured_drug_label_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
fda_structured_drug_label_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
fda_structured_drug_label_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
fda_structured_drug_label_intelligence_facts	application_number	STRING	NDA, ANDA, or BLA number normalized for regulatory joins.

Regulatory

FDA Drug Label Historical Archive

View full schema →

Table	Column	Type	Description
fda_drug_label_historical_archive_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
fda_drug_label_historical_archive_facts	source_record_id	STRING	Native identifier from the official source authority.
fda_drug_label_historical_archive_facts	source_authority	STRING	Official public source from which the row was ingested.
fda_drug_label_historical_archive_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
fda_drug_label_historical_archive_facts	application_number	STRING	NDA, ANDA, or BLA number normalized for regulatory joins.

Regulatory

FDA Adverse Event Signal Intelligence (FAERS)

View full schema →

Table	Column	Type	Description
fda_adverse_event_signal_intelligence_faers_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
fda_adverse_event_signal_intelligence_faers_facts	source_record_id	STRING	Native identifier from the official source authority.
fda_adverse_event_signal_intelligence_faers_facts	source_authority	STRING	Official public source from which the row was ingested.
fda_adverse_event_signal_intelligence_faers_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
fda_adverse_event_signal_intelligence_faers_facts	case_id	STRING	Primary FAERS case identifier used across linked safety tables.

Regulatory

FDA Approved Biologics Registry

View full schema →

Table	Column	Type	Description
fda_approved_biologics_registry_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
fda_approved_biologics_registry_facts	source_record_id	STRING	Native identifier from the official source authority.
fda_approved_biologics_registry_facts	source_authority	STRING	Official public source from which the row was ingested.
fda_approved_biologics_registry_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
fda_approved_biologics_registry_facts	application_number	STRING	NDA, ANDA, or BLA number normalized for regulatory joins.

Regulatory

FDA Small Molecule Approval Registry

View full schema →

Table	Column	Type	Description
fda_small_molecule_approval_registry_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
fda_small_molecule_approval_registry_facts	source_record_id	STRING	Native identifier from the official source authority.
fda_small_molecule_approval_registry_facts	source_authority	STRING	Official public source from which the row was ingested.
fda_small_molecule_approval_registry_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
fda_small_molecule_approval_registry_facts	application_number	STRING	NDA, ANDA, or BLA number normalized for regulatory joins.

Regulatory

FDA Risk Evaluation & Mitigation (REMS) Registry

View full schema →

Table	Column	Type	Description
fda_risk_evaluation_mitigation_rems_registry_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
fda_risk_evaluation_mitigation_rems_registry_facts	source_record_id	STRING	Native identifier from the official source authority.
fda_risk_evaluation_mitigation_rems_registry_facts	source_authority	STRING	Official public source from which the row was ingested.
fda_risk_evaluation_mitigation_rems_registry_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
fda_risk_evaluation_mitigation_rems_registry_facts	application_number	STRING	NDA, ANDA, or BLA number normalized for regulatory joins.

Regulatory

FDA National Drug Code Intelligence

View full schema →

Table	Column	Type	Description
fda_national_drug_code_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
fda_national_drug_code_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
fda_national_drug_code_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
fda_national_drug_code_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
fda_national_drug_code_intelligence_facts	application_number	STRING	NDA, ANDA, or BLA number normalized for regulatory joins.

Regulatory

DailyMed Pharmaceutical Label Intelligence

View full schema →

Table	Column	Type	Description
dailymed_pharmaceutical_label_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
dailymed_pharmaceutical_label_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
dailymed_pharmaceutical_label_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
dailymed_pharmaceutical_label_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
dailymed_pharmaceutical_label_intelligence_facts	application_number	STRING	NDA, ANDA, or BLA number normalized for regulatory joins.

Clinical

Clinical Trial Intelligence (ClinicalTrials.gov)

View full schema →

Table	Column	Type	Description
clinical_trial_intelligence_clinicaltrials_gov_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
clinical_trial_intelligence_clinicaltrials_gov_facts	source_record_id	STRING	Native identifier from the official source authority.
clinical_trial_intelligence_clinicaltrials_gov_facts	source_authority	STRING	Official public source from which the row was ingested.
clinical_trial_intelligence_clinicaltrials_gov_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
clinical_trial_intelligence_clinicaltrials_gov_facts	nct_id	STRING	ClinicalTrials.gov NCT identifier where the product maps to a trial.

Clinical

NIH Research Funding Intelligence

View full schema →

Table	Column	Type	Description
nih_research_funding_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
nih_research_funding_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
nih_research_funding_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
nih_research_funding_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
nih_research_funding_intelligence_facts	nct_id	STRING	ClinicalTrials.gov NCT identifier where the product maps to a trial.

Clinical

NIH Historical Funding Archive

View full schema →

Table	Column	Type	Description
nih_historical_funding_archive_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
nih_historical_funding_archive_facts	source_record_id	STRING	Native identifier from the official source authority.
nih_historical_funding_archive_facts	source_authority	STRING	Official public source from which the row was ingested.
nih_historical_funding_archive_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
nih_historical_funding_archive_facts	nct_id	STRING	ClinicalTrials.gov NCT identifier where the product maps to a trial.

Clinical

EMA European Drug Authorization Intelligence

View full schema →

Table	Column	Type	Description
ema_european_drug_authorization_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
ema_european_drug_authorization_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
ema_european_drug_authorization_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
ema_european_drug_authorization_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
ema_european_drug_authorization_intelligence_facts	nct_id	STRING	ClinicalTrials.gov NCT identifier where the product maps to a trial.

Safety & Pharmacovigilance

FAERS Adverse Event Demographics Intelligence

View full schema →

Table	Column	Type	Description
faers_adverse_event_demographics_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
faers_adverse_event_demographics_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
faers_adverse_event_demographics_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
faers_adverse_event_demographics_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
faers_adverse_event_demographics_intelligence_facts	case_id	STRING	Primary FAERS case identifier used across linked safety tables.

Safety & Pharmacovigilance

FAERS Drug-Reaction Signal Intelligence

View full schema →

Table	Column	Type	Description
faers_drug_reaction_signal_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
faers_drug_reaction_signal_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
faers_drug_reaction_signal_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
faers_drug_reaction_signal_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
faers_drug_reaction_signal_intelligence_facts	case_id	STRING	Primary FAERS case identifier used across linked safety tables.

Financial & Market Access

Medicare Part D Drug Spending Intelligence

View full schema →

Table	Column	Type	Description
medicare_part_d_drug_spending_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
medicare_part_d_drug_spending_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
medicare_part_d_drug_spending_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
medicare_part_d_drug_spending_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
medicare_part_d_drug_spending_intelligence_facts	spend_year	INT64	Calendar or payment year for the spending observation.

Financial & Market Access

Medicare Part B Drug Spending Intelligence

View full schema →

Table	Column	Type	Description
medicare_part_b_drug_spending_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
medicare_part_b_drug_spending_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
medicare_part_b_drug_spending_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
medicare_part_b_drug_spending_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
medicare_part_b_drug_spending_intelligence_facts	spend_year	INT64	Calendar or payment year for the spending observation.

Financial & Market Access

Medicaid Drug Spending Intelligence

View full schema →

Table	Column	Type	Description
medicaid_drug_spending_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
medicaid_drug_spending_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
medicaid_drug_spending_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
medicaid_drug_spending_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
medicaid_drug_spending_intelligence_facts	spend_year	INT64	Calendar or payment year for the spending observation.

Financial & Market Access

CMS IRA Maximum Fair Price Intelligence

View full schema →

Table	Column	Type	Description
cms_ira_maximum_fair_price_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
cms_ira_maximum_fair_price_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
cms_ira_maximum_fair_price_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
cms_ira_maximum_fair_price_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
cms_ira_maximum_fair_price_intelligence_facts	spend_year	INT64	Calendar or payment year for the spending observation.

Financial & Market Access

Medicare Part B ASP Pricing Intelligence

View full schema →

Table	Column	Type	Description
medicare_part_b_asp_pricing_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
medicare_part_b_asp_pricing_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
medicare_part_b_asp_pricing_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
medicare_part_b_asp_pricing_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
medicare_part_b_asp_pricing_intelligence_facts	spend_year	INT64	Calendar or payment year for the spending observation.

Financial & Market Access

National Drug Acquisition Cost Intelligence (NADAC)

View full schema →

Table	Column	Type	Description
national_drug_acquisition_cost_intelligence_nadac_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
national_drug_acquisition_cost_intelligence_nadac_facts	source_record_id	STRING	Native identifier from the official source authority.
national_drug_acquisition_cost_intelligence_nadac_facts	source_authority	STRING	Official public source from which the row was ingested.
national_drug_acquisition_cost_intelligence_nadac_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
national_drug_acquisition_cost_intelligence_nadac_facts	spend_year	INT64	Calendar or payment year for the spending observation.

Financial & Market Access

CMS HCPCS-NDC Crosswalk Intelligence

View full schema →

Table	Column	Type	Description
cms_hcpcs_ndc_crosswalk_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
cms_hcpcs_ndc_crosswalk_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
cms_hcpcs_ndc_crosswalk_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
cms_hcpcs_ndc_crosswalk_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
cms_hcpcs_ndc_crosswalk_intelligence_facts	spend_year	INT64	Calendar or payment year for the spending observation.

Financial & Market Access

CMS OPPS Reference Intelligence

View full schema →

Table	Column	Type	Description
cms_opps_reference_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
cms_opps_reference_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
cms_opps_reference_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
cms_opps_reference_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
cms_opps_reference_intelligence_facts	spend_year	INT64	Calendar or payment year for the spending observation.

Financial & Market Access

Physician & Industry Open Payments Intelligence

View full schema →

Table	Column	Type	Description
physician_industry_open_payments_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
physician_industry_open_payments_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
physician_industry_open_payments_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
physician_industry_open_payments_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
physician_industry_open_payments_intelligence_facts	spend_year	INT64	Calendar or payment year for the spending observation.

IP & Patent

USPTO Patent Intelligence

View full schema →

Table	Column	Type	Description
uspto_patent_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
uspto_patent_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
uspto_patent_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
uspto_patent_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
uspto_patent_intelligence_facts	patent_number	STRING	Patent identifier normalized for FDA and USPTO joins.

IP & Patent

FDA Orange Book Patent Intelligence

View full schema →

Table	Column	Type	Description
fda_orange_book_patent_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
fda_orange_book_patent_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
fda_orange_book_patent_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
fda_orange_book_patent_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
fda_orange_book_patent_intelligence_facts	patent_number	STRING	Patent identifier normalized for FDA and USPTO joins.

IP & Patent

FDA Orange Book Exclusivity Intelligence

View full schema →

Table	Column	Type	Description
fda_orange_book_exclusivity_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
fda_orange_book_exclusivity_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
fda_orange_book_exclusivity_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
fda_orange_book_exclusivity_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
fda_orange_book_exclusivity_intelligence_facts	patent_number	STRING	Patent identifier normalized for FDA and USPTO joins.

Scientific

Protein Target Intelligence (Swiss-Prot)

View full schema →

Table	Column	Type	Description
protein_target_intelligence_swiss_prot_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
protein_target_intelligence_swiss_prot_facts	source_record_id	STRING	Native identifier from the official source authority.
protein_target_intelligence_swiss_prot_facts	source_authority	STRING	Official public source from which the row was ingested.
protein_target_intelligence_swiss_prot_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
protein_target_intelligence_swiss_prot_facts	target_uniprot_id	STRING	Canonical UniProt accession for protein target joins.

Scientific

Drug-Target Bioactivity Intelligence (ChEMBL)

View full schema →

Table	Column	Type	Description
drug_target_bioactivity_intelligence_chembl_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
drug_target_bioactivity_intelligence_chembl_facts	source_record_id	STRING	Native identifier from the official source authority.
drug_target_bioactivity_intelligence_chembl_facts	source_authority	STRING	Official public source from which the row was ingested.
drug_target_bioactivity_intelligence_chembl_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
drug_target_bioactivity_intelligence_chembl_facts	target_uniprot_id	STRING	Canonical UniProt accession for protein target joins.

Scientific

Protein Cross-Reference Intelligence (UniProt)

View full schema →

Table	Column	Type	Description
protein_cross_reference_intelligence_uniprot_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
protein_cross_reference_intelligence_uniprot_facts	source_record_id	STRING	Native identifier from the official source authority.
protein_cross_reference_intelligence_uniprot_facts	source_authority	STRING	Official public source from which the row was ingested.
protein_cross_reference_intelligence_uniprot_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
protein_cross_reference_intelligence_uniprot_facts	target_uniprot_id	STRING	Canonical UniProt accession for protein target joins.

Scientific

PubChem Chemical Intelligence

View full schema →

Table	Column	Type	Description
pubchem_chemical_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
pubchem_chemical_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
pubchem_chemical_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
pubchem_chemical_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
pubchem_chemical_intelligence_facts	target_uniprot_id	STRING	Canonical UniProt accession for protein target joins.

Scientific

PubChem Bioassay Intelligence

View full schema →

Table	Column	Type	Description
pubchem_bioassay_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
pubchem_bioassay_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
pubchem_bioassay_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
pubchem_bioassay_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
pubchem_bioassay_intelligence_facts	target_uniprot_id	STRING	Canonical UniProt accession for protein target joins.

Literature

PubMed Biomedical Literature Intelligence

View full schema →

Table	Column	Type	Description
pubmed_biomedical_literature_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
pubmed_biomedical_literature_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
pubmed_biomedical_literature_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
pubmed_biomedical_literature_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
pubmed_biomedical_literature_intelligence_facts	pmid	STRING	PubMed identifier for publication-level joins.

Literature

PubMed Central Full-Text Intelligence

View full schema →

Table	Column	Type	Description
pubmed_central_full_text_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
pubmed_central_full_text_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
pubmed_central_full_text_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
pubmed_central_full_text_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
pubmed_central_full_text_intelligence_facts	pmid	STRING	PubMed identifier for publication-level joins.

Disease & Ontology

MeSH Disease & Topic Intelligence

View full schema →

Table	Column	Type	Description
mesh_disease_topic_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
mesh_disease_topic_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
mesh_disease_topic_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
mesh_disease_topic_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
mesh_disease_topic_intelligence_facts	disease_concept_id	STRING	Canonical disease identifier across MeSH, MONDO, DOID, and Orphanet.

Disease & Ontology

MeSH Supplementary Chemical Intelligence

View full schema →

Table	Column	Type	Description
mesh_supplementary_chemical_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
mesh_supplementary_chemical_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
mesh_supplementary_chemical_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
mesh_supplementary_chemical_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
mesh_supplementary_chemical_intelligence_facts	disease_concept_id	STRING	Canonical disease identifier across MeSH, MONDO, DOID, and Orphanet.

Disease & Ontology

Orphanet Rare Disease Intelligence

View full schema →

Table	Column	Type	Description
orphanet_rare_disease_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
orphanet_rare_disease_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
orphanet_rare_disease_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
orphanet_rare_disease_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
orphanet_rare_disease_intelligence_facts	disease_concept_id	STRING	Canonical disease identifier across MeSH, MONDO, DOID, and Orphanet.

Disease & Ontology

Orphanet Disease Ontology (ORDO)

View full schema →

Table	Column	Type	Description
orphanet_disease_ontology_ordo_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
orphanet_disease_ontology_ordo_facts	source_record_id	STRING	Native identifier from the official source authority.
orphanet_disease_ontology_ordo_facts	source_authority	STRING	Official public source from which the row was ingested.
orphanet_disease_ontology_ordo_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
orphanet_disease_ontology_ordo_facts	disease_concept_id	STRING	Canonical disease identifier across MeSH, MONDO, DOID, and Orphanet.

Disease & Ontology

Orphanet Rare Disease Gene Intelligence

View full schema →

Table	Column	Type	Description
orphanet_rare_disease_gene_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
orphanet_rare_disease_gene_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
orphanet_rare_disease_gene_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
orphanet_rare_disease_gene_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
orphanet_rare_disease_gene_intelligence_facts	disease_concept_id	STRING	Canonical disease identifier across MeSH, MONDO, DOID, and Orphanet.

Disease & Ontology

Disease Ontology Intelligence (DOID)

View full schema →

Table	Column	Type	Description
disease_ontology_intelligence_doid_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
disease_ontology_intelligence_doid_facts	source_record_id	STRING	Native identifier from the official source authority.
disease_ontology_intelligence_doid_facts	source_authority	STRING	Official public source from which the row was ingested.
disease_ontology_intelligence_doid_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
disease_ontology_intelligence_doid_facts	disease_concept_id	STRING	Canonical disease identifier across MeSH, MONDO, DOID, and Orphanet.

Disease & Ontology

MONDO Disease Ontology Intelligence

View full schema →

Table	Column	Type	Description
mondo_disease_ontology_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
mondo_disease_ontology_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
mondo_disease_ontology_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
mondo_disease_ontology_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
mondo_disease_ontology_intelligence_facts	disease_concept_id	STRING	Canonical disease identifier across MeSH, MONDO, DOID, and Orphanet.

Disease & Ontology

Open Targets Platform Intelligence

View full schema →

Table	Column	Type	Description
open_targets_platform_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
open_targets_platform_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
open_targets_platform_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
open_targets_platform_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
open_targets_platform_intelligence_facts	disease_concept_id	STRING	Canonical disease identifier across MeSH, MONDO, DOID, and Orphanet.

Identity & Registry

RxNorm Clinical Drug Intelligence

View full schema →

Table	Column	Type	Description
rxnorm_clinical_drug_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
rxnorm_clinical_drug_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
rxnorm_clinical_drug_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
rxnorm_clinical_drug_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
rxnorm_clinical_drug_intelligence_facts	normalized_entity_id	STRING	Canonical entity identifier for the registry domain.

Identity & Registry

UMLS Medical Language Intelligence

View full schema →

Table	Column	Type	Description
umls_medical_language_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
umls_medical_language_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
umls_medical_language_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
umls_medical_language_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
umls_medical_language_intelligence_facts	normalized_entity_id	STRING	Canonical entity identifier for the registry domain.

Identity & Registry

HGNC Gene Nomenclature Intelligence

View full schema →

Table	Column	Type	Description
hgnc_gene_nomenclature_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
hgnc_gene_nomenclature_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
hgnc_gene_nomenclature_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
hgnc_gene_nomenclature_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
hgnc_gene_nomenclature_intelligence_facts	normalized_entity_id	STRING	Canonical entity identifier for the registry domain.

Identity & Registry

UniChem Chemical Cross-Reference Intelligence

View full schema →

Table	Column	Type	Description
unichem_chemical_cross_reference_intelligence_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
unichem_chemical_cross_reference_intelligence_facts	source_record_id	STRING	Native identifier from the official source authority.
unichem_chemical_cross_reference_intelligence_facts	source_authority	STRING	Official public source from which the row was ingested.
unichem_chemical_cross_reference_intelligence_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
unichem_chemical_cross_reference_intelligence_facts	normalized_entity_id	STRING	Canonical entity identifier for the registry domain.

Identity & Registry

Research Organization Registry (ROR)

View full schema →

Table	Column	Type	Description
research_organization_registry_ror_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
research_organization_registry_ror_facts	source_record_id	STRING	Native identifier from the official source authority.
research_organization_registry_ror_facts	source_authority	STRING	Official public source from which the row was ingested.
research_organization_registry_ror_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
research_organization_registry_ror_facts	normalized_entity_id	STRING	Canonical entity identifier for the registry domain.

Identity & Registry

NPI Provider Registry Intelligence (NPPES)

View full schema →

Table	Column	Type	Description
npi_provider_registry_intelligence_nppes_facts	canonical_drug_id	STRING	Stable identifier from the unified drug identity spine.
npi_provider_registry_intelligence_nppes_facts	source_record_id	STRING	Native identifier from the official source authority.
npi_provider_registry_intelligence_nppes_facts	source_authority	STRING	Official public source from which the row was ingested.
npi_provider_registry_intelligence_nppes_facts	last_refreshed_at	TIMESTAMP	Timestamp for the most recent verified refresh batch.
npi_provider_registry_intelligence_nppes_facts	normalized_entity_id	STRING	Canonical entity identifier for the registry domain.