CodeRx Compendium update Q1 2025

The first data drop of 2025 introduces two new data marts: product synonyms and GTINs.

In addition to refreshing all of the existing data marts with data through the end of January 2025, this update to the open version of the CodeRx Compendium includes two new data marts: product synonyms and GTINs.

Plus, thanks to some great work by Kwasi Agyeman, our ATC codes to products data mart has captured over 300 extra rows from the API.

We will continue to update these data marts for free on a quarterly basis. If you find them useful but need more frequent updates, please contact us and we will work with you to deliver what you need. If you want to leave us general feedback or request additional data marts, also feel free to let us know - we’d love to hear from you!

The Q1 2025 CodeRx Compendium update.

Product synonyms

If you’re training a ML model to recognize fuzzy matches for names of drug products, this data mart could be useful. It contains synonyms of drug products from many different sources and maps each synonym to a drug product ID (RxNorm product-level RXCUI).

This data mart was originally created for a recent Awell Health hackathon with the goal of allowing patients to take a picture of their prescription and OTC bottles / packages and have AI identify the product either using the name or NDC and map it to a product-level RxNorm RXCUI. I was personally shocked and impressed at how well the demo worked. We’re now making this data available to everyone.

Here’s a link to the actual original data used for the hackathon in 2024.

Promotional image from the Awell Hackathon demo showing an example workflow. This demo utilized the product synonyms data mart, as well as a few others.

GTINs

This data mart is just an estimate of what a calculated GTIN (GTIN-14, specifically) should be be for any given NDC. It has not been validated and could be wrong for many reasons. Use at your own discretion but please provide feedback for ways it could be improved.

GTINs are important for track and trace (DSCSA) as well as any sort of barcode-related medication workflows (dispensing cabinets, for instance). This data represents a “best-guess” approach (based on this guide) for what a calculated GTIN should be for a given NDC, but manufacturers have some laterality in terms of using different digits.

Example of a FDA NDC embedded within a GTIN14. Image from the GS1 implementation guideline document.

Talk to us

More documentation about most of these data marts can be found on our website. If you have ideas for other data marts or if you find this data useful and would like updated data delivered on a weekly basis, please contact us and we will work with you. Please let us know if you have any questions or feedback and thanks for taking the time to read this!