In the recipes database, there are 4,197 records by 14 categories (Healthy, Family & kids, Cakes & baking, Cuisines, Dishes, Events, Everyday, Ingredients, Occasions, Quick & easy, Seasonal, Special diets, Vegetarian and More recipe ideas). Each record is comprised of title, rating, chef, prep time, cooking time, recipe details, recipe yield, recipe header description, ingredients and method. It also includes 4,199 recipe images in the 180.77M media sets of this data.
The whole recipes data set consists of 7 tables.
| Name | n3zm_Recipe_bbcgoodfood_com |
|---|---|
| Data | 64.77M (+ 0B) |
| Tables | 7 (+ 0) |
| Columns | 40 (+ 0) |
| Table Rows | 20,780 (+ 0) |
| Media | 37.74M (+ 0B) |
| Files | 799 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 14 | title |
100%
|
| category_2 | 340 | title |
100%
|
| category_1_id |
100%
|
||
| category_1 |
100%
|
||
| category_2_x_recipe | 7,831 | category_2_id |
100%
|
| recipe_id |
100%
|
||
| recipe | 4,197 | title |
100%
|
| rating |
100%
|
||
| chef |
99.12%
|
||
| recipe_header_magazine |
100%
|
||
| prep_time |
94.35%
|
||
| cooking_time |
65.9%
|
||
| recipe_details |
100%
|
||
| recipe_yield |
99.4%
|
||
| recipe_header_description |
100%
|
||
| recipe_header_additional |
71.53%
|
||
| nutrition |
100%
|
||
| ingredients |
100%
|
||
| method |
100%
|
||
| recipe_image | 4,199 | recipe_id |
100%
|
| recipe_x_recipe_image | 4,199 | recipe_id |
100%
|
| recipe_image_id |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
RECIPE_IMAGE_DOWNLOAD
| Size (Bytes) | Files |
|---|---|
| 37.74M | 799 |
