FAOSTAT Food Security and Nutrition - Revision history

Yutang.Xiong: /* Data Notes */

2026-02-24T22:08:41Z

Data Notes

← Older revision		Revision as of 22:08, 24 February 2026
Line 82:		Line 82:
	* MalnPop% has year ranges; only include the mid-year in the range. (ie. If 2000-2002, change it to 2001).		* MalnPop% has year ranges; only include the mid-year in the range. (ie. If 2000-2002, change it to 2001).
	* While exporting data, make sure to select "Null Values" under Output Formatting Options. This is to ensure that all countries are included even if there is no data available.		* While exporting data, make sure to select "Null Values" under Output Formatting Options. This is to ensure that all countries are included even if there is no data available.
			* For country concordance, use "China, mainland" to represent China in IFs.

Andrew.French: changed years to 2001-2023

2025-10-16T15:04:41Z

changed years to 2001-2023

← Older revision		Revision as of 15:04, 16 October 2025
Line 16:		Line 16:
	\|MalnDietEnSup		\|MalnDietEnSup
	\|National average dietary energy supply (DES) (expressed in calories per caput per day) used in the estimation of prevalence of undernourishment.		\|National average dietary energy supply (DES) (expressed in calories per caput per day) used in the estimation of prevalence of undernourishment.
	\|~~2000~~-~~2024~~		\|2001-2023
	\|1		\|1
	\|AGRICULTURE		\|AGRICULTURE
Line 22:		Line 22:
	\|MalnCaloricDistribution		\|MalnCaloricDistribution
	\|Coefficient of variation of habitual caloric consumption distribution.		\|Coefficient of variation of habitual caloric consumption distribution.
	\|~~2000~~-~~2024~~		\|2001-2023
	\|1		\|1
	\|AGRICULTURE		\|AGRICULTURE
Line 28:		Line 28:
	\|MalnMinNutrRequired		\|MalnMinNutrRequired
	\|In a specified age/sex category, MDER is the minimum amount of dietary energy per person that is considered adequate to meet the energy needs at a minimum acceptable BMI of an individual engaged in low physical activity.		\|In a specified age/sex category, MDER is the minimum amount of dietary energy per person that is considered adequate to meet the energy needs at a minimum acceptable BMI of an individual engaged in low physical activity.
	\|~~2000~~-~~2024~~		\|2001-2023
	\|1		\|1
	\|AGRICULTURE		\|AGRICULTURE

Andrew.French: Added relevant information into the data note section

2025-10-14T15:41:19Z

Added relevant information into the data note section

← Older revision		Revision as of 15:41, 14 October 2025
Line 16:		Line 16:
	\|MalnDietEnSup		\|MalnDietEnSup
	\|National average dietary energy supply (DES) (expressed in calories per caput per day) used in the estimation of prevalence of undernourishment.		\|National average dietary energy supply (DES) (expressed in calories per caput per day) used in the estimation of prevalence of undernourishment.
	\|2000-~~2022~~		\|2000-2024
	\|1		\|1
	\|AGRICULTURE		\|AGRICULTURE
Line 22:		Line 22:
	\|MalnCaloricDistribution		\|MalnCaloricDistribution
	\|Coefficient of variation of habitual caloric consumption distribution.		\|Coefficient of variation of habitual caloric consumption distribution.
	\|2000-~~2023~~		\|2000-2024
	\|1		\|1
	\|AGRICULTURE		\|AGRICULTURE
Line 28:		Line 28:
	\|MalnMinNutrRequired		\|MalnMinNutrRequired
	\|In a specified age/sex category, MDER is the minimum amount of dietary energy per person that is considered adequate to meet the energy needs at a minimum acceptable BMI of an individual engaged in low physical activity.		\|In a specified age/sex category, MDER is the minimum amount of dietary energy per person that is considered adequate to meet the energy needs at a minimum acceptable BMI of an individual engaged in low physical activity.
	\|2000-~~2023~~		\|2000-2024
	\|1		\|1
	\|AGRICULTURE		\|AGRICULTURE
Line 34:		Line 34:
	\|MalnPop%		\|MalnPop%
	\|Prevalence of undernourishment (% of population)		\|Prevalence of undernourishment (% of population)
	\|~~2000~~-~~2022~~		\|2001-2023
	\|1		\|1
	\|AGRICULTURE		\|AGRICULTURE
Line 80:		Line 80:
	* Any data values that include a symbol (ie. <2.5 for Algeria 2018-2022) need to be changed to NULL.		* 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.		* 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.
			* MalnPop% has year ranges; only include the mid-year in the range. (ie. If 2000-2002, change it to 2001).
			* While exporting data, make sure to select "Null Values" under Output Formatting Options. This is to ensure that all countries are included even if there is no data available.

Norah.Shamin: /* FAO Food Security Pulling Steps */

2025-08-15T16:38:32Z

FAO Food Security Pulling Steps

← Older revision		Revision as of 16:38, 15 August 2025
Line 39:		Line 39:
	\|}		\|}

	= ~~FAO Food Security~~ Pulling ~~Steps~~ =		= Data Pulling Instructions =
	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.

Norah.Shamin at 20:21, 2 July 2025

2025-07-02T20:21:29Z

@@ 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.
+The data team uses food security indicators for many series, including those related to hunger/malnutrition such as Series, Series, Series, Series. To pull data, follow the instructions below.
-=== FAO Food Security Pulling Steps ===
+= Tables In IFs =
 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.
@@ Line 41: / Line 75: @@
 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]]''Note:''
+[[File:FAO IMG 9.jpg|center|thumb|718x718px|Show and Download Data]]
-* '''''Any data values that include a symbol (ie. <2.5 for Algeria 2018-2022) need to be changed to NULL.'''''
+= Data Notes =
-* '''''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.'''''
+* Any data values that include a symbol (ie. <2.5 for Algeria 2018-2022) need to be changed to NULL.

Yutang.Xiong: Yutang.Xiong moved page FAOSTAT Food Security to FAOSTAT Food Security and Nutrition without leaving a redirect: new name

2025-02-12T21:29:50Z

Yutang.Xiong moved page FAOSTAT Food Security to FAOSTAT Food Security and Nutrition without leaving a redirect: new name

← Older revision	Revision as of 21:29, 12 February 2025
(No difference)

Kexin.Shang: /* FAO Food Security Pulling Steps */

2024-10-08T19:35:26Z

FAO Food Security Pulling Steps

← Older revision		Revision as of 19:35, 8 October 2024
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]]''Note: Any data values that include a symbol (ie. <2.5 for Algeria 2018-2022) need to be changed to NULL.''		[[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.'''''

Kexin.Shang: /* FAO Food Security Pulling Steps */

2024-08-26T21:35:51Z

FAO Food Security Pulling Steps

← Older revision		Revision as of 21:35, 26 August 2024
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.''

Sami.McKinsey at 23:46, 20 September 2023

2023-09-20T23:46:39Z

← Older revision		Revision as of 23:46, 20 September 2023
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]]

Sami.McKinsey: 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...."

2023-09-18T22:10:24Z

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...."

New page

=== 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.

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

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. 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 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.