Last update: 1 August 2023
Download sample XLS, CSV, SQL
1990-present
66 makes
10000+ model years
69000+ model trims
117 columns of specifications
(exterior and interior dimensions, engines, mpg, mileage, features, colors, invoice, MSRP, etc)
Last release: 25 May 2023
Download sample XLSX, CSV, SQL
All cars, trucks, vans and SUVs sold in United States & Canada
1945-present
100 brands
17000+ model years
5 columns (no engines or specifications)
Verified with KBB, Edmunds and NTHSA
New project November 2021
Download sample XLS
1910-1976
500+ brands
32000+ models
80 columns of specifications
Last update: 17 April 2023
Download sample Excel
1950-present
106 makes
1400+ models
12000+ model years
150000+ color codes
Last update: 18 March 2023
Download sample Excel
1950-present
68 makes
1400+ models
13000+ model years
48000+ model trims
Last update: 16 April 2023
Download sample Excel
1980-present
250 makes
3000+ models
30000+ engines
600000+ oil products
Last update: January 2021
Download sample Excel
Cars, trucks, bikes, snowmobiles sold in United States and Canada
1946-present
124 makes
34000+ models
New database made 29 June 2020
Download sample Excel
1970-present
72 makes
3094 models
20974 model years
Last update: 19 December 2019
Download sample Excel
1990-present
61 makes
8000+ model years
50000+ model trims
230 columns of specifications
New product made on 31 February 2020
Download sample XLSX
There are 76702 unique car models in database, and 72240 batteries.
I analyzed how American cars evolved over past 30 years. The average engine size rose from 3.33 L in 1990 to 4.09 L in 2007 then dropped to 3.42 L in 2022 due to introduction of turbochargers that allowed downsizing engines, meantime horsepower rose from 142 HP in 1990 to 313 HP in 2022.
Year-Make-Model is a car database started in February 2013. This page shows number of makes and model years at each successive update.
Year-Make-Model-Trim-Specs is a project started in 2014, This page show number of makes, model names, model years and trims at each successive update.
While analyzing data scraped from Edmunds, I decided to do several changes, correcting few obvious mistakes (example: AMG models and Yukon Denali) and improving model hierarchy to reduce number of so-called models with short production period, which are actually trims of a long-production model:
