Zum Inhalt springen
Data dictionary

What every column means

All 71 columns that can appear in a CSV or JSON export, explained — with the official source where there is one, and the traps worth knowing before you build on them.

The column headers stay German. They are explained here, not renamed. A translated label is no longer the official one — you could not hold it against the KBA publication it comes from, and that is the whole point of the data.

Vehicle type keys

The German registration system identifies a vehicle TYPE, not an individual car, by a pair of numbers. They are issued by the KBA and appear in every German registration document.

hsn

Manufacturer key — 4 digits, identifies the manufacturer (Herstellerschlüsselnummer).

KBA SV 4

tsn

Type key — 3 characters, identifies the type within that manufacturer (Typschlüsselnummer).

KBA SV 4

hsn_tsn

Both keys joined, the usual way to reference a type in Germany.

variante

Variant key (VSN) where the type is subdivided further.

kennziffer

Internal ordinal of the key within its listing.

hsn_tsn_schluessel_im_katalog

How many type keys of this brand or model range exist in our catalogue.

Watch out: A count of keys, not of vehicles.

typschluessel_gesamt

Total number of type keys in scope.

typschluessel_zugeordnet

Of those, how many are mapped to a model range in our catalogue.

zugeordnet

Whether this key is mapped to a model range (yes/no).

Makes and models

Two vocabularies sit side by side: what the KBA publishes, and what we curate. Columns ending in `_kba` carry the official wording verbatim.

marke

Brand, in our curated spelling (e.g. “Mercedes-Benz”).

marke_kba

Brand exactly as the KBA writes it.

Watch out: Differs from ours for the largest names: the KBA writes “VW” and “MERCEDES”. Do not join the two columns on equality.

marke_eigene_zuordnung

Our brand assignment where the official one is ambiguous or outdated.

marken_kennung

Stable brand identifier (slug), safe to join on.

konzern

Parent group the brand belongs to (e.g. Volkswagen AG).

modell

Model designation, curated.

modell_kba

Model designation exactly as published by the KBA.

modellreihe

Model range — the level at which the KBA reports monthly registrations.

modellreihe_kba

Model range as published by the KBA.

baureihe

Model range, our curated grouping across generations.

reihen_kennung

Stable identifier of the model range.

handelsname_kba

Trade name as recorded in the register.

generation

Generation within the model range (e.g. a facelift or a new platform).

baujahr_von

First production year of that generation.

baujahr_bis

Last production year; empty while still in production.

produktionsstatus

Whether the brand is still producing, or historical.

produktkategorien

Vehicle categories the brand covers (cars, motorcycles, commercial, agricultural, trailers).

herkunftsland

Country of origin of the brand as classified by the KBA.

KBA FZ 17

segment_der_modellreihe

Official KBA market segment of the model range (e.g. Kompaktklasse, SUVs).

KBA FZ 12

karosserie_zuordnung

Body type assignment.

Fleet stock

Stock is the number of vehicles registered on a given date — not sales. The KBA reports it as of 1 January each year.

bestand

Registered vehicles on the reference date.

KBA FZ 6

bestand_jahr

The year the stock figure refers to.

pkw_bestand

Passenger cars in stock.

KBA FZ 2 / FZ 27

pkw_bestand_erfasst

The share of that stock our catalogue can attribute to a type key.

Watch out: Around 3.1 % of German cars are recorded without a type key at all and cannot appear in any HSN/TSN-level figure.

stichtag

Reference date of the figure (usually 1 January or a quarter start).

jahr

Reference year.

berichtsjahr

Reporting year of the underlying KBA release.

co2_bezugsjahr

Reference year of the CO₂ figure, which may differ from the stock year.

New registrations

Monthly counts of newly registered vehicles. “Jahr kumuliert” means year to date, from January up to and including the reporting month.

neuzulassungen_monat

New registrations in the reporting month.

KBA FZ 10

neuzulassungen_jahr_kumuliert

New registrations year to date.

neuzulassungen_berichtsjahr

New registrations in the reporting year.

berichtsmonat

Reporting month, as the first day of that month.

marktanteil_monat_pct

Share of all new registrations in that month, in percent.

marktanteil_jahr_kumuliert_pct

Share of all new registrations year to date, in percent.

veraenderung_zum_vorjahresmonat_pct

Change against the same month one year earlier, in percent.

Watch out: A percentage change, not a factor: +110 % means 2.1 times as many, not 1.1 times.

allrad_monat

Of the month’s registrations, how many were all-wheel drive.

cabrio_monat

Of the month’s registrations, how many were convertibles.

Powertrains

The trap in this block is the one that catches everyone: plug-in hybrids are a SUBSET of hybrids in the official statistics, not a separate class beside them.

antrieb

Powertrain classification.

kraftstoff

Fuel type, official KBA wording.

KBA SV 1

bev

Battery-electric vehicles.

bev_monat

Battery-electric registrations in the reporting month.

bev_jahr_kumuliert

Battery-electric registrations year to date.

bev_anteil_am_bestand_pct

Battery-electric share of the fleet, in percent.

diesel_monat

Diesel registrations in the reporting month.

hybrid_inkl_plugin_monat

Hybrids INCLUDING plug-in hybrids.

Watch out: Do not add plug-in hybrids to this column — they are already contained in it.

hybrid_ohne_stecker

Hybrids EXCLUDING plug-in hybrids.

plugin_hybrid

Plug-in hybrids.

plugin_hybrid_monat

Plug-in hybrid registrations in the reporting month.

gas_lpg_cng

Vehicles running on LPG or CNG.

alternative_antriebe

All powertrains other than petrol and diesel, combined.

Technical data

Some of these come from the German type catalogue, others from European type-approval registers. The KBA does not publish vehicle dimensions at all.

leistung_kw

Engine power in kilowatts. Multiply by 1.36 for metric horsepower (PS).

hubraum_ccm

Engine displacement in cubic centimetres.

sitzplaetze

Number of seats including the driver.

zulaessige_gesamtmasse_kg

Maximum permissible laden mass in kilograms.

aufbau

Body type, official KBA classification.

KBA SV 1

abgasnorm

Emission standard (Euro 4, 5, 6 …).

co2_der_modellreihe_gkm

Average CO₂ emissions of the entire model range in the reporting year, across all powertrains.

Watch out: A range average, not the value of the individual type key — and not meaningful for a battery-electric key.

KBA FZ 14

co2_schnitt_gkm

Average CO₂ emissions in grams per kilometre.

benzin_verbrauch_l_je_100km

Average petrol consumption in litres per 100 km.

diesel_verbrauch_l_je_100km

Average diesel consumption in litres per 100 km.

Regions

Germany has 16 federal states and around 400 registration districts. The district is the finest level the official statistics publish for most figures.

bundesland

Federal state (Bundesland) — the 16 top-level regions.

zulassungsbezirk

Registration district (Zulassungsbezirk) — the authority a vehicle is registered with.

Watch out: Roughly 400 districts. Not identical to administrative counties, and their boundaries have changed over time.

Something missing?

If a column is unclear or you need a field we do not publish yet, write to us. We answer in English, and we would rather tell you a figure does not exist than let you infer it from something that looks close.