Second American car database

Download free SAMPLES:
American-Car-Database-No-Specs-by-Teoalida-SAMPLE.xls (5 columns)
American-Car-Database-Basic-Specs-by-Teoalida-SAMPLE.xls (28 columns)
American-Car-Database-Full-Specs-by-Teoalida-SAMPLE.xls (210 columns)

Buy complete database + FREE updates for one year:

•  2018-2020, no specs (5 columns), 43 makes, 836 model years, 6215 model trims, 0.5 cents/trim – $31.07
•  2018-2020, basic specs (28 columns), 43 makes, 836 model years, 6215 model trims, 1 cents/trim – $62.15
•  2018-2020, full specs (230 columns), 43 makes, 836 model years, 6215 model trims, 2 cents/trim – $124.30
•  1990-2020, no specs (5 columns), 61 makes, 8547 model years, 58006 model trims, 0.25 cents/trim – $145.02
•  1990-2020, basic specs (28 columns), 61 makes, 8547 model years, 58006 model trims, 0.5 cents/trim – $290.03
•  1990-2020, full specs (230 columns), 61 makes, 8547 model years, 58006 model trims, 1 cents/trim – $580.08

Add to cart Checkout Added to cart

Last release: December 2019. I abandoned second American database to focus updating first American database more often (Year-Make-Model-Trim-Specs, started in 2014 and updated every 2 months) and other databases for rest of world.

History & accuracy notes

The first American database, Year-Make-Model-Trim-Specs was missing some essential info, for example MSRP (manufacturer’s suggested retail price), in October 2017 one customer interested in MSRP suggested me to extract data from TheCarConnection.com, then in November 2017 another customer asked me for specific technical specs available in TheCarConnection so I sold him same database, re-scraped to include all specifications. After selling privately to 2 customers, both interested in 2017-2018 models only, I decided to scrap ALL 1990-2018 models and publish database on website, naming it “Second American car database”.

Inconsistencies: until mid-2019 there was no unique ID for each car, URL is unique but they occasionally change URLs, merging cars with too similar specs thus deleting some cars, etc. In mid-2019 they deleted nameplates discontinued before 2015 (details below), forcing me to provide December 2019 update as separate file than previous one, some customers had trouble combining new file with older file to have ALL cars in 1 database.

While specifications for each individual car are pretty accurate, filtering cars of a specific class may be a trouble, because it contains multiple values having same meaning: “midsize car”, “midsize cars”, “mid-size cars”. Model hierarchy was slightly messed, for example Jetta is 1996-2005, 2009-2014, 2017-2018, New Jetta is 1999, Jetta Sedan 2002-2016, etc (they corrected this in mid-2019).

Second American database is sold “as it is” on source website, without corrections or additions, because any changes I do, will be lost at next update.

First American database, beside nearly perfect specs accuracy, I manually-built URLs of car models using Edmunds unique IDs that are constant over time and nothing is deleted. I also improved model hierarchy, corrected errors and expanded database with additional data not available on Edmunds, for which in May 2018 I made a more complex JSON scraper (instead of HTML) and added MSRP (for 2001-present cars) in first American database, which been outselling second American database 10 times, keeping updates on-going for 2 databases targeting same market became worthless.

I kept second American database for sale because it still have some data not existing in first database, for example MSRP for 1990-2000 models, gear ratios, dimensions for cargo area / trunk bed (length, width between wheel arches, height to roof), etc. But very few people are interested in these specs.

List of car makes

