Modern ingredient usages

id	modern_record_id	recipe_ingredient_id	raw_name	raw_measure	canonical_name	mapping_status	parse_status	notes
1	1	45408	Vodka	30 ml Vodka	Vodka	exact_existing	parsed	{"category": "Spirit"}
2	1	45409	Cranberry juice	45 ml Cranberry juice	Cranberry juice	new_raw	parsed	{"category": "Still mixer"}
3	1	45410	Brut sparkling wine	45 ml Brut sparkling wine	Brut sparkling wine	new_raw	parsed	{"category": "Wine"}
4	2	45411	Gin	60 ml Gin	gin	exact_existing	parsed	{"category": "Spirit"}
5	2	45412	Canadian icewine	22.5 ml Canadian icewine	Canadian icewine	new_raw	parsed	{"category": "Wine"}
6	2	45413	Apple juice	22.5 ml Apple juice	Apple juice	new_raw	parsed	{"category": "Still mixer"}
7	2	45414	Dry vermouth	7.5 ml Dry vermouth	dry vermouth	exact_existing	parsed	{"category": "Vermouth"}
8	3	45415	Light white rum	45 ml Light white rum	Light white rum	new_raw	parsed	{"category": "Spirit"}
9	3	45416	Apricot liqueur	30 ml Apricot liqueur	Apricot liqueur	exact_existing	parsed	{"category": "Liqueur"}
10	3	45417	Lemon juice	22.5 ml Lemon juice	lemon juice	exact_existing	parsed	{"category": "Citrus juice"}
11	3	45418	Sugar syrup (2:1)	5 ml Sugar syrup (2:1)	Sugar syrup (2:1)	new_raw	parsed	{"category": "Syrup"}
12	3	45419	Egg white (pasteurised)	15 ml Egg white (pasteurised)	Egg white (pasteurised)	new_raw	parsed	{"category": "Egg"}
13	4	45420	Pineapple (fresh)	1 whole Pineapple (fresh)	Pineapple (fresh)	new_raw	parsed	{"category": "Garnish"}
14	4	45421	Light gold rum 1-3yo	90 ml Light gold rum 1-3yo	Light gold rum 1-3yo	new_raw	parsed	{"category": "Spirit"}
15	4	45422	Lime juice	22.5 ml Lime juice	lime juice	exact_existing	parsed	{"category": "Citrus juice"}
16	4	45423	Superfine/caster sugar	15 ml Superfine/caster sugar	Superfine/caster sugar	new_raw	parsed	{"category": "Sweetener"}
17	5	45424	Vodka	50 ml Vodka	Vodka	exact_existing	parsed	{"category": "Spirit"}
18	5	45425	Black raspberry liqueur	20 ml Black raspberry liqueur	Black raspberry liqueur	new_raw	parsed	{"category": "Liqueur"}
19	5	45426	Lemon juice	30 ml Lemon juice	lemon juice	exact_existing	parsed	{"category": "Citrus juice"}
20	5	45427	Sugar syrup (2:1)	5 ml Sugar syrup (2:1)	Sugar syrup (2:1)	exact_existing	parsed	{"category": "Syrup"}
21	5	45428	Soda (club soda) water	45 ml Soda (club soda) water	Soda (club soda) water	new_raw	parsed	{"category": "Carbonated mixer"}
22	6	45429	Red bitter liqueur	30 ml Red bitter liqueur	Red bitter liqueur	new_raw	parsed	{"category": "Bitters"}
23	6	45430	Citrus vodka	30 ml Citrus vodka	Citrus vodka	new_raw	parsed	{"category": "Spirit"}
24	6	45431	Apple juice	30 ml Apple juice	Apple juice	exact_existing	parsed	{"category": "Still mixer"}
25	6	45432	Passion fruit syrup	15 ml Passion fruit syrup	Passion fruit syrup	new_raw	parsed	{"category": "Syrup"}
26	7	45433	White overproof rum	20 ml White overproof rum	White overproof rum	new_raw	parsed	{"category": "Spirit"}
27	7	45434	Aged rum (6-10yr)	20 ml Aged rum (6-10yr)	Aged rum (6-10yr)	new_raw	parsed	{"category": "Spirit"}
28	7	45435	Amaro (e.g. Montenegro)	20 ml Amaro (e.g. Montenegro)	Amaro (e.g. Montenegro)	new_raw	parsed	{"category": "Liqueur"}
29	7	45436	Chilled water	10 ml Chilled water	Chilled water	new_raw	parsed	{"category": "Still mixer"}
30	8	45437	White overproof rum	30 ml White overproof rum	White overproof rum	exact_existing	parsed	{"category": "Spirit"}
31	8	45438	Apricot liqueur	15 ml Apricot liqueur	Apricot liqueur	exact_existing	parsed	{"category": "Liqueur"}
32	8	45439	Orange juice	30 ml Orange juice	orange juice	exact_existing	parsed	{"category": "Citrus juice"}
33	8	45440	Lemon juice	15 ml Lemon juice	lemon juice	exact_existing	parsed	{"category": "Citrus juice"}
34	8	45441	Fernet liqueur	5 ml Fernet liqueur	Fernet liqueur	new_raw	parsed	{"category": "Liqueur"}
35	9	45442	Dark/black rum	60 ml Dark/black rum	Dark/black rum	new_raw	parsed	{"category": "Spirit"}
36	9	45443	Cynar/carciofo amaro	20 ml Cynar/carciofo amaro	Cynar/carciofo amaro	new_raw	parsed	{"category": "Liqueur"}
37	9	45444	Cinnamon syrup	5 ml Cinnamon syrup	Cinnamon syrup	new_raw	parsed	{"category": "Syrup"}
38	10	45445	Gin	30 ml Gin	gin	exact_existing	parsed	{"category": "Spirit"}
39	10	45446	Orange Curaçao	20 ml Orange Curaçao	Orange curacao	exact_existing	parsed	{"category": "Liqueur"}
40	10	45447	Aromatized wine	20 ml Aromatized wine	Aromatized wine	new_raw	parsed	{"category": "Wine"}
41	11	45448	Tsipouro	50 ml Tsipouro	Tsipouro	unresolved	parsed	{"category": "Other"}
42	11	45449	Sauvignon Blanc wine	20 ml Sauvignon Blanc wine	Sauvignon Blanc wine	new_raw	parsed	{"category": "Wine"}
43	11	45450	Sugar syrup (2:1)	10 ml Sugar syrup (2:1)	Sugar syrup (2:1)	exact_existing	parsed	{"category": "Syrup"}
44	11	45451	Soda (club soda) water	10 ml Soda (club soda) water	Soda (club soda) water	exact_existing	parsed	{"category": "Carbonated mixer"}
45	12	45452	Cognac (brandy)	60 ml Cognac (brandy)	Cognac brandy	exact_existing	parsed	{"category": "Spirit"}
46	12	45453	Red quinquina e.g. Dubonnet, Byrrh	30 ml Red quinquina e.g. Dubonnet, Byrrh	Red quinquina e.g. Dubonnet, Byrrh	unresolved	parsed	{"category": "Other"}
47	12	45454	Rose petal liqueur	5 ml Rose petal liqueur	Rose petal liqueur	new_raw	parsed	{"category": "Liqueur"}
48	12	45455	Creole bitters	1 dash Creole bitters	Creole bitters	new_raw	parsed	{"category": "Bitters"}
49	13	45456	Vodka	15 ml Vodka	Vodka	exact_existing	parsed	{"category": "Spirit"}
50	13	45457	Reposado tequila	15 ml Reposado tequila	Reposado tequila	new_raw	parsed	{"category": "Spirit"}