Table 5 Database Structure and Description.
From: Carbon footprint and embodied nutrition evaluation of 388 recipes
Category | Field Name | Meaning | Category | Field Name | Meaning |
|---|---|---|---|---|---|
General Information | recipe_id | Unique identifier for each recipe. | Nutrition and Keywords | cliped_count | The number of times the recipe has been clipped or saved. |
recipe_name | The name of the recipe. | search_word | Relevant search terms linked to the recipe. | ||
img_url | URL of the recipe image. | Detailed Ingredient and Nutritional Information | ingredients | Detailed list of ingredients used. | |
author_type | The type of author who provides the recipe. | modified_ingredients | Variations or modifications to the standard ingredients. | ||
author_name | Name of the author of the recipe. | nutrients | Detailed nutritional breakdown. | ||
published_datetime | Date and time the recipe was published. | Environmental Impact Analysis | GHG_production | GHG emissions during production. | |
modified_datetime | Date and time the recipe was modified. | price | Cost associated with the recipe or its components. | ||
recipe_description | Brief description of the recipe. | disposal_amount | Amount of waste produced. | ||
servings | Number of servings the recipe yields. | GHG_disposal | GHG emissions during waste disposal. | ||
cooking_time | Duration required to cook the recipe. | GHG_cooking | GHG emissions during the cooking process. | ||
ingredients_inline | Ingredients listed in a single line. | GHG_total | Total GHG emissions associated with the recipe. | ||
instructions | Step-by-step cooking instructions. | dish | The type or category of the dish. | ||
recipe_cuisine | Type of cuisine the recipe belongs to. | ingredients_category | Category classification of ingredients. | ||
Nutrition and Keywords | nutrition | General nutritional description of the recipe. | category | General category of the recipe. | |
keywords | Keywords associated with the recipe. | cooking_method | Method used for cooking. |
