Coverage: cars, trucks, SUVs and vans sold in United States from 1990 to present. Every trim is a row, including engine specifications and features.
Last update: 16 August 2024, including 2682 “2024 models” and 689 “2025 models”.
Download free SAMPLES:
Year Make Model Trim .XLSX (5 columns)
Year Make Model Trim Basic Specs .XLSX (31 columns)
Year Make Model Trim Full Specs .XLSX (117 columns)
Alternative file formats: CSV and SQL.
Buy complete database + FREE updates (every 2 months) for one year:
Subsets having 1 row per model, year and body style, eliminating trims. Useful for customers interested in car dimensions which are the same regardless of trim, engine or transmission. Car dimensions, weight and engines are indicated as min-max range.
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:
Engine database have fewer columns, but extra rows indicating optional engine/transmission for certain trims that are not included in the above big database.
Download free SAMPLE:
Year-Make-Model-Trim-Engine (9 columns)
Buy complete database + FREE updates for one year:
Custom / partial database
Contact me for a quote if you want to buy custom selection of columns, makes, years, or body type. Custom subsets won’t let you download updates unless you ask me to send you updates, but are good for one-time use, for example to decide what used car to buy, or academic project.
Electric/hybrid subset I added in 2019 once few customers contacted me saying asking for subset because their business do not deal with internal combustion engines, but this seems to cause confusion now, some people thinks that first 6 packages are only for gasoline cars and contact me to ask if should buy 2 separate databases to get all cars. WRONG, original 6 packages contain ALL cars including electric ones.
Pre-1990 cars are available in Year-Make-Model without trims or specifications. Based on Wikipedia, it include also cars sold in Canada 1945-present.
Year-Make-Model-Trim-Specs is the best car database for people angry when a popular API closed in 2018 or tired of CarQueryAPI’s missing cars, I sourced most fields from most famous American car website, 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. Full changelog.
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. See list of models included, useful if you are foreigner and want to see if this database cover your country market.
They 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. European exotic manufacturers are missing in 1990-2000.
Cars are sorted by make and model alphabetically, by year new to old, then by trim from low to high. Feel free to re-sort models or years, avoid re-sorting trims when importing in your application.
68 car makes included
American domestic: AM General, Buick, Cadillac, Chevrolet, Chrysler, Dodge, Eagle, Fisker, Ford, Geo, GMC, Hummer, Jeep, Karma, Lincoln, Lucid, Mercury, Oldsmobile, Panoz, Plymouth, Pontiac, Ram, Rivian, Saturn, Tesla.
European imports: Alfa Romeo, Aston Martin, Audi, Bentley, BMW, Bugatti, Ferrari, Fiat, INEOS, Jaguar, Lamborghini, Land Rover, Lotus, Maserati, Maybach, McLaren, Mercedes-Benz, Mini, Polestar, 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, VinFast.
Data fields included with % available
Percentages calculated at 1 October 2022 update for 2001-2023 model years (54310 trims, out of 67032 total trims 1990-2023), because italic fields are NOT available for 1990-2000 models and 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.
Data extracted from JSON files:
Naming: ID 100%, Make 100%, Model 100%, Year 100%, Trim 100%, Trim (description) 100%.
Price & colors: Base MSRP 81.02%, Base Invoice 77.43%, Colors exterior 96.80%, Colors interior 83.83%
Dimensions and weight: Body type 100%, Doors 100%, Total seating 80.95%, Length 99.64%, Width 97.33%, Height 98.41%, Wheelbase 99.79%, Front track 41.46%, Rear track 41.34%, Ground clearance 64.18%, Angle of approach 27.72%, Angle of departure 27.74%, Turning circle 85.86%, Drag coefficient 16.44%, EPA interior volume 34.18%, Cargo capacity 65.09%, Maximum cargo capacity 44.36%, Curb weight 89.65%, Gross weight 56.36%, Maximum payload 48.45%, Maximum towing capacity 54.73%.
Engine and transmission: Cylinders 99.18%, Engine size 99.19%, Horsepower 99.72%, Horsepower rpm 98.04%, Torque 98.57%, Torque rpm 97.49%, Valves 80.28%, Valve timing 60.16%, Cam type 80.28%, Drive type 100%, Transmission 99.22%.
Fuel and mileage: Engine type 99.98%, Fuel type 99.45%, Fuel tank capacity 98.31%, EPA combined MPG 84.29%, EPA city/highway MPG 84.06%, Range in miles (city/hwy) 99.22%, EPA combined MPGe 1.40%, EPA city/highway MPGe 1.13%, EPA electricity range 1.05%, EPA kWh/100 mi 0.99%, EPA time to charge battery (at 240V) 1.00%, Battery capacity (kWh) 0.52%.
Interior dimensions: Front head room 93.67%, Front hip room 76.35%, Front leg room) 92.88%, Front shoulder room) 90.80%, Rear head room 81.50%, Rear hip room 66.40%, Rear leg room 80.96%, Rear shoulder room 79.47%.
Warranty: Basic 80.56%, Drivetrain 80.39%, Roadside 75.31%, Rust 80.29%.
Data extracted from Review pages:
Review: Source URL 100%, Image URL 99.98%, NHTSA Overall Rating 17.52%
Description: Review full 83.19%, Review 1 4.25%, Review 2 4.25%, Review 3 4.23%, Review 4 4.25%, What’s new 10.68%, Pros 85.94%, Cons 84.54%.
Scorecard: Overall 15.74%, Driving 8.08%, Comfort 8.00%, Interior 8.12%, Utility 7.71%, Technology 5.88%.
Expert rating: Our verdict 8.58%, Driving 8.55%, Comfort 8.56%, Interior 8.55%, Technology 8.56%, Storage 7.64%, Economy 3.31%, Value 8.57%, Wildcard 8.58%.
Data extracted from HTML pages (not available for cars launched after March 2020):
Old naming: Trim 88.88%, Description 88.88%, Images URL 73.74%, Suspension 69.52%.
Interior features: Front seats 69.87%, Rear seats 59.87%, Power features 69.60%, Instrumentation 69.71%, Convenience 69.83%, Comfort 69.47%, Memorized settings 18.65%, In car entertainment 69.69%.
Exterior features: Roof and glass 69.79%, Body 21.95%, Truck features 23.61%, Tires and wheels 69.88%, Doors 21.11%, Towing and hauling 40.88%.
Safety: Safety features 72.46%.
Optional features: Packages 35.75%, Exterior options 39.58%, Interior options 39.25%, Mechanical options 27.22%.
Bonus data (added by me):
Domestic / imported 100%, Country of origin 100%, Car classification 100%, Platform code / generation number 100%, Date added 100%.
I’m currently researching a truck to buy in North America and have specific requirements for the vehicles capability. I came across Teodalia’s website and used the live chat feature to inquire. I received a response almost immediately and was able to get a customised data set matching my target brands with detailed information and at a great price. The whole process only took around 10 minutes and has saved me many, many hours of collecting the data myself.
Great service and highly recommended!
Laurence