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 151–160 of 9,859 matching rows. Filters and search terms remain attached when you move between pages or open the API view.

  1. Projected row 151

    Record slug
    acetyl-coenzyme-a
    Record name
    Acetyl Coenzyme A
    Kind of record
    SUPPLEMENT_INGREDIENT
    Class rule
    rule-11: recorded supplement ingredient or supplement market module
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    acetyl-coenzyme-a
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • CAS
    • FDA_LABEL_SET
    • FDA_NDC
    • PUBCHEM_CID
    • RXCUI
    • UNII
    Attribution warnings
    None recorded
    Evidence
    None recorded

  2. Projected row 152

    Record slug
    acetyl-hexapeptide-8
    Record name
    Acetyl Hexapeptide-8
    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
    acetyl-hexapeptide-8
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • CAS
    • FDA_LABEL_SET
    • FDA_NDC
    • PUBCHEM_CID
    • RXCUI
    • UNII
    Attribution warnings
    • SHARED_REGISTRY_IDENTIFIER
    Evidence
    None recorded

  3. Projected row 153

    Record slug
    acetyl-hexapeptide-8-amide
    Record name
    Acetyl Hexapeptide-8 Amide
    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
    acetyl-hexapeptide-8-amide
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • CAS
    • FDA_LABEL_SET
    • FDA_NDC
    • PUBCHEM_CID
    • RXCUI
    • UNII
    Attribution warnings
    • SHARED_REGISTRY_IDENTIFIER
    Evidence
    None recorded

  4. Projected row 154

    Record slug
    acetyl-l-carnitine
    Record name
    Acetyl-L-Carnitine
    Kind of record
    SUPPLEMENT_INGREDIENT
    Class rule
    rule-11: recorded supplement ingredient or supplement market module
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    acetyl-l-carnitine
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • CAS
    • DSLD_INGREDIENT_GROUP
    • PUBCHEM_CID
    • RXCUI
    • UNII
    Attribution warnings
    • SHARED_REGISTRY_IDENTIFIER
    Evidence
    None recorded

  5. Projected row 155

    Record slug
    acetyl-l-carnitine-arginate
    Record name
    Acetyl-L-Carnitine Arginate
    Kind of record
    SUPPLEMENT_INGREDIENT
    Class rule
    rule-11: recorded supplement ingredient or supplement market module
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    acetyl-l-carnitine-arginate
    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

  6. Projected row 156

    Record slug
    acetyl-l-glutathione
    Record name
    Acetyl-L-Glutathione
    Kind of record
    SUPPLEMENT_INGREDIENT
    Class rule
    rule-11: recorded supplement ingredient or supplement market module
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    acetyl-l-glutathione
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • DSLD_INGREDIENT_GROUP
    Attribution warnings
    None recorded
    Evidence
    None recorded

  7. Projected row 157

    Record slug
    acetyl-l-tyrosine
    Record name
    Acetyl-L-Tyrosine
    Kind of record
    SUPPLEMENT_INGREDIENT
    Class rule
    rule-11: recorded supplement ingredient or supplement market module
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    acetyl-l-tyrosine
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • CAS
    • DSLD_INGREDIENT_GROUP
    • FDA_LABEL_SET
    • FDA_NDC
    • PUBCHEM_CID
    • RXCUI
    • UNII
    Attribution warnings
    • SHARED_REGISTRY_IDENTIFIER
    Evidence
    None recorded

  8. Projected row 158

    Record slug
    acetyl-tetrapeptide-5
    Record name
    Acetyl Tetrapeptide-5
    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
    acetyl-tetrapeptide-5
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • CAS
    • FDA_LABEL_SET
    • FDA_NDC
    • PUBCHEM_CID
    • RXCUI
    • UNII
    Attribution warnings
    None recorded
    Evidence
    None recorded

  9. Projected row 159

    Record slug
    acetyl-tetrapeptide-9
    Record name
    Acetyl Tetrapeptide-9
    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
    acetyl-tetrapeptide-9
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • CAS
    • FDA_LABEL_SET
    • FDA_NDC
    • PUBCHEM_CID
    • RXCUI
    • UNII
    Attribution warnings
    None recorded
    Evidence
    None recorded

  10. Projected row 160

    Record slug
    acetylcarnitine
    Record name
    Acetylcarnitine
    Kind of record
    SUPPLEMENT_INGREDIENT
    Class rule
    rule-11: recorded supplement ingredient or supplement market module
    Resolution
    CANONICAL_ENTITY
    Address for this entity
    acetylcarnitine
    Redirects to
    Not recorded
    What the identity rests on
    REGISTRY_IDENTIFIER_RECORDED
    Registry identifier kinds
    • DSLD_INGREDIENT_GROUP
    • FDA_LABEL_SET
    • FDA_NDC
    Attribution warnings
    • SHARED_REGISTRY_IDENTIFIER
    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=150

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