All posts by NCC

NCC News Bite | January 2023


This edition contains the following articles:

Using NDSR to Assess Ultra-Processed Food Intake

We have heard from some of you that you are interested in identifying ultra-processed foods in your dietary data so that you can assess level of intake of foods considered ultra-processed according to the NOVA classification system.  While NDSR does not classify foods into NOVA classified categories, researchers could carry out this type of classification of foods entered into NDSR dietary recalls, records, or menus.  One way to do this with your NDSR output data files would be to identify the unique food IDs in output file 02, and then assign a classification level to each food based on resources such as the NCC Database Food Group ID and ingredient statements for restaurant and packaged foods.  If you are interested in more details on this potential approach for classifying foods in your NDSR dietary data, see the corresponding FAQ on the NCC website.



Resource for Knowing the Foods Unique to Specific Eating Traditions Included In NDSR

Researchers often ask us if we have foods commonly consumed by various groups of people when they are making their dietary assessment plan, and we have a new resource to help answer that question.  We recently added a list of “Foods Unique to Various Eating Traditions included in the NCC Food and Nutrient Database” to our website.
While this list is not all-encompassing, we did our best to categorize foods into some broad categories, such as Latin American and Caribbean foods, Alaska Native foods, and Eastern and Southeastern Asian foods, so you could look through and see what foods in that category we have in the database.  Note that the foods in our database are as they are prepared and consumed in the US and may vary from how they are prepared in other countries.  If you aren’t finding the foods you are looking for on this list, you can also search NDSR for specific foods, or search the foods2022.txt file located on your C Drive (if you have NDSR installed).
Are you finding some other foods coming up frequently in your research that aren’t in NDSR?  Please send your suggestions to anytime and our Database Scientists will consider these requests for inclusion in a future version of NDSR.



New! FAQs page on our NCC Website

Several of you responded to our most recent Client Survey with the request that we make it easier to find the FAQs on our website.  In response, we’ve tried to do just that!  Check out the new FAQs tab at the top of the NCC website.  That tab will take you to a central Frequently Asked Questions page where you can find all of our FAQs in one place.


NCC Welcomes New Staff Member: Katelin Raimondi

NCC recently hired a new member to our team!  Katelin Raimondi is a Registered Dietitian and has a Master’s of Science in Dietetics and Nutrition.  She has a variety of research and training experiences that will serve her as she learns about NDSR and supports our Research Services and User Support teams.  She will also become one of our NDSR Trainers.


FAQ Highlight: FODMAPS


Some of you have asked if NDSR can be used to estimate intake of FODMAPs (fermentable oligo-, di-, and monosaccharides and polyols).  Below is the answer from our FAQ page.  Please contact if you have further questions.
NDSR output files include intake estimates for monosaccharides (fructose, galactose, glucose, tagatose), disaccharides (lactose, maltose, sucrose) and a variety of polyols (erythritol, inositol, isomalt, lactitol, maltitol, mannitol, pinitol, sorbitol, xylitol).  Intake estimates for oligosaccharides are not available. Thus, intake of all types of FODMAPs except oligosaccharides may be estimated using data available in the output files.



New Foods


The following new foods are available to you at no additional charge with this edition of the NCC News Bite.  A New Foods Backup File is available for download on our website under New Food Backup Files, “January 2023”.
Beyond Meat Original Brat

Trader Joe’s Peanut Butter Filled Pretzels

Sara Lee Delightful Healthy Multi-Grain Bread

Skinny Pop Popcorn – Aged White Cheddar

Kirkland Cauliflower Crust Pizza – Supreme

Follow Your Heart Dairy Free Cheese – Smoked Gouda

Van’s Protein Waffles – Blueberry

Sweet Baby Ray’s BBQ Sauce – No Sugar Added


Can you use NDSR data to assess intake of ultra-processed foods?

