stigler
50 rows where unit = "No. 2" sorted by calories descending
This data as json, CSV (advanced)
Suggested facets: commodity, price_cents, calories, protein_g, calcium_g, iron_mg, vitamin_a_iu, vitamin_b1_mg, vitamin_b2_mg, niacin_mg, vitamin_c_mg
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
62 | 62 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
139 | 139 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
216 | 216 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
293 | 293 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
370 | 370 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
447 | 447 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
524 | 524 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
601 | 601 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
678 | 678 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
755 | 755 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
58 | 58 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
135 | 135 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
212 | 212 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
289 | 289 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
366 | 366 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
443 | 443 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
520 | 520 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
597 | 597 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
674 | 674 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
751 | 751 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
57 | 57 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
134 | 134 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
211 | 211 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
288 | 288 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
365 | 365 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
442 | 442 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
519 | 519 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
596 | 596 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
673 | 673 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
750 | 750 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
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 );