Agriculture Land Use Evolution 1

@owid.additional_variables.owid_agriculture_land_use_evolution_1

428.35 kB
12,614 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

444.28 kB
12,883 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

457.01 kB
13,154 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

165.97 kB
11,760 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

170.01 kB
11,900 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

171.53 kB
12,089 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.76 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.88 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.99 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

297.11 kB
12,516 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

302.83 kB
12,750 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

308.68 kB
13,003 rows
8 columns

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

Fertilizer Exports 1

@owid.additional_variables.owid_fertilizer_exports_1

186.27 kB
19,030 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

209.1 kB
22,752 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

227.51 kB
27,610 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

463.39 kB
15,214 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

515.49 kB
15,482 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

521.77 kB
15,750 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

661.03 kB
12,360 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

653.81 kB
12,592 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

703.7 kB
12,879 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

190.77 kB
12,354 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

292.15 kB
12,131 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

333.25 kB
12,374 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

157.97 kB
12,879 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
);

Additional Variables (FAOSTAT, 2023b)

About this Dataset