NDSR does not classify foods into the four NOVA categories. However, a researcher may carry out this classification for foods entered into NDSR dietary recall, record, and menu record types. There are multiple ways this may be done. Sneed et al. report on one approach using their NDSR data (1). These authors assess inter-rater reliability and note that their data files are available to researchers on request. Below we describe another potential approach.
Potential approach for classifying foods in NDSR dietary recall, record and menu record types into the four NOVA categories.
1) For your set of dietary recalls/records/menus identify all unique food IDs in output file 02 (file that lists foods at the whole food level).
2) Sort the list of unique food IDs by the NCC Database Food Group ID* to facilitate coding.
3) Review the unique food IDs in your dataset, and then develop coding rules that will allow for classifying each food ID into one of the four NOVA categories.
Some of the coding rules you develop may leverage the NCC Database Food Group ID. For example, you may decide to specify in your coding rules that all foods with an NCC Database Food Group ID of 63 (‘Fruits, fresh and unsweetened’) be coded into the NOVA class 1 (‘Unprocessed or minimally processed’) category.
For some types of restaurant and packaged foods you may decide to develop coding rules that require going to the food company website to locate the food’s ingredient statement so that a classification determination may be made. Note that ingredient information is generally not available in output file 01 (component ingredient file) for packaged foods. Ingredient information is generally available for restaurant foods, but it should not be relied on for determining classification because NCC formulations for both packaged and restaurant foods include only those food ingredients that contribute to the nutrient content of the food. As a result, ingredients included in small amounts that do not contribute to nutrient content, such as most food flavorings, colorings, emulsifiers, and preservatives, are generally not included in the formulation.
For some types of restaurant and packaged foods you may develop general rules that do not require locating the product ingredient statement. For example, you may establish a rule that all soft drinks be coded into NOVA class 4 because these products are generally formulated in a way that involves including one or more ingredients that conform with class 4 criteria.
For multi-ingredient home prepared foods (e.g. home-made lasagna, pizza, cookies, etc.) the ingredients used in preparing the food are available in output file 01 (component ingredient file), and may be used to guide food coding decisions for these types of foods.
4) After NOVA classification codes have been assigned to all unique food IDs in file 02, statistical analysis code may be written to assign NOVA classification codes to all foods in all records in file 02. Then, code may be written to create processed food variables of interest for your study (e.g. times per day ultra-processed foods were consumed; percent of total calories from ultra-processed foods, etc.).
* The NCC Database Food Group ID’s, categories, and names are provided in the NDSR file ‘Nccdbfg[insert version].txt in the ‘Database Documentation Files’ folder within the ‘Additional Files’ folder. For Windows installations, the Additional Files are located at C:\Users\Public\Documents\NCC\NDSR [insert version]\Additional Files\Database Documentation.
1. Sneed NM, Ukwuani S, Sommer E, Samuels L, Truesdale K, Matheson D, Noerper T, Barkin S, Heerman W. Reliability and Validity of Assigning Ultra-Processed Food Categories to 24-Hour Dietary Recall Data Collected Using the Nutrition Data System for Research (NDS-R). Current Developments in Nutrition 2022;6:778.

There are two added sugar variables in the NDSR output files- Added Sugars (by Available Carbohydrate) and Added Sugars (by Total Sugars). What is the difference between the two?

Added Sugars are those sugars and syrups added to foods during food preparation or commercial food processing. Ingredients designated as “added sugar” foods in the NCC database include: white sugar (sucrose), brown sugar, powdered sugar, honey, molasses, pancake syrup, corn syrups, high fructose corn syrups, invert sugar, invert syrup, malt extract, malt syrup, fructose, glucose (dextrose), galactose, and lactose. They do not include mono- and disaccharides occurring naturally in foods, such as lactose in milk or fructose in fruit.
The Added Sugars (by Available Carbohydrate) value assigned by NCC to foods considered to be sources of added sugars represents the amount of available carbohydrate present in the food, which includes saccharides of all types. Mono- and disaccharides along with saccharides with a higher degree of polymerization that are resistant to digestion (e.g., trehalose) are included under this definition.

For example, corn syrups with different Dextrose Equivalency (DE) contain a high amount of trisaccharides and other higher saccharides (approximately 75%) due to the incomplete hydrolysis of the cornstarch. These more complex sugars are included under Added Sugars (by available carbohydrate).
The Added Sugars (Total Sugars) value assigned by NCC to foods considered to be a sources of added sugars represents the amount of total sugars present in the food, which includes only mono- and disaccharides.

The nutrient values for brand name food products in the database don’t precisely match the values on the product’s Nutrition Facts panel. Why?

