Cocktail Ingredients

Cocktails and their respective ingredients

@kaggle.ai_first_cocktail_ingredients

Table List

1 table(109.4 KB)

All Drinks

@kaggle.ai_first_cocktail_ingredients.all_drinks

109.4 KB
546 rows
41 columns

unnamed_0 Unnamed: 0	strdrink StrDrink	datemodified DateModified	iddrink IdDrink	stralcoholic StrAlcoholic	strcategory StrCategory	strdrinkthumb StrDrinkThumb	strglass StrGlass	striba StrIBA	stringredient1 StrIngredient1	stringredient10 StrIngredient10	stringredient11 StrIngredient11	stringredient12 StrIngredient12	stringredient2 StrIngredient2	stringredient3 StrIngredient3	stringredient4 StrIngredient4	stringredient5 StrIngredient5	stringredient6 StrIngredient6	stringredient7 StrIngredient7	stringredient8 StrIngredient8	stringredient9 StrIngredient9	strinstructions StrInstructions	strmeasure1 StrMeasure1	strmeasure10 StrMeasure10	strmeasure11 StrMeasure11	strmeasure12 StrMeasure12	strmeasure13 StrMeasure13	strmeasure14 StrMeasure14	strmeasure15 StrMeasure15	strmeasure2 StrMeasure2	strmeasure3 StrMeasure3	strmeasure4 StrMeasure4	strmeasure5 StrMeasure5	strmeasure6 StrMeasure6	strmeasure7 StrMeasure7	strmeasure8 StrMeasure8	strmeasure9 StrMeasure9
	'57 Chevy with a White License Plate	Mon Jul 18 2016 22:49:04 GMT+0000 (Coordinated Universal Time)	14029	Alcoholic	Cocktail	http://www.thecocktaildb.com/images/media/drink/qyyvtu1468878544.jpg	Highball glass	nan	Creme de Cacao	nan	nan	nan	Vodka	nan	nan	nan	nan	nan	nan	nan	1. Fill a rocks glass with ice 2.add white creme de cacao and vodka 3.stir	1 oz white	nan	nan	nan	nan	nan	nan	1 oz						nan	nan
