Home Data Automotive Car Parts & Accessories

US 1,363 BMW Car Parts API: Desc, Price, SKU, Image (1984-2020)

Name	n3_lyz_bmwofsouthatlanta.com
Data	7.66M (+ 0B)
Tables	19 (+ 0)
Columns	109 (+ 0)
Table Rows	18,569 (+ 0)
Media	1.20M (+ 0B)
Files	51 (+ 0)
Last Commit	2023-06-19 18:12:05 (+ 169 d)

In this BMW car parts database, there are 1,363 records from 1984 to 2020 years.

Each record is comprised of seq, part number, assemble, list price, sale price, sku, position, other name and description. There are 6 tables mostly related with these parts, they are 68 assembles; 526 fit car records with make, body trim and engine in each; 224 model records with series in each; series with 11 records; 1,428 system records with mark, model, year, series and system in each and 1,737 year records with model, year, series and system in each.

This BMW auto parts data also comes with assemble images & parts images, they are all keeped in the media files. The whole BMW car parts database totally has 19 tables.

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_lyz/parts_of_bmw_for_usa/ (By Table)

Media Files

assemble_image ^{Bytes: 1.19M / Files: 50}
part_image ^{Bytes: 6.64K / Files: 1}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
assemble	68	assemble	100%
assemble	68	sub_system_id	100%
fit_car	526	make	100%
		body_trim	100%
		engine	100%
model	224	model	100%
		series_id	100%
		series	100%
model_m	128	model	100%
		series	100%
		year	100%
		year_m_id	100%
part	1,363	seq	100%
		title	100%
		part_number	100%
		assemble_id	100%
		list_price	6.6%
		sale_price	6.6%
		sku	6.6%
		sku_2	6.75%
		position	3.6%
		other_name	6.75%
		description	6.68%
part2_image_slug	0	title	0%
		city	0%
		votes	0%
		description	0%
		part_2_id	0%
part_2	9	title	77.78%
		part_number	100%
		sub_system_id	100%
		list_price	88.89%
		sale_price	88.89%
		sku	88.89%
		sku_2	88.89%
		position	22.22%
		other_name	88.89%
		description	88.89%
part_2_x_fit_car	337	part_2_id	100%
part_2_x_fit_car	337	fit_car_id	100%
part_image_slug	1	part_id	100%
part_x_fit_car	2,817	part_id	100%
part_x_fit_car	2,817	fit_car_id	100%
series	11	series	100%
series_m	4	series	100%
sub_system	9,890	sub_system	100%
		system_id	100%
		mark	0%
system	1,428	system	100%
		mark	100%
		model	100%
		year	100%
		series	100%
year	1,737	year	99.14%
		model_id	100%
		model	100%
		series	100%
		system	0.86%
year_m	26	year	100%
		series	100%
		series_m_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

assemble_image

Size (Bytes)	Files
1.19M	50

part_image

Size (Bytes)	Files
6.64K	1

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	7.66M (+ 0B)	19 (+ 0)	109 (+ 0)	18,569 (+ 0)	1.20M (+ 0B)	51 (+ 0)
2023-01-01 (+ 95 d)	7.66M (+ 0B)	19 (+ 0)	109 (+ 0)	18,569 (+ 0)	1.20M (+ 0B)	51 (+ 0)
2022-09-27 (+ 271 d)	7.66M (+ 0B)	19 (+ 0)	109 (+ 0)	18,569 (+ 0)	1.20M (+ 0B)	51 (+ 0)
2021-12-30 (+ 115 d)	7.66M (+ 0B)	19 (+ 0)	109 (+ 0)	18,569 (+ 0)	1.20M (+ 0B)	51 (+ 0)
2021-09-05 (+ 150 d)	7.66M (+ 0B)	19 (+ 0)	109 (+ 0)	18,569 (+ 0)	1.20M (+ 0B)	51 (+ 0)
2021-04-08 (+ 68 d)	7.66M (+ 288K)	19 (+ 0)	109 (+ 0)	18,569 (+ 0)	1.20M (+ 0B)	51 (+ 0)
2021-01-29 (+ 120 d)	7.38M (+ 0B)	19 (+ 0)	109 (+ 0)	18,569 (+ 0)	1.20M (+ 0B)	51 (+ 0)
2020-10-01 (+ 38 d)	7.38M (+ 0B)	19 (+ 0)	109 (+ 0)	18,569 (+ 0)	1.20M (+ 0B)	51 (+ 0)
2020-08-23	7.38M	19	109	18,569	1.20M	51

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.