Name | n3_lyz_gmpartsdirect_part |
---|---|
Data | 9.17M (+ 0B) |
Tables | 20 (+ 0) |
Columns | 109 (+ 0) |
Table Rows | 16,193 (+ 0) |
Media | 2.56M (+ 0B) |
Files | 52 (+ 0) |
Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
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.
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%
|
Size (Bytes) | Files |
---|---|
2.20M | 35 |
Size (Bytes) | Files |
---|---|
238.69K | 9 |
Size (Bytes) | Files |
---|---|
127.13K | 8 |
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2023-06-19 (+ 169 d) | 9.17M (+ 0B) | 20 (+ 0) | 109 (+ 0) | 16,193 (+ 0) | 2.56M (+ 0B) | 52 (+ 0) |
2023-01-01 (+ 95 d) | 9.17M (+ 0B) | 20 (+ 0) | 109 (+ 0) | 16,193 (+ 0) | 2.56M (+ 0B) | 52 (+ 0) |
2022-09-27 (+ 271 d) | 9.17M (+ 0B) | 20 (+ 0) | 109 (+ 0) | 16,193 (+ 0) | 2.56M (+ 0B) | 52 (+ 0) |
2021-12-30 (+ 115 d) | 9.17M (+ 0B) | 20 (+ 0) | 109 (+ 0) | 16,193 (+ 0) | 2.56M (+ 0B) | 52 (+ 0) |
2021-09-05 (+ 150 d) | 9.17M (+ 0B) | 20 (+ 0) | 109 (+ 0) | 16,193 (+ 0) | 2.56M (+ 0B) | 52 (+ 0) |
2021-04-08 (+ 68 d) | 9.17M (+ 80K) | 20 (+ 0) | 109 (+ 0) | 16,193 (+ 0) | 2.56M (+ 0B) | 52 (+ 0) |
2021-01-29 (+ 120 d) | 9.09M (+ 0B) | 20 (+ 0) | 109 (+ 0) | 16,193 (+ 0) | 2.56M (+ 0B) | 52 (+ 0) |
2020-10-01 (+ 38 d) | 9.09M (+ 0B) | 20 (+ 0) | 109 (+ 0) | 16,193 (+ 0) | 2.56M (+ 0B) | 52 (+ 0) |
2020-08-23 | 9.09M | 20 | 109 | 16,193 | 2.56M | 52 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.