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

From Pardee Wiki
Jump to navigation Jump to search
mNo edit summary
(updated the pictures to include arrows)
Line 2: Line 2:


== General Pulling Instructions for FAOSTAT Food and Agriculture Organization of the United Nations ==
== General Pulling Instructions for FAOSTAT Food and Agriculture Organization of the United Nations ==
[[File:FAOSTAT Homepage.png|thumb|494x494px]]


Step 1.) Navigate to the homepage of [https://www.fao.org/faostat/en/#home FAOSTAT]


Step 2.) Near the top of the page, click on the tab labeled "'''Data'''"
[[File:FAOSTAT IMG STEP 01.jpg|center|thumb|575x575px]]




Step 3.) A page will pop up with a number of different domains, click on the one your series is in[[File:FAOSTAT Data Homepage.png|center|frame]]


[[File:FAOSTAT Data Homepage.png|thumb|494x494px]]


== Specific Variable Example: SeriesAgMeatImportValueFAOTrade ==
Step 4.) SeriesAgMeatImportValueFAOTrade in IFs is under the "'''Trade'''" category, select this to bring down a menu
[[File:FAOSTAT IMG STEP 04.jpg|center|thumb|574x574px]]




Step 5.) Click on "'''Crops and livestock products'''", a new page will appear
[[File:FAOSTAT IMG STEP 05.jpg|center|thumb|575x575px]]




1. Navigate to the homepage of [https://www.fao.org/faostat/en/#home FAOSTAT]
Step 6.) Under "Countries" on the right hand side, select "'''Select All'''"
[[File:FAOSTAT IMG STEP 06.jpg|center|thumb|574x574px]]


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


Step 7.) Under "Years" on the left hand side, select "'''Select All'''"
[[File:FAOSTAT IMG STEP 07.jpg|center|thumb|576x576px]]




Line 29: Line 38:




3. A page will pop up with a number of different domains, click on the one your series is in
== Specific Variable Example: SeriesAgMeatImportValueFAOTrade ==
[[File:FAOSTAT Trade Page.png|thumb|494x494px]]
4. SeriesAgMeatImportValueFAOTrade in IFs is under the "'''Trade'''" category, select this a drop down menu appears




Line 98: Line 72:




5. A new page will appear where you can select the different variables that are under this category





Revision as of 02:09, 19 January 2023

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 and download that data.

General Pulling Instructions for FAOSTAT Food and Agriculture Organization of the United Nations

Step 1.) Navigate to the homepage of FAOSTAT

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

FAOSTAT IMG STEP 01.jpg


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

FAOSTAT Data Homepage.png


Specific Variable Example: SeriesAgMeatImportValueFAOTrade

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

FAOSTAT IMG STEP 04.jpg


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

FAOSTAT IMG STEP 05.jpg


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

FAOSTAT IMG STEP 06.jpg


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

FAOSTAT IMG STEP 07.jpg










FAOSTAT Crop and Livestock Products.png









FAOSTAT Country Selected.png


















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

FAOSTAT Year.png











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



FAOSTAT Import Value.png








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

FAOSTAT Items Aggregated.png









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

FAOSTAT Crops and Livestock Products.png









10. Next to the section "Crops and livestock products > (List)", click on the > button to bring down a list of different variables

FAOSTAT Meat and Meat Preparations.png








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

FAOSTAT Download Data.png






12. Scroll down and select "Download Data"

FAOSTAT Excel Data.png









13. An Excel sheet will download. Now you can format the data to upload it into IFs.