This is a recipes database with 1,859 records by 7 categories (featured, special diets, ingredients, course, cuisine, season & type). Each record is comprised of title, ingredient, method, description, author, prep time, cook time, etc. In the whole recipes database, it also has author images in the 7.15M media set and recipe images in the 8.62M media set. The whole recipes database consists of 10 tables.
database| Name | n3zm_Recipe_simplyrecipes_com |
|---|---|
| Data | 10.73M (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 44 (+ 0) |
| Table Rows | 12,999 (+ 0) |
| Media | 15.77M (+ 0B) |
| Files | 277 (+ 0) |
Data Samples
Database APIs
Media Files
- author_image_download Bytes: 7.15M / Files: 24
- recipe_image_download Bytes: 8.62M / Files: 253
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 7 | title |
100%
|
| category_2 | 131 | title |
100%
|
| category_1_id |
100%
|
||
| category_2_x_recipe | 10,091 | category_2_id |
100%
|
| recipe_id |
100%
|
||
| recipe | 1,859 | title |
100%
|
| ingredient |
98.49%
|
||
| recipe_intronote |
55.46%
|
||
| recipe_method |
99.68%
|
||
| recipe_description |
99.78%
|
||
| author |
99.95%
|
||
| date_time |
6.24%
|
||
| description |
100%
|
||
| photography_credit |
99.78%
|
||
| recipe_name |
100%
|
||
| recipe_prep_time |
76.49%
|
||
| recipe_cook_time |
68.75%
|
||
| yield |
92.2%
|
||
| recipe_x_author_image | 381 | recipe_id |
100%
|
| author_image_id |
100%
|
||
| recipe_x_recipe_image | 253 | 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
AUTHOR_IMAGE_DOWNLOAD
| Size (Bytes) | Files |
|---|---|
| 7.15M | 24 |
RECIPE_IMAGE_DOWNLOAD
| Size (Bytes) | Files |
|---|---|
| 8.62M | 253 |
