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.
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.
hsnManufacturer key — 4 digits, identifies the manufacturer (Herstellerschlüsselnummer).
KBA SV 4
tsnType key — 3 characters, identifies the type within that manufacturer (Typschlüsselnummer).
KBA SV 4
hsn_tsnBoth keys joined, the usual way to reference a type in Germany.
varianteVariant key (VSN) where the type is subdivided further.
kennzifferInternal ordinal of the key within its listing.
hsn_tsn_schluessel_im_katalogHow many type keys of this brand or model range exist in our catalogue.
Watch out: A count of keys, not of vehicles.
typschluessel_gesamtTotal number of type keys in scope.
typschluessel_zugeordnetOf those, how many are mapped to a model range in our catalogue.
zugeordnetWhether 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.
markeBrand, in our curated spelling (e.g. “Mercedes-Benz”).
marke_kbaBrand 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_zuordnungOur brand assignment where the official one is ambiguous or outdated.
marken_kennungStable brand identifier (slug), safe to join on.
konzernParent group the brand belongs to (e.g. Volkswagen AG).
modellModel designation, curated.
modell_kbaModel designation exactly as published by the KBA.
modellreiheModel range — the level at which the KBA reports monthly registrations.
modellreihe_kbaModel range as published by the KBA.
baureiheModel range, our curated grouping across generations.
reihen_kennungStable identifier of the model range.
handelsname_kbaTrade name as recorded in the register.
generationGeneration within the model range (e.g. a facelift or a new platform).
baujahr_vonFirst production year of that generation.
baujahr_bisLast production year; empty while still in production.
produktionsstatusWhether the brand is still producing, or historical.
produktkategorienVehicle categories the brand covers (cars, motorcycles, commercial, agricultural, trailers).
herkunftslandCountry of origin of the brand as classified by the KBA.
KBA FZ 17
segment_der_modellreiheOfficial KBA market segment of the model range (e.g. Kompaktklasse, SUVs).
KBA FZ 12
karosserie_zuordnungBody 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.
bestandRegistered vehicles on the reference date.
KBA FZ 6
bestand_jahrThe year the stock figure refers to.
pkw_bestandPassenger cars in stock.
KBA FZ 2 / FZ 27
pkw_bestand_erfasstThe 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.
stichtagReference date of the figure (usually 1 January or a quarter start).
jahrReference year.
berichtsjahrReporting year of the underlying KBA release.
co2_bezugsjahrReference 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_monatNew registrations in the reporting month.
KBA FZ 10
neuzulassungen_jahr_kumuliertNew registrations year to date.
neuzulassungen_berichtsjahrNew registrations in the reporting year.
berichtsmonatReporting month, as the first day of that month.
marktanteil_monat_pctShare of all new registrations in that month, in percent.
marktanteil_jahr_kumuliert_pctShare of all new registrations year to date, in percent.
veraenderung_zum_vorjahresmonat_pctChange 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_monatOf the month’s registrations, how many were all-wheel drive.
cabrio_monatOf 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.
antriebPowertrain classification.
kraftstoffFuel type, official KBA wording.
KBA SV 1
bevBattery-electric vehicles.
bev_monatBattery-electric registrations in the reporting month.
bev_jahr_kumuliertBattery-electric registrations year to date.
bev_anteil_am_bestand_pctBattery-electric share of the fleet, in percent.
diesel_monatDiesel registrations in the reporting month.
hybrid_inkl_plugin_monatHybrids INCLUDING plug-in hybrids.
Watch out: Do not add plug-in hybrids to this column — they are already contained in it.
hybrid_ohne_steckerHybrids EXCLUDING plug-in hybrids.
plugin_hybridPlug-in hybrids.
plugin_hybrid_monatPlug-in hybrid registrations in the reporting month.
gas_lpg_cngVehicles running on LPG or CNG.
alternative_antriebeAll 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_kwEngine power in kilowatts. Multiply by 1.36 for metric horsepower (PS).
hubraum_ccmEngine displacement in cubic centimetres.
sitzplaetzeNumber of seats including the driver.
zulaessige_gesamtmasse_kgMaximum permissible laden mass in kilograms.
aufbauBody type, official KBA classification.
KBA SV 1
abgasnormEmission standard (Euro 4, 5, 6 …).
co2_der_modellreihe_gkmAverage 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_gkmAverage CO₂ emissions in grams per kilometre.
benzin_verbrauch_l_je_100kmAverage petrol consumption in litres per 100 km.
diesel_verbrauch_l_je_100kmAverage 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.
bundeslandFederal state (Bundesland) — the 16 top-level regions.
zulassungsbezirkRegistration 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.