Web Analytics Made Easy -
StatCounter

Evolution of cars sold in United Kingdom 1980-2020

After I copied all cars specifications from Parkers.co.uk into Excel format, I analyzed it to show you how cars sold in United Kingdom evolved over past 40 years. I calculated using AVERAGEIFS formulas. Charts made at 16 September 2019 update with 83430 model versions. You can buy Excel database: UK Car Database.

In case of American car database, there is a row for each “Model Year” a car was sold in, so each year calculate average data values of cars available that year and the evolution looks constant. But in case of UK car database, the statistics are based on the year of launch, so there are large variations in average data values from one year to another, only after 1990 number of cars launched per year became high enough to reduce variations of average values, but still do not make a constant evolution, this depends if in a particular year were launched more small cars or more big cars.

Evolution of Japanese cars 1988-2019

After I copied all cars specifications from a popular Japan website into Excel format, I analyzed it to show you how cars sold in Japan domestic market evolved over last 30 years. I calculated using AVERAGEIFS formulas. Charts made at 18 September 2019 update with 90276 model versions. You can buy Excel database: Japan Car Database.

Do you provide PHP scripts?

Because of large number of databases that I am selling, and because each customer have different requirements in integrating my database in his website, there is not possible to make ONE plugin and give it to every customer purchasing a database.

Several free plugins for WordPress do exist (example WooCommerce YMM search) but it can be used only for online stores made with WooCommerce and the only car database that works with it is the Year-Make-Model.

Although I made this WordPress website myself without any help from third party people, I do not have sufficient experience in PHP coding to make custom plugins for other people.

Most of my customers are web designers or have a webdesign team so they made themselves the required scripts, they did not asked me to provide any plugin or scripts. If you do not have own web designer I can connect you with my friends in web design, they can help you making custom PHP scripts according your requirements (you need to pay them separately than payment for my database).

If you made a WordPress plugin for any of my databases, can you share with me for my other customers?

Japan Car Database

Japan car databaseSmall database (make, model, country, production date) – FREE sample

 

BIG database (make, model, version, country, date, specs) – FREE sample

Demo video

Description

A lot of people asked me for a JDM car database, but I was facing trouble because most websites from Japan are in Japanese language while they needed English specifications. In March 2019 a customer told me about one Japanese website in English and after this I found 3 more similar websites, I choose the best one, coded a scraper and published database for sale in April 2019.

This database include ONLY car models sold in Japanese domestic market (including foreign models sold here) and target people from Japan as well as people from LHD countries in Asia and Africa who import used cars from Japan.

This database does NOT include car models made in Japan exclusively for export, for example Acura and Infiniti (Japanese brands aimed primarily for US market but sold also in Europe and Middle East), or example of Toyota models sold in US market but NOT sold in Japan: 4Runner, C-HR, Cressida, ECHO, Highlander, Matrix, Paseo, Previa, Sequoia, Sienna, T100, Tacoma, Tundra, Venza, Yaris. For these car models you can buy one my American databases.

Car makes included

Japan: Daihatsu, Eunos, Ford Japan, Honda, Isuzu, Lexus, Mazda, Mitsubishi, Mitsuoka, Nissan, Subaru, Suzuki, Toyota; America: Buick, Cadillac, Chevrolet, Chrysler, Chrysler Jeep, Dodge, Ford, Hummer, Kia, Lincoln, Mercury, Pontiac, Saturn, Starcraft, Tiara; England: Aston Martin, Bentley, Daimler, Jaguar, Land Rover, Lotus, MG, Mini, Morgan, Rolls-Royce, Rover, TVR; France: Citroen, Peugeot, Renault, Venturi; Germany: AMG, Audi, BMW, BMW Alpina, Europe Ford, Maybach, MCC Smart, Mercedes AMG, Mercedes Benz, Mercedes Maybach, Opel, Porsche, Volkswagen, Yes; Holland: Donkervoort; Italy: Abarth, Alfa Romeo, Autobianchi, Ferrari, Fiat, Lamborghini, Lancia, Maserati; South Africa: Birkin; South Korea: CT T, Daewoo, GM Matiz, Hyundai; Sweden: Saab, Volvo.

Coverage: all cars launched after 1986.

Data fields included

Naming: Make 100%, Model 100%, Version 100%, Date of Launch 99.88%, MSRP 100%, Country of Origin 100%, Image URL 99.88%.

Body & Dimensions: Body Type 100%, Doors 100%, Riding Capacity 100%, Model Code 98.45%, Overall Length (mm) 99.91%, Overall Width (mm) 99.96%, Overall Height (mm) 99.90%, Wheelbase (mm) 99.60%, Tread Front (mm) 98.42%, Tread Rear (mm) 98.43%, Interior Length (mm) 76.56%, Interior Width (mm) 76.61%, Interior Height (mm) 76.55%, Weight (kg) 98.12%.

Engine: Engine Model 92.25%, Cylinders 0%, Power (ps) 99.84%, Power (kW) 99.00%, Power (rpm) 97.32%, Torque (kgm) 99.82%, Torque (Nm) 99.03%, Torque (rpm) 87.30%, Displacement (cc) 99.87%, Bore (mm) 93.26%, Stroke (mm) 93.25%, Compression Ratio 95.56%, Charger 0%, Fuel Supply Equipment 3.47%, Fuel Tank Equipment (L) 99.40%, Fuel Type 0%.

