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 Re Export

@kaggle.michals22_coffee_dataset.coffee_re_export

27.76 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_re_export Total Re Export
Austria	24900000	45360000	57600000	32100000	22860000	13740000	9780000	13320000	12600000	23880000	24540000	26400000	31680000	37200000	32580000	48360000	59460000	67200000	59520000	24900000	27780000	21900000	18240000	18660000	23160000	22680000	18480000	18480000	15420000	16440000	869220000
Belgium										130140000	141420000	139440000	138480000	134280000	154320000	174300000	184020000	174660000	368520000	298860000	303180000	293640000	285240000	255420000	237180000	267600000	273000000	262620000	262620000	300840000	4779780000
Belgium/Luxembourg	53460000	62280000	67860000	76440000	78240000	79680000	89220000	99480000	136200000																						742860000
Bulgaria	9960000	10980000	420000	4200000	6600000	7320000	1560000	1140000	1080000	240000	360000	300000	180000	180000	180000	660000	840000	1740000	4320000	6840000	7980000	7320000	11040000	11460000	14640000	16500000	19620000	17520000	18720000	21720000	205620000
Croatia			2040000	1860000	1800000	1920000	1020000	1440000	1140000	900000	1020000	900000	960000	1020000	1080000	1080000	1080000	1620000	1680000	1680000	1440000	1440000	1440000	1560000	3060000	3780000	5940000	4680000	5160000	5160000	57900000
Cyprus	960000	420000	240000	120000	60000	60000	60000	60000	60000	120000	60000	240000	240000	360000	420000	540000	1080000	120000			120000		60000	120000	480000	180000	240000	120000	60000	1380000	7980000
Czechia			180000	3960000	2700000	2520000	3000000	4560000	14460000	10200000	14940000	15960000	14760000	21060000	19440000	24420000	18540000	21480000	24960000	24300000	28860000	22800000	26460000	32760000	49500000	81540000	58380000	42180000	44760000	45960000	674640000
Denmark	5640000	4440000	6180000	6180000	7500000	7140000	6660000	8460000	9600000	13500000	13860000	14100000	16260000	16680000	16260000	11940000	10920000	12060000	12720000	11040000	12480000	8820000	6780000	5940000	6300000	6540000	9120000	7200000	7680000	7800000	289800000
Estonia			180000	420000	1200000	1500000	1980000	2520000	2700000	2160000	480000	3240000	540000	1140000	2820000	4560000	5220000	10560000	10860000	14040000	9480000	6000000	3180000	2160000	840000	420000	780000	1500000	1260000	1500000	93240000
Finland	1140000	1260000	2100000	11880000	13020000	5820000	10320000	12300000	11160000	12900000	10320000	8880000	7140000	7320000	7740000	3240000	7260000	9000000	10200000	11100000	11580000	11640000	9360000	10860000	10980000	12660000	14520000	17880000	10740000	10080000	284400000


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