Coffee Quality Database From CQI

A database scrapped from Coffee Quality Institute

@kaggle.volpatto_coffee_quality_database_from_cqi

Table List

3 tables(352.02 KB)

Arabica Data Cleaned

Merged Data Cleaned

Robusta Data Cleaned

Robusta Data Cleaned

@kaggle.volpatto_coffee_quality_database_from_cqi.robusta_data_cleaned

34.26 KB
28 rows
44 columns

unnamed_0 Unnamed: 0	species Species	owner Owner	country_of_origin Country.of.Origin	farm_name Farm.Name	lot_number Lot.Number	mill Mill	ico_number ICO.Number	company Company	altitude Altitude	region Region	producer Producer	number_of_bags Number.of.Bags	bag_weight Bag.Weight	in_country_partner In.Country.Partner	harvest_year Harvest.Year	grading_date Grading.Date	owner_1 Owner.1	variety Variety	processing_method Processing.Method	fragrance_aroma Fragrance...Aroma	flavor Flavor	aftertaste Aftertaste	salt_acid Salt...Acid	bitter_sweet Bitter...Sweet	mouthfeel Mouthfeel	uniform_cup Uniform.Cup	clean_cup Clean.Cup	balance Balance	cupper_points Cupper.Points	total_cup_points Total.Cup.Points	moisture Moisture	color Color	category_two_defects Category.Two.Defects	expiration Expiration	certification_body Certification.Body	certification_address Certification.Address	certification_contact Certification.Contact	unit_of_measurement Unit Of Measurement	altitude_low_meters Altitude Low Meters	altitude_high_meters Altitude High Meters	altitude_mean_meters Altitude Mean Meters
1	Robusta	ankole coffee producers coop	Uganda	kyangundu cooperative society	nan	ankole coffee producers	0	ankole coffee producers coop	1488	sheema south western	Ankole coffee producers coop	300	60 kg	Uganda Coffee Development Authority	2013	June 26th, 2014	Ankole coffee producers coop	nan	nan	7.83	8.08	7.75	7.92	8	8.25	10	10	7.92	8	83.75	0.12	Green	2	June 26th, 2015	Uganda Coffee Development Authority	e36d0270932c3b657e96b7b0278dfd85dc0fe743	03077a1c6bac60e6f514691634a7f6eb5c85aae8	m	1488	1488	1488
2	Robusta	nishant gurjer	India	sethuraman estate kaapi royale	25	sethuraman estate	14/1148/2017/21	kaapi royale	3170	chikmagalur karnataka indua	Nishant Gurjer Kaapi Royale	320	60 kg	Specialty Coffee Association	2017	October 31st, 2017	Nishant Gurjer	nan	Washed / Wet	8	7.75	7.92	8	8	7.92	10	10	7.92	8	83.5		nan	2	October 31st, 2018	Specialty Coffee Association	ff7c18ad303d4b603ac3f8cff7e611ffc735e720	352d0cf7f3e9be14dad7df644ad65efc27605ae2	m	3170	3170	3170
3	Robusta	andrew hetzel	India	sethuraman estate	nan	nan	0000	sethuraman estate	1000m	chikmagalur	Nishant Gurjer	300	2 kg	Specialty Coffee Association	2015	April 30th, 2015	Andrew Hetzel	nan	nan	7.92	7.83	7.92	8	7.83	7.83	10	10	7.92	8	83.25		Green		April 29th, 2016	Specialty Coffee Association	ff7c18ad303d4b603ac3f8cff7e611ffc735e720	352d0cf7f3e9be14dad7df644ad65efc27605ae2	m	1000	1000	1000
4	Robusta	ugacof	Uganda	ugacof project area	nan	ugacof	0	ugacof ltd	1212	central	UGACOF	320	60 kg	Uganda Coffee Development Authority	2013	July 14th, 2014	UGACOF	nan	nan	8	7.92	7.92	7.75	7.75	7.83	10	10	7.75	8.08	83	0.12	Green	7	July 14th, 2015	Uganda Coffee Development Authority	e36d0270932c3b657e96b7b0278dfd85dc0fe743	03077a1c6bac60e6f514691634a7f6eb5c85aae8	m	1212	1212	1212
5	Robusta	katuka development trust ltd	Uganda	katikamu capca farmers association	nan	katuka development trust	0	katuka development trust ltd	1200-1300	luwero central region	Katuka Development Trust Ltd	1	60 kg	Uganda Coffee Development Authority	2013	June 26th, 2014	Katuka Development Trust Ltd	nan	nan	8.33	7.83	7.83	7.75	7.58	8.25	10	10	7.75	7.67	83	0.12	Green	3	June 26th, 2015	Uganda Coffee Development Authority	e36d0270932c3b657e96b7b0278dfd85dc0fe743	03077a1c6bac60e6f514691634a7f6eb5c85aae8	m	1200	1300	1250
6	Robusta	andrew hetzel	India	nan	nan	(self)	nan	cafemakers, llc	3000'	chikmagalur	Sethuraman Estates	200	1 kg	Specialty Coffee Association	2012	February 29th, 2012	Andrew Hetzel	nan	nan	8	7.92	7.67	8	7.75	7.75	10	10	7.92	7.75	82.75		Green		February 28th, 2013	Specialty Coffee Association	ff7c18ad303d4b603ac3f8cff7e611ffc735e720	352d0cf7f3e9be14dad7df644ad65efc27605ae2	m	3000	3000	3000
7	Robusta	andrew hetzel	India	sethuraman estates	nan	nan	nan	cafemakers	750m	chikmagalur	Nishant Gurjer	320	2 kg	Specialty Coffee Association	2014	May 15th, 2014	Andrew Hetzel	nan	nan	7.67	7.75	7.83	7.83	8	7.92	10	10	7.75	7.83	82.58		Green		May 15th, 2015	Specialty Coffee Association	ff7c18ad303d4b603ac3f8cff7e611ffc735e720	352d0cf7f3e9be14dad7df644ad65efc27605ae2	m	750	750	750
8	Robusta	nishant gurjer	India	sethuraman estate kaapi royale	7	sethuraman estate	14/1148/2017/18	kaapi royale	3140	chikmagalur karnataka india	Nishant Gurjer Kaapi Royale	320	60 kg	Specialty Coffee Association	2017	October 25th, 2017	Nishant Gurjer	nan	Washed / Wet	7.67	7.75	7.83	7.67	7.92	7.92	10	10	7.83	7.92	82.5	0.1	Bluish-Green		October 25th, 2018	Specialty Coffee Association	ff7c18ad303d4b603ac3f8cff7e611ffc735e720	352d0cf7f3e9be14dad7df644ad65efc27605ae2	m	3140	3140	3140
9	Robusta	nishant gurjer	India	sethuraman estate	RKR	sethuraman estate	14/1148/2016/17	kaapi royale	1000	chikmagalur karnataka	Sethuraman Estate Kaapi Royale	320	60 kg	Specialty Coffee Association	2015	August 17th, 2016	Nishant Gurjer	Other	Washed / Wet	7.67	7.75	7.58	7.83	7.92	7.83	10	10	8	7.92	82.5	0.09	Green		August 17th, 2017	Specialty Coffee Association	ff7c18ad303d4b603ac3f8cff7e611ffc735e720	352d0cf7f3e9be14dad7df644ad65efc27605ae2	m	1000	1000	1000
10	Robusta	ugacof	Uganda	ishaka	nan	nsubuga umar	0	ugacof ltd	900-1300	western	Nsubuga Umar	320	60 kg	Uganda Coffee Development Authority	2014	August 5th, 2014	UGACOF	nan	nan	7.67	7.83	7.83	7.83	7.75	7.92	10	10	7.75	7.83	82.42	0.12	Green	6	August 5th, 2015	Uganda Coffee Development Authority	e36d0270932c3b657e96b7b0278dfd85dc0fe743	03077a1c6bac60e6f514691634a7f6eb5c85aae8	m	900	1300	1100


