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"
Step 3.) A page will pop up with a number of different domains, click on the one your series is in
VARIABLE EXAMPLE: SeriesAgMeatImportValueFAOTrade
Step 4.) SeriesAgMeatImportValueFAOTrade in IFs is under the "Trade" category, select this to bring down a menu
Step 5.) Click on "Crops and livestock products", a new page will appear
Step 6.) Under "Countries" on the right hand side, select "Select All"
Step 7.) Under "Years" on the left hand side, select "Select All"
Step 8.) Under "Elements" on the right hand side, select "Import Value"
Step 9.) On the bottom left side, next to the tab "Items", select "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
Step 11.) Scroll down and select "Meat and Meat Preparations + (Total)"
Step 12.) Scroll down and select "Download Data"
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):
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 |