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
Engine specs
| Type | four-stroke, liquid-cooled, inline four-cylinder, DOHC |
| Displacement | 1099 cm3 |
| Bore X Stroke | 76 mm |
| Compression Ratio | 11.8:1 |
| Fuel System | DFI, 38 mm throttle bodies |
| Horsepower | 98 KW |
| Torque | 7600 Nm |
| Color | Metallic Graphite Gray/Metallic Diablo Black |
| Electronic Rider Aids | Kawasaki Intelligent anti-lock Brake System (KIBS) Kawasaki Electronic Control Suspension (KECS) Kawasaki Cornering Management Function (KCMF) IMU-Enhanced Chassis Orientation Awareness Kawasaki Quick Shifter (KQS) Kawasaki Traction Control (KTRC) Anti-lock Brake System (ABS) Economical Riding Indicator Electronic Cruise Control Power Modes |
Tyres specs
| Front | 120/70-17 |
| Rear | 180/55-17 |
Transmission specs
| Gearbox | 6-speed, return shift |
| Clutch | wet, multi-disc, manual, Assist & Slipper Clutch |
| Final Drive | chain |
Chassis specs
| Frame | twin-tube, aluminum |
| Front Suspension | 43 mm, inverted, Showa fork with KECS-controlled rebound and compression damping, manual spring preload adjustability and top-out springs, 150 mm/5.9 inch travel |
| Rear Suspension | Horizontal back-link, Showa BFRC Lite gas-charged shock with piggyback reservoir, KECS-controlled compression and rebound damping electronically-adjustable spring preload, 150 mm/5.9 inch travel |
| Front Brake | 310 mm |
| Rear Brake | single 260 mm, petal disc, single-piston caliper |
Dimension specs
| Overall Length | 2271 mm |
| Overall Width | 950 mm |
| Seat Height | 841 mm |
| Wheelbase | 1519 mm |
| Ground Clearance | 150 mm |
| Weight | 257 kg |
| Fuel Capacity | 20.8 l |
| Overall Height | 1529 mm |
| Dry weight | 236 kg |
| Curb Weight | 259 kg |
| Rake | 27 ° |
| Trail | 102 mm |
Example shows what information about the specific trim is stored in the motorcycle 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.
