Home Data Food & Beverages Recipes

603,704 Recipes Data: introduce, Ingredients, Nutritional, Image by 7 Categories

Name	n3zm_Recipe_sparkpeople_com
Data	1.74G (+ 121.72M)
Tables	8 (+ 0)
Columns	48 (+ 0)
Table Rows	2,123,349 (+ 0)
Media	1.86G (+ 0B)
Files	51,681 (+ 0)
Last Commit	2023-06-19 19:57:45 (+ 169 d)

In the recipes database, there are 603,704 records with title, mark, star, introduce, ratings, minutes to prepare, minutes to cook, number servings, ingredients, direction and nutritional info in each.

All these recipes are grouped into 7 categories and they are category, cuisine, course, occasion, dietary needs, time to make and recent searches. In addtion to this, there are 63,915 reviews with content, star, mark, like, hot and time in each; 51,947 image slug records and 45,786 image sum records for these recipes. In the 1.86G media set, there are 51,681 files of these food images.

The whole recipes database consists of 8 tables.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3zm/recipe_2/ (By Table)

Media Files

food_image ^{Bytes: 1.86G / Files: 51,681}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
category	7	category	100%
image_slug	51,947	recipe_id	100%
image_sum	45,786	total	100%
recipe	603,704	title	99.99%
		mark	100%
		star	10.37%
		introduce	61.44%
		ratings	100%
		minutes_to_prepare	70.26%
		minutes_to_cook	61.54%
		number_servings	98.39%
		ingredients	98.43%
		tip	11.92%
		direction	98.4%
		nutritional_info	98.43%
recipe_x_subcategory	1,357,931	recipe_id	100%
recipe_x_subcategory	1,357,931	subcategory_id	100%
review	63,915	content	95.62%
		recipe_id	100%
		star	100%
		mark	68.77%
		like	41.07%
		hot	41.07%
		time	100%
subcategory	59	subcategory	100%
subcategory	59	category	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

food_image

Size (Bytes)	Files
1.86G	51,681

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	1.74G (+ 121.72M)	8 (+ 0)	48 (+ 0)	2,123,349 (+ 0)	1.86G (+ 0B)	51,681 (+ 0)
2023-01-01 (+ 95 d)	1.62G (+ 239.39M)	8 (- 3)	48 (- 18)	2,123,349 (- 1,843,624)	1.86G (+ 1.85G)	51,681 (+ 51,180)
2022-09-27 (+ 271 d)	1.39G (+ 1.13G)	11 (+ 7)	66 (+ 46)	3,966,973 (+ 2,010,733)	18.04M (+ 130.25K)	501 (+ 1)
2021-12-30 (+ 115 d)	263.52M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	17.92M (+ 0B)	500 (+ 0)
2021-09-05 (+ 150 d)	263.52M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	17.92M (+ 0B)	500 (+ 0)
2021-04-08 (+ 68 d)	263.52M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	17.92M (+ 0B)	500 (+ 0)
2021-01-29 (+ 120 d)	263.52M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	17.92M (+ 0B)	500 (+ 0)
2020-10-01 (+ 38 d)	263.52M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	17.92M (+ 0B)	500 (+ 0)
2020-08-23 (+ 141 d)	263.52M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	17.92M (+ 0B)	500 (+ 0)
2020-04-04 (+ 196 d)	263.52M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	17.92M (+ 0B)	500 (+ 0)
2019-09-21 (+ 197 d)	263.52M (- 0.33M)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	17.92M (- 88.92M)	500 (- 3,802)
2019-03-07 (+ 43 d)	263.84M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	106.84M (+ 0B)	4,302 (+ 0)
2019-01-23 (+ 44 d)	263.84M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	106.84M (+ 7.23M)	4,302 (+ 289)
2018-12-09 (+ 29 d)	263.84M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2018-11-09 (+ 27 d)	263.84M (- 41.62M)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2018-10-13 (+ 30 d)	305.47M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2018-09-13 (+ 34 d)	305.47M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2018-08-09 (+ 27 d)	305.47M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2018-07-12 (+ 31 d)	305.47M (+ 0B)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2018-06-10 (+ 31 d)	305.47M (+ 292.62M)	4 (+ 0)	20 (+ 0)	1,956,240 (+ 1,904,992)	99.60M (+ 0B)	4,013 (+ 0)
2018-05-10 (+ 28 d)	12.84M (+ 0B)	4 (+ 0)	20 (+ 0)	51,248 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2018-04-11 (+ 38 d)	12.84M (+ 0B)	4 (+ 0)	20 (+ 0)	51,248 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2018-03-03 (+ 35 d)	12.84M (+ 0B)	4 (+ 0)	20 (+ 0)	51,248 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2018-01-27 (+ 29 d)	12.84M (+ 0B)	4 (+ 0)	20 (+ 0)	51,248 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2017-12-29 (+ 20 d)	12.84M (+ 0B)	4 (+ 0)	20 (+ 0)	51,248 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2017-12-08 (+ 9 d)	12.84M (+ 0B)	4 (+ 0)	20 (+ 0)	51,248 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2017-11-28 (+ 19 d)	12.84M (+ 0B)	4 (+ 0)	20 (+ 0)	51,248 (+ 0)	99.60M (+ 0B)	4,013 (+ 0)
2017-11-09	12.84M	4	20	51,248	99.60M	4,013

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.