CarsDataset / Guides / Car make, model and year dataset (CSV)
Dataset
Car make, model and year dataset (CSV)
If you need a make → model → year list for a form, a marketplace or analysis, a plain list gets you started; a list with specs lets you show and filter by power, fuel and size. CarsDataset is both: 47,344 rows, 108 brands, model years 1898–2026.
The columns
Every row is a variant (a specific engine and trim of a model in a model year). The first columns give you the make/model/year hierarchy; the rest are specifications:
brand, model, year, variant_name, trim, body_type, fuel_type, power_hp, power_kw, torque_nm, transmission_type, drive_type, dimensions, weight, performance, fuel consumption, CO₂, flags and features (39 in total).
A real excerpt
brand,model,year,variant_name,fuel_type,power_hp,transmission_type,drive_type
BMW,X4,2023,2023 BMW X4 30i (248 Hp) xDrive Steptronic,gasoline,248,automatic,all-wheel
BMW,X3,2024,2024 BMW X3 M50 (398 Hp) Mild Hybrid xDrive Steptronic,gasoline,398,automatic,all-wheel
BMW,4 Series,2023,2023 BMW 4 Series M440i (382 Hp) Mild Hybrid Steptronic,gasoline,382,automatic,rear-wheel
Largest makes in the file
| Make | Variants | Years |
|---|---|---|
| Hyundai | 3,044 | 1974–2026 |
| Renault | 2,780 | 1898–2026 |
| Volvo | 2,506 | 1927–2026 |
| Mercedes | 2,413 | 1993–2026 |
| Opel | 2,103 | 1899–2026 |
| Volkswagen | 2,091 | 1977–2026 |
| Toyota | 2,000 | 1980–2026 |
| BMW | 1,906 | 1982–2026 |
| Ford | 1,714 | 1908–2026 |
| Honda | 1,625 | 1963–2025 |
| Fiat | 1,563 | 1899–2026 |
| Audi | 1,545 | 1968–2026 |
All 108 brands with counts are on the makes page.
Building a make → model → year dropdown
- Distinct
brandvalues for the first list. - Distinct
modelfor the chosen brand, ordered by variant count or name. - Distinct
yearfor brand + model, newest first. - Optionally a fourth step with
variant_name(engine and power) to identify the exact car.
The import guide has the SQL for each step.
Good to know before you buy
- Model names are kept as published by the source. For some makes, older trims appear as separate model names, so plan a small mapping table if you need strictly clean model families.
- Coverage is strongest for European-market cars from 2010 on (34,850 variants). US-only models are less complete.
- Fill rates: power 99.7%, dimensions 94.8%, combined fuel consumption 76.0%, CO₂ 69.5%, equipment lists 39.5%.
- The file is a one-time purchase ($499) with two quarterly refreshes in the first six months.
See the data yourself
200 real rows, same columns as the paid files.