American Year Make Model Trim Specs

Year-Make-Model-Trim-Specs is the best car database for people angry after closure of Edmunds API or tired of CarQueryAPI’s missing cars, I sourced most fields from Edmunds, added 4 extra fields by myself, did few improvements in model hierarchy and created an Excel database with completeness and accuracy having no equivalent on internet. Watch video!

Last release: 3 December 2020, including 2869 “2020 models” and 1495 “2021 models”. Full changelog.

Download free SAMPLES:
Year Make Model Trim .XLSX (5 columns)
Year Make Model Trim Basic Specs .XLSX (32 columns)
Year Make Model Trim Full Specs .XLSX (109 columns)
Alternative file formats: CSV and SQL (note: phpMyAdmin truncate certain columns, do not judge quality of database by SQL sample, use Excel instead).

Buy complete database + FREE updates for one year:

Contact me if you want to buy partial database, example 2010-present, SUV only, etc, useful for people deciding what used car to buy.

American car database coverage

Complete for all cars, trucks, SUVs and minivans sold in United States from Model Year 1990 to present. Canada-specific cars are NOT included in this database based on Edmunds because this website focus on United States only (Canadian cars are included in Year-Make-Model based on Wikipedia). If you are not from USA and want to use this database in another country, first check list of models included in database.

Italic makes start at MY 2001 (European exotic manufacturers). Edmunds apparently changed source of data from MY 2001 onward. Specifications are consistent before and after but certain info is available starting from MY 2001 and hierarchy is different, for example Mercedes C43 AMG was listed as separate model until MY 2000 and as trim under C-Class for MY 2001. I manually improved hierarchy to fix these issues.

Cars are sorted by make and model alphabetically, by year old to new (should put new cars at top?), then by trim from low to high. You are advised to NOT re-sort cars when importing in your application.

Looking for pre-1990 cars? You can use Year-Make-Model (1945-present, no trims or specs). However, I am interested to make a specs database with older cars, for my personal research and for selling to people dealing with older cars! Show me a website similar with Edmunds but with longer historical coverage, that include at least car engine size, power and dimensions, and I may create a new database for you!

List of car makes included

American domestic: AM General, Buick, Cadillac, Chevrolet, Chrysler, Dodge, Eagle, Fisker, Ford, Geo, GMC, Hummer, Jeep, Lincoln, Mercury, Oldsmobile, Panoz, Plymouth, Pontiac, Ram, Saturn, Tesla.

European imports: Alfa Romeo, Aston Martin, Audi, Bentley, BMW, Bugatti, Ferrari, Fiat, Jaguar, Lamborghini, Land Rover, Lotus, Maserati, Maybach, McLaren, Mercedes-Benz, Mini, Porsche, Rolls-Royce, Saab, Smart, Spyker, Volkswagen, Volvo.

Asian imports: Acura, Daewoo, Genesis, Honda, Hyundai, INFINITI, Isuzu, Kia, Lexus, Mazda, Mitsubishi, Nissan, Scion, Subaru, Suzuki, Toyota.

Data fields included with % available

Percentages calculated at 18 May 2020 update using a filtered database 2001-2021 (47303 trims, out of 60029 total trims 1990-2021). Italic fields are NOT available for 1990-2000 models and I excluded them because would have screwed up percentages, while most customers deal with cars 10-20 years old max so don’t care about missing data in older cars.

Naming: ID 100%, Make 100%, Model 100%, Year 100%, Trim & description 100%.

Price & colors: MSRP 100%, Invoice 96.84%, Colors exterior 99.55%, Colors interior 99.26%.

Dimensions and weight: Body type 100%, Total seating 99.90%, Length 99.62%, Width 97.88%, Height 98.88%, Wheelbase 99.79%, Front track 58.75%, Rear track 58.58%, Ground clearance 70.87%, Angle of approach 34.08%, Angle of departure 34.12%, Turning circle 91.38%, Drag coefficient 23.30%, EPA interior volume 42.99%, Cargo capacity 67.75%, Maximum cargo capacity 50.04%, Curb weight 92.94%, Gross weight 61.57%, Maximum payload 50.19%, Maximum towing capacity 58.52%.

Engine and transmission: Cylinders 99.41%, Engine size 99.41%, Horsepower (HP & rpm) 98.64%, Torque (ft-lbs & rpm) 98.18%, Valves 99.32%, Valve timing 71.92%, Cam type 99.32%, Drive type 100%, Transmission 100%.

Fuel and mileage: Engine type 100%, Fuel type 99.82%, Fuel tank capacity 98.66%, Combined MPG 83.99%, EPA mileage 83.58%, Range 82.41%.

Interior dimensions: Front head room 95.98%, Front hip room 79.30%, Front leg room 95.22%, Front shoulder room 94.96%, Rear head room 85.67%, Rear hip room 70.34%, Rear leg room 84.99%, Rear shoulder room 84.67%.

