Current databases for sale


European Car Models, Engines, Dimensions, All details

1970s-present
110+ makes
1900+ models
22000+ versions
56 columns of specs per model
Last release: 1 August 2018

Demo / sample Read more & BUY
.


American
Year-Make-Model-Trim-Specs

1990-present
62 makes
8000+ model years
50000+ model trims
86 columns of specs per model
Last release: 27 November 2018

Demo / sample Read more & BUY
.


Indian
Full Specs Database

1990s-present
50 makes
600+ models
4000+ versions
188 columns of specs per model
Last release: 1 January 2019

Demo / sample Read more & BUY
.

Australia car database
Brazil Car Database

1970-present
? makes
? models
10000+ versions
80-100 columns per model

Possible future project, anyone interested?


Another American car database

1990-present
61 makes
8000+ model years
50000+ model trims
230 columns of specs per model
Last release: 1 October 2018

Demo / sample Read more & BUY
.



Middle East Database

2000-present
90 makes
900+ models
11000+ versions.
26 columns of specs per model.
Last release: 8 December 2018.

Demo / sample Read more & BUY
.


German car database

1970-present
80 makes
110000+ versions
179 columns of specs
Last release: July 2018

Demo / sample Read more & BUY
.

Australia car database
UK car database

1980-present
101 makes
80000+ versions
45 columns of specs
Last release: 20 January 2019

Demo / sample Read more & BUY
.

Australia car database
Australia car database

1960-present
123 makes
98000+ versions
96 columns of specs
Last release: 10 December 2018

Demo / sample Read more & BUY
.


Car Models Database

1945-present, 110+ makes, 2000+ models, 3400+ total rows. 1 row = model, platform and body style: BMW 3-Series E36, E46, Saloon, Touring, Coupe, Cabrio.
13 columns of specs per model.

Demo / sample Read more & BUY
.


Malaysia car database

2014-present
49 makes
2000+ versions
123 columns of specs
Last release: September 2018

Demo / sample Read more & BUY
.


Singapore car database

2005-present
56 makes
4000+ versions
62 columns of specs
Last release: November 2018

Demo / sample Read more & BUY
.


World Motorcycles Database

1894-present
473 makes
30000+ models
72 columns of specs per model.
Last release: October 2018.

Demo / sample Read more & BUY
.


Automobile production

Table and chart made in Excel with number of cars produced in each country from 1999 to 2017.
Does NOT contain makes and models.
.

Read more & request FREE

.


Car sales figures

Table with number of cars sold in Europe, United States and China, by make and model.
Updated February 2018 to include 2017 data.

Demo / sample Read more & BUY
.


Car Models List XLS

1945-present.
World 160+ makes, 5000+ models
Europe 120+ makes, 2700+ models
1 row = each model platform: BMW 3-Series E46, E90-E93, F30, etc.
Last release: 15 January 2019.
.
.

Demo / sample Read more & BUY
.


Car Nameplates List

1945-present
180+ makes
3300+ nameplates
An alternative to Car Models List, single row for all models sharing same name and separate row for each name a model is sold.
Last release: 20 January 2019.

Demo / sample Read more & BUY
.


Year-Make-Model

1945-present
90 makes
15000+ model years
5 columns, NO technical specs.
Last release: 8 May 2018.
Car Models List in American style with one row for each year the car was sold
.

Demo / sample Read more & BUY
.


Car Models List DOC

The original version of Car Models List in .DOC format. This is intended for consulting and reading only. Web developers are advised to purchase the above Car Models List in .XLS format that can be quickly dumped in a MySQL database.

Read more & request FREE

 .


Car Models Timeline

Same cars like in Car Models List but displayed in an easy-to-visualize timeline chart to study car models organization.
.
.
.

Read more & request FREE

 .


Car Models Encyclopedia

The original book-style .DOC with car models, dimensions, weight, list of engines.
Europe 1945-present / World 1980-present. 360-page book with 1500+ models.
.

Demo / sample Read more & BUY
.


Car Engines Database

1970s-present, 110+ makes, 1900+ models, 20000+ total rows. 1 row = engine / body / drivetrain combination: BMW 320i, 325d, 325d xDrive, etc.
9 columns of specs per model.
Last release: 1 August 2018.

Demo / sample Read more & BUY
.


Car Tires Database

Same like Car Engines Database + one additional column: TIRES, finalized 1990-present as September 2015, 1970-1990 under construction.
11 columns of specs per model.
Last release: 1 August 2018.
.

Demo / sample Read more & BUY
.


Car Models, Engines, Dimensions, Performance Database

Same like Car Engines Database + 18 additional columns.
27 columns of specs per model.
Last release: 1 August 2018.
.
.

Demo / sample Read more & BUY
.


Light Bulbs Database

1958-present
133 makes
37000+ models
.

Demo / sample Read more & BUY
.


ECU Remap Database

1991-present
64 makes
900+ models
34600+ engines

Demo / sample Read more & BUY
.


Wheels and Tires Size

1953-present
107 makes
32000+ model years
400000+ tire sizes

Demo / sample Read more & BUY
.

FAQ & notes

PRICES TOO HIGH! I am a student doing a non-profit research…

The price reflect my efforts and quality of work. Show me where you can find a cheaper auto database with comparable amount of data and updated regularly!

Most visitors of website are from companies, programmers and web developers, some offered me even 1000 euro to make a customized vehicle list in SQL. I cannot verify if you make profit or not. If you are a poor student or doing something non-profit, then probably we cannot make a deal. Sorry!

Do you provide updates?

Of course, I update all databases constantly, databases with higher sale volume are updates more often. Download links are set to expire in 1 year, you can click the link again anytime you want to download latest updates. Moreover each time I update a database I re-send the email with download link to each customer to notify you to re-download database.

Do you provide API to avoid needing re-downloading each time you update?

I do not have sufficient experience to create API. But YOU can help! Read more.

Do you provide invoices?

PayPal provide receipt for purchase and you can use it if needed. In 2014 and 2015 I also provided a DOC invoice if I was asked. But in 2015 someone told me that I cannot legally issue invoices if I am not a registered company. I am 1-person business with no employees so there is no reason to register a company. The CEO of one company got idea to pay from his personal account rather than company account, to avoid needing invoice to explain his purchase. You can do the same, tell to your boss to pay from personal account.

Can I buy a small database then upgrade to a bigger database by paying difference?

YES in case of vehicle databases with same table structure. For example if you bought Car Models & Engines 1995-present then you want want Car Models & Engines & Dimensions 1970-present, you can contact me and I will lower a price to the difference.

NO upgrade from Car Models Database to Car Models & Engines Database because they are totally different products aiming to different business types.

You can contact me also if you want to pay in another currency such as GBP to avoid conversion fee. Sometimes I go shopping on eBay.co.uk and having only EURO in PayPal I have to pay a conversion fee too.

United Kingdom car database

Small database (make, model, image) – FREE sample

BIG database (make, model, version, specifications) – FREE sample

FREE updates for one year!

Source of data: one of the most popular websites in United Kingdom.

Coverage: cars sold in United Kingdom 1980-present.

Lis of car makes included

Abarth, AC, Aixam, Alfa Romeo, Alpine, Asia, Aston Martin, Audi, Austin, Bentley, BMW, BMW Alpina, Bristol, Cadillac, Caterham, Chevrolet, Chrysler, Citroen, Coleman Milne, Corvette, Cupra, Dacia, Daewoo, Daihatsu, Daimler, De Tomaso, Dodge, DS, Eagle, Farbio, FBS, Ferrari, Fiat, Ford, FSO, Honda, Hummer, Hyundai, Infiniti, Invicta, Isuzu, Jaguar, Jeep, Jensen, Kia, KTM, Lada, Lamborghini, Lancia, Land Rover, Lexus, Ligier, Lotus, LTI, Marcos, Marlin, Maserati, Maybach, Mazda, McLaren, Mercedes-AMG, Mercedes-Benz, MG, MG Motor UK, MIA, Microcar, MINI, Mitsubishi, Morgan, Nissan, Noble, Opel, Perodua, Peugeot, PGO, Porsche, PRINDIVILLE, Proton, Reliant, Renault, Rolls-Royce, Rover, Saab, San, SAO, SEAT, Skoda, Smart, SsangYong, Subaru, Suzuki, Talbot, TD Cars, Tesla, Toyota, TVR, Vauxhall, Volkswagen, Volvo, Westfield, Yugo.

Description

I created this UK car database in January 2019 after multiple people requested me to do this job. For long time I avoided spending additional effort to make an UK car database because I already had the Car Models & Engines Database for whole Europe that has been purchased by many people in UK without problems, and the more detailed German Car Database was not selling well.

But… a small number of people wanted a more detailed database than European one (which have 1 row per body / engine / drivetrain combination, ignoring trims / equipment versions). Some did purchased German one but the ones from UK wanted an UK-specific one. The UK website turned much easier to scrap than originally expected, easier than other German and American websites I have scraped data from. I feel sorry for not creating this UK car database earlier!

How many distinct car models are being produced in the world?

The answer of above question depends by how do you define “one model”.

Should we count BMW 3-Series as one model?

Should we count each body type (compact, saloon, touring, coupe, cabrio)?

Should we count each engine version (318i, 320i, 325i, 330i, 335i, 316d, 318d, 320d, 325d, 330d, 335d, M3, in case of 3-Series E90)?

Should BMW M3 or BMW 3-Series Gran Turismo be counted as submodels of 3-Series or as separate models?

The answer according my PERSONAL classification

Volkswagen Group is 1 manufacturer, selling cars under 8 makes: Audi, Bentley, Bugatti, Lamborghini, Porsche, Seat, Skoda, Volkswagen.

BMW 3-Series is 1 nameplate.

Car Nameplates List have over 3,000 nameplates sold all over the world, 1945-present. Cars that are technically identical but sold under different names are counted separately, example Fiat Bravo / Brava or Mitsubishi Pajero (continental Europe) / Shogun (UK) / Montero (USA).

