Canada car database

Download free sample:
Canada Car Database SAMPLE.xlsx (340 columns)

Buy complete database + FREE updates for 1 year:

Add to cart

76 makes included

Acura, Alfa Romeo, AM General, Aston Martin, Asuna, Audi, Bentley, BMW, Bugatti, Buick, Cadillac, Campagna, Chevrolet, Chrysler, Daewoo, Dodge, Eagle, Ferrari, Fiat, Fisker, Ford, Ford SVT, Francii, Genesis, Geo, GMC, Honda, Hummer, Hyundai, Infiniti, Isuzu, Jaguar, Jeep, Kia, Lada, Lamborghini, Land Rover, Lexus, Lincoln, Lotus, Maserati, Maybach, Mazda, McLaren, Mercedes, Mercedes AMG, Mercedes Maybach, Mercury, Merkur, MINI, Mitsubishi, Morgan, Nissan, Oldsmobile, Passeport, Peugeot, Plymouth, Pontiac, Porsche, Ram, Renault, Rolls Royce, Saab, Saleen, Saturn, Scion, Smart, Spyker, SRT, Subaru, Suzuki, Tesla, Toyota, TVR, Volkswagen, Volvo.

History

Canada car database was the LAST of the 10+ databases requested by an Indian company I was working for in 2018-2019, they suggested me to scrap data from www.auto123.com (if anyone else thinks that this is BAD website and know a better one, please tell).

I started this project in September 2019, after few days of work I successfully extracted URLs of 53,000 car models as 29 September 2019, and had written scraper to extract 150+ car specs from each URL, but did not had chance run scraper for specs too and analyze data extracted (I suspect that it had many duplicates)… HDD crashed on 1 october 2019 made me to lose half of projects done last 2 months including Canada scraper code + data.

I could not continue working for Indian company and trying to save time for re-doing other lost projects, I did not recreated Canada car database because I assumed that Canadian customers can buy United States car database (almost same cars are sold in both countries). Over time few customers told me that would be interested in having a Canada car database in addition of United States one, so this is how my interest for this project revived. Starting from January 2021 I told to people contacting me from Canada that I will create soon a Canada car database, to leave me their emails so I can announce them when I complete this project, but I was facing trouble du to inconsistency between production models and discontinued models, also some models have directly trims under models, other cars have model > submodel > trim. I did not remembered exactly what solution I used in 2019 so I put project ON HOLD again to focus on other (easier) projects.

Given by high number of people interested, in on 13 October 2021 I (re)started coding scraper for this project and published this page with “coming soon” message. I realized that make pages list some models multiple times, model pages also list submodels and when running scraper on each submodel I got trims of all submodels of a model, etc, thus got many duplicates (this happened in 2019 to get 53,000+ models). Using Excel duplicate remover, I found 37485 unique cars.

I completed project on 23 October 2021, but this turned into a disappointment. The website www.auto123.com chosen by original 2019 customer is lagging in updates. Number of cars for model years 2018 onward is smaller than average for 1990-2017, and although contains plenty of 2021 models from US manufacturers, for most of European and Japanese imports, the latest year is 2019 (see Statistics sheet inside SAMPLE file for exact coverage for each make). If you don’t deal with too new cars, Canada may be still a good database to buy.

If new cars are crucial for you, please buy instead United States car database best-selling database made by me since 2015 and always up-to-date.

List of updates

15 Oct 2021 – 75 makes, 1052 models, 13834 model years, 37485 trims.

Leave a Reply

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