This is a car accessories and OEM parts database of 727 records for 551 Mazda cars. All these parts are classified by 20 categories with mark in each record. In each production record, there are part number, price, sale price, category, mark, other name, description, replaces, position and note. In table car, it has year, model, trims and engine. It also comes with 1,542 images of these parts.
Important fields: year, model, trim, engine, part no, price, category, replaces, position, note.
The whole Mazda cars accessories and OEM parts data set has 6 tables.
| Name | n3_lyz_mazdaparts_com |
|---|---|
| Data | 3.30M (+ 128K) |
| Tables | 6 (+ 0) |
| Columns | 33 (+ 0) |
| Table Rows | 8,019 (+ 0) |
| Media | 56.24M (+ 0B) |
| Files | 1,412 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| car | 551 | year |
100%
|
| model |
100%
|
||
| trims |
100%
|
||
| engine |
100%
|
||
| category | 20 | category |
100%
|
| mark |
100%
|
||
| image_slug | 1,542 | production_id |
100%
|
| production | 727 | title |
100%
|
| part_number |
100%
|
||
| price |
100%
|
||
| sale_price |
100%
|
||
| category |
100%
|
||
| mark |
100%
|
||
| other_name |
93.95%
|
||
| description |
88.72%
|
||
| replaces |
38.51%
|
||
| position |
33.7%
|
||
| note |
0%
|
||
| production_x_car | 5,179 | production_id |
100%
|
| car_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
PRODUCTION_IMAGE
| Size (Bytes) | Files |
|---|---|
| 56.24M | 1,412 |
