This is the database of foods and their nutrients released by the US Government, (currently version SR23) published by the USDA, in MySQL dump form. edit: Currently full table (no longer abbreviated table) but no keys, indexes, constraints yet.

Project Activity

See All Activity >

License

BSD License

Follow USDA Nutrient Data SR23 SQL dump port

USDA Nutrient Data SR23 SQL dump port Web Site

Other Useful Business Software
$300 Free Credits to Build on Google Cloud Icon
$300 Free Credits to Build on Google Cloud

New customers can spin up VMs, build with AI, and query data at no cost.

Put your $300 in credit toward real workloads, then keep building with free monthly usage for 20+ products. No commitment and no charge until you upgrade.
Start Free
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
★
1
0
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5

User Reviews

  • 5 out of 5 stars
    good effort so far! Here are the primary key defs needed: ALTER TABLE `sr23`.`DATA_SRC` ADD PRIMARY KEY (`DataSrc_ID`); ALTER TABLE `sr23`.`DERIV_CD` ADD PRIMARY KEY (`Deriv_Cd`); ALTER TABLE `sr23`.`FD_GROUP` ADD PRIMARY KEY (`FdGrp_Cd`); ALTER TABLE `sr23`.`FOOD_DES` ADD PRIMARY KEY (`NDB_No`); ALTER TABLE `sr23`.`LANGDESC` ADD PRIMARY KEY (`Factor_Code`); ALTER TABLE `sr23`.`LANGUAL` ADD PRIMARY KEY (`NDB_No`,`Factor_Code`); ALTER TABLE `sr23`.`NUTR_DEF` ADD PRIMARY KEY (`Nutr_No`); ALTER TABLE `sr23`.`NUT_DATA` ADD PRIMARY KEY (`NDB_No`,`Nutr_No`); ALTER TABLE `sr23`.`SRC_CD` ADD PRIMARY KEY (`Src_Cd`); ALTER TABLE `sr23`.`WEIGHT` ADD PRIMARY KEY (`NDB_No`,`Seq`); (assuming you name the database sr23).
Read more reviews >

Additional Project Details

Intended Audience

Developers

Registered

2010-11-23