
Applicable for all vehicle categories (M, N, O):
The Vehicle Identification Number (VIN) is encrypted with the hash function ‘sha256’ and can be found in the column called 'Vehicle_Id'. By applying the same hashing onto your VINs you can de-crypt the 'Vehicle_Id'.

Relevant only for buses (M):
In order to easily to link the data for buses, the EEA added two additional identifiers to the raw data - namely:
1. Pk_vehicle - to link the table 'vehicles' to tables containing the same 'Vehicle_Id' multiple time like e.g. the table 'mission_profiles'.
2. Pk_for_CO2 - to link derogated buses according to Art. 7b(b) of Regulation(EU)2019/1242 to the CO2 values of the incompleted buses. 
For non-derogated buses Pk_vehicle and Pk_for_CO2 are identical.

