I'm looking for a free or paid food database, that fits my needs below. Does anyone have any leads?

As far as a food database goes, I think there are probably three tiers of abstraction that a food database could have (#1: Basic food ingredients, #2: Basic food Products, #3: Specific Branded and FDA Labeled Food Products). See below for an explanation of what I mean by each of these.

Every food database I've come across is of Abstraction Type #3 (Specific Branded Food Products). Does anyone know of any food database available that is of abstraction levels #1 or #2, as described below? I'm trying to ask users generally about their diets, and I don't want a database that deals with brands and measurements of food.


#1 Basic food ingredients (DESIRED)
something like "banana, apple, wheat, corn, rye, potato, high fructose corn syrup, cane sugar, honey, milk, yogurt, olive oil, vinegar, salt, pepper, bell pepper, jalepenos, kidney beans, green beans, navy beans"
In other words, it would be a combined list of:
-Vegetables
-Fruits
-Legumes
-Grains
-Dairy Products (milk, yogurt, butter)
-Oils
-Refined Food Products (cane sugar, high fructose corn syrup)
-Spices & Herbs (salt, pepper, oregano)
-Sweets? (chocolate)

#2 Basic food PRODUCTS (DESIRED)
this might look like: cereal, oatmeal, lasagna, pasta, hamburger, cheeseburger, salad, hot dog, apple juice, orange juice, tea, coffee, ice cream, frozen yogurt, chow mein, chips, crackers, ...

#3 Specific BRANDED and FDA Labeled Food Products (NOT desired)
These would be foods that would look something like "Kroger's Raisin Bran (16 oz.), Lean Cuisine Meatball Lasagna (12 oz.)"


I want a food database that matches the descriptions of #1 above. If there's one that matches #2, that's pretty good too. But I definitely don't want a food database that matches #3.

Anyone have any links to such a food database? Or just a very long list of food on a website somewhere? Any leads appreciated!

Thanks in advance,
Sean

Have you looked here: http://www.fao.org/infoods/tables_int_en.stm

In reviewing this topic superficially, I've noticed that there is a pretty clear tradeoff between:

1. An easily accessed, standard format database available for a variety of mash-ups/uses.
2. An accurate, comprehensive assessment of food composition at a fine level of detail.

What you gain in simplicity you lose in precision....

I'm interested in what you find out as you search for a solution. Please share your results and feel free to refine your question.

Most of the food databases I've come across contain all three abstractions. Maybe the distinguishing characteristic you're looking for is that the database is offline, or has an API?

Here are some examples of online food databases; maybe one will fit your needs (or maybe you find an API for one, or write/find a web scraper):

http://www.livestrong.com/thedailyplate/...a&mode=tdp - LiveStrong's TheDailyPlate. I was involved with them for about a year in 2009. They accept user submissions, which are later "verified". The verification process at some point used Amazon's Mechanical Turk, with poor results. In 2009 I proposed they encourage users to submit photos of the nutrition label, so anyone could verify on their own. As far as I know, they haven't done that. Rather, verifications are done by moderators.

http://dailyburn.com/nutrition/food_search - there's a checkbox to only search USDA foods.

http://caloriecount.about.com/cc/search....hpro=apple

http://fatsecret.com/calories-nutrition/search?q=banana

http://www.thecaloriecounter.com/
http://www.fitday.com/webfit/nutrition/BrwsFoods.html - small database. In her excellent post here on weight loss, Naomi agrees.

There are way more food databases, but as Gary says, the question may need refinement.

I"m familiar with and have used Calorie Count, LiveStrong and DailyBurn. DailyBurn is the best tool I've used in 5+ years of nutrition/calorie tracking.

Sean - are these tools adequate for your needs. If not, tell us a bit more about what you are looking for?

mynetdiary.com is the one I use after 2 years of doing this and switching back and forth among the lot.

The FDA has an 'official' database of foods and calories if you're building an app.

(2011-Jul-15 12:04)seanahrens Wrote:  I'm looking for a free or paid food database, that fits my needs below. Does anyone have any leads?

Thanks for all your replies, Gary, Dan, Robert, and Burtonator. I'm looking through all the links you sent me now.

To add some context and clarify, I am looking for a database to use on the backend of my website: Crohnology - A Site to Learn about Crohn's & Colitis Diets & Treatments. I'm a software developer and will import the food dataset into a table in my backend, so that users of this site can select what foods make their disease flare up, and what foods comfort them. Having this as relational data allows me to do much more interesting things with the information, than if I asked users to just enter these foods into a freeform textbox.

I want the user to be able to enter that one of their trigger foods are "bananas" or "cheese", and literally just have one option for them to select come up. See http://bodday.com/, for a great example of how this site simplifies the food options / analysis. Having 20+ different alternate entries / variations for "banana", like many of the datasets I've found, will only serve to confuse my user interface (it is unneeded complexity).

What I realized shortly after asking the question, is that when I asked it, I was really not looking so much for a "database", but in my head, merely a list. A simple list of foods. In other words, metadata (calories, nutritional breakdown) not needed, just the name. Although, upon reflection, I realized that this nutritional metadata is probably the main reasons these databases exist in the first place. And now I suppose if I had some nutritional metadata on these foods it would be a good thing.

Alright, now that I've clarified my question, I'll get back to reviewing the links you guys sent. Thanks! Let me know if this added context changes your suggestions! Thanks!

P.S. an API also works, but a dataset might be preferable.

---

Upon review, it looks like none of the presented solutions yet fit the bill. I'm beginning to wonder if this is a database I'm going to have to create on my own. The links that Dan mentioned are sorta okay for what I'm after in regards to the data content (although most of them are still more complex than I'm after), but the big caveat here is that they are all web-based tools, not easily (or maybe legally) downloadable datasets.

