coderxio / sagerx

Open drug data pipelines curated by pharmacists.
https://coderx.io/sagerx
Other
41 stars 11 forks source link

Excipients with no matching FDA UNII code in data #297

Closed joeschmoey closed 5 days ago

joeschmoey commented 5 days ago

Problem Statement

30-someting out of 17k+ excipients / inactive ingredients / substances in our data mart have UNII codes but did not map to most recent UNII data.

Will the next UNII data load solve this? Or is there a different reason for this?

One thing I noticed is that if you search for these on the UNII website, they show up as a match, but only because they matched a synonym / mapping code... the code detail page you land on is for a different UNII. So maybe some of these need to be mapped to more recent/updated/reused codes? image

Criteria for Success

We reduce the number of unmatched UNII display names or show that they get resolved every time there is a new UNII data load.

Additional Information

Investigate the mapping thing first.

Should also look into the NOCODE excipients and see if there's anything we can do about those.

jrlegrand commented 5 days ago

Duplicate / in error