Download
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.
License
BSD LicenseFollow USDA Nutrient Data SR23 SQL dump port
Other Useful Business Software
Build Agents and Models on One Platform
Gemini Enterprise Agent Platform is Google Cloud's comprehensive platform for developers to build, scale, govern, and optimize agents and models. Choose from Google's most advanced models and third-party models like Anthropic's Claude Model Family.
Rate This Project
Login To Rate This Project
User Reviews
-
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).
