Additional Variables (FAOSTAT, 2023b)
@owid.additional_variables
@owid.additional_variables
CREATE TABLE owid_agriculture_land_use_evolution_1 (
"country" VARCHAR,
"year" INTEGER,
"agriculture_area" FLOAT,
"agriculture_area_change" FLOAT,
"agriculture_area_one_decade_back" FLOAT,
"cropland_area" FLOAT,
"cropland_area_change" FLOAT,
"cropland_area_one_decade_back" FLOAT,
"pasture_area" FLOAT,
"pasture_area_change" FLOAT,
"pasture_area_one_decade_back" FLOAT,
"year_one_decade_back" INTEGER
);
CREATE TABLE owid_agriculture_land_use_evolution_2 (
"country" VARCHAR,
"year" INTEGER,
"agriculture_area" FLOAT,
"agriculture_area_change" FLOAT,
"agriculture_area_one_decade_back" FLOAT,
"cropland_area" FLOAT,
"cropland_area_change" FLOAT,
"cropland_area_one_decade_back" FLOAT,
"pasture_area" FLOAT,
"pasture_area_change" FLOAT,
"pasture_area_one_decade_back" FLOAT,
"year_one_decade_back" INTEGER
);
CREATE TABLE owid_agriculture_land_use_evolution_3 (
"country" VARCHAR,
"year" INTEGER,
"agriculture_area" FLOAT,
"agriculture_area_change" FLOAT,
"agriculture_area_one_decade_back" FLOAT,
"cropland_area" FLOAT,
"cropland_area_change" FLOAT,
"cropland_area_one_decade_back" FLOAT,
"pasture_area" FLOAT,
"pasture_area_change" FLOAT,
"pasture_area_one_decade_back" FLOAT,
"year_one_decade_back" INTEGER
);
CREATE TABLE owid_arable_land_per_crop_output_1 (
"country" VARCHAR,
"year" INTEGER,
"area" FLOAT,
"index" FLOAT,
"arable_land_per_crop_output" FLOAT
);
CREATE TABLE owid_arable_land_per_crop_output_2 (
"country" VARCHAR,
"year" INTEGER,
"area" FLOAT,
"index" FLOAT,
"arable_land_per_crop_output" FLOAT
);
CREATE TABLE owid_arable_land_per_crop_output_3 (
"country" VARCHAR,
"year" INTEGER,
"area" FLOAT,
"index" FLOAT,
"arable_land_per_crop_output" FLOAT
);
CREATE TABLE owid_area_used_per_crop_type_1 (
"item" VARCHAR,
"year" INTEGER,
"area_used_for_production" FLOAT
);
CREATE TABLE owid_area_used_per_crop_type_2 (
"item" VARCHAR,
"year" INTEGER,
"area_used_for_production" FLOAT
);
CREATE TABLE owid_area_used_per_crop_type_3 (
"item" VARCHAR,
"year" INTEGER,
"area_used_for_production" UINTEGER
);
CREATE TABLE owid_cereal_allocation_1 (
"country" VARCHAR,
"year" INTEGER,
"cereals_allocated_to_animal_feed" FLOAT,
"cereals_allocated_to_food" FLOAT,
"cereals_allocated_to_other_uses" FLOAT,
"share_of_cereals_allocated_to_animal_feed" FLOAT,
"share_of_cereals_allocated_to_food" FLOAT,
"share_of_cereals_allocated_to_other_uses" FLOAT
);
CREATE TABLE owid_cereal_allocation_2 (
"country" VARCHAR,
"year" INTEGER,
"cereals_allocated_to_animal_feed" FLOAT,
"cereals_allocated_to_food" FLOAT,
"cereals_allocated_to_other_uses" FLOAT,
"share_of_cereals_allocated_to_animal_feed" FLOAT,
"share_of_cereals_allocated_to_food" FLOAT,
"share_of_cereals_allocated_to_other_uses" FLOAT
);
CREATE TABLE owid_cereal_allocation_3 (
"country" VARCHAR,
"year" INTEGER,
"cereals_allocated_to_animal_feed" UINTEGER,
"cereals_allocated_to_food" UINTEGER,
"cereals_allocated_to_other_uses" UINTEGER,
"share_of_cereals_allocated_to_animal_feed" FLOAT,
"share_of_cereals_allocated_to_food" FLOAT,
"share_of_cereals_allocated_to_other_uses" FLOAT
);
CREATE TABLE owid_fertilizer_exports_1 (
"country" VARCHAR,
"year" INTEGER,
"item" VARCHAR,
"exports" FLOAT,
"share_of_exports" FLOAT
);
CREATE TABLE owid_fertilizer_exports_2 (
"country" VARCHAR,
"year" INTEGER,
"item" VARCHAR,
"exports" FLOAT,
"share_of_exports" FLOAT
);
CREATE TABLE owid_fertilizer_exports_3 (
"country" VARCHAR,
"year" INTEGER,
"item" VARCHAR,
"exports" FLOAT,
"share_of_exports" FLOAT
);
CREATE TABLE owid_fertilizers_1 (
"country" VARCHAR,
"year" INTEGER,
"nitrogen_per_cropland" FLOAT,
"phosphate_per_cropland" FLOAT,
"potash_per_cropland" FLOAT,
"all_fertilizers_per_cropland" FLOAT,
"cropland" FLOAT,
"nitrogen_use" FLOAT,
"phosphate_use" FLOAT,
"potash_use" FLOAT,
"all_fertilizers_use" FLOAT
);
CREATE TABLE owid_fertilizers_2 (
"country" VARCHAR,
"year" INTEGER,
"nitrogen_per_cropland" FLOAT,
"phosphate_per_cropland" FLOAT,
"potash_per_cropland" FLOAT,
"all_fertilizers_per_cropland" FLOAT,
"cropland" FLOAT,
"nitrogen_use" FLOAT,
"phosphate_use" FLOAT,
"potash_use" FLOAT,
"all_fertilizers_use" FLOAT
);
CREATE TABLE owid_fertilizers_3 (
"country" VARCHAR,
"year" INTEGER,
"nitrogen_per_cropland" FLOAT,
"phosphate_per_cropland" FLOAT,
"potash_per_cropland" FLOAT,
"all_fertilizers_per_cropland" FLOAT,
"cropland" FLOAT,
"nitrogen_use" FLOAT,
"phosphate_use" FLOAT,
"potash_use" FLOAT,
"all_fertilizers_use" FLOAT
);
CREATE TABLE owid_food_available_for_consumption_1 (
"country" VARCHAR,
"year" INTEGER,
"cereals_and_grains" FLOAT,
"pulses" FLOAT,
"starchy_roots" FLOAT,
"fruits_and_vegetables" FLOAT,
"oils_and_fats" FLOAT,
"sugar" FLOAT,
"meat" FLOAT,
"dairy_and_eggs" FLOAT,
"alcoholic_beverages" FLOAT,
"other" FLOAT
);
CREATE TABLE owid_food_available_for_consumption_2 (
"country" VARCHAR,
"year" INTEGER,
"cereals_and_grains" FLOAT,
"pulses" FLOAT,
"starchy_roots" FLOAT,
"fruits_and_vegetables" FLOAT,
"oils_and_fats" FLOAT,
"sugar" FLOAT,
"meat" FLOAT,
"dairy_and_eggs" FLOAT,
"alcoholic_beverages" FLOAT,
"other" FLOAT
);
CREATE TABLE owid_food_available_for_consumption_3 (
"country" VARCHAR,
"year" INTEGER,
"cereals_and_grains" FLOAT,
"pulses" FLOAT,
"starchy_roots" FLOAT,
"fruits_and_vegetables" FLOAT,
"oils_and_fats" FLOAT,
"sugar" FLOAT,
"meat" FLOAT,
"dairy_and_eggs" FLOAT,
"alcoholic_beverages" FLOAT,
"other" FLOAT
);
CREATE TABLE owid_hypothetical_animals_slaughtered (
"country" VARCHAR,
"year" INTEGER,
"animals_global" BIGINT,
"animals_global_hypothetical" BIGINT,
"animals_per_capita" FLOAT,
"global_population" BIGINT
);
CREATE TABLE owid_hypothetical_meat_consumption_1 (
"country" VARCHAR,
"year" INTEGER,
"animals_global" FLOAT,
"animals_global_hypothetical" FLOAT,
"animals_per_capita" FLOAT,
"global_population" BIGINT,
"production_global" FLOAT,
"production_global_hypothetical" FLOAT,
"production_per_capita" FLOAT
);
CREATE TABLE owid_hypothetical_meat_consumption_2 (
"country" VARCHAR,
"year" INTEGER,
"animals_global" FLOAT,
"animals_global_hypothetical" BIGINT,
"animals_per_capita" FLOAT,
"global_population" BIGINT,
"production_global" FLOAT,
"production_global_hypothetical" UINTEGER,
"production_per_capita" FLOAT
);
CREATE TABLE owid_hypothetical_meat_consumption_3 (
"country" VARCHAR,
"year" INTEGER,
"global_population" BIGINT,
"meat_global_hypothetical" UINTEGER,
"meat_per_capita" FLOAT
);
CREATE TABLE owid_land_spared_by_increased_crop_yields_1 (
"country" VARCHAR,
"year" INTEGER,
"item" VARCHAR,
"area" FLOAT,
"area_with_yield_of_1961" FLOAT,
"spared_land" FLOAT,
"spared_land_pct" FLOAT
);
CREATE TABLE owid_land_spared_by_increased_crop_yields_2 (
"country" VARCHAR,
"year" INTEGER,
"item" VARCHAR,
"area" FLOAT,
"area_with_yield_of_1961" FLOAT,
"spared_land" FLOAT,
"spared_land_pct" FLOAT
);
CREATE TABLE owid_land_spared_by_increased_crop_yields_3 (
"country" VARCHAR,
"year" INTEGER,
"item" VARCHAR,
"area" FLOAT,
"area_with_yield_of_1961" FLOAT,
"spared_land" FLOAT,
"spared_land_pct" FLOAT
);
CREATE TABLE owid_macronutrient_compositions_1 (
"country" VARCHAR,
"year" INTEGER,
"total_energy" FLOAT,
"energy_from_vegetal_products" FLOAT,
"energy_from_animal_products" FLOAT,
"total_fat" FLOAT,
"fat_from_vegetal_products" FLOAT,
"fat_from_animal_products" FLOAT,
"total_protein" FLOAT,
"protein_from_vegetal_products" FLOAT,
"protein_from_animal_products" FLOAT,
"total_energy_from_fat" FLOAT,
"total_energy_from_protein" FLOAT,
"total_energy_from_carbohydrates" FLOAT,
"total_carbohydrates" FLOAT,
"share_of_energy_from_fat" FLOAT,
"share_of_energy_from_protein" FLOAT,
"share_of_energy_from_carbohydrates" FLOAT,
"energy_from_animal_protein" FLOAT,
"share_of_energy_from_animal_protein" FLOAT,
"energy_from_vegetal_protein" FLOAT,
"share_of_energy_from_vegetal_protein" FLOAT
);
CREATE TABLE owid_macronutrient_compositions_2 (
"country" VARCHAR,
"year" INTEGER,
"total_energy" FLOAT,
"energy_from_vegetal_products" FLOAT,
"energy_from_animal_products" FLOAT,
"total_fat" FLOAT,
"fat_from_vegetal_products" FLOAT,
"fat_from_animal_products" FLOAT,
"total_protein" FLOAT,
"protein_from_vegetal_products" FLOAT,
"protein_from_animal_products" FLOAT,
"total_energy_from_fat" FLOAT,
"total_energy_from_protein" FLOAT,
"total_energy_from_carbohydrates" FLOAT,
"total_carbohydrates" FLOAT,
"share_of_energy_from_fat" FLOAT,
"share_of_energy_from_protein" FLOAT,
"share_of_energy_from_carbohydrates" FLOAT,
"energy_from_animal_protein" FLOAT,
"share_of_energy_from_animal_protein" FLOAT,
"energy_from_vegetal_protein" FLOAT,
"share_of_energy_from_vegetal_protein" FLOAT
);
CREATE TABLE owid_macronutrient_compositions_3 (
"country" VARCHAR,
"year" INTEGER,
"energy_from_animal_products" FLOAT,
"total_energy" FLOAT,
"energy_from_vegetal_products" FLOAT,
"fat_from_animal_products" FLOAT,
"total_fat" FLOAT,
"fat_from_vegetal_products" FLOAT,
"protein_from_animal_products" FLOAT,
"total_protein" FLOAT,
"protein_from_vegetal_products" FLOAT,
"total_energy_from_fat" FLOAT,
"total_energy_from_protein" FLOAT,
"total_energy_from_carbohydrates" FLOAT,
"total_carbohydrates" FLOAT,
"share_of_energy_from_fat" FLOAT,
"share_of_energy_from_protein" FLOAT,
"share_of_energy_from_carbohydrates" FLOAT,
"energy_from_animal_protein" FLOAT,
"share_of_energy_from_animal_protein" FLOAT,
"energy_from_vegetal_protein" FLOAT,
"share_of_energy_from_vegetal_protein" FLOAT
);
CREATE TABLE owid_maize_and_wheat_1 (
"country" VARCHAR,
"year" INTEGER,
"maize_animal_feed" FLOAT,
"maize_exports" FLOAT,
"maize_other_uses" FLOAT,
"wheat_animal_feed" FLOAT,
"wheat_exports" FLOAT,
"wheat_other_uses" FLOAT
);
CREATE TABLE owid_maize_and_wheat_2 (
"country" VARCHAR,
"year" INTEGER,
"maize_animal_feed" FLOAT,
"maize_exports" FLOAT,
"maize_other_uses" FLOAT,
"wheat_animal_feed" FLOAT,
"wheat_exports" FLOAT,
"wheat_other_uses" FLOAT
);
CREATE TABLE owid_maize_and_wheat_3 (
"country" VARCHAR,
"year" INTEGER,
"maize_animal_feed" UINTEGER,
"maize_exports" UINTEGER,
"maize_other_uses" UINTEGER,
"wheat_animal_feed" UINTEGER,
"wheat_exports" INTEGER,
"wheat_other_uses" UINTEGER
);
CREATE TABLE owid_milk_per_animal (
"country" VARCHAR,
"year" INTEGER,
"animals_used_for_milk" UINTEGER,
"milk_production" FLOAT,
"milk_per_animal" FLOAT
);
CREATE TABLE owid_net_exports_as_share_of_supply_1 (
"country" VARCHAR,
"year" INTEGER,
"net_exports_as_share_of_supply" FLOAT
);
CREATE TABLE owid_net_exports_as_share_of_supply_2 (
"country" VARCHAR,
"year" INTEGER,
"net_exports_as_share_of_supply" FLOAT
);
CREATE TABLE owid_share_of_sustainable_and_overexploited_fish_1 (
"country" VARCHAR,
"year" INTEGER,
"sustainable_fish" FLOAT,
"overexploited_fish" FLOAT
);
CREATE TABLE owid_share_of_sustainable_and_overexploited_fish_2 (
"country" VARCHAR,
"year" INTEGER,
"sustainable_fish" FLOAT,
"overexploited_fish" FLOAT
);
CREATE TABLE owid_share_of_sustainable_and_overexploited_fish_3 (
"country" VARCHAR,
"year" INTEGER,
"sustainable_fish" FLOAT,
"overexploited_fish" FLOAT
);
CREATE TABLE owid_vegetable_oil_yields_1 (
"country" VARCHAR,
"year" INTEGER,
"sunflower_production" FLOAT,
"soybean_production" FLOAT,
"groundnut_production" FLOAT,
"coconut_production" FLOAT,
"olive_production" FLOAT,
"cottonseed_production" FLOAT,
"sesame_production" FLOAT,
"rapeseed_production" FLOAT,
"palm_production" FLOAT,
"sunflower_area" FLOAT,
"cottonseed_area" FLOAT,
"soybean_area" FLOAT,
"groundnut_area" FLOAT,
"olive_area" FLOAT,
"rapeseed_area" FLOAT,
"coconut_area" FLOAT,
"sesame_area" FLOAT,
"palm_area" FLOAT,
"vegetable_oils_production" FLOAT,
"palm_tonnes_per_hectare" FLOAT,
"palm_hectares_per_tonne" FLOAT,
"palm_area_to_meet_global_oil_demand" FLOAT,
"sunflower_tonnes_per_hectare" FLOAT,
"sunflower_hectares_per_tonne" FLOAT,
"sunflower_area_to_meet_global_oil_demand" FLOAT,
"rapeseed_tonnes_per_hectare" FLOAT,
"rapeseed_hectares_per_tonne" FLOAT,
"rapeseed_area_to_meet_global_oil_demand" FLOAT,
"soybean_tonnes_per_hectare" FLOAT,
"soybean_hectares_per_tonne" FLOAT,
"soybean_area_to_meet_global_oil_demand" FLOAT,
"olive_tonnes_per_hectare" FLOAT,
"olive_hectares_per_tonne" FLOAT,
"olive_area_to_meet_global_oil_demand" FLOAT,
"coconut_tonnes_per_hectare" FLOAT,
"coconut_hectares_per_tonne" FLOAT,
"coconut_area_to_meet_global_oil_demand" FLOAT,
"groundnut_tonnes_per_hectare" FLOAT,
"groundnut_hectares_per_tonne" FLOAT,
"groundnut_area_to_meet_global_oil_demand" FLOAT,
"cottonseed_tonnes_per_hectare" FLOAT,
"cottonseed_hectares_per_tonne" FLOAT,
"cottonseed_area_to_meet_global_oil_demand" FLOAT,
"sesame_tonnes_per_hectare" FLOAT,
"sesame_hectares_per_tonne" FLOAT,
"sesame_area_to_meet_global_oil_demand" FLOAT
);
CREATE TABLE owid_vegetable_oil_yields_2 (
"country" VARCHAR,
"year" INTEGER,
"sunflower_production" FLOAT,
"soybean_production" FLOAT,
"groundnut_production" FLOAT,
"coconut_production" FLOAT,
"olive_production" FLOAT,
"rapeseed_production" FLOAT,
"sesame_production" FLOAT,
"cottonseed_production" FLOAT,
"palm_production" FLOAT,
"sunflower_area" FLOAT,
"cottonseed_area" FLOAT,
"soybean_area" FLOAT,
"groundnut_area" FLOAT,
"olive_area" FLOAT,
"rapeseed_area" FLOAT,
"coconut_area" FLOAT,
"sesame_area" FLOAT,
"palm_area" FLOAT,
"vegetable_oils_production" FLOAT,
"palm_tonnes_per_hectare" FLOAT,
"palm_hectares_per_tonne" FLOAT,
"palm_area_to_meet_global_oil_demand" FLOAT,
"sunflower_tonnes_per_hectare" FLOAT,
"sunflower_hectares_per_tonne" FLOAT,
"sunflower_area_to_meet_global_oil_demand" FLOAT,
"rapeseed_tonnes_per_hectare" FLOAT,
"rapeseed_hectares_per_tonne" FLOAT,
"rapeseed_area_to_meet_global_oil_demand" FLOAT,
"soybean_tonnes_per_hectare" FLOAT,
"soybean_hectares_per_tonne" FLOAT,
"soybean_area_to_meet_global_oil_demand" FLOAT,
"olive_tonnes_per_hectare" FLOAT,
"olive_hectares_per_tonne" FLOAT,
"olive_area_to_meet_global_oil_demand" FLOAT,
"coconut_tonnes_per_hectare" FLOAT,
"coconut_hectares_per_tonne" FLOAT,
"coconut_area_to_meet_global_oil_demand" FLOAT,
"groundnut_tonnes_per_hectare" FLOAT,
"groundnut_hectares_per_tonne" FLOAT,
"groundnut_area_to_meet_global_oil_demand" FLOAT,
"cottonseed_tonnes_per_hectare" FLOAT,
"cottonseed_hectares_per_tonne" FLOAT,
"cottonseed_area_to_meet_global_oil_demand" FLOAT,
"sesame_tonnes_per_hectare" FLOAT,
"sesame_hectares_per_tonne" FLOAT,
"sesame_area_to_meet_global_oil_demand" FLOAT
);
CREATE TABLE owid_vegetable_oil_yields_3 (
"country" VARCHAR,
"year" INTEGER,
"soybean_production" FLOAT,
"groundnut_production" FLOAT,
"coconut_production" FLOAT,
"palm_production" FLOAT,
"olive_production" FLOAT,
"sunflower_production" FLOAT,
"rapeseed_production" FLOAT,
"sesame_production" FLOAT,
"cottonseed_production" FLOAT,
"soybean_area" UINTEGER,
"groundnut_area" UINTEGER,
"coconut_area" UINTEGER,
"palm_area" UINTEGER,
"olive_area" UINTEGER,
"sunflower_area" UINTEGER,
"rapeseed_area" UINTEGER,
"sesame_area" UINTEGER,
"cottonseed_area" UINTEGER,
"vegetable_oils_production" UINTEGER,
"palm_tonnes_per_hectare" FLOAT,
"palm_hectares_per_tonne" FLOAT,
"palm_area_to_meet_global_oil_demand" BIGINT,
"sunflower_tonnes_per_hectare" FLOAT,
"sunflower_hectares_per_tonne" FLOAT,
"sunflower_area_to_meet_global_oil_demand" FLOAT,
"rapeseed_tonnes_per_hectare" FLOAT,
"rapeseed_hectares_per_tonne" FLOAT,
"rapeseed_area_to_meet_global_oil_demand" FLOAT,
"soybean_tonnes_per_hectare" FLOAT,
"soybean_hectares_per_tonne" FLOAT,
"soybean_area_to_meet_global_oil_demand" FLOAT,
"olive_tonnes_per_hectare" FLOAT,
"olive_hectares_per_tonne" FLOAT,
"olive_area_to_meet_global_oil_demand" BIGINT,
"coconut_tonnes_per_hectare" FLOAT,
"coconut_hectares_per_tonne" FLOAT,
"coconut_area_to_meet_global_oil_demand" BIGINT,
"groundnut_tonnes_per_hectare" FLOAT,
"groundnut_hectares_per_tonne" FLOAT,
"groundnut_area_to_meet_global_oil_demand" FLOAT,
"cottonseed_tonnes_per_hectare" FLOAT,
"cottonseed_hectares_per_tonne" FLOAT,
"cottonseed_area_to_meet_global_oil_demand" FLOAT,
"sesame_tonnes_per_hectare" FLOAT,
"sesame_hectares_per_tonne" FLOAT,
"sesame_area_to_meet_global_oil_demand" FLOAT
);
Anyone who has the link will be able to view this.