CREATE TABLE robusta_data_cleaned (
  "unnamed_0" BIGINT,
  "species" VARCHAR,
  "owner" VARCHAR,
  "country_of_origin" VARCHAR,
  "farm_name" VARCHAR,
  "lot_number" VARCHAR,
  "mill" VARCHAR,
  "ico_number" VARCHAR,
  "company" VARCHAR,
  "altitude" VARCHAR,
  "region" VARCHAR,
  "producer" VARCHAR,
  "number_of_bags" BIGINT,
  "bag_weight" VARCHAR,
  "in_country_partner" VARCHAR,
  "harvest_year" BIGINT,
  "grading_date" VARCHAR,
  "owner_1" VARCHAR,
  "variety" VARCHAR,
  "processing_method" VARCHAR,
  "fragrance_aroma" DOUBLE,
  "flavor" DOUBLE,
  "aftertaste" DOUBLE,
  "salt_acid" DOUBLE,
  "bitter_sweet" DOUBLE,
  "mouthfeel" DOUBLE,
  "uniform_cup" DOUBLE,
  "clean_cup" DOUBLE,
  "balance" DOUBLE,
  "cupper_points" DOUBLE,
  "total_cup_points" DOUBLE,
  "moisture" DOUBLE,
  "category_one_defects" BIGINT,
  "quakers" BIGINT,
  "color" VARCHAR,
  "category_two_defects" BIGINT,
  "expiration" VARCHAR,
  "certification_body" VARCHAR,
  "certification_address" VARCHAR,
  "certification_contact" VARCHAR,
  "unit_of_measurement" VARCHAR,
  "altitude_low_meters" DOUBLE,
  "altitude_high_meters" DOUBLE,
  "altitude_mean_meters" DOUBLE
);