RXNorm - Quantities

[suku...@gmail.com]

I am trying to retrieve the commonly prescribed quantities for drugs using RXNorm. For example, Amoxicillin is usually prescribes in 21, 28, or 30 and this is the information I am looking for.

Feels like RXNorm has this data, but not entirely sure. Can anyone please help?

Thank you in advance.

[Josh Mandel]

This is probably more of a question for the RxNorm team at NLM.

In general, I'm not aware that prescribing frequency data are available in RxNorm. That is, I don't think there's a way to figure out which drugs are prescribed most commonly. There's a related question, which is "for a given drug, what pill counts are available as pre-packaged configurations?" That information doesn't appear to be available in RxNorm in a consistent, structured way. But it is available from FDA's Structured Product Label database. 

For an example of the kind of structured data you can find in RxNorm directly, given an NDC, see the query below. As you'll see, there are details about piss shape and size, but not structured pill counts. (It's possible I'm looking in the wrong place -- I'd be very happy for someone to correct me :-))

Also, quick point: if you're interested in setting up your own local rxnorm database, see https://github.com/chb/py-umls from Pascal on the SMART team.

Best,

  Josh

---

sqlite> select rxcui, rxaui, atn, sab, atv from rxnsat where rxaui in (

        select rxaui from rxnsat where atn='NDC' and atv='42291-158-90');

RXCUI   RXAUI   ATN     SAB       ATV                           

------  ------  ------  --------  ------------------------------

197391  639796  ANDA    MTHSPL    ANDA078220                    

197391  639796  COLOR   MTHSPL    C48325                        

197391  639796  COLORT  MTHSPL    WHITE(white)                  

197391  639796  DM_SPL  MTHSPL    137116                        

197391  639796  IMPRIN  MTHSPL    LCI;1330                      

197391  639796  LABELE  MTHSPL    AvKARE, Inc.                  

197391  639796  LABEL_  MTHSPL    HUMAN PRESCRIPTION DRUG LABEL 

197391  639796  MARKET  MTHSPL    ANDA                          

197391  639796  MARKET  MTHSPL    20140825                      

197391  639796  MARKET  MTHSPL    active                        

197391  639796  NDC     MTHSPL    42291-158-10                  

197391  639796  NDC     MTHSPL    42291-158-90                  

197391  639796  SCORE   MTHSPL    2                             

197391  639796  SHAPE   MTHSPL    C48348                        

197391  639796  SHAPET  MTHSPL    round                         

197391  639796  SIZE    MTHSPL    9 mm                          

197391  639796  SPL_SE  MTHSPL    4ac972eb-80f9-18ce-0bec-65f232

197391  639796  UMLSCU  RXNORM    C0687971 

  -Josh

--
You received this message because you are subscribed to the Google Groups "SMART App Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to smart-app-develo...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[exim]

An alternate source of drug packaging information is the National Drug Code Directory (http://www.fda.gov/Drugs/InformationOnDrugs/ucm142438.htm ).  The directory is updated daily and is available for download as a zip file.  The zip file contains product and package files in .txt or .xls formats.

 

For my app, I load the product.txt and package.txt files into a SQL database indexed on the  productNDC and/or the packageNDC.

 

Note: From the perspective of the FDA, the NDC is a 3 segment number; each segment separated by a hyphen (-).  The first two segments are the product NDC.  All three segments collectively are referred to as the package NDC.  Some organizations have deviated from the FDA standard when assigning an NDC code for use in their systems.  Therefore, depending upon the source of the NDC, it may/may not be in the proper format to access the NDC Directory directly.

 

 

Robert

USGovXML.com

 

---

From: smart-app-...@googlegroups.com [mailto:smart-app-...@googlegroups.com] On Behalf Of Josh Mandel
Sent: Tuesday, March 10, 2015 1:24 PM
To: smart-app-...@googlegroups.com
Subject: Re: [smart-dev] RXNorm - Quantities