Home Data Automotive Motorcycles Motorcycle Parts & Accessories

11,754,808 OEM Parts of Motorcycles API

Name	n3_lyz_motorcyclemall_parts.com
Data	6.76G (+ 3.21G)
Tables	23 (+ 10)
Columns	114 (+ 58)
Table Rows	45,772,502 (+ 28,824,404)
Media	8.59G (+ 4.48G)
Files	1,814,422 (+ 983,302)
Last Commit	2023-06-19 18:12:05 (+ 169 d)

This motorcycle OEM(original equipment manufacture) parts database contains 1,380,339 motor parts by 9 well-known makes (Can-Am / Honda / KTM / Kawasaki / Victory / Suzuki / Sea-Doo / Polaris / Yamaha OEM parts). In table part, each record is comprised of part, part idt, price, quantity and assembly id. The whole motor parts data set has 23 tables.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table
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_lyz/parts_of_powersports_vehicle_and_motorcycle_and_trailers_and_generator_set_and_watercraft_3/ (By Table)

Media Files

assemble_image ^{Bytes: 4.48G / Files: 983,302}
assembly_image ^{Bytes: 3.81G / Files: 771,797}
assembly_image_to_make ^{Bytes: 307.23M / Files: 59,323}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
assemble	1,175,873	assemble	100%
		model_id	100%
		model	100%
		brand	100%
		type	100%
		year	99.59%
assemble_x_part	25,068,477	assemble_id	100%
assemble_x_part	25,068,477	part_id	100%
assembly	842,907	assembly	100%
assembly	842,907	category_model_id	100%
assembly_to_make	59,804	assembly	100%
assembly_to_make	59,804	category_model_to_make_id	100%
assembly_to_make_x_part	1,443,260	assembly_to_make_id	100%
assembly_to_make_x_part	1,443,260	part_id	100%
assembly_x_part	13,109,753	assembly_id	100%
assembly_x_part	13,109,753	part_id	100%
brand	9	brand	100%
category_make	9	title	100%
category_model	16,831	model	100%
category_model	16,831	category_year_id	100%
category_model_to_make	1,408	model	100%
category_model_to_make	1,408	category_year_to_make_id	100%
category_type	36	type	100%
category_type	36	category_make_id	100%
category_year	827	year	99.64%
category_year	827	category_type_id	100%
category_year_to_make	44	year	100%
category_year_to_make	44	category_make_id	100%
image_slug	0	assemble_id	0%
model	22,792	model	100%
		brand	100%
		type	100%
		year	98.91%
part	1,380,339	part	100%
		part_number	100%
		quantity	62.28%
		old_number	14.76%
		price	62.89%
type	38	type	100%
type	38	brand	100%
year	1,003	year	99.9%
		type	100%
		brand	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

assemble_image

Size (Bytes)	Files
4.48G	983,302

assembly_image

Size (Bytes)	Files
3.81G	771,797

assembly_image_to_make

Size (Bytes)	Files
307.23M	59,323

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	6.76G (+ 3.21G)	23 (+ 10)	114 (+ 58)	45,772,502 (+ 28,824,404)	8.59G (+ 4.48G)	1,814,422 (+ 983,302)
2023-01-01 (+ 95 d)	3.55G (+ 0B)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2022-09-27 (+ 271 d)	3.55G (+ 0B)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2021-12-30 (+ 115 d)	3.55G (+ 0B)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2021-09-05 (+ 150 d)	3.55G (+ 0B)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2021-04-08 (+ 68 d)	3.55G (+ 1.91G)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2021-01-29 (+ 120 d)	1.64G (+ 0B)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2020-10-01 (+ 38 d)	1.64G (+ 0B)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2020-08-23 (+ 141 d)	1.64G (+ 0B)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2020-04-04 (+ 196 d)	1.64G (+ 0B)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2019-09-21 (+ 197 d)	1.64G (+ 0B)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2019-03-07 (+ 43 d)	1.64G (+ 0B)	13 (+ 0)	56 (+ 0)	16,948,098 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2019-01-23 (+ 44 d)	1.64G (- 3.18G)	13 (- 4)	56 (- 26)	16,948,098 (- 9,473,122)	4.11G (+ 0B)	831,120 (+ 0)
2018-12-09 (+ 29 d)	4.83G (- 0.99G)	17 (+ 2)	82 (+ 7)	26,421,220 (- 7,822,437)	4.11G (+ 0B)	831,120 (+ 0)
2018-11-09 (+ 27 d)	5.81G (+ 1.49G)	15 (+ 0)	75 (+ 0)	34,243,657 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2018-10-13 (+ 29 d)	4.33G (+ 0B)	15 (+ 0)	75 (+ 0)	34,243,657 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2018-09-13 (+ 34 d)	4.33G (+ 0B)	15 (+ 0)	75 (+ 0)	34,243,657 (+ 0)	4.11G (+ 0B)	831,120 (+ 0)
2018-08-09 (+ 27 d)	4.33G (+ 64K)	15 (+ 1)	75 (+ 4)	34,243,657 (+ 1,593,380)	4.11G (+ 81.55M)	831,120 (+ 11,045)
2018-07-12 (+ 31 d)	4.33G (+ 2.68G)	14 (+ 7)	71 (+ 39)	32,650,277 (+ 20,286,870)	4.03G (+ 1.81G)	820,075 (+ 293,127)
2018-06-10 (+ 31 d)	1.65G (+ 0B)	7 (+ 0)	32 (+ 0)	12,363,407 (+ 0)	2.22G (+ 0B)	526,948 (+ 0)
2018-05-10 (+ 28 d)	1.65G (+ 0B)	7 (+ 0)	32 (+ 0)	12,363,407 (+ 0)	2.22G (+ 105.86M)	526,948 (+ 18,002)
2018-04-11 (+ 38 d)	1.65G (+ 0B)	7 (+ 0)	32 (+ 0)	12,363,407 (+ 0)	2.11G (+ 1.77G)	508,946 (+ 417,338)
2018-03-03 (+ 35 d)	1.65G (+ 7.95M)	7 (+ 0)	32 (+ 0)	12,363,407 (+ 3,778,310)	349.55M (+ 349.55M)	91,608 (+ 91,607)
2018-01-27 (+ 29 d)	1.64G (+ 1.34G)	7 (+ 0)	32 (+ 0)	8,585,097 (+ 5,508,682)	5.49K (+ 0B)	1 (+ 0)
2017-12-29	310.91M	7	32	3,076,415	5.49K	1

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.