BMW 3-Series nameplate produced 7 successive models: E21, E30, E36, E46, E90-93, F30-33, G20.

Car Models List have over 5,000 models (generations) sold all over the world of which over 2,500 sold in Europe, 1945-present. Cars that are technically identical are counted only once here, Pajero / Shogun / Montero, but there are 4 generations of them.

BMW 3-Series was sold with up to 5 body styles: compact, saloon, touring, coupe, cabrio (in case of E36 and E46).

Car Models Database have over 3,500 body styles of the 2,000+ models sold in Europe, 1945-present (and actually there are more body styles, because in case of old cars if I do not know dimensions for each body style, I ignored them).

BMW 3-Series E90-93, each body style is sold with up to 12 engine versions: 318i, 320i, 325i, 330i, 335i, 316d, 318d, 320d, 325d, 330d, 335d, M3, some of them sold in rear wheel drive and all wheel drive options.

Car Models & Engines Database have over 20,000 combinations of body style, engine, drivetrain of the 2,000+ models sold in Europe 1975-present. This is the biggest database I compiled myself, manual data entry from AutoKatalog magazines issued yearly in Germany, which due to limited space of a printed book, they choose to not show separate row for manual / automatic transmission or trims / editions / equipment levels.

Larger than this are the databases made via scraping from various websites (as opposite of manual data entry).

Each engine version of BMW 3-Series F30-33 is sold with few trims / editions: (base), Modern Line, Luxury Line, M Sportpaket.

German Car Database made via scraping from www.adac.de have over 100,000 rows including every possible variation, 1975-present. United Kingdom Car Database made via scraping from www.parkers.co.uk have over 80,000 rows 1985-present.

They make so many rows that most customers refuse to purchase the over-detailed German and UK car databases and choose instead the Car Models & Engines Database, for example the car parts shops that do not need multiple rows for each engine.

Some customers thinks that a database with more rows is more complete, this is WRONG. Completion level is inverse proportional to detail level. The most comprehensive are the Car Models List and Car Nameplates List, because the more detailed ones cover cars sold in a specific continent only.

German Car Database although it have 5 times more rows than European Car Models & Engines Database, it is missing cars that are not sold in Germany, for example some Dacia, some Lada, all Moskwitch, all Zastava and other cars specific to Eastern Europe.

How many car models are sold in United States

Americans do not make distinction between multiple generations of same model, but due to government regulations of car market, each year is counted as separate model, manufacturers releasing each “2019 Model” during 2018. Also models sold here are offered with a smaller range of engines, for example in case of BMW 3-Series E90-93, only 4 engines are sold in US (328i, 335i, 335d, M3) compared with 12 sold in Europe.

Year-Make-Model-Trim-Specs have over 1,000 model nameplates, over 8,000 model years, over 50,000 trims, sold in United States 1990-present. Each year add about 2,500-3,000 new trims.

How many car models are sold in Australia

Australia government most likely do not regulate each year to be counted as separate model but websites such as Redbook.com.au shows each calendar year separately.

Australian Car Database have over 90,000 trims 1960-present. Each year add about 4,000 new trims.

Car paint color codes

Download free SAMPLE:
Car-paint-color-codes-SAMPLE.xlsx

Buy FULL database:

Database made in December 2018

64 makes, 2706 make years, 1085 don’t have breakdown by model and 1621 are breakdown by 12376 model years, total 142612 paint codes.

Custom database building

A variety of people and companies visit my website, there is impossible to make everyone happy by offering a single vehicle database, or to predict the needs of future customers and develop suitable databases in advance.

If you think that these vehicle databases are stolen from somewhere and sold “as it is” like on other data providers, you’re WRONG. Being the developer of database and having over 10 years experience in researching car industry, I can offer you customized solutions.

Tell me what are you looking for, I may customize a database or create a new database according your requirements, and for future customers who may want same thing, you can help me to expand my business and make databases usable for applications that was not originally planned.

Note: please don’t treat me like your own personal full-time employee, with unlimited time available for YOU in defavor of other customers. I am an independent businessman who likes serving as many customers is possible. So I have the right to NOT do projects that takes more than ~5 hours of manual work and more than ~50 hours of web scraping, if you are the only person who want that particular database. Large projects can be done only in the fields of my personal interest OR if there is demand from multiple people.

Custom packages

I sell each database in several standard packages, for example Year-Make-Model-Trim-Specs have 3 column options: Trims, Basic Specs, Full Specs, and 2 rows options: all cars (1990-2018) and new cars only (2016-2018), making a total of 6 packages. But you can ask me to create a custom package if:

  • You need more than 2016-2018, but also don’t want to pay big price for 1990-2018. For example you need 2010-2018.
  • You need an additional column that is not included in Basic Specs package, but don’t want to pay big price of Full Specs package.
  • You need only SUV, or only vehicles made by General Motors (Buick, Cadillac, Chevrolet, Geo, GMC, Oldsmobile, Pontiac, Saturn). Useful for people who buy my database to decide what car to purchase. Note: for a selection of makes the price per row will be twice of normal price, so if your chosen makes exceed 50% of total rows in databases you won’t get discount.

Note: if you buy custom packages you will NOT be notified automatically when updates are available and you will not be able to download them. If you need updates you need to contact me and I will email you.

Customization of existing data

FREE customization: rearranging the existing data, deleting the “bonus” cars not sold in Europe, translating technical terms, etc. Do not lose a FREE offer like this FUNNY customer!

Paid customization: if new data need to be added, but if your idea is great and makes the database better thus can be sold to more people, price will be LOWER.

I have developed the databases initially as stand-alone products intended for visualization in Excel, not expecting that people will want to integrate them in websites or other applications.

Until december 2012 I had only 2 databases with specs for sale: Car Database LITE (renamed Car Models Database) and Car Database BIG (renamed Car Models & Engines Database), plus the Car Models List offered FREE in Word format because I was in doubt that someone will ever pay for a simple list of models without technical specs…

… without realizing that there is audience of people looking for a car database to integrate in a website, so they do not need technical specs, they need just a list of models… but in Excel rather than Word!

– As soon as one customer (from Turkey) told me this (30 December 2012), I offered conversion of Car Models List.DOC (offered FREE) to .XLS for €20 but he did not agreed to pay, however I DONE IT and put it for sale for other people, for $29.60 – 2960 models / 103 brands. Surprisingly, in just one month 4 people bought such XLS list of models without specs, outselling the other 2 products. Many thanks to anonymous from Turkey.

– One American did not liked the just-launched Car Models List.XLS and told me to recompile it by making separate row for each year (5 February 2013), after a little talk and confusion, I DONE IT!
This format of database was very WEIRD for me as European, but later I realized that this is the standard format for North America market so I put it on sale for everyone as Car Models List US and it became a best-seller! Later renamed to Year-Make-Model.
Now I think that this guy from one month ago wanted the same thing, but instead of explaining me, he quitted like an idiot.

– An insurance company intending to buy Car Models & Engines Database suggested to add two extra columns for make and model beside full model name. DONE! (December 2012), this boosted sales a lot.

– Someone who purchased Car Models & Engines Database complained that cannot filter the table by fuel type (January 2013). DONE! I added an extra column for Fuel type without charging extra cost (it was originally not included because any reader can realize which is gasoline and which diesel, by model name). Now I am sad by thinking that I lost potential buyers who were needing Fuel type column too, they went away instead of telling me to add it?

The BIGGEST job ever done by customer request (opposite of the original database made as personal interest), is the Car Tire Database. Initially I said NO to first customers, because takes over 100 hours, but during 2013 I has been contacted by 4 customers demanding a Car Tire Database, so I decided to start adding tires in the Car Models Engines & Dimensions database. After completing 20% my website was hit by Google Penalty, lost 90% of traffic, lost interest in making new databases because potential of new customers was too low. Penalty ended in March 2014, traffic recovered.
A new customer wanted transmission, other customer wanted something else. I put Car tires on hold to decide what is best thing to do, and in mid-2014 I decided to add not just tires but ALL 40+ data fields from AutoKatalog.
I published a SAMPLE of the 40+ fields database, as marketing experiment, to see if anyone is interested in such big amount of data, and in 6 months found only 1 customer interested in 40+ columns (which in this case I would have abandoned the project) but numerous customers interested in specific data (mostly interested in tires, few in transmission, etc) encouraged me to continue.
I launched for sale Car Models, Engines, Tires in May 2015 with 60% completion for tires, and finalized the 40+ fields database for 1990-present in October 2015.

CONCLUSION: many people are looking for things that I did not expected, but I could offer them IF they would not be lazy to contact me and request them. What are YOU looking for?

Creating totally new databases

Learning web scraping in 2015 opened a new era, now I can create totally new databases with minimum of effort, not limited automobiles or other fields of personal interests, by writing scripts that visit a certain website and extract specific data and put it into an Excel database.

Do not just tell me what data do you need and expect me to do research on the web to find that particular data. You need to provide URL of a website containing the data you need and I will make the scraping script. The resulted database will match the original website, which may be or may be not the format you need.

Do not expect me to create databases with data that you cannot find yourself in any form, for example:

  • Do not ask me to make database with dimensions of car lights, bumpers, windows, etc. Such dimensions are not provided in car manuals or anywhere in the web. If you sell such car parts, measuring yourself your own parts is the only solution.
  • Do not think that I can compile a table with number of cars sold in your country, breakdown by model, if your government is not tracking sales and making them public on the internet. Data needs to be available somewhere in order to scrap it and put into a database.
  • One of the weirdest requests was from a manufacturer of mosquito nets for 4-door cars, requesting a database with rear door window dimensions. No car manufacturer provide such info that is not on general interest… it needs to be measured manually on cars of his own customers.

Motorcycle database

Download SAMPLE (one make):
Motorcycle Database .XLS

Buy FULL database + FREE updates for one year:

Contact me for other packages such as 2008-present or specific set of columns.

Bikes database history

