Skip to main content
U.S. flag
An official website of the United States Government.
Dot gov

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

SSL

Secure .gov websites use HTTPS
A lock (LockA locked padlock) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

USDA-FNS
  • COVID-19
  • Contact Us
  • Report Fraud
  • Ask USDA
  • USDA.gov
USDA-FNS
  • Home
    • Data & Research
    • Research & Analysis
    • Program Data
    • Child Nutrition Tables
    • Food Distribution Program Tables
    • SNAP Tables
    • Puerto Rico NAP Tables
    • WIC Data Tables
    • Grants
    • Financial Management
    • Newsroom
    • Farm Bill
    • Federal Register Documents
    • FNS Blogs
    • FNS Infographics
    • FNS Press Releases
    • Notice to Stakeholders
    • USDA Press Releases
    • USDA Blogs
    • Webinars & Videos
    • Contact FNS Press Office
    • Resources
    • Fact Sheets
    • Federal Register
    • Guidance Documents
    • Policy Memos
    • Videos/Webinars
    • All Resources
    • Our Agency
    • Contact us
    • Civil Rights
    • Core Nutrition Messages
    • FNS Partnerships
    • Freedom of Information Act
    • FNS Human Resources
    • State Systems Office
    • Programs
    • Child and Adult Care Food Program
    • Center for Nutrition Policy and Promotion
    • Community Food Systems
    • Commodity Supplemental Food Program
    • Farmers Market Nutrition Program
    • FNS Disaster Assistance
    • Food Distribution Program on Indian Reservations
    • Fresh Fruit and Vegetable Program
    • Food Safety
    • National School Lunch Program
    • School Breakfast Program
    • Senior Farmers' Market Nutrition Program
    • SNAP
    • Special Milk Program
    • Summer Food Service Program
    • Team Nutrition
    • TEFAP
    • USDA Foods in Schools
    • WIC

Child Nutrition Database

Breadcrumb

  1. Home
  2. Team Nutrition
Resource type
Technical Assistance
Resource materials
CNDB_Documentation_CN23.pdf
CN23_NUTDES.csv
CN23_FDES.csv
CN23_NUTVAL.csv
CN23_CTGNME.csv
CN23_WGHT_rev.csv
laptop computer

The Child Nutrition Database (CNDB) is a required part of the nutrient analysis software approved by USDA for use in the National School Lunch Program and School Breakfast Program. It is a nutrient database of over 10,000 food items.

The CNDB includes food product nutrient data collected for the following 18 nutrients: calories, total fat, saturated fat, trans fat, cholesterol, sodium, carbohydrate, dietary fiber, protein, vitamin A, vitamin C, vitamin D, calcium, potassium, iron, ash, total sugars, and moisture.

The CNDB includes nutrient data from the USDA National Nutrient Database for Standard Reference (SR) Legacy Release, data for the USDA Standardized Recipes and USDA Foods, and data collected from food manufacturers for products produced for and marketed to school food service.

The CNDB is usually updated once each year in the spring. Software companies with nutrient analysis software approved by USDA are required to update their software with the current release of the CNDB.

The 23rd Release of the CNDB (CN23) is available. USDA-approved software must be updated to include CN23.

Download the Current Version of the Child Nutrition Database

The most recent version (CN23) of the CNDB is available on this website as a CSV (comma-separated values) format. To download this version of the CNDB please right-click on the link for each CSV file (one file per database table) and “save target as…”. Please also download the Child Nutrition Database Documentation document that explains the tables and fields in this database.

  • Food Description Table (FDES)*
  • Food Category Name Table (CTGNME)
  • Weights Table (WGHT_rev)**
  • Nutrient Values Table (NUTVAL)
  • Nutrient Description Table (NUTDES)
  • Child Nutrition Database Documentation

*Note: If opening the CN23 CSV FDES file in Excel, this file must be opened from your file manager (File Explorer or Finder) or imported into Excel, not opened with “Open” from within Excel.

**Note:  The revised file for the Weights table (WGHT_rev.csv) corrects an error in the Measure_Desc value for CN_Code: 51685.

The CNDB is also available in additional file formats to software developers on the CNP Approved Nutrition Software PartnerWeb (SharePoint) site and to other interested persons upon request.

For additional information about the CN Database, contact us at cnpntab@usda.gov.

Data is collected by use of the following OMB approved data collection process:

FNS-710
OMB Number: 0584-0494
Expiration: Jan. 31, 2021

05/07/2020
  • Home
  • Data & Research
  • Grants
  • Newsroom
  • Resources
  • Our Agency
  • Programs
  • USDA
  • USA.gov
  • WhiteHouse.gov
  • FNS PartnerWeb.gov
  • No Fear Act
  • Privacy Policy
  • Non-Discrimination Statement
  • Civil Rights
  • FOIA
  • Information Quality
  • Peer Review
  • Accessibility

Sign up for Updates

USDA-FNS
  • Twitter
  • Facebook
  • Gov Delivery
  • Instagram
  • Flickr
  • Youtube