Food Prices For Nutrition (World Bank, 2023)
@owid.food_prices_for_nutrition
@owid.food_prices_for_nutrition
CREATE TABLE owid_food_prices_for_nutrition_1 (
"country" VARCHAR,
"year" INTEGER,
"cost_of_an_energy_sufficient_diet" FLOAT,
"affordability_of_an_energy_sufficient_diet_ratio_of_co_8ffb1a17" FLOAT,
"percent_of_the_population_who_cannot_afford_sufficient_calories" FLOAT,
"affordability_of_an_energy_sufficient_diet_ratio_of_co_18664a38" FLOAT,
"people_who_cannot_afford_sufficient_calories" FLOAT,
"cost_of_a_healthy_diet" FLOAT,
"cost_of_a_healthy_diet_relative_to_the_cost_of_suffici_b7920004" FLOAT,
"cost_of_animal_source_foods" FLOAT,
"cost_share_for_animal_sourced_foods_in_a_least_cost_he_00e5cabf" FLOAT,
"cost_of_animal_sourced_foods_relative_to_the_starchy_s_efb2deec" FLOAT,
"cost_of_fruits" FLOAT,
"cost_share_for_fruits_in_a_least_cost_healthy_diet" FLOAT,
"cost_of_fruits_relative_to_the_starchy_staples_in_a_le_0f888e29" FLOAT,
"affordability_of_a_healthy_diet_ratio_of_cost_to_food__dd98fefa" FLOAT,
"percent_of_the_population_who_cannot_afford_a_healthy_diet" FLOAT,
"cost_of_legumes_nuts_and_seeds" FLOAT,
"cost_share_for_legumes_nuts_and_seeds_in_a_least_cost__9f5f2345" FLOAT,
"cost_of_legumes_nuts_and_seeds_relative_to_the_starchy_9b5a6efe" FLOAT,
"cost_of_oils_and_fats" FLOAT,
"cost_share_for_oils_and_fats_in_a_least_cost_healthy_diet" FLOAT,
"cost_of_oils_and_fats_relative_to_the_starchy_staples__2c005259" FLOAT,
"affordability_of_a_healthy_diet_ratio_of_cost_to_the_f_71e2af92" FLOAT,
"cost_of_starchy_staples" FLOAT,
"cost_share_for_starchy_staples_in_a_least_cost_healthy_diet" FLOAT,
"people_who_cannot_afford_a_healthy_diet" FLOAT,
"cost_of_vegetables" FLOAT,
"cost_share_for_vegetables_in_a_least_cost_healthy_diet" FLOAT,
"cost_of_vegetables_relative_to_the_starchy_staples_in__2b2bff71" FLOAT,
"cost_of_a_nutrient_adequate_diet" FLOAT,
"affordability_of_a_nutrient_adequate_diet_ratio_of_cos_9183146c" FLOAT,
"percent_of_the_population_who_cannot_afford_nutrient_adequacy" FLOAT,
"affordability_of_a_nutrient_adequate_diet_ratio_of_cos_602b8374" FLOAT,
"people_who_cannot_afford_nutrient_adequacy" FLOAT,
"population" BIGINT
);
CREATE TABLE owid_food_prices_for_nutrition_2 (
"country" VARCHAR,
"year" INTEGER,
"cost_of_an_energy_sufficient_diet" FLOAT,
"affordability_of_an_energy_sufficient_diet_ratio_of_co_8ffb1a17" FLOAT,
"percent_of_the_population_who_cannot_afford_sufficient_calories" FLOAT,
"affordability_of_an_energy_sufficient_diet_ratio_of_co_18664a38" FLOAT,
"people_who_cannot_afford_sufficient_calories" FLOAT,
"cost_of_a_healthy_diet" FLOAT,
"cost_of_a_healthy_diet_relative_to_the_cost_of_suffici_b7920004" FLOAT,
"cost_of_animal_source_foods" FLOAT,
"cost_share_for_animal_sourced_foods_in_a_least_cost_he_00e5cabf" FLOAT,
"cost_of_animal_sourced_foods_relative_to_the_starchy_s_efb2deec" FLOAT,
"cost_of_fruits" FLOAT,
"cost_share_for_fruits_in_a_least_cost_healthy_diet" FLOAT,
"cost_of_fruits_relative_to_the_starchy_staples_in_a_le_0f888e29" FLOAT,
"affordability_of_a_healthy_diet_ratio_of_cost_to_food__dd98fefa" FLOAT,
"percent_of_the_population_who_cannot_afford_a_healthy_diet" FLOAT,
"cost_of_legumes_nuts_and_seeds" FLOAT,
"cost_share_for_legumes_nuts_and_seeds_in_a_least_cost__9f5f2345" FLOAT,
"cost_of_legumes_nuts_and_seeds_relative_to_the_starchy_9b5a6efe" FLOAT,
"cost_of_oils_and_fats" FLOAT,
"cost_share_for_oils_and_fats_in_a_least_cost_healthy_diet" FLOAT,
"cost_of_oils_and_fats_relative_to_the_starchy_staples__2c005259" FLOAT,
"affordability_of_a_healthy_diet_ratio_of_cost_to_the_f_71e2af92" FLOAT,
"cost_of_starchy_staples" FLOAT,
"cost_share_for_starchy_staples_in_a_least_cost_healthy_diet" FLOAT,
"people_who_cannot_afford_a_healthy_diet" FLOAT,
"cost_of_vegetables" FLOAT,
"cost_share_for_vegetables_in_a_least_cost_healthy_diet" FLOAT,
"cost_of_vegetables_relative_to_the_starchy_staples_in__2b2bff71" FLOAT,
"cost_of_a_nutrient_adequate_diet" FLOAT,
"affordability_of_a_nutrient_adequate_diet_ratio_of_cos_9183146c" FLOAT,
"percent_of_the_population_who_cannot_afford_nutrient_adequacy" FLOAT,
"affordability_of_a_nutrient_adequate_diet_ratio_of_cos_602b8374" FLOAT,
"people_who_cannot_afford_nutrient_adequacy" FLOAT,
"population" BIGINT
);
CREATE TABLE owid_food_prices_for_nutrition_3 (
"country" VARCHAR,
"year" INTEGER,
"cost_of_an_energy_sufficient_diet" FLOAT,
"affordability_of_an_energy_sufficient_diet_ratio_of_co_8ffb1a17" FLOAT,
"percent_of_the_population_who_cannot_afford_sufficient_calories" FLOAT,
"affordability_of_an_energy_sufficient_diet_ratio_of_co_18664a38" FLOAT,
"people_who_cannot_afford_sufficient_calories" UINTEGER,
"cost_of_a_healthy_diet" FLOAT,
"cost_of_a_healthy_diet_relative_to_the_cost_of_suffici_b7920004" FLOAT,
"cost_of_animal_source_foods" FLOAT,
"cost_share_for_animal_sourced_foods_in_a_least_cost_he_00e5cabf" FLOAT,
"cost_of_animal_sourced_foods_relative_to_the_starchy_s_efb2deec" FLOAT,
"cost_of_fruits" FLOAT,
"cost_share_for_fruits_in_a_least_cost_healthy_diet" FLOAT,
"cost_of_fruits_relative_to_the_starchy_staples_in_a_le_0f888e29" FLOAT,
"affordability_of_a_healthy_diet_ratio_of_cost_to_food__dd98fefa" FLOAT,
"percent_of_the_population_who_cannot_afford_a_healthy_diet" FLOAT,
"cost_of_legumes_nuts_and_seeds" FLOAT,
"cost_share_for_legumes_nuts_and_seeds_in_a_least_cost__9f5f2345" FLOAT,
"cost_of_legumes_nuts_and_seeds_relative_to_the_starchy_9b5a6efe" FLOAT,
"cost_of_oils_and_fats" FLOAT,
"cost_share_for_oils_and_fats_in_a_least_cost_healthy_diet" FLOAT,
"cost_of_oils_and_fats_relative_to_the_starchy_staples__2c005259" FLOAT,
"affordability_of_a_healthy_diet_ratio_of_cost_to_the_f_71e2af92" FLOAT,
"cost_of_starchy_staples" FLOAT,
"cost_share_for_starchy_staples_in_a_least_cost_healthy_diet" FLOAT,
"people_who_cannot_afford_a_healthy_diet" UINTEGER,
"cost_of_vegetables" FLOAT,
"cost_share_for_vegetables_in_a_least_cost_healthy_diet" FLOAT,
"cost_of_vegetables_relative_to_the_starchy_staples_in__2b2bff71" FLOAT,
"cost_of_a_nutrient_adequate_diet" FLOAT,
"affordability_of_a_nutrient_adequate_diet_ratio_of_cos_9183146c" FLOAT,
"percent_of_the_population_who_cannot_afford_nutrient_adequacy" FLOAT,
"affordability_of_a_nutrient_adequate_diet_ratio_of_cos_602b8374" FLOAT,
"people_who_cannot_afford_nutrient_adequacy" UINTEGER,
"population" UINTEGER
);
Anyone who has the link will be able to view this.