FAOstat Food and Agriculture Organization of the United Nations

From Pardee Wiki
Revision as of 18:00, 2 April 2024 by Kexin.Shang (talk | contribs) (→‎ADDITIONAL INFORMATION)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


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.

FAOSTAT Excel Data.png

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