stigler

10 rows where calories = "2.2" and price_cents = "30.9"

✎ 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
44 44 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
121 121 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
198 198 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
275 275 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
352 352 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
429 429 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
506 506 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
583 583 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
660 660 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
737 737 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998

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
);