Global - Food Prices
Global - Food Prices 2023
@kaggle.jocelyndumlao_global_food_prices
Global - Food Prices 2023
@kaggle.jocelyndumlao_global_food_prices
This dataset contains Countries, Commodities, and Markets data, sourced from the World Food Programme Price Database. The volume of data means that the actual Food Prices data is in country-level datasets. The World Food Programme Price Database covers foods such as maize, rice, beans, fish, and sugar for 98 countries and some 3000 markets. It is updated weekly but contains to a large extent monthly data. The data goes back as far as 1992 for a few countries, although many countries started reporting from 2003 or thereafter.
Compiled by the World Food Program and distributed by HDX.
[Image Source] (https://dipoinduction.com/wp-content/uploads/2021/04/Global-Food-Prices-Continue-to-Rise-Dipo-Induction-1024x581.jpg)
CREATE TABLE wfp_commodities_global (
"commodity_id" VARCHAR,
"category" VARCHAR,
"commodity" VARCHAR
);
CREATE TABLE wfp_countries_global (
"countryiso3" VARCHAR,
"url" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR
);
CREATE TABLE wfp_markets_global (
"market_id" VARCHAR,
"market" VARCHAR,
"countryiso3" VARCHAR,
"admin1" VARCHAR,
"admin2" VARCHAR,
"latitude" VARCHAR,
"longitude" VARCHAR
);
Anyone who has the link will be able to view this.