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

From Pardee Wiki
Jump to navigation Jump to search
mNo edit summary
(finished updating the pictures with arrows)
Line 6: Line 6:


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




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|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|thumb|575x575px|List of Domains]]




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




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




Step 6.) Under "Countries" on the right hand side, select "'''Select All'''"
Step 6.) Under "Countries" on the right hand side, select "'''Select All'''"
[[File:FAOSTAT IMG STEP 06.jpg|center|thumb|574x574px]]
[[File:FAOSTAT IMG STEP 06.jpg|center|thumb|574x574px|Select (All) Countries]]




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


Step 8.) Under "Elements" on the right hand side, select "'''Import Value'''"
[[File:FAOSTAT IMG STEP 08.jpg|center|thumb|576x576px|Select the Element]]


Step 9.) On the bottom left side, next to the tab "Items", select "'''Items Aggregated'''"
[[File:FAOSTAT IMG STEP 09.jpg|center|thumb|575x575px|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
[[File:FAOSTAT IMG STEP 10.jpg|center|thumb|574x574px|Click the Dropdown arrow]]


Step 11.) Scroll down and select "'''Meat and Meat Preparations + (Total)'''"
[[File:FAOSTAT IMG STEP 11.jpg|center|thumb|575x575px|Select the Variable]]


Step 12.) Scroll down and select "'''Download Data'''"
[[File:FAOSTAT IMG STEP 12.jpg|center|thumb|575x575px|Click "Download"]]


 
Step 13.) An Excel sheet will download. Now you can format the data to upload it into IFs. o import data into IFs, please follow the instructions found in the [[Importing data (general instructions)|Importing Data (general instructions)]] page.  
 
[[File:FAOSTAT Excel Data.png|center|frame|Data in Excel]]
 
 
 
 
 
 
 
 
 
 
[[File:FAOSTAT Crop and Livestock Products.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
[[File:FAOSTAT Country Selected.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
6. Under "Countries" on the right hand side, select "'''Select All'''"
[[File:FAOSTAT Year.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
7. Under "Years" on the left hand side, select "'''Select All'''"
 
 
 
 
 
[[File:FAOSTAT Import Value.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
8. Under "Elements" on the right hand side, select "'''Import Value'''"
[[File:FAOSTAT Items Aggregated.png|thumb|492x492px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
9. On the bottom left side, next to the tab "Items", select "'''Items Aggregated'''"
[[File:FAOSTAT Crops and Livestock Products.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
10. Next to the section "Crops and livestock products > (List)", click on the '''>''' button to bring down a list of different variables
[[File:FAOSTAT Meat and Meat Preparations.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
11. Scroll down and select "'''Meat and Meat Preparations + (Total)'''"
[[File:FAOSTAT Download Data.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
12. Scroll down and select "Download Data"
[[File:FAOSTAT Excel Data.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
13. An Excel sheet will download. Now you can format the data to upload it into IFs.

Revision as of 03:39, 20 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 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


Specific 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. o import data into IFs, please follow the instructions found in the Importing Data (general instructions) page.

Data in Excel