FAOstat Food and Agriculture Organization of the United Nations: Difference between revisions
mNo edit summary |
mNo edit summary |
||
Line 1: | Line 1: | ||
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. | 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 STEPS TO PULL DATA FROM FAOSTAT == | ||
Step 1.) Navigate to the homepage of [https://www.fao.org/faostat/en/#home FAOSTAT] | Step 1.) Navigate to the homepage of [https://www.fao.org/faostat/en/#home FAOSTAT] | ||
Line 12: | Line 12: | ||
== | == 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|Select the Domain]] | [[File:FAOSTAT IMG STEP 04.jpg|center|thumb|574x574px|Select the Domain]] | ||
Line 48: | Line 48: | ||
[[File:FAOSTAT IMG STEP 12.jpg|center|thumb|575x575px|Click "Download"]] | [[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. | 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)|Importing Data (general instructions)]] page. | ||
[[File:FAOSTAT Excel Data.png|center|Data in Excel|thumb|576x576px]] | [[File:FAOSTAT Excel Data.png|center|Data in Excel|thumb|576x576px]] |
Revision as of 03:46, 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 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"
Step 3.) A page will pop up with a number of different domains, click on the one your series is in
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. To import data into IFs, please follow the instructions found in the Importing Data (general instructions) page.