The motorcycle database was originally the ONLY product on this website that is not “100% Made by Teoalida”. It resulted from a “work exchange” with a customer who needed both cars and bikes and we agreed to give him a discount for my manually-made biggest car database and he made a script to copy data automatically from www.bikez.com and put in a CSV file with permission to sell it on my website. However, few months later I made my own script which surprisingly works faster than his one, making it a product Made by Teoalida.

Bikez.com is a fan-made website, there are many data fields, but actual data is available for just a small amount of bike models, and completion is NOT guaranteed for any specific market. Fan-made website means less restrictive in terms of copyright. You are free to use this data on your own website. Already seen a website (motociclisti.ro) using same data from bikez.com, everything translated into Romanian.

Bikez.com website originally covered 1970-present, but was expanded to 1930-present during summer 2016 and to 1894-present during autumn.

My experience is limited to cars so I cannot tell how complete is for bikes sold in any specific country in the world, or what is the accuracy of fan-made websites, but with 30000+ bike models I assume that it is the most comprehensive website with bikes produced worldwide, even if in the early years there are much lower number of bikes per year, compared with 2000s and 2010s.

Motorcycle database was created and launched for sale in May 2016, with 43 fields (columns) found on common 2-wheeler models. After first release, I started browsing other bikes and found additional data fields which I included in the August 2016 update, having 62 columns, after this I re-started looking at bike models with most fields filled up and found that they have even more fields not yet included, so I released final version in September 2016 with 71 columns. For example, August 2016 release include 0-100 kmph available for 1% of bikes, and after this I found that other bikes contain also 1/4 mile and 60-140 kmph in highest gear. There is possible that Bikez.com to have even more data fields but they are available for so small amount of bikes that does not add any value to my bike database.

List of major bike manufacturers

You can open sample file and click Statistics sheet for full list of 473 makes. For SEO purposes I list here the 55 makes with more than 100 models:

AJS, Aprilia, Arctic Cat, Ariel, Benelli, Beta, Bimota, BMW, Cagiva, CCM, Daelim, Derbi, Ducati, Enfield, GAS GAS, Gilera, Harley-Davidson, Hercules, Honda, Husaberg, Husqvarna, Hyosung, Indian, Kawasaki, Keeway, Kreidler, KTM, Kymco, Lambretta, Laverda, Maico, Malaguti, Moto Guzzi, Moto Morini, MuZ, MV Agusta, MZ, Norton, NSU, Peugeot, PGO, Piaggio, Rieju, Sherco, Suzuki, Sym, TGB, TM Racing, Triumph, Ural, Veli, Vespa, Victory, Yamaha, Zündapp.

Bike data fields included

Naming: Make 100.00%, Model 100.00%, Year of launch 100.00%, Category 100.00%, Price as new (MSRP) 19.90%.

Engine and transmission: Displacement (cm³) 98.21%, Engine details 12.70%, Engine type 99.96%, Power (PS) 66.25%, Power (rpm) 58.45%, Torque (Nm) 38.57%, Torque (rpm) 35.67%, Top speed (kmph) 34.38%, 1/4 mil (sec) 0.24%, 0-100 km/h (sec) 0.99%, 60-140 km/h, highest gear (sec) 0.43%, Max RPM 1.65%, Compression 60.67%, Bore x stroke (mm) 74.43%, Valves per cylinder 41.40%, Fuel system 68.59%, Fuel control 56.28%, Ignition 39.51%, Lubrication system 24.41%, Cooling system 87.82%, Gearbox 84.70%, Transmission type, final drive 83.99%, Clutch 34.40%, Driveline 17.39%, Fuel consumption (l/100km) 11.80%, Greenhouse gases co2 (g/km) 11.80%, Emission details 6.76%, Exhaust system 14.24%.

Chassis, suspension, brakes and wheels: Frame type 39.30%, Rake (fork angle) 20.87%, Trail 15.62%, Front suspension 60.66%, Front wheel travel (mm) 26.73%, Rear suspension 59.40%, Rear wheel travel (mm) 26.11%, Front tyre 80.65%, Rear tyre 80.70%, Front brakes 95.04%, Front brakes diameter (mm) 43.51%, Rear brakes 94.31%, Rear brakes diameter (mm) 41.96%, Wheels 19.13%, Seat 12.36%.

Physical measures and capacities: Dry weight (kg) 59.41%, Weight incl. oil, gas, etc (kg) 36.73%, Power/weight ratio (HP/kg) 39.01%, Seat height (mm) 57.98%, Alternate seat height (mm) 1.60%, Front percentage of weight 0.64%, Rear percentage of weight 0.18%, Overall height (mm) 37.59%, Overall length (mm) 52.70%, Overall width (mm) 43.38%, Ground clearance (mm) 32.88%, Wheelbase (mm) 62.19%, Fuel capacity (litres) 80.98%, Reserve fuel capacity (litres) 8.62%, Oil capacity (litres) 7.75%.

Other specifications: Color options 55.04%, Starter 62.76%, Instruments 7.14%, Electrical 6.69%, Light 4.57%, Carrying capacity 5.74%, Factory warranty 10.16%, Comments 30.69%, Modifications compared to previous model 0.95%.

Completion percentages calculated in March 2017 edition.

List of updates

400+ brands, 25747 models – May 2016, first release!
444 brands, 29403 models – September 2016
468 brands, 30619 models – March 2017
473 brands, 30933 models – July 2017
473 brands, 31280 models – December 2017
477 brands, 31986 models – May 2018
479 brands, 32101 models – October 2018

How often do you want updates? (Motorcycles database)

Every month
Every 3 months
Every 6 months
Every year
One-time project, not interested in updates
Other
Please Specify:
Created with PollMaker

Car Models Database with body styles & dimensions

Download SAMPLES (one make):
Car Models Database.XLS for general use
Car Models Database.CSV (BETA) for programming
Car Models Database.SQL (BETA) for web developers
Feel free to test CSV and SQL, if they are OK I will sell the full database in these formats beside Excel format.

Buy FULL database + FREE updates for one year:

Last release: 10 August 2018, including 46 models launched 2017 and 21 models launched 2018, see changelog.

Car Models Database

Description & history

Started in 2005, originally a research-analysis to compare cars and study evolution in terms of dimensions, weight and engines. For example Golf 1 (3705 mm length, 1100-1800 cm³, 50-112 PS), vs Golf 5 (4204 mm length, 1400-3200 cm³, 75-250 PS). However, since started selling in 2012, its typical customers are car shipping companies pricing transport costs by car dimensions, or car cover manufacturers.

At least one customer bought this Car Body Specs Database (SURPRISE!) not for body specs, but just for list of car body types. Previously I was adding car models only when/if data of car dimensions was available, but since 2013 I choose as ultimate goal to add EVERY car manufactured after World War II, even if no dimensions are available, over time I may find dimensions and complete the table.

Car Models Database contains separate row for each car body style, showing basic data:

Car dimensions (length, width, height, wheelbase, cube) with 99% completion for 1980-present and 75% for 1945-1980.
Car weight range and cargo space with 99% completion for 1980-present.
Car engine range (displacement, horsepower and top speed), for 1980-present (except for cars not sold in Europe).

Coverage

European-produced cars 1945-present, Asian imports 1970/1980-present, American imports 1990-present, for more details see List of car manufacturers and years included.

Bonus: some Asian cars not imported in Europe, for example Malaysian cars (Proton’s all 15 models, not just the two imported in continental Europe, Perodua’s 10 models, none imported in continental Europe but few imported in United Kingdom). Add-on with cars produced in India, Brazil and Argentina (added during 2013).

This is NOT a database of Latin America / India market. I guarantee completion for European market ONLY. Indians and Latin Americans can buy European database + add-on of vehicles produced locally, delete yourself the vehicles not imported in your country and request me to add if there is any additional foreign models available in your country but not in European database!

Source of data: AutoKatalog for 1980s-present (99% data completion and accuracy guaranteed), and Wikipedia for older automobiles (expect some mess and missing data in pre-1980s). All data written manually in Excel, making an original product “Made by Teoalida”.

Sorting order: alphabetic by make, followed by class from mini to luxury cars, followed by model from old to new, followed by body style. You are advised to NOT change sorting order for example do not sort models alphabetically.

This vehicle database focus on model only and breakdown for body type (sedan, wagon, coupe, convertible, etc). There are NO list of car engines. For breakdown by individual engines, see Car Models & Engines Database.

List of car makes included

Mainstream makes: AC Cars, Alfa Romeo, Alpine, Alvis, ARO, Asia Motors, Aston Martin, Audi, Austin / Rover, Austin-Healey, Autobianchi, Auto-Union, Bentley, BMW, Bond, British Leyland (Austin, MG, Mini, Morris, Riley, Rover, Triumph, Vanden Plas, Wolseley), Buick, Cadillac, Chevrolet USA, Chrysler USA, Chrysler Europe / Simca / Talbot (France) / Sunbeam / Hillman / Talbot (UK), Citroën, Dacia, Daewoo / Chevrolet Korea, DAF, Daihatsu, De Tomaso, DeLorean, Dodge, Ferrari, Fiat, Ford Europe, FSO, GAZ (Volga), Honda, Hummer, Hyundai, IFA (Trabant, Wartburg, Barkas), Infiniti, Innocenti, ISO, Isuzu, Iveco, Izh, Jaguar, Jeep, Kia, Lada, Lamborghini, Lancia, Land Rover, Lexus, Lotus, Maserati, Matra, Maybach, Mazda, Mercedes, Mini, Mitsubishi, Morgan, Moskwitch, Nissan, NSU, Oltcit, Opel, Otosan, Perodua, Peugeot, Pontiac, Porsche, Proton, Reliant, Renault, Rolls-Royce, Saab, Samsung, Santana, Seat, Skoda, Smart, SsangYong, Standard-Triumph, Subaru, Suzuki, Tatra, Tesla, Tofas, Toyota, TVR, UAZ, Vauxhall, Volkswagen, Volvo, Zastava, ZAZ.

