home / nutrition

meal_foods

23 rows where food_id = 26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: servings

id ▼ meal_id food_id servings
32 19 19 Monster Bad Apple (16 oz can) 26 0.5
33 20 20 Monster Bad Apple (16 oz can) 26 0.5
43 23 23 Monster Bad Apple (16 oz can) 26 1.0
86 47 47 Monster Bad Apple (16 oz can) 26 0.5
89 48 48 Monster Bad Apple (16 oz can) 26 0.5
113 60 60 Monster Bad Apple (16 oz can) 26 0.5
118 61 61 Monster Bad Apple (16 oz can) 26 0.5
123 63 63 Monster Bad Apple (16 oz can) 26 1.0
151 80 80 Monster Bad Apple (16 oz can) 26 1.0
184 102 102 Monster Bad Apple (16 oz can) 26 1.0
211 115 115 Monster Bad Apple (16 oz can) 26 1.0
221 122 122 Monster Bad Apple (16 oz can) 26 0.5
230 124 124 Monster Bad Apple (16 oz can) 26 0.5
319 169 169 Monster Bad Apple (16 oz can) 26 1.0
444 239 239 Monster Bad Apple (16 oz can) 26 0.5
445 240 240 Monster Bad Apple (16 oz can) 26 0.5
547 297 297 Monster Bad Apple (16 oz can) 26 0.5
551 300 300 Monster Bad Apple (16 oz can) 26 0.5
554 301 301 Monster Bad Apple (16 oz can) 26 0.5
556 303 303 Monster Bad Apple (16 oz can) 26 0.5
563 306 306 Monster Bad Apple (16 oz can) 26 0.5
565 307 307 Monster Bad Apple (16 oz can) 26 0.5
575 311 311 Monster Bad Apple (16 oz can) 26 0.5

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE meal_foods (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    meal_id INTEGER NOT NULL REFERENCES meals(id) ON DELETE CASCADE,
    food_id INTEGER NOT NULL REFERENCES foods(id),
    servings REAL NOT NULL DEFAULT 1.0
  );
Powered by Datasette · Queries took 3.699ms