FAOstat Food and Agriculture Organization of the United Nations

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.

Series pulled from the FAOSTAT Trade

Variable	Definition
AgCropExportQuantityFAOTrade	Quantity of Crops exported (Tonnes) from FAO Trade Domain
AgCropImportQuantityFAOTrade	Quantity of Crops Imported (Tonnes) from FAO Trade Domain
AgMeatExportQuantityFAOTrade	Quantity of meat exported (Tonnes) from FAO Trade Domain
AgMeatImportQuantityFAOTrade	Quantity of Meat Imported (Tonnes) from FAO Trade Domain
AgCropExportValue%GDPFAOTrade	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
AgCropImportValue%GDPFAOTrade	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
AgMeatExportValue%GDPFAOTrade	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
AgMeatImportValue%GDPFAOTrade	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

To pull data, please follow the instructions below.

GENERAL STEPS TO PULL DATA FROM FAOSTAT

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.

ADDITIONAL INFORMATION

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

*Note: When you pull Crude Materials Nes for Import or Export Quantity, the indicator will pull twice in this same document with two different element codes (5607 and 5610). You will see countries with 1961-2021 back-to-back for each. We are looking for element code 5610, not 5907, because 5907 does not have units (which should be in Tonnes).

The following tables are how we have aggregated FAO TCL data (what is classified as Crops, what is classified as Meat):

FAOSTAT TCL AGGREGATION TABLE IMG 01

FAOSTAT TCL Aggregation Table IMG 02

FAOSTAT TCL Aggregation Table IMG 03

Easy to Copy for coding:

Item Code	CPC Code	Item	Item Group
1907	'F1907	Alcoholic Beverages	Crops
1941	'F1941	Cereal preparations total	Crops
1944	'F1944	Cereals	Crops
1972	'F1972	Flowers	Crops
1802	'F1802	Fruit	Crops
1900	'F1900	Natural Rubber	Crops
1908	'F1908	Non-alcoholic Beverages	Crops
1773	'F1773	Nuts	Crops
1899	'F1899	Oilseeds	Crops
1849	'F1849	Other food nes	Crops
1954	'F1954	Pulses	Crops
1719	'F1719	Roots and Tubers	Crops
1723	'F1723	Sugar Crops Primary	Crops
1901	'F1901	Textile Fibres	Crops
1788	'F1788	Vegetable Oil and Fat	Crops
1734	'F1734	Vegetables	Crops
1975	'F1975	Animal Fats and Oils (excl. Butter)	Meat
2071	'F2071	Bovine Meat	Meat
1902	'F1902	Crude Materials nes	Meat
1887	'F1887	Dairy Products	Meat
1782	'F1782	Eggs	Meat
1898	'F1898	Hides and skins	Meat
2076	'F2076	Other Meat	Meat
2073	'F2073	Pigmeat (meat equivalent)	Meat
2074	'F2074	Poultry Meat	Meat