European Car Models & Engines Database

Download SAMPLE: Car Models, Engines .XLS  (2013-2019 format)
Car Models Engines Database new proposed format.xls (2020 format)

Buy complete database + FREE updates for one year:

A vehicle database intended for auto parts shops and other businesses, and webdesigners making drop-down boxes that need to go further than make and model. It is simplified from The BIG Car Database by removal of duplicate rows for same engine caused by facelifts which affected only exterior of cars.

Last release: 6 May 2019 for AutoKatalog-based database, 27 July 2020 for ADAC-based database. Full change log.

Shorty after May 2019 update I drafted a sample for making Car Models & Engines Database based on ADAC website in the future, to reduce effort needed for on-going updates and to include unique IDs, car images and engine codes. I could potentially start this project in January-February 2020, but due to ADAC website redesign in December 2019, followed by on-going changes in model hierarchy in 2020, I decided to put this project on hold a bit until ADAC settle up its model hierarchy… to avoid needing to re-do same work again in the future.

I published a new update of German Car Database on 12 July 2020 and on 19 July I started work to remove excess rows of equipment variations for same engine, I published a BETA version of Car Models & Engines on 27 July 2020 but decided to keep prices 1 cent/row according number of rows from 2019 because there is still work in progress to remove duplicates until database will have exactly 1 row for each body / engine combination.

July 2020 edition row count: 1950s-present: 27920 rows, 1990s-present: 22361 rows, 2000s-present: 17283 rows, 2010s-present: 7894 rows, new cars only: 3956 rows.

Coverage

Cars sold in Europe. Database being based on AutoKatalog (german car magazine) have 100% coverage for cars sold in Germany which is the biggest car market of Europe. 99% of cars sold in any European country are also sold in Germany. I also added unique cars sold only in UK, communist cars sold only in Eastern bloc, as well as special cars with 2.0 liter engine to comply with Italian tax system.

If you are outside Europe, you can check list of car models included in Excel file and report missing models (sold in your country but not in Europe) so I can add their data if available, but I cannot guarantee that I can add all.

Data fields included

Database contain the following columns, indicating the period that include data in. Completion is nearly 99% for every column in the period covered. For more columns, see The BIGGEST Car Database.

Naming: Make, Model, Version, Years, Source of data, Sold in, Class.

Body data: Body type, No. of doors, No. of seats, Engine place, Drivetrain.

Engine data: Cylinders (all), Displacement (all), Power kW (all), Power PS (all), Torque Nm (all), Catalytic (1986-1993).

Drivetrain data: Tire size (all), Tire size rear (if different than front).

Performance data: Engine type (all).

How to use the database

Either you are creating a car parts website, car insurance website or just informational website, you are advised to make 3 drop-down boxes: Make, Model, Version, example: www.onlinecarparts.co.uk, DO NOT make a drop-down for Year, as Europeans do not need this, this system is good only for America. Use colums D, E, F, H, use of column E to group the list of model platforms (example BMW 3-Series – E36, E46, E90-93).

This database will undergo major redesign in the future… YOUR opinion is needed!

Several customers said that this database is too detailed and contains duplicate rows for same engine because it is offered with multiple bodies and drivetrains and they do not need these details (especially the ones in ECU chiptuning field). I am planning to make a NEW Car Engine Database stripping off data from German car database to reduce number of rows until meet your requirements.

This is a possible SAMPLE: Car Models Engines Database new proposed format.xls. Feel free to suggest changes.

I could potentially start this project in January-February 2020, but due to ADAC website redesign in December 2019, followed by on-going changes in model hierarchy in 2020, I decided to put this project on hold a bit until ADAC settle up its model hierarchy… to avoid needing to re-do same work again in the future.

If same engine is available on multiple body styles…

BMW 320i is enough, I do not need 4 rows for saloon, touring, coupe, cabrio
I need separate row for saloon, estate, coupe, cabrio, but 3/5-door hatchbacks can share same row
Even 3-door and 5-door hatchbacks should be 2 separate rows
Other
Please Specify:
Created with QuizMaker

If an engine is offered with 2-wheel drive and 4-wheel drive…

A car engine database should omit multiple drivetrain options, 1 row per engine is enough
Front wheel drive, rear wheel drive and all wheel drive should be each on separate row
Other
Please Specify:
Created with QuizMaker

Production years should be indicated for each engine?

I do not need production years for each BMW 320i, 328i, 330d, etc, is enough to indicate production years for 3-Series E46, E90, etc
Beside production years for main model, each engine version should have production years indicated
Other
Please Specify:

How to indicate engine size?

litres
cm³
Other
Please Specify:

6 thoughts on “European Car Models & Engines Database

  1. I need firing order, location of Cylinder 1 and the naming convention if not in-line (Alternate between banks, or sequential in banks in order of bank number).
    Want ignition (spark, diesel),
    Circuit voltage (6, 12, 48, ..)
    Bore (mm)
    Stroke(mm)

  2. I would like to see important engine tech info such as cam timing, spark ignition timing, fuel injection timing specs. This is an engine database is it not?
    Thank you

Leave a Reply

Your email address will not be published. Required fields are marked *