European United Kingdom car database

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

Small database SAMPLE:
Make, Model, Generation + dimensions and engines range.xlsx

Buy complete database + FREE updates for one year:

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

Buy complete database + FREE updates for one year:

105 car makes included

Abarth, AC, Aixam, Alfa Romeo, Alpine, Asia, Aston Martin, Audi, Austin, Bentley, BMW, BMW Alpina, Bristol, Cadillac, Caterham, Chevrolet, Chrysler, Citroën, Coleman Milne, Corvette, Cupra, Dacia, Daewoo, Daihatsu, Daimler, De Tomaso, DFSK, 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, LEVC, Lexus, Ligier, Lotus, LTI, MAHINDRA, 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.

55 data fields included

Naming: Make 100%, Model 100%, Generation 100%, Trim / Version 100%, Year from 100%, Year to 100%, Date from 100%, Date to 100%.

Costs: New Price 7.16%, Used price range 82.84%, Fuel consumption (mpg) 86.49%, Insurance group 84.98%, Annual road tax 100%, Monthly company car tax cost (Basic Rate) 86.62%, Monthly company car tax cost (Higher Rate) 86.62%.

Performance: Power (bhp) 98.87%, Top Speed (mph) 89.31%, 0-60 mph (secs) 88.79%, Torque (Nm) 88.48%, Torque (ft-lb) 81.72%, CO2 Emissions (g/km) 100%, Euro Emissions Standard 87.92%, Miles Per Tank 81.26%.

Dimensions: Length (mm) 97.40%, Width (mm) 97.01%, Height (mm) 81.24%, Wheelbase (mm) 89.42%, Turning Circle (m) 80.97%, Fuel Capacity (litres) 88.89%, Weight (kg) 84.41%.

Engine: Engine Size (cc) 99.37%, Cylinders 88.19%, Valves 87.14%, Fuel Type 100%, Transmission 100%, Gearbox 93.70%, Drivetrain 100%.

Cabin & Luggage: Doors 99.97%, Seats 91.21%, Luggage Capacity (litres) 75.24%, Unbraked Towing Weight (kg) 67.12%, Braked Towing Weight (kg) 74.97%.

Safety ratings: EuroNCAP Rating 37.65%, EuroNCAP Rating description 37.65%, Adult Occupant 11.13%, Child Occupant 11.13%, Pedestrian 11.13%, Adult Occupant % 24.94%, Child Occupant % 24.94%, Pedestrian % 0.00%, Safety Assist % 24.94%.

Bonus: Country 100%, Status 100%, Model Generation (Years) 100%, Image URL 98.69% (you can use Tab Save extension for Chrome to download image JPG files).

Completion percentages calculated at 21 January 2021 update with 90054 model versions.

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.
105 makes, 2571 models, 90054 versions – 21 January 2021.
105 makes, 2576 models, 90467 versions – 29 March 2021.

Last update is too old? Request update today! I just need to open scraper and leave it running for about 20 hours, then upload new file on my website and notify all past customers to re-download file.

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 *