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)
12University of Southern California Consortium (USCC)
14University of Hawaii Cancer Center
15Mayo Clinic
16Fred Hutch, Seattle
17University of California at San Francisco (UCSF) (formerly CPIC, originally Northern California (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