Download free sample:
Canada Car Database SAMPLE.xlsx (340 columns)
Buy complete database: (NO updates for this one, sorry)
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.
Coverage: cars sold in Canada 1990-2021 but complete for 1990-2017 only, many new cars missing (for 2020 and 2021 it contains only American cars and nothing from Europe and Japan imports). 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 which is always up-to-date.
History
Canada car database was the LAST of the 10+ databases created at request for an Indian company I was working for in 2018-2019, they suggested me to scrape 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, on 29 September 2019 I extracted URLs of 53,000 car models (I suspect some duplicates), and wrote scraper to extract 150+ car specs from each URL, but did not had chance run scraper for specs too and analyze data extracted… HDD crashed on 1 october 2019 made me to lose half of projects done last 2 months including Canada scraper code + data, forcing me to halt work for Indian company, to save time for re-doing other lost projects.
For 1 year I did not recreated Canada car database because I assumed that Canadian customers can use United States car database (almost same cars are sold in both countries). Few customers were interested in buying a Canada car database in addition of United States one. I was facing trouble due 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, on 13 October 2021 I (re)started coding scraper auto123.com, I found 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 (probably this happened in 2019 when I got 53,000+ models).
Removing duplicates left 37485 unique cars, but this turned into a disappointment. I published Canada database on 23 October 2021 after 10 days of work.
I don’t know how complete was www.auto123.com in 2019, but currently it is lagging in updates. The only good thing is that I haven’t published in 2019, otherwise would have been today more customers demanding updates that I cannot provide. Should I remove Canada car database from sale?
List of updates
As 15 October 2021 I found 75 makes, 1052 models, 13834 model years, 37485 trims. Number of cars for model years 2018 and 2019 is smaller than average for 1990-2017, and for 2020 and 2021 it contains only American cars and nothing from Europe and Japan imports). Mercedes last year is 2017: https://www.auto123.com/en/new-cars/search/mercedes/
As 27 January 2022 I found 75 makes, 935 models, 11367 model years, 29661 trims, all 2021 models were removed as well as 70% of 2020 models, most years have less number of cars compared with October, number of trims increased only for 1993-1995 years, making me concerned about intentions of people behind auto123.com website.
As June 2023 I ran scraper again and found same number of models and trims like in January 2022. Nothing has been updated on Auto123.com = DEAD website!
