stigler
10 rows where commodity = "Pork and Beans (can)" and unit = "16 oz." 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
59 | 59 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
136 | 136 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
213 | 213 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
290 | 290 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
367 | 367 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
444 | 444 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
521 | 521 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
598 | 598 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
675 | 675 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
752 | 752 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
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 );