Name | n3_lyz_lexus_epc_euro |
---|---|
Data | 1.95M (+ 0B) |
Tables | 14 (+ 0) |
Columns | 78 (+ 0) |
Table Rows | 4,426 (+ 0) |
Media | 2.20M (+ 0B) |
Files | 65 (+ 0) |
Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
This is a database of car parts of Lexus for Japan, Europe & US. There are 958 car parts record and 1,734 assembles records.
Each car part record is comprised of part code, part name and std part code. There are assemble, system, seq, system, model, frame and complectation in each of assemble. In the Lexus car parts database, it has 4 tables mostly related with these parts, they are 92 complectation records with engine, production period, body, grade, transm, option, frame and model in each; 52 frame records with model in each; model with 17 records and 200 system records with model, frame & complectation in each. It also comes with 49 assemble image slug records in the 2.03M media set and 233 system image slug records in the 173.99K media set.
The whole Lexus car parts data set totaly has 14 tables.
Tables | Rows | Columns | Non-empty |
---|---|---|---|
assemble | 1,734 | assemble |
100%
|
system_id |
100%
|
||
seq |
100%
|
||
system |
100%
|
||
model |
100%
|
||
frame |
100%
|
||
complectation |
100%
|
||
assemble_c | 11 | assemble_number |
100%
|
assemble_image_slug | 49 | assemble_id |
100%
|
assemble_x_assemble_c | 14 | assemble_id |
100%
|
assemble_c_id |
100%
|
||
assemble_x_part | 958 | assemble_id |
100%
|
part_id |
100%
|
||
complectation | 92 | complectation |
100%
|
frame_id |
100%
|
||
engine |
100%
|
||
production_period |
100%
|
||
body |
39.13%
|
||
grade |
5.43%
|
||
transm |
42.39%
|
||
option |
98.91%
|
||
frame |
100%
|
||
model |
100%
|
||
frame | 52 | frame |
100%
|
model_id |
100%
|
||
model |
100%
|
||
model | 17 | model |
100%
|
part | 958 | part_code |
77.04%
|
part_name |
100%
|
||
std_part_code |
22.96%
|
||
part_detail | 108 | pnc_sub |
91.67%
|
oem_part_no |
100%
|
||
part_id |
100%
|
||
no |
78.7%
|
||
required_per_car |
93.52%
|
||
production_period |
72.22%
|
||
name |
72.22%
|
||
applicability |
0%
|
||
price |
95.37%
|
||
system | 200 | system |
100%
|
complectation_id |
100%
|
||
model |
100%
|
||
frame |
100%
|
||
complectation |
100%
|
||
system_image_slug | 233 | system_id |
100%
|
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2023-06-19 (+ 169 d) | 1.95M (+ 0B) | 14 (+ 0) | 78 (+ 0) | 4,426 (+ 0) | 2.20M (+ 0B) | 65 (+ 0) |
2023-01-01 (+ 95 d) | 1.95M (+ 0B) | 14 (+ 0) | 78 (+ 0) | 4,426 (+ 0) | 2.20M (+ 0B) | 65 (+ 0) |
2022-09-27 (+ 271 d) | 1.95M (+ 0B) | 14 (+ 0) | 78 (+ 0) | 4,426 (+ 0) | 2.20M (+ 0B) | 65 (+ 0) |
2021-12-30 (+ 115 d) | 1.95M (+ 0B) | 14 (+ 0) | 78 (+ 0) | 4,426 (+ 0) | 2.20M (+ 0B) | 65 (+ 0) |
2021-09-05 (+ 150 d) | 1.95M (+ 0B) | 14 (+ 0) | 78 (+ 0) | 4,426 (+ 0) | 2.20M (+ 0B) | 65 (+ 0) |
2021-04-08 (+ 68 d) | 1.95M (+ 128K) | 14 (+ 0) | 78 (+ 0) | 4,426 (+ 0) | 2.20M (+ 0B) | 65 (+ 0) |
2021-01-29 (+ 120 d) | 1.83M (+ 0B) | 14 (+ 0) | 78 (+ 0) | 4,426 (+ 0) | 2.20M (+ 0B) | 65 (+ 0) |
2020-10-01 (+ 38 d) | 1.83M (+ 0B) | 14 (+ 0) | 78 (+ 0) | 4,426 (+ 0) | 2.20M (+ 0B) | 65 (+ 0) |
2020-08-23 | 1.83M | 14 | 78 | 4,426 | 2.20M | 65 |
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.