Additional Variables (FAOSTAT, 2023b)
@owid.additional_variables
@owid.additional_variables
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
);
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
);
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
);
CREATE TABLE owid_arable_land_per_crop_output_1 (
"country" VARCHAR,
"year" INTEGER,
"area" FLOAT,
"index" FLOAT,
"arable_land_per_crop_output" FLOAT
);
CREATE TABLE owid_arable_land_per_crop_output_2 (
"country" VARCHAR,
"year" INTEGER,
"area" FLOAT,
"index" FLOAT,
"arable_land_per_crop_output" FLOAT
);
CREATE TABLE owid_arable_land_per_crop_output_3 (
"country" VARCHAR,
"year" INTEGER,
"area" FLOAT,
"index" FLOAT,
"arable_land_per_crop_output" FLOAT
);
CREATE TABLE owid_area_used_per_crop_type_1 (
"item" VARCHAR,
"year" INTEGER,
"area_used_for_production" FLOAT
);
CREATE TABLE owid_area_used_per_crop_type_2 (
"item" VARCHAR,
"year" INTEGER,
"area_used_for_production" FLOAT
);
CREATE TABLE owid_area_used_per_crop_type_3 (
"item" VARCHAR,
"year" INTEGER,
"area_used_for_production" UINTEGER
);
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
);
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
);
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
);
CREATE TABLE owid_fertilizer_exports_1 (
"country" VARCHAR,
"year" INTEGER,
"item" VARCHAR,
"exports" FLOAT,
"share_of_exports" FLOAT
);
CREATE TABLE owid_fertilizer_exports_2 (
"country" VARCHAR,
"year" INTEGER,
"item" VARCHAR,
"exports" FLOAT,
"share_of_exports" FLOAT
);
CREATE TABLE owid_fertilizer_exports_3 (
"country" VARCHAR,
"year" INTEGER,
"item" VARCHAR,
"exports" FLOAT,
"share_of_exports" FLOAT
);
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
);
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
);
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
);
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
);
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
);
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
);
CREATE TABLE owid_hypothetical_animals_slaughtered (
"country" VARCHAR,
"year" INTEGER,
"animals_global" BIGINT,
"animals_global_hypothetical" BIGINT,
"animals_per_capita" FLOAT,
"global_population" BIGINT
);
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
);
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
);
CREATE TABLE owid_hypothetical_meat_consumption_3 (
"country" VARCHAR,
"year" INTEGER,
"global_population" BIGINT,
"meat_global_hypothetical" UINTEGER,
"meat_per_capita" FLOAT
);
Anyone who has the link will be able to view this.