Child Nutrition Database Release 18
(Final version posted March 25, 2014)
The Child Nutrition Database (CN-D) is required to be part of the nutrient analysis software approved by USDA for use in the National School Lunch Program and School Breakfast Program.
Data is collected on the following 16 nutrients: calories, total fat, saturated fat, trans fat, cholesterol, sodium, carbohydrate, dietary fiber, protein, vitamin A, vitamin C, calcium, iron, ash, sugars, and moisture.
CN19 is in progress. Data collection for CN19 closed on 12/5/14. Data collected after 12/5/14 will be included in CN20.
Food Manufacturers: Click here to add nutrient data to the CN Database for foods sold in the school market. You now need a Level 1 USDA eAuthorization account to access the Online Web Tool for Submitting Nutrient Data. When you go to the link above, click Register to obtain your eAuth account. When you return to submit data, select Sign In.
Comments and Notes for CN18 Release
CN18 Release: A record with a date after 07/31/2013 in the "date_added" field is a new record in the CN18 release. A record with a date after 07/31/2013 in the "last_modified" field and different from the date in the "date_added" field contains a revised value in one or more of its fields with the CN18 release.
142 food item (FDES) records, 1,185 weights (WGHT) records, and 13,653 nutrient value (NUTVAL) records marked "d" in CN17 were removed from CN18. The 13,653 deleted NUTVAL records includes 11,881 Vitamin A(RE) values (392), maked "d" in CN17. The 1,185 deleted WGHT records includes 952 records with a gram weight of 100 and a serving amount and description inconsistent with a 100 gram weight.
The length of the "MEASURE_DESCRIPTION" field in the "WGHT" file has been increased from 80 to 100 characters to accommodate newly added weight values from the National Nutrient Database for Standard Reference, Release 26 (SR26) whose measure description field ¬exceeds 80 characters.
In CN18, Total Sugars has been added as a nutrient in the NUTDES file, and values for total sugars, if available for National Nutrient Database for Standard Reference (SR) items (source code 1) have been added to the NUTVAL file.
4,620 new foods have been added to CN18 from SR26. This includes 374 new items added to SR26, and 4,246 existing SR foods which did not have values for the previously required 12 nutrients but do have values for the currently required three nutrients.
All modified data from SR26, including food descriptions, weights, and nutrient values has been applied to CN18.
System Components and File Formats (documentation)
(MS Word) (plain text)
Child Nutrition Database in Access Format
(right click and choose "Save Target As" or "Save Link As")
This file includes all the components listed below under the Comma Delimited Format
Child Nutrition Database in Plain Text Format
Please submit any issues or concerns regarding the Child Nutrition (CN) Database to:
Healthy Meals Resource System