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

About this Dataset

Crop Yields

In agriculture, the yield is a measurement of the amount of a crop grown, or product such as wool, meat or milk produced, per unit area of land. The seed ratio is another way of calculating yields. Wikipedia

@article{owidcropyields,
author = {Hannah Ritchie and Max Roser},
title = {Crop Yields},
journal = {Our World in Data},
year = {2013},
note = {https://ourworldindata.org/crop-yields}
}

Tables

Palm Oil Yields

@kaggle.programmerrdai_crop_yields.palm_oil_yields

24.56 kB
3,392 rows
4 columns

CREATE TABLE palm_oil_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_oil_palm_fruit_254_yield_5419_hg_ha" DOUBLE  -- Crops - Oil Palm Fruit - 254 - Yield - 5419 - Hg/ha
);

Pea Yields

@kaggle.programmerrdai_crop_yields.pea_yields

50.67 kB
6,235 rows
4 columns

CREATE TABLE pea_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_peas_dry_187_yield_5419_hg_ha" DOUBLE  -- Crops - Peas, Dry - 187 - Yield - 5419 - Hg/ha
);

Potato Yields

@kaggle.programmerrdai_crop_yields.potato_yields

78.25 kB
10,016 rows
4 columns

CREATE TABLE potato_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_potatoes_116_yield_5419_hg_ha" DOUBLE  -- Crops - Potatoes - 116 - Yield - 5419 - Hg/ha
);

Rapeseed Yields

@kaggle.programmerrdai_crop_yields.rapeseed_yields

31.86 kB
4,143 rows
4 columns

CREATE TABLE rapeseed_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_rapeseed_270_yield_5419_hg_ha" DOUBLE  -- Crops - Rapeseed - 270 - Yield - 5419 - Hg/ha
);

Rice Yields

@kaggle.programmerrdai_crop_yields.rice_yields

86.71 kB
11,789 rows
4 columns

CREATE TABLE rice_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_cereals_rice_milled_eqv_1817_yield_5419_hg_ha" DOUBLE  -- Crops - Cereals (Rice Milled Eqv) - 1817 - Yield - 5419 - Hg/ha
);

Soybean Yields

@kaggle.programmerrdai_crop_yields.soybean_yields

42.52 kB
5,961 rows
4 columns

CREATE TABLE soybean_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_soybeans_236_yield_5419_hg_ha" DOUBLE  -- Crops - Soybeans - 236 - Yield - 5419 - Hg/ha
);

Sugar Beet Yields

@kaggle.programmerrdai_crop_yields.sugar_beet_yields

35.33 kB
4,027 rows
4 columns

CREATE TABLE sugar_beet_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_sugar_beet_157_yield_5419_hg_ha" DOUBLE  -- Crops - Sugar Beet - 157 - Yield - 5419 - Hg/ha
);

Sugar Cane Yields

@kaggle.programmerrdai_crop_yields.sugar_cane_yields

57.06 kB
7,590 rows
4 columns

CREATE TABLE sugar_cane_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_sugar_cane_156_yield_5419_hg_ha" DOUBLE  -- Crops - Sugar Cane - 156 - Yield - 5419 - Hg/ha
);

Tea Yields

@kaggle.programmerrdai_crop_yields.tea_yields

28.61 kB
3,906 rows
4 columns

CREATE TABLE tea_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_tea_667_yield_5419_hg_ha" DOUBLE  -- Crops - Tea - 667 - Yield - 5419 - Hg/ha
);

Tomato Yields

@kaggle.programmerrdai_crop_yields.tomato_yields

82.28 kB
10,609 rows
4 columns

CREATE TABLE tomato_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_tomatoes_388_yield_5419_hg_ha" DOUBLE  -- Crops - Tomatoes - 388 - Yield - 5419 - Hg/ha
);

Wheat Yields

@kaggle.programmerrdai_crop_yields.wheat_yields

59.79 kB
8,101 rows
4 columns

CREATE TABLE wheat_yields (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crops_wheat_15_yield_5419_hg_ha" DOUBLE  -- Crops - Wheat - 15 - Yield - 5419 - Hg/ha
);