Skip to content
RNAWiki
Checking…
All public datasets

Public dataset

What each stored medicine record resolves to

Look up what one stored record was decided to be: an entity that keeps its own address, a record that resolves to the address of the same entity, or an identifier that never named a medicine.

What this does not mean: This is about records, not about substances. It does not say two substances are the same thing, that a record is correct, or that a withdrawn address means the substance does not exist. A registry identifier held by more than one record is published as a warning code and is never treated as evidence to merge.
Public rows
9,859
Generated
Schema version
inventory-resolution/1

Coverage

What this run contains

Stored records resolved
9,859
CANONICAL_ENTITY
9,852
ALIAS_OF_CANONICAL_ENTITY
0
DUPLICATE_OF_CANONICAL_ENTITY
5
HISTORICAL_REDIRECT
0
INVALID_IDENTITY_GONE
2
MANUAL_IDENTITY_REVIEW_REQUIRED
0
Kinds of record represented
12
APPROVED_BIOLOGIC, APPROVED_MEDICINE, BOTANICAL_OR_ORGANISM_PREPARATION, COMBINATION_PRODUCT, CONTROLLED_NO_APPROVED_USE, INVESTIGATIONAL_MEDICINE, MARKETED_PRODUCT_INGREDIENT, OFF_LABEL_OR_COMPOUNDED, PLACEHOLDER, REGISTRY_ONLY_IDENTITY, SUPPLEMENT_INGREDIENT, WITHDRAWN_MEDICINE
Rows carrying an attribution warning
3,416
ALIAS_SHADOWED_BY_CANONICAL_SLUG, DUPLICATE_HOLDS_UNMERGED_MODULES, NAME_ONLY_IDENTITY, NO_RECORDED_BACKGROUND, SHARED_REGISTRY_IDENTIFIER

Method

How the rows were made

  1. Every row in the medicine table receives exactly one resolution, decided by a fixed rule table read over stored fields.
  2. Two records resolve to one entity only on exact deterministic evidence, such as an identical name once punctuation is removed. Salts, stereoisomers, metabolites, formulations, combinations, brands, botanical preparations, organisms and biologics are never merged by rule.
  3. A registry identifier recorded on more than one record produces the SHARED_REGISTRY_IDENTIFIER warning code. The other records are not named in this dataset.
  4. entityClassRule names the rule that fired and resolutionEvidence carries the deterministic evidence behind a non-canonical outcome, so a reader can repeat the decision or disagree with it.
  5. identitySourceKinds names the kinds of registry identifier read from the record, such as UNII or PUBCHEM_CID, without repeating the identifier values already published on the medicine row.

Limits

Read these before using a row

  • A resolution states which public address a stored record answers at. It is not a medical statement and it is not a quality ranking. A registry identifier held by more than one record is published as a warning code only; the other records are never named. resolutionEvidence can name the record a duplicate resolves to, because both describe one entity.
  • The rules read the fields stored in this snapshot. A record whose registry identifiers were never recorded is resolved on its name alone, which identityConfidence states.
  • A resolution can change when the record behind it changes. Read the snapshot date before comparing two exports.
  • A row whose identity is marked for manual review means a person still has to decide. The row stays published and visible until they do.

Provenance

Source examples

0.01-0.2 Mole Percent Bisacrylamide) · CANONICAL_ENTITY

MARKETED_PRODUCT_INGREDIENT by rule-5: approved status, but every label naming it is a non-prescription product declaring it alongside other substances, and no Drugs@FDA application is recorded; identity confidence REGISTRY_IDENTIFIER_RECORDED

Coenzyme Q-10 · DUPLICATE_OF_CANONICAL_ENTITY

SUPPLEMENT_INGREDIENT by rule-11: recorded supplement ingredient or supplement market module; identity confidence REGISTRY_IDENTIFIER_RECORDED

identical name after removing non-alphanumeric characters ("coenzymeq10"): "Coenzyme Q-10" and "Coenzyme Q10" a resolver-written redirect ledger row already records this duplicate both records carry CAS 303-98-0 both records carry PUBCHEM_CID 5281915 both records carry RXCUI 21406

Header · INVALID_IDENTITY_GONE

