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
  • 446.29 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.54 KB
  • 13003 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.54 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.17 KB
  • 12879 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.15 KB
  • 12879 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
);

Share link

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