FAOSTAT Trade Crops and livestock products

Summary

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

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	https://www.fao.org/faostat/en/#data	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	https://www.fao.org/faostat/en/#data	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	https://www.fao.org/faostat/en/#data	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	https://www.fao.org/faostat/en/#data	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	https://www.fao.org/faostat/en/#data	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	https://www.fao.org/faostat/en/#data	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	https://www.fao.org/faostat/en/#data	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	https://www.fao.org/faostat/en/#data	1	AGRICULTURE

To pull data, please follow the instructions below.

Data Pulling Instructions

Step 1.) Navigate to the homepage of FAOSTAT

Step 2.) Near the top of the page, click on the tab labeled "Data"

FAOSTAT Homepage

Step 3.) A page will pop up with a number of different domains, click on the one your series is in

List of Domains

VARIABLE EXAMPLE: SeriesAgMeatImportValueFAOTrade

Step 4.) SeriesAgMeatImportValueFAOTrade in IFs is under the "Trade" category, select this to bring down a menu

Select the Domain

Step 5.) Click on "Crops and livestock products", a new page will appear

Select the Database in Domain

Step 6.) Under "Countries" on the right hand side, select "Select All"

Select (All) Countries

Step 7.) Under "Years" on the left hand side, select "Select All"

Select (All) Years

Step 8.) Under "Elements" on the right hand side, select "Import Value"

Select the Element

Step 9.) On the bottom left side, next to the tab "Items", select "Items Aggregated"

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

Click the Dropdown arrow

Step 11.) Scroll down and select "Meat and Meat Preparations + (Total)"

Select the Variable

Step 12.) Scroll down and select "Download Data"

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) page.

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 here.

Item Scheme:

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