1,309 rows sorted by calories

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
70 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
71 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
147 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
148 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
224 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
225 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
301 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
302 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
378 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
379 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
455 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
456 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
532 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
533 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
609 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
610 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
686 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
687 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
763 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
764 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
840 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
841 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
917 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
918 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
994 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
995 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
1071 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
1072 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
1148 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
1149 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
1225 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
1226 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
1302 Coffee 1 lb. 22.4 0.0 0 0.0 0 0.0 4.0 5.1 50 0
1303 Tea 1/4 lb. 17.4 0.0 0 0.0 0 0.0 0.0 2.3 42 0
49 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
57 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
126 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
134 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
203 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
211 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
280 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
288 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
357 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
365 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
434 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
442 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
511 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
519 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
588 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
596 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
665 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
673 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
742 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
750 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
819 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
827 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
896 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
904 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
973 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
981 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
1050 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
1058 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
1127 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
1135 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
1204 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
1212 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
1281 Lettuce 1 head 8.2 0.4 27 1.1 22 112.4 1.8 3.4 11 449
1289 Asparagus (can) No. 2 27.7 0.4 33 0.3 12 16.3 1.4 2.1 17 272
48 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
125 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
202 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
279 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
356 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
433 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
510 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
587 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
664 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
741 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
818 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
895 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
972 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
1049 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
1126 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
1203 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
1280 Celery 1 stalk 7.3 0.9 51 3.0 23 0.9 1.4 1.4 9 313
43 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
58 Green Beans (can) No. 2 10.0 1.0 54 2.0 65 53.9 1.6 4.3 32 431
120 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
135 Green Beans (can) No. 2 10.0 1.0 54 2.0 65 53.9 1.6 4.3 32 431
197 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
212 Green Beans (can) No. 2 10.0 1.0 54 2.0 65 53.9 1.6 4.3 32 431
274 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
289 Green Beans (can) No. 2 10.0 1.0 54 2.0 65 53.9 1.6 4.3 32 431
351 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
366 Green Beans (can) No. 2 10.0 1.0 54 2.0 65 53.9 1.6 4.3 32 431
428 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
443 Green Beans (can) No. 2 10.0 1.0 54 2.0 65 53.9 1.6 4.3 32 431
505 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952
520 Green Beans (can) No. 2 10.0 1.0 54 2.0 65 53.9 1.6 4.3 32 431
582 Lemons 1 doz. 26.0 1.0 21 0.5 14 0.0 0.5 0.0 4 952

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