Subway Nutrition

All items on Subway's Menu w/ Nutrition, Micronutrients, and Calorie Information

@kaggle.joebeachcapital_subway_nutrition

Table List

1 table(15.57 KB)

Subwaymenunutrition

@kaggle.joebeachcapital_subway_nutrition.subwaymenunutrition

15.57 KB
186 rows
13 columns

category Category	item Item	calories Calories	total_fat_g Total Fat (g)	saturated_fat_g Saturated Fat (g)	trans_fat_g Trans Fat (g)	cholesterol_mg Cholesterol (mg)	sodium_mg Sodium (mg)	carbs_g Carbs (g)	dietary_fiber_g Dietary Fiber (g)	sugars_g Sugars (g)	protein_g Protein (g)	weight_watchers_pnts Weight Watchers Pnts
Sandwiches	BBQ Chicken	330	4	1		50	860	50	2	16	24	323
Sandwiches	BBQ Rib	580	31	10		60	1260	54	3	18	21	587
Sandwiches	Black Forest Ham	260	4	1.5		30	720	42	5	8	18	251.5
Sandwiches	Buffalo Chicken	360	12	2		55	7710	39	3	5	24	343
Sandwiches	Chicken & Bacon Ranch	530	26	10	0.5	100	1100	41	3	6	36	510
Sandwiches	Chicken Mango Curry	330	7	1.5		50	840	43	3	9	24	316.5
Sandwiches	Chicken Tikka	290	5	1		50	720	39	2	6	23	274
Sandwiches	Chicken Vindaloo	340	9	1		50	880	42	3	7	24	324
Sandwiches	Cold Cut Combo	310	10	2		45	930	38	2	5	16	301
Sandwiches	Genoa Salami	430	23	8		60	1180	40	2	5	18	425


CREATE TABLE subwaymenunutrition (
  "category" VARCHAR,
  "item" VARCHAR,
  "calories" BIGINT,
  "total_fat_g" DOUBLE,
  "saturated_fat_g" DOUBLE,
  "trans_fat_g" DOUBLE,
  "cholesterol_mg" BIGINT,
  "sodium_mg" BIGINT,
  "carbs_g" BIGINT,
  "dietary_fiber_g" BIGINT,
  "sugars_g" BIGINT,
  "protein_g" BIGINT,
  "weight_watchers_pnts" DOUBLE
);