Bonus minor makes: Artega, Bitter, Bristol, Bugatti, Caterham, Cizeta, Donkervoort, Felber, Fisker, Ginetta, GTA Spano, Gumpert, Isdera, Jensen, Koenigsegg, LuAZ, Lynx, McLaren, Messerschmitt, Monica, Monteverdi, Pagani, Panther, Saleen, Shelby SuperCars, Venturi, Wiesmann, ZIL (producing less than 100 cars per year).

List as September 2017. Italic makes to be added in next release. Additional minor makes may be added in the future.

Discontinued: Timeline database

Download SAMPLE: Car Models Database Timeline version.XLS

Same rows, but sorted by class and year instead of alphabetic by make, useful for my personal research but difficult to maintain and check for missing models.

This was the only database format since 2005 to December 2012, when I re-sorted database alphabetically and sold both versions in same package but the timeline had a lag in updates. I updated the Timeline version and offered of sale both versions separately at main yearly update of November 2013, but due to customers preference for alphabetic version, I no longer updated Timeline version since May 2014 and removed from sale at end of 2014.

Timeline version’s purpose is to visualize car evolution over years, and in 1 year NOBODY bought for this purpose.

Car Models Database Timeline

Future of this database – I need your feedback!

I was thinking in March 2016 to offer a major update for Car Models Database after Car Models & Engines Database will be fully expanded to 1970, which was going to happen in 2017 but I left it for 2018 to prioritize other projects. I will recheck every car and add correct dimensions, weight and engine range from the expanded bigger database.

Until that, I will offer minor updates with new cars added and with dimensions only.

Some things that need to be decided:

– Cars that had a mid-life facelift that changed external dimensions only slightly do not have a separate row, instead they have in Notes column “Length X mm after year Y”, would be better if I make separate row for every slight variation of dimensions, or this will make unecessarily too many rows?

– Make & Model & Platform controversy: since I started this database in 2003, until I published on website and started selling in 2012, there was a single column “Car name”, starting from 2012 I made columns Make and Model, since 2014 I made 4 columns Make, Model-Platform, Model, Platform. May I know how are you using these 4 columns? I am questioning if this is the best format or I can improve it even further, for example I am thinking to remove (facelift) from model names, and add instead production years to differentiate pre- and post-facelift models

– If you have any better proposal, let me know!

Survey

Car specifications vary from country to country where a car is sold, but overall car dimensions are usually the same. If 90% of database sales are done by European customers, should I expand the database by including cars not sold in Europe (such as Japanese Domestic Market cars)?

NO! We are Europeans and we don’t want cars that are not sold in Europe. Or we are not Euopeans but if you cannot make a database complete worldwide, then don’t bother adding more cars, just stick on cars sold in Europe.
YES! Add as many cars is possible that are not sold in Europe, since June 2015 you offer a column “sold in Europe”, European buyers can delete themselves the cars that are not sold in Europe
YES! Add as many cars is possible that are not sold in Europe, even if you cannot add ALL cars sold all over the world, and sell Car Models Database Europe edition / Worldwide edition as you do with Car Models List
Other
Please Specify:

Poll Maker

Year Make Model Trim Specs for American Market

Year Make Model Specifications car database for American marketYear-Make-Model-Trim-Specs is the best car database for people angry due to closure of Edmunds API or tired of CarQueryAPI’s missing cars, I sourced most fields from Edmunds, added 4 extra fields from my experience, done some changes to improve model hierarchy and created an Excel database with completeness and accuracy having no equivalent on internet.

Download free SAMPLES:
Year-Make-Model-Trim (7 columns)
Year-Make-Model-Trim-Basic-Specs (31 columns)
Year-Make-Model-Trim-Full-Specs (86 columns)
Alternate formats: CSV (Full Specs)

For people looking for more columns I offer since December 2017 second American car database, with 230 columns but less historical coverage and less accuracy. Choose which suit you better.

One of my programmer partners made also a JSON API. Whenever you can use it or not, you decide.

Buy FULL database + FREE updates for one year:

Last release: 27 November 2018, including 2911 models of 2018 and 1707 models of 2019. Full changelog.

The trims database does have same number of rows but just first 5 columns, making duplicate rows for each trim due to differences such as FWD / 4WD, manual / automatic, different engine, different features, etc. A proper car trim database, filtered from trim duplicates, require additional dozens of hours of work too much considering how many sales it can get. Should do this job?

Additional proposed format: Year-Make-Model-Dimensions, there are some vehicles offered with multiple dimensions for same body style, example: Lexus LS short and long wheelbase, Ford F-150 short and long truck bed, etc. They have duplicate Year, Make, Model, Body which can pose a potential problem for integrating database in a website. Including trims would be NOT the right solution because would increase number of rows significantly for no reason and Ford F-150 have same trim in multiple bed lengths. Can someone suggest the best solution for these vehicles?

American car database coverage

Complete for all cars, trucks, SUVs and minivans sold in United States from Model Year 1990 to present. Exotic makes (Ferrari, Lotus, Maserati, etc) which are MY 2001 onward. Vehicles sold in Canada but not in United States are NOT included as they are included in Year-Make-Model which is based on Wikipedia. Certain technical data (valves, cam type) is available for MY 2001 onward. This is due to the website I based my database on.

Apparently they changed source of data for MY 2001 as some cars like Mercedes C43 AMG were listed as separate model for MY 2000 and as trim under C-Class for MY 2001, had to correct these model naming issues manually. The specs are consistent before and after MY 2001 change.

Cars are sorted by make and model alphabetically, by year old to new, then by trim from low to high. You are advised to NOT mess up the order when importing in your database.

Are you interested in automobiles older than 1990? I am interested too, for my personal research and for selling such database! Show me a website having older vehicles displaying at least car engine size, power and dimensions, and I will see if I can copy data from it!

List of car makes

Acura, Alfa Romeo, AM General, Aston Martin, Audi, Bentley, BMW, Bugatti, Buick, Cadillac, Chevrolet, Chrysler, Daewoo, Dodge, Eagle, Ferrari, Fiat, Fisker, Ford, Genesis, Geo, GMC, Honda, Hummer, Hyundai, Infiniti, Isuzu, Jaguar, Jeep, Kia, Lamborghini, Land Rover, Lexus, Lincoln, Lotus, Maserati, Maybach, Mazda, McLaren, Mercedes-Benz, Mercury, Mini, Mitsubishi, Nissan, Oldsmobile, Panoz, Plymouth, Pontiac, Porsche, RAM, Rolls-Royce, Saab, Saturn, Scion, Smart, Spyker, Subaru, Suzuki, Tesla, Toyota, Volkswagen, Volvo.

If you are not from USA and you are concerned if this database will work for your country, check list of models included in database.

Data fields included

This car database contain 62 columns with following completion percentages (calculated from May 2018 edition with 54030 vehicles).

Naming: ID 100%, Make 100%, Model 100%, Year 100%, Trim 100%.

Price and colors: Price (2001-present) 76.46%, Colors exterior 96.02%, Colors interior 79.91%.

Dimensions and weight: Length 99.57%, Width 98.13%, Height 98.28%, Wheelbase 99.84%
Curb weight 89.47%, Gross weight 53.87%, Maximum payload 46.05%, Maximum towing capacity 53.68%.

Engine and transmission: Cylinders 99.62%, Engine size 99.65%, Horsepower (HP) 98.71%, Horsepower (rpm) 98.71%, Torque (ft-lbs) 98.45%, Torque (rpm) 98.45%, Valves (2001-present) 76.05%, Valve timing (2001-present) 52.67%, Cam type (2001-present) 76.05%, Drive type 100%, Transmission 99.03%.

Fuel and mileage: Engine type 99.97%, Fuel type 99.93%, Fuel tank capacity (gal) 99.04%, Combined MPG 85.54%, EPA mileage 85.34%, Range 84.54%.

Interior dimensions: Front head room 93.31%, Front hip room 76.09%, Front leg room 92.58%, Front shoulder room 90.28%, Rear head room 80.37%, Rear hip room 65.66%, Rear leg room 79.91%, Rear shoulder room 78.35%.

Other dimensions: Front track 51.43%, Rear track 51.29%, Ground clearance 63.16%, Angle of approach 26.05%, Angle of departure 26.07%, Turning circle 86.46%, Drag coefficient 20.39%, EPA interior volume 32.44%, Cargo capacity 62.68%, Maximum cargo capacity 41.38%.

Warranty: Basic 74.99%, Drivetrain 73.86%, Roadside 56.25%, Rust 28.74%, Free maintenance 18.51%, Hybrid component 2.71%, EV battery 0.20%.

Bonus: Domestic / imported 100%, Country of origin 100%, Car classification 100%, Platform code / generation number 100%.

Analysis of American car evolution

I offer free of charge an analysis of how cars evolved from 1990 to 2018, open sample file of full specs database and click “statistics data history” sheet. You can see average values for every year, for each column in database, breakdown by domestic and imported cars, calculated using Excel AVERAGEIFS formulas.

For example average engine size rose from 3.33 L in 1990 to 4.09 L in 2007 then dropped to 3.49 L in 2018 due to downsizing and introduction of turbochargers, meantime horsepower rose from 142 HP in 1990 to 295 HP in 2018.

Poll

How often do you want updates? (Year-Make-Model-Trim-Specs)

Every month
Every 3 months
Every 6 months
Every year
One-time project, not interested in updates
Other
Please Specify:
Created with Poll Maker

Car Models List

Car Models ListFREE version include complete list of manufacturers and list of models for 4 manufacturers, one for each continent.
PAID version have 160+ makes, 5000+ models in Worldwide version / 120+ makes with 2500+ models in Europe version.

Last release: January 2019. Full change log.

Download SAMPLES:
Car Models List.XLS for general use
Car Models List.CSV for programming
Car Models List.SQL for web developers

Buy FULL database + FREE updates for one year:

Coverage: World War II – present. Few pre-war classic automobiles are included too, if they are related with post-war ones.

All major (and few minor) manufacturers of Europe, United States, Australia, Japan, Korea, Malaysia, India, Brazil, Argentina.

