North American Nutrient

Module: north-american-diet

Module Contents

  1. north-american-nutrient


1CENTER_NOnumber (2,0)Required:false
Center identification number.
Allowable Values
11Sinai Health Systems (formerly Cancer Care Ontario)
12Cedars-Sinai & Cleveland Clinic (formerly USC Consortium)
14University of Hawaii Cancer Center
15Mayo Clinic
16Fred Hutchinson Cancer Center
17UCSF/University of California at San Franscisco (formerly CPIC, originally NCCC)


2PERSON_ID (*PK)string (12)Required:false
Number that uniquely identifies an individual. *PERSON_ID is the primary key for the table.

3CALORIES_IN_FOODnumber (13,3)Required:false
Calories (cal)

4PROTEIN_IN_FOODnumber (13,3)Required:false
Protein (g)

5TOTAL_FAT_IN_FOODnumber (13,3)Required:false
Total Fat (g)

6SATUR_FAT_IN_FOODnumber (13,3)Required:false
Saturated Fat (g)

7MONOUNSAT_FAT_IN_FOODnumber (13,3)Required:false
Monounsaturated Fat (g)

8POLYUNSAT_FAT_IN_FOODnumber (13,3)Required:false
Polyunsaturated Fat (g)

9CHOLESTEROL_IN_FOODnumber (13,3)Required:false
Cholesterol (mg)

10CARBOHYDRATE_IN_FOODnumber (13,3)Required:false
Carbohydrate (g)

11STARCH_IN_FOODnumber (13,3)Required:false
Starch (g)

12DIET_FIBER_IN_FOODnumber (13,3)Required:false
Total Dietary Fiber (g)

13INSOL_NONSTARCH_POLYSAC_IN_FOODnumber (13,3)Required:false
Insoluble Nonstarch Polysaccharids (g)

14SOL_NONSTARCH_POLYSAC_IN_FOODnumber (13,3)Required:false
Soluble Nonstarch Polysaccharides (g)

15CALCIUM_IN_FOODnumber (13,3)Required:false
Calcium (mg)

16PHOSPHORUS_IN_FOODnumber (13,3)Required:false
Phosphorus (mg)

17MAGNESIUM_IN_FOODnumber (13,3)Required:false
Magnesium (mg)

18IRON_IN_FOODnumber (13,3)Required:false
Iron (mg)

19SODIUM_IN_FOODnumber (13,3)Required:false
Sodium (mg)

20POTASSIUM_IN_FOODnumber (13,3)Required:false
Potassium (mg)

21ZINC_IN_FOODnumber (13,3)Required:false
Zinc (mg)

22COPPER_IN_FOODnumber (13,3)Required:false
Copper (mg)

23SELENIUM_IN_FOODnumber (13,3)Required:false
Selenium (mcg)

24MANGANESE_IN_FOODnumber (13,3)Required:false
Manganese (mg)

25IODINE_IN_FOODnumber (13,3)Required:false
Iodine (mcg)

26VITA_A_IN_FOODnumber (13,3)Required:false
Vitamin A (mcg RAE)

27ALPHA_CAROTENE_IN_FOODnumber (13,3)Required:false
Alpha-Carotene (mcg)

28BETA_CAROTENE_IN_FOODnumber (13,3)Required:false
Beta-Carotene (mcg)

29BETA_CRYPTOXANTHIN_IN_FOODnumber (13,3)Required:false
Beta-Cryptoxanthin (mcg)

30LYCOPENE_IN_FOODnumber (13,3)Required:false
Lycopene (mcg)

31LUTEIN_IN_FOODnumber (13,3)Required:false
Lutein (mcg)

32THIAMIN_IN_FOODnumber (13,3)Required:false
Thiamin (mg)

33RIBOFLAVIN_IN_FOODnumber (13,3)Required:false
Riboflavin (mg)

34NIACIN_IN_FOODnumber (13,3)Required:false
Niacin (mg)

35PANTOTHENIC_ACID_IN_FOODnumber (13,3)Required:false
Pantothenic Acid (mg)

36VITA_B6_IN_FOODnumber (13,3)Required:false
Vitamin B-6 (mg)

37FOLATE_PREFORT_IN_FOODnumber (13,3)Required:false
Folate, pre-fortification (mcg)

38FOLATE_POSTFORT_IN_FOODnumber (13,3)Required:false
Folate, post-fortification (mcg DFE)

