1,309 rows sorted by unit

View and edit SQL

Suggested facets: unit, 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
47 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
124 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
201 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
278 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
355 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
432 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
509 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
586 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
663 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
740 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
817 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
894 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
971 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
1048 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
1125 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
1202 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
1279 Carrots 1 bunch 4.7 2.7 73 2.8 43 188.5 6.1 4.3 89 608
18 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
43 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
44 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
95 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
120 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
121 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
172 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
197 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
198 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
249 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
274 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
275 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
326 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
351 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
352 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
403 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
428 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
429 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
480 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
505 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
506 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
557 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
582 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
583 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
634 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
659 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
660 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
711 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
736 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
737 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
788 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
813 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
814 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
865 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
890 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
891 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
942 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
967 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
968 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
1019 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
1044 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
1045 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
1096 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
1121 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
1122 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
1173 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
1198 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
1199 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
1250 Eggs 1 doz. 32.6 2.9 238 1.0 52 18.6 2.8 6.5 1 0
1275 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
1276 Oranges 1 doz. 30.9 2.2 40 1.1 18 11.1 3.6 1.3 10 1998
49 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
126 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
203 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
280 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
357 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
434 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
511 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
588 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
665 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
742 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
819 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
896 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
973 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
1050 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
1127 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
1204 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
1281 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
2 Macaroni 1 lb. 14.1 11.6 418 0.7 54 0.0 3.2 1.9 68 0
5 Corn Meal 1 lb. 4.6 36.0 897 1.7 99 30.9 17.4 7.9 106 0
7 Rice 1 lb. 7.5 21.2 460 0.6 41 0.0 2.0 4.8 60 0
8 Rolled Oats 1 lb. 7.1 25.3 907 5.1 341 0.0 37.1 8.9 64 0
9 White Bread (Enriched) 1 lb. 7.9 15.0 488 2.5 115 0.0 13.8 8.5 126 0
10 Whole Wheat Bread 1 lb. 9.1 12.2 484 2.7 125 0.0 13.9 6.4 160 0
11 Rye Bread 1 lb. 9.1 12.4 439 1.1 82 0.0 9.9 3.0 66 0
12 Pound Cake 1 lb. 24.8 8.0 130 0.4 31 18.9 2.8 3.0 17 0
13 Soda Crackers 1 lb. 15.1 12.5 288 0.5 50 0.0 0.0 0.0 0 0
16 Butter 1 lb. 30.8 10.8 9 0.2 3 44.2 0.0 0.2 2 0
17 Oleomargarine 1 lb. 16.1 20.6 17 0.6 6 55.8 0.2 0.0 0 0
19 Cheese (Cheddar) 1 lb. 24.2 7.4 448 16.4 19 28.1 0.8 10.3 4 0
21 Peanut Butter 1 lb. 17.9 15.7 661 1.0 48 0.0 9.6 8.1 471 0
23 Crisco 1 lb. 20.3 20.1 0 0.0 0 0.0 0.0 0.0 0 0
24 Lard 1 lb. 9.8 41.7 0 0.0 0 0.2 0.0 0.5 5 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);