Name: Crop Yields
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

Agri Yields Uk

@kaggle.programmerrdai_crop_yields.agri_yields_uk

7.58 kB
435 rows
5 columns

CREATE TABLE agri_yields_uk (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "potatoes_uk_yields" DOUBLE  -- Potatoes (UK Yields),
  "sugar_beet_uk_yields" DOUBLE  -- Sugar Beet (UK Yields)
);

Almond Yields

@kaggle.programmerrdai_crop_yields.almond_yields

24.34 kB
3,018 rows
4 columns

CREATE TABLE almond_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_almonds_with_shell_221_yield_5419_hg_ha" DOUBLE  -- Crops - Almonds, With Shell - 221 - Yield - 5419 - Hg/ha
);

Arable Land Pin

@kaggle.programmerrdai_crop_yields.arable_land_pin

116.19 kB
11,280 rows
4 columns

CREATE TABLE arable_land_pin (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "arable_land_per_crop_output_pin_fao_2019" DOUBLE  -- Arable Land Per Crop Output (PIN) (FAO, 2019)
);

Attainable Yields Mueller Et Al 2012

@kaggle.programmerrdai_crop_yields.attainable_yields_mueller_et_al_2012

234.52 kB
8,094 rows
36 columns

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

Average Corn Yields In The United States 1866–2014

@kaggle.programmerrdai_crop_yields.average_corn_yields_in_the_united_states_1866_2014

5.43 kB
149 rows
4 columns

CREATE TABLE average_corn_yields_in_the_united_states_1866_2014 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "corn_yield_usda_2017_fao_2017" DOUBLE  -- Corn Yield (USDA (2017) \u0026 FAO (2017))
);

Banana Yields

@kaggle.programmerrdai_crop_yields.banana_yields

64.87 kB
8,909 rows
4 columns

CREATE TABLE banana_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_bananas_486_yield_5419_hg_ha" DOUBLE  -- Crops - Bananas - 486 - Yield - 5419 - Hg/ha
);

Bean Yields

@kaggle.programmerrdai_crop_yields.bean_yields

52.94 kB
8,009 rows
4 columns

CREATE TABLE bean_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_beans_dry_176_yield_5419_hg_ha" DOUBLE  -- Crops - Beans, Dry - 176 - Yield - 5419 - Hg/ha
);

Cashew Nut Yields

@kaggle.programmerrdai_crop_yields.cashew_nut_yields

19.46 kB
2,376 rows
4 columns

CREATE TABLE cashew_nut_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cashew_nuts_with_shell_217_yield_5419_hg_ha" DOUBLE  -- Crops - Cashew Nuts, With Shell - 217 - Yield - 5419 - Hg/ha
);

Cassava Yields

@kaggle.programmerrdai_crop_yields.cassava_yields

52.05 kB
7,188 rows
4 columns

CREATE TABLE cassava_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cassava_125_yield_5419_hg_ha" DOUBLE  -- Crops - Cassava - 125 - Yield - 5419 - Hg/ha
);

Cereal Crop Yield Vs Fertilizer Application

@kaggle.programmerrdai_crop_yields.cereal_crop_yield_vs_fertilizer_application

111.67 kB
12,054 rows
6 columns

CREATE TABLE cereal_crop_yield_vs_fertilizer_application (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cereals_total_1717_yield_5419_hg_ha" DOUBLE  -- Crops - Cereals, Total - 1717 - Yield - 5419 - Hg/ha,
  "fertilizers_indicators_nutrient_nitrogen_n_total_3102__a882958f" DOUBLE  -- Fertilizers Indicators - Nutrient Nitrogen N (total) - 3102 - Use Per Area Of Cropland - 5159 - Kg/ha,
  "continent" VARCHAR
);

Cereal Land Spared

@kaggle.programmerrdai_crop_yields.cereal_land_spared

5.77 kB
59 rows
5 columns

CREATE TABLE cereal_land_spared (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cereals_additional_cropland_area_needed_if_yields_stag_60b14224" DOUBLE  -- Cereals: Additional Cropland Area Needed If Yields Stagnated In 1961,
  "cereals_area_harvested" BIGINT  -- Cereals: Area Harvested
);

Cereal Yield

@kaggle.programmerrdai_crop_yields.cereal_yield

87.89 kB
11,789 rows
4 columns

CREATE TABLE cereal_yield (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cereals_total_1717_yield_5419_hg_ha" DOUBLE  -- Crops - Cereals, Total - 1717 - Yield - 5419 - Hg/ha
);

Cereal Yields Uk

@kaggle.programmerrdai_crop_yields.cereal_yields_uk

24.96 kB
612 rows
6 columns

CREATE TABLE cereal_yields_uk (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "wheat_uk_yields" DOUBLE  -- Wheat (UK Yields),
  "barley_uk_yields" DOUBLE  -- Barley (UK Yields),
  "oats_uk_yields" DOUBLE  -- Oats (UK Yields)
);

Cereal Yields Vs Tractor Inputs In Agriculture

@kaggle.programmerrdai_crop_yields.cereal_yields_vs_tractor_inputs_in_agriculture

535.43 kB
56,459 rows
7 columns

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  -- Agricultural Machinery, Tractors Per 100 Sq. Km Of Arable Land,
  "cereal_yield_kg_per_hectare" DOUBLE  -- Cereal Yield (kg Per Hectare),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Change Of Cereal Yield Vs Land Used

@kaggle.programmerrdai_crop_yields.change_of_cereal_yield_vs_land_used

155.16 kB
11,800 rows
5 columns

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 - Yield - 5419 - Hg/ha,
  "crops_cereals_total_1717_area_harvested_5312_ha" BIGINT  -- Crops - Cereals, Total - 1717 - Area Harvested - 5312 - Ha
);

