stigler
10 rows where unit = "1 lb." and vitamin_c_mg = 862 sorted by calories
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45 | 45 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
122 | 122 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
199 | 199 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
276 | 276 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
353 | 353 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
430 | 430 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
507 | 507 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
584 | 584 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
661 | 661 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
738 | 738 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
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 );