All datasets

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.