39VITA_B_12_IN_FOODnumber (13,3)Required:false
Vitamin B-12 (mcg)

40VITA_C_IN_FOODnumber (13,3)Required:false
Vitamin C (mg)

41VITA_D_IN_FOODnumber (13,3)Required:false
Vitamin D (IU)

42ALPHA_TOCOPHEROL_IN_FOODnumber (13,3)Required:false
Vitamin E (IU)

43NITRATE_IN_FOODnumber (13,3)Required:false
Nitrate (mg)

44NITRITE_IN_FOODnumber (13,3)Required:false
Nitrite (mg)

45NITROSAMINE_IN_FOODnumber (13,3)Required:false
Nitrosamine (mcg)

46CAFFEINE_IN_FOODnumber (13,3)Required:false
Caffeine (mg)

47ALCOHOL_IN_FOODnumber (13,3)Required:false
Alcohol (g)

48GENISTEIN_IN_FOODnumber (13,3)Required:false
Genistein (mg)

49DAIDZEIN_IN_FOODnumber (13,3)Required:false
Daidzein (mg)

50GLYCITEIN_IN_FOODnumber (13,3)Required:false
Glycitein (mg)

51T_ISOFLA_IN_FOODnumber (13,3)Required:false
Total Isoflavonoids (mg)

52CAL_PRCT_FR_PROTEINnumber (13,3)Required:false
% of Calories from Protein

53CAL_PRCT_FR_TOTAL_FATnumber (13,3)Required:false
% of Calories from Total Fat

54CAL_PRCT_FR_SATU_FATnumber (13,3)Required:false
% of Calories from Saturated Fat

55CAL_PRCT_FR_CARBOHYDnumber (13,3)Required:false
% of Calories from Carbohydrates

56CAL_PRCT_FR_ALCOHOLnumber (13,3)Required:false
% of Calories from Alcohol

57CALCIUM_IN_SUPPnumber (13,3)Required:false
Calcium from Supplements (mg)

58PHOSPHORUS_IN_SUPPnumber (13,3)Required:false
Phosphorus from Supplements (mg)

59MAGNESIUM_IN_SUPPnumber (13,3)Required:false
Magnesium from Supplements (mg)

60IRON_IN_SUPPnumber (13,3)Required:false
Iron from Supplements (mg)

61POTASSIUM_IN_SUPPnumber (13,3)Required:false
Potassium from Supplements (mg)

62ZINC_IN_SUPPnumber (13,3)Required:false
Zinc from Supplements (mg)

63COPPER_IN_SUPPnumber (13,3)Required:false
Copper from Supplements (mg)

64MANGANESE_IN_SUPPnumber (13,3)Required:false
Manganese from Supplements (mg)

65SELENIUM_IN_SUPPnumber (13,3)Required:false
Selenium from Supplements (mcg)

66IODINE_IN_SUPPnumber (13,3)Required:false
Iodine from Supplements (mg)

67VITA_A_IN_SUPPnumber (13,3)Required:false
Vitamin A from Supplements (mcg RAE)

68BETA_CAROTENE_IN_SUPPnumber (13,3)Required:false
Beta-Carotene from Supplements (mcg)

69THIAMIN_IN_SUPPnumber (13,3)Required:false
Thiamin from Supplements (mg)

70RIBOFLAVIN_IN_SUPPnumber (13,3)Required:false
Riboflavin from Supplements (mg)

71NIACIN_IN_SUPPnumber (13,3)Required:false
Niacin from Supplements (mg)

72PANTOTHENIC_ACID_IN_SUPPnumber (13,3)Required:false
Pantothenic Acid from Supplements (mg)

73VITA_B6_IN_SUPPnumber (13,3)Required:false
Vitamin B-6 from Supplements (mg)

74FOLIC_ACID_IN_SUPPnumber (13,3)Required:false
Folic Acid from Supplements (mcg DFE)

75VITA_B12_IN_SUPPnumber (13,3)Required:false
Vitamin B-12 from Supplements (mcg)

76ASCORBIC_ACID_IN_SUPPnumber (13,3)Required:false
Ascorbic Acid from Supplements (mg)

77VITA_D_IN_SUPPnumber (13,3)Required:false
Vitamin D from Supplements (IU)

78VITA_E_IN_SUPPnumber (13,3)Required:false
Vitamin E from Supplements (mg alpha tocopherol)

