2,956
edits
Code:food1.sql: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
This is ''sqlite code'' to analyze the production of [[food]] crops and nutrition. Data is mostly from [https://fao.org FAO] and [https://usda.gov USDA]. | This is ''sqlite code'' to analyze the production of [[food]] crops and nutrition. Data is mostly from [https://fao.org FAO] and [https://usda.gov USDA]. | ||
Dependencies | Dependencies (data files as input) | ||
* [[Code:fao_usda.csv]] | * [[Code:fao_usda.csv]] | ||
* [[:File:sr28-collated.csv]] | * [[:File:sr28-collated.csv]] | ||
* [[:File: | * [[:File:fao-crops-primary.csv]] | ||
* [[:File: | * [[:File:API_SP.POP.TOTL_DS2_en_csv_v2_4150863.csv]] | ||
* [[:File:global-hunger-index-2021.csv]] | * [[:File:global-hunger-index-2021.csv]] | ||
* [[:File: | * [[:File:country-and-continent-codes-list-csv_csv.csv]] | ||
See more notes below the code. | See more notes below the code. | ||
| Line 23: | Line 23: | ||
.mode csv | .mode csv | ||
-- cross-reference: crops (FAO data) with foods (USDA nutrition data): | -- cross-reference: crops (FAO data) with foods (USDA nutrition data): | ||
.import fao_usda.csv | .import fao_usda.csv fao_usda | ||
-- 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-crops-primary.csv fao | ||
-- population of regions (World Bank): | -- population of regions (World Bank): | ||
.import data | .import data/API_SP.POP.TOTL_DS2_en_csv_v2_4150863.csv pop | ||
-- global hunger index (.com) | -- global hunger index (.com) | ||
.import data/global-hunger-index-2021.csv | .import data/global-hunger-index-2021.csv ghi | ||
-- region codes: | -- region codes: | ||
.import data | .import data/country-and-continent-codes-list-csv_csv.csv region | ||
.mode list | .mode list | ||