Drinks and Cocktails Database

Explore 16,893 drink recipes and 66,281 linked ingredient rows in a database built for finding, comparing, and organizing drinks. The recipes table includes names, categories, alcohol classi...

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.0 dated October 14, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
Usage RightsComplete recipe and ingredient tables; usage rights follow the selected license.
$30.00
Master RightsComplete recipe and ingredient tables; usage rights follow the selected license.Current update offer$7.50For eligible earlier Master purchases
$90.00
Records
16,893
Version
2.0.0
Release date
Oct 14, 2026
Before you choose
Explore the samples

Current release story

Latest update

Version 2.0.0 October 14, 2026 Build #167

Find the drink, then find what goes in it

A drink name is only the start. Explore 16,893 recipes, compare formulas, and connect each drink to its ordered ingredients in the updated Drinks and Cocktails Database.

Read the update announcement
Drinks and Cocktails Database List

Drinks and Cocktails Database v.2.0.0

16,893 Drink Recipes

Drinks and Cocktails Database catalog icon Drinks and Cocktails Database Download
Drinks and Cocktails Database artwork

Explore 16,893 drink recipes and 66,281 linked ingredient rows in a database built for finding, comparing, and organizing drinks. The recipes table includes names, categories, alcohol classification, glassware, ingredient text, preparation instructions, and shopping-list text. Each recipe_id connects a drink to its ordered rows in recipe_ingredients, so you can search by ingredient or reconstruct a recipe in sequence.

Use the collection to research cocktail variations, plan a menu, build a searchable recipe site, or find drinks that use ingredients already on hand. Filter recipes in a spreadsheet, work with JSON in an application, or join the two tables in SQLite. CSV, JSON, and SQLite files are included, along with schemas, samples, field statistics, and documentation. Preview both tables and their missing-value counts before choosing a license.

The release contains 16,351 historical recipes labeled historical_unverified and 542 additions labeled licensed_source_snapshot. The historical recipes come from an earlier Oddity release; their individual source dates and formulas have not been independently reverified. The additions reflect a licensed source snapshot, not a guarantee that every recipe is current. Check ingredients, quantities, allergens, and preparation before serving or publishing a drink.

16,893 Drink Recipes Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Restaurants Bars and Pubs Recipes Restaurant Profiles Starbucks

License Database Purchase Options

PUBLICATION

Publication Rights

$60.00

Publish and build for clients

All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Publication License

Choose this package above

MASTER

Master Rights

$90.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$7.50For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

Table Schema Database Field Statistics

Release structure

Drinks and Cocktails Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#7
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
recipes16893recipe_id, name, category, alcohol, glass, ingredients_text, instructions, shopping_list, garnish, source_status, snapshot_date, source_vintage
recipe_ingredients66281recipe_id, ordinal, ingredient, amount, unit, source_status

Release at a glance

What is inside this database

Review verified record totals, geographic coverage, classifications, and field completeness for Drinks and Cocktails Database.

16,893Recipes
66,281Recipe Ingredients

Status

  • Historical Unverified16,351
  • Licensed Source Snapshot542

Category

Showing the 12 largest groups from 19 represented values.

  • Cocktail9,998
  • Shot2,890
  • Ordinary Drink2,303
  • Mixed Drink397
  • Punch / Party Drink386
  • Other/Unknown326
  • Milk / Float / Shake146
  • Coffee / Tea109
  • Soft Drink / Soda71
  • Beer59
  • Homemade Liqueur52
  • Tea41

Table and column statistics

Select a table to review its schema, record total and fields. Distinct and missing-value counts appear where measured.