79CALCIUM_IN_SUPPL_GT2YRnumber (13,3)Required:false
Calcium from Supplements (mg)

80IRON_IN_SUPPL_GT2YRnumber (13,3)Required:false
Iron from Supplements (mg)

81ZINC_IN_SUPPL_GT2YRnumber (13,3)Required:false
Zinc from Supplements (mg)

82SELENIUM_IN_SUPPL_GT2YRnumber (13,3)Required:false
Selenium from Supplements (mcg)

83VITAMIN_A_IN_SUPPL_GT2YRnumber (13,3)Required:false
Vitamin A from Supplements (IU)

84BETA_CAROTENE_IN_SUPPL_GT2YRnumber (13,3)Required:false
Beta-Carotene from Supplements (mcg)

85THIAMIN_IN_SUPPL_GT2YRnumber (13,3)Required:false
Thiamin from Supplements (mg)

86RIBOFLAVIN_IN_SUPPL_GT2YRnumber (13,3)Required:false
Riboflavin from Supplements (mg)

87NIACIN_IN_SUPPL_GT2YRnumber (13,3)Required:false
Niacin from Supplements (mg)

88VITAMIN_B6_IN_SUPPL_GT2YRnumber (13,3)Required:false
Vitamin B-6 (Pyridoxine) from Supplements (mg)

89FOLIC_ACID_IN_SUPPL_GT2YRnumber (13,3)Required:false
Folic Acid from Supplements (mcg DFE)

90VITAMIN_B12_IN_SUPPL_GT2YRnumber (13,3)Required:false
Vitamin B-12 from Supplements (mcg)

91VITAMIN_C_IN_SUPPL_GT2YRnumber (13,3)Required:false
Vitamin C from Supplements (mg)

92VITAMIN_E_IN_SUPPL_GT2YRnumber (13,3)Required:false
Vitamin E from Supplements (mg alpha tocopherol)

93FOOD_GROUP_BEEFnumber (13,3)Required:false
Average daily intake of beef about two years before the time of interview, measured in grams per day

94FOOD_GROUP_PORKnumber (13,3)Required:false
Average daily intake of pork about two years before the time of interview, measured in grams per day

95FOOD_GROUP_REDMEAT_NONPROCESSEDnumber (13,3)Required:false
Average daily intake of red meat (excluding processed meat) about two years before the time of interview, measured in grams per day

96FOOD_GROUP_PROCESSED_REDMEATnumber (13,3)Required:false
Average daily intake of processed red meat about two years before the time of interview, measured in grams per day

97FOOD_GROUP_POULTRYnumber (13,3)Required:false
Average daily intake of fresh poultry about two years before the time of interview, measured in grams per day

98FOOD_GROUP_FISH_NONSHELLFISHnumber (13,3)Required:false
Average daily intake of fish (excluding shellfish) about two years before the time of interview, measured in grams per day

99FOOD_GROUP_SHELLFISHnumber (13,3)Required:false
Average daily intake of shellfish about two years before the time of interview, measured in grams per day

100FOOD_GROUP_LEGUMESnumber (13,3)Required:false
Average daily intake of all legumes about two years before the time of interview, measured in grams per day

101FOOD_GROUP_TOFUnumber (13,3)Required:false
Average daily intake of tofu about two years before the time of interview, measured in grams per day

102FOOD_GROUP_TOT_VEGETABLESnumber (13,3)Required:false
Average daily intake of vegetables (total) about two years before the time of interview, measured in grams per day

103FOOD_GROUP_LT_GRN_VEGnumber (13,3)Required:false
Average daily intake of light green vegetables about two years before the time of interview, measured in grams per day

104FOOD_GROUP_DARK_GRN_VEGnumber (13,3)Required:false
Average daily intake of dark green vegetables about two years before the time of interview, measured in grams per day

105FOOD_GROUP_YELLOW_ORANGE_VEGnumber (13,3)Required:false
Average daily intake of yellow-orange vegetables about two years before the time of interview, measured in grams per day

106FOOD_GROUP_CRUCIFEROUS_VEGnumber (13,3)Required:false
Average daily intake of cruciferous vegetables about two years before the time of interview, measured in grams per day

107FOOD_GROUP_TOMATO_INC_JUICEnumber (13,3)Required:false
Average daily intake of tomato products (including juice) about two years before the time of interview, measured in grams per day

