stigler

10 rows where price_cents = "29.2", vitamin_a_iu = "0.0" and vitamin_c_mg = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ commodity unit price_cents calories protein_g calcium_g iron_mg vitamin_a_iu vitamin_b1_mg vitamin_b2_mg niacin_mg vitamin_c_mg
27 27 Rib Roast 1 lb. 29.2 3.4 213 0.1 33 0.0 0.0 2.0 0 0
104 104 Rib Roast 1 lb. 29.2 3.4 213 0.1 33 0.0 0.0 2.0 0 0
181 181 Rib Roast 1 lb. 29.2 3.4 213 0.1 33 0.0 0.0 2.0 0 0
258 258 Rib Roast 1 lb. 29.2 3.4 213 0.1 33 0.0 0.0 2.0 0 0
335 335 Rib Roast 1 lb. 29.2 3.4 213 0.1 33 0.0 0.0 2.0 0 0
412 412 Rib Roast 1 lb. 29.2 3.4 213 0.1 33 0.0 0.0 2.0 0 0
489 489 Rib Roast 1 lb. 29.2 3.4 213 0.1 33 0.0 0.0 2.0 0 0
566 566 Rib Roast 1 lb. 29.2 3.4 213 0.1 33 0.0 0.0 2.0 0 0
643 643 Rib Roast 1 lb. 29.2 3.4 213 0.1 33 0.0 0.0 2.0 0 0
720 720 Rib Roast 1 lb. 29.2 3.4 213 0.1 33 0.0 0.0 2.0 0 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "stigler" (
"commodity" TEXT,
  "unit" TEXT,
  "price_cents" REAL,
  "calories" REAL,
  "protein_g" INTEGER,
  "calcium_g" REAL,
  "iron_mg" INTEGER,
  "vitamin_a_iu" REAL,
  "vitamin_b1_mg" REAL,
  "vitamin_b2_mg" REAL,
  "niacin_mg" INTEGER,
  "vitamin_c_mg" INTEGER
);