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

33.3 kB
55 rows
33 columns

CREATE TABLE coffee_domestic_consumption (
  "country" VARCHAR,
  "coffee_type" VARCHAR,
  "n_1990_91" BIGINT  -- 1990/91,
  "n_1991_92" BIGINT  -- 1991/92,
  "n_1992_93" BIGINT  -- 1992/93,
  "n_1993_94" BIGINT  -- 1993/94,
  "n_1994_95" BIGINT  -- 1994/95,
  "n_1995_96" BIGINT  -- 1995/96,
  "n_1996_97" BIGINT  -- 1996/97,
  "n_1997_98" BIGINT  -- 1997/98,
  "n_1998_99" BIGINT  -- 1998/99,
  "n_1999_00" BIGINT  -- 1999/00,
  "n_2000_01" BIGINT  -- 2000/01,
  "n_2001_02" BIGINT  -- 2001/02,
  "n_2002_03" BIGINT  -- 2002/03,
  "n_2003_04" BIGINT  -- 2003/04,
  "n_2004_05" BIGINT  -- 2004/05,
  "n_2005_06" BIGINT  -- 2005/06,
  "n_2006_07" BIGINT  -- 2006/07,
  "n_2007_08" BIGINT  -- 2007/08,
  "n_2008_09" BIGINT  -- 2008/09,
  "n_2009_10" BIGINT  -- 2009/10,
  "n_2010_11" BIGINT  -- 2010/11,
  "n_2011_12" BIGINT  -- 2011/12,
  "n_2012_13" BIGINT  -- 2012/13,
  "n_2013_14" BIGINT  -- 2013/14,
  "n_2014_15" BIGINT  -- 2014/15,
  "n_2015_16" BIGINT  -- 2015/16,
  "n_2016_17" BIGINT  -- 2016/17,
  "n_2017_18" BIGINT  -- 2017/18,
  "n_2018_19" BIGINT  -- 2018/19,
  "n_2019_20" BIGINT  -- 2019/20,
  "total_domestic_consumption" BIGINT
);

Coffee Export

@kaggle.michals22_coffee_dataset.coffee_export

32.61 kB
55 rows
32 columns

CREATE TABLE coffee_export (
  "country" VARCHAR,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "total_export" BIGINT
);

Coffee Green Coffee Inventorie

@kaggle.michals22_coffee_dataset.coffee_green_coffee_inventorie

25.39 kB
18 rows
32 columns

CREATE TABLE coffee_green_coffee_inventorie (
  "country" VARCHAR,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "total_inventorie" BIGINT
);

Coffee Import

@kaggle.michals22_coffee_dataset.coffee_import

29.24 kB
35 rows
32 columns

CREATE TABLE coffee_import (
  "country" VARCHAR,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "total_import" BIGINT
);

Coffee Importers Consumption

@kaggle.michals22_coffee_dataset.coffee_importers_consumption

29.33 kB
35 rows
32 columns

CREATE TABLE coffee_importers_consumption (
  "country" VARCHAR,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "total_import_consumption" BIGINT
);

Coffee Production

@kaggle.michals22_coffee_dataset.coffee_production

34.84 kB
55 rows
33 columns

CREATE TABLE coffee_production (
  "country" VARCHAR,
  "coffee_type" VARCHAR,
  "n_1990_91" DOUBLE  -- 1990/91,
  "n_1991_92" DOUBLE  -- 1991/92,
  "n_1992_93" DOUBLE  -- 1992/93,
  "n_1993_94" DOUBLE  -- 1993/94,
  "n_1994_95" DOUBLE  -- 1994/95,
  "n_1995_96" DOUBLE  -- 1995/96,
  "n_1996_97" DOUBLE  -- 1996/97,
  "n_1997_98" DOUBLE  -- 1997/98,
  "n_1998_99" DOUBLE  -- 1998/99,
  "n_1999_00" DOUBLE  -- 1999/00,
  "n_2000_01" DOUBLE  -- 2000/01,
  "n_2001_02" DOUBLE  -- 2001/02,
  "n_2002_03" DOUBLE  -- 2002/03,
  "n_2003_04" DOUBLE  -- 2003/04,
  "n_2004_05" DOUBLE  -- 2004/05,
  "n_2005_06" DOUBLE  -- 2005/06,
  "n_2006_07" DOUBLE  -- 2006/07,
  "n_2007_08" DOUBLE  -- 2007/08,
  "n_2008_09" DOUBLE  -- 2008/09,
  "n_2009_10" DOUBLE  -- 2009/10,
  "n_2010_11" DOUBLE  -- 2010/11,
  "n_2011_12" DOUBLE  -- 2011/12,
  "n_2012_13" DOUBLE  -- 2012/13,
  "n_2013_14" DOUBLE  -- 2013/14,
  "n_2014_15" DOUBLE  -- 2014/15,
  "n_2015_16" DOUBLE  -- 2015/16,
  "n_2016_17" DOUBLE  -- 2016/17,
  "n_2017_18" DOUBLE  -- 2017/18,
  "n_2018_19" DOUBLE  -- 2018/19,
  "n_2019_20" DOUBLE  -- 2019/20,
  "total_production" DOUBLE
);

Coffee Re Export

@kaggle.michals22_coffee_dataset.coffee_re_export

28.42 kB
35 rows
32 columns

CREATE TABLE coffee_re_export (
  "country" VARCHAR,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "total_re_export" BIGINT
);