There are 2,090,401 products from 181,701 stores. Each product is comprised of description, present price, original price, shop title, store title, feedback number and favorited by number. These stores have location, favorers number, owner introduction, category, sale number, pudate, rating and shop owner in each. These products are mainly categorized into 7 classifications and further into 43 categories. There are related to this item with 1,898,923 records, overviews with 467,072 records and 6,288,171 images of these products. The whole products and stores database totally has 15 tables.
| Name | n3_chennan_oumeitaobao_etsy_com |
|---|---|
| Data | 8.77G (+ 0B) |
| Tables | 15 (+ 0) |
| Columns | 94 (+ 0) |
| Table Rows | 45,695,694 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 7 | title |
100%
|
| category_1_x_product | 49,858 | category_1_id |
100%
|
| product_id |
100%
|
||
| category_2 | 43 | title |
100%
|
| category_1_id |
100%
|
||
| category_1 |
100%
|
||
| category_2_x_product | 444 | category_2_id |
100%
|
| product_id |
100%
|
||
| category_3 | 266 | title |
100%
|
| category_2_id |
100%
|
||
| category_2 |
100%
|
||
| category_4 | 350 | title |
100%
|
| category_3_id |
100%
|
||
| category_3 |
100%
|
||
| category_4_x_product | 2,215,054 | category_4_id |
100%
|
| product_id |
100%
|
||
| image | 6,288,171 | product_id |
100%
|
| overview | 467,072 | value |
100%
|
| product | 2,090,401 | title |
100%
|
| description |
75.9%
|
||
| present_price |
100%
|
||
| original_price |
10.34%
|
||
| shop_title |
100%
|
||
| store_title |
75.9%
|
||
| feedback_num |
38.97%
|
||
| favorited_by_num |
60.44%
|
||
| product_x_overview | 8,707,833 | product_id |
100%
|
| overview_id |
100%
|
||
| product_x_related_to_this_item | 23,005,777 | product_id |
100%
|
| related_to_this_item_id |
100%
|
||
| product_x_store | 789,794 | product_id |
100%
|
| store_id |
100%
|
||
| related_to_this_item | 1,898,923 | title |
100%
|
| store | 181,701 | title |
100%
|
| location |
83.76%
|
||
| favorers_num |
99.94%
|
||
| owner_introduction |
0%
|
||
| category |
90.01%
|
||
| sale_num |
98.28%
|
||
| pudate |
99.94%
|
||
| rating |
92.2%
|
||
| shop_owner |
73.5%
|
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
No media sets.