108FOOD_GROUP_CARROTSnumber (13,3)Required:false
Average daily intake of carrots about two years before the time of interview, measured in grams per day

109FOOD_GROUP_BROCCOLInumber (13,3)Required:false
Average daily intake of broccoli about two years before the time of interview, measured in grams per day

110FOOD_GROUP_RICEnumber (13,3)Required:false
Average daily intake of rice about two years before the time of interview, measured in grams per day

111FOOD_GROUP_POTATOES_TUBERSnumber (13,3)Required:false
Average daily intake of potatoes and tubers about two years before the time of interview, measured in grams per day

112FOOD_GROUP_ALL_FRUITS_INC_JUICEnumber (13,3)Required:false
Average daily intake of all fruits (including juice) about two years before the time of interview, measured in grams per day

113FOOD_GROUP_FRUIT_JUICE_ONLYnumber (13,3)Required:false
Average daily intake of fruit juice alone about two years before the time of interview, measured in grams per day

114FOOD_GROUP_CITRUS_FRUITSnumber (13,3)Required:false
Average daily intake of citrus fruits about two years before the time of interview, measured in grams per day

115FOOD_GROUP_YELLOW_ORANGE_FRUITSnumber (13,3)Required:false
Average daily intake of yellow-orange fruits about two years before the time of interview, measured in grams per day

116FOOD_GROUP_ALL_DAIRYnumber (13,3)Required:false
Average daily intake of all dairy products about two years before the time of interview, measured in grams per day

117FOOD_GROUP_BREAKFAST_CEREALSnumber (13,3)Required:false
Average daily intake of breakfast cereal about two years before the time of interview, measured in grams per day

118FOOD_GROUP_BREADnumber (13,3)Required:false
Average daily intake of bread about two years before the time of interview, measured in grams per day

119FOOD_GROUP_PASTAnumber (13,3)Required:false
Average daily intake of pasta about two years before the time of interview, measured in grams per day

120FOOD_GROUP_EGGSnumber (13,3)Required:false
Average daily intake of eggs about two years before the time of interview, measured in grams per day

121FOOD_GROUP_MILKnumber (13,3)Required:false
Average daily intake of milk about two years before the time of interview, measured in grams per day

122FOOD_GROUP_BEERnumber (13,3)Required:false
Average daily intake of beer about two years before the time of interview, measured in grams per day

123FOOD_GROUP_WINEnumber (13,3)Required:false
Average daily intake of wine about two years before the time of interview, measured in grams per day

124FOOD_GROUP_NUTSnumber (13,3)Required:false
Average daily intake of nuts (excluding coconuts) about two years before the time of interview, measured in grams per day

125FOOD_GROUP_ONIONnumber (13,3)Required:false
Average daily intake of onion about two years before the time of interview, measured in grams per day

126FOOD_GROUP_PROCESSED_POULTRYnumber (13,3)Required:false
Average daily intake of processed poultry about two years before the time of interview, measured in grams per day

127FOOD_GROUP_VEG_EXC_LEGUMESnumber (13,3)Required:false
Average daily intake of vegetables (excluding legumes) about two years before the time of interview, measured in grams per day

128FOOD_GROUP_SOY_TOFUnumber (13,3)Required:false
Average daily intake of soy from tofu about two years before the time of interview, measured in grams per day

129FOOD_GROUP_SOY_TOFU_MISOnumber (13,3)Required:false
Average daily intake of soy from tofu or miso about two years before the time of interview, measured in grams per day

130FOOD_GROUP_SOY_TOFU_MISO_VEGMEATnumber (13,3)Required:false
Average daily intake of soy from tofu, miso, or vegetarian meat products about two years before the time of interview, measured in grams per day

131TOTAL_GRAINnumber (11,3)Required:false
Average daily intake of total grain about two years before the time of interview, measured in food pyramid servings per day

132WHOLE_GRAINnumber (11,3)Required:false
Average daily intake of whole grain about two years before the time of interview, measured in food pyramid servings per day

133NONWHOLE_GRAINnumber (11,3)Required:false
Average daily intake of non-whole grain about two years before the time of interview, measured in food pyramid servings per day

134TOTAL_VEGETABLESnumber (11,3)Required:false
Average daily intake of total vegetables about two years before the time of interview, measured in food pyramid servings per day

135DARK_GRN_LEAFY_VEGnumber (11,3)Required:false
Average daily intake of dark green leafy vegetables about two years before the time of interview, measured in food pyramid servings per day

