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
Paessler: Easy to Use With Enterprise Power. Free Trial
You shouldn't have to choose between a monitoring tool that's easy to use and one that's powerful enough for a complex environment. PRTG's low-code interface lets any admin build dashboards, set alerts and monitor devices without scripting, while custom sensors and full API access are there when your team needs deeper control. One platform, no compromise. Download a free 30-day trial now.
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).
