In the auto parts database, there are 23,048 parts with 21,668 models by 60 makes. Each part is comprised of part number, brand, item location, condition, product fit, weight, dimensions, uom, how sold, qty per application, minimum order quantity, gtin, category, part type, price, engine, notes and etc. There are 2,971 years with make in each of this data. The whole auto parts database totally has 7 tables. See also this auto parts dataset: https://datasn.io/p/245.
| Name | n3zm_Auto_parts_discountautoparts_com |
|---|---|
| Data | 57.88M (+ 0B) |
| Tables | 7 (+ 0) |
| Columns | 47 (+ 0) |
| Table Rows | 292,078 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category | 21,668 | model_id |
100%
|
| model |
100%
|
||
| category_x_parts | 222,663 | category_id |
100%
|
| parts_id |
100%
|
||
| make | 60 | title |
100%
|
| model | 21,668 | title |
100%
|
| year_id |
100%
|
||
| year |
100%
|
||
| parts | 23,048 | title |
100%
|
| part_number |
100%
|
||
| brand |
100%
|
||
| item_location |
99.83%
|
||
| condition |
100%
|
||
| product_fit |
100%
|
||
| weight |
99.99%
|
||
| dimensions |
99.96%
|
||
| uom |
74.91%
|
||
| how_sold |
100%
|
||
| qty_per_application |
100%
|
||
| minimum_order_quantity |
100%
|
||
| gtin |
75.99%
|
||
| category |
99.94%
|
||
| subcategory |
99.94%
|
||
| part_type |
99.94%
|
||
| price |
100%
|
||
| engine |
99.93%
|
||
| notes |
99.93%
|
||
| year | 2,971 | title |
100%
|
| make_id |
100%
|
||
| make |
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
PARTS_IMAGE_DOWNLOAD
| Size (Bytes) | Files |
|---|---|
| 0P | 0 |
