Main SQL tables
car_make |
Makes |
car_model |
Models |
car_serie |
Series |
car_trim |
Trims |
car_specification |
Specifications |
car_specification_value |
Specification values |
car_type |
Vehicle types |
These are the actual table names shipped in the dump. Screenshots of each table are on the main page.
Database contents example
Bodywork
| Body type | Tanker |
| The length of the car | 8780 mm |
| The width of the car | 2500 mm |
| The height of the car | 3110 mm |
| Wheelbase | 4250 mm |
| Front track | 2055 mm |
| Rear track | 1830 mm |
Gearbox and handling
| Drive wheels | 4x2 |
| Amount of gear | 9 |
| Model transmission | ZF 9S 109 |
| Transmission type | Manual |
PERFORMANCE
| Fuel tank capacity | 315 l |
| Diamètre de braquage | 16.8 m |
| Angle me to ove. lift, not less | 47 % |
| Maximum speed | 111 km/h |
Payload
| The volume of the tank/bodywork | 8.6 m3 |
| Cross-section | Oval |
| The tank material | Steel |
| Compartments' | 2 pc. |
| The height of self-suction | 4.5 m |
| Pump | 1SVN-80A |
Dimentions and weight
| Curb vehicle weight | 8860 kg |
| Gross vehicle weight | 16000 kg |
| The load on the front axle | 5700 kg |
| The load on the rear axle (trolley) | 10300 kg |
| Tyre dimension | 12 R 22.5 |
Engine
| Engine model | Ecotorq 300 Hp |
| Environmental standard | EURO III |
| Potencia | 7330 cm3 |
| Engine power | 300 bhp |
| Torque | 1100 Nm |
| Engine type | Diesel |
| Pressurization | With intercooling |
| Number of cylinders | 6 |
| Compression ratio | 17.4 |
| Fuel | Diesel fuel |
| Engine power at rpm | 2400 min-1 |
| Torque at rpm | 1800 min-1 |
Suspension and brakes
| Type rear suspension | Spring |
| Type front suspension | Spring |
Example shows what information about the specific trim is stored in the truck 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.
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 11 languages; this page describes the edition sold on this website.
