This is a database of 1,425 auto parts, 76 accessories and 184 assemble records of 13 brands (Buick, Cadillac, Chevrolet, Ford, GMC, Hyundai, Lincoln, Scion, Toyota, Jeep, Chrysler, Dodge and Ram). Each car part is comprised of part number, part name, assemble, seq, list price, sale price, other name, positions and description. There are 7 tables mostly related to these parts, they are 893 fit car records with type and engine in each; 173 group records with model, brand, year and series in each; 385 model records with series, brand, year and model in each; 439 series with brand; 380 sub group; 23 system records with series, brand, year, model in each and 4,384 year records with brand and series in each. In table accessory, there are accessory, description, list price, sale price, number, other name, replace and install time. It also comes with 48 accessory images, 90 assemble images and 76 part images in the car parts & accessories data set.
Important fields: part no, accessory, assemble, desc, price, fit car, type, engine, group, model, year, series, seq, positions, system.
The whole cars accessories and parts data set has 19 tables.
| Name | n3_lyz_oempartsquick_com |
|---|---|
| Data | 3.81M (+ 80K) |
| Tables | 19 (+ 0) |
| Columns | 99 (+ 0) |
| Table Rows | 11,021 (+ 0) |
| Media | 4.73M (+ 0B) |
| Files | 106 (+ 0) |
Data Samples
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
- http://n3.datasn.io/data/api/v1/n3_lyz/accessories_of_buick_fort/ (By Table)
- http://n3.datasn.io/data/api/v1/n3_lyz/parts_of_buick_fort/ (By Table)
Media Files
- accessory_image Bytes: 3.46M / Files: 47
- assemble_image Bytes: 1.18M / Files: 50
- part_image Bytes: 89.21K / Files: 9
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| accessory | 76 | accessory |
100%
|
| description |
65.79%
|
||
| list_price |
35.53%
|
||
| sale_price |
64.47%
|
||
| number |
64.47%
|
||
| other_name |
60.53%
|
||
| replace |
0%
|
||
| install_time |
5.26%
|
||
| accessory_image_slug | 48 | accessory_id |
100%
|
| assemble | 184 | assemble |
100%
|
| system_id |
100%
|
||
| assemble_image_slug | 90 | assemble_id |
100%
|
| brand | 13 | brand |
100%
|
| fit_car | 893 | title |
100%
|
| type |
100%
|
||
| engine |
100%
|
||
| group | 173 | group |
100%
|
| model_id |
100%
|
||
| brand |
100%
|
||
| model |
100%
|
||
| year |
100%
|
||
| series |
100%
|
||
| model | 385 | series |
100%
|
| brand |
100%
|
||
| year |
100%
|
||
| model |
100%
|
||
| year_id |
100%
|
||
| part | 1,425 | part_number |
100%
|
| part_name |
98.46%
|
||
| assemble_id |
100%
|
||
| seq |
97.33%
|
||
| list_price |
5.61%
|
||
| sale_price |
5.61%
|
||
| other_name |
5.26%
|
||
| positions |
3.72%
|
||
| description |
2.95%
|
||
| part_image_slug | 76 | part_id |
100%
|
| part_x_fit_car | 2,200 | part_id |
100%
|
| fit_car_id |
100%
|
||
| series | 439 | series |
100%
|
| brand |
100%
|
||
| brand_id |
100%
|
||
| sub_group | 380 | sub_group |
100%
|
| group_id |
100%
|
||
| sub_group_x_accessory | 232 | sub_group_id |
100%
|
| accessory_id |
100%
|
||
| system | 23 | series |
100%
|
| brand |
100%
|
||
| year |
100%
|
||
| model |
100%
|
||
| system |
100%
|
||
| model_id |
100%
|
||
| year | 4,384 | year |
100%
|
| brand |
100%
|
||
| series |
100%
|
||
| series_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
ACCESSORY_IMAGE
| Size (Bytes) | Files |
|---|---|
| 3.46M | 47 |
ASSEMBLE_IMAGE
| Size (Bytes) | Files |
|---|---|
| 1.18M | 50 |
PART_IMAGE
| Size (Bytes) | Files |
|---|---|
| 89.21K | 9 |
