NBC
USDA Data Import
Upload each CSV from the USDA FoodData Central ZIP in the order shown below.
1. Nutrient2. Food3. FoodNutrient4. FoodPortion5. RetailPrice
Nutrient
nutrient.csv — 477 rows, nutrient definitions
Food
food.csv — filter to foundation_food fdc_ids for best quality
FoodNutrient
food_nutrient.csv — 170k rows, chunked automatically
FoodPortion
food_portion.csv — 10k rows, household portion conversions
RetailPrice
Median retail price dataset (File 20 format accepted) — joins to FoodSearchMaster via canonical_food_id / name+variant / fdc_id. Unknown prices stay null, never 0.
Data is imported in chunks of 200 rows. Large files (FoodNutrient) may take several minutes. Once imported, use the SQL Terminal to query the data.