After I copied all cars specifications from German automobile club into Excel format, I analyzed it to show you how cars sold in Germany evolved over past 50 years (this analysis apply for whole Europe, 99% of cars sold in Europe are also sold in Germany). I calculated using AVERAGEIFS formulas. Charts made at 18 September 2019 update with 122214 model versions. You can buy Excel database: German 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 Europe, the statistics are based on the year of launch, so there are large variations in average data values from one year to another, for example in 1970 a large number of small cars are launched, and in 1971 a large number of big cars were launched. Only after 1975 number of cars launched per year included in database is high enough to reduce variations of average values, but still do not make a constant evolution.
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.
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.
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?
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.
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.
74 makes, 1465 models, of which 1465 models with 90944 versions – 7 December 2019.
74 makes, 1472 models, of which 1472 models with 91952 versions – 14 February 2020.
Each update involve re-scraping all cars and takes about 22 hours.
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
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 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.
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.