Context RxNorm is a name of a US-specific terminology in medicine that contains all medications available on US market. Source: https://en.wikipedia.org/wiki/RxNorm RxNorm provides normalized names for clinical drugs and links its names to many of the drug vocabularies commonly used in pharmacy management and drug interaction software, including those of First Databank, Micromedex, Gold Standard Drug Database, and Multum. By providing links between these vocabularies, RxNorm can mediate messages between systems not using the same software and vocabulary. Source: https://www.nlm.nih.gov/research/umls/rxnorm/ Content RxNorm was created by the [U.S. National Library of Medicine (NLM)][1] to provide a normalized naming system for clinical drugs, defined as the combination of {ingredient + strength + dose form}. In addition to the naming system, the RxNorm dataset also provides structured information such as brand names, ingredients, drug classes, and so on, for each clinical drug. Typical uses of RxNorm include navigating between names and codes among different drug vocabularies and using information in RxNorm to assist with health information exchange/medication reconciliation, e-prescribing, drug analytics, formulary development, and other functions. This public dataset includes multiple data files originally released in RxNorm Rich Release Format (RXNRRF) that are loaded into Bigquery tables. The data is updated and archived on a monthly basis. The following tables are included in the RxNorm dataset: - RXNCONSO contains concept and source information - RXNREL contains information regarding relationships between entities - RXNSAT contains attribute information - RXNSTY contains semantic information - RXNSAB contains source info - RXNCUI contains retired rxcui codes - RXNATOMARCHIVE contains archived data - RXNCUICHANGES contains concept changes Update Frequency: Monthly Fork [this kernel][2] to get started with this dataset. Acknowledgements https://www.nlm.nih.gov/research/umls/rxnorm/ https://bigquery.cloud.google.com/dataset/bigquery-public-data:nlm_rxnorm https://cloud.google.com/bigquery/public-data/rxnorm Dataset Source: [Unified Medical Language System RxNorm][3]. The dataset is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset. This dataset uses publicly available data from the U.S. National Library of Medicine (NLM), National Institutes of Health, Department of Health and Human Services; NLM is not responsible for the dataset, does not endorse or recommend this or any other dataset. Banner Photo by [@freestocks from Unsplash][4]. Inspiration What are the RXCUI codes for the ingredients of a list of drugs? Which ingredients have the most variety of dose forms? In what dose forms is the drug phenylephrine found? What are the ingredients of the drug labeled with the generic code number 072718? [1]: https://www.nlm.nih.gov/ [2]: https://www.kaggle.com/paultimothymooney/starter-kernel-for-rxnorm-dataset [3]: https://www.nlm.nih.gov/research/umls/rxnorm/ [4]: https://unsplash.com/photos/nss2eRzQwgw