Source of data: mostly Wikipedia, the most comprehensive car database ever! I manually compiled the list of cars into an Excel database, creating an original product “Made by Teoalida” with no equivalent on internet! Excel allow for easy reading, sort, filter, as well as conversion to CSV and SQL database to be used in web building.

The list include model generations (example: VW Golf IV), platforms (example: BMW E46), chassis code (example: Mercedes W124), with exact years of production for each of them. If you want just model names, without separate row for each Golf I to Golf VII, you should use Car Nameplates List instead.

Commercial vehicles under 3.5t are included too. No concept cars or prototypes, only vehicles sold in world markets.

Make, model, car classification, years produced or Model Years of sale in United States and Canada.

There is also a column for number of units produced, but I was able to find this info for only 8% of total models, mostly exotic cars, so if you are looking for a production figures for all cars, this Car Models List will NOT help you.

Notes

I guarantee 100% completion for European and North American markets, plus for the market of the country of origin of each manufacturer. For example the Car Models List may not include any possible cars produced in Korea and sold somewhere else than EU, US, or Korea markets. This because Korea and Japan manufacturers often sell ONE car model under dozens of different names in various countries. There are over 200 countries in the world, making a global world complete database for every country is HARD JOB. But you can contribute!

Cars produced in China are not included in current edition due to insufficient data available online. You can see on Wikipedia pages of each manufacturer from China, many links to individual models are red (non-existent pages), nowhere is indicated production year for each model. Other websites are also incomplete and contradictory.

The Worldwide edition include also the sheet of Europe edition.
The Europe edition include all markets from United Kingdom to Russia and Turkey, does not focus only on Western Europe.
For North America I offer a different database in Year-Make-Model format instead of Make – Model – Start year – End year.

Car Models List does NOT go into more details than model. If you need more details such as engine version or trim, check my other databases: Car Models & Engines Database (Europe) and Year Make Model Trim (United States).

India vehicle database: cars, bikes, trucks, buses

India car databaseDownload SAMPLE database (one make)
Make, model, version, no specs (5 columns)
Make, model, version, basic specs (26 columns)
Make, model, version, full specs & features (188 columns)
Alternate formats: CSV and SQL (full specs & features)

See list of updates. You can purchase a smaller package and later pay the difference to a bigger package.

Scroll down for bikes, trucks, buses, car dealers and other stuff.

Buy FULL database (all makes)FREE monthly updates:

Description

In August 2015 I learned to scrap data from websites, the India car database was my first scraping project, as opposite of the manually-written European car databases that I am making since 2003. Lots of people were asking me if I have an indian car database, that times nobody was selling.

Source of data: Carwale.com, which removed discontinued models in March 2017, so my database contains valuable data that you cannot get yourself from Carwale anymore. Unfortunately India do not have a quality car website that display years produced for every car version (as I personally wanted). Database contains production years indicated only for discontinued models and only if there are multiple generations of same model. Not good in my opinion but there was no other alternative. HAD TO DO IT in this way. If you know other better source of data please tell me. 

Personally I viewed web scraping as copyright issue and cheating way to make databases, but most people are not against web scraping. Personally I am interested only in CARS, but people asked me if I can scrap data for BIKES, TRUCKS, BUSES, car dealers and other stuff. And I did! For additional data scraping please ask!

India database coverage

Mid-1990s to present, meaning that the database is complete for all cars ever imported in India.
Do note India car market boomed only in late 1990s and especially during 2000s. In early 1990s the ONLY cars available were Maruti (dominant passenger cars), Mahindra and Tata (off-road and commercial vehicles), Hindustan and Premier (outdated passenger cars).
Daewoo was the FIRST foreign car manufacturer to enter in Indian market (1994), followed by Ford and Opel (1996), Fiat (1997), Honda and Hyundai (1998).

List of makes included

Ashok Leyland, Aston Martin, Audi, Bentley, BMW, Bugatti, Caterham, Chevrolet, Chrysler, Datsun, Daewoo, DC, Eicher Polaris, Ferrari, Fiat, Force Motors, Ford, Honda, Hindustan Motors, Hyundai, ICML, Isuzu, Jaguar, Jeep, Lamborghini, Land Rover, Lexus, Mahindra, Mahindra Renault, Maini, Maruti Suzuki, Maserati, Maybach, Mercedes-Benz, Mini, Mitsubishi, Opel, Nissan, Porsche, Premier, Renault, Rolls-Royce, San, Skoda, Ssangyong, Tata, Toyota, Volkswagen, Volvo, Willys.

Expected to be launched in India in 2018: Acura, Infiniti, Tesla.

Data fields included

Naming: ID, Make, Model, Version, Status 100%.
Price: Production cars 30.65%, Discontinued cars (last recorded price) 69.35%.
Body: Length (mm) 99.70%, Width (mm) 99.70%, Height (mm) 99.67%, Wheelbase (mm) 99.54%, Ground clearance (mm) 59.27%, Kerb weight (kg) 61.11%, Bootspace (litres) 48.75%, No of doors 99.54%, Seating capacity 99.57%, No of seating rows 72.36%.
Engine: Displacement (cc) 99.21%, Max power (bhp) 99.43%, Max power (rpm) 99.21%, Max torque (Nm) 99.43%, Max torque (rpm) 99.73%, Transmission type 99.78%, No of gears 97.15%, Drivetrain 86.74%, Engine type 87.39%, Cylinders 72.17%, Bore x Stroke (mm) 13.18%, Compression ratio 9.16%, Valves per cylinder 69.73%, Dual clutch 60.92%, Sport mode 61.74%, Fuel system 31.33%, Turbocharger/supercharger 50.60%, Turbocharge type 50.16%, Driving modes 51.01%, Manual shifting for automatic 50.03%, Engine start-stop 49.78%.
Fuel: Fuel type 99.67%, Alternate fuel type 63.53%, Mileage (kmpl) 87.31%, Fuel tank capacity (litres) 96.30%.
Drivetrain: Suspension front 91.30%, Suspension rear 90.68%, Brake type front 98.48%, Brake type rear 98.23%, Steering type 50.87%, Turning radius (m) 80.14%, Wheels 50.95%, Spare wheel 68.53%, Tyres front 71.28%, Tyres rear 71.22%.
Others: Colour names 93.89%, Colour RGB 93.89%, Image URL 87.85% (you can use Tab Save extension for Chrome to download image files).
Features: 131 columns, see SAMPLE file, I do not list them here to overload the page with too much text.
Bonus: Car class, Body style 100.00% (added manually from my personal experience, NOT scraped from website).

Percentages as 1 January 2017 (3680 cars).

How was made & quality notes

While the European car database is made via manual data entry (thus adding new data constantly), and American car database is a mix between manual work and automatic web scraping, the Indian car database is just a web scraping job.

Good news: easy to update. Bad news: I sell “as it is” without corrections or filling missing data. A customer asked me if I can add body type column (hatchback, sedan, convertible, etc). I can add for a fee, but at each update any additional data will be lost, so I would need to charge the adding fee again = not cost-effective.

Typical programmers charge $300-500 to build a web scraper (example), plus $50-100 for each update. You can buy ready data from me for $30-120 with free monthly updates for one year.

is OK to scrap data from websites using automatic software, instead of compiling data manually in Excel?

YES, scraping is legal and a nice way to get the data faster, I am willing to pay you for a database that is scraped from somewhere and not your original work
NO, scraping is illegal, means stealing data from a website that invested a huge effort in making their database, scraping produce a database too similar with the source website, causing copyright trouble for people who buy the database and use in their own websites. You NEED to compile data manually and make original content, different than the source.
I don’t care how the data was obtained, scraped automatically or compiled manually, as long the data is accurate and error free, and you check it manually and correct errors if necessary
Other
Please Specify:

Poll Maker

Future updates will be only for new cars… sorry for this

Indian car database launched for sale in August 2015, and after doing ~8 sales and 3 updates, I decided in May 2016 to offer monthly updates on 1st day of month. Each update takes 8 fours of data scraping + 2 hours post-scraping manual work. I scrap every make to get models, every model URL to get versions, every version URL to get specifications, remove all data from previous update and put new data. See list of updates.

In February 2017 Carwale decided to hide discontinued models from website. I kept updating database by scraping for new versions URL, add them into database, compare the unique ID, delete duplicates, then scrap all versions URL to get specifications including current price and last recorded price that indicate whenever a car is in production or discontinued.

In November 2017 Carwale removed unique ID from each URL, causing all URLs to be changed and redirected, in 10 cases the old version URLs redirect to 404 Not Found, in 197 cases the old version URLs is redirecting to a different car that it should (multiple old URLs redirect to same new URL), making me impossible to re-scrap old cars for updates without risking loss of model versions. I will continue to update database monthly by adding new cars, but without updates for old cars, database quality will go down over time, when a model is discontinued and replaced with a new model with same name, discontinued model name will not be updated with production years to differentiate from current production model, specifications including prices will also not be updated for old cars, etc.

India bikes database

One of the first people who bought the Indian car database in August 2015 wanted a 2-wheeler database too. Initially I said NO because I was personally interested only in cars, but once I mastered my data scraping skills, I decided to offer web scraping services for individual customers. In January 2016 another customer wanted to scrap bike specs from Bikewale.com, this was the moment I created bike database . I update every few months when I got new sales.

Initially in 2016 Bikewale was showing only current production models, the discontinued models being added near end-2016 but I was not aware of until October 2017. I updated database raising number of models from ~250 to over 600. Note: if a bike have multiple versions, database contains specs of base version, because the versions do not have a distinct URL, proper scraping is impossible.

Download FREE sample

Bikes Database.xls

Buy full database

Dealers database

Several people told me to scrap dealer information from Carwale and Bikewale. Here is the database containing dealer name, street address, email and phone number.

Download samples:

India-Car-Dealers-SAMPLE.xls
India-Bike-Dealers-SAMPLE.xls

Buy full database:

Trucks and buses

I made them in September 2016 for a customer who never paid for the job he requested me to do. First person to purchase them came in January 2018 so I updated them for first time, future updates will be done at request.

