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

From Pardee Wiki
Jump to navigation Jump to search
(finished updating the pictures with arrows)
mNo edit summary
Line 27: Line 27:
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|Select (All) Years]]
[[File:FAOSTAT IMG STEP 07.jpg|center|thumb|576x576px|Select (All) Years]]


Step 8.) Under "Elements" on the right hand side, select "'''Import Value'''"
Step 8.) Under "Elements" on the right hand side, select "'''Import Value'''"
[[File:FAOSTAT IMG STEP 08.jpg|center|thumb|576x576px|Select the Element]]
[[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'''"
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]]
[[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
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]]
[[File:FAOSTAT IMG STEP 10.jpg|center|thumb|574x574px|Click the Dropdown arrow]]


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


Step 12.) Scroll down and select "'''Download Data'''"
Step 12.) Scroll down and select "'''Download Data'''"
Line 44: Line 49:


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.  
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 Excel Data.png|center|Data in Excel|thumb|576x576px]]

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