stigler
770 rows
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
201 | 201 | Carrots | 1 bunch | 4.7 | 2.7 | 73 | 2.8 | 43 | 188.5 | 6.1 | 4.3 | 89 | 608 |
202 | 202 | Celery | 1 stalk | 7.3 | 0.9 | 51 | 3.0 | 23 | 0.9 | 1.4 | 1.4 | 9 | 313 |
203 | 203 | Lettuce | 1 head | 8.2 | 0.4 | 27 | 1.1 | 22 | 112.4 | 1.8 | 3.4 | 11 | 449 |
204 | 204 | Onions | 1 lb. | 3.6 | 5.8 | 166 | 3.8 | 59 | 16.6 | 4.7 | 5.9 | 21 | 1184 |
205 | 205 | Potatoes | 15 lb. | 34.0 | 14.3 | 336 | 1.8 | 118 | 6.7 | 29.4 | 7.1 | 198 | 2522 |
206 | 206 | Spinach | 1 lb. | 8.1 | 1.1 | 106 | 0.0 | 138 | 918.4 | 5.7 | 13.8 | 33 | 2755 |
207 | 207 | Sweet Potatoes | 1 lb. | 5.1 | 9.6 | 138 | 2.7 | 54 | 290.7 | 8.4 | 5.4 | 83 | 1912 |
208 | 208 | Peaches (can) | No. 2 1/2 | 16.8 | 3.7 | 20 | 0.4 | 10 | 21.5 | 0.5 | 1.0 | 31 | 196 |
209 | 209 | Pears (can) | No. 2 1/2 | 20.4 | 3.0 | 8 | 0.3 | 8 | 0.8 | 0.8 | 0.8 | 5 | 81 |
210 | 210 | Pineapple (can) | No. 2 1/2 | 21.3 | 2.4 | 16 | 0.4 | 8 | 2.0 | 2.8 | 0.8 | 7 | 399 |
211 | 211 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
212 | 212 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
213 | 213 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
214 | 214 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
215 | 215 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
216 | 216 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
217 | 217 | Tomato Soup (can) | 10 1/2 oz. | 7.6 | 1.6 | 71 | 0.6 | 43 | 57.9 | 3.5 | 2.4 | 67 | 862 |
218 | 218 | Peaches, Dried | 1 lb. | 15.7 | 8.5 | 87 | 1.7 | 173 | 86.8 | 1.2 | 4.3 | 55 | 57 |
219 | 219 | Prunes, Dried | 1 lb. | 9.0 | 12.8 | 99 | 2.5 | 154 | 85.7 | 3.9 | 4.3 | 65 | 257 |
220 | 220 | Raisins, Dried | 15 oz. | 9.4 | 13.5 | 104 | 2.5 | 136 | 4.5 | 6.3 | 1.4 | 24 | 136 |
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 |
225 | 225 | Tea | 1/4 lb. | 17.4 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 2.3 | 42 | 0 |
226 | 226 | Cocoa | 8 oz. | 8.6 | 8.7 | 237 | 3.0 | 72 | 0.0 | 2.0 | 11.9 | 40 | 0 |
227 | 227 | Chocolate | 8 oz. | 16.2 | 8.0 | 77 | 1.3 | 39 | 0.0 | 0.9 | 3.4 | 14 | 0 |
228 | 228 | Sugar | 10 lb. | 51.7 | 34.9 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 |
229 | 229 | Corn Syrup | 24 oz. | 13.7 | 14.7 | 0 | 0.5 | 74 | 0.0 | 0.0 | 0.0 | 5 | 0 |
230 | 230 | Molasses | 18 oz. | 13.6 | 9.0 | 0 | 10.3 | 244 | 0.0 | 1.9 | 7.5 | 146 | 0 |
231 | 231 | Strawberry Preserves | 1 lb. | 20.5 | 6.4 | 11 | 0.4 | 7 | 0.2 | 0.2 | 0.4 | 3 | 0 |
232 | 232 | Wheat Flour (Enriched) | 10 lb. | 36.0 | 44.7 | 1411 | 2.0 | 365 | 0.0 | 55.4 | 33.3 | 441 | 0 |
233 | 233 | Macaroni | 1 lb. | 14.1 | 11.6 | 418 | 0.7 | 54 | 0.0 | 3.2 | 1.9 | 68 | 0 |
234 | 234 | Wheat Cereal (Enriched) | 28 oz. | 24.2 | 11.8 | 377 | 14.4 | 175 | 0.0 | 14.4 | 8.8 | 114 | 0 |
235 | 235 | Corn Flakes | 8 oz. | 7.1 | 11.4 | 252 | 0.1 | 56 | 0.0 | 13.5 | 2.3 | 68 | 0 |
236 | 236 | Corn Meal | 1 lb. | 4.6 | 36.0 | 897 | 1.7 | 99 | 30.9 | 17.4 | 7.9 | 106 | 0 |
237 | 237 | Hominy Grits | 24 oz. | 8.5 | 28.6 | 680 | 0.8 | 80 | 0.0 | 10.6 | 1.6 | 110 | 0 |
238 | 238 | Rice | 1 lb. | 7.5 | 21.2 | 460 | 0.6 | 41 | 0.0 | 2.0 | 4.8 | 60 | 0 |
239 | 239 | Rolled Oats | 1 lb. | 7.1 | 25.3 | 907 | 5.1 | 341 | 0.0 | 37.1 | 8.9 | 64 | 0 |
240 | 240 | White Bread (Enriched) | 1 lb. | 7.9 | 15.0 | 488 | 2.5 | 115 | 0.0 | 13.8 | 8.5 | 126 | 0 |
241 | 241 | Whole Wheat Bread | 1 lb. | 9.1 | 12.2 | 484 | 2.7 | 125 | 0.0 | 13.9 | 6.4 | 160 | 0 |
242 | 242 | Rye Bread | 1 lb. | 9.1 | 12.4 | 439 | 1.1 | 82 | 0.0 | 9.9 | 3.0 | 66 | 0 |
243 | 243 | Pound Cake | 1 lb. | 24.8 | 8.0 | 130 | 0.4 | 31 | 18.9 | 2.8 | 3.0 | 17 | 0 |
244 | 244 | Soda Crackers | 1 lb. | 15.1 | 12.5 | 288 | 0.5 | 50 | 0.0 | 0.0 | 0.0 | 0 | 0 |
245 | 245 | Milk | 1 qt. | 11.0 | 6.1 | 310 | 10.5 | 18 | 16.8 | 4.0 | 16.0 | 7 | 177 |
246 | 246 | Evaporated Milk (can) | 14.5 oz. | 6.7 | 8.4 | 422 | 15.1 | 9 | 26.0 | 3.0 | 23.5 | 11 | 60 |
247 | 247 | Butter | 1 lb. | 30.8 | 10.8 | 9 | 0.2 | 3 | 44.2 | 0.0 | 0.2 | 2 | 0 |
248 | 248 | Oleomargarine | 1 lb. | 16.1 | 20.6 | 17 | 0.6 | 6 | 55.8 | 0.2 | 0.0 | 0 | 0 |
249 | 249 | Eggs | 1 doz. | 32.6 | 2.9 | 238 | 1.0 | 52 | 18.6 | 2.8 | 6.5 | 1 | 0 |
250 | 250 | Cheese (Cheddar) | 1 lb. | 24.2 | 7.4 | 448 | 16.4 | 19 | 28.1 | 0.8 | 10.3 | 4 | 0 |
251 | 251 | Cream | 1/2 pt. | 14.1 | 3.5 | 49 | 1.7 | 3 | 16.9 | 0.6 | 2.5 | 0 | 17 |
252 | 252 | Peanut Butter | 1 lb. | 17.9 | 15.7 | 661 | 1.0 | 48 | 0.0 | 9.6 | 8.1 | 471 | 0 |
253 | 253 | Mayonnaise | 1/2 pt. | 16.7 | 8.6 | 18 | 0.2 | 8 | 2.7 | 0.4 | 0.5 | 0 | 0 |
254 | 254 | Crisco | 1 lb. | 20.3 | 20.1 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 |
255 | 255 | Lard | 1 lb. | 9.8 | 41.7 | 0 | 0.0 | 0 | 0.2 | 0.0 | 0.5 | 5 | 0 |
256 | 256 | Sirloin Steak | 1 lb. | 39.6 | 2.9 | 166 | 0.1 | 34 | 0.2 | 2.1 | 2.9 | 69 | 0 |
257 | 257 | Round Steak | 1 lb. | 36.4 | 2.2 | 214 | 0.1 | 32 | 0.4 | 2.5 | 2.4 | 87 | 0 |
258 | 258 | Rib Roast | 1 lb. | 29.2 | 3.4 | 213 | 0.1 | 33 | 0.0 | 0.0 | 2.0 | 0 | 0 |
259 | 259 | Chuck Roast | 1 lb. | 22.6 | 3.6 | 309 | 0.2 | 46 | 0.4 | 1.0 | 4.0 | 120 | 0 |
260 | 260 | Plate | 1 lb. | 14.6 | 8.5 | 404 | 0.2 | 62 | 0.0 | 0.9 | 0.0 | 0 | 0 |
261 | 261 | Liver (Beef) | 1 lb. | 26.8 | 2.2 | 333 | 0.2 | 139 | 169.2 | 6.4 | 50.8 | 316 | 525 |
262 | 262 | Leg of Lamb | 1 lb. | 27.6 | 3.1 | 245 | 0.1 | 20 | 0.0 | 2.8 | 3.9 | 86 | 0 |
263 | 263 | Lamb Chops (Rib) | 1 lb. | 36.6 | 3.3 | 140 | 0.1 | 15 | 0.0 | 1.7 | 2.7 | 54 | 0 |
264 | 264 | Pork Chops | 1 lb. | 30.7 | 3.5 | 196 | 0.2 | 30 | 0.0 | 17.4 | 2.7 | 60 | 0 |
265 | 265 | Pork Loin Roast | 1 lb. | 24.2 | 4.4 | 249 | 0.3 | 37 | 0.0 | 18.2 | 3.6 | 79 | 0 |
266 | 266 | Bacon | 1 lb. | 25.6 | 10.4 | 152 | 0.2 | 23 | 0.0 | 1.8 | 1.8 | 71 | 0 |
267 | 267 | Ham, smoked | 1 lb. | 27.4 | 6.7 | 212 | 0.2 | 31 | 0.0 | 9.9 | 3.3 | 50 | 0 |
268 | 268 | Salt Pork | 1 lb. | 16.0 | 18.8 | 164 | 0.1 | 26 | 0.0 | 1.4 | 1.8 | 0 | 0 |
269 | 269 | Roasting Chicken | 1 lb. | 30.3 | 1.8 | 184 | 0.1 | 30 | 0.1 | 0.9 | 1.8 | 68 | 46 |
270 | 270 | Veal Cutlets | 1 lb. | 42.3 | 1.7 | 156 | 0.1 | 24 | 0.0 | 1.4 | 2.4 | 57 | 0 |
271 | 271 | Salmon, Pink (can) | 16 oz. | 13.0 | 5.8 | 705 | 6.8 | 45 | 3.5 | 1.0 | 4.9 | 209 | 0 |
272 | 272 | Apples | 1 lb. | 4.4 | 5.8 | 27 | 0.5 | 36 | 7.3 | 3.6 | 2.7 | 5 | 544 |
273 | 273 | Bananas | 1 lb. | 6.1 | 4.9 | 60 | 0.4 | 30 | 17.4 | 2.5 | 3.5 | 28 | 498 |
274 | 274 | Lemons | 1 doz. | 26.0 | 1.0 | 21 | 0.5 | 14 | 0.0 | 0.5 | 0.0 | 4 | 952 |
275 | 275 | Oranges | 1 doz. | 30.9 | 2.2 | 40 | 1.1 | 18 | 11.1 | 3.6 | 1.3 | 10 | 1998 |
276 | 276 | Green Beans | 1 lb. | 7.1 | 2.4 | 138 | 3.7 | 80 | 69.0 | 4.3 | 5.8 | 37 | 862 |
277 | 277 | Cabbage | 1 lb. | 3.7 | 2.6 | 125 | 4.0 | 36 | 7.2 | 9.0 | 4.5 | 26 | 5369 |
278 | 278 | Carrots | 1 bunch | 4.7 | 2.7 | 73 | 2.8 | 43 | 188.5 | 6.1 | 4.3 | 89 | 608 |
279 | 279 | Celery | 1 stalk | 7.3 | 0.9 | 51 | 3.0 | 23 | 0.9 | 1.4 | 1.4 | 9 | 313 |
280 | 280 | Lettuce | 1 head | 8.2 | 0.4 | 27 | 1.1 | 22 | 112.4 | 1.8 | 3.4 | 11 | 449 |
281 | 281 | Onions | 1 lb. | 3.6 | 5.8 | 166 | 3.8 | 59 | 16.6 | 4.7 | 5.9 | 21 | 1184 |
282 | 282 | Potatoes | 15 lb. | 34.0 | 14.3 | 336 | 1.8 | 118 | 6.7 | 29.4 | 7.1 | 198 | 2522 |
283 | 283 | Spinach | 1 lb. | 8.1 | 1.1 | 106 | 0.0 | 138 | 918.4 | 5.7 | 13.8 | 33 | 2755 |
284 | 284 | Sweet Potatoes | 1 lb. | 5.1 | 9.6 | 138 | 2.7 | 54 | 290.7 | 8.4 | 5.4 | 83 | 1912 |
285 | 285 | Peaches (can) | No. 2 1/2 | 16.8 | 3.7 | 20 | 0.4 | 10 | 21.5 | 0.5 | 1.0 | 31 | 196 |
286 | 286 | Pears (can) | No. 2 1/2 | 20.4 | 3.0 | 8 | 0.3 | 8 | 0.8 | 0.8 | 0.8 | 5 | 81 |
287 | 287 | Pineapple (can) | No. 2 1/2 | 21.3 | 2.4 | 16 | 0.4 | 8 | 2.0 | 2.8 | 0.8 | 7 | 399 |
288 | 288 | Asparagus (can) | No. 2 | 27.7 | 0.4 | 33 | 0.3 | 12 | 16.3 | 1.4 | 2.1 | 17 | 272 |
289 | 289 | Green Beans (can) | No. 2 | 10.0 | 1.0 | 54 | 2.0 | 65 | 53.9 | 1.6 | 4.3 | 32 | 431 |
290 | 290 | Pork and Beans (can) | 16 oz. | 7.1 | 7.5 | 364 | 4.0 | 134 | 3.5 | 8.3 | 7.7 | 56 | 0 |
291 | 291 | Corn (can) | No. 2 | 10.4 | 5.2 | 136 | 0.2 | 16 | 12.0 | 1.6 | 2.7 | 42 | 218 |
292 | 292 | Peas (can) | No. 2 | 13.8 | 2.3 | 136 | 0.6 | 45 | 34.9 | 4.9 | 2.5 | 37 | 370 |
293 | 293 | Tomatoes (can) | No. 2 | 8.6 | 1.3 | 63 | 0.7 | 38 | 53.2 | 3.4 | 2.5 | 36 | 1253 |
294 | 294 | Tomato Soup (can) | 10 1/2 oz. | 7.6 | 1.6 | 71 | 0.6 | 43 | 57.9 | 3.5 | 2.4 | 67 | 862 |
295 | 295 | Peaches, Dried | 1 lb. | 15.7 | 8.5 | 87 | 1.7 | 173 | 86.8 | 1.2 | 4.3 | 55 | 57 |
296 | 296 | Prunes, Dried | 1 lb. | 9.0 | 12.8 | 99 | 2.5 | 154 | 85.7 | 3.9 | 4.3 | 65 | 257 |
297 | 297 | Raisins, Dried | 15 oz. | 9.4 | 13.5 | 104 | 2.5 | 136 | 4.5 | 6.3 | 1.4 | 24 | 136 |
298 | 298 | Peas, Dried | 1 lb. | 7.9 | 20.0 | 1367 | 4.2 | 345 | 2.9 | 28.7 | 18.4 | 162 | 0 |
299 | 299 | Lima Beans, Dried | 1 lb. | 8.9 | 17.4 | 1055 | 3.7 | 459 | 5.1 | 26.9 | 38.2 | 93 | 0 |
300 | 300 | Navy Beans, Dried | 1 lb. | 5.9 | 26.9 | 1691 | 11.4 | 792 | 0.0 | 38.4 | 24.6 | 217 | 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 );