Child Nutrition Database Release 19
(Final version posted June 22, 2015)
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.
The online tool is open to collect data for the Child Nutrition Database, Release 20 (CN20). Any data entered after December 5, 2014 will be incorporated into CN20. The tool will no longer be closed in the transition period between releases, but will remain open for data entry.
Food Manufacturers: Click here to add nutrient data to the CN Database for foods sold in the school market. You now need a Level 2 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 CN19 Release
CN19 Release: A record with a date after 01/18/2014 in the “date_added” field is a new record in the CN19 release. A record with a date after 01/18/2014 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 CN19 release.
103 food item (FDES) records, 156 weights (WGHT) records, and 17,114 nutrient value (NUTVAL) records marked “d” in CN18 were removed from CN19. The 17,114 deleted NUTVAL records includes 15,481 Vitamin A(RAE) values (320), marked “d” in CN18.
300 new food items have been added to CN19 from SR27.
All modified data from SR27, including food descriptions, weights, and nutrient values has been applied to CN19.
165 new source code 3 (food industry) food items have been added to CN19. Outdated source code 3 food items added to the CN-D before March 2011 have been marked ‘d’ in CN19.
The DQC file was not updated to the current required nutrients and was removed for CN19. It may be added back in a later version.
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