V2__seed_culinary_catalog.sql
20,438 bytes
| 1 | insert into destination (code, name, local_name, region_name, summary, center_lat, center_lng, accent_color, display_order) values |
|---|---|
| 2 | ('JP', 'Japan', '日本', 'East Asia', 'A food culture shaped by seasonality, precision, preservation, and strong regional identities.', 36.2048, 138.2529, '#E84749', 1), |
| 3 | ('MX', 'Mexico', 'México', 'North America', 'Maize, chiles, beans, herbs, and regional techniques form one of the world''s deepest everyday food traditions.', 23.6345, -102.5528, '#E96A2C', 2), |
| 4 | ('PT', 'Portugal', 'Portugal', 'Southern Europe', 'Atlantic seafood, preserved cod, broths, small sandwiches, coffee, and convent sweets.', 39.3999, -8.2245, '#2878A5', 3), |
| 5 | ('GE', 'Georgia', 'საქართველო', 'Caucasus', 'Bread, cheese, walnuts, herbs, dumplings, and ancient wine traditions meet around a shared table.', 42.3154, 43.3569, '#A6503B', 4), |
| 6 | ('TH', 'Thailand', 'ประเทศไทย', 'Southeast Asia', 'Sweet, sour, salty, spicy, and bitter notes are balanced across street stalls and regional kitchens.', 15.8700, 100.9925, '#7258B8', 5), |
| 7 | ('VN', 'Vietnam', 'Việt Nam', 'Southeast Asia', 'Fresh herbs, broths, rice, grilled meats, and strong coffee change distinctly from north to south.', 14.0583, 108.2772, '#2D8A68', 6), |
| 8 | ('MA', 'Morocco', 'المغرب', 'North Africa', 'Slow cooking, grains, preserved citrus, warm spices, tea, and communal eating define the table.', 31.7917, -7.0926, '#C7543A', 7), |
| 9 | ('PE', 'Peru', 'Perú', 'South America', 'Andean produce, Pacific seafood, Indigenous traditions, and migration created a highly varied cuisine.', -9.1900, -75.0152, '#D84545', 8), |
| 10 | ('IT', 'Italy', 'Italia', 'Southern Europe', 'Local ingredients and regional identity matter more than a single national menu.', 41.8719, 12.5674, '#3A8A63', 9), |
| 11 | ('IN', 'India', 'भारत', 'South Asia', 'A vast collection of regional cuisines connected by layered spice, grains, legumes, and varied techniques.', 20.5937, 78.9629, '#D9822B', 10), |
| 12 | ('EE', 'Estonia', 'Eesti', 'Northern Europe', 'Seasonal forest ingredients, rye, dairy, preserved fish, grains, and modern Nordic influences.', 58.5953, 25.0136, '#3B76B8', 11), |
| 13 | ('KR', 'South Korea', '대한민국', 'East Asia', 'Fermentation, shared side dishes, rice, soups, grills, and lively street food shape daily eating.', 35.9078, 127.7669, '#8B4DA8', 12); |
| 14 | |
| 15 | insert into dish (slug, destination_code, name, local_name, category, description, why_it_matters, importance, image_url, vegetarian, spicy_level, display_order) values |
| 16 | ('ramen', 'JP', 'Ramen', 'ラーメン', 'STAPLE', 'Wheat noodles served in a carefully built broth with regional toppings.', 'Its broths and styles reveal strong local identities, from Sapporo miso to Hakata tonkotsu.', 5, null, false, 1, 1), |
| 17 | ('takoyaki', 'JP', 'Takoyaki', 'たこ焼き', 'STREET', 'Griddled batter balls filled with octopus and finished with sauce and bonito.', 'A defining Osaka street snack built around speed, technique, and communal eating.', 4, null, false, 0, 2), |
| 18 | ('japanese-breakfast', 'JP', 'Japanese breakfast', '朝ご飯', 'BREAKFAST', 'Rice, miso soup, pickles, fish, and small sides served as a balanced morning meal.', 'It shows the structure of an everyday Japanese meal better than a single famous dish.', 4, null, false, 0, 3), |
| 19 | ('daifuku', 'JP', 'Daifuku', '大福', 'SWEET', 'Soft mochi wrapped around a sweet filling, commonly red bean paste.', 'It introduces the texture and restrained sweetness central to wagashi.', 3, null, true, 0, 4), |
| 20 | ('matcha', 'JP', 'Matcha', '抹茶', 'DRINK', 'Finely milled green tea whisked with hot water.', 'Its preparation connects everyday taste with a long ceremonial tradition.', 3, null, true, 0, 5), |
| 21 | ('sushi', 'JP', 'Sushi', '寿司', 'SIGNATURE', 'Seasoned rice paired with seafood, vegetables, egg, or preserved ingredients.', 'The rice, seasonality, knife work, and many regional forms make it more than raw fish.', 5, null, false, 0, 6), |
| 22 | |
| 23 | ('mole-poblano', 'MX', 'Mole poblano', 'Mole poblano', 'STAPLE', 'A layered chile sauce with spices, seeds, nuts, and sometimes cacao, commonly served with poultry.', 'It represents celebration cooking and the patience of building flavor in stages.', 5, null, false, 2, 1), |
| 24 | ('tacos-al-pastor', 'MX', 'Tacos al pastor', 'Tacos al pastor', 'STREET', 'Marinated pork shaved from a vertical spit into small maize tortillas.', 'The dish shows how Lebanese migration and Mexican street cooking formed something new.', 5, null, false, 2, 2), |
| 25 | ('chilaquiles', 'MX', 'Chilaquiles', 'Chilaquiles', 'BREAKFAST', 'Tortilla pieces simmered briefly in salsa and topped with crema, cheese, onion, and egg or meat.', 'A practical breakfast that makes yesterday''s tortillas the center of the meal.', 4, null, true, 2, 3), |
| 26 | ('churros', 'MX', 'Churros', 'Churros', 'SWEET', 'Fried ridged dough coated with sugar and often served with chocolate or caramel.', 'They are an accessible entry into Mexico''s street-side sweet culture.', 3, null, true, 0, 4), |
| 27 | ('agua-fresca', 'MX', 'Agua fresca', 'Agua fresca', 'DRINK', 'Fruit, seeds, flowers, or grains blended with water and a little sugar.', 'Flavors such as jamaica and horchata are part of everyday markets and lunch counters.', 3, null, true, 0, 5), |
| 28 | ('pozole', 'MX', 'Pozole', 'Pozole', 'SIGNATURE', 'A hominy stew served with crisp vegetables, lime, chile, and regional meat or vegetarian bases.', 'Its Indigenous roots and role in gatherings make it culturally central.', 5, null, false, 2, 6), |
| 29 | |
| 30 | ('bacalhau-a-bras', 'PT', 'Bacalhau à Brás', 'Bacalhau à Brás', 'STAPLE', 'Salt cod folded through thin potatoes, onion, and softly set egg.', 'It shows how preserved cod became part of everyday Portuguese cooking far from the fishing grounds.', 5, null, false, 0, 1), |
| 31 | ('bifana', 'PT', 'Bifana', 'Bifana', 'STREET', 'Thin marinated pork in a crusty bread roll, often sharpened with mustard or hot sauce.', 'This small sandwich is a direct taste of cafés, markets, and late-night counters.', 4, null, false, 1, 2), |
| 32 | ('pao-galao', 'PT', 'Pão com manteiga and galão', 'Pão com manteiga e galão', 'BREAKFAST', 'Buttered bread with a tall glass of milky coffee.', 'The simple pairing reflects the daily rhythm of the Portuguese neighbourhood café.', 3, null, true, 0, 3), |
| 33 | ('pastel-de-nata', 'PT', 'Pastel de nata', 'Pastel de nata', 'SWEET', 'A blistered puff pastry tart filled with baked egg custard.', 'It links convent baking traditions with one of Portugal''s most recognisable café rituals.', 5, null, true, 0, 4), |
| 34 | ('vinho-verde', 'PT', 'Vinho Verde', 'Vinho Verde', 'DRINK', 'Young, bright wine from northwestern Portugal, ranging from white to red and rosé.', 'It expresses a protected region rather than a grape or simply a green-coloured wine.', 3, null, true, 0, 5), |
| 35 | ('caldo-verde', 'PT', 'Caldo verde', 'Caldo verde', 'SIGNATURE', 'A smooth potato and onion soup threaded with finely cut greens.', 'The humble soup appears at home, celebrations, and late-night gatherings across Portugal.', 4, null, false, 0, 6), |
| 36 | |
| 37 | ('lobio', 'GE', 'Lobio', 'ლობიო', 'STAPLE', 'Slow-cooked beans seasoned with herbs and spices, often served in a clay pot.', 'It shows the depth of Georgia''s vegetable and pulse cooking beside its better-known breads and meat.', 4, null, true, 1, 1), |
| 38 | ('khachapuri', 'GE', 'Khachapuri', 'ხაჭაპური', 'STREET', 'Cheese-filled bread with shapes and fillings that vary by region.', 'Comparing Imeretian, Adjarian, and other forms is a map of Georgia in bread.', 5, null, true, 0, 2), |
| 39 | ('khashi', 'GE', 'Khashi', 'ხაში', 'BREAKFAST', 'A restorative garlic-rich soup traditionally eaten early in the morning.', 'Its timing, rituals, and social setting reveal a side of Georgian eating missed by restaurant highlights.', 3, null, false, 0, 3), |
| 40 | ('churchkhela', 'GE', 'Churchkhela', 'ჩურჩხელა', 'SWEET', 'Nuts threaded on a string and repeatedly dipped in thickened grape juice.', 'The portable sweet connects grape harvest, preservation, and household craft.', 4, null, true, 0, 4), |
| 41 | ('amber-wine', 'GE', 'Qvevri amber wine', 'ქვევრის ღვინო', 'DRINK', 'White grapes fermented with skins in buried clay vessels called qvevri.', 'Georgia''s qvevri tradition is one of the world''s oldest continuous winemaking methods.', 5, null, true, 0, 5), |
| 42 | ('khinkali', 'GE', 'Khinkali', 'ხინკალი', 'SIGNATURE', 'Pleated dumplings filled with seasoned meat, mushrooms, potato, or cheese.', 'Eating the broth-filled dumpling by hand is as important as its filling.', 5, null, false, 1, 6), |
| 43 | |
| 44 | ('pad-kra-pao', 'TH', 'Pad kra pao', 'ผัดกะเพรา', 'STAPLE', 'A fast stir-fry of holy basil, chile, garlic, and protein over rice.', 'It is a common made-to-order meal that shows the direct force of Thai wok cooking.', 5, null, false, 3, 1), |
| 45 | ('moo-ping', 'TH', 'Moo ping', 'หมูปิ้ง', 'STREET', 'Sweet-savoury pork skewers grilled over charcoal and commonly eaten with sticky rice.', 'The smoke, marinade, and portability make it a morning and street-market staple.', 4, null, false, 1, 2), |
| 46 | ('jok', 'TH', 'Jok', 'โจ๊ก', 'BREAKFAST', 'Soft rice porridge topped with pork, egg, ginger, and fresh herbs.', 'It shows the gentle, comforting side of Thai flavour beyond chile-forward dishes.', 3, null, false, 0, 3), |
| 47 | ('mango-sticky-rice', 'TH', 'Mango sticky rice', 'ข้าวเหนียวมะม่วง', 'SWEET', 'Glutinous rice enriched with coconut milk and served with ripe mango.', 'The dish depends on fruit season, rice texture, and the balance of salt and sweetness.', 4, null, true, 0, 4), |
| 48 | ('cha-yen', 'TH', 'Thai iced tea', 'ชาเย็น', 'DRINK', 'Strong brewed tea poured over ice with sweetened milk.', 'Its colour, sweetness, and cooling role make it part of modern street-food life.', 3, null, true, 0, 5), |
| 49 | ('tom-yum-goong', 'TH', 'Tom yum goong', 'ต้มยำกุ้ง', 'SIGNATURE', 'A hot and sour prawn soup scented with lemongrass, galangal, lime leaf, and chile.', 'It demonstrates the balance and aromatic layering at the heart of Thai cooking.', 5, null, false, 3, 6), |
| 50 | |
| 51 | ('com-tam', 'VN', 'Cơm tấm', 'Cơm tấm', 'STAPLE', 'Broken rice served with grilled pork, pickles, scallion oil, and fish sauce.', 'Once a thrifty use of fractured grains, it became a defining southern everyday plate.', 4, null, false, 1, 1), |
| 52 | ('banh-mi', 'VN', 'Bánh mì', 'Bánh mì', 'STREET', 'A crisp baguette filled with pâté, meats or tofu, pickles, herbs, and chile.', 'It carries the history of French colonial bread transformed by Vietnamese ingredients.', 5, null, false, 2, 2), |
| 53 | ('pho', 'VN', 'Phở', 'Phở', 'BREAKFAST', 'Rice noodles in an aromatic broth with herbs and sliced meat.', 'Often eaten in the morning, its northern and southern forms expose regional differences.', 5, null, false, 1, 3), |
| 54 | ('che-ba-mau', 'VN', 'Chè ba màu', 'Chè ba màu', 'SWEET', 'A layered dessert of beans, jelly, coconut milk, and crushed ice.', 'It introduces chè as a broad Vietnamese category rather than one fixed dessert.', 3, null, true, 0, 4), |
| 55 | ('ca-phe-sua-da', 'VN', 'Cà phê sữa đá', 'Cà phê sữa đá', 'DRINK', 'Dark drip coffee mixed with condensed milk and poured over ice.', 'The drink reflects Vietnam''s coffee-growing history and slow streetside café culture.', 4, null, true, 0, 5), |
| 56 | ('bun-bo-hue', 'VN', 'Bún bò Huế', 'Bún bò Huế', 'SIGNATURE', 'A lemongrass-scented spicy noodle soup associated with the former imperial city of Huế.', 'It expands the traveller''s view beyond phở and highlights central Vietnamese cuisine.', 5, null, false, 3, 6), |
| 57 | |
| 58 | ('couscous', 'MA', 'Couscous', 'كسكس', 'STAPLE', 'Steamed semolina grains served with vegetables, broth, and often meat.', 'Friday couscous is a shared family meal and a key expression of Amazigh food heritage.', 5, null, false, 1, 1), |
| 59 | ('msemen', 'MA', 'Msemen', 'مسمن', 'STREET', 'A layered square flatbread cooked on a griddle and served sweet or savoury.', 'It moves easily between breakfast tables, tea stalls, and street snacks.', 4, null, true, 0, 2), |
| 60 | ('bissara', 'MA', 'Bissara', 'بيصارة', 'BREAKFAST', 'A thick fava bean or split pea soup finished with olive oil, cumin, and chile.', 'This inexpensive breakfast shows Morocco''s everyday pulse-based cooking.', 3, null, true, 1, 3), |
| 61 | ('chebakia', 'MA', 'Chebakia', 'الشباكية', 'SWEET', 'Flower-shaped fried pastry coated with honey and sesame.', 'It is closely associated with Ramadan tables and the soup harira.', 3, null, true, 0, 4), |
| 62 | ('mint-tea', 'MA', 'Moroccan mint tea', 'أتاي بالنعناع', 'DRINK', 'Green tea brewed with mint and sugar, poured from height into small glasses.', 'Preparation and service express hospitality as much as refreshment.', 5, null, true, 0, 5), |
| 63 | ('tagine', 'MA', 'Tagine', 'طاجين', 'SIGNATURE', 'A slow-cooked stew named for its conical earthenware vessel.', 'Regional combinations of meat, vegetables, fruit, and preserved lemon reward looking beyond one recipe.', 5, null, false, 1, 6), |
| 64 | |
| 65 | ('lomo-saltado', 'PE', 'Lomo saltado', 'Lomo saltado', 'STAPLE', 'Beef, onion, tomato, and chile stir-fried with soy sauce and served with rice and fries.', 'The dish makes Chinese Peruvian chifa influence visible on one plate.', 5, null, false, 1, 1), |
| 66 | ('anticuchos', 'PE', 'Anticuchos', 'Anticuchos', 'STREET', 'Marinated beef heart skewers grilled over high heat with chile and spices.', 'They connect pre-Columbian ingredients, colonial history, and modern street cooking.', 5, null, false, 2, 2), |
| 67 | ('pan-con-chicharron', 'PE', 'Pan con chicharrón', 'Pan con chicharrón', 'BREAKFAST', 'A roll filled with fried pork, sweet potato, and sharp onion relish.', 'The mix of rich, sweet, and acidic flavours is a classic weekend breakfast.', 4, null, false, 1, 3), |
| 68 | ('picarones', 'PE', 'Picarones', 'Picarones', 'SWEET', 'Squash and sweet-potato rings fried and served with spiced syrup.', 'They are a distinctly Peruvian relative of the doughnut with Indigenous ingredients.', 4, null, true, 0, 4), |
| 69 | ('chicha-morada', 'PE', 'Chicha morada', 'Chicha morada', 'DRINK', 'A purple-corn drink simmered with fruit and spices and served chilled.', 'Its colour and core ingredient come directly from Andean biodiversity.', 4, null, true, 0, 5), |
| 70 | ('ceviche', 'PE', 'Ceviche', 'Ceviche', 'SIGNATURE', 'Fresh fish cured briefly in lime with chile, onion, and coriander.', 'Timing, fish quality, leche de tigre, and regional sides make it central to Peru''s coastal identity.', 5, null, false, 2, 6), |
| 71 | |
| 72 | ('pasta-carbonara', 'IT', 'Pasta carbonara', 'Pasta alla carbonara', 'STAPLE', 'Pasta coated with egg, pecorino, cured pork, and black pepper.', 'Its short ingredient list makes Roman technique and ingredient choices impossible to hide.', 5, null, false, 0, 1), |
| 73 | ('arancini', 'IT', 'Arancini', 'Arancini', 'STREET', 'Breaded and fried rice parcels with regional fillings.', 'Names, shapes, and fillings reveal local identity across Sicily.', 4, null, false, 0, 2), |
| 74 | ('cornetto-cappuccino', 'IT', 'Cornetto and cappuccino', 'Cornetto e cappuccino', 'BREAKFAST', 'A filled or plain pastry paired with milk coffee at the bar.', 'The compact ritual explains the pace and social rules of the Italian morning café.', 4, null, true, 0, 3), |
| 75 | ('tiramisu', 'IT', 'Tiramisù', 'Tiramisù', 'SWEET', 'Coffee-soaked biscuits layered with mascarpone cream and cocoa.', 'Its modern origin and many regional claims make it part dessert and part identity debate.', 4, null, true, 0, 4), |
| 76 | ('espresso', 'IT', 'Espresso', 'Caffè espresso', 'DRINK', 'A small concentrated coffee commonly taken standing at the bar.', 'Ordering and drinking it in context is a daily social ritual, not only a brewing method.', 4, null, true, 0, 5), |
| 77 | ('pizza-napoletana', 'IT', 'Neapolitan pizza', 'Pizza napoletana', 'SIGNATURE', 'Soft, blistered dough baked quickly at high heat with restrained toppings.', 'The dough, oven, and Neapolitan craft distinguish it from the global category called pizza.', 5, null, true, 0, 6), |
| 78 | |
| 79 | ('dal-tadka', 'IN', 'Dal tadka', 'दाल तड़का', 'STAPLE', 'Cooked lentils finished with a hot tempering of spices and aromatics.', 'Dal shows how pulses, texture, and tempering techniques underpin daily meals across many regions.', 4, null, true, 1, 1), |
| 80 | ('pani-puri', 'IN', 'Pani puri', 'पानी पूरी', 'STREET', 'Crisp hollow shells filled with potato, chickpeas, chutney, and spiced water.', 'Its many regional names and variations make comparison part of the experience.', 5, null, true, 3, 2), |
| 81 | ('masala-dosa', 'IN', 'Masala dosa', 'मसाला डोसा', 'BREAKFAST', 'A fermented rice and lentil crêpe wrapped around spiced potato.', 'This southern breakfast demonstrates fermentation, griddle technique, and a full set of accompaniments.', 5, null, true, 2, 3), |
| 82 | ('gulab-jamun', 'IN', 'Gulab jamun', 'गुलाब जामुन', 'SWEET', 'Fried milk-solid dumplings soaked in fragrant sugar syrup.', 'It is a widely recognised celebration sweet while still varying by household and region.', 3, null, true, 0, 4), |
| 83 | ('masala-chai', 'IN', 'Masala chai', 'मसाला चाय', 'DRINK', 'Black tea simmered with milk, sugar, and a changing mix of spices.', 'The small glass or cup belongs to daily breaks, stations, homes, and roadside stalls.', 4, null, true, 1, 5), |
| 84 | ('biryani', 'IN', 'Biryani', 'बिरयानी', 'SIGNATURE', 'Layered or cooked-together rice with aromatics, spices, and meat or vegetables.', 'Hyderabadi, Lucknowi, Kolkata, and other biryanis show why India cannot be reduced to one flavour profile.', 5, null, false, 2, 6), |
| 85 | |
| 86 | ('mulgipuder', 'EE', 'Mulgipuder', 'Mulgipuder', 'STAPLE', 'Mashed potatoes and barley groats traditionally served with pork and onion.', 'The farmhouse dish ties southern Estonian regional identity to filling grain-and-potato cooking.', 4, null, false, 0, 1), |
| 87 | ('kiluleib', 'EE', 'Sprat sandwich', 'Kiluvõileib', 'STREET', 'Dark rye bread topped with spiced sprat, egg, and fresh onion or herbs.', 'Its compact combination of rye and Baltic fish is an immediate Estonian flavour marker.', 5, null, false, 0, 2), |
| 88 | ('kama', 'EE', 'Kama', 'Kama', 'BREAKFAST', 'A roasted grain and pea flour mixture stirred into kefir, yoghurt, or buttermilk.', 'The preserved flour began as practical travel food and remains distinctively Estonian.', 5, null, true, 0, 3), |
| 89 | ('kohuke', 'EE', 'Kohuke', 'Kohuke', 'SWEET', 'A small sweet curd snack usually coated in chocolate or glaze.', 'It is a familiar everyday dairy snack across generations, not a restaurant dessert.', 4, null, true, 0, 4), |
| 90 | ('kali', 'EE', 'Kali', 'Kali', 'DRINK', 'A lightly fermented, low-alcohol or alcohol-free drink made from rye bread or malt.', 'Its malty tartness connects bread culture with a traditional everyday drink.', 3, null, true, 0, 5), |
| 91 | ('verivorst', 'EE', 'Blood sausage', 'Verivorst', 'SIGNATURE', 'Barley blood sausage served with sauerkraut, potatoes, and lingonberry preserve.', 'The winter and Christmas context matters as much as the sausage itself.', 5, null, false, 0, 6), |
| 92 | |
| 93 | ('bibimbap', 'KR', 'Bibimbap', '비빔밥', 'STAPLE', 'Rice mixed with seasoned vegetables, sauce, egg, and optional meat.', 'The act of mixing varied prepared components reflects balance within one bowl.', 4, null, false, 2, 1), |
| 94 | ('tteokbokki', 'KR', 'Tteokbokki', '떡볶이', 'STREET', 'Chewy rice cakes cooked in a glossy, often spicy gochujang sauce.', 'It is a defining modern snack-shop and market food with many new variations.', 5, null, true, 3, 2), |
| 95 | ('gukbap', 'KR', 'Gukbap', '국밥', 'BREAKFAST', 'Hot soup served with rice, often built around beef, pork, or offal.', 'Regional bowls show the restorative, practical side of Korean morning and late-night eating.', 3, null, false, 1, 3), |
| 96 | ('hotteok', 'KR', 'Hotteok', '호떡', 'SWEET', 'Pan-fried filled pancakes, commonly with brown sugar, seeds, and nuts.', 'The crisp-chewy winter snack is best understood fresh from a street griddle.', 4, null, true, 0, 4), |
| 97 | ('makgeolli', 'KR', 'Makgeolli', '막걸리', 'DRINK', 'A cloudy lightly sparkling rice alcohol with a soft tang.', 'Its farming history and pairing with savoury pancakes make drinking context important.', 4, null, true, 0, 5), |
| 98 | ('kimchi', 'KR', 'Kimchi', '김치', 'SIGNATURE', 'Vegetables salted and fermented with seasonings, with hundreds of regional and seasonal forms.', 'Kimchi is a technique, side dish, preservation system, and shared cultural practice.', 5, null, true, 3, 6); |
| 99 | |