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 Import

@kaggle.michals22_coffee_dataset.coffee_import

28.55 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 Total Import
Austria	112800000	123480000	132360000	110160000	85020000	73860000	72600000	77640000	77580000	90000000	75420000	85920000	86820000	80160000	92280000	94620000	96060000	118080000	114060000	78540000	82140000	87120000	93540000	93300000	91500000	90780000	89700000	87600000	85740000	86880000	2765760000
Belgium										180180000	209460000	192540000	227520000	229080000	238080000	243780000	276300000	240840000	407520000	354960000	355440000	349680000	340080000	330120000	312720000	332040000	363120000	340620000	344520000	371940000	6240540000
Belgium/Luxembourg	120900000	104760000	109680000	123780000	135720000	144060000	151560000	152640000	214800000																						1257900000
Bulgaria	16080000	12000000	10920000	23820000	27780000	30900000	16320000	17640000	20520000	22020000	16860000	21300000	20580000	24000000	22020000	26460000	26100000	23580000	31020000	31380000	31680000	28920000	33600000	36540000	37260000	40920000	46740000	42420000	44220000	47100000	830700000
Croatia			10080000	9780000	11580000	19200000	19320000	23100000	20340000	21120000	20640000	21120000	22260000	23580000	23280000	23520000	24240000	24840000	24300000	23640000	23640000	23460000	23040000	24780000	25200000	26220000	28740000	26340000	26760000	27960000	622080000
Cyprus	3000000	3240000	2460000	4620000	3120000	2640000	3120000	2460000	3000000	3300000	4140000	3540000	3420000	3540000	3540000	4800000	4440000	4260000	4680000	4320000	4620000	4920000	5040000	5640000	5640000	5340000	5580000	6000000	7980000	7980000	130380000
Czechia	39540000	31500000	28500000	30840000	33240000	33180000	31500000	33600000	45900000	43680000	48540000	53940000	53280000	58440000	55740000	63780000	56400000	62220000	62220000	55800000	57060000	57120000	67620000	71040000	109380000	124080000	106740000	90420000	114180000	96540000	1816020000
Denmark	57540000	58980000	63720000	59640000	61980000	52620000	60360000	56940000	60840000	65640000	61320000	66180000	64560000	60120000	67140000	59580000	60240000	59700000	54000000	51600000	60900000	54540000	54780000	55260000	51180000	50460000	54360000	51120000	52080000	54480000	1741860000
Estonia			960000	3060000	4980000	6420000	7020000	8460000	8100000	7860000	6300000	9660000	7200000	8040000	10560000	13260000	15240000	16620000	20040000	21420000	15780000	10020000	9420000	9360000	7860000	7560000	8100000	7980000	8820000	8880000	268980000
Finland	65700000	61980000	63300000	78060000	81660000	46140000	59520000	71160000	70080000	72540000	63780000	65040000	64500000	66300000	69120000	69360000	70080000	72420000	77100000	74580000	76440000	77220000	74280000	76500000	72780000	79260000	83340000	81600000	77100000	90900000	2151840000


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