This is a car parts and accessories database with 1,050,518 records from 1,008 brands. Each part record is comprised of description, price, es number, mfg number and mark. In table fit car, there are 307 records with submodel, city name, engine, part, make and model in each. The car parts data also comes with 5,549 car part images in the media set. The whole car parts and accessories data set totally has 16 tables.
| Name | n3_lyz_ecstuning.com |
|---|---|
| Data | 434.61M (+ 26.97M) |
| Tables | 16 (+ 0) |
| Columns | 86 (+ 0) |
| Table Rows | 2,173,912 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| brand | 1,008 | brand |
100%
|
| brand_count |
100%
|
||
| brand_x_category_1 | 3,446 | brand_id |
100%
|
| category_1_id |
100%
|
||
| brand_x_category_1_x_category_2 | 8,177 | brand_x_category_1_id |
100%
|
| category_2_id |
100%
|
||
| brand_x_category_1_x_category_2_x_category_3 | 19,045 | brand_x_category_1_x_category_2_id |
100%
|
| category_3_id |
100%
|
||
| brand_x_category_1_x_category_2_x_category_3_x_cate_4 | 23,265 | brand_x_category_1_x_category_2_x_category_3_id |
100%
|
| cate_4_id |
100%
|
||
| brand_x_category_1_x_category_2_x_category_3_x_part | 24,251 | brand_x_category_1_x_category_2_x_category_3_id |
100%
|
| part_id |
100%
|
||
| brand_x_category_1_x_category_2_x_part | 1,551 | brand_x_category_1_x_category_2_id |
100%
|
| part_id |
100%
|
||
| brand_x_category_1_x_part | 1,028,282 | brand_x_category_1_id |
100%
|
| part_id |
100%
|
||
| cate_4 | 5,291 | category_4 |
100%
|
| category_1 | 20 | category_1 |
100%
|
| category_2 | 360 | category_2 |
100%
|
| category_3 | 2,382 | category_3 |
100%
|
| fit_car | 307 | submodel |
100%
|
| city_name |
0%
|
||
| engine |
100%
|
||
| part_id |
0%
|
||
| make |
100%
|
||
| model |
100%
|
||
| image_slug | 5,549 | part_id |
100%
|
| part | 1,050,518 | description |
0.05%
|
| part |
100%
|
||
| price |
99.98%
|
||
| es_num |
100%
|
||
| mfg_num |
100%
|
||
| mark |
0.08%
|
||
| part_x_fit_car | 460 | part_id |
100%
|
| fit_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
No media sets.
