• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!


Case Study - Food Database

Page history last edited by Dr. Ron Eaglin 8 years ago

Case Study - Food Database


Assignments, Lectures, and Support Materials for the Food Database are on this page.The food database contains food nutritional content for about 2000 foods that were compiled by the USDA. Full details of the data are available at data.gov and the raw data (including extra files for different classes of foods) are available at the data.gov site.


I'm also making this data set available here as a Excel file. Food-data.xlsx


About Nutrition Databases


The US government (through the USDA) makes nutrition data publicly available. Though most consumers will have a hard time working with this data - you are a database professional and data scientist. Here are some incredible sources of data for you to use;


USDA National Nutrient Database - Find nutrient information on nearly 9,000 foods.




These lectures use the Food Database.


Lecture - Database and Aggregations


Lecture - Importing Data Into SQL Server


Lecture - Advanced Query - WITH Clause




These assignments require use of the Food Database


Spring 2013 COP4709 Assignment 9


Comments (0)

You don't have permission to comment on this page.