National Drug Code and Drug Labels Database

**Overview**
This data package includes FDA National Drug Code (NDC) data for finished and unfinished drugs and main FDA labels databases.

**Description**
This data package includes FDA National Drug Code (NDC) of products and packages for both finished and unfinished drugs and main FDA labels databases like detailed drug facts label structure and approved safety labeling changes by the Center for Drug Evaluation and Research (CDER).

**Benefits**
- Useful for researchers seeking for organized data related to drug labels and labeling, drug national drug products codes, drug package codes and other specific drug facts.
- the fields descriptions along with the dataset description are again useful for user to quick understand the data and the dataset.

**License Information**
The use of John Snow Labs datasets is free for personal and research purposes. For commercial use please subscribe to the [Data Library](https://www.johnsnowlabs.com/marketplace/) on John Snow Labs website. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes.

**Included Datasets**
- [Detailed Drug Facts Label Structure by NDC](https://johnsnowlabs.com/wp-json/datasets-api/v1/detailed-drug-facts-label-structure-by-ndc)
- This dataset contains details from the Structure Product Labeling documents and NDC assignment of products submitted to FDA for the inclusion in the Online Label Repository.
- [Drug Manufacturer Codes and Labeler Codes](https://johnsnowlabs.com/wp-json/datasets-api/v1/drug-manufacturer-codes-and-labeler-codes)
- This dataset contains a list of NDC National Health Related Items Code (NHRIC) codes for pharmaceutical companies.
- [Drug Safety Labeling Changes](https://johnsnowlabs.com/wp-json/datasets-api/v1/drug-safety-labeling-changes)
- The Drug Safety Labeling Changes (SLC) database provides approved safety labeling changes by the Center for Drug Evaluation and Research (CDER) from January 2021 forward.
- [NDC Packages of Unfinished Drugs](https://johnsnowlabs.com/wp-json/datasets-api/v1/ndc-packages-of-unfinished-drugs)
- The National Drug Code (NDC) Packages of Unfinished Drugs dataset contains NDC package listing data submitted for all unfinished drugs.
Drug products are identified and reported using a unique, three-segment number, called the National Drug Code (NDC), which serves as a universal product identifier for drugs. FDA publishes the listed NDC numbers and the information submitted as part of the listing information in the NDC Directory which is updated daily.
- [NDC Products of Unfinished Drugs](https://johnsnowlabs.com/wp-json/datasets-api/v1/ndc-products-of-unfinished-drugs)
- The National Drug Code (NDC) Products of Unfinished Drugs dataset contains NDC product listing data submitted for all unfinished drugs.
Drug products are identified and reported using a unique, three-segment number, called the National Drug Code (NDC), which serves as a universal product identifier for drugs. FDA publishes the listed NDC numbers and the information submitted as part of the listing information in the NDC Directory which is updated daily.
- [National Drug Code Packages](https://johnsnowlabs.com/wp-json/datasets-api/v1/national-drug-code-packages)
- The Drug Listing Act of 1972 requires registered drug establishments to provide the Food and Drug Administration (FDA) with a current list of all drugs manufactured, prepared, propagated, compounded, or processed by it for commercial distribution including drug code packages. Drug products are identified and reported using a unique, three-segment number, called the National Drug Code (NDC), which serves as a universal product identifier for drugs.
- [National Drug Code Products](https://johnsnowlabs.com/wp-json/datasets-api/v1/national-drug-code-products)
- The Drug Listing Act of 1972 requires registered drug establishments to provide the Food and Drug Administration (FDA) with a current list of all drugs manufactured, prepared, propagated, compounded, or processed by it for commercial distribution including drug code products. Drug products are identified and reported using a unique, three-segment number, called the National Drug Code (NDC), which serves as a universal product identifier for drugs.
- [Pillbox Master Data Lookup](https://johnsnowlabs.com/wp-json/datasets-api/v1/pillbox-master-data-lookup)
- This dataset is the master file of the Pillbox database of the US National Library of Medicine (NLM), which contains descriptive information on the existing medication pills in the market. Values supplied by the drug companies to FDA (Food and Drug Administration) as part of the Structured Product Labels are labeled "SPL". All other values are added by the National Library of Medicine’s (NLM) Pillbox or RxNorm datasets.
- [Structured Product Labeling](https://johnsnowlabs.com/wp-json/datasets-api/v1/structured-product-labeling)
- The Structured Product Labeling dataset contains the most recent drug labeling information submitted to the Food and Drug Administration (FDA) and currently in use.
All labels information are published by DailyMed the official provider of FDA label information.

**Data Engineering Overview**
**We deliver high-quality data**
- Each dataset goes through 3 levels of quality review
- 2 Manual reviews are done by domain experts
- Then, an automated set of 60+ validations enforces every datum matches metadata & defined constraints
- Data is normalized into one unified type system
- All dates, unites, codes, currencies look the same
- All null values are normalized to the same value
- All dataset and field names are SQL and Hive compliant
- Data and Metadata
- Data is available in both CSV and Apache Parquet format, optimized for high read performance on distributed Hadoop, Spark & MPP clusters
- Metadata is provided in the open Frictionless Data standard, and its every field is normalized & validated
- Data Updates
- Data updates support replace-on-update: outdated foreign keys are deprecated, not deleted

**Our data is curated and enriched by domain experts**

Each dataset is manually curated by our team of doctors, pharmacists, public health & medical billing experts:
- Field names, descriptions, and normalized values are chosen by people who actually understand their meaning
- Healthcare & life science experts add categories, search keywords, descriptions and more to each dataset
- Both manual and automated data enrichment supported for clinical codes, providers, drugs, and geo-locations
- The data is always kept up to date – even when the source requires manual effort to get updates
- Support for data subscribers is provided directly by the domain experts who curated the data sets
- Every data source’s license is manually verified to allow for royalty-free commercial use and redistribution.

**Need Help?**
If you have questions about our products, contact us at [[e-mail]](mailto:[e-mail]).

搜集汇总

背景与挑战

背景概述

该数据集整合了FDA国家药品代码(NDC)数据，涵盖成品/未成品药品的包装代码、产品代码及主要标签数据库，包含药品标签结构、安全标签变更等详细信息。数据集包含8个子集，如未成品药品NDC包、药品制造商代码、结构化产品标签等，适用于药品编码与标签研究的标准化数据需求。