Meta Data

DD_USDA_NATL_NUTRIENT_ABBR_22

Title	USDA National Nutrients Abbr Ref, 22
Table Name	DD_USDA_NATL_NUTRIENT_ABBR_22
Region	U.S.
Agency	Department of Agriculture
SubAgency	Agricultural Research Service
Category	LOOKUP
Description	The USDA Nutrient Database for Standard Reference, Release 22 (SR22) is the major source of food composition data in the United States and provides the foundation for most public and private sector databases. This DataSet contains data for all food items, but not all nutrient values--starch, fluoride, betaine, vitamin D2 and D3, added vitamin E, added vitamin B12, alcohol, caffeine, theobromine, phytosterols, individual amino acids, individual fatty acids, or individual sugars are not included.
Tags	food composition, nutrient compostion
Date Released	9/30/2009
Time Period	Current as Date Released
Unique ID	1458
Unit of Analysis	food items
Geographic Coverage	United States of America
Size in MB	2.52
Row Count	7539
Column Count	53
Source	http://www.data.gov
Data Dictionary	http://www.ars.usda.gov/SP2UserFiles/Place/12354500/Data/SR22/sr22_doc.pdf

Data Dictionary

DD_USDA_NATL_NUTRIENT_ABBR_22

Field Order Field Name Original Name Description Field Type Field Size Field Scale
1 NDB_NO NDB_No NDB_No VARCHAR 5
2 SHRT_DESC Shrt_Desc Shrt_Desc VARCHAR 60
3 WATER Water Water VARCHAR 5
4 ENERG_KCAL Energ_Kcal Energ_Kcal VARCHAR 3
5 PROTEIN Protein Protein VARCHAR 5
6 LIPID_TOT Lipid_Tot Lipid_Tot VARCHAR 5
7 ASH Ash Ash VARCHAR 5
8 CARBOHYDRT Carbohydrt Carbohydrt VARCHAR 5
9 FIBER_TD Fiber_TD Fiber_TD VARCHAR 4
10 SUGAR_TOT Sugar_Tot Sugar_Tot VARCHAR 5
11 CALCIUM Calcium Calcium VARCHAR 4
12 IRON Iron Iron VARCHAR 5
13 MAGNESIUM Magnesium Magnesium VARCHAR 3
14 PHOSPHORUS Phosphorus Phosphorus VARCHAR 4
15 POTASSIUM Potassium Potassium VARCHAR 5
16 SODIUM Sodium Sodium VARCHAR 5
17 ZINC Zinc Zinc VARCHAR 6
18 COPPER Copper Copper VARCHAR 6
19 MANGANESE Manganese Manganese VARCHAR 6
20 SELENIUM Selenium Selenium VARCHAR 5
21 VIT_C Vit_C Vit_C VARCHAR 6
22 THIAMIN Thiamin Thiamin VARCHAR 5
23 RIBOFLAVIN Riboflavin Riboflavin VARCHAR 5
24 NIACIN Niacin Niacin VARCHAR 6
25 PANTO_ACID Panto_Acid Panto_Acid VARCHAR 6
26 VIT_B6 Vit_B6 Vit_B6 VARCHAR 5
27 FOLATE_TOT Folate_Tot Folate_Tot VARCHAR 4
28 FOLIC_ACID Folic_Acid Folic_Acid VARCHAR 4
29 FOOD_FOLATE Food_Folate Food_Folate VARCHAR 4
30 FOLATE_DFE Folate_DFE Folate_DFE VARCHAR 4
31 CHOLINE_TOT Choline_Tot Choline_Tot VARCHAR 6
32 VIT_B12 Vit_B12 Vit_B12 VARCHAR 5
33 VIT_A_IU Vit_A_IU Vit_A_IU VARCHAR 6
34 VIT_A_RAE Vit_A_RAE Vit_A_RAE VARCHAR 5
35 RETINOL Retinol Retinol VARCHAR 5
36 ALPHA_CAROT Alpha_Carot Alpha_Carot VARCHAR 5
37 BETA_CAROT Beta_Carot Beta_Carot VARCHAR 5
38 BETA_CRYPT Beta_Crypt Beta_Crypt VARCHAR 4
39 LYCOPENE Lycopene Lycopene VARCHAR 5
40 LUT_ZEA Lut+Zea Lut+Zea VARCHAR 5
41 VIT_E Vit_E Vit_E VARCHAR 5
42 VIT_D_MCG Vit_D_mcg Vit_D_mcg VARCHAR 4
43 VIVIT_D_IU ViVit_D_IU ViVit_D_IU VARCHAR 5
44 VIT_K Vit_K Vit_K VARCHAR 6
45 FA_SAT FA_Sat FA_Sat VARCHAR 6
46 FA_MONO FA_Mono FA_Mono VARCHAR 6
47 FA_POLY FA_Poly FA_Poly VARCHAR 6
48 CHOLESTRL Cholestrl Cholestrl VARCHAR 4
49 GMWT_1 GmWt_1 GmWt_1 VARCHAR 7
50 GMWT_DESC1 GmWt_Desc1 GmWt_Desc1 VARCHAR 80
51 GMWT_2 GmWt_2 GmWt_2 VARCHAR 7
52 GMWT_DESC2 GmWt_Desc2 GmWt_Desc2 VARCHAR 79
53 REFUSE_PCT Refuse_Pct Refuse_Pct VARCHAR 2