stigler
440 rows where unit = "1 lb." sorted by vitamin_c_mg
This data as json, CSV (advanced)
Suggested facets: calcium_g, vitamin_a_iu, 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | Macaroni | 1 lb. | 14.1 | 11.6 | 418 | 0.7 | 54 | 0.0 | 3.2 | 1.9 | 68 | 0 |
5 | 5 | Corn Meal | 1 lb. | 4.6 | 36.0 | 897 | 1.7 | 99 | 30.9 | 17.4 | 7.9 | 106 | 0 |
7 | 7 | Rice | 1 lb. | 7.5 | 21.2 | 460 | 0.6 | 41 | 0.0 | 2.0 | 4.8 | 60 | 0 |
8 | 8 | Rolled Oats | 1 lb. | 7.1 | 25.3 | 907 | 5.1 | 341 | 0.0 | 37.1 | 8.9 | 64 | 0 |
9 | 9 | White Bread (Enriched) | 1 lb. | 7.9 | 15.0 | 488 | 2.5 | 115 | 0.0 | 13.8 | 8.5 | 126 | 0 |
10 | 10 | Whole Wheat Bread | 1 lb. | 9.1 | 12.2 | 484 | 2.7 | 125 | 0.0 | 13.9 | 6.4 | 160 | 0 |
11 | 11 | Rye Bread | 1 lb. | 9.1 | 12.4 | 439 | 1.1 | 82 | 0.0 | 9.9 | 3.0 | 66 | 0 |
12 | 12 | Pound Cake | 1 lb. | 24.8 | 8.0 | 130 | 0.4 | 31 | 18.9 | 2.8 | 3.0 | 17 | 0 |
13 | 13 | Soda Crackers | 1 lb. | 15.1 | 12.5 | 288 | 0.5 | 50 | 0.0 | 0.0 | 0.0 | 0 | 0 |
16 | 16 | Butter | 1 lb. | 30.8 | 10.8 | 9 | 0.2 | 3 | 44.2 | 0.0 | 0.2 | 2 | 0 |
17 | 17 | Oleomargarine | 1 lb. | 16.1 | 20.6 | 17 | 0.6 | 6 | 55.8 | 0.2 | 0.0 | 0 | 0 |
19 | 19 | Cheese (Cheddar) | 1 lb. | 24.2 | 7.4 | 448 | 16.4 | 19 | 28.1 | 0.8 | 10.3 | 4 | 0 |
21 | 21 | Peanut Butter | 1 lb. | 17.9 | 15.7 | 661 | 1.0 | 48 | 0.0 | 9.6 | 8.1 | 471 | 0 |
23 | 23 | Crisco | 1 lb. | 20.3 | 20.1 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 |
24 | 24 | Lard | 1 lb. | 9.8 | 41.7 | 0 | 0.0 | 0 | 0.2 | 0.0 | 0.5 | 5 | 0 |
25 | 25 | Sirloin Steak | 1 lb. | 39.6 | 2.9 | 166 | 0.1 | 34 | 0.2 | 2.1 | 2.9 | 69 | 0 |
26 | 26 | Round Steak | 1 lb. | 36.4 | 2.2 | 214 | 0.1 | 32 | 0.4 | 2.5 | 2.4 | 87 | 0 |
27 | 27 | Rib Roast | 1 lb. | 29.2 | 3.4 | 213 | 0.1 | 33 | 0.0 | 0.0 | 2.0 | 0 | 0 |
28 | 28 | Chuck Roast | 1 lb. | 22.6 | 3.6 | 309 | 0.2 | 46 | 0.4 | 1.0 | 4.0 | 120 | 0 |
29 | 29 | Plate | 1 lb. | 14.6 | 8.5 | 404 | 0.2 | 62 | 0.0 | 0.9 | 0.0 | 0 | 0 |
31 | 31 | Leg of Lamb | 1 lb. | 27.6 | 3.1 | 245 | 0.1 | 20 | 0.0 | 2.8 | 3.9 | 86 | 0 |
32 | 32 | Lamb Chops (Rib) | 1 lb. | 36.6 | 3.3 | 140 | 0.1 | 15 | 0.0 | 1.7 | 2.7 | 54 | 0 |
33 | 33 | Pork Chops | 1 lb. | 30.7 | 3.5 | 196 | 0.2 | 30 | 0.0 | 17.4 | 2.7 | 60 | 0 |
34 | 34 | Pork Loin Roast | 1 lb. | 24.2 | 4.4 | 249 | 0.3 | 37 | 0.0 | 18.2 | 3.6 | 79 | 0 |
35 | 35 | Bacon | 1 lb. | 25.6 | 10.4 | 152 | 0.2 | 23 | 0.0 | 1.8 | 1.8 | 71 | 0 |
36 | 36 | Ham, smoked | 1 lb. | 27.4 | 6.7 | 212 | 0.2 | 31 | 0.0 | 9.9 | 3.3 | 50 | 0 |
37 | 37 | Salt Pork | 1 lb. | 16.0 | 18.8 | 164 | 0.1 | 26 | 0.0 | 1.4 | 1.8 | 0 | 0 |
39 | 39 | Veal Cutlets | 1 lb. | 42.3 | 1.7 | 156 | 0.1 | 24 | 0.0 | 1.4 | 2.4 | 57 | 0 |
67 | 67 | Peas, Dried | 1 lb. | 7.9 | 20.0 | 1367 | 4.2 | 345 | 2.9 | 28.7 | 18.4 | 162 | 0 |
68 | 68 | Lima Beans, Dried | 1 lb. | 8.9 | 17.4 | 1055 | 3.7 | 459 | 5.1 | 26.9 | 38.2 | 93 | 0 |
69 | 69 | Navy Beans, Dried | 1 lb. | 5.9 | 26.9 | 1691 | 11.4 | 792 | 0.0 | 38.4 | 24.6 | 217 | 0 |
70 | 70 | Coffee | 1 lb. | 22.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 4.0 | 5.1 | 50 | 0 |
77 | 77 | Strawberry Preserves | 1 lb. | 20.5 | 6.4 | 11 | 0.4 | 7 | 0.2 | 0.2 | 0.4 | 3 | 0 |
79 | 79 | Macaroni | 1 lb. | 14.1 | 11.6 | 418 | 0.7 | 54 | 0.0 | 3.2 | 1.9 | 68 | 0 |
82 | 82 | Corn Meal | 1 lb. | 4.6 | 36.0 | 897 | 1.7 | 99 | 30.9 | 17.4 | 7.9 | 106 | 0 |
84 | 84 | Rice | 1 lb. | 7.5 | 21.2 | 460 | 0.6 | 41 | 0.0 | 2.0 | 4.8 | 60 | 0 |
85 | 85 | Rolled Oats | 1 lb. | 7.1 | 25.3 | 907 | 5.1 | 341 | 0.0 | 37.1 | 8.9 | 64 | 0 |
86 | 86 | White Bread (Enriched) | 1 lb. | 7.9 | 15.0 | 488 | 2.5 | 115 | 0.0 | 13.8 | 8.5 | 126 | 0 |
87 | 87 | Whole Wheat Bread | 1 lb. | 9.1 | 12.2 | 484 | 2.7 | 125 | 0.0 | 13.9 | 6.4 | 160 | 0 |
88 | 88 | Rye Bread | 1 lb. | 9.1 | 12.4 | 439 | 1.1 | 82 | 0.0 | 9.9 | 3.0 | 66 | 0 |
89 | 89 | Pound Cake | 1 lb. | 24.8 | 8.0 | 130 | 0.4 | 31 | 18.9 | 2.8 | 3.0 | 17 | 0 |
90 | 90 | Soda Crackers | 1 lb. | 15.1 | 12.5 | 288 | 0.5 | 50 | 0.0 | 0.0 | 0.0 | 0 | 0 |
93 | 93 | Butter | 1 lb. | 30.8 | 10.8 | 9 | 0.2 | 3 | 44.2 | 0.0 | 0.2 | 2 | 0 |
94 | 94 | Oleomargarine | 1 lb. | 16.1 | 20.6 | 17 | 0.6 | 6 | 55.8 | 0.2 | 0.0 | 0 | 0 |
96 | 96 | Cheese (Cheddar) | 1 lb. | 24.2 | 7.4 | 448 | 16.4 | 19 | 28.1 | 0.8 | 10.3 | 4 | 0 |
98 | 98 | Peanut Butter | 1 lb. | 17.9 | 15.7 | 661 | 1.0 | 48 | 0.0 | 9.6 | 8.1 | 471 | 0 |
100 | 100 | Crisco | 1 lb. | 20.3 | 20.1 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 |
101 | 101 | Lard | 1 lb. | 9.8 | 41.7 | 0 | 0.0 | 0 | 0.2 | 0.0 | 0.5 | 5 | 0 |
102 | 102 | Sirloin Steak | 1 lb. | 39.6 | 2.9 | 166 | 0.1 | 34 | 0.2 | 2.1 | 2.9 | 69 | 0 |
103 | 103 | Round Steak | 1 lb. | 36.4 | 2.2 | 214 | 0.1 | 32 | 0.4 | 2.5 | 2.4 | 87 | 0 |
104 | 104 | Rib Roast | 1 lb. | 29.2 | 3.4 | 213 | 0.1 | 33 | 0.0 | 0.0 | 2.0 | 0 | 0 |
105 | 105 | Chuck Roast | 1 lb. | 22.6 | 3.6 | 309 | 0.2 | 46 | 0.4 | 1.0 | 4.0 | 120 | 0 |
106 | 106 | Plate | 1 lb. | 14.6 | 8.5 | 404 | 0.2 | 62 | 0.0 | 0.9 | 0.0 | 0 | 0 |
108 | 108 | Leg of Lamb | 1 lb. | 27.6 | 3.1 | 245 | 0.1 | 20 | 0.0 | 2.8 | 3.9 | 86 | 0 |
109 | 109 | Lamb Chops (Rib) | 1 lb. | 36.6 | 3.3 | 140 | 0.1 | 15 | 0.0 | 1.7 | 2.7 | 54 | 0 |
110 | 110 | Pork Chops | 1 lb. | 30.7 | 3.5 | 196 | 0.2 | 30 | 0.0 | 17.4 | 2.7 | 60 | 0 |
111 | 111 | Pork Loin Roast | 1 lb. | 24.2 | 4.4 | 249 | 0.3 | 37 | 0.0 | 18.2 | 3.6 | 79 | 0 |
112 | 112 | Bacon | 1 lb. | 25.6 | 10.4 | 152 | 0.2 | 23 | 0.0 | 1.8 | 1.8 | 71 | 0 |
113 | 113 | Ham, smoked | 1 lb. | 27.4 | 6.7 | 212 | 0.2 | 31 | 0.0 | 9.9 | 3.3 | 50 | 0 |
114 | 114 | Salt Pork | 1 lb. | 16.0 | 18.8 | 164 | 0.1 | 26 | 0.0 | 1.4 | 1.8 | 0 | 0 |
116 | 116 | Veal Cutlets | 1 lb. | 42.3 | 1.7 | 156 | 0.1 | 24 | 0.0 | 1.4 | 2.4 | 57 | 0 |
144 | 144 | Peas, Dried | 1 lb. | 7.9 | 20.0 | 1367 | 4.2 | 345 | 2.9 | 28.7 | 18.4 | 162 | 0 |
145 | 145 | Lima Beans, Dried | 1 lb. | 8.9 | 17.4 | 1055 | 3.7 | 459 | 5.1 | 26.9 | 38.2 | 93 | 0 |
146 | 146 | Navy Beans, Dried | 1 lb. | 5.9 | 26.9 | 1691 | 11.4 | 792 | 0.0 | 38.4 | 24.6 | 217 | 0 |
147 | 147 | Coffee | 1 lb. | 22.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 4.0 | 5.1 | 50 | 0 |
154 | 154 | Strawberry Preserves | 1 lb. | 20.5 | 6.4 | 11 | 0.4 | 7 | 0.2 | 0.2 | 0.4 | 3 | 0 |
156 | 156 | Macaroni | 1 lb. | 14.1 | 11.6 | 418 | 0.7 | 54 | 0.0 | 3.2 | 1.9 | 68 | 0 |
159 | 159 | Corn Meal | 1 lb. | 4.6 | 36.0 | 897 | 1.7 | 99 | 30.9 | 17.4 | 7.9 | 106 | 0 |
161 | 161 | Rice | 1 lb. | 7.5 | 21.2 | 460 | 0.6 | 41 | 0.0 | 2.0 | 4.8 | 60 | 0 |
162 | 162 | Rolled Oats | 1 lb. | 7.1 | 25.3 | 907 | 5.1 | 341 | 0.0 | 37.1 | 8.9 | 64 | 0 |
163 | 163 | White Bread (Enriched) | 1 lb. | 7.9 | 15.0 | 488 | 2.5 | 115 | 0.0 | 13.8 | 8.5 | 126 | 0 |
164 | 164 | Whole Wheat Bread | 1 lb. | 9.1 | 12.2 | 484 | 2.7 | 125 | 0.0 | 13.9 | 6.4 | 160 | 0 |
165 | 165 | Rye Bread | 1 lb. | 9.1 | 12.4 | 439 | 1.1 | 82 | 0.0 | 9.9 | 3.0 | 66 | 0 |
166 | 166 | Pound Cake | 1 lb. | 24.8 | 8.0 | 130 | 0.4 | 31 | 18.9 | 2.8 | 3.0 | 17 | 0 |
167 | 167 | Soda Crackers | 1 lb. | 15.1 | 12.5 | 288 | 0.5 | 50 | 0.0 | 0.0 | 0.0 | 0 | 0 |
170 | 170 | Butter | 1 lb. | 30.8 | 10.8 | 9 | 0.2 | 3 | 44.2 | 0.0 | 0.2 | 2 | 0 |
171 | 171 | Oleomargarine | 1 lb. | 16.1 | 20.6 | 17 | 0.6 | 6 | 55.8 | 0.2 | 0.0 | 0 | 0 |
173 | 173 | Cheese (Cheddar) | 1 lb. | 24.2 | 7.4 | 448 | 16.4 | 19 | 28.1 | 0.8 | 10.3 | 4 | 0 |
175 | 175 | Peanut Butter | 1 lb. | 17.9 | 15.7 | 661 | 1.0 | 48 | 0.0 | 9.6 | 8.1 | 471 | 0 |
177 | 177 | Crisco | 1 lb. | 20.3 | 20.1 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 |
178 | 178 | Lard | 1 lb. | 9.8 | 41.7 | 0 | 0.0 | 0 | 0.2 | 0.0 | 0.5 | 5 | 0 |
179 | 179 | Sirloin Steak | 1 lb. | 39.6 | 2.9 | 166 | 0.1 | 34 | 0.2 | 2.1 | 2.9 | 69 | 0 |
180 | 180 | Round Steak | 1 lb. | 36.4 | 2.2 | 214 | 0.1 | 32 | 0.4 | 2.5 | 2.4 | 87 | 0 |
181 | 181 | Rib Roast | 1 lb. | 29.2 | 3.4 | 213 | 0.1 | 33 | 0.0 | 0.0 | 2.0 | 0 | 0 |
182 | 182 | Chuck Roast | 1 lb. | 22.6 | 3.6 | 309 | 0.2 | 46 | 0.4 | 1.0 | 4.0 | 120 | 0 |
183 | 183 | Plate | 1 lb. | 14.6 | 8.5 | 404 | 0.2 | 62 | 0.0 | 0.9 | 0.0 | 0 | 0 |
185 | 185 | Leg of Lamb | 1 lb. | 27.6 | 3.1 | 245 | 0.1 | 20 | 0.0 | 2.8 | 3.9 | 86 | 0 |
186 | 186 | Lamb Chops (Rib) | 1 lb. | 36.6 | 3.3 | 140 | 0.1 | 15 | 0.0 | 1.7 | 2.7 | 54 | 0 |
187 | 187 | Pork Chops | 1 lb. | 30.7 | 3.5 | 196 | 0.2 | 30 | 0.0 | 17.4 | 2.7 | 60 | 0 |
188 | 188 | Pork Loin Roast | 1 lb. | 24.2 | 4.4 | 249 | 0.3 | 37 | 0.0 | 18.2 | 3.6 | 79 | 0 |
189 | 189 | Bacon | 1 lb. | 25.6 | 10.4 | 152 | 0.2 | 23 | 0.0 | 1.8 | 1.8 | 71 | 0 |
190 | 190 | Ham, smoked | 1 lb. | 27.4 | 6.7 | 212 | 0.2 | 31 | 0.0 | 9.9 | 3.3 | 50 | 0 |
191 | 191 | Salt Pork | 1 lb. | 16.0 | 18.8 | 164 | 0.1 | 26 | 0.0 | 1.4 | 1.8 | 0 | 0 |
193 | 193 | Veal Cutlets | 1 lb. | 42.3 | 1.7 | 156 | 0.1 | 24 | 0.0 | 1.4 | 2.4 | 57 | 0 |
221 | 221 | Peas, Dried | 1 lb. | 7.9 | 20.0 | 1367 | 4.2 | 345 | 2.9 | 28.7 | 18.4 | 162 | 0 |
222 | 222 | Lima Beans, Dried | 1 lb. | 8.9 | 17.4 | 1055 | 3.7 | 459 | 5.1 | 26.9 | 38.2 | 93 | 0 |
223 | 223 | Navy Beans, Dried | 1 lb. | 5.9 | 26.9 | 1691 | 11.4 | 792 | 0.0 | 38.4 | 24.6 | 217 | 0 |
224 | 224 | Coffee | 1 lb. | 22.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 4.0 | 5.1 | 50 | 0 |
231 | 231 | Strawberry Preserves | 1 lb. | 20.5 | 6.4 | 11 | 0.4 | 7 | 0.2 | 0.2 | 0.4 | 3 | 0 |
233 | 233 | Macaroni | 1 lb. | 14.1 | 11.6 | 418 | 0.7 | 54 | 0.0 | 3.2 | 1.9 | 68 | 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 );