data.sql

INSERT INTO foods (hardness, temp, image, tastes, name, country, continent, ingredients, description)
VALUES
   ('solid', 'hot', 'sarma.png', 'sweet, sour, salty', 'Sarma', 'Turkey', 'Asia', 'beef, lamb or pork, cabbage, rice, onion, tomato sauce', 'A type of dolma, a stuffed dish of the cuisines of the former Ottoman Empire from the Middle East to Southeastern Europe.'),
   ('solid', 'cold', 'banchan.png', 'sweet, sour', 'Banchan', 'South Korea', 'Asia', 'kimchi, rice, (pickled or fresh) vegetables, grilled meat', 'A collective name for small side dishes served along with cooked rice in Korean cuisine.'),
   ('soft', 'cold', 'pavlova.png', 'sweet', 'Pavlova', 'Australia and New Zealand', 'Australia and Zealandia', 'fresh fruits, whipped cream, egg whites, sugar (meringue)', 'A meringue-based desert with a crisp crust and soft, light inside, usually topped with fruit and whipped cream.'),
   ('solid', 'hot', 'grilledcheese.png', 'salty, umami', 'Grilled cheese sandwich', 'USA', 'North America', 'bread, cheese, butter', 'A  hot sandwich made with one or more varieties of cheese on bread.'),
   ('solid', 'hot', 'bruschetta.png', 'salty, sour, umami', 'Bruschetta', 'Italy', 'Europe', 'bread, garlic, olive oil, tomato, basil, oregano, wild fennel', 'An antipasto consisting of grilled bread rubbed with garlic and topped with olive oil and salt.'),
   ('solid', 'hot', 'borek.png', 'sweet, umami, salty', 'Borek', 'Turkey', 'Asia', 'phyllo or yufka dough, meat, cheese, potatoes, spinach', 'A family of baked filled pastries made of a thin flaky dough such as phyllo or yufka.'),
   ('solid', 'hot', 'churros.png', 'sweet', 'Churros', 'Spain', 'Europe', 'flour, olive oil, salt, sugar', 'A type of fried dough from Spanish and Portuguese cuisine.'),
   ('soft', 'hot', 'miso.png', 'umami, salty', 'Miso soup', 'Japan', 'Asia', 'dashi, miso, tofu, scallions', 'A traditional Japanese soup consisting of a dashi stock into which softened miso paste is mixed.'),
   ('soft', 'cold', 'parfait.png', 'sweet', 'Parfait', 'France', 'Europe', 'fruits, cream, eggs, sugar, syrup', 'A rich cold dessert made with whipped cream, eggs, and fruit.'),
   ('solid', 'hot', 'springrolls.png', 'umami, salty', 'Spring rolls', 'China', 'Asia', 'flour, eggs, mushroom, pork or shrimp, cabbage', 'Spring rolls are a large variety of filled, rolled appetizers found in Asian cuisine.'),
   ('solid', 'hot', 'fishandchips.png', 'sour, salty', 'Fish and chips', 'England', 'Europe', 'fish, potatoes, flour, lard, vinegar, salt', 'A popular hot dish consisting of fried fish in crispy batter, served with chips.'),
   ('solid', 'cold', 'mooncake.png', 'sweet, salty', 'Mooncake', 'China', 'Asia', 'flour, sugar, eggs, mung bean, sesame seeds', 'These are round or square in shape, and have a pastry exterior with a dense, sweet filling usually made from lotus paste. Many of them also contain a salted duck yolk.'),
   ('solid', 'hot', 'padthai.png', 'sweet, sour', 'Pad Thai', 'Thailand', 'Asia', 'noodles, peanuts, shrimp, bean sprouts, eggs, fish sauce, sugar', 'Thailands national dish, a flavorful stir-fry (pad in Thai) dish consisting of rice noodles, tofu, dried shrimp, bean sprouts, and eggs.'),
   ('solid', 'cold', 'ceviche.png', 'salty, sour', 'Ceviche', 'Peru', 'South America', 'fish, lime, chillies, onion, sweet potatoes', 'This is made from fresh raw fish cured in fresh citrus juices, most commonly lemon or lime, but historically made with the juice of bitter orange.'),
   ('solid', 'hot', 'fajitas.png', 'sour, umami, salty', 'Fajitas', 'Mexico', 'North America', 'tortilla, beed, onion, garlic, guacamoli (avocados), sour cream', 'a dish consisting of strips of spiced beef or chicken, chopped vegetables, and grated cheese, wrapped in a soft tortilla and often served with sour cream.'),
   ('solid', 'cold', 'chocochip.png', 'sweet', 'Chocolate Chip Cookies', 'USA', 'North America', 'chocolate, butter, flour, eggs, sugar', 'A  drop cookie that features chocolate chips or chocolate morsels as its distinguishing ingredient.'),
   ('solid', 'hot', 'bibimbap.png', 'sweet, umami', 'Bibimbap', 'South Korea', 'Asia', 'rice, beef, eggs, soy sauce, spinach, gochujang (red chili paste)', 'The term "bibim" means mixing rice, while the "bap" noun refers to rice. It is served as a bowl of warm white rice topped with namul or kimchi and gochujang, soy sauce, etc.'),
   ('solid', 'hot', 'bulgogi.png', 'sweet, umami', 'Bulgogi','South Korea', 'Asia', 'red meat or poultry or seafood, honey, sesame seed, soy sauce, garlic, scallions', 'Bulgogi, literally "fire meat", is made of thin, marinated slices of beef or pork grilled on a barbecue or on a stove-top griddle.'),
   ('solid', 'hot', 'quesadilla.png', 'salty, umami', 'Quesadilla', 'Mexico', 'North America', 'tortilla, cheese, meat, poultry or fish', 'A dish consisting of a tortilla that is filled primarily with cheese, and sometimes meats, spices, and other fillings, and then cooked on a griddle or stove.'),
   ('solid', 'hot', 'tonkatsu.png', 'sweet, umami', 'Tonkatsu', 'Japan', 'Asia', 'pork, flour, breadcrumbs, eggs, oil', 'A dish that consists of a breaded, deep-fried pork cutlet. It involves coating slices of pork with panko, frying them in oil, and then serving with rice and shredded cabbage.'),
   ('soft', 'cold', 'sundae.png', 'sweet', 'Ice cream sundae', 'USA', 'North America', 'ice cream, syrup, cherries, nuts', 'An ice cream dessert that typically consists of one or more scoops of ice cream topped with sauce or syrup and in some cases other toppings.'),
   ('soft', 'cold', 'hummus.png', 'umami', 'Hummus', 'Lebanon', 'Asia', 'tahini, chickpeas, lemon, garlic, cumin', 'A Middle Eastern dip, spread, or savory dish made from cooked, mashed chickpeas blended with tahini, lemon juice, and garlic.'),
   ('solid', 'hot', 'macncheese.png', 'umami', 'Macaroni and cheese', 'USA', 'North America', 'macaroni pasta, cheese', 'A dish of cooked macaroni pasta and a cheese sauce, most commonly cheddar. It can also incorporate other ingredients, such as breadcrumbs or meat.'),
   ('solid', 'hot', 'tamale.png', 'umami, sweet', 'Tamale', 'Mexico', 'North America', 'read meat or poultry, corn, chilies, masa (or dough)', 'A dish, made of masa or dough, which is steamed in a corn leaf or banana leaf. The wrapping can either be discarded prior to eating or used as a plate.'),
   ('solid', 'hot', 'burrito.png', 'umami, sour, sweet', 'Burrito', 'Mexico', 'North America', 'tortilla, ground meat, cheese, beans, cheese', 'A burrito is a dish in Mexican and Tex-Mex cuisine that took form in California cuisine, consisting of a flour tortilla wrapped into a sealed cylindrical shape around various ingredients.'),
   ('soft', 'hot', 'pho.png', 'sweet, salty', 'Pho', 'Vietnam', 'Asia', 'beef or chicken, noodles, ginger, garlic, onion, scallions', 'A Vietnamese soup dish consisting of broth, rice noodles, herbs, and meat, sometimes chicken.'),
   ('solid', 'hot', 'friedchicken.png', 'sweet, salty', 'Fried chicken', 'USA', 'North America', 'chicken, milk, flour, vegetable oil', 'A dish consisting of chicken pieces that have been coated with seasoned flour or batter and pan-fried, deep fried, pressure fried, or air fried.'),
   ('solid', 'cold', 'cheese.png', 'umami', 'Cheese', 'England, Greece, Italy, France', 'Europe', 'Cheddar, Feta, Mozzarella, Parmigiano Reggiano, Ricotta', 'A dairy product, derived from milk and produced in wide ranges of flavors, textures and forms by coagulation of the milk protein casein.'),
   ('solid', 'hot', 'carbonara.png', 'umami, sweet', 'Pasta carbonara', 'Italy', 'Europe', 'spaghetti, guanciale, egg yolk, romano cheese, black pepper', 'A dish from Rome made with eggs, hard cheese, cured pork, and black pepper. The dish arrived at its modern form, with its current name, in the middle of the 20th century.'),
   ('solid', 'hot', 'shabu.png', 'umami', 'Shabu shabu', 'Japan', 'Asia', 'red meat, poultry or seafood, rice, soy sauce', 'A hotpot dish of thinly sliced meat and vegetables boiled in water and served with dipping sauces.'),
   ('solid','hot', 'wonton.png', 'salty, sweet', 'Wonton', 'China', 'Asia', 'wheat flour, eggs, pork or shrimp, ginger, onion', 'A type of Chinese dumpling commonly found across regional styles of Chinese cuisine.'),
   ('solid', 'hot', 'biryani.png', 'umami, sour', 'Biryani', 'India', 'Asia', 'chicken or lamb, dried fruit, onion, basmati rice', 'A mixed rice dish originating among the Muslims of the Indian subcontinent. It is made with Indian spices, rice, and meat usually that of chicken, goat, lamb, prawn, fish, etc.'),
   ('soft', 'cold', 'soba.png', 'salty', 'Soba', 'Japan', 'Asia', 'buckwheat noodles, dipping sauce, vegetables', 'A thin Japanese noodle made from buckwheat. The noodles are served either chilled with a dipping sauce, or hot in a noodle soup.'),
   ('solid','hot', 'nachos.png', 'salty, umami', 'Nachos', 'Mexico', 'North America', 'torilla, cheese, jalapenos, tomatoes', 'A dish that consists of heated tortilla chips or totopos covered with melted cheese, often served as a snack or appetizer. '),
   ('soft', 'hot', 'quiche.png', 'salty, umami', 'Quiche', 'France', 'Europe', 'eggs, creme fraiche, milk, flour, cheese', 'A tart consisting of pastry crust filled with savoury custard and pieces of cheese, meat, seafood or vegetables.'),
   ('solid', 'cold', 'fudge.png', 'sweet', 'Fudge', 'USA', 'North America', 'chocolate, sugar, vanilla, milk, butter', 'A type of candy that is made by mixing sugar, butter and milk and cooking it to the point that it acquires a smooth, creamy consistency.'),
   ('solid', 'cold', 'onigiri.png', 'salty, sour', 'Onigiri', 'Japan', 'Asia', 'sticky rice, nori seaweed, kelp, tuna (or other) fish, Japanese plums', 'A food made from white rice formed into triangular or cylindrical shapes and often wrapped in seaweed.'),
   ('solid', 'hot','bolognese.png', 'umami, salty', 'Pasta Bolognese', 'Italy', 'Europe', 'pasta, beef, pancetta, tomatoes, butter', 'Bolognese is a slowly cooked meat-based sauce, and its preparation involves several techniques, including sweating, sautéing and braising.'),
   ('solid', 'hot', 'gyoza.png', 'umami, salty', 'Gyoza', 'Japan', 'Asia', 'wheat flour, eggs, chicken or pork, cabbage, garlic, onion, ginger', 'These are dumplings filled with ground meat and vegetables and wrapped in a thin dough.'),
   ('solid', 'hot', 'baozi.png', 'umami, sweet', 'Baozi', 'China', 'Asia', 'flour, yeast, ground meat, chives, sugar', 'A type of yeast-leavened filled bun in various Chinese cuisines. There are many variations in fillings and preparations, though the buns are most often steamed.'),
   ('solid', 'cold', 'tiramisu.png', 'sweet', 'Tiramisu', 'Italy', 'Europe', 'cocoa, egg yolk, marscapone cream, coffee, ladyfingers', 'This is made of ladyfingers dipped in coffee, layered with a whipped mixture of eggs, sugar, and mascarpone cheese, flavoured with cocoa.'),
   ('solid', 'hot', 'pretzel.png', 'salty', 'Pretzel', 'Germany', 'Europe', 'flour, yeast, butter, sugar, salt', 'A type of baked pastry made from dough that is commonly shaped into a knot.'),
   ('solid', 'cold', 'kimchi.png', 'sour', 'Kimchi', 'South Korea', 'Asia', 'fermented napa cabbage, scallions, onion, chili powder, garlic', 'A traditional side dish of salted and fermented vegetables, such as napa cabbage and Korean radish, made with a widely varying selection of seasonings.'),
   ('solid', 'hot', 'lasagne.png', 'umami, sweet', 'Lasagne', 'Italy', 'Europe', 'lasagna pasta, ground beef, tomatoes, onion, mozzarella, ricotta and Parmesan cheese', 'A dish made of stacked layers of thin flat pasta alternating with fillings, seasonings and spices such as garlic, oregano and basil.'),
   ('soft', 'hot', 'risotto.png', 'salty, sweet', 'Risotto', 'Italy', 'Europe', 'rice, butter, olive oil, onion, bone marrow', 'A rice dish cooked with broth until it reaches a creamy consistency. The broth can be derived from meat, fish, or vegetables.'),
   ('soft', 'cold', 'milkshake.png', 'sweet', 'Milkshake', 'USA', 'North America', 'milk, ice cream, sweet syrup', 'A sweet drink made by blending milk, ice cream, and flavorings or sweeteners such as butterscotch, caramel sauce, chocolate syrup, fruit syrup, or whole fruit into a thick, sweet, cold mixture.'),
   ('solid', 'cold', 'macarons.png', 'sweet', 'Macarons', 'France', 'Europe', 'almonds, sugar, eggs (meringue)', 'A sweet meringue-based confection made with egg white, icing sugar, granulated sugar, almond meal, and food colouring.'),
   ('solid', 'cold', 'donut.png', 'sweet', 'Doughnut', 'USA', 'North America', 'flour, butter, eggs, sugar, milk', 'A type of leavened fried dough. It is popular in many countries and is prepared in various forms as a sweet snack.'),
   ('solid', 'hot', 'fries.png', 'salty', 'French fries (pommes frites)', 'Belgium', 'Europe', 'potatoes, salt, vegetable oil or animal fat', 'These are prepared by cutting the potato into even strips, then drying and frying it, usually in a deep fryer.'),
   ('solid', 'cold','wagashi.png', 'sweet', 'Wagashi', 'Japan', 'Asia', 'mochi, bean paste, fruit and/or nuts', 'Traditional Japanese confections that are often served with green tea, especially the types made of mochi, anko, and fruit. Wagashi are typically made from plant-based ingredients.'),
   ('solid', 'hot', 'roti.png', 'salty', 'Roti', 'India', 'Asia', 'wheat flour, oil, ghee', 'A round flatbread native to the Indian subcontinent made from stoneground whole wheat flour and water that is combined into a dough.'),
   ('solid', 'hot', 'bbq.png', 'sweet, umami', 'Barbecue', 'USA', 'North America', 'meat or vegetables, various sauces', 'A term used with significant regional and national variations to describe various cooking methods which use live fire and smoke to cook the food.'),
   ('solid', 'hot', 'burger.png', 'sweet, sour, salty', 'Hamburger', 'USA', 'North America', 'beef, cheese, burger bun (bread), tomatoes, ketchup', 'A food, typically considered a sandwich, consisting of one or more cooked patties of ground meat, usually beef, placed inside a sliced bread roll or bun.'),
   ('solid', 'hot', 'paella.png', 'salty, sour', 'Paella', 'Spain', 'Europe', 'rice, tomatoes, meat, vegetables, beans, saffron', 'A rice dish that can have meat, fish, seafood, and vegetables and is characterized by its use of saffron to give it a yellow color and unique flavor.'),
   ('soft', 'cold','mousse.png', 'sweet', 'Mousse', 'France', 'Europe', 'dark chocolate, eggs, butter, sugar, salt', 'A soft prepared food that incorporates air bubbles to give it a light and airy texture. It can range from light and fluffy to creamy and thick. A mousse may be sweet or savory.'),
   ('solid', 'cold', 'brownies.png', 'sweet', 'Brownies', 'USA', 'North America', 'chocolate, butter, eggs, flour, cocoa beans', 'A square or rectangular chocolate baked confection. Brownies come in a variety of forms and may be either fudgy or cakey, depending on their density.'),
   ('soft', 'hot', 'udon.png', 'salty', 'Udon', 'Japan', 'Asia', 'wheat flour noodles, beef, scallions, broth made of soy sauce, dashi and mirin', 'A thick noodle soup that, in its simplest form is in a hot soup with a mild broth from dashi, soy sauce, and mirin.'),
   ('solid', 'hot', 'spaghetti.png', 'sour, umami', 'Spaghetti', 'Italy', 'Europe', 'spaghetti pasta, tomatoes, red meat, poultry or seafood', 'A long, thin, solid, cylindrical pasta. It is a staple food of traditional Italian cuisine often eaten with tomato sauces.'),
   ('solid', 'hot', 'dimsum.png', 'sweet, umami', 'Dim sum', 'China', 'Asia', 'wheat starch dough, soy sauce, chives, garlic, meat, poultry or seafood', 'A traditional Chinese meal made up of small plates of dumplings and other snack dishes and is usually accompanied by tea.'),
   ('solid', 'cold', 'sashimi.png', 'umami', 'Sashimi', 'Japan', 'Asia', 'seafood (including fish and octopus), soy sauce, wasabi, ginger', 'A Japanese delicacy consisting of fresh raw fish or meat sliced into thin pieces and often eaten with soy sauce.'),
   ('solid', 'cold', 'cupcakes.png', 'sweet', 'Cupcakes', 'USA', 'North America', 'butter, flour, eggs, milk, sugar', 'A small cake designed to serve one person topped with frosting and other cake decorations'),
   ('solid', 'cold', 'croissants.png', 'sweet, salty', 'Croissants', 'France', 'Europe', 'butter, flour, eggs, milk, sugar', 'A buttery, flaky, viennoiserie pastry of Austrian origin, but mostly associated with France. Croissants are named for their historical crescent shape.'),
   ('solid', 'hot', 'tacos.png', 'umami, salty, sour', 'Tacos', 'Mexico', 'North America', 'tortillas, meat or poultry or seafood, garlic, cheese', 'A dish consisting of a small hand-sized tortilla topped with a filling. The tortilla is then folded around the filling and eaten by hand.'),
   ('soft', 'hot', 'ramen.png', 'umami, salty', 'Ramen', 'Japan', 'Asia', 'wheat flour noodles, chicken or pork or seafood, root vegetables, mushroom', 'A noodle soup that consists of wheat noodles served in a meat or fish-based broth, often flavored with soy sauce or miso, and uses toppings.'),
   ('solid', 'hot', 'sushi.png', 'sour, umami', 'Sushi', 'Japan', 'Asia', 'seafood (including fish and octopus), scallions, rice, nori seaweed', 'A dish of prepared vinegared rice, accompanied by a variety of ingredients, such as seafood, often raw, and vegetables.'),
   ('solid', 'hot', 'pizza.png', 'sweet, sour, salty', 'Pizza', 'Italy', 'Europe', 'bread, cheese, tomato sauce, various toppings', 'A dish consisting of a usually round, flattened base of dough topped with tomatoes, cheese, which is then baked at a high temperature');