Coffee Dataset

Coffee economic indicatores from the International Coffee Organization dataset

@kaggle.michals22_coffee_dataset

Table List

7 tables(208.13 KB)

Coffee Domestic Consumption

Coffee Export

Coffee Green Coffee Inventorie

Coffee Import

Coffee Importers Consumption

Coffee Production

Coffee Re Export

Coffee Importers Consumption

@kaggle.michals22_coffee_dataset.coffee_importers_consumption

28.64 KB
35 rows
32 columns

country Country	n_1990 1990	n_1991 1991	n_1992 1992	n_1993 1993	n_1994 1994	n_1995 1995	n_1996 1996	n_1997 1997	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	total_import_consumption Total Import Consumption
Austria	80400000	78120000	72720000	80100000	65160000	60720000	64560000	65220000	66300000	67380000	52500000	60780000	55560000	43200000	59760000	46320000	36720000	50820000	54480000	53160000	54180000	67020000	76140000	74940000	68100000	68160000	71580000	69720000	70320000	70380000	1904520000
Belgium										50040000	67980000	53040000	89040000	94740000	83760000	69480000	92220000	66180000	39000000	56040000	52260000	56040000	54900000	74700000	75540000	64440000	90120000	78000000	81900000	71100000	1460520000
Belgium/Luxembourg	67440000	42480000	41760000	47340000	57480000	64380000	62340000	53160000	78540000																						514920000
Bulgaria	6120000	1020000	10500000	19620000	21180000	23580000	14760000	16500000	19440000	21780000	16500000	21000000	20460000	23820000	21840000	25800000	25200000	21840000	26700000	24540000	23700000	21600000	22560000	25140000	22560000	24360000	27120000	24900000	25560000	25380000	625080000
Croatia			8100000	7920000	9840000	17280000	18240000	21660000	19200000	20220000	19620000	20220000	21300000	22500000	22200000	22440000	23160000	23160000	22620000	21960000	22200000	22020000	21600000	23220000	22080000	22500000	22800000	21660000	21600000	22860000	564180000
Cyprus	1860000	2700000	2340000	4680000	2700000	2580000	3120000	2760000	2760000	3240000	4020000	3180000	3060000	3180000	3600000	4200000	3300000	4140000	4620000	4500000	4440000	4860000	5100000	5340000	4860000	5580000	5580000	5820000	7800000	6900000	122820000
Czechia	39540000	31500000	28320000	26880000	30540000	30660000	28500000	29100000	31380000	33480000	33600000	37980000	38520000	37380000	36300000	39360000	37860000	40740000	37260000	31500000	28200000	34320000	41100000	38220000	59880000	42480000	48360000	48240000	69480000	50580000	1141260000
Denmark	51900000	54540000	57540000	53460000	54480000	45480000	53700000	48480000	51240000	52140000	47460000	52080000	48300000	43440000	50940000	47700000	49320000	47640000	41280000	40560000	48360000	45720000	48000000	49320000	44880000	43860000	45180000	43980000	44340000	46680000	1452000000
Estonia			780000	2640000	3780000	4980000	5040000	5940000	5400000	5700000	5820000	6420000	6660000	6840000	7740000	8700000	10020000	6060000	9240000	7380000	6300000	4020000	6240000	7200000	7020000	7140000	7260000	6540000	7560000	7380000	175800000
Finland	64200000	57960000	61800000	67740000	63000000	44100000	54060000	56340000	60060000	58740000	58020000	56820000	58200000	57960000	62040000	66120000	62820000	63420000	66900000	63480000	64800000	65580000	64920000	65700000	61800000	66600000	68820000	63720000	66360000	80880000	1872960000


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