Crop Yields by Kaggle | Environmental and Climate Sciences

Agri Yields Uk

@kaggle.programmerrdai_crop_yields.agri_yields_uk

7.41 KB
435 rows
5 columns


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

Almond Yields

@kaggle.programmerrdai_crop_yields.almond_yields

23.77 KB
3018 rows
4 columns


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

Arable Land Pin

@kaggle.programmerrdai_crop_yields.arable_land_pin

113.47 KB
11280 rows
4 columns


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

Attainable Yields Mueller Et Al 2012

@kaggle.programmerrdai_crop_yields.attainable_yields_mueller_et_al_2012

229.02 KB
8094 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.31 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
);

Banana Yields

@kaggle.programmerrdai_crop_yields.banana_yields

63.35 KB
8909 rows
4 columns


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

Bean Yields

@kaggle.programmerrdai_crop_yields.bean_yields

51.7 KB
8009 rows
4 columns


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

Cashew Nut Yields

@kaggle.programmerrdai_crop_yields.cashew_nut_yields

19 KB
2376 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
);

Cassava Yields

@kaggle.programmerrdai_crop_yields.cassava_yields

50.83 KB
7188 rows
4 columns


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

Cereal Crop Yield Vs Fertilizer Application

@kaggle.programmerrdai_crop_yields.cereal_crop_yield_vs_fertilizer_application

109.05 KB
12054 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,
  "fertilizers_indicators_nutrient_nitrogen_n_total_3102__a882958f" DOUBLE,
  "continent" VARCHAR
);

Cereal Land Spared

@kaggle.programmerrdai_crop_yields.cereal_land_spared

5.63 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_area_harvested" BIGINT
);

Cereal Yield

@kaggle.programmerrdai_crop_yields.cereal_yield

85.83 KB
11789 rows
4 columns


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

Cereal Yields Uk

@kaggle.programmerrdai_crop_yields.cereal_yields_uk

24.38 KB
612 rows
6 columns


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

Cereal Yields Vs Tractor Inputs In Agriculture

@kaggle.programmerrdai_crop_yields.cereal_yields_vs_tractor_inputs_in_agriculture

522.88 KB
56459 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,
  "cereal_yield_kg_per_hectare" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

Change Of Cereal Yield Vs Land Used

@kaggle.programmerrdai_crop_yields.change_of_cereal_yield_vs_land_used

151.53 KB
11800 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_area_harvested_5312_ha" BIGINT
);

Cocoa Bean Yields

@kaggle.programmerrdai_crop_yields.cocoa_bean_yields

28.48 KB
4609 rows
4 columns


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

Coffee Yields

@kaggle.programmerrdai_crop_yields.coffee_yields

35.5 KB
5828 rows
4 columns


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

Groundnuts Yield

@kaggle.programmerrdai_crop_yields.groundnuts_yield

50.96 KB
7960 rows
4 columns


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

Index Of Cereal Production Yield And Land Use

@kaggle.programmerrdai_crop_yields.index_of_cereal_production_yield_and_land_use

357.91 KB
16599 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_production_5510_tonnes" DOUBLE,
  "crops_cereals_total_1717_yield_5419_hg_ha" DOUBLE,
  "population_historical_estimates" DOUBLE
);

Key Crop Yields

@kaggle.programmerrdai_crop_yields.key_crop_yields

550.87 KB
13075 rows
14 columns


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

Land Use Vs Yield Change In Cereal Production

@kaggle.programmerrdai_crop_yields.land_use_vs_yield_change_in_cereal_production

435.96 KB
58081 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,
  "land_under_cereal_production_index_world_bank_2017" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

Lettuce Yields

@kaggle.programmerrdai_crop_yields.lettuce_yields

48.61 KB
6333 rows
4 columns


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

Long Term Wheat Yields In Europe

@kaggle.programmerrdai_crop_yields.long_term_wheat_yields_in_europe

50.63 KB
7268 rows
4 columns


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

Maize Yields

@kaggle.programmerrdai_crop_yields.maize_yields

76.15 KB
10774 rows
4 columns


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

Orange Yields

@kaggle.programmerrdai_crop_yields.orange_yields

55.72 KB
7593 rows
4 columns


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

Palm Oil Yields

@kaggle.programmerrdai_crop_yields.palm_oil_yields

23.99 KB
3392 rows
4 columns


CREATE TABLE palm_oil_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_oil_palm_fruit_254_yield_5419_hg_ha" DOUBLE
);

Pea Yields

@kaggle.programmerrdai_crop_yields.pea_yields

49.48 KB
6235 rows
4 columns


CREATE TABLE pea_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_peas_dry_187_yield_5419_hg_ha" DOUBLE
);

Potato Yields

@kaggle.programmerrdai_crop_yields.potato_yields

76.42 KB
10016 rows
4 columns


CREATE TABLE potato_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_potatoes_116_yield_5419_hg_ha" DOUBLE
);

Rapeseed Yields

@kaggle.programmerrdai_crop_yields.rapeseed_yields

31.11 KB
4143 rows
4 columns


CREATE TABLE rapeseed_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_rapeseed_270_yield_5419_hg_ha" DOUBLE
);

Rice Yields

@kaggle.programmerrdai_crop_yields.rice_yields

84.68 KB
11789 rows
4 columns


CREATE TABLE rice_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cereals_rice_milled_eqv_1817_yield_5419_hg_ha" DOUBLE
);

Soybean Yields

@kaggle.programmerrdai_crop_yields.soybean_yields

41.53 KB
5961 rows
4 columns


CREATE TABLE soybean_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_soybeans_236_yield_5419_hg_ha" DOUBLE
);

Sugar Beet Yields

@kaggle.programmerrdai_crop_yields.sugar_beet_yields

34.5 KB
4027 rows
4 columns


CREATE TABLE sugar_beet_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_sugar_beet_157_yield_5419_hg_ha" DOUBLE
);

Sugar Cane Yields

@kaggle.programmerrdai_crop_yields.sugar_cane_yields

55.72 KB
7590 rows
4 columns


CREATE TABLE sugar_cane_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_sugar_cane_156_yield_5419_hg_ha" DOUBLE
);

Tea Yields

@kaggle.programmerrdai_crop_yields.tea_yields

27.94 KB
3906 rows
4 columns


CREATE TABLE tea_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_tea_667_yield_5419_hg_ha" DOUBLE
);

Tomato Yields

@kaggle.programmerrdai_crop_yields.tomato_yields

80.36 KB
10609 rows
4 columns


CREATE TABLE tomato_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_tomatoes_388_yield_5419_hg_ha" DOUBLE
);

Wheat Yields

@kaggle.programmerrdai_crop_yields.wheat_yields

58.39 KB
8101 rows
4 columns


CREATE TABLE wheat_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_wheat_15_yield_5419_hg_ha" DOUBLE
);