Usage & Publication License: database price dollar sign289.00

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

database structure screenshot of 103K Car Parts Data: Desc, Price, Images & 335 Assemblies 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/

Related DBs:

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
  1. id
  2. ts
  3. brand
system 16
  1. id
  2. ts
  3. system
brand_x_system 112
  1. id
  2. ts
assemble 335
  1. id
  2. ts
  3. assemble
brand_x_system_x_assemble 1,626
  1. id
  2. ts
sub_assemble 2,721
  1. id
  2. ts
  3. sub_assemble
brand_x_system_x_assemble_x_sub_assemble 8,288
  1. id
  2. ts
part 103,195
  1. id
  2. ts
  3. description
  4. part
  5. price
  6. mark
  7. star
  8. review_count
  9. part_number
  10. sub_name
  11. fcp_euro_number
  12. quality
  13. made_in
  14. mfg_numerbr
brand_x_system_x_assemble_x_sub_assemble_x_part 115,521
  1. id
  2. ts
part_image 96,956
  1. id
  2. ts
  3. source_content_type
  4. hash_file_content
  5. size
  6. path
  7. title
  8. access
fit_car 423,828
  1. id
  2. ts
  3. car
fit_model 2,311,199
  1. id
  2. ts
  3. model
  4. content
part_brand 270
  1. id
  2. ts
  3. part_brand
  4. description
part_x_part_brand 99,497
  1. id
  2. ts
oe_number 138,302
  1. id
  2. ts
  3. oe_number
part_x_oe_number 181,836
  1. id
  2. ts

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
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email: info@UsableDatabases.com

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. Which is smaller, elephant or mouse?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.