View source for FAOSTAT Trade Crops and livestock products

__FORCETOC__

== Summary ==
[https://www.fao.org/faostat/en/#home FAOSTAT] gives users access to food and agriculture data for over 245 countries and territories. Additionally, it covers all FAO regional groupings from 1961 to the most recent year available. Users are able to select different indicators from a variety of different domain groupings including Production, Investment, and Trade.

== Tables In IFs ==
{| class="wikitable"
|Variable
|Definition
|Ext. Definition
|Unit
|Source
|Original Source
|Preprocessor
|Preprocessor Name
|-
|AgCropExportQuantityFAOTrade
|Quantity of Crops Exported (Tonnes) from FAO Trade Domain
|Quantity of crops exported (Tonnes) from FAO Trade Domain, collapsed to  match FAO FBS categories in IFs
|Tonnes
|FAOSTAT, Trade Domain
|<nowiki>https://www.fao.org/faostat/en/#data</nowiki>
|1
|AGRICULTURE
|-
|AgCropExportValue%GDPFAOTrade
|Value of Crops exported as a percent of GDP from FAO Trade Domain
|value of crops exported (1000$ US) from FAO Trade Domain, as a percent of  GDP at current $ from WDI, collapsed to match FAO FBS in IFs
|Percent
|FAOSTAT, Trade Domain
|<nowiki>https://www.fao.org/faostat/en/#data</nowiki>
|1
|AGRICULTURE
|-
|AgCropImportQuantityFAOTrade
|Quantity of Crops Imported (Tonnes) from FAO Trade Domain
|Quantity of crops imported (Tonnes) from FAO Trade Domain, collapsed to  match FAO FBS in IFs
|Tonnes
|FAOSTAT, Trade Domain
|<nowiki>https://www.fao.org/faostat/en/#data</nowiki>
|1
|AGRICULTURE
|-
|AgCropImportValue%GDPFAOTrade
|Value of Crops Imported as a percent of GDP from FAO Trade Domain
|value of crops imported (1000$ US) from FAO Trade Domain, as a percent of  GDP at current $ from WDI, collapsed to match FAO FBS in IFs
|Percent
|FAOSTAT, Trade Domain
|<nowiki>https://www.fao.org/faostat/en/#data</nowiki>
|1
|AGRICULTURE
|-
|AgMeatExportQuantityFAOTrade
|Quantity of meat exported (Tonnes) from FAO Trade Domain
|Quantity of meat exported (Tonnes) from FAO Trade Domain, collapsed to  match FAO FBS in IFs
|Tonnes
|FAOSTAT, Trade Domain
|<nowiki>https://www.fao.org/faostat/en/#data</nowiki>
|1
|AGRICULTURE
|-
|AgMeatExportValue%GDPFAOTrade
|Value of meat exported as a percent of GDP from FAO Trade Domain
|Value of meat exported (1000$ US) from FAO Trade Domain, as a percent of  GDP at current $ from WDI, collapsed to match FAO FBS in IFs
|Percent
|FAOSTAT, Trade Domain
|<nowiki>https://www.fao.org/faostat/en/#data</nowiki>
|1
|AGRICULTURE
|-
|AgMeatImportQuantityFAOTrade
|Quantity of Meat Imported (Tonnes) from FAO Trade Domain
|Quantity of meat imported (Tonnes) from FAO Trade Domain, collapsed to  match FAO FBS in IFs
|Tonnes
|FAOSTAT, Trade Domain
|<nowiki>https://www.fao.org/faostat/en/#data</nowiki>
|1
|AGRICULTURE
|-
|AgMeatImportValue%GDPFAOTrade
|Value of Meat Imported as a percent of GDP from FAO Trade Domain
|Value of meat imported (1000$ US) from FAO Trade Domain, as a percent of  GDP at current $ from WDI, collapsed to match FAO FBS in IFs
|Percent
|FAOSTAT, Trade Domain
|<nowiki>https://www.fao.org/faostat/en/#data</nowiki>
|1
|AGRICULTURE
|}
To pull data, please follow the instructions below.

== Data Pulling Instructions ==

Step 1.) Navigate to the homepage of [https://www.fao.org/faostat/en/#home FAOSTAT]

Step 2.) Near the top of the page, click on the tab labeled "'''Data'''"
[[File:FAOSTAT IMG STEP 01.jpg|center|thumb|575x575px|FAOSTAT Homepage]]


