Food Composition
Food Composition Database
@kaggle.vinitshah0110_food_composition
Food Composition Database
@kaggle.vinitshah0110_food_composition
Food Composition Databases (FCDB), also referred to as Food Composition Tables (FCT), are data that provide the nutritional content of foods. FCDBs are a required input in order to convert foods from food consumption data to nutrient intakes. FCDBs have multiple uses, including for nutrient analysis of foods from dietary consumption surveys, nutrition labeling, and to inform nutrition-sensitive agricultural policies. Exploring this dataset can yield detailed sets of information on the nutritionally important components of foods.
The dataset was obtained from the publicly available information, I do not own any information.
CREATE TABLE food_composition (
"public_food_key" VARCHAR,
"food_profile_id" BIGINT,
"derivation" VARCHAR,
"food_name" VARCHAR,
"food_description" VARCHAR,
"sampling_details" VARCHAR,
"nitrogen_factor" DOUBLE,
"fat_factor" DOUBLE,
"specific_gravity" DOUBLE,
"analysed_portion" VARCHAR,
"unanalysed_portion" VARCHAR,
"classification" BIGINT,
"classification_name" VARCHAR
);Anyone who has the link will be able to view this.