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
Full-stack observability with actually useful AI | Grafana Cloud
Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.
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).
