home / calmcode

stigler

20 rows where unit = "1 lb." and vitamin_b2_mg = "4.3"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commodity, price_cents, calories, protein_g, calcium_g, iron_mg, vitamin_a_iu, vitamin_b1_mg, niacin_mg, vitamin_c_mg

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
64 64 Peaches, Dried 1 lb. 15.7 8.5 87 1.7 173 86.8 1.2 4.3 55 57
65 65 Prunes, Dried 1 lb. 9.0 12.8 99 2.5 154 85.7 3.9 4.3 65 257
141 141 Peaches, Dried 1 lb. 15.7 8.5 87 1.7 173 86.8 1.2 4.3 55 57
142 142 Prunes, Dried 1 lb. 9.0 12.8 99 2.5 154 85.7 3.9 4.3 65 257
218 218 Peaches, Dried 1 lb. 15.7 8.5 87 1.7 173 86.8 1.2 4.3 55 57
219 219 Prunes, Dried 1 lb. 9.0 12.8 99 2.5 154 85.7 3.9 4.3 65 257
295 295 Peaches, Dried 1 lb. 15.7 8.5 87 1.7 173 86.8 1.2 4.3 55 57
296 296 Prunes, Dried 1 lb. 9.0 12.8 99 2.5 154 85.7 3.9 4.3 65 257
372 372 Peaches, Dried 1 lb. 15.7 8.5 87 1.7 173 86.8 1.2 4.3 55 57
373 373 Prunes, Dried 1 lb. 9.0 12.8 99 2.5 154 85.7 3.9 4.3 65 257
449 449 Peaches, Dried 1 lb. 15.7 8.5 87 1.7 173 86.8 1.2 4.3 55 57
450 450 Prunes, Dried 1 lb. 9.0 12.8 99 2.5 154 85.7 3.9 4.3 65 257
526 526 Peaches, Dried 1 lb. 15.7 8.5 87 1.7 173 86.8 1.2 4.3 55 57
527 527 Prunes, Dried 1 lb. 9.0 12.8 99 2.5 154 85.7 3.9 4.3 65 257
603 603 Peaches, Dried 1 lb. 15.7 8.5 87 1.7 173 86.8 1.2 4.3 55 57
604 604 Prunes, Dried 1 lb. 9.0 12.8 99 2.5 154 85.7 3.9 4.3 65 257
680 680 Peaches, Dried 1 lb. 15.7 8.5 87 1.7 173 86.8 1.2 4.3 55 57
681 681 Prunes, Dried 1 lb. 9.0 12.8 99 2.5 154 85.7 3.9 4.3 65 257
757 757 Peaches, Dried 1 lb. 15.7 8.5 87 1.7 173 86.8 1.2 4.3 55 57
758 758 Prunes, Dried 1 lb. 9.0 12.8 99 2.5 154 85.7 3.9 4.3 65 257

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 25.467ms