FAOSTAT Food Security: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
 
(One intermediate revision by the same user not shown)
Line 41: Line 41:


Step 10. Click '''“Download Data”'''. Either an Excel or CSV 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.
Step 10. Click '''“Download Data”'''. Either an Excel or CSV 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:FAO IMG 9.jpg|center|thumb|718x718px|Show and Download Data]]
[[File:FAO IMG 9.jpg|center|thumb|718x718px|Show and Download Data]]''Note:''
 
* '''''Any data values that include a symbol (ie. <2.5 for Algeria 2018-2022) need to be changed to NULL.'''''
* '''''For the table MalnMinNutrRequired, we need to make sure Sahrawi has values (use Mali as a proxy). So, only Kosovo is allowed to have nulls.'''''

Latest revision as of 19:35, 8 October 2024

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. The Suite of Food Security Indicators presents the core set of food security indicators. The choice of the indicators has been informed by expert judgment and the availability of data with sufficient coverage to enable comparisons across regions and over time. Many of these indicators are produced and published elsewhere by FAO and other international organizations. More indicators will be added to as more data will become available. Indicators are classified along the four dimensions of food security -- availability, access, utilization and stability.


The data team uses food security indicators for many series, including those related to hunger/malnutrition such as SeriesMalnDietEnSup, SeriesMalnPop%, SeriesMalnCaloricDistribution, SeriesMalnMinNutrRequired. To pull data, follow the instructions below.

FAO Food Security Pulling Steps

Step 1. Navigate to FAOSTAT Food Securitysite. This site will display a suite of food security indicators.

FAO Food Security Homepage


Step 2. The page displays four options that must be selected to download data: Countries/Regions/Special Groups, Elements, Years, and Items. For all these options, you can also type in a search box.

FAO Data Selections


Step 3. For “Countries” options, you will generally want to select “Select All” to capture all country data.

Country Selection


Step 4. For the “Elements” options you will most likely want to select “Value”, depending on the desired dataset.

Elements Selection


Step 5. For “Years”, you will generally want to select “Select All” to capture all years of data available.

Years Selection


Step 6. For “Items”, select the desired indicator. You can also type in the search box for the indicator. This example will use “Prevalence of undernourishment (percent)”.

Items Selection


Step 7. After selecting for these for options, the page will display the completed selections.

Completed Selections


Step 8. Scroll down below the options. You also have options to select the “Output Type”, “File Type”, and “Thousand Separator in ‘Show Data’”. It’s recommended to select “Pivot” under “Output Type” to have easier data cleaning.

Additional Data Options

Step 9. You may select “Show Data” to look at the data before downloading. This option will populate data at the bottom of the page.

Step 10. Click “Download Data”. Either an Excel or CSV 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.

Show and Download Data

Note:

  • Any data values that include a symbol (ie. <2.5 for Algeria 2018-2022) need to be changed to NULL.
  • For the table MalnMinNutrRequired, we need to make sure Sahrawi has values (use Mali as a proxy). So, only Kosovo is allowed to have nulls.