Baselight
Sign In

Coffee Quality Institute Arabica Reviews May2023

Updated dataset scrapped from Coffee Quality Institute.

@kaggle.erwinhmtang_coffee_quality_institute_reviews_may2023

Arabica Coffee Full Table
@kaggle.erwinhmtang_coffee_quality_institute_reviews_may2023.arabica_coffee_full_table

  • 173.39 KB
  • 1509 rows
  • 42 columns
coffee_id

Coffee Id

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

Owner

variety

Variety

status

Status

processing_method

Processing Method

aroma

Aroma

flavor

Flavor

aftertaste

Aftertaste

acidity

Acidity

body

Body

balance

Balance

uniformity

Uniformity

clean_cup

Clean Cup

sweetness

Sweetness

overall

Overall

defects

Defects

total_cup_points

Total Cup Points

moisture

Moisture

color

Color

category_one_defects

Category One Defects

category_two_defects

Category Two Defects

quakers

Quakers

expiration

Expiration

certification_body

Certification Body

certification_address

Certification Address

certification_contact

Certification Contact

parsed_expiration

Parsed Expiration

parsed_grading_date

Parsed Grading Date

#647123Guatemalasan francisco cotzal11/441/50inmobiliaria e inversiones dos mil, s.a.11/441/50inmobiliaria e inversiones dos mil, s.a.1600quichesan francisco cotzal27569 kgAsociacion Nacional Del Café2021 / 2022June 22 2022Angelica Paola Citan LopezCaturraCompletedWashed / Wet7.837.927.7587.757.751010107.9284.920.1169999999999999Green13June 22 2023Asociacion Nacional Del Café5a Calle 0-50, Zona 14 Guatemala City, Guatemala 1014Brayan Cifuentes -Thu Jun 22 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Jun 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
#927000GuatemalaSan jose del lago11/15/95San jose del lago11/15/95Peter Schoenfeld, S.A.1600AtitlánCafetalera Paquim, S.A.3530 kgAsociacion Nacional Del Café2022 / 2023April 17 2023Yesica Alejandra Martìnez VàsquezBourbonCompletedWashed / Wet7.587.837.587.757.677.751010107.7583.920.1Green21April 16 2024Asociacion Nacional Del Café5a Calle 0-50, Zona 14 Guatemala City, Guatemala 1014Brayan Cifuentes -Tue Apr 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Apr 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
#902618Guatemalavarias fincas11/15/51El Trèbol/Lìnea Gourmet11/15/51Peter Schoenfeld, S.A.1550Oriente Santa rosavarios productores43030 kgAsociacion Nacional Del Café2022 / 2023March 22 2023Yesica Alejandra Martìnez VàsquezCaturraCompletedWashed / Wet7.677.837.677.837.757.671010107.6784.080.11Green21March 21 2024Asociacion Nacional Del Café5a Calle 0-50, Zona 14 Guatemala City, Guatemala 1014Brayan Cifuentes -Thu Mar 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Mar 22 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
#781706GuatemalaSan jose del lago11/15/96San jose del lago11/15/96Peter Schoenfeld, S.A.1600AtitlánCafetalera Paquim, S.A.5530 kgAsociacion Nacional Del Café2022 / 2023April 17 2023Yesica Alejandra Martìnez VàsquezTypicaCompletedWashed / Wet7.587.927.677.757.837.751010107.7584.250.1Green1April 16 2024Asociacion Nacional Del Café5a Calle 0-50, Zona 14 Guatemala City, Guatemala 1014Brayan Cifuentes -Tue Apr 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Apr 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
#237025GuatemalaFinca Alta Luz11-63-657nan11-63-657Retrillas del pacifico, s.a.1350HuehuetenangoMaria de los Angeles Perez60030 kgAsociacion Nacional Del Café2022 / 2023April 26 2023Yesica Alejandra Martìnez VàsquezBourbonCompletedWashed / Wet7.677.837.757.757.837.751010107.7584.330.092Green51April 25 2024Asociacion Nacional Del Café5a Calle 0-50, Zona 14 Guatemala City, Guatemala 1014Brayan Cifuentes -Thu Apr 25 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Apr 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
#932904Guatemalavarias fincas11/15/59El Trebol/Linea Gourmet11/15/59Peter Schoenfeld, S.A.1550Sierra de las minasvarios productores20030 kgAsociacion Nacional Del Café2022 / 2023March 22 2023Yesica Alejandra Martìnez VàsquezCaturraCompletedWashed / Wet7.677.927.677.757.677.581010107.75840.11Green22March 21 2024Asociacion Nacional Del Café5a Calle 0-50, Zona 14 Guatemala City, Guatemala 1014Brayan Cifuentes -Thu Mar 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Mar 22 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
#614786GuatemalaPEÑA BLANCA11/951/279BENEFICIO LAS AMERICAS11/951/279OLAM AGRO GUATEMALA, S.A.1432Santa RosaPABLO CHUY63230 kgAsociacion Nacional Del Café2022 / 2023February 23 2023Yesica Alejandra Martìnez VàsquezCatuaiCompletedWashed / Wet7.6787.757.9287.831010107.83850.113Green4February 23 2024Asociacion Nacional Del Café5a Calle 0-50, Zona 14 Guatemala City, Guatemala 1014Brayan Cifuentes -Fri Feb 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Feb 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
#975481GuatemalaVarias Fincas11/15/117Varios Beneficios11/15/117Peter Schoenfeld, S.A.1600HuehuetenangoVarios Productores60030 kgAsociacion Nacional Del Café2022 / 2023April 28 2023Yesica Alejandra Martìnez VàsquezCaturraCompletedWashed / Wet7.6787.677.837.927.671010107.9284.670.106Green1April 27 2024Asociacion Nacional Del Café5a Calle 0-50, Zona 14 Guatemala City, Guatemala 1014Brayan Cifuentes -Sat Apr 27 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Apr 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
#938229Guatemalavarias fincas11/15/118Beneficio Pastores11/15/118Peter Schoenfeld, S.A.1600AntiguaVarios productores60030 kgAsociacion Nacional Del Café2022 / 2023April 17 2023Yesica Alejandra Martìnez VàsquezCaturraCompletedWashed / Wet7.678.087.6787.927.831010107.83850.099Green11April 16 2024Asociacion Nacional Del Café5a Calle 0-50, Zona 14 Guatemala City, Guatemala 1014Brayan Cifuentes -Tue Apr 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Apr 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
#797284GuatemalaFina las Rosas11/63/459nan11/63/459Retrillas del pacifico, s.a.1500HuehuetenangoRolando Belarmino Villatoro Villatoro27569 kgAsociacion Nacional Del Café2022 / 2023May 15 2023Yesica Alejandra Martìnez VàsquezBourbonCompletedWashed / Wet7.677.927.677.757.757.751010107.7584.250.107Green31May 14 2024Asociacion Nacional Del Café5a Calle 0-50, Zona 14 Guatemala City, Guatemala 1014Brayan Cifuentes -Tue May 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Mon May 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATE TABLE arabica_coffee_full_table (
  "coffee_id" VARCHAR,
  "country_of_origin" VARCHAR,
  "farm_name" VARCHAR,
  "lot_number" VARCHAR,
  "mill" VARCHAR,
  "ico_number" VARCHAR,
  "company" VARCHAR,
  "altitude" DOUBLE,
  "region" VARCHAR,
  "producer" VARCHAR,
  "number_of_bags" BIGINT,
  "bag_weight" VARCHAR,
  "in_country_partner" VARCHAR,
  "harvest_year" VARCHAR,
  "grading_date" VARCHAR,
  "owner" VARCHAR,
  "variety" VARCHAR,
  "status" VARCHAR,
  "processing_method" VARCHAR,
  "aroma" DOUBLE,
  "flavor" DOUBLE,
  "aftertaste" DOUBLE,
  "acidity" DOUBLE,
  "body" DOUBLE,
  "balance" DOUBLE,
  "uniformity" DOUBLE,
  "clean_cup" DOUBLE,
  "sweetness" DOUBLE,
  "overall" DOUBLE,
  "defects" DOUBLE,
  "total_cup_points" DOUBLE,
  "moisture" DOUBLE,
  "color" VARCHAR,
  "category_one_defects" BIGINT,
  "category_two_defects" BIGINT,
  "quakers" DOUBLE,
  "expiration" VARCHAR,
  "certification_body" VARCHAR,
  "certification_address" VARCHAR,
  "certification_contact" VARCHAR,
  "parsed_expiration" TIMESTAMP,
  "parsed_grading_date" TIMESTAMP
);

Share link

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