136DEEP_YELLOW_VEGnumber (11,3)Required:false
Average daily intake of deep yellow vegetables about two years before the time of interview, measured in food pyramid servings per day

137WHITE_POTATOESnumber (11,3)Required:false
Average daily intake of white potatoes about two years before the time of interview, measured in food pyramid servings per day

138OTH_STARCH_VEGnumber (11,3)Required:false
Average daily intake of other starch vegetables about two years before the time of interview, measured in food pyramid servings per day

139TOMATOESnumber (11,3)Required:false
Average daily intake of tomatoes about two years before the time of interview, measured in food pyramid servings per day

140OTH_VEGETABLESnumber (11,3)Required:false
Average daily intake of other vegetables about two years before the time of interview, measured in food pyramid servings per day

141TOTAL_FRUITnumber (11,3)Required:false
Average daily intake of total fruit about two years before the time of interview, measured in food pyramid servings per day

142CITRUS_FRUITSnumber (11,3)Required:false
Average daily intake of citrus fruits about two years before the time of interview, measured in food pyramid servings per day

143OTH_FRUITSnumber (11,3)Required:false
Average daily intake of other fruits about two years before the time of interview, measured in food pyramid servings per day

144TOTAL_DAIRYnumber (11,3)Required:false
Average daily intake of total dairy about two years before the time of interview, measured in food pyramid servings per day

145MILKnumber (11,3)Required:false
Average daily intake of milk about two years before the time of interview, measured in food pyramid servings per day

146YOGURTnumber (11,3)Required:false
Average daily intake of yogurt about two years before the time of interview, measured in food pyramid servings per day

147CHEESEnumber (11,3)Required:false
Average daily intake of cheese about two years before the time of interview, measured in food pyramid servings per day

148MEAT_POULTRY_FISHnumber (11,3)Required:false
Average daily intake of meat, poultry and fish about two years before the time of interview, measured in food pyramid servings per day

149MEAT_ONLYnumber (11,3)Required:false
Average daily intake of meat (beef, pork, veal, lamb, or game) about two years before the time of interview, measured in food pyramid servings per day

150ORGAN_MEATSnumber (11,3)Required:false
Average daily intake of organs from meat about two years before the time of interview, measured in food pyramid servings per day

151SAUSAGE_LUNCHMEATnumber (11,3)Required:false
Average daily intake of frankfurters, sausage, or luncheon meat about two years before the time of interview, measured in food pyramid servings per day

152POULTRY_ONLYnumber (11,3)Required:false
Average daily intake of poultry (turkey, chicken, other poultry) about two years before the time of interview, measured in food pyramid servings per day

153FISH_ONLYnumber (11,3)Required:false
Average daily intake of fish (fish, shellfish, or other) about two years before the time of interview, measured in food pyramid servings per day

154EGGSnumber (11,3)Required:false
Average daily intake of eggs about two years before the time of interview, measured in food pyramid servings per day

155SOYBEANnumber (11,3)Required:false
Average daily intake of soybean producgts (tofu, miso, vegetarian meat, etc) about two years before the time of interview, measured in food pyramid servings per day

156NUTS_SEEDSnumber (11,3)Required:false
Average daily intake of nuts and seeds about two years before the time of interview, measured in food pyramid servings per day

157DRY_BEANS_PEASnumber (11,3)Required:false
Average daily intake of cooked dry beans and peas about two years before the time of interview, measured in food pyramid servings per day

158DISCRETIONARY_FATnumber (11,3)Required:false
Average daily intake of discretionary fat about two years before the time of interview, measured in grams per day

159ADDED_SUGARSnumber (11,3)Required:false
Average daily intake of added sugars about two years before the time of interview, measured in teaspoons per day

160ALCOHOLnumber (11,3)Required:false
Average daily intake of alcohol about two years before the time of interview, measured in drinks per day

161DAILY_MELQXnumber (15,3)Required:false
2-amino-3, 8-dimethylimidazo[4,5-f]quinoxaline

162DAILY_PHIPnumber (15,3)Required:false
2-amino-1-methy1-6-phenylimidazo[4,5-b]pyridine

163DAILY_DIMELQXnumber (15,3)Required:false
2-amino-3,4,8-trimethylimidazo[4,5-f]quinoxaline

164DAILY_HAAnumber (15,3)Required:false
Heterocyclic Amine