Home Data Automotive Car Parts & Accessories

151,771 Car Parts Database: Parameter, Model, Ref No

Name	n3_chennan_PA_EN_yiparts_com_part
Data	438.19M (+ 0B)
Tables	12 (+ 0)
Columns	61 (+ 0)
Table Rows	3,394,006 (+ 0)
Media	18.97M (+ 0B)
Files	1,901 (+ 0)
Last Commit	2023-06-19 18:36:38 (+ 169 d)

This car parts database contains 151,771 records by 3 main types and further into 21 categories. Each car part is comprised of model, parameter and ref number. These main types are engine part, chassis part and body part. There are 12,892 engines, 23,532 model records with model, engine, cc, kw, cylinder, type, year and engine code in each and 1,222 reference number with number 1, number 2 and supplier in each for these car parts. There are 12 tables in the whole car parts API.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3_chennan/car_part_information_2/ (By Table)

Media Files

car_part_image ^{Bytes: 18.97M / Files: 1,901}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
car_part	151,771	title	100%
		ref_no	95.73%
		model	100%
		parameter	75.49%
car_part_x_engine	1,109,826	car_part_id	100%
car_part_x_engine	1,109,826	engine_id	100%
car_part_x_model	566,930	car_part_id	100%
car_part_x_model	566,930	model_id	100%
car_part_x_ref_no	1,375,670	car_part_id	100%
car_part_x_ref_no	1,375,670	ref_no_id	100%
category_1	3	title	100%
category_2	21	title	100%
category_2	21	category_1_id	100%
category_3	368	title	100%
		category_2_id	100%
		category_2	100%
category_3_x_car_part	151,771	category_3_id	100%
category_3_x_car_part	151,771	car_part_id	100%
engine	12,892	value	100%
model	23,532	title	100%
		model	99.88%
		engine	99.88%
		cc	99.88%
		kw	99.88%
		cylinder	99.33%
		type	92.21%
		year	99.79%
		engine_code	11.43%
ref_no	1,222	changshang	100%
		haoma1	99.92%
		haoma2	58.27%
		supplier	0%

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

car_part_image

Size (Bytes)	Files
18.97M	1,901

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	438.19M (+ 0B)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2023-01-01 (+ 95 d)	438.19M (+ 0B)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2022-09-27 (+ 271 d)	438.19M (+ 0B)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2021-12-30 (+ 115 d)	438.19M (+ 0B)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2021-09-05 (+ 150 d)	438.19M (+ 0B)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2021-04-08 (+ 68 d)	438.19M (+ 0B)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2021-01-29 (+ 120 d)	438.19M (+ 16K)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2020-10-01 (+ 38 d)	438.17M (+ 0B)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2020-08-23 (+ 141 d)	438.17M (+ 0B)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2020-04-04 (+ 196 d)	438.17M (+ 0B)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2019-09-21 (+ 197 d)	438.17M (+ 0B)	12 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 0B)	1,901 (+ 0)
2019-03-07 (+ 43 d)	438.17M (+ 544K)	12 (+ 1)	61 (+ 0)	3,394,006 (+ 0)	18.97M (+ 18.97M)	1,901 (+ 1,901)
2019-01-23 (+ 44 d)	437.64M (+ 0B)	11 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	437.64M (+ 0B)	11 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	437.64M (+ 123.75M)	11 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 29 d)	313.89M (+ 0B)	11 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	313.89M (+ 0B)	11 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	313.89M (+ 0B)	11 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	313.89M (+ 0B)	11 (+ 0)	61 (+ 0)	3,394,006 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	313.89M (+ 286.03M)	11 (+ 6)	61 (+ 35)	3,394,006 (+ 3,242,556)	0B (+ 0B)	0 (+ 0)
2018-05-10	27.86M	5	26	151,450	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

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.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.