1	1-900-FUK-MEUP	Mon Jul 18 2016 22:27:04 GMT+0000 (Coordinated Universal Time)	15395	Alcoholic	Shot	http://www.thecocktaildb.com/images/media/drink/uxywyw1468877224.jpg	Old-fashioned glass	nan	Absolut Kurant	nan	nan	nan	Grand Marnier	Chambord raspberry liqueur	Midori melon liqueur	Malibu rum	Amaretto	Cranberry juice	Pineapple juice	nan	Shake ingredients in a mixing tin filled with ice cubes. Strain into a rocks glass.	1/2 oz					nan	nan	1/4 oz	1/4 oz	1/4 oz	1/4 oz	1/4 oz	1/2 oz	1/4 oz
2	110 in the shade	Wed Feb 03 2016 14:51:57 GMT+0000 (Coordinated Universal Time)	15423	Alcoholic	Beer	http://www.thecocktaildb.com/images/media/drink/xxyywq1454511117.jpg	Beer Glass	nan	Lager	nan	nan	nan	Tequila	nan	nan	nan	nan	nan	nan	nan	Drop shooter in glass. Fill with beer	16 oz	nan	nan	nan	nan	nan	nan	1.5 oz						nan	nan
3	151 Florida Bushwacker	Mon Jul 18 2016 22:28:43 GMT+0000 (Coordinated Universal Time)	14588	Alcoholic	Milk / Float / Shake	http://www.thecocktaildb.com/images/media/drink/rvwrvv1468877323.jpg	Beer mug	nan	Malibu rum	nan	nan	nan	Light rum	151 proof rum	Dark Creme de Cacao	Cointreau	Milk	Coconut liqueur	Vanilla ice-cream	nan	Combine all ingredients. Blend until smooth. Garnish with chocolate shavings if desired.	1/2 oz					nan	nan	1/2 oz	1/2 oz Bacardi	1 oz	1 oz	3 oz	1 oz	1 cup
4	155 Belmont	Wed Oct 05 2016 12:36:28 GMT+0000 (Coordinated Universal Time)	15346	Alcoholic	Cocktail	http://www.thecocktaildb.com/images/media/drink/yqvvqs1475667388.jpg	White wine glass	nan	Dark rum	nan	nan	nan	Light rum	Vodka	Orange juice	nan	nan	nan	nan	nan	Blend with ice. Serve in a wine glass. Garnish with carrot.	1 shot	nan	nan	nan	nan	nan	nan	2 shots	1 shot	1 shot
5	24k nightmare	Mon Jul 18 2016 22:31:38 GMT+0000 (Coordinated Universal Time)	17060	Alcoholic	Shot	http://www.thecocktaildb.com/images/media/drink/yyrwty1468877498.jpg	Shot glass	nan	Goldschlager	nan	nan	nan	Jägermeister	Rumple Minze	151 proof rum	nan	nan	nan	nan	nan	Add over ice,shake and pour.	1/2 oz	nan	nan	nan	nan	nan	nan	1/2 oz	1/2 oz	1/2 oz Bacardi
6	252	Mon Jul 18 2016 22:32:42 GMT+0000 (Coordinated Universal Time)	15288	Alcoholic	Shot	http://www.thecocktaildb.com/images/media/drink/rtpxqw1468877562.jpg	Shot glass	nan	151 proof rum	nan	nan	nan	Wild Turkey	nan	nan	nan	nan	nan	nan	nan	Add both ingredients to shot glass, shoot, and get drunk quick	1/2 shot Bacardi	nan	nan	nan	nan	nan	nan	1/2 shot						nan	nan
7	3 Wise Men	Mon Jul 18 2016 22:34:37 GMT+0000 (Coordinated Universal Time)	13899	Alcoholic	Shot	http://www.thecocktaildb.com/images/media/drink/wxqpyw1468877677.jpg	Collins glass	nan	Jack Daniels	nan	nan	nan	Johnnie Walker	Jim Beam	nan	nan	nan	nan	nan	nan	put them them in a glass... and slam it to tha head.	1/3 oz	nan	nan	nan	nan	nan	nan	1/3 oz	1/3 oz						nan
8	3-Mile Long Island Iced Tea	Wed Aug 31 2016 19:42:52 GMT+0000 (Coordinated Universal Time)	15300	Alcoholic	Ordinary Drink	http://www.thecocktaildb.com/images/media/drink/rrtssw1472668972.jpg	Collins Glass	nan	Gin	nan	nan	nan	Light rum	Tequila	Triple sec	Vodka	Coca-Cola	Sweet and sour	Bitters	Lemon	Fill 14oz glass with ice and alcohol. Fill 2/3 glass with cola and remainder with sweet & sour. Top with dash of bitters and lemon wedge.	1/2 oz					nan	nan	1/2 oz	1/2 oz	1/2 oz	1/2 oz		1-2 dash	1 wedge
9	410 Gone	Wed Aug 31 2016 19:43:46 GMT+0000 (Coordinated Universal Time)	13581	Alcoholic	Ordinary Drink	http://www.thecocktaildb.com/images/media/drink/xtuyqv1472669026.jpg	Collins Glass	nan	Peach Vodka	nan	nan	nan	Coca-Cola	nan	nan	nan	nan	nan	nan	nan	nan	2-3 oz	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan


CREATE TABLE all_drinks (
  "unnamed_0" BIGINT,
  "strdrink" VARCHAR,
  "datemodified" TIMESTAMP,
  "iddrink" BIGINT,
  "stralcoholic" VARCHAR,
  "strcategory" VARCHAR,
  "strdrinkthumb" VARCHAR,
  "strglass" VARCHAR,
  "striba" VARCHAR,
  "stringredient1" VARCHAR,
  "stringredient10" VARCHAR,
  "stringredient11" VARCHAR,
  "stringredient12" VARCHAR,
  "stringredient13" VARCHAR,
  "stringredient14" VARCHAR,
  "stringredient15" VARCHAR,
  "stringredient2" VARCHAR,
  "stringredient3" VARCHAR,
  "stringredient4" VARCHAR,
  "stringredient5" VARCHAR,
  "stringredient6" VARCHAR,
  "stringredient7" VARCHAR,
  "stringredient8" VARCHAR,
  "stringredient9" VARCHAR,
  "strinstructions" VARCHAR,
  "strmeasure1" VARCHAR,
  "strmeasure10" VARCHAR,
  "strmeasure11" VARCHAR,
  "strmeasure12" VARCHAR,
  "strmeasure13" VARCHAR,
  "strmeasure14" VARCHAR,
  "strmeasure15" VARCHAR,
  "strmeasure2" VARCHAR,
  "strmeasure3" VARCHAR,
  "strmeasure4" VARCHAR,
  "strmeasure5" VARCHAR,
  "strmeasure6" VARCHAR,
  "strmeasure7" VARCHAR,
  "strmeasure8" VARCHAR,
  "strmeasure9" VARCHAR,
  "strvideo" VARCHAR
);