Canada car database

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?