Web Analytics Made Easy -
StatCounter

Second American car database

Database starts at 1990 with model naming and prices, but specifications are available starting from 1996. Last release: 14 June 2019, including 2744 models of MY 2019 and 645 of MY 2020.

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 FULL database + FREE updates for one year:

Description

I offered a car database for USA market since 2014, named Year-Make-Model-Trim-Specs, but it does not have several things that some customers were looking for, for example MSRP (manufacturer’s suggested retail price) until April 2018 update.

I discovered another easy-to-scrap website in October 2017 when a customer interested in MSRP suggested me to do scraping from that website and create a new database for American market, then in November 2017 another customer asked me for specific data so I offered to sell 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 1997-2018 models and publish database on website so everyone can purchase.

As March 2018 I realized that the source website 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.

Accuracy notes

This car database is made via web scraping and sold “as it is” without corrections or additions, because any changes done will be lost at next update. 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 is slightly messed, for example Jetta is 1996-2005, 2009-2014, 2017-2018, New Jetta is 1999, Jetta Sedan 2002-2016, etc.

You are advised to buy Year-Make-Model-Trim-Specs if you care about accuracy, unless you need certain data available only in the 230 columns package of the Second American Car Database.

Year-Make-Model-Trim-Specs beside nearly perfect specs accuracy, it is based on a manually-built list of car models URLs thus I was able to improve model hierarchy, correct errors and add additional data not included in the original website.

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

1136 models, 7224 model years, of which 6608 with specs, ? with trims, 46140 trims, as December 2017
1191 models, 8390 model years, of which 8074 with specs, 6644 with trims, 46804 trims, as 12 March 2018, published 18 March.
1210 models, 8651 model years, of which 8313 with specs (? full specs), 56363 trims (? full specs) as 20 September 2018.
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?)
1225 models, 8762 model years, of which 8439 with specs (7008 full specs), 57181 trims (49381 full specs) as 1 Feb 2019.
1229 models, 8790 model years, of which 8454 with specs (7023 full specs), 57312 trims (49512 full specs) as 28 March 2019.
1235 models, 8877 model years, of which 8547 with specs (7116 full specs), 58006 trims (50209 full specs) as 4 June 2019.

Each update involve re-scraping all makes, models, years and trim, the job takes about 50 hours at speed of 3 seconds per page.

4 comments

5 pings

Skip to comment form

  1. I need a database that tells me what size class of vehicle customers have when they call. Example Small, mid-size, Full-Size in the US

    1. The above American car database does have car class as sourced from original website, which is NOT accurate, for example it have multiple variations like “midsize car”, “midsize cars”, mid-size cars”.

      I suggest buying one of these 2 alternative databases:
      https://www.teoalida.com/cardatabase/year-make-model/
      https://www.teoalida.com/cardatabase/year-make-model-trim-specs/
      Both have car class manually added by me CORRECTLY instead of being sourced “as it is” from a dodgy website.

    • Walter Gavarrete on June 23, 2019 at 6:11 am
    • Reply

    Where can I find the makes for Heavy trucks, i.e. Peterbilt. Thanks!

    1. If you find any website about trucks similar with KBB or Edmunds I can make an Excel database based on it, for you and other people who asked same thing

  1. […] Another American car database (230 columns) […]

  2. […] Demo / sample Read more & BUY […]

  3. […] people looking for more columns I offer since December 2017 second American car database, with 230 columns but less historical coverage and less accuracy. Choose which suit you […]

  4. […] You are welcome to purchase it even if you are in Europe and America if you need more tire sizes per car than OEM size indicated in Car Models Engines Tires (Europe) and Second American database. […]

  5. […] 2017 that will STOP updating this database and recommend customers to buy other databases like  www.teoalida.com/cardatabase/american/ and […]

Leave a Reply

Your email address will not be published.