search

alyssaq / usda-sqlite

USDA food files SR28 to SQLite
116 stars 27 forks source link

Add weight table #1

Closed pierobot closed 7 years ago

pierobot commented 7 years ago

Weight file format (pg 36 in https://github.com/alyssaq/usda-sqlite/blob/master/data/sr28_doc.pdf)

Field name Type Blank Description
NDB_No A 5* N 5-digit Nutrient Databank number
Seq A 2* N Sequence number
Amount N 5.3 N Unit modifier (for example, 1 in “1 cup”).
Msre_Desc A 84 N Description (for example, cup, diced, and 1-inch pieces).
Gm_Wgt N 7.1 N Gram weight.
Num_Data_Pts N 3 Y Number of data points.
Std_Dev N 7.3 Y Standard deviation.
alyssaq commented 7 years ago

Thanks!