Additional Variables (FAOSTAT, 2023b)
@owid.additional_variables
@owid.additional_variables
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.