European United Kingdom car database

Coverage: passenger cars sold in United Kingdom from ~1980 to present. Businesses from continental Europe are advised to purchase German Car Database, which include also light commercial vehicles. Last update: 20 October 2020.

Small database SAMPLE:
Make, Model + image SAMPLE .xls

Buy complete database + FREE updates for one year:

BIG database SAMPLES:
Make, Model, Version + image SAMPLE .xlsx
Make, Model, Version + full specifications SAMPLE .xlsx
Alternative formats: CSV and SQL (full specs)

Buy complete database + FREE updates for one year:

List 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, Polestar, 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.

Data fields included

Naming: Make 100%, Model 100%, Submodel 100%, Version 100%, Date from 100%, Date to 100%.

Costs: New Price 8.18%, Used price range 86.08%, Fuel consumption (mpg) 89.99%, Insurance group 84.51%, Annual road tax 99.68%, Monthly company car tax cost (Basic Rate) 88.66%, Monthly company car tax cost (Higher Rate) 88.66%.

Performance: Power (bhp) 98.77%, Top Speed (mph) 88.53%, 0-60 mph (secs) 88.10%, Torque (Nm / ft-lb) 88.64%, CO2 Emissions (g/km) 88.35%, Euro Emissions Standard 87.05%, Miles Per Tank 86.59%.

Dimensions: Length (mm) 97.04%, Width (mm) 96.69%, Height (mm) 81.35%, Wheelbase (mm) 88.42%, Turning Circle (m) 80.00%, Fuel Capacity (litres) 88.25%, Weight (kg) 83.44%.

Engine: Engine Size (cc) 99.65%, Cylinders 88.55%, Valves 87.56%, Fuel Type 100%, Transmission 100%, Gearbox 93.07%, Drivetrain 100%.

Cabin & Luggage: Doors 99.97%, Seats 90.35%, Luggage Capacity (litres) 72.93%, Unbraked Towing Weight (kg) 65.65%, Braked Towing Weight (kg) 74.05%.

Safety ratings: EuroNCAP Rating 33.27%, EuroNCAP Rating description 33.27%, Adult Occupant 12.25%, Child Occupant 12.25%, Pedestrian 12.25%, Adult Occupant % 19.29%, Child Occupant % 19.29%, Pedestrian % 19.29%, Safety Assist % 19.29%

Bonus: Country of origin 100%, Status (production/discontinued) 100%, Submodel production years 100%, Image URL 100% (you can use Tab Save extension for Chrome to download image JPG files).

Percentages calculated at 7 May 2019 update.

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 additional databases for Europe because I already had the AutoKatalog-based 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. I made a scraper for the most famous UK car website and it was easier than originally expected, easier than German and American websites I also extracted data for their databases. I feel sorry for not creating this UK car database earlier!

List of updates

2389 models, 80406 versions – 20 January 2019, initial scrap, beta version. 45 columns.
2389 models, 80485 versions – 3 February 2019, re-scraped to fix the incorrect car prices in initial scrap.
2383 models, 81501 versions – 28 March 2019.
2418 models, 81873 versions – 7 May 2019, removed unit of measurement after values, made multiple tables and VLOOKUP formulas in order to add model production years (different than version production years) and image URL from small database into big database, also status (production / discontinued) for purpose of selling a “new cars only” package with discount. 52 columns.
101 makes, 2439 models, 83314 versions – 5 September 2019.
101 makes, 2439 models, 83430 versions – 16 September 2019.
101 makes, 2467 models, 84532 versions – 7 December 2019.
102 makes, 2481 models, 84966 versions – 14 February 2020.
102 makes, 2490 models, 85466 versions – 7 April 2020.
102 makes, 2491 models, 85578 versions – 1 May 2020.
102 makes, 2491 models, 85630 versions – 19 May 2020.
102 makes, 2498 models, 86173 versions – 14 August 2020.
103 makes, 2543 models, 88151 versions – 20 October 2020.

5 thoughts on “European United Kingdom car database

    1. Been gradually adding CSV / SQL beside XLS since March 2020, starting from best-selling databases, UK database sales are lower, so I added only now.

Leave a Reply

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