Crop Yields

CREATE TABLE agri_yields_uk (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "potatoes_uk_yields" DOUBLE,
  "sugar_beet_uk_yields" DOUBLE
);

CREATE TABLE almond_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_almonds_with_shell_221_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE arable_land_pin (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "arable_land_per_crop_output_pin_fao_2019" DOUBLE
);

CREATE TABLE attainable_yields_mueller_et_al_2012 (
  "entity" VARCHAR,
  "year" BIGINT,
  "barley_attainable" DOUBLE,
  "cassava_attainable" DOUBLE,
  "cotton_attainable" DOUBLE,
  "groundnut_attainable" DOUBLE,
  "maize_attainable" DOUBLE,
  "millet_attainable" DOUBLE,
  "oilpalm_attainable" DOUBLE,
  "potato_attainable" DOUBLE,
  "rapeseed_attainable" DOUBLE,
  "rice_attainable" DOUBLE,
  "rye_attainable" DOUBLE,
  "sorghum_attainable" DOUBLE,
  "soybean_attainable" DOUBLE,
  "sugarbeet_attainable" DOUBLE,
  "sugarcane_attainable" DOUBLE,
  "sunflower_attainable" DOUBLE,
  "wheat_attainable" DOUBLE,
  "wheat_yield_gap" DOUBLE,
  "barley_yield_gap" DOUBLE,
  "rye_yield_gap" DOUBLE,
  "millet_yield_gap" DOUBLE,
  "sorghum_yield_gap" DOUBLE,
  "maize_yield_gap" DOUBLE,
  "cassava_yield_gap" DOUBLE,
  "soybeans_yield_gap" DOUBLE,
  "rapeseed_yield_gap" DOUBLE,
  "sugarbeet_yield_gap" DOUBLE,
  "sugarcane_yield_gap" DOUBLE,
  "potato_yield_gap" DOUBLE,
  "oilpalm_yield_gap" DOUBLE,
  "groundnut_yield_gap" DOUBLE,
  "rice_yield_gap" DOUBLE,
  "sunflower_yield_gap" DOUBLE,
  "cotton_yield_gap" DOUBLE
);

CREATE TABLE average_corn_yields_in_the_united_states_1866_2014 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "corn_yield_usda_2017_fao_2017" DOUBLE
);

CREATE TABLE banana_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_bananas_486_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE bean_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_beans_dry_176_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE cashew_nut_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cashew_nuts_with_shell_217_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE cassava_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cassava_125_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE cereal_crop_yield_vs_fertilizer_application (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cereals_total_1717_yield_5419_hg_ha" DOUBLE,
  "fertilizers_indicators_nutrient_nitrogen_n_total_3102__a882958f" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE cereal_land_spared (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cereals_additional_cropland_area_needed_if_yields_stag_60b14224" DOUBLE,
  "cereals_area_harvested" BIGINT
);

CREATE TABLE cereal_yield (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cereals_total_1717_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE cereal_yields_uk (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "wheat_uk_yields" DOUBLE,
  "barley_uk_yields" DOUBLE,
  "oats_uk_yields" DOUBLE
);

CREATE TABLE cereal_yields_vs_tractor_inputs_in_agriculture (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "agricultural_machinery_tractors_per_100_sq_km_of_arable_land" DOUBLE,
  "cereal_yield_kg_per_hectare" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE change_of_cereal_yield_vs_land_used (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cereals_total_1717_yield_5419_hg_ha" DOUBLE,
  "crops_cereals_total_1717_area_harvested_5312_ha" BIGINT
);

CREATE TABLE cocoa_bean_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cocoa_beans_661_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE coffee_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_coffee_green_656_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE groundnuts_yield (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_groundnuts_with_shell_242_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE index_of_cereal_production_yield_and_land_use (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cereals_total_1717_area_harvested_5312_ha" DOUBLE,
  "crops_cereals_total_1717_production_5510_tonnes" DOUBLE,
  "crops_cereals_total_1717_yield_5419_hg_ha" DOUBLE,
  "population_historical_estimates" DOUBLE
);

CREATE TABLE key_crop_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_wheat_15_yield_5419_hg_ha" DOUBLE,
  "crops_rice_paddy_27_yield_5419_hg_ha" DOUBLE,
  "crops_maize_56_yield_5419_hg_ha" DOUBLE,
  "crops_soybeans_236_yield_5419_hg_ha" DOUBLE,
  "crops_potatoes_116_yield_5419_hg_ha" DOUBLE,
  "crops_beans_dry_176_yield_5419_hg_ha" DOUBLE,
  "crops_peas_dry_187_yield_5419_hg_ha" DOUBLE,
  "crops_cassava_125_yield_5419_hg_ha" DOUBLE,
  "crops_barley_44_yield_5419_hg_ha" DOUBLE,
  "crops_cocoa_beans_661_yield_5419_hg_ha" DOUBLE,
  "crops_bananas_486_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE land_use_vs_yield_change_in_cereal_production (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cereal_yield_index_world_bank_2017_owid" DOUBLE,
  "land_under_cereal_production_index_world_bank_2017" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE lettuce_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_lettuce_and_chicory_372_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE long_term_wheat_yields_in_europe (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "wheat_fao_2017_bayliss_smith_1984" DOUBLE
);

CREATE TABLE maize_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_maize_56_yield_5419_hg_ha" DOUBLE
);

CREATE TABLE orange_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_oranges_490_yield_5419_hg_ha" DOUBLE
);