ECU Food Security

Database Layouts for the ECU dashboard

The Grafana program is connected to a MySQL database which gets updated daily from a CRON script. This script queries the API endpoints to check for new data in the timeframe, and if it exists then update the database.

Grafana can be updated to include new datasets as database tables are created.

Database name	Schema details
DTM_DisplacementData	Crop yield from the FEWS Source
FAO_ChildStuntedWastingOverweight	Percent of children under 5 who are stunted, wasting, and overweight
FAO_CostAffordabilityHealthyDiet	Number of people who can't afford a healthy diet
FAO_CostOfHealthyDiet	Cost of a healthy diet (kcal/cap/day)
FAO_FoodBalanceSupply	Food supply measured in average dietary energy requirement
FAO_FoodSecurityData	Per capita food supply variability (kcal/cap/day)
FAO_FoodSupplyLosses	Food Losses in 1000 tonnes
FAO_TempChange	Temperature change on land
FEWS_CropYieldData	Crop yield from the FEWS Source
IDX_BaselinePopulation	Population and demographics
IDX_ConflictEvents	Data on protests and political violence
IDX_FoodPrices	Prices of different food groups
IDX_FoodSecurity	IPC Acute Food Insecurity classification data
IDX_Funding	Funding to countries vs their humanitarian response needs
IDX_Humanitarian	Number of people who need assistance in an area
IDX_NationalRisk	INFORM Risk Index data
IDX_OperationalPresence	Geographical data of humanitarian activity
IDX_PovertyRate	Poverty rate data
IDX_Rainfall	Periodic rainfall data
IDX_Refugees	Data on number and demographics of forcibly displaced people
IDX_returnees	Displaced people based on country of origin and asylum
WB_PopulationGrowth	Percentage increase in the population
WB_ConsumerPriceInflation	Inflation measured by percentage change in consumer price
WB_IndustrialDesignApplications	Industrial design applications registered by residents