Year-Make-Model changelog

This was my FIRST car database done at a customer’s request. Started on 5 February 2013 for an American who did not liked the original Car Models List and asked me to recompile the Excel database by multiplying model rows for each Model Year, for vehicles sold in United States 1990-2013.

Later I noticed that this format, weird for me as European, is the typical format for US & Canada car market, useful to dump in MySQL database, so I decided to expand coverage to WW2, and it was purchased by dozens of other customers (primarily web developers).

Release history

5408 domestic (1945-2013) + 3686 imported (1990-2013 but some imported models have unknown years). First edition in March 2013.
5408 domestic + 3820 imported models, 984 KB file, as April 2013. Imports about 80% complete for 1980s, 10% for 1970s.
5408 domestic + 4176 imported models from 55 makes, as May 2013. Corrected with Edmunds, unknown years eliminated, imports about 90% complete for 1980s and 50% complete for 1970s.
5533 domestic + 4243 imported models from 59 makes, as June 2013. Fixed foreign cars rebadged under US brands, and which do not have separate Wikipedia page, were missing from the original Car Models List Worldwide. For example Mitsubishi Chariot sold as Dodge / Plymouth Colt Vista (not a big deal, because the Colt was included), however Colt Vista have nothing related with Colt, in my opinions should be included separately.


5604 domestic + 4433 imported models, from 59 makes, main 2014 update done in June 2013.
5632 domestic + 4460 imported models, from 60 makes, 1086 KB file, as July 2013. Job done, BETA label removed!
5626 domestic + 4493 imported models, from 62 makes, as September 2013. No major update, just fixed few errors and added Daihatsu and Zastava, two makes sold in US so poorly that most do not even know that they WERE imported!
5975 domestic + 4519 imported models, from 65 makes, 1130 KB, as November 2013. Major additions to 1940s-1960s, including Hudson and Nash.
5975 domestic + 4543 imported models, from 66 makes, 1132 KB, as February 2014 (+18 models in 3 months).
5975 domestic + 4575 imported models, from 66 makes, 1134 KB, as May 2014. Few corrections, thanks to the Year-Make-Model-Trim-Specs database that I just launched for sale.


6161 domestic + 4761 imported models, from 66 makes, 1171 KB, main 2015 update done in June 2014.
6174 domestic + 4772 imported models, from 66 makes, 1171 KB, as October 2014.
6180 domestic + 4772 imported models, from 66 makes, 1187 KB, as December 2014.
6181 domestic + 4770 imported models, from 66 makes, 1187 KB, as February 2015.
6116 domestic + 4770 imported models, from 66 makes, ?? KB, as May 2015. Deleted 65 models (MY 1943-1945 which were jumped as the civilian car production was interrupted for military vehicles).


6193 domestic + 4947 imported models, from 66 makes, 1246 KB, main 2016 update done in May 2015.
6193 domestic + 5021 imported models, from 68 makes, 1246 KB, as June 2015. Added 74 imported cars (pre-1980), also added BMW M and Audi S models in naming, not separate row (suggested by a customer of Car Models List Europe).
6239 domestic + 5047 imported models, from 68 makes, 1125 KB, as July 2015.
6239 domestic + 5051 imported models, from 69 makes, 1130 KB, as September 2015.
6336 domestic + 5513 imported models, from 69 makes, 1184 KB, as January 2016. Added some missing domestic cars, mostly captive imports with no dedicated page on Wikipedia, thanks to the Year-Make-Model-Trim-Specs database that I re-launched for sale, also added a lot of imported cars (pre-1980) which were previously omitted due to lack of accurate info regarding what model years they were sold. But as most customers said, better have non-existent cars than missing cars.
6468 domestic + 7257 imported models, from 80 makes, as May 2016, added a lot of European imports, thanks to www.nadaguides.com (new makes added: Austin, Austin-Healey, Citroën, ISO, Jensen, MG, Morris, NSU, Riley, Rover, Triumph).


6548 domestic + 7475 imported models, from 80 makes, 1564 KB, main 2017 update done in June 2016.
6556 domestic + 7481 imported models, from 80 makes, 1566 KB, as December 2016, end-year corrections, removed several 2017 models that were no longer launched, including the 5 Scion models as the make was discontinued in August 2016, added several missing models.
6613 domestic + 8206 imported models, from 90 makes, as May 2017, added more European imports sourced from www.nadaguides.com (new makes added: AC, Alvis, Bristol, Hillman, Lada, Morgan, Panther, Spyker, Tatra), as well as one US brand: DeSoto.


6708 domestic + 8472 imported models, from 90 makes, added all “2018 models” in June 2017, also split up on separate rows certain models and added RAM separate from Dodge.

6759 domestic + 8478 imported models, from 90 makes, 1700 KB, end-year corrections, removed several 2018 models that were no longer launched, added several missing models.


6838 domestic + 8742 imported models, from 90 makes, 1737 KB, added all “2019 models” in May 2018, also added several older cars.

6843 domestic + 8763 imported models, from 90 makes, 1740 KB, end-year corrections done in January 2019.


6969 domestic + 9009 imported models, from 90 makes, ? KB, added all “2020 models” in May 2019.

7034 domestic + 9152 imported models, from 96 makes, 1803 KB, added 6 more brands in May 2019: Daimler, Fisker, Freightliner, Nash-Healey, Packard, Sunbeam.


7043 domestic + 9171 imported models, from 97 makes, 1807 KB, added McLaren, few corrections in December 2019.

7119 domestic + 9394 imported models, from 98 makes, 704 KB, added all “2021 models” in April 2020, added Polestar, changed file format from XLS to compressed XLSX.

Dilemma

The original customer told me to move platform codes to a separate column, later I realized that americans do not use platform code in model naming, and I am the only one selling a database containing this info. Some of my subsequent customers deleted the platform code column causing few duplicates in year-make-model columns. Would be better if… for example 1999 BMW 3-Series E36 / E46 (1 row for overlapping year) instead of 1999 BMW 3-Series E46 / 1999 BMW 3-Series E46 (two rows, one for each model platform)?

Leave a Reply

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