Land Spared By Increased Crop Yields 1

@owid.additional_variables.owid_land_spared_by_increased_crop_yields_1

2.11 MB
87,945 rows
7 columns

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  -- Spared Land, Pct
);

Production: Crops And Livestock Products

@owid.additional_variables.owid_land_spared_by_increased_crop_yields_2

2.15 MB
89,394 rows
7 columns

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  -- Spared Land, Pct
);

Production: Crops And Livestock Products

@owid.additional_variables.owid_land_spared_by_increased_crop_yields_3

2.19 MB
91,218 rows
7 columns

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  -- Spared Land, Pct
);

Macronutrient Compositions 1

@owid.additional_variables.owid_macronutrient_compositions_1

1.42 MB
12,360 rows
22 columns

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.44 MB
12,592 rows
22 columns

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.48 MB
12,879 rows
22 columns

CREATE TABLE owid_macronutrient_compositions_3 (
  "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
);

Maize And Wheat 1

@owid.additional_variables.owid_maize_and_wheat_1

146.35 kB
12,516 rows
8 columns

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

150.19 kB
12,750 rows
8 columns

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

153.41 kB
13,003 rows
8 columns

CREATE TABLE owid_maize_and_wheat_3 (
  "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
);

Production: Crops And Livestock Products

@owid.additional_variables.owid_milk_per_animal

223.8 kB
13,860 rows
5 columns

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

80.39 kB
12,751 rows
3 columns

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

81.92 kB
13,004 rows
3 columns

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.88 kB
217 rows
4 columns

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.88 kB
217 rows
4 columns

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.62 kB
318 rows
4 columns

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.29 MB
13,485 rows
48 columns

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.32 MB
13,959 rows
48 columns

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.36 MB
13,992 rows
48 columns

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" FLOAT,
  "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
);

Additional Variables (FAOSTAT, 2023b)

About this Dataset