stigler
10 rows where vitamin_c_mg = 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20 | 20 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
97 | 97 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
174 | 174 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
251 | 251 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
328 | 328 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
405 | 405 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
482 | 482 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
559 | 559 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
636 | 636 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
713 | 713 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
Advanced export
JSON shape: default, array, newline-delimited
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 );