In this GM car parts & accessories database, there are 2,421 auto parts and 470 accessories of 8 brands.
Each part record is comprised of part name, part number, assemble, seq, list price, price, replace, other name and description and there are sub_group, part name, part number, other names, list price, price and description in each accessory record. There are 7 tables mostly related with these parts and accessories, they are 184 assembles with brand, system, model, year, series in each; 126 fit car records with full name, trim, engine, make, model, year in each; group with 179 records; 7,585 model records with series, brand, year and model in each; 299 series records with brand and series in each; 23 system records with series, brand, year and model in each and year with 2,653 records with brand, series in each from 1984-2019 years. This gm car parts & accessories database also comes with 55 accessory image slug records in the 2.20M media set; 169 assemble image slug records in the 238.69K media set annd 12 part image slug records in the 127.13K media set.
The whole GM auto parts & accessories data set totaly has 20 tables.
| Name | n3_lyz_gmpartsdirect_part |
|---|---|
| Data | 9.17M (+ 80K) |
| Tables | 20 (+ 0) |
| Columns | 109 (+ 0) |
| Table Rows | 16,193 (+ 0) |
| Media | 2.56M (+ 0B) |
| Files | 52 (+ 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_gm/ (By Table)
- http://n3.datasn.io/data/api/v1/n3_lyz/parts_of_gm/ (By Table)
Media Files
- accessory_image Bytes: 2.20M / Files: 35
- assemble_image Bytes: 238.69K / Files: 9
- part_image Bytes: 127.13K / Files: 8
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| accessory | 470 | sub_group_id |
100%
|
| part_number |
96.17%
|
||
| part_name |
96.17%
|
||
| other_names |
94.47%
|
||
| list_price |
5.74%
|
||
| price |
11.7%
|
||
| description |
11.91%
|
||
| accessory_image_slug | 55 | accessory_id |
100%
|
| accessory_x_fit_car | 1,031 | accessory_id |
100%
|
| fit_car_id |
100%
|
||
| assemble | 184 | assemble |
100%
|
| brand |
100%
|
||
| system |
100%
|
||
| model |
100%
|
||
| year |
100%
|
||
| series |
100%
|
||
| assemble_image_slug | 169 | assemble_id |
100%
|
| brand | 8 | brand |
100%
|
| fit_car | 126 | full_name |
100%
|
| trim |
100%
|
||
| engine |
100%
|
||
| make |
100%
|
||
| model |
100%
|
||
| year |
100%
|
||
| group | 179 | group |
100%
|
| model_a_id |
100%
|
||
| model | 7,585 | series |
100%
|
| brand |
100%
|
||
| year |
100%
|
||
| model |
100%
|
||
| year_id |
100%
|
||
| model_a | 385 | series |
100%
|
| brand |
100%
|
||
| year |
100%
|
||
| model |
100%
|
||
| part | 2,421 | part_number |
98.27%
|
| part_name |
98.27%
|
||
| assemble_id |
100%
|
||
| seq |
100%
|
||
| list_price |
98.27%
|
||
| price |
98.27%
|
||
| replace |
0.08%
|
||
| other_name |
0.66%
|
||
| description |
0.62%
|
||
| part_image_slug | 12 | part_id |
100%
|
| part_x_fit_car | 200 | part_id |
100%
|
| fit_car_id |
100%
|
||
| series | 299 | brand |
100%
|
| brand_id |
100%
|
||
| series |
100%
|
||
| sub_group | 393 | sub_group |
100%
|
| group_id |
100%
|
||
| system | 23 | series |
100%
|
| brand |
100%
|
||
| year |
100%
|
||
| model |
100%
|
||
| system |
100%
|
||
| model_id |
100%
|
||
| year | 2,653 | 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 |
|---|---|
| 2.20M | 35 |
ASSEMBLE_IMAGE
| Size (Bytes) | Files |
|---|---|
| 238.69K | 9 |
PART_IMAGE
| Size (Bytes) | Files |
|---|---|
| 127.13K | 8 |
