Skip to content

Using SQL and Tableau to learn more about the relationship between food security and other factors using UN data.

Notifications You must be signed in to change notification settings

Joms94/food-security-exploratory-analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Exploring food security data using SQL and Tableau

A brief exploration of food insecurity and how it relates to management of water services, sanitation access and government spending.

About the data

All data was sourced from the Food and Agriculture Organisation of the United Nations (FAOSTAT): https://www.fao.org/faostat/en/#data

To learn more about definitions and standards used in this project, go to: https://ourworldindata.org/food-supply#data-sources

Description of what 'moderate to severe food insecurity' means according to FAOSTAT:

The prevalence of moderate or severe food insecurity is an estimate of the percentage of people in the population who live in households classified as moderately or severely food insecure. The assessment is conducted using data collected with the Food Insecurity Experience Scale or a compatible experience-based food security measurement questionnaire (such as the HFSSM). The probability to be food insecure is estimated using the one-parameter logistic Item Response Theory model (the Rasch model) and thresholds for classification are made cross country comparable by calibrating the metrics obtained in each country against the FIES global reference scale, maintained by FAO. The threshold to classify "moderate or severe" food insecurity corresponds to the severity associated with the item "having to eat less" on the global FIES scale. In simpler terms, a household is classified as moderately or severely food insecure when at least one adult in the household has reported to have been exposed, at times during the year, to low quality diets and might have been forced to also reduce the quantity of food they would normally eat because of a lack of money or other resources. It is an indicator of lack of food access.

Description of what 'political stability and absence of violence/terrorism (index)' means:

Political stability and absence of violence measures perceptions of the likelihood that thegovernment will be destabilized or overthrown by unconstitutional or violent means, includingpolitically-motivated violence and terrorism.

About

Using SQL and Tableau to learn more about the relationship between food security and other factors using UN data.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages