stigler
10 rows where unit = "1/4 lb." sorted by calories descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
71 | 71 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 0 |
148 | 148 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 0 |
225 | 225 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 0 |
302 | 302 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 0 |
379 | 379 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 0 |
456 | 456 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 0 |
533 | 533 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 0 |
610 | 610 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 0 |
687 | 687 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 0 |
764 | 764 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 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 );