idreview_keysubject_recipe_idsubject_variant_idobject_recipe_idobject_variant_idfamily_idrelationship_typeconfidenceevidence_summaryevidence_batchsource_scopepromotion_statuspromotion_notessource_filesource_lineraw_jsoncreated_atupdated_at
511661|16660|546|839||modern_spec_for|manual_modern_historical_curation.md#batch-0231166116660546839modern_spec_forhighTheCocktailDB Gin Fizz preserves gin, lemon, powdered sugar, and carbonated water from the historical Gin Fizz formula.manual_modern_historical_curation.md#batch-023curated_db_onlydraftPromotable after final review.ontology_build\reports\modern_relationship_review_draft.jsonl6{"record_type":"relationship_review","subject_recipe_id":11661,"subject_variant_id":16660,"object_recipe_id":546,"object_variant_id":839,"family_id":null,"relationship_type":"modern_spec_for","confidence":"high","evidence_summary":"TheCocktailDB Gin Fizz preserves gin, lemon, powdered sugar, and carbonated water from the historical Gin Fizz formula.","evidence_batch":"manual_modern_historical_curation.md#batch-023","source_scope":"curated_db_only","promotion_status":"draft","promotion_notes":"Promotable after final review."}7/12/2026, 9:00:02 AM7/12/2026, 9:00:02 AM
4011773|16772|2883|7143||name_collision_with|manual_modern_historical_curation.md#batch-022117731677228837143name_collision_withhighTheCocktailDB Mimosa is champagne and orange juice; historical Mimosa Cocktail 2883 is gin, Vieille Cure, and French vermouth.manual_modern_historical_curation.md#batch-022curated_db_onlydraftHistorical 2472/3761 are the correct Mimosa anchors, not 2883.ontology_build\reports\modern_name_collision_review_draft.jsonl14{"record_type":"relationship_review","subject_recipe_id":11773,"subject_variant_id":16772,"object_recipe_id":2883,"object_variant_id":7143,"family_id":null,"relationship_type":"name_collision_with","confidence":"high","evidence_summary":"TheCocktailDB Mimosa is champagne and orange juice; historical Mimosa Cocktail 2883 is gin, Vieille Cure, and French vermouth.","evidence_batch":"manual_modern_historical_curation.md#batch-022","source_scope":"curated_db_only","promotion_status":"draft","promotion_notes":"Historical 2472/3761 are the correct Mimosa anchors, not 2883."}7/12/2026, 9:00:02 AM7/12/2026, 9:00:02 AM
1611776|16775|3503|8127||modern_spec_for|manual_modern_historical_curation.md#batch-026117761677535038127modern_spec_forhighTheCocktailDB Mojito preserves light rum, lime, sugar, mint, and soda water from the historical Mojito line.manual_modern_historical_curation.md#batch-026curated_db_onlydraftPromotable after final review.ontology_build\reports\modern_relationship_review_draft.jsonl17{"record_type":"relationship_review","subject_recipe_id":11776,"subject_variant_id":16775,"object_recipe_id":3503,"object_variant_id":8127,"family_id":null,"relationship_type":"modern_spec_for","confidence":"high","evidence_summary":"TheCocktailDB Mojito preserves light rum, lime, sugar, mint, and soda water from the historical Mojito line.","evidence_batch":"manual_modern_historical_curation.md#batch-026","source_scope":"curated_db_only","promotion_status":"draft","promotion_notes":"Promotable after final review."}7/12/2026, 9:00:02 AM7/12/2026, 9:00:02 AM
3611844|16843|5937|10936||name_collision_with|manual_modern_historical_curation.md#batch-0221184416843593710936name_collision_withhighTheCocktailDB Red Snapper is a Crown Royal, amaretto, and cranberry shooter; Difford's Red Snapper is a gin Bloody Mary family drink with tomato, lemon, spices, and sauces.manual_modern_historical_curation.md#batch-022curated_db_onlydraftIntra-modern collision warning.ontology_build\reports\modern_name_collision_review_draft.jsonl10{"record_type":"relationship_review","subject_recipe_id":11844,"subject_variant_id":16843,"object_recipe_id":5937,"object_variant_id":10936,"family_id":null,"relationship_type":"name_collision_with","confidence":"high","evidence_summary":"TheCocktailDB Red Snapper is a Crown Royal, amaretto, and cranberry shooter; Difford's Red Snapper is a gin Bloody Mary family drink with tomato, lemon, spices, and sauces.","evidence_batch":"manual_modern_historical_curation.md#batch-022","source_scope":"curated_db_only","promotion_status":"draft","promotion_notes":"Intra-modern collision warning."}7/12/2026, 9:00:02 AM7/12/2026, 9:00:02 AM
3511870|16869|4337|9254||name_collision_with|manual_modern_historical_curation.md#batch-022118701686943379254name_collision_withhighTheCocktailDB Sea breeze is vodka, cranberry, and grapefruit; historical Sea Breeze is gin/apricot/grenadine/lemon/soda/mint.manual_modern_historical_curation.md#batch-022curated_db_onlydraftHigh-confidence same-name collision.ontology_build\reports\modern_name_collision_review_draft.jsonl9{"record_type":"relationship_review","subject_recipe_id":11870,"subject_variant_id":16869,"object_recipe_id":4337,"object_variant_id":9254,"family_id":null,"relationship_type":"name_collision_with","confidence":"high","evidence_summary":"TheCocktailDB Sea breeze is vodka, cranberry, and grapefruit; historical Sea Breeze is gin/apricot/grenadine/lemon/soda/mint.","evidence_batch":"manual_modern_historical_curation.md#batch-022","source_scope":"curated_db_only","promotion_status":"draft","promotion_notes":"High-confidence same-name collision."}7/12/2026, 9:00:02 AM7/12/2026, 9:00:02 AM
5111895|16894|5891|10890||name_collision_with|manual_modern_historical_curation.md#batch-0221189516894589110890name_collision_withhighTexas Rattlesnake is a party/shooter-style mix of Yukon Jack, cherry brandy, Southern Comfort, and sweet-and-sour; Difford's Rattlesnake is a rye/absinthe/egg-white sour/flip.manual_modern_historical_curation.md#batch-022curated_db_onlydraftIntra-modern collision warning.ontology_build\reports\modern_name_collision_review_draft.jsonl25{"record_type":"relationship_review","subject_recipe_id":11895,"subject_variant_id":16894,"object_recipe_id":5891,"object_variant_id":10890,"family_id":null,"relationship_type":"name_collision_with","confidence":"high","evidence_summary":"Texas Rattlesnake is a party/shooter-style mix of Yukon Jack, cherry brandy, Southern Comfort, and sweet-and-sour; Difford's Rattlesnake is a rye/absinthe/egg-white sour/flip.","evidence_batch":"manual_modern_historical_curation.md#batch-022","source_scope":"curated_db_only","promotion_status":"draft","promotion_notes":"Intra-modern collision warning."}7/12/2026, 9:00:02 AM7/12/2026, 9:00:02 AM
4911902|16901|3639|8314||name_collision_with|manual_modern_historical_curation.md#batch-022119021690136398314name_collision_withhighModern Last Word is equal-parts gin/Chartreuse/maraschino/lime; historical Last Round is gin, dry vermouth, brandy, and Pernod.manual_modern_historical_curation.md#batch-022curated_db_onlydraftName-adjacent only.ontology_build\reports\modern_name_collision_review_draft.jsonl23{"record_type":"relationship_review","subject_recipe_id":11902,"subject_variant_id":16901,"object_recipe_id":3639,"object_variant_id":8314,"family_id":null,"relationship_type":"name_collision_with","confidence":"high","evidence_summary":"Modern Last Word is equal-parts gin/Chartreuse/maraschino/lime; historical Last Round is gin, dry vermouth, brandy, and Pernod.","evidence_batch":"manual_modern_historical_curation.md#batch-022","source_scope":"curated_db_only","promotion_status":"draft","promotion_notes":"Name-adjacent only."}7/12/2026, 9:00:02 AM7/12/2026, 9:00:02 AM