Drivetrain: Steering System 0%, Minimum Turning Radius 95.29%, Suspension System (front) 0.02%, Suspension System (rear) 0.02%, Braking System (front) 0%, Braking System (rear) 0%, Tires Size (front) 99.63%, Tires Size (rear) 99.63%.

Transmission: Driving Wheel 61.51%, Transmission 82.22%, LSD 0%, 1st Gear 73.81%, 2nd Gear 73.78%, 3nd Gear 73.78%, 4th Gear 70.47%, 5th Gear 38.05%, Reverse 84.68%, Final Drive Gear Ratio 87.40%.

Note: I included ALL possible data fields from the source website, on which no car shows info for Cylinders, Charger, Fuel Type, Suspension, Braking, etc. Quite strange. Maybe in the future they will add data for these fields too.

List of updates

67 makes, 1388 models, of which 1379 models with 88211 versions – 30 March 2019 (beta version).
74 makes, 1442 models, of which 1430 models with 88866  versions – 8 April 2019 (published for first time).
74 makes, 1457 models, of which 1457 models with 90276  versions – 17 September 2019.

Each update involve re-scraping all cars and takes about 22 hours.

South Africa car database

Source of data: https://www.cars.co.za/ (this website shows specs only for new cars, no discontinued models).

South Africa car databaseDownload SAMPLE:
South Africa Car Database SAMPLE.xls

Buy FULL database + FREE updates for 1 year:

List of updates:

44 brands, 364 models |(295 unique), 2478 versions (1812 unique) – 6 July 2019

China Car Database

Download SAMPLE:
China Car Database SAMPLE.xls

Buy FULL database + FREE updates for 1 year:

Over years several people asked me if I can make a database of chinese cars, but I never been able to find an english car website from China. In June 2019 a customer said that is OK if I make a database in chinese language. DONE! I translated column headers into english, but since I do not speak chinese, some may be incorrectly translated.

Coverage: earliest car included is from 1985, but number of cars get significant only after 2000s. Is also well known that automotive market in China boomed recently. Each calendar year in which a car was produced is a separate row in database.

List of updates:

254 makes, 1341 models, 30319 versions – 22 June 2019

China car database

Oil recommendation database

Oil recommendations databaseCoverage: earliest car included is from 1980, but bulk of cars start at 1990s. Oil capacity in US Gallons.

Download SAMPLE: Pennzoil SAMPLE.xls

Buy FULL database + FREE updates for 1 year:

History

Someone contacted me in 2017 to ask for an oil recommendation database, I scraped data from Pennzoil using my “universal” scraper. The customer did not replied anymore and never purchased it, and due to this reason I initially didn’t published it on website. I regret now, other people may have been interested and could do few extra sales. Pennzoil website has been redesigned meantime and the scraper was no longer working, to update it.

In March 2019 another customer needing oil database provided me 5 possible websites to scrap data from. All them are difficult to scrap, cannot do them with my universal scraper so I need to pay a programmer for a custom scraper.

By June 2019 other 5 customers contacted me interested in oil database, but we argued regarding from which is the BEST website to source data from:

Option 1: https://www.pennzoil.com/en_us/oil-selector.html#iframe=L2RvL2VuX1VTL2VxdWlwbWVudC9jYWRpbGxhY18odXMpLzIwMTkvY3RzX2x1eHVyeV8yXzB0X3Z2dF9hd2RfY3RzX0VGdDhQb2FtbA – do I need to make 1 row for Standard and 1 row for Premium, or should be separate columns? some cars have 3 or 4 oil types indicated. Give me a suggestion because my programmer need exact template how you want data to be displayed. This may be slightly easier to scrap, however personally I DON’T like this website because it have only cars sold in USA and only engine oil.

Pennzoil have also a section for oil filters: https://www.pennzoil.com/en_us/filter-selector.html but car model hierarchy is different so will require 2 different custom scrapers which will produce 2 different databases that I CANNOT combine.

Option 2: https://www.amsoil.com/lookup/auto-and-light-truck/2013/audi/a4-quattro/2-0l-4-cyl-engine-code-cpma-5-flex-turbo/us-volume/#engine1 – this one have more info than just engine oil, but the way info is displayed on website makes difficult to put each piece of information in the right column.

Option 3: https://applications.castrol.com/oilselector/en_us/c/recommendation?vehicleType=cars-and-suvs&manufacturer=bmw&model=3-series-e46-(1998-2006)&modelType=325i-(132-kw)-(2002-2005) – Castrol have cars sold in Europe and USA and also truck and motorcycles, but many cars lack oil recommendation.

Option 4: http://fuchs-eu.lubricantadvisor.com/advice.aspx?lang=eng&country=ro&type=e5167c014c627820dd5f0ce57c9a0bdb – can someone check is this is a good and reliable website to source data from? It have both cars sold in Europe and in America separated in Make list, and shows oil for more oils than just engine oil.

Option 5: https://www.bizol.com/oil-guide/##1|uk|1 this have not just cars but also trucks and motorcycles, contains cars from  US, EU and China, but is again difficult to scrap data from.

Option 6: https://www.ravenol.de/en/oil-guide.html this have not just cars but also trucks and motorcycles, agricutural and construction equipment, contains cars from  US, EU and China, but is again difficult to scrap data from.

Despite that personally I don’t like Pennzoil, 3 people choose it, so my programmer partner made a custom scraper for Pennzoil in July 2019. This is not enough to satisfy all customers because Pennzoil have only cars sold in USA, so we need to scrap one of other sites too.

57 makes, 34643 models – 12 July 2019

57 makes, 34782 models – 15 October 2019