Cocoa Bean Yields

@kaggle.programmerrdai_crop_yields.cocoa_bean_yields

29.17 kB
4,609 rows
4 columns

CREATE TABLE cocoa_bean_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cocoa_beans_661_yield_5419_hg_ha" DOUBLE  -- Crops - Cocoa, Beans - 661 - Yield - 5419 - Hg/ha
);

Coffee Yields

@kaggle.programmerrdai_crop_yields.coffee_yields

36.35 kB
5,828 rows
4 columns

CREATE TABLE coffee_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_coffee_green_656_yield_5419_hg_ha" DOUBLE  -- Crops - Coffee, Green - 656 - Yield - 5419 - Hg/ha
);

Groundnuts Yield

@kaggle.programmerrdai_crop_yields.groundnuts_yield

52.18 kB
7,960 rows
4 columns

CREATE TABLE groundnuts_yield (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_groundnuts_with_shell_242_yield_5419_hg_ha" DOUBLE  -- Crops - Groundnuts, With Shell - 242 - Yield - 5419 - Hg/ha
);

Index Of Cereal Production Yield And Land Use

@kaggle.programmerrdai_crop_yields.index_of_cereal_production_yield_and_land_use

366.5 kB
16,599 rows
7 columns

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 - Area Harvested - 5312 - Ha,
  "crops_cereals_total_1717_production_5510_tonnes" DOUBLE  -- Crops - Cereals, Total - 1717 - Production - 5510 - Tonnes,
  "crops_cereals_total_1717_yield_5419_hg_ha" DOUBLE  -- Crops - Cereals, Total - 1717 - Yield - 5419 - Hg/ha,
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates)
);

Key Crop Yields

@kaggle.programmerrdai_crop_yields.key_crop_yields

564.1 kB
13,075 rows
14 columns

CREATE TABLE key_crop_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_wheat_15_yield_5419_hg_ha" DOUBLE  -- Crops - Wheat - 15 - Yield - 5419 - Hg/ha,
  "crops_rice_paddy_27_yield_5419_hg_ha" DOUBLE  -- Crops - Rice, Paddy - 27 - Yield - 5419 - Hg/ha,
  "crops_maize_56_yield_5419_hg_ha" DOUBLE  -- Crops - Maize - 56 - Yield - 5419 - Hg/ha,
  "crops_soybeans_236_yield_5419_hg_ha" DOUBLE  -- Crops - Soybeans - 236 - Yield - 5419 - Hg/ha,
  "crops_potatoes_116_yield_5419_hg_ha" DOUBLE  -- Crops - Potatoes - 116 - Yield - 5419 - Hg/ha,
  "crops_beans_dry_176_yield_5419_hg_ha" DOUBLE  -- Crops - Beans, Dry - 176 - Yield - 5419 - Hg/ha,
  "crops_peas_dry_187_yield_5419_hg_ha" DOUBLE  -- Crops - Peas, Dry - 187 - Yield - 5419 - Hg/ha,
  "crops_cassava_125_yield_5419_hg_ha" DOUBLE  -- Crops - Cassava - 125 - Yield - 5419 - Hg/ha,
  "crops_barley_44_yield_5419_hg_ha" DOUBLE  -- Crops - Barley - 44 - Yield - 5419 - Hg/ha,
  "crops_cocoa_beans_661_yield_5419_hg_ha" DOUBLE  -- Crops - Cocoa, Beans - 661 - Yield - 5419 - Hg/ha,
  "crops_bananas_486_yield_5419_hg_ha" DOUBLE  -- Crops - Bananas - 486 - Yield - 5419 - Hg/ha
);

Land Use Vs Yield Change In Cereal Production

@kaggle.programmerrdai_crop_yields.land_use_vs_yield_change_in_cereal_production

446.42 kB
58,081 rows
7 columns

CREATE TABLE land_use_vs_yield_change_in_cereal_production (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cereal_yield_index_world_bank_2017_owid" DOUBLE  -- Cereal Yield Index (World Bank (2017) \u0026 OWID),
  "land_under_cereal_production_index_world_bank_2017" DOUBLE  -- Land Under Cereal Production Index (World Bank (2017)),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Lettuce Yields

@kaggle.programmerrdai_crop_yields.lettuce_yields

49.78 kB
6,333 rows
4 columns

CREATE TABLE lettuce_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_lettuce_and_chicory_372_yield_5419_hg_ha" DOUBLE  -- Crops - Lettuce And Chicory - 372 - Yield - 5419 - Hg/ha
);

Long Term Wheat Yields In Europe

@kaggle.programmerrdai_crop_yields.long_term_wheat_yields_in_europe

51.85 kB
7,268 rows
4 columns

CREATE TABLE long_term_wheat_yields_in_europe (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "wheat_fao_2017_bayliss_smith_1984" DOUBLE  -- Wheat (FAO (2017) \u0026 Bayliss-Smith (1984))
);

Maize Yields

@kaggle.programmerrdai_crop_yields.maize_yields

77.97 kB
10,774 rows
4 columns

CREATE TABLE maize_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_maize_56_yield_5419_hg_ha" DOUBLE  -- Crops - Maize - 56 - Yield - 5419 - Hg/ha
);

Orange Yields

@kaggle.programmerrdai_crop_yields.orange_yields

57.05 kB
7,593 rows
4 columns

CREATE TABLE orange_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_oranges_490_yield_5419_hg_ha" DOUBLE  -- Crops - Oranges - 490 - Yield - 5419 - Hg/ha
);

Crop Yields

About this Dataset