Warranty: Basic 98.14%, Drivetrain 96.78%, Roadside 74.25%, Rust 37.11%, Free maintenance 24.44%, Hybrid component 3.55%, EV battery 0.42%.

Review: Source URL 100%, MSRP Range 12.64%, What’s new 12.00%, Pros 99.36%, Cons 99.36%, Image URL 98.94%.

Bonus data (added by Teoalida): Domestic / imported 100%, Country of origin 100%, Car classification 100%, Platform code / generation number 100%, Date added 100%.

Additional fields sourced from Edmunds old-styled HTML pages (no longer available for cars launched after March 2020):

Old naming: Trim 99.07%, Description 99.07%, Images URL 84.33%, Suspension 98.52%.

Interior features: Front seats 99.02%, Rear seats 84.85%, Power features 98.63%, Instrumentation 98.79%, Convenience 98.96%, Comfort 98.46%, Memorized settings 26.44%, In car entertainment 98.77%.

Exterior features: Roof and glass 98.90%, Body 31.11%, Truck features 33.46%, Tires and wheels 99.03%, Doors 29.93%, Towing and hauling 57.94%.

Safety: Safety features 99.06%.

Optional features: Packages 50.67%, Exterior options 56.09%, Interior options 55.63%, Mechanical options 38.57%.

See also: Analysis of American cars evolution 1990-2020.

Engine database (added November 2019)

Download free SAMPLE:
Year-Make-Model-Trim-Engine (9 columns)

Buy complete database + FREE updates for one year:


Shortlisted databases (NEW packages added 20 May 2020)

For startups who do not need a huge database with 60,000+ rows for every trim, I offer shortlisted databases with trims removed.

Download free SAMPLES:
Make-Model (2 columns)
Year-Make-Model-Image (5 columns)
Year-Make-Model-Body-Dimensions (15 columns)

Buy complete database + FREE updates for one year:

Note: car images are NOT specific by body style. Example: BMW 3-Series can be sedan, wagon, coupe, cabrio, photo URL is the same for all 4, showing same body style at random.

Make & Model and Year-Make-Model were originally made as custom sheet for a specific customer, but seeing that other people are interested in same thing, I made them public so everyone can purchase.

The dimensions database originated from an experiment made in 2015 for Lexus, manually filtering database to a single row per Year / Make / Model / Body combination, I did not made for all cars because it would have taken dozens hours of manual work and risk cannibalizing sales of bigger database, also I was undecided what to do in case of variable dimensions. In 2020 I figured out how to automatize this task using Excel formulas to generate min/max values for cars that have variable dimensions for same body style (example Ford F-150 with short and long bed), the job took just few hours. I hope that these databases will help me to get additional customers and NOT turn customers that could afford full specs database to the (cheaper) dimensions database and affect my income negatively…

For 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 better.

Old samples from May 2019:
Year-Make-Model-Trim (7 columns)
Year-Make-Model-Trim-Basic-Specs (31 columns)
Year-Make-Model-Trim-Full-Specs (86 columns)

Poll

How often do you want updates? (Year-Make-Model-Trim-Specs)

Every month
Every 3 months
Every 6 months
Every year
One-time project, not interested in updates
Other
Please Specify:
Created with Poll Maker

35 thoughts on “American Year Make Model Trim Specs

  1. I first bought the carquery database/API… My developer could not get it to work to show US makes only… I emailed them several times and the never replied to me… I bought the same product from Teoalida and it works great, and when we had a question he responded to us very promptly…

    Thank you Teoalida,

  2. This database has powered my company’s website for over a year. The data it contains is excellent and accurate. The support has been beyond my expectations and has given me comfort in knowing that I’m not wasting my money. Free updates are sent out by email when they are a ready so I don’t have to try to track down an update.

  3. The Year-Make-Model-Trim-Full-Specs Package is the best!!! Thank you for hard work, especially that you were able to return to the expended database as it was until March 2018 release!
    Thank you for your time Teoalida

  4. We are an automotive paint mixing company and are building a website to include all car manufactures US/Foreign. We are looking to obtain paint codes for all years makes and models foreign and domestic from 1950-2019.

  5. Hi

    I am looking for American Cars Database with below values only:

    Naming –> Make Model Year Trim
    Tires –>
    Wheels –>

    What will be the best option and price for these values.

    Thanks

    Raman

  6. This data is awesome. We are using it to be able to properly spec out customers who need paint protection patterns cut for their vehicles and we would do a lot of back and forth. Now it is three questions, Make, Model and trim and most issues are resolved.

  7. Awesome data set with a definitive list of trim level details. Especially helpful is the safety feature attribute. Super customer service (helped filter and create a custom package over the weekend in less than 5 minutes).

Leave a Reply

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