Nutrient values in the NCC Food and Nutrient Database for brand name foods do not precisely match the information on product Nutrition Facts panels for a number of reasons. One reason is that values in the database are not rounded to the nearest whole number as is allowed on the Nutrition Facts panel. Another reason is the database values may not reflect recent changes in the marketplace. For example, if General Mills reformulates Cheerios® today, the nutrient values in the current database may no longer match those on the product label. Discrepancies between database and Nutrition Facts panel values may be due to use of the nutrient composition of representative foods for some brand name product categories for which the nutrient composition across brands is similar.
As an example, although the database includes several brands of pretzel twists, the nutrient values assigned to each are based on a representative pretzel twist. It is important to note that use of a representative food is only done when variation in nutrient content across brands of a product is minimal.

The database includes several brand name products in some food product categories such as snack crackers but no brand name products in other categories such as canned and frozen vegetables. Why?

Brand name products are included if there are significant differences in the nutrient composition of food products within a category. For example, different brands of potato chips are included in the database because the fatty acid content of chips varies notably across brands. Another reason for including brands relates to how people tend to describe the food. For example, commercial cookies tend to be described by brand name (e.g., Oreo® cookie) rather than by generic food description (e.g., chocolate sandwich cookie).

How does NCC decide whether to add new nutrients or food components to the database?

The following factors are considered in deciding whether to add a nutrient or other food component to the database:

  • Scientific Interest: Is there demand for it? If there is a nutrient or food component you’d like added to the database please let us know(
  • Availability of Food Composition Information: Is there analytic composition information available for a significant proportion of core foods in the NCC Food and Nutrient Database?
  • Quality of Analytic Data: Is the analytic information available of sufficient quality (e.g., obtained using appropriate analytic methods) for use in assigning values to foods in the NCC Food and Nutrient Database?

How does NCC assign nutrient values to unknown foods, and how can I figure out what food is being used as the ‘default’ for unknown foods?

In the NCC Food and Nutrient Database there are foods defined as ‘unknown’ (e.g., ‘milk, unknown % fat’). These foods may be selected when a participant does not know the level of detail required for a food.


To assign nutrient values to unknowns NCC uses the nutrient values for the form of the food that is believed to be most commonly consumed in the U.S. For example, the nutrient values for 2% milk are utilized for ‘milk, unknown % fat’. To decide what is most common, NCC relies on scientific and food industry publications that report dietary intake patterns and product sales. Professional judgment is also used where published data is lacking.


If you need to know what food an unknown food defaults to you can look in the output files. The Food File (output file 02) lists the food as it was selected (e.g., milk, unknown % fat). The Component/Ingredient File (output file 01) lists the default food that is associated with the unknown food (e.g., milk, 2 % fat). To quickly identify unknown foods in your dataset use the column in file 2 labeled ‘Unknown (default) Food’. If a food is an unknown there will be a ‘1’ in this column.

Can NDSR be used to estimate intake of FODMAPs (fermentable oligo-, di-, and monosaccharides and polyols)?

NDSR output files include intake estimates for monosaccharides (fructose, galactose, glucose, tagatose), disaccharides (lactose, maltose, sucrose) and a variety of polyols (erythritol, inositol, isomalt, lactitol, maltitol, mannitol, pinitol, sorbitol, xylitol). Intake estimates for oligosaccharides are not available. Thus, intake of all types of FODMAPs except oligosaccharides may be estimated using data available in the output files.

How do I open my output in Microsoft Excel and view it?

If you plan to analyze your data using Excel, you may want to generate the output files with the headers. Once you have generated the output, you will first need to extract the output files. Then open Excel, select Open from the File menu, and browse to the location of the output file you wish to open. Change the “All Excel Files” option to “All Files” in the drop down menu above the Open button, then select the file you want to open. A Text Import Wizard in Excel will pop up and should already recognize that the .txt files are tab delimited. Select “finish” to open the file.

Why are the grains in ounce equivalents columns blank?

The USDA Food Pattern Equivalent grain variables (total, whole, and refined grains) will not be calculated for data collected from versions prior to NDSR 2013. If older data are rerun, the grain per ounce equivalent categories will be in the output files, but data will be missing or blank for these variables. See “The USDA Food Patterns Equivalents Grain Variables” in Appendix 10, Food Grouping” for more information on equivalent grain variables.