As August 2018 I noticed that CarDekho made each version URL to redirect to main model URL, effectively making me impossible to scrap specifications of other versions than base version. Probably I will never update them again. Only 3 people purchased them so does not worth my effort to keep maintaining.

Download FREE samples

Trucks Database.xls and Buses Database.xls – Easy job, source of data: CarDekho.com.

Buy FULL database

Other databases

CarWale On-Road Prices.csv – A very difficult job which involved about 20 hours of coding in Visual Basic to make an application sending javascript requests to CarWale website to get price of each car in each city, application works at a rate of 2 requests per second, so 3100 cars × 510 cities = 1632000 seconds = 226 hours needed to get all on-road prices, RTO tax and insurance. The empty cells is because certain cars are available only in selected cities (Aston Martin only in Mumbai, Maruti is available in 500+ cities).

Due to time required to scrap all cities, I done future updates MONTHLY for a shortened list of 47 cities that takes about 22 hours and asked customer to pay for each update.

Goods and Services Tax was implemented on 1 July 2017 and harmonized car prices across India, the customer told me that updates are no longer required.

Used cars – Scraping used cars websites is a big stupidity in my opinion, since they are never complete, cars are removed from site once their owners found a buyer, you are not getting any usable data, but someone told me specifically to scrap an indian used cars website. CarDekho was the easiest to scrap, and have 45000+ cars.

Buy FULL database


DO NOT ask me about car owners database!

A number of people have trouble understanding what I am selling or don’t bother to check samples of what I am selling (database of car MODELS with specifications and features), they ask me straight to sell them a database of car OWNERS with registration number, name, address, profession, phone, email, insurance expiry date, etc. Strangely I do not get such questions from Europe and America, but ONLY from India.

I DO NOT have registration / owners data, and the companies who does have (car dealerships and insurance companies) must follow personal data protection laws and DO NOT share data of their customers to third-parties.

If you do a google search “car owners database” you see at least 10 sites selling personal data illegally, all them from India, the only country in the world where people have no respect for personal data and email/SMS spamming is national sport. But I am skeptical about how real is this data, how it was obtained and how updated it is, considering that vehicle registration authority do not keep records of emails and phone numbers, but only of residence address. Furthermore, most drivers do not even use email!

The only way to get car registration data legally and up-to-date is to apply in vahan.nic.in “The Ministry has decided to offer the services to different stake holders like Banks, Insurance Companies etc on payment basis.” If you do apply, please inform me what are their prices.

Possible upcoming projects… waiting for feedback!

New database ideas are welcome, as well as suggestions for improving data structure! If there are multiple people interested, I will do them!
Having too many Excel vehicle lists means more time necessary to update each of them. Also, some customers get confused and complained that I already have too many products for sale, so… I will develop only products that people are demanding!

Supercars database

Fans of Ferrari, Porsche, Corvette, etc, as well of C63AMG, M3 and S4, can get what they wants without paying the high price of all cars database. Just tell me what amount of technical specs should be included the database for sport cars.

EuroNCAP crashtest database

Someone suggested this in November 2013. If more people are interested in this project, I will do it! Tell me if it should contain overall star rating or… how many details I need to include about each crash test?

Car photo database

Started in May 2013 and put on hold, due to controversy regarding what kind of photos should be offered, and possible copyright issues. You feedback is needed to continue the project! Check this page Car photo database.

Engine codes database

Someone asked this in 2013. I can add the codes in Car Engine Specs Database for BMW and Mercedes as Wikipedia provide them… but how about the rest of brands? From where I can take the codes?
As early 2015 I found websites like http://www.buycarparts.co.uk/ displaying engine codes for most of brands. Car model names are different than in my database, so will be a pain in the ass to add correct codes to correct models and impossible to reach more than 80-90% completion, I leave this job for a later time when I will have more free time.
Starting from 2015 I found that is more profitable to create additional databases for other markets (USA, India, etc) than expanding European database with engine codes.

Car Models + Simplified Engine List

Thank you to an Indian who gave me this idea in February 2013, unfortunately I do not have knowledge to make a complete list of cars sold in India at a reasonable data accuracy. I am looking for potential customers in Europe interested in this thing!
See SAMPLE, it is based on Car Models Encyclopedia.DOC and recompiled in .XLS format to be usable for webdesigners.

You can help me to take RIGHT decision! Do I should…
– add production years, per model or per each engine?
– Mercedes E320 changed from in-line-6 to V-6 in 1997, should be on same or separate rows?
– BMW 325d, 330d, 335d, all having 3.0 litres engine, different power versions, should be on same or separate rows?

Alternatively, I can scrap from Car Engine Database aka delete the duplicate engine rows caused by multiple body types and multiple transmission options, and let only engine data.

A web-based searchable automobile database

I came in December 2012 with the idea of making an automobile blog with 1 post per car model (see SAMPLE) something similar with Car Models Encyclopedia currently available in Word format. It may display car photos and an undecided amount of technical specs. This is a subject of DISCUSS, especially regarding photo format.
Few months later some visitor suggested that an online car database should store data in MySQL instead of static posts, to allow comparisons and car reviews. This exceed my abilities. That times I knew NOTHING about MySQL or how dynamic websites work.
Developing websites require time and money. Most of the customers who are buying vehicle database are businesses, auto parts shops, shipping companies, car classifieds websites, etc, they may use my database for their website but the cost of website is funded from their businesses. Personally I do NOT have any business in automotive industry so making a website just to offer info…. how I can make revenue to cover my time and expenses? (no Adsense please, it never produce significant income).

America vs Europe vs rest of world

If you are a business working globally rather than in a specific country, or working in some other country than the countries covered by my standard car databases, you may be looking for a global car database.

But… this is not really possible. Car specifications vary between country to country for models having same name, and for accuracy reasons, a car database should be specific to one country, or with some compromise of quality, to one continent.

Over years I gained reputation for providing most accurate and complete databases, because I offer separate car database for each market of sale, containing ALL and ONLY car models sold locally and data is formatted according tastes of local people. Car Models & Engines Database collect data from European car dealers while Year-Make-Model-Trim-Specs collect data from American car dealers.

Some customers asked “I need a database containing European cars (BMW, Skoda, etc) and Japanese cars (Nissan, Toyota, etc), we have all them in Brazil“. You CANNOT buy a single database of “all cars made in Japan” because they vary depending by market of sale.

Example: Toyota sold the following models in calendar year 2015 / US MY 2016:

  • In United States: 4Runner, Avalon, Camry, Corolla, Highlander, Land Cruiser, Mirai, Prius, Prius c, Prius v, RAV4, Sequoia, Sienna, Tacoma, Tundra, Yaris.
  • In Europe: Auris, Avensis, Aygo, Corolla, GT86, Hilux, iQ, Land Cruiser, Mirai, Prius, Prius+, RAV4, Urban Cruiser, Verso, Verso-S, Yaris.
  • In Australia: 86, Aurion, Camry, Corolla, FJ Cruiser, Fortuner, Hiace, Hilux, Kluger, Land Cruiser, Land Cruiser Prado, Prius, Prius C, Prius V, RAV4, Rukus, Tarago, Yaris.
  • In India: Camry, Corolla, Etios, Fortuner, Innova, Land Cruiser, Land Cruiser Prado, Prius.
  • In whatever other country: possible other models.

Furthermore, there are several distinct cars named Toyota Corolla E120 (2000-2007):

  • Corolla sold in Europe is offered in hatchback, saloon, estate versions, with engines 1.4 (97 PS), 1.6 (110 PS), 1.8 turbo (192, 224 PS), 1.4 diesel (90 PS), 2.0 diesel (90, 110, 116 PS).
  • Corolla sold in North America is offered only in saloon version, with engines 1.8 (130, later 126 PS) and 1.8 turbo (170, later 164 PS).
  • Corolla sold in Australia is offered in hatchback, saloon, estate versions, with engines 1.8 (136, later 126 PS) and 1.8 turbo (192 PS).
  • Another Corolla is sold in Japanese domestic market with narrower body to comply with compact size tax regulation.
  • Additional different-specs Corollas are sold in Asia, Africa, Latin America, etc.

 

The ONLY type of database that CAN cover multiple markets (without risking accuracy) are Car Models List and Car Nameplates List, this was possible because these two do not contain engines, dimensions or any other specifications, but just model naming and production years.

A couple of customers choose to purchase multiple databases from me. I did not asked everyone how they use data, but I advise you to make separate sections on your website for each region. Do not mix up my multiple car databases, or you will end up in a mess that will displease any customer.

There are several websites like www.carfolio.com having worldwide cars, which I could make a script to scrap data and create an Excel database, but I do not do this because data quality will be a disaster.

There are also data providers like www.carqueryapi.com selling apparently a worldwide database but you should be careful in purchasing from them because their database is not complete for any given market. Some of my happy customers informed me that bought previously CarQueryAPI and had a major disappointment, missing models even from American and European markets, new models are added with delay of few years after they been launched, some model names are lowercase while others uppercase, certain values missing for random cars, etc. They bought from me afterwards and turned happy. Sadly, there are also people coming on my website and chatting with me then buying from CarQueryAPI just because is cheaper or website is simpler… stupid people who take cheap price over quality!

Model year (America) vs production year (rest of world)

North American car market is tightly regulated by government, all car models sold here are organized by Model Years. Most important, two successive models DO NOT share same Model Year (with few exceptions). Traditionally car models launched in second half of year are considered Model Year of next year, but legally manufacturers are allowed to launch “2017 Model” starting from 2 January 2016. Every year, they launch the “next year model”, even if the car is unchanged from previous year. New trims also appear in middle of model year.

Europe (and rest of world) do not have officially a car model year system, the year of a particular car is used only informally, and it’s the calendar year. So a car model launched in December 2016 is still a 2016 model. European car websites should show Make – Model – production years (as a range, no individual years).

I have seen some cheap-made websites targeting Europe but using drop-down vehicle list with each year on separate row, but since Europe do not have regulated Model Year, they used each calendar year in which a car has been manufactured. This is WRONG and leads to errors and confusion, in the year of model replacement, their list include both old and new models or just one of them at random.