PLACEHOLDER by rule-1: placeholder identity; identity confidence PLACEHOLDER

placeholder identity: slug "header", name "Header"

Artifact used for this view: data/inventory-resolution.ndjson. The reader resolves the current run first and uses the checked-in compatibility run only when a current artifact is absent.

Schema

Fields in the public projection

FieldTypeMeaning
medicineSlugstringThe stored record being resolved, by its original RNAWiki route key.
medicineNamestringThe name recorded on that row; not normalized for display style.
entityClassstringWhat kind of thing the row is, such as APPROVED_MEDICINE, SUPPLEMENT_INGREDIENT or REGISTRY_ONLY_IDENTITY. It selects which dossier sections apply and is never a quality ranking.
entityClassRulestringThe rule from the fixed class table that decided the kind.
resolutionStatusstringCANONICAL_ENTITY keeps its own address. DUPLICATE_OF_CANONICAL_ENTITY, ALIAS_OF_CANONICAL_ENTITY and HISTORICAL_REDIRECT resolve to the address of the same entity. INVALID_IDENTITY_GONE never named a medicine. MANUAL_IDENTITY_REVIEW_REQUIRED is waiting for a person.
canonicalSlugstringThe route key this entity is served at. It equals the record slug for a canonical record.
redirectTargetSlugstringPresent only for a resolving status, always one hop, and always the same entity described twice. Null on every other row.
identityConfidencestringREGISTRY_IDENTIFIER_RECORDED, NAME_ONLY when the row is identified by its recorded name alone, or PLACEHOLDER when it identifies nothing.
identitySourceKindsstring[]Kinds of identifier recorded on the row. Empty when none was recorded.
attributionWarningCodesstring[]Codes a reviewer should see, such as SHARED_REGISTRY_IDENTIFIER or NAME_ONLY_IDENTITY. Codes only: the records a warning was raised against are never named here.
resolutionEvidencestring[]The deterministic evidence behind a non-canonical outcome. It can name the address a record resolves to, because both describe one entity.

Reader

Search and filter the rows

Case-insensitive text search over the public fields named for this dataset.

Exact resolution status.

Exact entity class.

Clear

