Starbucks

Starbucks Beverage Components

@kaggle.henryshan_starbucks

Table List

1 table(17.62 KB)

Starbucks

@kaggle.henryshan_starbucks.starbucks

17.62 KB
242 rows
18 columns

beverage_category Beverage Category	beverage Beverage	beverage_prep Beverage Prep	calories Calories	n__total_fat_g Total Fat (g)	trans_fat_g Trans Fat (g)	saturated_fat_g Saturated Fat (g)	n__sodium_mg Sodium (mg)	n__total_carbohydrates_g Total Carbohydrates (g)	cholesterol_mg Cholesterol (mg)	n__dietary_fibre_g Dietary Fibre (g)	n__sugars_g Sugars (g)	n__protein_g Protein (g)	vitamin_a_dv Vitamin A (% DV)	vitamin_c_dv Vitamin C (% DV)	n__calcium_dv Calcium (% DV)	iron_dv Iron (% DV)	caffeine_mg Caffeine (mg)
Coffee	Brewed Coffee	Short	3	0.1				5				0.3	0%	0%	0%	0%	175
Coffee	Brewed Coffee	Tall	4	0.1				10				0.5	0%	0%	0%	0%	260
Coffee	Brewed Coffee	Grande	5	0.1				10				1	0%	0%	0%	0%	330
Coffee	Brewed Coffee	Venti	5	0.1				10				1	0%	0%	2%	0%	410
Classic Espresso Drinks	Caffè Latte	Short Nonfat Milk	70	0.1	0.1		5	75	10		9	6	10%	0%	20%	0%	75
Classic Espresso Drinks	Caffè Latte	2% Milk	100	3.5	2	0.1	15	85	10		9	6	10%	0%	20%	0%	75
Classic Espresso Drinks	Caffè Latte	Soymilk	70	2.5	0.4			65	6	1	4	5	6%	0%	20%	8%	75
Classic Espresso Drinks	Caffè Latte	Tall Nonfat Milk	100	0.2	0.2		5	120	15		14	10	15%	0%	30%	0%	75
Classic Espresso Drinks	Caffè Latte	2% Milk	150	6	3	0.2	25	135	15		14	10	15%	0%	30%	0%	75
Classic Espresso Drinks	Caffè Latte	Soymilk	110	4.5	0.5			105	10	1	6	8	10%	0%	30%	15%	75


CREATE TABLE starbucks (
  "beverage_category" VARCHAR,
  "beverage" VARCHAR,
  "beverage_prep" VARCHAR,
  "calories" BIGINT,
  "n__total_fat_g" VARCHAR,
  "trans_fat_g" DOUBLE,
  "saturated_fat_g" DOUBLE,
  "n__sodium_mg" BIGINT,
  "n__total_carbohydrates_g" BIGINT,
  "cholesterol_mg" BIGINT,
  "n__dietary_fibre_g" BIGINT,
  "n__sugars_g" BIGINT,
  "n__protein_g" DOUBLE,
  "vitamin_a_dv" VARCHAR,
  "vitamin_c_dv" VARCHAR,
  "n__calcium_dv" VARCHAR,
  "iron_dv" VARCHAR,
  "caffeine_mg" VARCHAR
);