2,956
edits
Code:food2.sql: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
* [[Code:fao2usda.csv]] | * [[Code:fao2usda.csv]] | ||
* [[:File:sr28-collated.csv]] | * [[:File:sr28-collated.csv]] | ||
* [[:File: | * [[:File:fao-livestock-primary.csv]] | ||
| Line 14: | Line 14: | ||
.mode csv | .mode csv | ||
-- cross-reference table 2: livestock products (FAO data) with foods (USDA nutrition data): | -- cross-reference table 2: livestock products (FAO data) with foods (USDA nutrition data): | ||
.import fao2usda.csv | .import fao2usda.csv fao2usda | ||
-- nutrition (USDA): | -- nutrition (USDA): | ||
.import data/sr28-collated.csv | .import data/sr28-collated.csv usda | ||
-- crop production (FAO): | -- crop production (FAO): | ||
.import data | .import data/fao-livestock-primary.csv animal | ||
.mode list | .mode list | ||