Data dictionary
Australian vehicle data dictionary27 columns, every row
One row per vehicle variant per year - 133,279 rows in release 2026.11. The same columns, in the same order, in the CSV, the Excel workbook, the SQL table and the JSON. Columns marked Full are never shown on this website.
| # | Column | Type | Example | What it holds |
|---|---|---|---|---|
| 01 | NVIC Full | Text (6) | 0E3426 | National Vehicle Identification Code - the code Australian insurers, financiers and valuers use to identify an exact variant in a given year. |
| 02 | GuideID Full | Integer | 10204517 | The variant's numeric identifier in the source vehicle guide. Unique per row; stable between releases. |
| 03 | Year | Integer | 2026 | The year the variant is listed for. A model on sale for several years appears once per year, each with its own NVIC. |
| 04 | MakeCode Full | Text (4) | ABAR | Short code for the make. |
| 05 | Make | Text | ABARTH | Manufacturer / brand, in capitals as published. |
| 06 | ModelCode Full | Text | 500e | Short code for the model family. |
| 07 | Model | Text | 500E | Model name. |
| 08 | Variant | Text | SCORPIONISSIMA LAUNCH EDITION | Badge or trim level (the name on the boot lid and the price list). |
| 09 | Series | Text | MY23 SERIES 0 | Series, generation or model-year code (e.g. MY23, GR, VDJ79R). Blank where the maker has none. |
| 10 | Body | Text | H/BAC | Body style: SEDAN, WAGON, H/BAC (hatch), C/CHA (cab chassis), UTE, P/UP (pick-up), VAN, COUPE, CONVT, CABRO, RDSTR, H/TOP, S/TOP, L/BAC, TRAY, TRUCK, BUS, PMOVER. |
| 11 | Doors | Integer | 3 | Number of doors. |
| 12 | Transmission | Text (1) | A | A = automatic, M = manual, O = continuously variable (CVT), S = automated dual-clutch / sports automatic, T = automatic with manual mode. |
| 13 | Gears | Integer | 1 | Number of forward gears (1 for a CVT or most electric vehicles). |
| 14 | Fuel | Text | PETROL | PETROL, DIESEL or LPG. Blank where the source gives no fuel - most battery electric vehicles. |
| 15 | EngineCC | Integer | 1368 | Engine capacity in cubic centimetres (0 for battery electric). A few heavy trucks are recorded in litres. |
| 16 | Cylinders Full | Integer | 4 | Number of cylinders, where published. |
| 17 | Drive | Text | FWD | Driven wheels: FWD, RWD, AWD, 4WD, 4X4, 4X2, 2WD, 6X4, 6X2, 6X6, 8X4. |
| 18 | Turbo Full | 0 / 1 | 1 | Turbo flag as coded in the source. |
| 19 | VehicleType Full | Text (3) | PVG | Segment: PVG = passenger vehicle, CVG = light commercial, OCG = older passenger vehicle, OLC = older light commercial, HCV = heavy commercial, IMP = imported (grey / parallel import). |
| 20 | HighPerformance Full | 0 / 1 | 0 | 1 where the variant is flagged as a high-performance vehicle. |
| 21 | MarketValue Full | Integer (A$) | 46800 | Market value in whole Australian dollars at the release date. |
| 22 | RetailValue Full | Integer (A$) | 46800 | Retail value in whole Australian dollars at the release date. |
| 23 | TradeValue Full | Integer (A$) | 40200 | Trade-in value in whole Australian dollars at the release date. |
| 24 | TradeLowValue Full | Integer (A$) | 34000 | Low trade-in value in whole Australian dollars at the release date. |
| 25 | KerbWeightKg Full | Integer | 1335 | Kerb weight in kilograms, where published. |
| 26 | LengthMm Full | Integer | 3673 | Overall length in millimetres, where published. |
| 27 | ReleaseMonth Full | Text (YYYY-MM) | 2023-07 | The month the variant was released in Australia. |
Good to know
How the data is shaped
- One row per variant per year. A model sold for five years appears five times, each with its own NVIC and values. The pair
NVIC + Yearis the primary key. - Names are as published - in capitals, exactly as the market lists them - so they match the systems insurers and financiers use.
- Values are whole Australian dollars at the release date, and are indicative - a guide, not a quote.
- Blank means "not published", never zero: cylinders, weights and lengths are missing for some older and heavy vehicles. EngineCC is 0 for battery-electric vehicles.
- Codes are explained in the body, transmission and drive codes guide.
Ready when you are
The whole Australian market. One download.
133,279 variants with NVIC codes, specs and values - CSV, Excel, SQL and JSON - for one payment of $149 AUD. Updates every 6 months included.
Free sample first$149AUD ยท ONCE
My downloads