Acura, Alfa Romeo, AM General, Aston Martin, Audi, Bentley, BMW, Buick, Cadillac, Chevrolet, Chrysler, Coda, Daewoo, Dodge, Eagle, Ferrari, FIAT, Fisker, Ford, Genesis, Geo, GMC, Honda, HUMMER, Hyundai, INFINITI, Isuzu, Jaguar, Jeep, Kia, Lamborghini, Land Rover, Lexus, Lincoln, Lotus, Maserati, Maybach, Mazda, McLaren, Mercedes-Benz, Mercury, MINI, Mitsubishi, Nissan, Oldsmobile, Panoz, Plymouth, Pontiac, Porsche, Ram, Rolls-Royce, Saab, Saturn, Scion, smart, Subaru, Suzuki, Tesla, Toyota, Volkswagen, Volvo.

List of updates

TheCarConnection was originally 1997-present. As March 2018 they added specifications for 1996 models and also 1990-1995 models without specifications (only model names and price). I do not know if in the future, they will add specifications for pre-1996 cars too.

59 makes, 1136 models, 7224 model years, of which 6608 with specs, ? with trims, 46140 trims, as December 2017
61 makes, 1191 models, 8390 model years, of which 8074 with specs, 6644 with trims, 46804 trims, as 12 March 2018, published 18 March.
61 makes, 1210 models, 8651 model years, of which 8313 with specs (? full specs), 56363 trims (? full specs) as 20 September 2018.
61 makes, 1215 models, 8694 model years, of which 8313 with specs (? full specs), 56369 trims (? full specs) as 26 December 2018 (the source website did not added more specs in 3 months?)
61 makes, 1225 models, 8762 model years, of which 8439 with specs (7008 full specs), 57181 trims (49381 full specs) as 1 Feb 2019.
61 makes, 1229 models, 8790 model years, of which 8454 with specs (7023 full specs), 57312 trims (49512 full specs) as 28 March 2019.
61 makes, 1235 models, 8877 model years, of which 8547 with specs (7116 full specs), 58006 trims (50209 full specs) as 4 June 2019.

In mid-2019 TheCarConnection deleted pages of all model nameplates discontinued before 2015. We can still see specs of 1990 Dodge Grand Caravan, because a new model with same name is still in production today, but we cannot see anymore specs of Dodge Caravan (non-Grand) because this nameplate was discontinued in 2007! Strange decision to delete data for discontinued nameplates! Wasn’t TheCarConnection supposed to contain ALL cars that have been sold in United States since 1990 to present?

My idea was to run scraper on all cars and add 2019-2020 models over the 1990-2018 models from June 2019 release. However, in September and early December I did not found enough new cars. The number of cars increased in December, I ran scraper again on 18 December and found more 2020 models, but less 2018 and 2019 models than at previous run, meaning that TheCarConnection is not only updating with new cars but also doing changes in old cars, deleting / merging 2 similar trims into one. Consequently, I provide 2 separate files for June and December 2019 updates, until taking further decision.

521 models, 5629 model years, of which 5449 with specs, 44507 trims, as 16 Sep 2019.
525 models, 5696 model years, of which 5460 with specs, 44558 trims, as 07 Dec 2019.
554 models, 5785 model years, of which 5661 with specs, 46108 trims, as 15 Dec 2019.
46 makes, 538 models, 5786 model years, of which 5660 with specs, 46107 trims, as 24 Dec 2019. This was the LAST published update.

From 2020 onward I only ran scraper on Make, Model, Year breadcrumbs to check number of models, without scraping specifications of each individual model trim. In early 2020 TheCarConnection removed all exotic manufacturers (Aston Martin, Bentley, Ferrari, Lamborghini, Rolls-Royce, etc). Are you fucking serious?

38 makes, 472 models, 5510 model years, of which 5392 with specs, 47493 trims, as 30 May 2020.
38 makes, 476 models, 5544 model years, of which 5419 with specs, of with 5407 with 47724 trims, as 1 July 2020.
38 makes, 476 models, 5646 model years, of which 5532 with specs, of with 5522 with 49019 trims, as 18 October 2020.
39 makes, 454 models, 3632 model years, of which 3575 with specs, of with 3574 with 33711 trims, as 10 August 2022. TheCarConnection removed all model years older than 2008.