http://fatsecret.com/calories-nutrition/search?q=banana
http://www.thecaloriecounter.com/
http://www.fitday.com/webfit/nutrition/BrwsFoods.html

The dataset you linked me to, Gary, is unfortunately simultaneously too complex in some categories (too many slightly different food options), and incomplete in others (no food options in many food categories).

I've talked to the developer of http://bodday.com/ (which performs like I'd desire my app too), and he mentioned he had to mostly create his own database to get this level of simplicity.

If anyone has any leads given this new info, would love to know.

Thanks for your help so far guys.

Thanks Sean for this really good clarification. I think you are hitting on a key problem with the personal data ecosystem in general. We are all dependent on competent performance of neighboring layers, and would benefit from standardization on these layers, but "competent" turns out to depend heavily on the use case, and use cases vary quite a lot in the details. This works against standardization. So there are a lot of people "rolling their own" in all areas. The lesson from previous rounds of tech evolution is that it's unrealistic to expect not to have to break down and recompose your system several times to accommodate the evolving architecture. It won't be pretty, but that's what we're in for. In other words, you probably WILL have to create your own database to "speedily" move on with your project, and then replace it down the road if a standard emerges. This is not the answer you probably wished for, but at least having a clear view can allow you to allocate "just enough" time to it, knowing it isn't a permanent solution. At the detail level, designing for modularity will also help you in the future when the standards change. (This is easier said than done, I know.)

In the United States, you will probably want to look at the USDA FNDDS--you can download the CSVs or an MSAccess DB here: http://www.ars.usda.gov/Services/docs.htm?docid=12089
I believe it has everything you are looking for...except it is limited with respect to ethnic foods. We need to get it harmonized with the EuroFIR and the Brazilians and India as well.

(2011-Jul-20 15:50)mateolan Wrote:  In the United States, you will probably want to look at the USDA FNDDS--you can download the CSVs or an MSAccess DB here: http://www.ars.usda.gov/Services/docs.htm?docid=12089
I believe it has everything you are looking for...except it is limited with respect to ethnic foods. We need to get it harmonized with the EuroFIR and the Brazilians and India as well.

