stigler
50 rows where unit = "No. 2" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61 | 61 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
138 | 138 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
215 | 215 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
292 | 292 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
369 | 369 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
446 | 446 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
523 | 523 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
600 | 600 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
677 | 677 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
754 | 754 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
60 | 60 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
137 | 137 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
214 | 214 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
291 | 291 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
368 | 368 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
445 | 445 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
522 | 522 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
599 | 599 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
676 | 676 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
753 | 753 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
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 );