Page Banner

United States Department of Agriculture

Agricultural Research Service

SR27 - Home Page
headline bar

Release 27

This release of the USDA Nutrient Database for Standard Reference has been superseded. The current release is SR28.  Access to Release 27 of the USDA Nutrient Database for Standard Reference is provided here for those users who may wish to use it for historical reasons.

The suggested citation for this database is:

U.S. Department of Agriculture, Agricultural Research Service. 2014. USDA National Nutrient Database for Standard Reference, Release 27. Nutrient Data Laboratory Home Page, /ba/bhnrc/ndl

Full version

  • ASCII (6.4Mb) - This file contains the SR27 data in ASCII (ISO/IEC 8859-1), delimited files. These tables are organized in a relational format, and are best used with a relational database management system (RDBMS), which will allow you to form your own queries of the database and generate custom reports.

Since the release of SR27 in August 2014, we have identified a number of foods and nutrient values which were either in need of updating or not calculated properly.

A file containing the update files (sr27_upd052915.zip) is available for the ASCII version of the database.  It contains:  CHG_FOOD.txt, ADD_NUTR.txt, CHG_NUTR.txt, DEL_NUTR.txt, and CHG_ABBR.txt.

Users who have updated or plan to import the database into their applications will need use this update file to update the appropriate files.  The changes included in the May 2015 update for SR27 will be included in the update files disseminated with SR28.

  • ACCESS (15.6Mb) - This file contains the SR27 data imported into a Microsoft Access (2007 or later) database. It includes relationships between files and a few sample queries and reports.  This file has been updated with the May 2015 revisions.

     

  •  Abbreviated - This file contains data for all food items in SR27, but not all nutrient values--starch, fluoride, betaine, vitamin D2 and D3, added vitamin E, added vitamin B12, alcohol, caffeine, theobromine, phytosterols, individual amino acids, individual fatty acids, or individual sugars are not included.  These data are presented per 100 grams, edible portion.  Up to two household measures are also provided, allowing the user to calculate the values per household measure, if desired.

     

    • ASCII (1.1Mb; ISO/IEC 8859-1) - delimited file suitable for importing into many programs.  To update the file for the May 2015 revisions, you will need to download the update file described above.

    • Excel (2.9Mb) - for use with Microsoft Excel (2007 or later), but can also be used by many other spreadsheet programs.  This file has been updated with the May 2015 revisions.

  • Update Files - Contains updates for those users who have loaded Release 26 into their own programs and wish to do their own updates. These files contain the updates between SR26 and SR27. 
    • ASCII (1.0Mb; ISO/IEC 8859-1) - delimited file suitable for import into many programs.  To update your files with the May 2015 revisions you will also need to download the file: sr27_upd052915.zip  

Last Modified: 8/15/2016
Footer Content Back to Top of Page