this one isn't too shabby; i tried out test searches by signing up for mypyramidtracker. i'll have to work around the fact that the downloads are .exe files (i'm primarily on OS X). if the database flags branded food products differently than food ingredients, i can probably ignore the branded food products when i hook it up to my search functionality. thx for this.

still open to other suggestions, but somewhat pleasantly surprised by this. thx Mateolan.

you may want to look again, like I said, you can download the csv files...

(2011-Jul-21 08:22)seanahrens Wrote:  

(2011-Jul-20 15:50)mateolan Wrote:  In the United States, you will probably want to look at the USDA FNDDS--you can download the CSVs or an MSAccess DB here: http://www.ars.usda.gov/Services/docs.htm?docid=12089
I believe it has everything you are looking for...except it is limited with respect to ethnic foods. We need to get it harmonized with the EuroFIR and the Brazilians and India as well.

this one isn't too shabby; i tried out test searches by signing up for mypyramidtracker. i'll have to work around the fact that the downloads are .exe files (i'm primarily on OS X). if the database flags branded food products differently than food ingredients, i can probably ignore the branded food products when i hook it up to my search functionality. thx for this.

still open to other suggestions, but somewhat pleasantly surprised by this. thx Mateolan.

update: http://swole.me/ is a good resource and example of how a human-readable abstraction on food in action. I still haven't found the perfect solution, but I've held of my search for now.

Hey guys, update:

The University of Minnesota's Food & Nutrition Database (http://www.ncc.umn.edu/products/database.html) seems like it might be a really great option. I'm looking into it. It seems to have this idea I was interested in: a "core foods" database as they call it.

(2011-Jul-15 12:04)seanahrens Wrote:  I'm looking for a free or paid food database, that fits my needs below. Does anyone have any leads?

As far as a food database goes, I think there are probably three tiers of abstraction that a food database could have (#1: Basic food ingredients, #2: Basic food Products, #3: Specific Branded and FDA Labeled Food Products). See below for an explanation of what I mean by each of these.

Every food database I've come across is of Abstraction Type #3 (Specific Branded Food Products). Does anyone know of any food database available that is of abstraction levels #1 or #2, as described below? I'm trying to ask users generally about their diets, and I don't want a database that deals with brands and measurements of food.


#1 Basic food ingredients (DESIRED)
something like "banana, apple, wheat, corn, rye, potato, high fructose corn syrup, cane sugar, honey, milk, yogurt, olive oil, vinegar, salt, pepper, bell pepper, jalepenos, kidney beans, green beans, navy beans"
In other words, it would be a combined list of:
-Vegetables
-Fruits
-Legumes
-Grains
-Dairy Products (milk, yogurt, butter)
-Oils
-Refined Food Products (cane sugar, high fructose corn syrup)
-Spices & Herbs (salt, pepper, oregano)
-Sweets? (chocolate)

#2 Basic food PRODUCTS (DESIRED)
this might look like: cereal, oatmeal, lasagna, pasta, hamburger, cheeseburger, salad, hot dog, apple juice, orange juice, tea, coffee, ice cream, frozen yogurt, chow mein, chips, crackers, ...

#3 Specific BRANDED and FDA Labeled Food Products (NOT desired)
These would be foods that would look something like "Kroger's Raisin Bran (16 oz.), Lean Cuisine Meatball Lasagna (12 oz.)"


I want a food database that matches the descriptions of #1 above. If there's one that matches #2, that's pretty good too. But I definitely don't want a food database that matches #3.

Anyone have any links to such a food database? Or just a very long list of food on a website somewhere? Any leads appreciated!

Thanks in advance,
Sean

---

Thanks for adding the post on the University of Minnesota's Food & Nutrition Database. Have you come across a database that has the QR codes for the same type of products?

Also, are you using the University of Minnesota's Food & Nutrition Database? And are you happy with it?

Thanks.
Mike

I am not yet using the UoMinnesota Database (mostly just been a reprioritization thing). Haven't seen anything with QR codes yet.