Car Database Fields and Vehicle Specifications
Car2DB is a relational vehicle database — available as a MySQL dump, CSV, Excel spreadsheet and REST API, with monthly updates. This page documents the actual fields, tables and data model behind the product, with real examples.
Main SQL tables
car_type |
Vehicle types |
car_make |
Makes |
car_model |
Models |
car_generation |
Generations |
car_serie |
Series |
car_trim |
Trims |
car_specification |
Specifications |
car_specification_value |
Specification values |
These are the actual table names shipped in the dump. Screenshots of each table are on the main page.
Database contents example
Engine
| Horsepower | 22 hp |
| Number of cylinders | 3 |
| Fuel type | Diesel |
| Fuel capacity | 25 l |
Weight
| Machine weight | 1443 kg |
Transmission and drive
| Transmission type | Hydrostatic |
| Drive types | 4WD |
Hydraulics and implements
| Hydraulic flow rate | 23.5 l/min |
| PTO power requirement | 17.7 hp |
| Hitch category | Category 1 |
Example shows what information about the specific trim is stored in the tractor database.
How values and translations work
Specifications are normalized: one table is a dictionary of field names, and another stores the actual value for each trim as a separate row. Every record has a stable numeric ID and creation/update timestamps, so you can track what changed and when.
The same underlying IDs are shared across all language editions of Car2DB — a record for a given trim resolves to the same specifications whichever language database you query. The database is refreshed monthly.
Field coverage depends on the specific make, model, generation and market: not every trim has a value for every field.
Formats and use cases
MySQL & CSV
Full relational dump — best for importing into your own database or data pipeline. Pricing →
How the data is organized
Technical specifications and equipment options are attached at the trim level — the same modification can appear with different values across body styles or markets.
FAQ
Is every field filled in for every vehicle?
No. Field coverage depends on the make, model, generation and data source — some trims have detailed specifications, others only the core fields.
How often is the data updated?
The database is regenerated monthly; see the actuality date on the main page.
In which formats can I get the data?
A MySQL dump and CSV come with every purchase; other formats are listed above.
Which languages are available?
Car2DB ships in 12 languages; this page describes the edition sold on this website.
