|SR27 - Download Files|
All files are compressed using PKZip, you can view the compressed file and extract the contents using Windows Explorer on your PC.
Documentation for the database is available here as a PDF file or in each of the download files listed below. PDF files can be read using the Acrobat reader which is available free. To install a PDF viewer in your web browser read, "Steps to Downloading the Free Acrobat Reader"
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.