Dataset: Additional Variables (FAOSTAT, 2023b)

Agriculture Land Use Evolution 1

@owid.additional_variables.owid_agriculture_land_use_evolution_1

418.31 KB
12614 rows
12 columns


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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

Tables

Agriculture Land Use Evolution 1

Inputs: Land Use

Land, Inputs And Sustainability: Land Use

Arable Land Per Crop Output 1

Arable Land Per Crop Output 2

Arable Land Per Crop Output 3

Area Used Per Crop Type 1

Production: Crops And Livestock Products

Production: Crops And Livestock Products

Cereal Allocation 1

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

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

Fertilizer Exports 1

Inputs: Fertilizers By Nutrient

Land, Inputs And Sustainability: Fertilizers By Nutrient

Fertilizers 1

Fertilizers 2

Fertilizers 3

Food Available For Consumption 1

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

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

Production: Crops And Livestock Products

Hypothetical Meat Consumption 1

Production: Crops And Livestock Products

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

Land Spared By Increased Crop Yields 1

Production: Crops And Livestock Products

Production: Crops And Livestock Products

Macronutrient Compositions 1

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

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

Maize And Wheat 1

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

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

Production: Crops And Livestock Products

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

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

Share Of Sustainable And Overexploited Fish 1

SDG Indicators: SDG Indicators

SDG Indicators: SDG Indicators

Vegetable Oil Yields 1

Vegetable Oil Yields 2

Vegetable Oil Yields 3