📊

Data marts

Available data marts

Currently available data marts. Data is updated quarterly for free in our Google Drive.

For more frequent (weekly) updates, please contact us.

‣

Products

Name	Short Description	Status
Products	Product information including name, RXCUI, brand vs generic, ingredient, and dose form.	Done
Products to inactive ingredients	Maps products to inactive ingredients for the purpose of perhaps checking for allergies or contraindications to the INactive ingredients that comprise drug products.	Done
Brand products with related NDCs	Brand Product RXCUI → Related Clinical Product RXCUI → NDCs related to that Clinical Product RXCUI → FDA Start Marketing Dates.	Done
Product synonyms	Synonyms / different spellings of drugs from many different systems, mapped to RXCUIs.	Done

‣

NDCs

Name	Short Description	Status
NDCs to products	NDCs consolidated from 5 different sources and mapped to RxNorm description (with RXCUI) + FDA description.	Done
NDCs to package size + inner NDCs	NDC to total package size (GM, ML, or EA). Also inner/outer NDCs.	Done
NDCs to label images	Mapping NDCs to label image (the box / sticker with label information, not the product itself).	Done
NDCs to GTINs	An estimate of what a calculated GTIN should be be for any given NDC.	Done

‣

Classification

Name	Short Description	Status
ATC to RXCUI	ATC 1-4 codes to product-level RXCUIs and descriptions.	Done

The data marts we plan on developing in the near future.

‣

Products

Name	Short Description	Status
Product utilization	Ranking / data on most to least frequently utilized drug products.	To Do
Brand names to generic names	Generic name equivalents for brand names.	To Do
Product ingredients	Ingredients of products. Can be single or multi-ingredient at this grain.	To Do
Product components	Components of products.	To Do

‣

NDCs

Name	Short Description	Status
NDCs to characteristics	Size / color / imprint / etc.	To Do

‣

Classification

Name	Short Description	Status
VA to RXCUI	VA classification system.	To Do
EPC to RXCUI	EPC classification system.	To Do

‣

Billing

Name	Short Description	Status
CMS All	A combination of ASP, NDC HCPCS, and Addendum B to give a single source for a complete picture of the OPPS CMS data as it relates to billing and payments for provider administered drugs in the outpatient hospital facilities.	To Do
OPPS ASP Mapping	A combination of all status drug information sheets from CMS, including ASP (separately billable drugs), NOC (not otherwise chargeable), and OPPS classified drugs. It gives a full picture of how CMS views drugs in the US healthcare system.	To Do

Don’t see some source data you’re looking for on this list? Have an idea for a useful data mart?

← Previous

On this page