Database
103K Car Parts Data: Desc, Price, Images & 335 Assemblies of 7 Brands
103,195 car parts data: price, description, part number, system, assemble, OEM number, and images of 7 Brands
Description: In this car parts database, there are 103,195 records of 7 brands(Volvo BMW Audi VW Mercedes Porsche Saab). Each record is comprised of description, part, price, mark, star, review count, part number, sub name, fcp euro number, quality, made in, and mfg number. There are 7 tables mostly related to these parts, they are 335 assemblies; fit a car with 423,828 records; 2,311,199 fit model records with model and content in each; 138,302 OE numbers; 270 part brands with the description in each; sub-assembly with 2,721 records and 16 systems. This auto parts data also comes with 97,248 images of these parts. The whole car parts API totally has 17 tables.
Data Samples (JSON, CSV, XML, Excel):
http://n3.datasn.io/data/api/v1/n3_lyz/parts_and_assemblies_of_car_for_6_brands/
Database Statistics
- Size: 318.61 MB
- Tables: 16
- Records: 103,195
- Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)
Database Categories
Images Statistics
- Images: 7.27G
- Dimensions: 600x 500 on average
- Image formats: JPEG
- Images count: 96956
- Reference field: image_name_field
Database Structure
Table | Records | Fields |
---|---|---|
brand | 7 |
|
system | 16 |
|
brand_x_system | 112 |
|
assemble | 335 |
|
brand_x_system_x_assemble | 1,626 |
|
sub_assemble | 2,721 |
|
brand_x_system_x_assemble_x_sub_assemble | 8,288 |
|
part | 103,195 |
|
brand_x_system_x_assemble_x_sub_assemble_x_part | 115,521 |
|
part_image | 96,956 |
|
fit_car | 423,828 |
|
fit_model | 2,311,199 |
|
part_brand | 270 |
|
part_x_part_brand | 99,497 |
|
oe_number | 138,302 |
|
part_x_oe_number | 181,836 |
|
Database Attachments
Images: This database is attached with 96956 images. See them under the Attachments tab.
Content Scope
Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:
brand
- Volvo
- BMW
- Audi
- VW
- Mercedes
- Porsche
- Saab
system
- AC and Climate Control
- Air Intake
- Brake
- Clutch and Flywheel
- Cooling System
- Drivetrain and Axle
- Engine
- Exhaust
- Exterior Body
- Fuel System Parts
- Interior Body
- Merchandise and Accessories
- Steering
- Suspension
- Tools Hardware and Supplies
- Transmission
part_brand
- Valeo
- Sanden
- Behr
- ACM
- Nissens
- Bosch
- Aftermarket
- Genuine Porsche
- Genuine Volvo
- OEM Supplier
- Rein
- Santech
- Stribel
- KAE
- Four Seasons
- Hella
- Metrix
- Hansa
- Dansk
- Mahle
- Corteco
- Hengst
- Mann
- Meyle
- Pierburg
- Gemo
- Delphi
- Kayser
- VDO
- Febi
- Vemo
- CTA Manufacturing
- TYC
- Reinz
- NPN
- Contitech
- Programa
- Elring
- AKG
- Borg Warner
- MTC
- Snabb
- Bremi
- Canyon Engine Components
- Cofle
- Elwis
- Genuine VW Audi
- ATE
- TRW
- Mackay
- Centric
- Mishimoto
- Facet
- FAE
- Denso
- TPI
- CRC Industries
- FTE
- Genuine BMW
- Sebro
- Cohline
- Techna-Fit
- Brembo
- Zimmermann
- Stop Tech
- Hawk
- Pagid
- Textar
- Cardone
- Pro Parts Sweden
- Odometer Gears
- Sachs
- Pentosin
- Castrol
- Motul
- Liqui Moly
- INA
- SKF
- LuK
- Ferodo
- FAG
- Jurid
- Permatex
- Loctite
- Cifam
- PEX
- Reutter
- Gates
- CRP
- Lemforder
- SWF
- Laengerer Reich
- Aisin
- Motorad
- Eurospare
- GEBA
- Laso
- Graf
- Hepu
- Meistersatz
Lifetime Updates (fees may apply)
This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.
Other Formats upon Request
We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:
- Microsoft SQL Server
- Microsoft SQL Server Compact Edition
- Oracle
- PostgreSQL
- ODBC
- Interbase / Firebird
- WordPress
- Single Table (multiple tables are combined into one)
- Microsoft Word .DOC
Let us know and we'll see what we can do. Additional fees may apply.