Check yourself ebay.com/motors and ebay.co.uk/motors, see the difference? This makes combination virtually impossible, unless you adapt American database to European / rest of world format, which is not on the taste of American customers.

Americans doing their business in Europe or worldwide, argued with me saying that my European database is WRONG. Actually it is CORRECT for us. Me too, I considered the american system strange and wrong, until 2013.

More differences between Europe and America markets

From 1970s to 1990s many European and Japanese models sold in US had bigger bumpers, getting few extra inches in length compared with same models sold in rest of world.

Models are sold in US with less engine choices, usually top of range. Example: the 2007-2012 BMW 3-Series E90 have versions 328i, 335i, 335d, M3, while in Europe the versions are 318i, 320i, 325i, 330i, 335i, 316d, 318d, 320d, 325d, 330d, 335d, M3.

Sometimes US engines do not exist in rest of world. Example: VW Golf 6 is sold in US with a 2.5 liters 5 cylinders 170 PS engine which do not exists in Europe where all engines are 4 cylinders, ranging from 1.4 to 2.0 liters turbo, 80 – 200 PS.

US measure horsepower according SAE rules, usually getting slightly higher power than measured in European DIN standard.

US EPA measure fuel efficiency as miles per gallon, Europe measure in liters per 100 km. Conversion is theoretically possible, but due to different testing procedure, any given car tested in US will eat 10-20% more gas than when tested in Europe, making comparison difficult. Read more: fuel economy testing procedure.

Don’t trust any database claiming to be 100% complete worldwide!

European car market is 99%+ similar within European Union except United Kingdom and Ireland, and 90-95% similar for all 50 European countries. Eastern Europe have few additional cars produced locally, plus Russia gets few additional Asian cars which are not available in Western Europe, all them being included in my European database. United Kingdom car market is different by having less cars available, because not every manufacturer bother to produce cars in right-hand drive, also UK produce few additional cars sold only locally, again included in my European database.

Asia, Africa and Latin America car markets may be 60-80% similar with European market. If you do not have other options and don’t care about accuracy, buy European Database and tell me what other cars are available in your country, eventually delete the excess cars that are not sold in your country.

North American car market is unique. Most vehicles sold in US & Canada are not sold anywhere else. Many vehicles are sold with different specs in Europe and US even if they wear same name.

I offer Car Models List Worldwide including all models sold in Europe and North America and models sold in local market of non EU/US manufacturers, such as Japanese domestic market for Japan manufacturers (after a big effort in 2014). However it will be NEVER complete for all of the 200+ countries in the world, it DO NOT include cars manufactured in a given country and sold somewhere else but not in Europe, USA, neither in their own country’s market.

If do you need a worldwide database more detailed than a simple Make / Model list, things get very… COMPLEX. Car specs vary from one market to another. NOBODY can make a worldwide / global vehicle database for every 200+ countries in the world, at a reasonable accuracy.

The problem is that Japan and South Korea export SAME cars under dozens of different names in various countries. If this was not worse enough, same name is sometimes used in multiple countries for unrelated cars. For example: the Samsung SM3 produced in Korea is also sold in Mexico as Renault Scala and in Russia as Nissan Almera, unrelated with the well-known Japanese Nissan Almera sold all over Europe until 2007. This Russian Almera and its years (and dozens of other similar name changes) are NOT included in Car Models List. Ford do the same, see Ford Escort (Europe) and Ford Escort (North America).

People outside Europe and America have trouble finding a database suitable for their country

I got a customer from Arab world saying “I am looking for a car database that contains Nissan Patrol because most database I’ve seen miss it” this happens because most databases available online are for US market and Nissan Patrol is not sold there, my European database does contain Nissan Patrol, but won’t help him either, because Nissan sell in Middle East also Altima which do not exist in European database but exist in American database.

Other customers asked me “if my database contain certain Asian cars that are missing from most car databases” and refused to purchase my European database because they are not containing there as well. Indeed, I do not recommend customers outside Europe and America to buy from me, but I am curious… what alternatives you can buy?

Study: car evolution trends

Who have more photos such as the following ones, showing contrasts between old vs new cars, small vs big cars, please give me link to photo or email me the photo. I love collecting!

1959 Mini vs 2001 Mini Smart vs Maybach

Car length evolution

Car classification in Europe is not officially regulated, instead, it is defined in relative size with other cars.

Today the average lifetime of a car model is 6 years for compact and medium cars and 8 years for mini and luxury cars. Is normal for cars to grow over years, as technology advance and more gadgets should be included under body, but in Europe since 1990s, the cars are growing crazy with about 10-20 cm per model change, which is exaggerate, based on technology evolution, 5 mm per year is enough. This non-natural grow causes companies to abandon large models and introduce new smaller models below existing models.

Some brands do not follow the common class sizes, making cars with intermediate sizes, these are usually considered being part of the smaller class, causing further increase in size of car classes.

Seems that all European companies wants to make a car bigger than competitor’s cars of same class. This leads to 2 cm / year increase in average car length in each class. The cars get fatter also in width, this is an issue for parking design, since in most countries the parking lots are 2.5 m width, most compact cars were under 1.7 m width in 1998 but since 2008 most are over 1.8 m.

Common car classes 1960s to 2010s

During 1950s and 1960s, engine size played a bigger role in classifying cars than car dimensions. Citroën 2CV belong to economy class while Fiat 850 was a superior class despite of smaller size.

During 1970s the cars started being classified by dimensions, compact class (3.8 m, 4.0 m sedans), medium class (4.3 m), large class (4.6 m).

Due to oil crisis, there was a boom of cars smaller than compact class / small family cars around 3.5-3.6 m. Example: Fiat 127 (1971), Audi 50 (1974), Volkswagen Polo (1975), Ford Fiesta (1976), Austin Metro (1980), Talbot Samba (1981), also mini class around 3.3-3.4 m: Peugeot 104 (1972), Citroën LNA (1976), Fiat Panda (1980), Autobianchi / Lancia Y10 (1985).

During 1980s growth in dimensions was very slow. In early 1990s the classes were small class / supermini (3.6-3.7 m), compact class / small family (4.0-4.3 m), medium class / large family (4.3-4.4 m), large class / executive (4.7-4.8 m), luxury class (4.9-5.0 m).

During 1990s and 2000s the cars entered in a rapid growth. Many manufacturers abandoned the executive segment: Ford Scorpio (ended 1998), Rover 800 (ended 1999), Opel Omega (ended 2003), Peugeot 607 (ended 2010), Citroën C6 (ended 2012) and replaced their medium / large family models with a new model that its dimensions are nearer former large class / executive cars rather than medium class / large family cars, further aggravating the growth. No wonder that these cars had poorer sales than their predecessors, since most buyers choose cars based on car size, engine size, price, not based on model name or designated class.

The growth of small class / superminis allowed a boom of a new mini class: Renault Twingo (1993), Ford Ka (1996), Seat Arosa (1996), Volkswagen Lupo (1997), Audi A2 (2000), Opel Agila (2000), Citroën C2 (2003), Citroën C1 (2005), Peugeot 107 (2005). Note: mini class had existed since 1950s with Fiat 500 and british Mini. Most manufacturers introduced at least one model at bottom of range: Audi A3 (1996), Mercedes A-Class (1997), BMW 1-Series (2004), Alfa Romeo Mito (2008), Jaguar X-Type (2001).

Prestige brands like BMW and Mercedes add only 5 cm per model changes, allowing some compact / small family sedans to overtake their medium / large family cars. Example 2005 Volkswagen Jetta V (4554 mm) overtook 2005 BMW 3-series (4531 mm). A4, 3-Series, C-Class started being defined as “compact executive”.

During 2010s the growth in dimensions slowed down. We have mini (3.6 m), supermini (4.0 m), small family (4.3-4.7 m), large family (4.7-4.9 m), compact executive (4.6-4.7 m), executive (4.9-5.0 m), luxury (5.1-5.2 m). Opel Astra K (2015) is even smaller than predecessor, however surprises can appear from the other manufacturers.

MPV and SUV followed same rapid evolution during 1990s and 2000s.

Renault Espace (1984) was the first European MPV (short and tall car with 7 seats), only 4260 mm long. Renault Mégane Scénic (1997) was the first MPV on compact car dimensions, 4134 mm, followed by Fiat Multipla (1998) 3994 mm, then Opel Zafira (1999) the first compact MPV to offer 7 seats, in 4317 mm long. Mini MPVs appeared few year later, Ford Fusion (2002), Opel Meriva (2003), Fiat Idea, Lancia Musa, Renault Modus (2004), all around 4 meters. This pushed up compact MPVs to 4.6 m and original MPVs to 4.8 m by 2010.

Opel Meriva was replaced in 2010 by a new model 25 cm longer, 4288 mm, Fiat 500L Living (2013) 4352 mm is the first European MPV smaller than compact MPV that offer 7 seats, they hardly can be classified as mini MPVs.

Japan produced compact and mini MPVs for long time, even 7-seater mini MPV sold in Asia where people are smaller: Honda Mobillo (2001) 4060 mm, Toyota Sienta (2003) 4100 mm.

Off-road cars are produced since pre-WW2 times but they were not popular except for army use, as most them featuring open body and wooden seats.
The first SUV (vehicle with off-road abilities and comfort of a car) was Range Rover (1970) and it remained the only SUV in Europe for 2 decades. Was followed by Land Rover Discovery (1989), Opel Frontera (1991) and Ford Maverick (1993). Early SUV were offered in 2 wheelbase, with 3 and 5 doors.

Japanese manufacturers had SUVs in lineup since 1980s. During 1990s and 2000s most European manufacturers joined SUV segment and 3 classes have been defined: compact (4.0-4.4 m), medium (4.4-4.6 m), large (4-6-4.8 m). Few so-called “mini SUV” appeared during 2010s: Skoda Yeti (2009) 4223 mm, Opel Mokka (2012) 4278 mm, Fiat 500X (2014) 4248 mm, but they are actually bigger than some compact SUV from 10 years ago.