recipes16,893 records · 12 fields
recipe_id
Distinct
16,893
Missing
0 (0.0%)
name
Distinct
16,893
Missing
0 (0.0%)
category
Distinct
19
Missing
0 (0.0%)
alcohol
Distinct
5
Missing
0 (0.0%)
glass
Distinct
60
Missing
542 (3.2%)
ingredients_text
Distinct
16,845
Missing
0 (0.0%)
instructions
Distinct
15,206
Missing
15 (0.1%)
shopping_list
Distinct
16,450
Missing
0 (0.0%)
garnish
Distinct
1
Missing
16,893 (100.0%)
source_status
Distinct
2
Missing
0 (0.0%)
snapshot_date
Distinct
2
Missing
16,351 (96.8%)
source_vintage
Distinct
2
Missing
0 (0.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

recipesDownload this sample CSV
recipe_idnamecategoryalcoholglassingredients_textinstructionsshopping_listgarnishsource_statussnapshot_datesource_vintage
L1110 in the shadeBeerAlcoholicAny Glass16 oz Lager|1.5 oz TequilaDrop shooter in glass. Fill with beerLager|Tequilahistorical_unverified2011 release; underlying recipe dates unknown
L2'57 ChevyCocktailAlcoholicCocktail glass1/2 oz Vodka|1 1/2 oz Southern Comfort|1/2 oz Grand Marnier|Fill with Pineapple juiceShake and serve.Vodka|Southern Comfort|Grand Marnier|Pineapple juicehistorical_unverified2011 release; underlying recipe dates unknown
L31-900-FUK-MEUPShotAlcoholicOld-fashioned glass1/2 oz Absolut Kurant|1/4 oz Grand Marnier|1/4 oz Chambord raspberry liqueur|1/4 oz Midori melon liqueur|1/4 oz Malibu rum|1/4 oz Amaretto|1/2 oz Cranberry juice|1/4 oz Pineapple juiceShake ingredients in a mixing tin filled with ice cubes. Strain into a rocks glass.Absolut Kurant|Grand Marnier|Chambord raspberry liqueur|Midori melon liqueur|Malibu rum|Amaretto|Cranberry juice|Pineapple juicehistorical_unverified2011 release; underlying recipe dates unknown
L4'57 Chevy #2ShotAlcoholicShot glass1/3 shot Southern Comfort|1/3 shot Grand Marnier|1/3 shot Amaretto|1 splash Orange juice|1 splash Pineapple juice|1 dash Grenadine|1 splash 7-UpShake with ice and strain into a shot glass.Southern Comfort|Grand Marnier|Amaretto|Orange juice|Pineapple juice|Grenadine|7-Uphistorical_unverified2011 release; underlying recipe dates unknown
L5187 URgeCocktailAlcoholicAny Glass1 shot Jack Daniels|1 shot Vodka|6 shots Dr. Pepper|1 dash Sugar|1 piece CherryMix together and stir it is goodJack Daniels|Vodka|Dr. Pepper|Sugar|Cherryhistorical_unverified2011 release; underlying recipe dates unknown
L6The "Liquerice" DreamShotAlcoholicShot glass1/4 oz Galliano|1/4 oz Irish cream|1/4 oz Scotch|1/4 oz TequilaAdd all ingredients in shot glass. Mix well before drinking.Galliano|Irish cream|Scotch|Tequilahistorical_unverified2011 release; underlying recipe dates unknown
L7'57 Chevy with a White License PlateCocktailAlcoholicHighball glass1 oz white Creme de Cacao|1 oz Vodka1. Fill a rocks glass with ice 2.add white creme de cacao and vodka 3.stirCreme de Cacao|Vodkahistorical_unverified2011 release; underlying recipe dates unknown
L8220 BTUShotAlcoholicShot glass1 oz Absolut Kurant|1 oz Absolut Citron|1 oz Sour Apple Pucker|1 oz Blue MauiShake over ice and strain into shot glass. Enjoy!Absolut Kurant|Absolut Citron|Sour Apple Pucker|Mauihistorical_unverified2011 release; underlying recipe dates unknown
L93 Wise MenShotAlcoholicCollins glass1/3 oz Jack Daniels|1/3 oz Johnnie Walker|1/3 oz Jim Beamput them them in a glass... and slam it to tha head.Jack Daniels|Johnnie Walker|Jim Beamhistorical_unverified2011 release; underlying recipe dates unknown
L10151 Florida BushwackerMilk / Float / ShakeAlcoholicBeer mug1/2 oz Malibu rum|1/2 oz Light rum (Bacardi)|1/2 oz Bacardi 151 proof rum|1 oz Dark Creme de Cacao|1 oz Cointreau|3 oz Milk|1 oz Coconut liqueur|1 cup Vanilla ice-creamCombine all ingredients. Blend until smooth. Garnish with chocolate shavings if desired.Malibu rum|Light rum|151 proof rum|Dark Creme de Cacao|Cointreau|Milk|Coconut liqueur|Vanilla ice-creamhistorical_unverified2011 release; underlying recipe dates unknown
L11155 BelmontCocktailAlcoholicWhite wine glass1 shot Dark rum|2 shots Light rum|1 shot Vodka|1 shot Orange juiceBlend with ice. Serve in a wine glass. Garnish with carrot.Dark rum|Light rum|Vodka|Orange juicehistorical_unverified2011 release; underlying recipe dates unknown
L12252ShotAlcoholicShot glass1/2 shot Bacardi 151 proof rum|1/2 shot Wild Turkey, 101 proofAdd both ingredients to shot glass, shoot, and get drunk quick151 proof rum|Wild Turkeyhistorical_unverified2011 release; underlying recipe dates unknown
L133-Mile Long Island Iced TeaOrdinary DrinkAlcoholicAny Glass1/2 oz Gin|1/2 oz Light rum|1/2 oz Tequila|1/2 oz Triple sec|1/2 oz Vodka|Coca-Cola|Sweet and sour|1-2 dash Bitters|1 wedge LemonFill 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.Gin|Light rum|Tequila|Triple sec|Vodka|Coca-Cola|Sweet and sour|Bitters|Lemonhistorical_unverified2011 release; underlying recipe dates unknown
L1424k nightmareShotAlcoholicShot glass1/2 oz Goldschlager|1/2 oz Jagermeister|1/2 oz Rumple Minze|1/2 oz Bacardi 151 proof rumAdd over ice,shake and pour.Goldschlager|Jagermeister|Rumple Minze|151 proof rumhistorical_unverified2011 release; underlying recipe dates unknown
L15351 SpecialOrdinary DrinkAlcoholicCoffee mug1 part Coca-Cola|1 part Gin (Gordon's)|2 splashes Kronenbourg BeerPour Gordon's Gin and Kronenbourg beer (it MUST be Kronenbourg) into a coffee cup or a glass. Add Coca-Cola until it acquires the right taste.Coca-Cola|Gin|Beerhistorical_unverified2011 release; underlying recipe dates unknown
N7d3c0c5c3794f39b151 Rum ShotShotUnspecified1 oz 151-proof rumPour the rum into a shot glass. Serve immediately.151-proof rumlicensed_source_snapshot2026-10-14individual recipe date unverified
N40fe74c7f6f44165Aam PannaMocktailNon-alcoholic1 cup Sugar|2 cups Unripe Green Mango|3 tsp Cardamom|1 cup Fresh Mint|5 tsp Black SaltChoose the raw mangoes which are tart. You can keep the skin on before boiling the mangoes. It gives a very distinct flavor to the Panna. Peeling the skin before boiling makes the process very easy. If the Panna is not very tangy, you can add some lemon juice to it. Boil Mango with mild heat in 1 cup of water. You can also roast mango before boiling if needed for crispy taste. The subtly smoky flavor in this drink will take it to the next level. Strain into the prepared glass. Garnish with a parsley sprig, 2 speared green olives, and a lime wedge and a celery stalk (optional).Sugar|Unripe Green Mango|Cardamom|Fresh Mint|Black Saltlicensed_source_snapshot2026-10-14individual recipe date unverified
N68b1acd8f2ba9f68AamrasMixed drinkUnspecified3 kesar mangoesr|1/2 teaspoon cardamom powder|1 pinch saffron strands(kesar)|1 teaspoon Sugar|1/4 teaspoon dry ginger powder|1 cup Milk (Optional)Rinse the Alphonso mangoes, then peel and chop them. Add the chopped mango pieces in a blender and blend. Add cardamom powder and crushed saffron strands. Stir very well. To thin down the aamras you can add some sugar and water/milk. Pour in small bowls and chill in the refrigerator. You can also add your choice of dry fruits to the aamras.kesar mangoesr|cardamom powder|saffron strands(kesar)|Sugar|dry ginger powder|Milk (Optional)licensed_source_snapshot2026-10-14individual recipe date unverified
N2ff0e0f278cb1dbcABC JuiceMocktailNon-alcoholic2 pcs Apples|1 Beetroot|4-5 Carrots|1 inch Ginger (optional)|1/2 pcs Lemon|1/2-3/4 cup Water (if using blender)|to taste Salt and Sugar (optional)Wash all the ingredients thoroughly. Core the apples and chop all the fruits and vegetables into chunks. If using a juicer: juice apples, beetroot, carrots, and ginger in that order. If using a blender: blend everything with water until smooth and strain using a mesh or muslin cloth. Squeeze in lemon juice if desired. Add a pinch of salt, sugar, or chaat masala as per taste (optional). Serve immediately with or without ice, or store in the fridge for up to 24–48 hours.Apples|Beetroot|Carrots|Ginger (optional)|Lemon|Water (if using blender)|Salt and Sugar (optional)licensed_source_snapshot2026-10-14individual recipe date unverified
N4ff624063ce883bfAcross the PacificMixed drinkUnspecified30 ml Blended Aged Rum|15 ml Jamaican Rum|15 ml Averna Amaro|22.5 ml Lime Juice|22.5 ml Orgeat SyrupAdd all ingredients into a shaker with one ice cube. Shake until the ice melts and mixture is frothy. Pour into a rocks glass filled with crushed ice. Garnish with a lime wheel and grated nutmeg.Blended Aged Rum|Jamaican Rum|Averna Amaro|Lime Juice|Orgeat Syruplicensed_source_snapshot2026-10-14individual recipe date unverified

Drink Recipes Records Information

16,893 recipe rows plus 66,281 linked ingredient rows. Historical entries are labeled; their underlying source dates are unknown.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.
Discuss your data needs Explore the catalog

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Support

How can we help?

Browse all Help topics

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details