1945-present 110+ makes 2100+ models 3400+ body styles 13 columns of specs per model
1 row = model, platform and body style: BMW 3-Series E36, E46, Saloon, Touring, Coupe, Cabrio.
Last update: 6 May 2019
The price reflect my efforts researching automobile industry since 2003, compiling quality databases and keeping them up-to-date, plus offering daily customer support.
Databases are targeting commercial use, each year few hundreds companies, programmers and web developers, paying BIG $$ to ensure getting a complete vehicle database, frequently updated and with accurate technical specs, several customers offered me $1000+ to make a customized vehicle list. Hope you can do the same.
Stay away from websites offering databases for FREE download, they are most likely stolen and posted online by other people than original author, or made by careless students who needed only a bunch of data for their studies, such databases does not cover all cars, have many errors, are outdated, no support or updates are provided. Using databases downloaded freely may destroy your company reputation.
Prices too high! Can you offer a discount for non-commercial use?
I cannot verify if you make profit or not. If you need database for personal use, data analysis, machine learning, academic, etc, you are welcome to purchase at same price like commercial entities. If you cannot afford my prices, we cannot make a deal. Sorry!
Full databases prices are NOT negotiable. Do not say that you are a poor student from India or Africa, you lost job, your mom died yesterday, and need full data for $10 (example of SCAM attempt mentioning death of his mother). I have a constant flow of European and American companies paying me hundreds $, I do not care about getting $10 from an Indian student (no racism intended but over 50% of Indian customers attempted to negotiate price, compared with <10% from other countries).
Discounts are ONLY if you buy partial data. I offer big databases in multiple packages, such as “new cars only” or “naming only” for people who do not need old cars and full specifications. Additionally I can offer partial databases with specific makes or car types, for example if you want to buy an used SUV and think that my database can help you making a decision, I can sell you a partial database with only SUVs produced last 5-10 years, price will be 2x my regular price per row of data.
Students who need 200 rows, 1000 rows, etc, but not full database: if the free samples with 1 make are not sufficient, I can sell you a partial database for example with 5 selected makes, 2 selected models per make, and all variants of these models, NO updates, for a discounted price. If you want for free, use sample files posted on website, DO NOT waste my time selecting models if you cannot pay even a discounted price!
How to get full database?
First, download the free SAMPLES (they usually include 1 make with all models or 3 models from 3 makes with their all variants) and test database in your application. Then click green button “buy and download”, pay with PayPal or Credit Card (via 2Checkout) and download link for the FULL database is emailed automatically to you (example email).
Contact me for other payment methods (Skrill, Western Union, Bank Transfer, Bitcoin and other crypto, etc).
Can I buy a small database then upgrade to a bigger database by paying difference?
YES in case of databases with same table structure. For example if you bought Car Models & Engines 1990s-present then you want Car Models & Engines & Dimensions 1970s-present, you can contact me and I will lower a price to pay difference.
NO upgrade from Car Models Database to Car Models & Engines Database because their table structure is very different and are aimed to different business fields.
Do you provide updates and how often?
Update frequency depends by how many people buy each database and how much effort takes each update. 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 all customers to notify you to re-download database.
Do you provide API to avoid needing to re-download file after each update?
I do not have sufficient experience to create API myself. If you are an experienced developer with interest for cars, join to help me and other customers by creating an API (API should be hosted on my server and managed by me). I reward you with free access to data. Read more.
A variety of people and companies visit my website, so is NOT possible to make everyone happy by offering a single vehicle database, or to predict what customers will visit me in the future and create suitable databases in advance.
If you think that these vehicle databases are stolen from somewhere and sold “as it is” like what do other data providers, you are WRONG. Being the developer of database and having over 15 years experience in researching car industry, plus high skills in data mining, I can offer you customized solutions.
Tell me what data are you looking for, I may customize one of the already-made databases, or create a new database according your requirements, for you and for future customers looking for same thing.
Note: I am here to make databases that can be used by as many people is possible, NOT to work full time for 1 person. I do dozens sales per month. I may reject projects that takes more than few hours if the data collected have no use for anyone else than yourself, or I can pass your project to my partners. See examples of projects done and their price.
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-2019) and new cars only (2017-2019), 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 SUVs, only trucks, or only vehicles made by General Motors (Buick, Cadillac, Chevrolet, Geo, GMC, Oldsmobile, Pontiac, Saturn). Useful for people who want to buy a car and my database may help them making a decision. Note: for a selection of makes the price per row will be twice of normal price, so if you choose few makes that exceed 50% of total rows in database you will no longer 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 would take 100 hours to enter tire size manually, 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 car magazines.
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, and put it on sale for 500 euro, a price at which I was not expecting many buyers, but I was wrong. Many people switched their choice to the bigger and more expensive database, and my income has been doubled.
There were many things that I could offer, but in early years I was not aware what I should offer due to people lazy to contact me and inform about their requirements
Creating totally new databases
A new era started in 2015, using web scraping software I can create new databases with minimum of effort, by writing scripts that visit a website at your choice, extract specific data and put it into an Excel database, in a matter of hours.
Do not just tell me what data do you require and expect me to do research on the web to find that particular data. You need to provide URL of a website having required data and I will code a scraper that create a database with all data from the website you choose, which may be or may not be exactly the data you require.
Do not expect me to create databases with data that you cannot find public on internet, for example:
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 need to be public somewhere in order to scrap it and put into a database.
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.
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.
Do not ask for car owners database with name, address, email, phone number, insurance expiry date. Such database belongs to car dealerships and insurance companies and is NOT public, only their staff have access to it. However if you do a Google search “car owners database” you see at least 10 sites selling such personal data, all them from India, a country infamous for so-called email marketing, telemarketing and cold calling that us (westerns) we define as spamming. No wonder that 90% of people asking me for such dumb things were Indians. How these databases appeared on internet we do not know, probably corrupted employees tried to make extra money by selling via internet their company’s customer database. This is ILLEGAL and anyone distributing personal data risk to be fined or even jailed.
Year-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 by myself, did few improvements in model hierarchy and created an Excel database with completeness and accuracy having no equivalent on internet.
Buy complete database + FREE updates for one year:
Last release: 15 December 2019, including 2963 “2019 models” and 2109 “2020 models”. Full changelog.
Contact me for custom packages, example 2010-present, SUV only, etc, useful for people deciding what used car to buy.
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.
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) are MY 2001 onward. Vehicles sold in Canada but not in United States are NOT included here, as they are included in Year-Make-Model which is based on Wikipedia.
Apparently they changed source of data for MY 2001. The specs are consistent before and after MY 2001 except that certain fields (car price, valves, cam type) are available starting from MY 2001, and hierarchy is different, for example Mercedes C43 AMG was listed as separate model for MY 2000 and as trim under C-Class for MY 2001. I manually improved hierarchy to fix these issues.
Cars are sorted by make and model alphabetically, by year old to new (should put new cars at top?), then by trim from low to high. You are advised to NOT re-sort cars when importing in your application.
Looking for pre-1990 cars? You can use Year-Make-Model (1945-present, no trims or specs). However, I am interested to make a specs database with older cars, for my personal research and for selling to people dealing with older cars! Show me a website similar with Edmunds but with longer historical coverage, that include at least car engine size, power and dimensions, and I may create a new database for you!
List of car makes included
American domestic: AM General, Buick, Cadillac, Chevrolet, Chrysler, Dodge, Eagle, Fisker, Ford, Geo, GMC, Hummer, Jeep, Lincoln, Mercury, Oldsmobile, Panoz, Plymouth, Pontiac, Ram, Saturn, Tesla.
European imports: Alfa Romeo, Aston Martin, Audi, Bentley, BMW, Bugatti, Ferrari, Fiat, Jaguar, Lamborghini, Land Rover, Lotus, Maserati, Maybach, McLaren, Mercedes-Benz, Mini, Porsche, Rolls-Royce, Saab, Smart, Spyker, Volkswagen, Volvo.
Fuel and mileage: Engine type 99.98%, Fuel type 99.94%, Fuel tank capacity 98.92%, Combined MPG 85.44%, EPA mileage 85.18%, Range 84.29%.
Interior dimensions: Front head room 93.43%, Front hip room 76.16%, Front leg room 92.63%, Front shoulder room 90.38%, Rear head room 80.70%, Rear hip room 65.87%, Rear leg room 80.13%, Rear shoulder room 78.62%.
Other dimensions: Front track 48.61%, Rear track 48.47%, Ground clearance 63.40%, Angle of approach 26.50%, Angle of departure 26.51%, Turning circle 86.32%, Drag coefficient 19.28%, EPA interior volume 33.49%, Cargo capacity 63.38%, Maximum cargo capacity 42.07%.
Interior features: Front seats 77.70%, Rear seats 66.44%, Power features 77.38%, Instrumentation 77.51%, Convenience 77.65%, Comfort 77.23%, Memorized settings 20.19%, In car entertainment 77.49%, Telematics 0.00%.
Exterior features: Roof and glass 77.60%, Body 23.95%, Truck features 26.25%, Tires and wheels 77.71%, Doors 22.97%, Towing and hauling 45.08%.
Bonus data (added from my own experience): Domestic / imported 100%, Country of origin 100%, Car classification 100%, Platform code / generation number 100%.
Percentages calculated at 15 May 2019 update (57169 trims, 86 columns).
Possible alternate databases
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?
How often do you want updates? (Year-Make-Model-Trim-Specs)
Complete for World War II – present. All major (and few minor) manufacturers of Europe, United States, Australia, Japan, Korea, Malaysia, India, Brazil, Argentina. Commercial vehicles under 3.5t are included too. No concept cars, prototypes or custom-made presidential limousines, but only vehicles actually sold on market.
The database does include also ~100 antique cars old as 1900, if they are related with post-war cars, but it is not and will never be complete for pre-war period. Before WW2 the world had over 1000 small manufacturers and the internet do not provide sufficient accurate info to include them.
The database 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.
Because in the recent updates I added too many minor brands / exotic cars that are seen more at museums and collectors than driving on roads, at May 2019 update I also added a column that allow you to delete easily the exotic brands, if you want to have a database with only cars commonly seen on roads.
Example of cars included and marked as minor brands: Cizeta-Moroder (1990s supercar with only 20 units produced), Messerschmitt (cheap 1950s bubble car, 15,000 units produced but most of them been scraped and are not driving anymore), Peel (1960s, 2 models, less than 100 units produced, but famous for Peel P50 which is listed in Guinness book of records as world’s smallest car).
Cars produced in China are not included yet due to insufficient data available online. If you check 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 offer contradictory data.
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 and mobile app development.
There is also a column for number of units produced, but I was able to find this info for only 11% of total models included in database, mostly exotic cars, so if you are looking for a production figures for all cars, this Car Models List will NOT help you. See instead Car Sales Figures.
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!
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.
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,500 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,500 models (generations) sold all over the world of which over 3,000 sold in Europe, 1945-present. Cars that are technically identical are counted only once here, Mitsubishi 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 120,000 rows including every possible variations, 1970-present and each year add 5000-9000 rows. United Kingdom Car Database made via scraping from www.parkers.co.uk have over 80,000 rows 1980-present and each year add 4000-6000 rows. Japan Car Database made via scraping from www.goo-net-exchange.com/catalog/ have over 90,000 rows 1986-present and each year add 3000 rows.
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 they are worldwide, while the more detailed databases cover only cars sold in one specific continent.
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.
If you ask how many distinct model versions are sold all over the world: this is impossible to answer. There are nearly 200 countries in the world. Most cars sold in Europe have same specifications all over continent except steering wheel position (UK is LHD), do we should count cars sold in UK as distinct models than those sold in continental Europe? I think that some cars sold in hot Middle East come with more powerful air conditioners than when sold in Europe or USA. Does this is enough to count as different models? We will never know how many slighly different versions of each car model are sold in remaining countries.
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 55,000 trims, sold in United States 1990-present, and each year add about 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.
Ford Model T was the first car model to exceed 1 million units, it is estimated to have been produced approximately 16,500,000 units between 1908 and 1927.
Volkswagen Beetle is the all-time best-selling model, having 21,529,464 units produced between initial launch in Germany in 1938 and latest car produced in Mexico in 2003.
Lada Classic/Nova is the second or third best-selling models, over 15 million units were produced in Russia between 1970 and 2012, plus an unknown number of units were produced under license in other countries.
Toyota Corolla is the best-selling nameplate, wear by over 40,000,000 cars as 2013, but they are multiple models, main Corolla model being at 12th generation in 2018, plus additional unrelated models such as Corolla Axio, Corolla Matrix, Corolla Tercel, Corolla Verso, etc.
Buy FULL database (all makes) + FREE updates every month:
Coverage: oldest car included in database that indicate year is Daewoo from 1994, the FIRST foreign car manufacturer to enter in Indian market, followed by Ford and Opel (1996), Fiat (1997), Honda and Hyundai (1998). It may include pre-1994 models from Indian domestic brands but no year is indicated.
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 and Bikewale.com.
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.
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.
Carwale removed discontinued models in March 2017, so my database contains valuable data that you cannot get yourself from Carwale anymore.
In April 2019 I made new scraper for Bikewale, adding individual versions in the Indian bikes database (in the previous editions, if a bike had multiple versions, database contained only base version).
Future updates will only add new cars, no updates for existing records
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.
Car 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 in new+old cars package, NOT scraped from website).
Percentages as 1 January 2017 (3680 cars).
Note: Car class and Body style are NOT available in new cars only package, because would take a lot of time to re-add them for 1200 cars every monthly update, so I add them only in new+old cars package for the cars added each month (about 20-50 cars per monthly update). Cars launched after June 2019 have some engine columns merged into 1 column due to changes in Carwale website.
Car engine codes database
Database made at request for someone who wanted production years for every model and engine, and engine codes, and posted here for other people who may be interested in same thing
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.
Buy FULL database + FREE updates when someone ask an update:
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! They may be databases of users registered in some website that was hacked or a corrupted employee try to make extra money by selling their internal database.
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.
News: in April 2019 been contacted by a strange person claiming to have database of customers from all new car dealerships across India, 1.5 million records. He was speaking very bad english mixed with hindi and we didn’t understood each other, when I asked for a SAMPLE with few rows to see what details he have about each car buyer/owner, he said “bulk orders only” and asked me to do bank transfer. How I can pay without knowing what I get?
I have his phone and email, he is living in Mumbai. I am not from India so I cannot meet him. Is there anyone from Mumbai who can help me and meet him in person, check database before paying, then share database with me (I can pay you half of the price of database) then I will sell it to other people interested?
If you want a complete and accurate database of cars sold in your country, used cars classifieds websites are NOT a good place to source data from, because they are variable data, every day new cars are posted for sale while others become inactive, many car models are duplicated and some car models are missing because none is on sale today.
In 2016 someone asked me via this comment to scrap data from an used cars website and I initially said that is a stupidity to do this… I am sorry for this. Next year I noticed that there are several cases in which you need specifically to extract data from used cars listings, example:
You are doing an analysis of most popular car models, their average price, age, mileage, etc.
You are training an image recognition software, thus need thousands of amateur images labelled with car make and model. Used car classifieds websites are best option to get such images.
You want to start your own used cars website and can do this by copying listings from an existing website, with a link to original website so people can contact seller.
Someone asked me to provide a database of prices for used cars transactions. This is NOT possible because in most cases buyer and seller meet somewhere on street and negotiate price face to face, nobody knows at what price they agreed. There are also used cars dealers, but they are unlikely to share their sales records with third parties.
Websites scraped so far
Here you can buy SOME of the records I scraped in the past for various customers. If you want update (re-scraping) of any of below websites, or another website at your choice, please ask!
Note for telemarketers who want email database or phone numbers to spam SMS ads: sorry but I may be not able to provide emails or phone numbers. All major classifieds websites use various anti-scraping features purposely to prevent users posting cars for sale to be spammed with unsolicited calls and emails.
For example phone numbers is generated to be displayed as an image, you need to click a button or solve a captcha to reveal seller phone number (certain anti-scraping features can be beaten, for example by using an OCR software, but this is difficult and I rather don’t bother doing this).
There may be some small websites that do not use any protection. Check yourself by right clicking page > view source, Ctrl+F and try to find phone number, if it is here, then I can easily scrap it.
Buy complete database + FREE updates for one year:
Contact me for other packages such as 2008-present or specific set of columns.
Source of data:bikez.com, 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.
Each calendar year a bike is manufactured is on a separate row in database. I know that some customers prefer start year – end year, but customizing this is too difficult. If you are from United States you may be familiarized with the fact that vehicles launched in 2019 are wear “Model Year 2020” and several people asked me when I am going to add 2020 models. Bikez database use calendar year, so you won’t see 2020 models until we actually enter in 2020 year.
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.
The motorcycle database was originally made in May 2016 with 43 columns, by someone who needed both cars and bikes and we agreed to give him a discount for my manually-made biggest car database in exchange of a script that extract data from 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. Browsing other bikes I 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 480 makes. For SEO purposes I list here the 57 makes with more than 100 models:
Other specifications: Color options 78.09%, Starter 80.77%, Instruments 11.35%, Electrical 9.32%, Light 7.42%, Carrying capacity 7.96%, Factory warranty 16.25%, Comments 43.07%, Modifications compared to previous model 0.85%.
Completion percentages calculated in 2000-present package at May 2019 update.
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
479 brands, 32590 models, 25 February 2019
479 brands, 32867 models, 25 May 2019
480 brands, 33234 models (12 not found), 30 May 2019, scraped from a different page because previous methods seems that were missing few bikes.
480 brands, 33658 models (12 not found), 5 November 2019.
483 brands, 33938 models (12 not found), 4 January 2020.
How often do you want updates? (Motorcycles database)
German Database is the biggest car database available for sale, in terms of file size, breakdown of models and number of data fields, but not the biggest in terms of distinct models, because it cover only cars sold in Germany. Anyway, Germany have the most diversified car market in the world. 95% of car models sold in Europe are sold in Germany too (95% of models from European Car Models & Engines Database are included also in German database, with more details).
Last release: 3 December 2019, including 10250 cars launched in 2019 and 164 cars in launched 2020. Most cars are included in database 1-2 months ahead of launch, some cars, especially electric/hybrid, are announced sometimes more than 6 months in advance.
Coverage: all cars sold in Germany, the biggest car market in Europe. 99% of car models sold in Western Europe are also sold in Germany, so you can use this database even if you are from another country of Europe. Example of cars sold in (Eastern) Europe but not in Germany, missing from German car database but available in the original European database: old Dacia and Skoda models, some Lada models, Moskwitch, GAZ, UAZ, ZAZ, FSO, Zastava.
The website was originally 1990s-present, consequently some cars produced during 1990s do not have starting year. During 2016 they done extensive research on automobile history and coverage was extended to 1950s for German domestic manufacturers and 1970s other makes from Europe or Asia.
Looking for 2000-present at discounted price? Database being made in European format with production start/end year, there is not possible to filter automatically cars older than year X like in case of American and Australian car databases. I need to manually add a filtering column as I did for European Car Models Database and Car Models & Engines Database, but because this database is made via web scraping, each time I update database, anything added will be lost. So the only option is to purchase whole database 1950-present. Sorry for this.
Legal: data belongs to German Automobile Club, turned into Excel database after I paid my programmer partner to make a scraping software for this website, each scrap taking about 7 days at 3 seconds per car. I am not responsible for any legal issues you may face for using data copied from another website. If you care about legality, buy https://www.teoalida.com/cardatabase/the-biggest-car-database/ instead, which is an original product “Made by Teoalida” with no equivalent on internet, as the data is sourced from books.
Preise und Ausstattung: Grundpreis 100.00%, Klassenübliche Ausstattung nach ADAC-Vorgabe 18.88%, Klimaanlage 91.87%, Zentralverriegelung 94.81%, Fensterheber elektr. vorne 94.09%, Fensterheber elektr. hinten 62.88%, Einparkhilfe 70.01%, Einparkhilfe – Bezeichnung 68.79%, Einparkassistent 24.80%, Trailer-Assist 1.60%, Berganfahrassistent 46.51%, Radio 88.56%, Radio – Bezeichnung 86.64%, Navigation 70.04%, Navigation – Bezeichnung 67.92%, Notruffunktion 26.98%, Alufelgen 83.59%, Lederausstattung 51.68%, Metallic-Lackierung 97.82%.
Teoalida’s Car Database originates in 2003, sourcing data from multiple AutoKatalog books issued yearly and typing data in Excel manually in a data structure invented by me, making an original product with no equivalent on internet, which you can use in your website or mobile app without risking to be sued by anyone. Because AutoKatalog is a printed book, space is limited so it include one row for each model engine, and if it was offered with both manual and automatic transmission, performance data is provided for manual one. This makes my database the perfect choice for auto parts businesses which do not need multiple rows per for each model engine.
However, a small amount of customers, who are interested in performance data, are not happy with my original database, they would like separate row for manual and automatic transmissions.
Since AutoKatalog was discontinued in 2014, I source data from German website to continue maintaining my database, In late 2015 I paid a programmer to make an application that visit each page of German website and scrap/extract the data into Excel, then I manipulate data to match the format of my car database, to have an original product which I can copyright.
I was NOT intending to sell the German database, but in late 2016 several people told me that this database having more rows is more suitable for their projects than my original database, so I made it public. Most people still preferred my original Car Models & Engines Database because the German one have equipment levels that are making too many rows for same engine.
Cover whole Europe, including Rover high-powered variants sold only in UK, 2.0 litres cars sold only in Italy (example Ferrari 208), low-cost cars for Eastern Europe (Fiat Albea, Peugeot 301, Renault Symbol, Lada, Volga, etc)
Cover only cars sold in Germany
Shows period of production as year only, based on their appearance in AutoKatalog, which is a bit off (cars launched in november-december may indicate starting year as next year)
Show period of production as year/month in which the car was sold in Germany
One row per engine, regardless if it was offered with both manual and automatic transmission
One row per each transmission type, also one row per each equipment level (this can be stripped off, don’t know who would need equipment levels that have same specs)
1 column for fuel efficiency (combined)
3 columns for fuel efficiency (urban, highway, combined)
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 depending by country of sale for models having same name, and for accuracy reasons, a car database should be specific to cars SOLD in 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 people 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 “cars made in Japan” because they vary depending by market of sale.
This is Toyota lineup for America
and Toyota lineup for Asia
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.
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?
Live chat customer support
10-14 hours per day, 7 days of 7
Trouble choosing the right database? Have a suggestion for a database? Found errors that need correction? Contact me!Do not waste money on other (cheap) data providers that do not provide support for their customers, selling incomplete data and never correcting errors.
I research automotive industry for over 15 years and compile data in Excel from books and websites. XLS is a versatile format easy to consult, read, sort, etc, also converted to CSV and SQL and used as database for mobile apps and websites.
Download the free SAMPLES and test database in your application, then pay with PayPal or Credit Card and download link for the FULL database is emailed automatically to you (example email).
Making custom databases
Can’t find what are you looking for? Don’t go away… just tell your requirements. Don’t care if I have of not… what I don’t HAVE I can MAKE as custom project for you and for future customers (depending by available time and number of people requesting same thing).
Do you need only new cars? Buy Year-Make-Model 2017-2020 for only 12 euro. Changed mind and need 1945-2020 at full specifications? Pay only the difference. Partial purchases (selected makes) can be arranged!
Download link is valid for 1 year, and each time I update databases I send email notifications to re-download. After first year, you can buy another year of updates at 50% discount. Read more.
Hand-made, no scraping
I started European database in 2003 independently from internet world, sourcing data from books and typing in Excel (see video), creating an original product that you won't find anywhere on internet (except websites that purchased from me), so you can use my database on your website without worrying about copyright claim by someone else.
But I can also scrap websites
Since 2015 I offer web scraping services. If initially I though that web scraping means cheating and illegal way to get data, over years I realized that is not as dangerous. Most customers do not care about how the data was obtained and some ask me specifically to extract data from various websites and sell them database.