FAOstat Food and Agriculture Organization of the United Nations: Difference between revisions
(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 | [[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"
Step 3.) A page will pop up with a number of different domains, click on the one your series is in
Specific Variable Example: SeriesAgMeatImportValueFAOTrade
Step 4.) SeriesAgMeatImportValueFAOTrade in IFs is under the "Trade" category, select this to bring down a menu
Step 5.) Click on "Crops and livestock products", a new page will appear
Step 6.) Under "Countries" on the right hand side, select "Select All"
Step 7.) Under "Years" on the left hand side, select "Select All"
Step 8.) Under "Elements" on the right hand side, select "Import Value"
Step 9.) On the bottom left side, next to the tab "Items", select "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 11.) Scroll down and select "Meat and Meat Preparations + (Total)"
Step 12.) Scroll down and select "Download Data"
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.