Step 3.) A page will pop up with a number of different domains, click on the one your series is in[[File:FAOSTAT Data Homepage.png|center|thumb|576x576px|List of Domains]]

=== VARIABLE EXAMPLE: SeriesAgMeatImportValueFAOTrade ===
Step 4.) SeriesAgMeatImportValueFAOTrade in IFs is under the "'''Trade'''" category, select this to bring down a menu
[[File:FAOSTAT IMG STEP 04.jpg|center|thumb|574x574px|Select the Domain]]


Step 5.) Click on "'''Crops and livestock products'''", a new page will appear
[[File:FAOSTAT IMG STEP 05.jpg|center|thumb|575x575px|Select the Database in Domain]]


Step 6.) Under "Countries" on the right hand side, select "'''Select All'''"
[[File:FAOSTAT IMG STEP 06.jpg|center|thumb|574x574px|Select (All) Countries]]


Step 7.) Under "Years" on the left hand side, select "'''Select All'''"
[[File:FAOSTAT IMG STEP 07.jpg|center|thumb|576x576px|Select (All) Years]]


Step 8.) Under "Elements" on the right hand side, select "'''Import Value'''"
[[File:FAOSTAT IMG STEP 08.jpg|center|thumb|576x576px|Select the Element]]


Step 9.) On the bottom left side, next to the tab "Items", select "'''Items Aggregated'''"
[[File:FAOSTAT IMG STEP 09.jpg|center|thumb|575x575px|Click Items Aggregated]]


Step 10.) Next to the section "Crops and livestock products > (List)", click on the '''>''' button to bring down a list of different variables
[[File:FAOSTAT IMG STEP 10.jpg|center|thumb|574x574px|Click the Dropdown arrow]]


Step 11.) Scroll down and select "'''Meat and Meat Preparations + (Total)'''"
[[File:FAOSTAT IMG STEP 11.jpg|center|thumb|575x575px|Select the Variable]]


Step 12.) Scroll down and select "'''Download Data'''"
[[File:FAOSTAT IMG STEP 12.jpg|center|thumb|575x575px|Click "Download"]]

Step 13.) An Excel sheet will download. Now you can format the data to upload it into IFs. To import data into IFs, please follow the instructions found in the [[Importing data (general instructions)|Importing Data (general instructions)]] page. 
[[File:FAOSTAT Excel Data.png|center|thumb|574x574px]]

== Data Notes ==
For Crop and Livestock data, we are currently only looking at items with CPC codes that have "F" in front of them. TCL is the label given to trade data domain in FAOSTAT. 

The following states are included in FAOSTAT countries, but we do not have them in IFs Countries. You will need to copy and paste the data from the below dissolved states into their new states (The general rule about merging data between current states and their former dissolved states is whichever state that inherited the capital city has the right to claim data from its former dissolved state):

* China, mainland --> China
* Czechoslovakia --> Czech Republic

*Ethiopia PDR --> Ethiopia
* USSR --> Russian Federation
* Yugoslav SFR --> Serbia
* Serbia and Montenegro --> Serbia
* Sudan (former) --> Sudan
The following table is how we have aggregated FAO TCL data (what is classified as Crops, what is classified as Meat). Using Item Code_lv3 is the easiest way to differentiate the codes (this is Item Code (CPC) in FAO).

