Recipe relationships

id	recipe_id	related_recipe_id	relation_type	notes	source_book	source_year
216	667	546	variation	Defined by adding creme de vanille to Boothby's Old Tom fizz.	Cocktail Boothby's American Bar-Tender	1891
221	672	671	variation	Built directly from Boothby's preceding burnt brandy recipe.	Cocktail Boothby's American Bar-Tender	1891
222	677	77	variation	Defined by direct substitution from Boothby's hot brandy toddy.	Cocktail Boothby's American Bar-Tender	1891
223	680	517	variation	Defined by substituting old Islay whisky into Boothby's hot whiskey punch.	Cocktail Boothby's American Bar-Tender	1891
224	681	80	variation	Defined by direct substitution from Boothby's hot brandy sling.	Cocktail Boothby's American Bar-Tender	1891
230	684	135	variation	Defined by adding a dash of claret to the base lemonade.	Cocktail Boothby's American Bar-Tender	1891
232	686	135	variation	Defined by adding a dash of port to the base lemonade.	Cocktail Boothby's American Bar-Tender	1891
233	687	135	variation	Defined by substituting seltzer water for plain water.	Cocktail Boothby's American Bar-Tender	1891
234	688	135	variation	Defined by substituting soda for water.	Cocktail Boothby's American Bar-Tender	1891
235	689	135	variation	Defined by adding whiskey to the base lemonade.	Cocktail Boothby's American Bar-Tender	1891
236	690	689	variation	Boothby defines Texas Lemonade as another name for spike lemonade.	Cocktail Boothby's American Bar-Tender	1891
413	693	112	same-family	A later hybrid cup branch that preserves the claret-and-sparkling overlap without simply repeating Thomas's Brunow formula.	The World's Drinks and How to Mix Them	1908
242	708	455	variation	Boothby defines white wine punch by substituting white wine for claret.	Cocktail Boothby's American Bar-Tender	1891
246	724	127	variation	Irish whiskey substitution within the same peel-led hot skin pattern.	Wehman's Bartender's Guide	1891
318	727	622	same-family	Another aromatic cocktail sharpened by bitters and citrus, but with absinthe placed at the centre.	Modern American Drinks	1895
488	750	750	variation	A later printed source variant of the cooler line.	Harry of Ciro's ABC of Mixing Cocktails	1923
250	755	51	variation	Transfers the classic aromatic cocktail structure from grape brandy to apple brandy.	Modern American Drinks	1895
360	756	52	descendant	Represents the retrospective same-glass naming of the older aromatic whiskey-cocktail form.	The Mixicologist	1895
445	756	756	variation	A whiskey-and-curacao branch of Ensslin's old-fashioned service pattern.	Recipes for Mixed Drinks	1917
358	770	576	same-family	Another late-century gin cocktail, but without vermouth taking structural control.	The Mixicologist	1895
371	770	770	same-family	Plain aromatic counterpart to the improved Tom Gin branch.	The Mixicologist	1895
251	772	51	variation	A bottled preparation of the standard brandy cocktail formula.	Modern American Drinks	1895
252	773	772	variation	Same bottled service structure with Holland gin as the base.	Modern American Drinks	1895
253	774	773	same-family	Parallel bottled gin branch, but lighter and more orange-driven.	Modern American Drinks	1895
254	775	52	variation	Bottled service version of the standard whiskey cocktail.	Modern American Drinks	1895
255	776	622	variation	Bottled service version of the sweet nineteenth-century Martini.	Modern American Drinks	1895
256	777	557	variation	Bottled service version of the standard Manhattan.	Modern American Drinks	1895
257	778	528	variation	Bottled service version of the vermouth-centred cocktail line.	Modern American Drinks	1895
259	779	51	descendant	Retrospective simplified branch of the brandy-cocktail line.	Modern American Drinks	1895
260	780	761	descendant	Retrospective simplified branch of the Holland-gin cocktail line.	Modern American Drinks	1895
261	781	557	variation	Dry branch omitting syrup and cherry.	Modern American Drinks	1895
262	782	557	variation	Extra-dry branch using French vermouth in place of Italian vermouth.	Modern American Drinks	1895
263	783	52	variation	Canadian-whiskey branch of the standard whiskey cocktail.	Modern American Drinks	1895
265	784	761	same-family	A lighter gin branch within the broader aromatic cocktail family.	Modern American Drinks	1895
266	785	761	variation	Schiedam-gin version of the Holland-gin cocktail structure.	Modern American Drinks	1895
267	786	780	variation	Old Tom version of the old-fashioned gin-cocktail build.	Modern American Drinks	1895
268	787	557	same-family	Shares vermouth-and-spirit logic but opens into carbonated service.	Modern American Drinks	1895
269	788	557	descendant	Named Canadian-whisky descendant within the Manhattan-style vermouth branch.	Modern American Drinks	1895
270	789	557	variation	Irish-whiskey and acid-phosphate branch of the Manhattan-style family.	Modern American Drinks	1895
271	790	789	same-family	Plainer aromatic sibling to the vermouth-and-acid-phosphate version.	Modern American Drinks	1895
272	791	51	variation	A Jamaica-rum adaptation of the classic aromatic cocktail pattern.	Modern American Drinks	1895
273	792	52	variation	A bitter-orange branch of the whiskey-cocktail line.	Modern American Drinks	1895
274	793	526	riff	Builds on absinthe-centred aromatic logic but adds vermouth and brandy.	Modern American Drinks	1895
275	794	51	variation	Medford-rum version of the standard brandy-cocktail structure.	Modern American Drinks	1895
276	795	557	same-family	Shares the split spirit-and-vermouth aromatic logic, but with brandy and French vermouth.	Modern American Drinks	1895
278	796	52	variation	Standard whiskey-cocktail structure altered by heavy use of pepsin bitters.	Modern American Drinks	1895
279	797	770	variation	A port-settled decorative branch of the Tom-gin cocktail line.	Modern American Drinks	1895
280	798	622	same-family	A drier gin-vermouth sibling within the late nineteenth-century Martini field.	Modern American Drinks	1895
281	800	52	variation	A no-sweetening, very-cold bourbon branch of the whiskey-cocktail line.	Modern American Drinks	1895
283	801	761	variation	Dry-vermouth Holland-gin branch.	Modern American Drinks	1895