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

Agriculture Land Use Evolution 1

@owid.additional_variables.owid_agriculture_land_use_evolution_1
  • 418.31 KB
  • 12614 rows
  • 12 columns
Loading...

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

Inputs: Land Use

@owid.additional_variables.owid_agriculture_land_use_evolution_2
  • 433.87 KB
  • 12883 rows
  • 12 columns
Loading...

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

Land, Inputs And Sustainability: Land Use

@owid.additional_variables.owid_agriculture_land_use_evolution_3
  • 447.5 KB
  • 13154 rows
  • 12 columns
Loading...

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

Arable Land Per Crop Output 1

@owid.additional_variables.owid_arable_land_per_crop_output_1
  • 162.08 KB
  • 11760 rows
  • 5 columns
Loading...

CREATE TABLE owid_arable_land_per_crop_output_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "area" FLOAT,
  "index" FLOAT,
  "arable_land_per_crop_output" FLOAT
);

Arable Land Per Crop Output 2

@owid.additional_variables.owid_arable_land_per_crop_output_2
  • 166.02 KB
  • 11900 rows
  • 5 columns
Loading...

CREATE TABLE owid_arable_land_per_crop_output_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "area" FLOAT,
  "index" FLOAT,
  "arable_land_per_crop_output" FLOAT
);

Arable Land Per Crop Output 3

@owid.additional_variables.owid_arable_land_per_crop_output_3
  • 167.51 KB
  • 12089 rows
  • 5 columns
Loading...

CREATE TABLE owid_arable_land_per_crop_output_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "area" FLOAT,
  "index" FLOAT,
  "arable_land_per_crop_output" FLOAT
);

Area Used Per Crop Type 1

@owid.additional_variables.owid_area_used_per_crop_type_1
  • 6.6 KB
  • 580 rows
  • 3 columns
Loading...

CREATE TABLE owid_area_used_per_crop_type_1 (
  "item" VARCHAR,
  "year" INTEGER,
  "area_used_for_production" FLOAT
);

Production: Crops And Livestock Products

@owid.additional_variables.owid_area_used_per_crop_type_2
  • 6.72 KB
  • 620 rows
  • 3 columns
Loading...

CREATE TABLE owid_area_used_per_crop_type_2 (
  "item" VARCHAR,
  "year" INTEGER,
  "area_used_for_production" FLOAT
);

Production: Crops And Livestock Products

@owid.additional_variables.owid_area_used_per_crop_type_3
  • 6.83 KB
  • 630 rows
  • 3 columns
Loading...

CREATE TABLE owid_area_used_per_crop_type_3 (
  "item" VARCHAR,
  "year" INTEGER,
  "area_used_for_production" UINTEGER
);

Cereal Allocation 1

@owid.additional_variables.owid_cereal_allocation_1
  • 290.15 KB
  • 12516 rows
  • 8 columns
Loading...

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

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

@owid.additional_variables.owid_cereal_allocation_2
  • 295.73 KB
  • 12750 rows
  • 8 columns
Loading...

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

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

@owid.additional_variables.owid_cereal_allocation_3
  • 301.57 KB
  • 13001 rows
  • 8 columns
Loading...

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

Fertilizer Exports 1

@owid.additional_variables.owid_fertilizer_exports_1
  • 181.91 KB
  • 19030 rows
  • 5 columns
Loading...

CREATE TABLE owid_fertilizer_exports_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "item" VARCHAR,
  "exports" FLOAT,
  "share_of_exports" FLOAT
);

Inputs: Fertilizers By Nutrient

@owid.additional_variables.owid_fertilizer_exports_2
  • 204.2 KB
  • 22752 rows
  • 5 columns
Loading...

CREATE TABLE owid_fertilizer_exports_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "item" VARCHAR,
  "exports" FLOAT,
  "share_of_exports" FLOAT
);

Land, Inputs And Sustainability: Fertilizers By Nutrient

@owid.additional_variables.owid_fertilizer_exports_3
  • 222.18 KB
  • 27610 rows
  • 5 columns
Loading...

CREATE TABLE owid_fertilizer_exports_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "item" VARCHAR,
  "exports" FLOAT,
  "share_of_exports" FLOAT
);

Fertilizers 1

@owid.additional_variables.owid_fertilizers_1
  • 452.53 KB
  • 15214 rows
  • 11 columns
Loading...

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

Fertilizers 2

@owid.additional_variables.owid_fertilizers_2
  • 503.41 KB
  • 15482 rows
  • 11 columns
Loading...

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

Fertilizers 3

@owid.additional_variables.owid_fertilizers_3
  • 509.69 KB
  • 15750 rows
  • 11 columns
Loading...

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

Food Available For Consumption 1

@owid.additional_variables.owid_food_available_for_consumption_1
  • 645.54 KB
  • 12360 rows
  • 12 columns
Loading...

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

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

@owid.additional_variables.owid_food_available_for_consumption_2
  • 638.48 KB
  • 12592 rows
  • 12 columns
Loading...

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

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

@owid.additional_variables.owid_food_available_for_consumption_3
  • 687.1 KB
  • 12877 rows
  • 12 columns
Loading...

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

Production: Crops And Livestock Products

@owid.additional_variables.owid_hypothetical_animals_slaughtered
  • 186.36 KB
  • 12354 rows
  • 6 columns
Loading...

CREATE TABLE owid_hypothetical_animals_slaughtered (
  "country" VARCHAR,
  "year" INTEGER,
  "animals_global" BIGINT,
  "animals_global_hypothetical" BIGINT,
  "animals_per_capita" FLOAT,
  "global_population" BIGINT
);

Hypothetical Meat Consumption 1

@owid.additional_variables.owid_hypothetical_meat_consumption_1
  • 285.3 KB
  • 12131 rows
  • 9 columns
Loading...

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

Production: Crops And Livestock Products

@owid.additional_variables.owid_hypothetical_meat_consumption_2
  • 325.44 KB
  • 12374 rows
  • 9 columns
Loading...

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

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

@owid.additional_variables.owid_hypothetical_meat_consumption_3
  • 154.14 KB
  • 12877 rows
  • 5 columns
Loading...

CREATE TABLE owid_hypothetical_meat_consumption_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "global_population" BIGINT,
  "meat_global_hypothetical" UINTEGER,
  "meat_per_capita" FLOAT
);

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
  • 12877 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
  • 150.03 KB
  • 13001 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
  • 219.13 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.97 KB
  • 13002 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: 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.