You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 200 }, "api": { "title": "Recipes 2", "point": { "title": "By Table", "desc": "Each API function returns data by a specific database table. " } }, "input": { "url": false, "get": false, "post": false }, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/recipes_2/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/recipes_2/by_table/ingredient/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/recipes_2/by_table/ingredient/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 200, "time": 0.00091000000000000000159594559789866252685897052288055419921875 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 36046, "pages_total": 361 }, "struct": { "stem": { "0": "ingredient" }, "leaf": "ingredient.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "ingredient.id": 1, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "1 pound dried pinto beans (pink beans) or four 15-ounce cans cooked pinto beans" }, "2": { "ingredient.id": 2, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "1/4 pound bacon, chopped" }, "3": { "ingredient.id": 3, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "1 medium yellow onion, chopped" }, "4": { "ingredient.id": 4, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "3 garlic cloves, peeled and minced" }, "5": { "ingredient.id": 5, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "2 tablespoons tomato paste" }, "6": { "ingredient.id": 6, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "2 teaspoons ground cumin" }, "7": { "ingredient.id": 7, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "1/2 teaspoon ground coriander" }, "8": { "ingredient.id": 8, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "2 teaspoons chili powder (the spice blend)" }, "9": { "ingredient.id": 9, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "1/2 teaspoon cayenne, or shakes of your favorite hot sauce or chipotle purée to taste" }, "10": { "ingredient.id": 10, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "2 teaspoons coarse sea or kosher salt (for lightly salted broth; use more for unsalted broth, and less for salted or canned beans)" }, "11": { "ingredient.id": 11, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "4 cups vegetable broth (for dried beans) plus 1 cup water (if beans weren’t presoaked), or 1 1/2 cups vegetable broth (for precooked/canned beans)" }, "12": { "ingredient.id": 12, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "soft corn tortillas for tortilla chips (estimate 2 tortillas per person)" }, "13": { "ingredient.id": 13, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "fine salt, to taste" }, "14": { "ingredient.id": 14, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "1/2 medium-large white onion, minced" }, "15": { "ingredient.id": 15, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "1 jalapeño, seeded and minced" }, "16": { "ingredient.id": 16, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "2 tablespoons finely chopped fresh cilantro" }, "17": { "ingredient.id": 17, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "1 tablespoon olive oil" }, "18": { "ingredient.id": 18, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "juice of half a lime, plus more lime wedges" }, "19": { "ingredient.id": 19, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "1 large avocado, diced or sliced" }, "20": { "ingredient.id": 20, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "1 cup chopped fresh tomatoes" }, "21": { "ingredient.id": 21, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "sour cream, Mexican crema, or plain yogurt" }, "22": { "ingredient.id": 22, "ingredient.ts": "2017-11-07 04:27:56", "ingredient.value": "hot sauce" }, "23": { "ingredient.id": 23, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "2 8 ounce cans diced pimentos, drained" }, "24": { "ingredient.id": 24, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "2 cups shredded extra-sharp cheddar" }, "25": { "ingredient.id": 25, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "8 ounces cream cheese, softened" }, "26": { "ingredient.id": 26, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "1/2 cup mayonnaise" }, "27": { "ingredient.id": 27, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "1/4 teaspoon garlic powder" }, "28": { "ingredient.id": 28, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "1/4 teaspoon ground cayenne pepper" }, "29": { "ingredient.id": 29, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "1 tablespoon dried parsley" }, "30": { "ingredient.id": 30, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "1/4 teaspoon onion powder" }, "31": { "ingredient.id": 31, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "3 tablespoons lemon juice" }, "32": { "ingredient.id": 32, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "3 tablespoons Worcestershire sauce" }, "33": { "ingredient.id": 33, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "1 cup fresh grated Parmesan" }, "34": { "ingredient.id": 34, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "2 cups heavy cream" }, "35": { "ingredient.id": 35, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "2 tablespoons thyme leaves" }, "36": { "ingredient.id": 36, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "1 pound cavatappi, cooked per the instructions on the box" }, "37": { "ingredient.id": 37, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "toasted breadcrumbs, for garnish" }, "38": { "ingredient.id": 38, "ingredient.ts": "2017-11-07 04:29:52", "ingredient.value": "sliced chives, for garnish" }, "39": { "ingredient.id": 39, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "4 tablespoons pineapple juice" }, "40": { "ingredient.id": 40, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "2 tablespoons lemon juice" }, "41": { "ingredient.id": 41, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "3 tablespoons honey" }, "42": { "ingredient.id": 42, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "1 tablespoon chili vinegar" }, "43": { "ingredient.id": 43, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "1 tablespoon yuzu juice" }, "44": { "ingredient.id": 44, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "1 tablespoon sesame oil" }, "45": { "ingredient.id": 45, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "1/2 cup tamari" }, "46": { "ingredient.id": 46, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "2 tablespoons dried shrimp furikake" }, "47": { "ingredient.id": 47, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "1 head red cabbage" }, "48": { "ingredient.id": 48, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "1 tablespoon cornstarch" }, "49": { "ingredient.id": 49, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "salt" }, "50": { "ingredient.id": 50, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "freshly cracked black pepper" }, "51": { "ingredient.id": 51, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "12 fresh oysters, preferably Blue Point" }, "52": { "ingredient.id": 52, "ingredient.ts": "2017-11-07 04:29:58", "ingredient.value": "cilantro leaves, for garnish" }, "53": { "ingredient.id": 53, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "1 pound boneless dark meat chicken, diced and unseasoned" }, "54": { "ingredient.id": 54, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "2 teaspoons cornstarch" }, "55": { "ingredient.id": 55, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "2 teaspoons canola oil" }, "56": { "ingredient.id": 56, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "1 teaspoon fresh garlic, minced" }, "57": { "ingredient.id": 57, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "1 teaspoon fresh ginger, minced" }, "58": { "ingredient.id": 58, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "1/2 teaspoon green chilies, minced" }, "59": { "ingredient.id": 59, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "1 tablespoon sambal oelek" }, "60": { "ingredient.id": 60, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "5 teaspoons soy sauce" }, "61": { "ingredient.id": 61, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "1 teaspoon honey" }, "62": { "ingredient.id": 62, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "1 teaspoon cornstarch dissolved in 2 teaspoons water" }, "63": { "ingredient.id": 63, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "chopped scallions, for garnish" }, "64": { "ingredient.id": 64, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "julienned radish, for garnish" }, "65": { "ingredient.id": 65, "ingredient.ts": "2017-11-07 04:30:07", "ingredient.value": "torn cilantro, for garnish" }, "66": { "ingredient.id": 66, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "4 large eggs, separated" }, "67": { "ingredient.id": 67, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "1/2 cup organic cane sugar" }, "68": { "ingredient.id": 68, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "1/2 cup canola or other neutral oil" }, "69": { "ingredient.id": 69, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "8 ounces dark chocolate (70%), melted" }, "70": { "ingredient.id": 70, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "1/2 cup mashed avocado, pressed through a fine-mesh sieve" }, "71": { "ingredient.id": 71, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "1/4 teaspoon cream of tartar" }, "72": { "ingredient.id": 72, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "1/4 cup unsweetened cocoa powder, for garnish" }, "73": { "ingredient.id": 73, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "Blackberry Whipped Cream, (see below) for serving" }, "74": { "ingredient.id": 74, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "1 cup heavy cream" }, "75": { "ingredient.id": 75, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "2 teaspoons confectioners’ sugar" }, "76": { "ingredient.id": 76, "ingredient.ts": "2017-11-07 04:30:11", "ingredient.value": "2 teaspoons blackberry powder" }, "77": { "ingredient.id": 77, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "4 tablespoons unsalted butter, cut into several pieces" }, "78": { "ingredient.id": 78, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 small shallot, thinly sliced" }, "79": { "ingredient.id": 79, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 medium garlic clove, smashed and peeled" }, "80": { "ingredient.id": 80, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "8 ounces fresh porcini mushrooms, including stems, cleaned and thinly sliced" }, "81": { "ingredient.id": 81, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "kosher salt" }, "82": { "ingredient.id": 82, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "freshly ground black pepper" }, "83": { "ingredient.id": 83, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "4 tablespoons water" }, "84": { "ingredient.id": 84, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 large egg yolk" }, "85": { "ingredient.id": 85, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 1/2 teaspoons sherry vinegar, or as needed" }, "86": { "ingredient.id": 86, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 1/2 teaspoons Dijon mustard" }, "87": { "ingredient.id": 87, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 dash Tabasco sauce" }, "88": { "ingredient.id": 88, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1/4 teaspoon Porcini Spice Powder (recipe follows; optional)" }, "89": { "ingredient.id": 89, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 cup grapeseed oil" }, "90": { "ingredient.id": 90, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "2 ounces dried porcini mushrooms" }, "91": { "ingredient.id": 91, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "4 allspice berries" }, "92": { "ingredient.id": 92, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "8 white peppercorns" }, "93": { "ingredient.id": 93, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 1/2 teaspoons kosher salt" }, "94": { "ingredient.id": 94, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "3/4 teaspoons granulated sugar" }, "95": { "ingredient.id": 95, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 ounce kombu (Japanese dried kelp), snipped into pieces" }, "96": { "ingredient.id": 96, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 1/2-inch knob ginger, peeled and smashed" }, "97": { "ingredient.id": 97, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "2 medium garlic cloves, smashed and peeled" }, "98": { "ingredient.id": 98, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "2 strips Meyer lemon peel (each about 3 by 1 inch), white pith removed" }, "99": { "ingredient.id": 99, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "1 small rosemary sprig" }, "100": { "ingredient.id": 100, "ingredient.ts": "2017-11-07 04:30:20", "ingredient.value": "4 cups water" } } } }