Name: Coffee Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Coffee Dataset

Dataset contain information about coffee production and consumption.

All data are available from the official ICO website:
https://www.ico.org/new_historical.asp

Data were brought into usable form by JupyterLab Python notebook.

For more details about notebook visit repo: https://github.com/MSI17819/Coffee_data_analysis/blob/main/Coffee_codeimpro.ipynb

Statistics are given in kilo (1000 grams) unit.

Tables

Coffee Domestic Consumption

@kaggle.michals22_coffee_dataset.coffee_domestic_consumption

32.52 KB
55 rows
33 columns


CREATE TABLE coffee_domestic_consumption (
  "country" VARCHAR,
  "coffee_type" VARCHAR,
  "n_1990_91" BIGINT,
  "n_1991_92" BIGINT,
  "n_1992_93" BIGINT,
  "n_1993_94" BIGINT,
  "n_1994_95" BIGINT,
  "n_1995_96" BIGINT,
  "n_1996_97" BIGINT,
  "n_1997_98" BIGINT,
  "n_1998_99" BIGINT,
  "n_1999_00" BIGINT,
  "n_2000_01" BIGINT,
  "n_2001_02" BIGINT,
  "n_2002_03" BIGINT,
  "n_2003_04" BIGINT,
  "n_2004_05" BIGINT,
  "n_2005_06" BIGINT,
  "n_2006_07" BIGINT,
  "n_2007_08" BIGINT,
  "n_2008_09" BIGINT,
  "n_2009_10" BIGINT,
  "n_2010_11" BIGINT,
  "n_2011_12" BIGINT,
  "n_2012_13" BIGINT,
  "n_2013_14" BIGINT,
  "n_2014_15" BIGINT,
  "n_2015_16" BIGINT,
  "n_2016_17" BIGINT,
  "n_2017_18" BIGINT,
  "n_2018_19" BIGINT,
  "n_2019_20" BIGINT,
  "total_domestic_consumption" BIGINT
);

Coffee Export

@kaggle.michals22_coffee_dataset.coffee_export

31.84 KB
55 rows
32 columns


CREATE TABLE coffee_export (
  "country" VARCHAR,
  "n_1990" BIGINT,
  "n_1991" BIGINT,
  "n_1992" BIGINT,
  "n_1993" BIGINT,
  "n_1994" BIGINT,
  "n_1995" BIGINT,
  "n_1996" BIGINT,
  "n_1997" BIGINT,
  "n_1998" BIGINT,
  "n_1999" BIGINT,
  "n_2000" BIGINT,
  "n_2001" BIGINT,
  "n_2002" BIGINT,
  "n_2003" BIGINT,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "total_export" BIGINT
);

Coffee Green Coffee Inventorie

@kaggle.michals22_coffee_dataset.coffee_green_coffee_inventorie

24.79 KB
18 rows
32 columns


CREATE TABLE coffee_green_coffee_inventorie (
  "country" VARCHAR,
  "n_1990" BIGINT,
  "n_1991" BIGINT,
  "n_1992" BIGINT,
  "n_1993" BIGINT,
  "n_1994" BIGINT,
  "n_1995" BIGINT,
  "n_1996" BIGINT,
  "n_1997" BIGINT,
  "n_1998" BIGINT,
  "n_1999" BIGINT,
  "n_2000" BIGINT,
  "n_2001" BIGINT,
  "n_2002" BIGINT,
  "n_2003" BIGINT,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "total_inventorie" BIGINT
);

Coffee Import

@kaggle.michals22_coffee_dataset.coffee_import

28.55 KB
35 rows
32 columns


CREATE TABLE coffee_import (
  "country" VARCHAR,
  "n_1990" BIGINT,
  "n_1991" BIGINT,
  "n_1992" BIGINT,
  "n_1993" BIGINT,
  "n_1994" BIGINT,
  "n_1995" BIGINT,
  "n_1996" BIGINT,
  "n_1997" BIGINT,
  "n_1998" BIGINT,
  "n_1999" BIGINT,
  "n_2000" BIGINT,
  "n_2001" BIGINT,
  "n_2002" BIGINT,
  "n_2003" BIGINT,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "total_import" BIGINT
);

Coffee Importers Consumption

@kaggle.michals22_coffee_dataset.coffee_importers_consumption

28.64 KB
35 rows
32 columns


CREATE TABLE coffee_importers_consumption (
  "country" VARCHAR,
  "n_1990" BIGINT,
  "n_1991" BIGINT,
  "n_1992" BIGINT,
  "n_1993" BIGINT,
  "n_1994" BIGINT,
  "n_1995" BIGINT,
  "n_1996" BIGINT,
  "n_1997" BIGINT,
  "n_1998" BIGINT,
  "n_1999" BIGINT,
  "n_2000" BIGINT,
  "n_2001" BIGINT,
  "n_2002" BIGINT,
  "n_2003" BIGINT,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "total_import_consumption" BIGINT
);

Coffee Production

@kaggle.michals22_coffee_dataset.coffee_production

34.02 KB
55 rows
33 columns


CREATE TABLE coffee_production (
  "country" VARCHAR,
  "coffee_type" VARCHAR,
  "n_1990_91" DOUBLE,
  "n_1991_92" DOUBLE,
  "n_1992_93" DOUBLE,
  "n_1993_94" DOUBLE,
  "n_1994_95" DOUBLE,
  "n_1995_96" DOUBLE,
  "n_1996_97" DOUBLE,
  "n_1997_98" DOUBLE,
  "n_1998_99" DOUBLE,
  "n_1999_00" DOUBLE,
  "n_2000_01" DOUBLE,
  "n_2001_02" DOUBLE,
  "n_2002_03" DOUBLE,
  "n_2003_04" DOUBLE,
  "n_2004_05" DOUBLE,
  "n_2005_06" DOUBLE,
  "n_2006_07" DOUBLE,
  "n_2007_08" DOUBLE,
  "n_2008_09" DOUBLE,
  "n_2009_10" DOUBLE,
  "n_2010_11" DOUBLE,
  "n_2011_12" DOUBLE,
  "n_2012_13" DOUBLE,
  "n_2013_14" DOUBLE,
  "n_2014_15" DOUBLE,
  "n_2015_16" DOUBLE,
  "n_2016_17" DOUBLE,
  "n_2017_18" DOUBLE,
  "n_2018_19" DOUBLE,
  "n_2019_20" DOUBLE,
  "total_production" DOUBLE
);

Coffee Re Export

@kaggle.michals22_coffee_dataset.coffee_re_export

27.76 KB
35 rows
32 columns


CREATE TABLE coffee_re_export (
  "country" VARCHAR,
  "n_1990" BIGINT,
  "n_1991" BIGINT,
  "n_1992" BIGINT,
  "n_1993" BIGINT,
  "n_1994" BIGINT,
  "n_1995" BIGINT,
  "n_1996" BIGINT,
  "n_1997" BIGINT,
  "n_1998" BIGINT,
  "n_1999" BIGINT,
  "n_2000" BIGINT,
  "n_2001" BIGINT,
  "n_2002" BIGINT,
  "n_2003" BIGINT,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "total_re_export" BIGINT
);