FAOstat Food and Agriculture Organization of the United Nations: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
(removed FishStat page)
 
Line 4: Line 4:
[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.
[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.


The data team uses FAOSTAT for a number of series including SeriesAgCropExportQuantityFAOTrade, SeriesAgFishExportsAqMammalsFAO, and SeriesAgFishProdMealFAO  to name a few. To pull data, please follow the instructions below.
== Series pulled from the FAOSTAT Trade ==
{| class="wikitable"
|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 ==
== GENERAL STEPS TO PULL DATA FROM FAOSTAT ==
Line 61: Line 90:
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):
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):


* Sudan (former) --> Sudan
* China, mainland --> China
* Czechoslovakia --> Czech Republic
 
*Ethiopia PDR --> Ethiopia
* USSR --> Russian Federation
* Yugoslav SFR --> Serbia
* Yugoslav SFR --> Serbia
* Czechoslovakia --> Czech Republic/Czechia
* Ethiopia PDR --> Ethiopia
* Serbia and Montenegro --> Serbia
* Serbia and Montenegro --> Serbia
* USSR --> Russian Federation
* Sudan (former) --> Sudan


<nowiki>*</nowiki>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).
<nowiki>*</nowiki>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).
Line 75: Line 106:


[[File:FAOSTAT TCL AGGREGATION TABLE IMG 02.png|center|thumb|742x742px|FAOSTAT TCL Aggregation Table IMG 02]]
[[File:FAOSTAT TCL AGGREGATION TABLE IMG 02.png|center|thumb|742x742px|FAOSTAT TCL Aggregation Table IMG 02]]
[[File:FAOSTAT TCL AGGREGATION TABLE IMG 03.png|center|thumb|490x490px|FAOSTAT TCL Aggregation Table IMG 03]]
[[File:FAOSTAT TCL AGGREGATION TABLE IMG 03.png|center|thumb|490x490px|FAOSTAT TCL Aggregation Table IMG 03]]Easy to Copy for coding:
{| class="wikitable"
|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
|}

Latest revision as of 18:00, 2 April 2024


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