FDA NDC Drug Products
U.S. FDA National Drug Code (NDC) directory, one row per listed drug product (138,143 products): product id, product NDC, labeler, generic and brand names, dosage form, route, marketing category, application number, DEA schedule, active ingredients with strengths, pharmacologic classes, RxCUI, UNII, and marketing and listing dates. Join to fda_ndc_package on product_id (product_ndc is not unique). Data provided by the U.S. Food and Drug Administration (openFDA drug NDC, export of 2026-10-27), CC0 1.0: https://open.fda.gov/license/. Lists are joined with semicolons; dates are ISO. Do not rely on this data to make decisions regarding medical care; FDA says all results are unvalidated.
Details
- Publisher
- API Bay
- Category
- Health
- Source
- U.S. FDA openFDA drug NDC (download.open.fda.gov/drug/ndc)
- License
- CC0
- Updates
- One-time / static
- Coverage
- United States · 138,143 drug products · export 2026-10-27
- Size
- 138143 rows, 23 columns
- Version
- v1.0.0
- Last updated
- 2026-10-28
Columns
- product_id (Nullable(String))
- product_ndc (Nullable(String))
- spl_id (Nullable(String))
- generic_name (Nullable(String))
- brand_name (Nullable(String))
- brand_name_base (Nullable(String))
- brand_name_suffix (Nullable(String))
- labeler_name (Nullable(String))
- dosage_form (Nullable(String))
- route (Nullable(String))
- marketing_category (Nullable(String))
- application_number (Nullable(String))
- product_type (Nullable(String))
- dea_schedule (Nullable(String))
- finished (Nullable(Bool))
- active_ingredients (Nullable(String))
- pharm_class (Nullable(String))
- rxcui (Nullable(String))
- unii (Nullable(String))
- marketing_start_date (Nullable(Date32))
- marketing_end_date (Nullable(Date32))
- listing_expiration_date (Nullable(Date32))
- package_count (Nullable(Int32))
API
GET https://api.selectstar.wtf/v1/apibay/fda_ndc_product — send your API key in the LB-Access-Token header. Select columns with fc, filter with col=eq.value, page with ps and pg.