Baselight

Coffee Dataset

Coffee economic indicatores from the International Coffee Organization dataset

@kaggle.michals22_coffee_dataset

Coffee Domestic Consumption
@kaggle.michals22_coffee_dataset.coffee_domestic_consumption

  • 32.52 KB
  • 55 rows
  • 33 columns
country

Country

coffee_type

Coffee Type

n_1990_91

1990/91

n_1991_92

1991/92

n_1992_93

1992/93

n_1993_94

1993/94

n_1994_95

1994/95

n_1995_96

1995/96

n_1996_97

1996/97

n_1997_98

1997/98

n_1998_99

1998/99

n_1999_00

1999/00

n_2000_01

2000/01

n_2001_02

2001/02

n_2002_03

2002/03

n_2003_04

2003/04

n_2004_05

2004/05

n_2005_06

2005/06

n_2006_07

2006/07

n_2007_08

2007/08

n_2008_09

2008/09

n_2009_10

2009/10

n_2010_11

2010/11

n_2011_12

2011/12

n_2012_13

2012/13

n_2013_14

2013/14

n_2014_15

2014/15

n_2015_16

2015/16

n_2016_17

2016/17

n_2017_18

2017/18

n_2018_19

2018/19

n_2019_20

2019/20

total_domestic_consumption

Total Domestic Consumption

AngolaRobusta/Arabica1200000180000021000001200000150000060000012000002400000180000012000001200000120000012000009000009000009000001800000180000018000001800000180000018000001800000180000018000001800000180000018000001800000180000046500000
Bolivia (Plurinational State of)Arabica15000001620000165000017100001770000183000018900001950000198000020400002100000219000022500002310000270000024600002520000261000027000002760000285000029400003030000312000032100003300000342000035100003600000366000075180000
BrazilArabica/Robusta492000000510000000534000000546000000558000000606000000660000000690000000732000000762000000792000000815400000825000000852000000896760000932280000979860000102660000010596000001103400000114792000011832000001219800000120510000012199800001230480000127350000013198200001332000000132000000027824700000
BurundiArabica/Robusta12000096000102000114600120000120000120000120000120000120000120000120000120000120000120000114360936008142086100839401200001200001200001200001200001200001200001200001200001200003412020
EcuadorArabica/Robusta210000002100000021000000210000002100000021000000180000001800000018000000138000001200000012000000900000090000009000000900000090000009000000900000090000009000000900000090000009300000930000093000009300000930000093000008940000381540000
IndonesiaRobusta/Arabica745200007680000079140000815400008400000086580000891600009192000094680000975600001005600001200000001067400001099800001200000001500000001699800001999800001999800001999800001999800002200200002340000002550000002650200002730000002790000002850000002880000002883600004920480000
MadagascarRobusta21000000180000002100000021600000999996010020000100200001002000010020000336000053460007680000130200001998000028020000280200002802000028020000280200002802000028020000270000002580000024600000234000002220000021600000219000002250000022500000588705960
MalawiArabica1200001200001200001200001200001200001200001200001200006000060000600006000060000600006000060000600006000060000600006000060000600006000060000600006000060000600002340000
Papua New GuineaArabica/Robusta1800001800001800001200001200001200001200001200006000012000012000012000012000012000012000012000012000012000012000012000085800741601026601223401154401080001200001200001200001200003608400
ParaguayArabica90000090000090000012000001200000120000012000001200000120000012000001200000120000012000001200000120000012000001200000120000012000001200000120000012000001200000120000012000001200000120000012000001200000120000035100000

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

Share link

Anyone who has the link will be able to view this.