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
- Every row in the medicine table receives exactly one resolution, decided by a fixed rule table read over stored fields.
- 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.
- 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.
- 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.
- 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
| Field | Type | Meaning |
|---|---|---|
| medicineSlug | string | The stored record being resolved, by its original RNAWiki route key. |
| medicineName | string | The name recorded on that row; not normalized for display style. |
| entityClass | string | What 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. |
| entityClassRule | string | The rule from the fixed class table that decided the kind. |
| resolutionStatus | string | CANONICAL_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. |
| canonicalSlug | string | The route key this entity is served at. It equals the record slug for a canonical record. |
| redirectTargetSlug | string | Present only for a resolving status, always one hop, and always the same entity described twice. Null on every other row. |
| identityConfidence | string | REGISTRY_IDENTIFIER_RECORDED, NAME_ONLY when the row is identified by its recorded name alone, or PLACEHOLDER when it identifies nothing. |
| identitySourceKinds | string[] | Kinds of identifier recorded on the row. Empty when none was recorded. |
| attributionWarningCodes | string[] | 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. |
| resolutionEvidence | string[] | 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
Showing 1,421–1,430 of 9,859 matching rows. Filters and search terms remain attached when you move between pages or open the API view.
Projected row 1421
- Record slug
- boron-citrate
- Record name
- Boron Citrate
- Kind of record
- SUPPLEMENT_INGREDIENT
- Class rule
- rule-11: recorded supplement ingredient or supplement market module
- Resolution
- CANONICAL_ENTITY
- Address for this entity
- boron-citrate
- Redirects to
- Not recorded
- What the identity rests on
- REGISTRY_IDENTIFIER_RECORDED
- Registry identifier kinds
- DSLD_INGREDIENT_GROUP
- FDA_LABEL_SET
- PUBCHEM_CID
- RXCUI
- UNII
- Attribution warnings
- SHARED_REGISTRY_IDENTIFIER
- Evidence
- None recorded
Projected row 1422
- Record slug
- boron-oxide
- Record name
- Boron Oxide
- Kind of record
- SUPPLEMENT_INGREDIENT
- Class rule
- rule-11: recorded supplement ingredient or supplement market module
- Resolution
- CANONICAL_ENTITY
- Address for this entity
- boron-oxide
- 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
- UNII
- Attribution warnings
- SHARED_REGISTRY_IDENTIFIER
- Evidence
- None recorded
Projected row 1423
- Record slug
- boronic-acid-analogues
- Record name
- Boronic Acid Analogues
- Kind of record
- SUPPLEMENT_INGREDIENT
- Class rule
- rule-11: recorded supplement ingredient or supplement market module
- Resolution
- CANONICAL_ENTITY
- Address for this entity
- boronic-acid-analogues
- 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
Projected row 1424
- Record slug
- boronoethyl-l-cysteine
- Record name
- Boronoethyl L-Cysteine
- Kind of record
- SUPPLEMENT_INGREDIENT
- Class rule
- rule-11: recorded supplement ingredient or supplement market module
- Resolution
- CANONICAL_ENTITY
- Address for this entity
- boronoethyl-l-cysteine
- 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
Projected row 1425
- Record slug
- borosilicate-glass
- Record name
- Borosilicate Glass
- Kind of record
- SUPPLEMENT_INGREDIENT
- Class rule
- rule-11: recorded supplement ingredient or supplement market module
- Resolution
- CANONICAL_ENTITY
- Address for this entity
- borosilicate-glass
- Redirects to
- Not recorded
- What the identity rests on
- REGISTRY_IDENTIFIER_RECORDED
- Registry identifier kinds
- CAS
- FDA_LABEL_SET
- FDA_NDC
- UNII
- Attribution warnings
- None recorded
- Evidence
- None recorded
Projected row 1426
- Record slug
- borotutu
- Record name
- Borotutu
- Kind of record
- SUPPLEMENT_INGREDIENT
- Class rule
- rule-11: recorded supplement ingredient or supplement market module
- Resolution
- CANONICAL_ENTITY
- Address for this entity
- borotutu
- 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
Projected row 1427
- Record slug
- borrelia-afzelii
- Record name
- Borrelia Afzelii
- Kind of record
- SUPPLEMENT_INGREDIENT
- Class rule
- rule-11: recorded supplement ingredient or supplement market module
- Resolution
- CANONICAL_ENTITY
- Address for this entity
- borrelia-afzelii
- Redirects to
- Not recorded
- What the identity rests on
- REGISTRY_IDENTIFIER_RECORDED
- Registry identifier kinds
- FDA_LABEL_SET
- FDA_NDC
- NCBI_TAXONOMY
- UNII
- Attribution warnings
- None recorded
- Evidence
- None recorded
Projected row 1428
- Record slug
- borrelia-burgdorferi
- Record name
- Borrelia Burgdorferi
- Kind of record
- SUPPLEMENT_INGREDIENT
- Class rule
- rule-11: recorded supplement ingredient or supplement market module
- Resolution
- CANONICAL_ENTITY
- Address for this entity
- borrelia-burgdorferi
- Redirects to
- Not recorded
- What the identity rests on
- REGISTRY_IDENTIFIER_RECORDED
- Registry identifier kinds
- FDA_LABEL_SET
- FDA_NDC
- UNII
- Attribution warnings
- None recorded
- Evidence
- None recorded
Projected row 1429
- Record slug
- bortezomib
- Record name
- Bortezomib
- Kind of record
- APPROVED_MEDICINE
- Class rule
- rule-7: approved status
- Resolution
- CANONICAL_ENTITY
- Address for this entity
- bortezomib
- 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
Projected row 1430
- Record slug
- bos-taurus-adrenal-cortex
- Record name
- Bos Taurus Adrenal Cortex
- Kind of record
- SUPPLEMENT_INGREDIENT
- Class rule
- rule-11: recorded supplement ingredient or supplement market module
- Resolution
- CANONICAL_ENTITY
- Address for this entity
- bos-taurus-adrenal-cortex
- 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
Access
Query or download the projection
GET /api/datasets/inventory-resolution?limit=10&offset=1420Allowed 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.