home / calmcode

stigler

10 rows where protein_g = 63

✎ 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
62 62 Tomatoes (can) No. 2 8.6 1.3 63 0.7 38 53.2 3.4 2.5 36 1253
139 139 Tomatoes (can) No. 2 8.6 1.3 63 0.7 38 53.2 3.4 2.5 36 1253
216 216 Tomatoes (can) No. 2 8.6 1.3 63 0.7 38 53.2 3.4 2.5 36 1253
293 293 Tomatoes (can) No. 2 8.6 1.3 63 0.7 38 53.2 3.4 2.5 36 1253
370 370 Tomatoes (can) No. 2 8.6 1.3 63 0.7 38 53.2 3.4 2.5 36 1253
447 447 Tomatoes (can) No. 2 8.6 1.3 63 0.7 38 53.2 3.4 2.5 36 1253
524 524 Tomatoes (can) No. 2 8.6 1.3 63 0.7 38 53.2 3.4 2.5 36 1253
601 601 Tomatoes (can) No. 2 8.6 1.3 63 0.7 38 53.2 3.4 2.5 36 1253
678 678 Tomatoes (can) No. 2 8.6 1.3 63 0.7 38 53.2 3.4 2.5 36 1253
755 755 Tomatoes (can) No. 2 8.6 1.3 63 0.7 38 53.2 3.4 2.5 36 1253

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
);
Powered by Datasette · Queries took 19.748ms