FAOSTAT Food Security: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
(Created page with "=== Summary === === FAO Food Security Pulling Steps === Step 1. Navigate to [https://www.fao.org/faostat/en/#data/FS FAOSTAT Food Security]site. This site will display a suite of food security indicators. Step 2. The page will automatically display the “DOWNLOAD DATA” page. Step 3. This will display four options that must be selected to download data: Countries/Regions/Special Groups, Elements, Years, and Items. For all these options, you can type in a search box....")
 
No edit summary
 
Line 1: Line 1:
=== Summary ===
=== 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 ===
=== FAO Food Security Pulling Steps ===
Step 1. Navigate to [https://www.fao.org/faostat/en/#data/FS FAOSTAT Food Security]site. This site will display a suite of food security indicators.
Step 1. Navigate to [https://www.fao.org/faostat/en/#data/FS FAOSTAT Food Security]site. This site will display a suite of food security indicators.


Step 2. The page will automatically display the “DOWNLOAD DATA” page.
[[File:FAO IMG 1.jpg|center|thumb|696x696px|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.
[[File:FAO IMG 2.jpg|center|thumb|754x754px|FAO Data Selections]]
 
 
Step 3. For '''“Countries”''' options, you will generally want to select '''“Select All”''' to capture all country data.
[[File:FAO IMG 3.jpg|center|thumb|688x688px|Country Selection]]
 
 
Step 4. For the '''“Elements”''' options you will most likely want to select '''“Value”''', depending on the desired dataset.
[[File:FAO IMG 4.jpg|center|thumb|684x684px|Elements Selection]]
 
 
Step 5. For '''“Years”''', you will generally want to select '''“Select All”''' to capture all years of data available.
[[File:FAO IMG 5.jpg|center|thumb|678x678px|Years Selection]]


Step 3. This will display four options that must be selected to download data: Countries/Regions/Special Groups, Elements, Years, and Items. For all these options, you can type in a search box.


Step 4. For '''“Countries”''' options, you will generally want to select '''“Select All”''' to capture all country data.
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)”'''.
[[File:FAO IMG 6.jpg|center|thumb|684x684px|Items Selection]]


Step 5. For '''“Elements”''' options, you will generally want to select '''“Value”'''.


Step 6. For '''“Years”''', you will generally want to select '''“Select All”''' to capture all years of data available.
Step 7. After selecting for these for options, the page will display the completed selections.
[[File:FAO IMG 7.jpg|center|thumb|716x716px|Completed Selections ]]


Step 7. 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)”'''.


Step 8. After selecting for these for options, 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.
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.
[[File:FAO IMG 8.jpg|center|thumb|701x701px|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 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)|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]]

Latest revision as of 23:46, 20 September 2023

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