stigler

10 rows where niacin_mg = 126, unit = "1 lb." and vitamin_a_iu = "0.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
9 9 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 0
86 86 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 0
163 163 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 0
240 240 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 0
317 317 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 0
394 394 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 0
471 471 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 0
548 548 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 0
625 625 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 0
702 702 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 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
);