FAOstat Food and Agriculture Organization of the United Nations
SUMMARY
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 from a variety of different domain groupings including Production, Investment, and Trade.
The data team uses FAOSTAT for a number of series including SeriesAgCropExportQuantityFAOTrade, SeriesAgFishExportsAqMammalsFAO, and SeriesAgFishProdMealFAO to name a few. To pull data, please follow the instructions below.
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.
STEPS FOR PULLING FROM FISHSTATJ- FAO'S FISHERIES AND AQUACULTURE DATABASE SOFTWARE
Step 1. To pull data from FAO's Fisheries and Aquaculture Statistical Time Series software, FishStatJ, navigate to https://www.fao.org/fishery/en/topic/166235
Step 2. Scroll down the page until you reach <Installing FishStatJ v.4.02.08 (November 2022)>. Under <Download FishStatJ>, click on the desired operating system to download the software. This example will use the Windows version.
NOTE: Make sure your Windows version is compatible with FishStatJ before downloading. FishStatJ is compatible with Windows 10; 64-bit version; it cannot work with Windows 32-bit.
Step 3. After installing, go to your downloads and right click on <FishStatJ_4.02.08_Installer> and click <Open>.
Step 4. The following permission window will pop up. Click <Yes> to finish installing and lauch.
Step 5. FishStatJ will immediately launch at this point. The <Workspaces Manager> page should also open automatically after launching.
Step 6. Select the desired workspace, then click <Download> on the right side. This example will pull data from <FAO Global Fish Trade Statistics>.
Step 7. The following page will populate. Click <Next> two times, then click <Finish>.
.jpg)
.jpg)
Step 8. The <Dataset Browser> page will then pop up. You can select to have the dataset by partner country or all partners aggregated. This example will select <All partners aggregated>. Click <OK> on bottom right of page to open up the dataset.
Step 9. The following page will populate. To export the data, click on <File> in the top left corner, then select <Export Selection (CSV file)...> OR use command Ctrl + S. Name the CSV file then save it into an appropriate place.
Step 10. Opening up the CSV file in Excel will formulate the following page. Make sure to save the file as an *.xls or *.xlsx to prevent any possible data loss.