Showing 211–220 of 9,859 matching rows. Filters and search terms remain attached when you move between pages or open the API view.

  1. Projected row 211

    Record slug
    adansonia-digitata-seed-oil
    Record name
    Adansonia Digitata Seed Oil
    Kind of record
    MARKETED_PRODUCT_INGREDIENT
    Class rule
    rule-5: approved status, but every label naming it is a non-prescription product declaring it alongside other substances, and no Drugs@FDA application is recorded
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    adansonia-digitata-seed-oil
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • FDA_LABEL_SET
    • FDA_NDC
    • RXCUI
    • UNII
    Attribution warnings
    None recorded
    Evidence
    None recorded

  2. Projected row 212

    Record slug
    adapalene
    Record name
    Adapalene
    Kind of record
    APPROVED_MEDICINE
    Class rule
    rule-7: approved status
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    adapalene
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • FDA_APPLICATION
    • FDA_LABEL_SET
    • FDA_NDC
    • RXCUI
    • UNII
    Attribution warnings
    None recorded
    Evidence
    None recorded

  3. Projected row 213

    Record slug
    adapalene-benzoyl-peroxide
    Record name
    Adapalene, Benzoyl Peroxide
    Kind of record
    COMBINATION_PRODUCT
    Class rule
    rule-2: recorded composition with more than one active ingredient
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    adapalene-benzoyl-peroxide
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • CAS
    • FDA_APPLICATION
    • PUBCHEM_CID
    • RXCUI
    • UNII
    Attribution warnings
    • SHARED_REGISTRY_IDENTIFIER
    Evidence
    None recorded

  4. Projected row 214

    Record slug
    adefovir-dipivoxil
    Record name
    Adefovir Dipivoxil
    Kind of record
    APPROVED_MEDICINE
    Class rule
    rule-7: approved status
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    adefovir-dipivoxil
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • FDA_APPLICATION
    • FDA_LABEL_SET
    • FDA_NDC
    • RXCUI
    • UNII
    Attribution warnings
    None recorded
    Evidence
    None recorded

  5. Projected row 215

    Record slug
    ademetionine
    Record name
    Ademetionine
    Kind of record
    SUPPLEMENT_INGREDIENT
    Class rule
    rule-11: recorded supplement ingredient or supplement market module
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    ademetionine
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • FDA_LABEL_SET
    • FDA_NDC
    Attribution warnings
    None recorded
    Evidence
    None recorded

  6. Projected row 216

    Record slug
    adenine
    Record name
    Adenine
    Kind of record
    SUPPLEMENT_INGREDIENT
    Class rule
    rule-11: recorded supplement ingredient or supplement market module
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    adenine
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • DSLD_INGREDIENT_GROUP
    • FDA_LABEL_SET
    • FDA_NDC
    • UNII
    Attribution warnings
    None recorded
    Evidence
    None recorded

  7. Projected row 217

    Record slug
    adenophora
    Record name
    Adenophora
    Kind of record
    BOTANICAL_OR_ORGANISM_PREPARATION
    Class rule
    rule-10: recorded biological (taxonomy) identity
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    adenophora
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • DSLD_INGREDIENT_GROUP
    • NCBI_TAXONOMY
    Attribution warnings
    None recorded
    Evidence
    None recorded

  8. Projected row 218

    Record slug
    adenosine
    Record name
    Adenosine
    Kind of record
    APPROVED_MEDICINE
    Class rule
    rule-7: approved status
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    adenosine
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • DSLD_INGREDIENT_GROUP
    • FDA_APPLICATION
    • FDA_LABEL_SET
    • FDA_NDC
    Attribution warnings
    • SHARED_REGISTRY_IDENTIFIER
    Evidence
    None recorded

  9. Projected row 219

    Record slug
    adenosine-cyclic
    Record name
    Adenosine Cyclic
    Kind of record
    SUPPLEMENT_INGREDIENT
    Class rule
    rule-11: recorded supplement ingredient or supplement market module
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    adenosine-cyclic
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • FDA_LABEL_SET
    • FDA_NDC
    Attribution warnings
    None recorded
    Evidence
    None recorded

  10. Projected row 220

    Record slug
    adenosine-diphosphate
    Record name
    Adenosine Diphosphate
    Kind of record
    SUPPLEMENT_INGREDIENT
    Class rule
    rule-11: recorded supplement ingredient or supplement market module
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    adenosine-diphosphate
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • CAS
    • DSLD_INGREDIENT_GROUP
    • PUBCHEM_CID
    • UNII
    Attribution warnings
    None recorded
    Evidence
    None recorded

Access

Query or download the projection

View this filtered page as JSONDownload up to 200 filtered CSV rows
GET /api/datasets/inventory-resolution?limit=10&offset=210

Allowed query parameters

q
Case-insensitive text search over the public fields named for this dataset.
state
Exact resolution status.Values: CANONICAL_ENTITY, ALIAS_OF_CANONICAL_ENTITY, DUPLICATE_OF_CANONICAL_ENTITY, HISTORICAL_REDIRECT, INVALID_IDENTITY_GONE, MANUAL_IDENTITY_REVIEW_REQUIRED
role
Exact entity class.Values: APPROVED_MEDICINE, APPROVED_BIOLOGIC, INVESTIGATIONAL_MEDICINE, OFF_LABEL_OR_COMPOUNDED, WITHDRAWN_MEDICINE, CONTROLLED_NO_APPROVED_USE, COMBINATION_PRODUCT, BOTANICAL_OR_ORGANISM_PREPARATION, SUPPLEMENT_INGREDIENT, MARKETED_PRODUCT_INGREDIENT, REGISTRY_ONLY_IDENTITY, PLACEHOLDER
limit / offset
Pagination is required. limit is at most 200; offset is bounded. Set format=csv for the same projected page as a download.

Reuse and corrections

Keep the boundary attached

CC BY 4.0 applies to RNAWiki licenses its selection, schema, structure, and derived projection. Quoted source passages and third-party records retain their original rights.

Cite RNAWiki, this dataset identifier, and the generated date. Keep the “does not mean” statement with any downstream display so a corpus measurement is not mistaken for medical advice.

Read the correction policy