See also: smallest cars and biggest cars.

Examples of length over-increase

Ford: 1993 Mondeo I (sedan 4556 mm), 2000 Mondeo II (sedan 4731 mm), 2007 Mondeo III (sedan 4844 mm). 29 cm increase in 14 years.

Opel: 2002 Vectra C (sedan 4596 mm, estate 4822 mm) replaced both 1995 Vectra B (sedan 4477 mm, estate 4490 mm) and 1994 Omega B (sedan 4787 mm, estate 4819 mm). 33 cm increase in just 7 years for estate version, being even longer than previous large-class Omega B Caravan.

Obviously the compact-class Ford Focus and Opel Astra were replaced with bigger models to fit the gap to growing medium-class brothers.

The gap between compact/medium cars and large/luxury cars is getting smaller: 2010 Opel Astra Sports Tourer (4698 mm) is just 17 cm shorter than 2009 Mercedes E-Class (4869 mm) which is 2 classes larger.

Opel is the best example of car growing

Opel had a constant lineup of 4 car models during last 40 years, BUT… take a look in this table:

1970s lineup 1990s lineup current lineup
1973 Kadett C – compact car 3922 mm 1993 Corsa B – small car 3741 mm 2007 Agila B – mini car 3740 mm
1970 Ascona A – medium car 4178 mm 1991 Astra F – compact car 4051 mm 2006 Corsa D – small car 3999 mm
1971 Rekord D – large car 4567 mm 1995 Vectra B – medium car 4477 mm 2009 Astra J – compact car 4419 mm
1969 Diplomat B – luxury car 4920 mm 1994 Omega B – large car 4787 mm 2008 Insignia – medium car 4830 mm

Once known for low-cost cars like Kadett and Ascona, the last Astra and Insignia models are LARGEST models in their class. Same for Meriva and Antara. Surprisingly, 2014 Opel Corsa E gained just 30 mm while 2015 Opel Astra K is even smaller than predecessor.

Opel Rekord vs Vectra vs Astra

 

Japanese car evolution is more stable, they do not increase cars so crazy, also they do not install bigger engines than necessary.

Solution: Europe should urgently implement a tax system similar with Japanese one, taxes depending not only by engine size but also by car size. This would make manufacturers to stick under some size limits…

Volkswagen Golf evolution Mercedes S-Class evolutionBMW 5-Series evolution

European car classification

50 years ago the european car classes were: small (3.5 m), compact (3.8 m), medium (4.1 m), large (4.5 m), luxury (4.8 m).
Today main car classes are: mini (3.6 m), small (4.0 m), compact (4.3 m), medium (4.7 m), large (4.9 m), luxury (5.1 m).

If this stupid trend continue, how do we classify the cars in the year 2050? Probably nano (3.5 m), micro (4.0 m), mini (4.5 m), small (5.0 m), compact cars were equivalent of today’s Maybach, while medium-class cars were definitely dead!!

With other words, in 1960s most cars were the “medium” ones, being 4 meter in length, in 1990s “compact” cars became common, being again 4 meters in length, in 2010s “small” cars enjoy growing popularity, having the same length of 4 meters.

Also, what the fuck are the crazy supersport engines on regular cars? Example: 2008 Audi RS6 with 580 horsepower. Most today cars, even in their base model, can reach max speed over 200 kmph, while most today highways have speed limit up to 130 kmph. Also who needs to reach 100 kmph in under 5 seconds?

American car classification

American classification is different. Do not confuse American compact-size with German compact cars (British small family cars), is just a coincidence that today they have same size. American mid-size imported in Europe are long like german large cars (british Executive cars) but priced like german medium cars (British large family cars), American full-size equals the length of European luxury cars but they are just big and cheap.

American cars were even bigger until 1973 oil crisis. If in Europe everything was growing, the American cars had successive downsizing starting from 1977 to 1990s.

1957 Fiat 500 vs 2007 Fiat Nuova 500 Mercedes E-Class evolution Porsche 356 and 911 evolutionCar badges compilation

 

Car engines evolution

First, some basic notions of physics:

Horsepower is never measured, instead the torque is measured at various rpm then horsepower is calculated from torque.

Torque value in Nm x rpm / 7024 = power value in PS. Do note that numerical values of max power and max torque given in car manuals are not directly related because at the rpm of max power, torque is lower than its max value.

Top speed is proportional to square root of engine power, and also depends by area of car viewed from front.

Acceleration is related with engine power but also with mass. A loaded car will have same top speed like an empty car, but require longer distance to accelerate and reach top speed.

A car with two engines, gasoline and diesel, having same max power but the diesel one have more torque, is likely to have same top speed but the diesel one will accelerate slower because diesel engines are often heavier. Actual performance figures depend also by gearbox.

Most gasoline engines run at 5000-6000 rpm, and their torque numerical value in Nm to be 1.2-1.3x the numerical value of power in PS, Ferrari engines which run at 8000+ rpm have less Nm than PS. Diesel engines always have less horsepower / litre than gasoline engines because they run slower (about 4000 rpm), making torque numerical value in Nm to be more than double of numerical value in PS.

Common car classes 1960s to 2010s
Image source: http://www.competition-car-engineering.com/PvTquiz.htm, also explaining torque-power relation.

Catalytic converters, appeared for first time in 1973, for cars produced or imported in USA, because in 1974 US EPA imposed limits of exhaust emissions. European car manufacturers introduced catalytic converters in 1985. Cars without catalytic converters were produced until 1988 in Germany and 1990 in rest of Western Europe. Japan don’t know when introduced but in 1985 they already had catalytic converters for most domestic cars. They are meant to reduce pollution, but they also reduce engine torque and power and increase fuel consumption, this also introduced fuel injections for mainstream cars, which counter-balance the loss of power, however the sport cars which were already fuel injected have lost about 10% of power.

In the above article we discussed primarily growing of car length, but they grow also in width and height, making frontal area larger thus require more powerful engines to maintain the speed.

Comparison of base engines:
Opel Astra F in 1991 (1.4 litres, 60 PS, 160 kmph, 16.5 s 0-100 kmph)
Opel Astra J in 2010 (1.4 litres, 87 PS, 168 kmph, 15.1 s 0-100 kmph)
45% more power but almost same performance figures, due to increase in car width, height, and weight.

During 1970s to 1990s, most gasoline engines had 50-60 PS / litre, thus bigger and bigger engines were installed in small cars. For example Golf III in 1991 was the first compact car with V6 engine (2.8 litres, 174 PS). Mercedes C 43 AMG was in 1997 the first medium car with V8 engine (4.3 litres, 306 PS), it was followed by Volkswagen Passat W8 in 2001 (4.0 litres, 275 PS).

Other manufacturers choose to use a turbocompressor for top-range model instead of bigger engine. Interestingly Mercedes in 2004 replaced C 32 AMG (3.2 litres turbo, 354 PS) with C 55 AMG (5.5 litres non-turbo, 367 PS). What was the reason?

Since 1990s attempt to increase power per litre was used instead of increasing engine size. 4-valve per cylinder raise power with about 10% compared with 2-valve per cylinder engines, they became common since 1990s, but few manufacturers such as Volkswagen continue to produce 2-valves per cylinder even in 2010s.

From 1970s to 1990s. Diesel engines are about 25-35 PS / litre while turbodiesel around 35-50 PS / litre.

First turbodiesel car was Peugeot 604 in 1978 (2.3 litres, 80 PS).

Direct injection in diesel engines was introduced by Audi 100 in 1989 (2.5 litres, 120 PS), it helped popularity of turbochargers and caused extinction of naturally-aspired diesel engines in early 2000s. Turbodiesel entered in a rapid evolution, from 60 PS / litre in 1990s to over 100 PS / litre: BMW 335d in 2013 (3.0 litres, 313 PS).

Direct injection in gasoline engines was introduced by Mitsubishi in 1999 for multiple models, followed by Volkswagen in 2002, however it did not became common until 2010s, when together with turbochargers, helped achieving power over 100 PS per litre, allowing even 4.8-meter long cars like Ford Mondeo to be powered by tiny 1.0 litres engines. V6 engines disappeared from compact cars and even from medium cars except for premium brands like Audi, BMW, Mercedes. Saab and Volvo were the first manufacturers to stop producing naturally-aspired engines. Even the highly popular Porsche 911 Carrera will go turbo in 2016!

Car evolution records

Mercedes hold most records, especially in engines:

Most models produced at same time (17 models as 2014):
A, B, CLA, C, E, CLS, S, V, SLK, SL, SLS, G, GLA, GLK, ML, GL, R.

Most engine options at same time in one model: (E-Class)
10 engines as 1997: 200, 240, 280, 320, 430, 55 AMG, 220 Diesel, 290 Turbodiesel, 300 Diesel, 300 Turbodiesel.
10 engines as 2003: 200 Kompressor, 240, 320, 500, 55 AMG, 200 CDI, 220 CDI, 270 CDI, 320 CDI, 400 CDI.
11 engines as 2011: 200, 250, 300, 350, 500, 63 AMG, 200 CDI, 220 CDI, 250 CDI, 300 CDI, 350 BlueTec.

Largest engines:
In a medium car: C 55 AMG, (5.5 litres).
In a large car: C 63 AMG, (6.2 litres).

Smallest engine in a large car:
E200 Kompressor, from 2003 to present (1.8 litres), all other large cars starts at 2.0 litres.

Most underpowered diesel engines during 1980s and 1990s:
W124 D until 1985 (2.0 litres, 60 PS, 135 kmph), 45% less power than base gasoline engine (109 PS)
W124 200 TD / E200 Diesel T until 1995 (2.0 litres, 75 PS, 150 kmph), 45% less power than base gasoline engine (136 PS).
Even VW Golf III base engine in 1991 had higher top speed (1.4 litres, 60 PS, 157 kmph). At other brands, base diesel engine is max 10-15% less power than base gasoline engine.

Mercedes hold also the record of smallest car in modern world (if we include Smart) and longest car in modern world (if we include Maybach), note that in 1970s some americans cars were longer.