This is a fields-rich truck parts database of 35,099 records by 12 categories (Clearance, Exterior, Fuel Savings, Gift Guide, Interior, Jeep®, Lighting, Performance, Replacement, Suspension, Tools & Garage and Towing). Each auto part is comprised of title, price, manufacturer, quantity sold etc. The whole auto parts & accessories database consists of 6 tables.
| Name | n3a2_stylintrucks_com |
|---|---|
| Data | 78.92M (+ 0B) |
| Tables | 6 (+ 0) |
| Columns | 37 (+ 0) |
| Table Rows | 402,842 (+ 0) |
| Media | 521.70M (+ 0B) |
| Files | 37,139 (+ 0) |
Data Samples
Database APIs
Media Files
- category_2_image Bytes: 32.84M / Files: 2,074
- truck_part_image Bytes: 488.85M / Files: 35,065
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 12 | title |
100%
|
| category_2 | 2,083 | title |
99.95%
|
| category_1_id |
100%
|
||
| price_range |
100%
|
||
| category_2_x_truck_part | 365,648 | category_2_id |
100%
|
| truck_part_id |
100%
|
||
| truck_part | 35,099 | title |
100%
|
| assembly |
1.8%
|
||
| certification |
1.33%
|
||
| color_finish |
26.54%
|
||
| deals |
7.79%
|
||
| light_source |
0.76%
|
||
| location |
47.27%
|
||
| notes |
36.8%
|
||
| replaces_o_e_number |
22.05%
|
||
| replaces_partslink_number |
9.67%
|
||
| type |
8.69%
|
||
| manufacturer |
100%
|
||
| item |
100%
|
||
| price |
100%
|
||
| quantity_sold |
98.7%
|
||
| by |
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
CATEGORY_2_IMAGE
| Size (Bytes) | Files |
|---|---|
| 32.84M | 2,074 |
TRUCK_PART_IMAGE
| Size (Bytes) | Files |
|---|---|
| 488.85M | 35,065 |
