Home Data Food & Beverages

1,841 Wines Database: Price, SKU, Bottle Options by Categories

Name	n3zm_Wine_totalwine_com
Data	3.55M (+ 0B)
Tables	7 (+ 0)
Columns	38 (+ 0)
Table Rows	4,330 (+ 0)
Media	25.11M (+ 0B)
Files	1,251 (+ 0)
Last Commit	2023-06-19 19:57:45 (+ 169 d)

This is a wine database with 1,841 records by 3 primary categories and 31 sub-categories. Each record consists of title, price, bottle options, SKU, pdp email sec left and description. The whole wines database has 7 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/wine_for_sale_information_4/ (By Table)

Media Files

wine_image ^{Bytes: 25.11M / Files: 1,251}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
category_1	3	title	100%
category_2	31	title	100%
		category_1_id	100%
		category_1	100%
category_2_x_wine	791	category_2_id	100%
category_2_x_wine	791	wine_id	100%
category_3	132	title	100%
		category_2_id	100%
		category_2	100%
category_3_x_wine	1,532	category_3_id	100%
category_3_x_wine	1,532	wine_id	100%
wine	1,841	title	99.95%
		price	100%
		bottle_options	75.88%
		sku	75.88%
		pdp_email_sec_left	27.65%
		description	76.32%

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

wine_image

Size (Bytes)	Files
25.11M	1,251

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2023-01-01 (+ 95 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2022-09-27 (+ 271 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2021-12-30 (+ 115 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2021-09-05 (+ 150 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2021-04-08 (+ 68 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2021-01-29 (+ 120 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2020-10-01 (+ 38 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2020-08-23 (+ 141 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2020-04-04 (+ 196 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2019-09-21 (+ 197 d)	3.55M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 0B)	1,251 (+ 0)
2019-03-07 (+ 43 d)	3.55M (+ 784K)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	25.11M (+ 25.11M)	1,251 (+ 1,251)
2019-01-23 (+ 44 d)	2.78M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	2.78M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	2.78M (+ 160K)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 30 d)	2.62M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	2.62M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	2.62M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	2.62M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	2.62M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	2.62M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-04-11 (+ 38 d)	2.62M (+ 0B)	7 (+ 0)	38 (+ 0)	4,330 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-03-03 (+ 35 d)	2.62M (+ 1.75M)	7 (+ 0)	38 (+ 5)	4,330 (+ 2,261)	0B (+ 0B)	0 (+ 0)
2018-01-27	896K	7	33	2,069	0B	0

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.