Baselight

Additional Variables (FAOSTAT, 2023b)

@owid.additional_variables

Loading...
Loading...

About this Dataset

Additional Variables (FAOSTAT, 2023b)

Additional variables created using data from different FAOSTAT datasets.

Tables

Land Spared By Increased Crop Yields 1

@owid.additional_variables.owid_land_spared_by_increased_crop_yields_1
  • 2.02 MB
  • 87945 rows
  • 7 columns
Loading...

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
);

Production: Crops And Livestock Products

@owid.additional_variables.owid_land_spared_by_increased_crop_yields_2
  • 2.05 MB
  • 89394 rows
  • 7 columns
Loading...

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
);

Production: Crops And Livestock Products

@owid.additional_variables.owid_land_spared_by_increased_crop_yields_3
  • 2.09 MB
  • 91218 rows
  • 7 columns
Loading...

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
);

Macronutrient Compositions 1

@owid.additional_variables.owid_macronutrient_compositions_1
  • 1.35 MB
  • 12360 rows
  • 22 columns
Loading...

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
);

Food Balances (old Methodology Before 2010, And New From 2010 Onwards)

@owid.additional_variables.owid_macronutrient_compositions_2
  • 1.37 MB
  • 12592 rows
  • 22 columns
Loading...

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
);

Food Balances (old Methodology Before 2010, And New From 2010 Onwards)

@owid.additional_variables.owid_macronutrient_compositions_3
  • 1.41 MB
  • 12879 rows
  • 22 columns
Loading...

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
);

Maize And Wheat 1

@owid.additional_variables.owid_maize_and_wheat_1
  • 142.92 KB
  • 12516 rows
  • 8 columns
Loading...

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
);

Food Balances (old Methodology Before 2010, And New From 2010 Onwards)

@owid.additional_variables.owid_maize_and_wheat_2
  • 146.67 KB
  • 12750 rows
  • 8 columns
Loading...

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
);

Food Balances (old Methodology Before 2010, And New From 2010 Onwards)

@owid.additional_variables.owid_maize_and_wheat_3
  • 149.8 KB
  • 13003 rows
  • 8 columns
Loading...

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
);

Production: Crops And Livestock Products

@owid.additional_variables.owid_milk_per_animal
  • 218.56 KB
  • 13860 rows
  • 5 columns
Loading...

CREATE TABLE owid_milk_per_animal (
  "country" VARCHAR,
  "year" INTEGER,
  "animals_used_for_milk" UINTEGER,
  "milk_production" FLOAT,
  "milk_per_animal" FLOAT
);

Food Balances (old Methodology Before 2010, And New From 2010 Onwards)

@owid.additional_variables.owid_net_exports_as_share_of_supply_1
  • 78.5 KB
  • 12751 rows
  • 3 columns
Loading...

CREATE TABLE owid_net_exports_as_share_of_supply_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "net_exports_as_share_of_supply" FLOAT
);

Food Balances (old Methodology Before 2010, And New From 2010 Onwards)

@owid.additional_variables.owid_net_exports_as_share_of_supply_2
  • 79.98 KB
  • 13004 rows
  • 3 columns
Loading...

CREATE TABLE owid_net_exports_as_share_of_supply_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "net_exports_as_share_of_supply" FLOAT
);

Share Of Sustainable And Overexploited Fish 1

@owid.additional_variables.owid_share_of_sustainable_and_overexploited_fish_1
  • 8.67 KB
  • 217 rows
  • 4 columns
Loading...

CREATE TABLE owid_share_of_sustainable_and_overexploited_fish_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "sustainable_fish" FLOAT,
  "overexploited_fish" FLOAT
);

SDG Indicators: SDG Indicators

@owid.additional_variables.owid_share_of_sustainable_and_overexploited_fish_2
  • 8.67 KB
  • 217 rows
  • 4 columns
Loading...

CREATE TABLE owid_share_of_sustainable_and_overexploited_fish_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sustainable_fish" FLOAT,
  "overexploited_fish" FLOAT
);

SDG Indicators

@owid.additional_variables.owid_share_of_sustainable_and_overexploited_fish_3
  • 7.44 KB
  • 318 rows
  • 4 columns
Loading...

CREATE TABLE owid_share_of_sustainable_and_overexploited_fish_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "sustainable_fish" FLOAT,
  "overexploited_fish" FLOAT
);

Vegetable Oil Yields 1

@owid.additional_variables.owid_vegetable_oil_yields_1
  • 1.23 MB
  • 13485 rows
  • 48 columns
Loading...

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
);

Vegetable Oil Yields 2

@owid.additional_variables.owid_vegetable_oil_yields_2
  • 1.26 MB
  • 13959 rows
  • 48 columns
Loading...

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
);

Vegetable Oil Yields 3

@owid.additional_variables.owid_vegetable_oil_yields_3
  • 1.3 MB
  • 13992 rows
  • 48 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.