If you would like to use a script, one for the aggregation is attached [https://github.com/n1shamin/FAO-Trade-Updated/tree/main here]. 

===== Item Scheme: =====
{| class="wikitable"
|Item  Code_lv1
|Item_lv1
|Item Code_lv2
|Item_lv2
|Item Code_lv3
|Item_lv3
|IFs Group
|Notes
|-
|1847
|Non-food
|1845
|Non-edible Crude Materials
|F1972  
|Flowers
|Crops
|
|-
|1847
|Non-food
|1845
|Non-edible Crude Materials
|F1900  
|Natural Rubber
|Crops
|
|-
|1847
|Non-food
|1845
|Non-edible Crude Materials
|F1901  
|Textile Fibres
|Crops
|
|-
|1847
|Non-food
|1845
|Non-edible Crude Materials
|F1902  
|Crude Materials nes
|Crops
|This consists of Bees; Crude organic material n.e.c.; Hop  cones; Leather used & waste. In terms of trade values, this is basically  Crude organic material n.e.c., which is live plants, cut flowers, and animal  semen.
|-
|1847
|Non-food
|1892
|Fodder and Feeding Stuff
|F1892  
|Fodder and Feeding Stuff
|Crops
|
|-
|1847
|Non-food
|1846
|Non-edible Fats and Oils
|F1846  
|Non-edible Fats and Oils
|Crops
|This can be produced with either animal or vegetable oil.  Since the production/trade of oil & fat from vegetable is much higher  than animal, we categorize this as crops. 
|-
|1847
|Non-food
|1896
|Tobacco
|F1896  
|Tobacco
|Crops
|
|-
|1982
|Food Excluding Fish
|1844
|Fats and Oils (excluding Butter)
|F1788  
|Vegetable Oil and Fat
|Crops
|
|-
|1982
|Food Excluding Fish
|1848
|Other food
|F1899  
|Oilseeds
|Crops
|
|-
|1982
|Food Excluding Fish
|1848
|Other food
|F1849  
|Other food nes
|Crops
|Chocolate products nes, green coffee, cocoa beans, tea leaves,  etc.
|-
|1982
|Food Excluding Fish
|1888
|Cereals and Preparations
|F1944  
|Cereals
|Crops
|
|-
|1982
|Food Excluding Fish
|1888
|Cereals and Preparations
|F1941  
|Cereal preparations total
|Crops
|
|-
|1982
|Food Excluding Fish
|1889
|Fruit and Vegetables
|F1802  
|Fruit
|Crops
|
|-
|1982
|Food Excluding Fish
|1889
|Fruit and Vegetables
|F1734  
|Vegetables
|Crops
|
|-
|1982
|Food Excluding Fish
|1889
|Fruit and Vegetables
|F1954  
|Pulses
|Crops
|
|-
|1982
|Food Excluding Fish
|1889
|Fruit and Vegetables
|F1719  
|Roots and Tubers
|Crops
|
|-
|1982
|Food Excluding Fish
|1889
|Fruit and Vegetables
|F1773  
|Nuts
|Crops
|
|-
|1982
|Food Excluding Fish
|1889
|Fruit and Vegetables
|F1723  
|Sugar Crops Primary
|Crops
|
|-
|1982
|Food Excluding Fish
|1895
|Beverages
|F1907  
|Alcoholic Beverages
|Crops
|
|-
|1982
|Food Excluding Fish
|1895
|Beverages
|F1908  
|Non-alcoholic Beverages
|Crops
|
|-
|1982
|Food Excluding Fish
|1890
|Sugar and Honey
|F1890  
|Sugar and Honey
|Crops
|Refined cane or beet sugar, in solid form, containing added  flavouring or colouring matter; maple sugar and maple syrup; Other sugar  crops n.e.c.; Raw cane or beet sugar (centrifugal only); Cane sugar,  non-centrifugal; Refined sugar; Molasses; Other fructose and syrup; Sugar and  syrups n.e.c.; Sugar confectionery; Glucose and dextrose; Lactose;  Isoglucose; Honey and Lactose are small comparing to Raw cane or beet sugar  & Refined sugar & Sugar confectionery. 
|-
|1847
|Non-food
|1845
|Non-edible Crude Materials
|F1898  
|Hides and skins
|Meat
|
|-
|1982
|Food Excluding Fish
|1844
|Fats and Oils (excluding Butter)
|F1975  
|Animal Fats and Oils (excl. Butter)
|Meat
|
|-
|1982
|Food Excluding Fish
|1885
|Meat and Meat Preparations
|F2071  
|Bovine Meat
|Meat
|
|-
|1982
|Food Excluding Fish
|1885
|Meat and Meat Preparations
|F2074  
|Poultry Meat
|Meat
|
|-
|1982
|Food Excluding Fish
|1885
|Meat and Meat Preparations
|F2073  
|Pigmeat (meat equivalent)
|Meat
|
|-
|1982
|Food Excluding Fish
|1885
|Meat and Meat Preparations
|F2076  
|Other Meat
|Meat
|
|-
|1982
|Food Excluding Fish
|1886
|Dairy Products and Eggs
|F1887  
|Dairy Products
|Meat
|
|-
|1982
|Food Excluding Fish
|1886
|Dairy Products and Eggs
|F1782  
|Eggs
|Meat
|
|}