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
Veeam Data Platform v13.1 - Get Your Free Trial
Try Veeam Data Platform today. Experience the unified platform that's secure by design, portable by default, and proven to recover clean, fast, and anywhere.
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).
