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: 6 June 2021, including 2654 “2021 models” and 98 “2022 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 (127 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 (I update every 2 months):
Contact me if you want to buy subsets, example 2010-present, SUV only, specific makes only, etc (filtering makes or body type will cost twice per row than price of complete database), buying custom subset prevent you downloading updates yourself, but are useful if you need database for one-time use, for example to decide what used car to buy.
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.
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 trims when importing in your application. You can re-sort years if you want newer cars first.
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 1 April 2021 update using a filtered database 2001-2022 (49719 trims, out of 62441 total trims 1990-2022), because some 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.13%, Model 100%, Year 100%, Trim (description) 100%.
Price & colors: MSRP 99.97%, Invoice 96.29%, Colors exterior 99.57%, Colors interior 99.35%.
Dimensions and weight: Body type 100%, Doors 100%, Total seating 99.88%, Length 99.59%, Width 97.62%, Height 98.84%, Wheelbase 99.73%, Front track 55.89%, Rear track 55.74%, Ground clearance 71.03%, Angle of approach 34.29%, Angle of departure 34.33%, Turning circle 90.92%, Drag coefficient 22.16%, EPA interior volume 42.95%, Cargo capacity 67.87%, Maximum cargo capacity 50.07%, Curb weight 92.83%, Gross weight 61.72%, Maximum payload 50.60%, Maximum towing capacity 58.60%.
Engine and transmission: Cylinders 99.29%, Engine size 99.29%, Horsepower 99.34%, Torque 98.39%, Valves 99.21%, Valve timing 72.75%, Cam type 99.21%, Drive type 99.97%, Transmission 99.97%.
Fuel and mileage: Engine type 99.97%, Fuel type 99.80%, Fuel tank capacity 98.46%, Combined MPG 83.78%, EPA mileage City/Highway 83.29%, Range City/Highway 99.97%, EPA Combined MPGe 0.93%, EPA City MPGe 0.59%, EPA Highway MPGe 0.56%, EPA KWh/100 Mi 0.61%, EPA Time To Charge Battery (At 240V) 0.65%, EPA Electricity Range 0.65%.
Interior dimensions: Front head room 95.95%, Front hip room 79.38%, Front leg room 95.18%, Front shoulder room 94.92%, Rear head room 85.86%, Rear hip room 70.52%, Rear leg room 85.19%, Rear shoulder room 84.85%.
Warranty: Basic 99.52%, Drivetrain 99.33%, Roadside 92.80%, Rust 99.18%, Free maintenance 27.80%, Hybrid component 3.57%, EV battery 0.64%, Source JSON 100%
Review (review pages) Source URL 100%, Image URL 99.99%, NHTSA Overall Rating 23.60%.
Data extracted from Review pages:
Description: Review full 88.98%, Review 1 9.30%, Review 2 9.28%, Review 3 9.26%, Review 4 9.30%, What’s new 10.48%, Pros 99.46%, Cons 99.46%.
Scorecard: Scorecard Overall 17.01%, Scorecard Driving 10.89%, Scorecard Confort 10.78%, Scorecard Interior 10.94%, Scorecard Utility 10.38%, Scorecard Technology 7.91%.
Expert rating: Our verdict 7.56%, Driving 7.52%, Comfort 7.54%, Interior 7.52%, Technology 7.54%, Storage 7.53%, Economy 7.56%, Value 7.54%, Wildcard 7.55%.
Data extracted from HTML pages (not available for cars launched after March 2020):
Old naming: Trim 94.26%, description 94.26%, Images URL 80.23%, Suspension 93.73%.
Interior features: Front seats 94.21%, Rear seats 80.73%, Power features 93.84%, Instrumentation 93.99%, Convenience 94.16%, Comfort 93.68%, Memorized settings 25.15%, In car entertainment 93.97%, Telematics 0.00%.
Exterior features: Roof and glass 94.10%, Body 29.60%, Truck features 31.83%, Tires and wheels 94.22%, Doors 28.48%, Towing and hauling 55.12%.
Safety: Safety features 94.08%.
Optional features: Packages 48.21%, Exterior options 53.37%, Interior options 52.93%, Mechanical options 36.70%
Bonus data (added by me):
Domestic / imported 100%, Country of origin 100%, Car classification 100%, Platform code / generation number 100%, Date added 100%.
Download free SAMPLE:
Year-Make-Model-Trim-Engine (9 columns)
Buy complete database + FREE updates for one year:
For startups who do not need a huge database with 60,000+ rows for every trim, I offer shortlisted databases with trims removed.
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.