Flattened HDV data

Data Table

1 min read

A flattened table containing data delivered by manufacturers and EU Member States plus UK and Norway. The parameters reported are defined in Regulation (EU) 2018/956. Parameters reported by countries have a prefix "MS". Several derived or additional parameters are included to help filter and use data. These are explained in the table definition below.

Data and maps

Menu

Category

European data

Records

2,211,662

Table definition

Field name	Data type	Description (derived parameters)
OEM_PK_Vehicle	bigint	Primary key for data reported by OEM
Model	nvarchar(120)
Make	nvarchar(120)
Manufacturer	nvarchar(120)
ManufacturerAddress	nvarchar(120)
LegislativeClass	nvarchar(10)
GrossVehicleMass_t	float
CurbMassChassis_kg	int
ZeroEmissionVehicle	bit
HybridElectricHDV	bit
DualFuelVehicle	bit
ExemptedVehicle	bit	VECTO derived flag to indicate that the vehicle does not have a full simulation (ExemptedVehicle="yes"), because it is either a ZeroEmissionVehicle, DualFuelVehicle or HybridElectricHDV. Detailed data is not available for these vehicles.
AxleConfiguration	nvarchar(10)
VehicleGroup	int
VocationalVehicle	bit
SleeperCab	bit
PTO	bit
MS_PK_Vehicle	bigint	Primary key for data reported by countries
MS_Year	int
MS_MS	nvarchar(50)
MS_ID	bigint
MS_Mh	nvarchar(120)
MS_Mh_msv	nvarchar(120)
MS_Mk	nvarchar(120)
MS_Bw	nvarchar(120)
MS_Electric	nvarchar(10)
MS_Hybrid	nvarchar(10)
MS_ClassOfHybrid	nvarchar(120)
MS_FT	nvarchar(20)
MS_MaximumSpeed	int
MS_StageOfCompletionCode	nvarchar(10)
MS_VehicleCategoryCode	nvarchar(10)
MS_NumberOfAxles	int
MS_TechnPermMaxLadenMass	int
MS_CryptHashManufacturerRecord	nvarchar(120)
MS_SpecificCO2Emissions	float
MS_AveragePayload	float
MS_RegistrationDate	nvarchar(40)
ADAS_EngineStopStart	bit
ADAS_EcoRollWithoutEngineStop	bit
ADAS_EcoRollWithEngineStop	bit
ADAS_PredictiveCruiseControl	bit
Engine_CertificationNumber	nvarchar(120)
Engine_TAN	nvarchar(120)
Engine_RatedPower_kw	int
Engine_IdlingSpeed_rpm	int
Engine_RatedSpeed_rpm	int
Engine_Displacement_ltr	float
Engine_FuelType	nvarchar(20)
WHTC_CO2_gkwh	float
WHTC_FuelConsumption_gkwh	float
WHSC_CO2_gkwh	float
WHSC_FuelConsumption_gkwh	float
Gearbox_CertificationNumber	nvarchar(120)
Gearbox_CertificationMethod	nvarchar(120)
Gearbox_TransmissionType	nvarchar(10)
Gearbox_GearsCount	int
Gearbox_TransmissionRatioFinalGear	float
TorqueConverter_CertificationMethod	nvarchar(120)
TorqueConverter_CertificationNumber	nvarchar(120)
Retarder_RetarderType	nvarchar(120)
Retarder_CertificationMethod	nvarchar(120)
Retarder_CertificationNumber	nvarchar(120)
AngleDrive_CertificationMethod	nvarchar(120)
AngleDrive_CertificationNumber	nvarchar(120)
AngleDrive_Ratio	float
Axlegear_CertificationMethod	nvarchar(120)
Axlegear_CertificationNumber	nvarchar(120)
Axlegear_LineType	nvarchar(120)
Axlegear_Ratio	float
AirDrag_CertificationMethod	nvarchar(120)
AirDrag_CertificationNumber	nvarchar(120)
AirDrag_CdxA_range	nvarchar(20)
Auxiliaries_FanTechnology	nvarchar(120)
Auxiliaries_SteeringPumpTechnology1	nvarchar(120)
Auxiliaries_SteeringPumpTechnology2	nvarchar(120)
Auxiliaries_SteeringPumpTechnology3	nvarchar(120)
Auxiliaries_SteeringPumpTechnology4	nvarchar(120)
Auxiliaries_ElectricSystemTechnology	nvarchar(120)
Auxiliaries_PneumaticSystemTechnology	nvarchar(120)
SimulationToolVersion	nvarchar(120)
SimulationDate	nvarchar(40)
NumberofLicenceforSimulationTool	nvarchar(120)
RDL_Mission	nvarchar(120)
RDL_Distance_km	float
RDL_TotalVehicleMass_kg	int
RDL_Payload_kg	int
RDL_FuelType	nvarchar(20)
RDL_AverageSpeed_kmh	float
RDL_MinSpeed_kmh	float
RDL_MaxSpeed_kmh	float
RDL_MaxDeceleration_ms2	float
RDL_MaxAcceleration_ms2	float
RDL_FullLoadDrivingtimePct	float
RDL_GearShiftCount	int
RDL_CO2_gkm	float
RDL_CO2_gm3km	float
RDL_CO2_gtkm	float
RDL_FuelConsumption_gkm	float
RDL_FuelConsumption_gm3km	float
RDL_FuelConsumption_gtkm	float
RDL_FuelConsumption_l100km	float
RDL_FuelConsumption_lm3km	float
RDL_FuelConsumption_ltkm	float
RDL_FuelConsumption_mjkm	float
RDL_FuelConsumption_mjm3km	float
RDL_FuelConsumption_mjtkm	float
RDR_Mission	nvarchar(120)
RDR_Distance_km	float
RDR_TotalVehicleMass_kg	int
RDR_Payload_kg	int
RDR_FuelType	nvarchar(20)
RDR_AverageSpeed_kmh	float
RDR_MinSpeed_kmh	float
RDR_MaxSpeed_kmh	float
RDR_MaxDeceleration_ms2	float
RDR_MaxAcceleration_ms2	float
RDR_FullLoadDrivingtimePct	float
RDR_GearShiftCount	int
RDR_CO2_gkm	float
RDR_CO2_gm3km	float
RDR_CO2_gtkm	float
RDR_FuelConsumption_gkm	float
RDR_FuelConsumption_gm3km	float
RDR_FuelConsumption_gtkm	float
RDR_FuelConsumption_l100km	float
RDR_FuelConsumption_lm3km	float
RDR_FuelConsumption_ltkm	float
RDR_FuelConsumption_mjkm	float
RDR_FuelConsumption_mjm3km	float
RDR_FuelConsumption_mjtkm	float
LHL_Mission	nvarchar(120)
LHL_Distance_km	float
LHL_TotalVehicleMass_kg	int
LHL_Payload_kg	int
LHL_FuelType	nvarchar(20)
LHL_AverageSpeed_kmh	float
LHL_MinSpeed_kmh	float
LHL_MaxSpeed_kmh	float
LHL_MaxDeceleration_ms2	float
LHL_MaxAcceleration_ms2	float
LHL_FullLoadDrivingtimePct	float
LHL_GearShiftCount	int
LHL_CO2_gkm	float
LHL_CO2_gm3km	float
LHL_CO2_gtkm	float
LHL_FuelConsumption_gkm	float
LHL_FuelConsumption_gm3km	float
LHL_FuelConsumption_gtkm	float
LHL_FuelConsumption_l100km	float
LHL_FuelConsumption_lm3km	float
LHL_FuelConsumption_ltkm	float
LHL_FuelConsumption_mjkm	float
LHL_FuelConsumption_mjm3km	float
LHL_FuelConsumption_mjtkm	float
LHR_Mission	nvarchar(120)
LHR_Distance_km	float
LHR_TotalVehicleMass_kg	int
LHR_Payload_kg	int
LHR_FuelType	nvarchar(20)
LHR_AverageSpeed_kmh	float
LHR_MinSpeed_kmh	float
LHR_MaxSpeed_kmh	float
LHR_MaxDeceleration_ms2	float
LHR_MaxAcceleration_ms2	float
LHR_FullLoadDrivingtimePct	float
LHR_GearShiftCount	int
LHR_CO2_gkm	float
LHR_CO2_gm3km	float
LHR_CO2_gtkm	float
LHR_FuelConsumption_gkm	float
LHR_FuelConsumption_gm3km	float
LHR_FuelConsumption_gtkm	float
LHR_FuelConsumption_l100km	float
LHR_FuelConsumption_lm3km	float
LHR_FuelConsumption_ltkm	float
LHR_FuelConsumption_mjkm	float
LHR_FuelConsumption_mjm3km	float
LHR_FuelConsumption_mjtkm	float
UDL_Mission	nvarchar(120)
UDL_Distance_km	float
UDL_TotalVehicleMass_kg	int
UDL_Payload_kg	int
UDL_FuelType	nvarchar(20)
UDL_AverageSpeed_kmh	float
UDL_MinSpeed_kmh	float
UDL_MaxSpeed_kmh	float
UDL_MaxDeceleration_ms2	float
UDL_MaxAcceleration_ms2	float
UDL_FullLoadDrivingtimePct	float
UDL_GearShiftCount	int
UDL_CO2_gkm	float
UDL_CO2_gm3km	float
UDL_CO2_gtkm	float
UDL_FuelConsumption_gkm	float
UDL_FuelConsumption_gm3km	float
UDL_FuelConsumption_gtkm	float
UDL_FuelConsumption_l100km	float
UDL_FuelConsumption_lm3km	float
UDL_FuelConsumption_ltkm	float
UDL_FuelConsumption_mjkm	float
UDL_FuelConsumption_mjm3km	float
UDL_FuelConsumption_mjtkm	float
UDR_Mission	nvarchar(120)
UDR_Distance_km	float
UDR_TotalVehicleMass_kg	int
UDR_Payload_kg	int
UDR_FuelType	nvarchar(20)
UDR_AverageSpeed_kmh	float
UDR_MinSpeed_kmh	float
UDR_MaxSpeed_kmh	float
UDR_MaxDeceleration_ms2	float
UDR_MaxAcceleration_ms2	float
UDR_FullLoadDrivingtimePct	float
UDR_GearShiftCount	int
UDR_CO2_gkm	float
UDR_CO2_gm3km	float
UDR_CO2_gtkm	float
UDR_FuelConsumption_gkm	float
UDR_FuelConsumption_gm3km	float
UDR_FuelConsumption_gtkm	float
UDR_FuelConsumption_l100km	float
UDR_FuelConsumption_lm3km	float
UDR_FuelConsumption_ltkm	float
UDR_FuelConsumption_mjkm	float
UDR_FuelConsumption_mjm3km	float
UDR_FuelConsumption_mjtkm	float
REL_Mission	nvarchar(120)
REL_Distance_km	float
REL_TotalVehicleMass_kg	int
REL_Payload_kg	int
REL_FuelType	nvarchar(20)
REL_AverageSpeed_kmh	float
REL_MinSpeed_kmh	float
REL_MaxSpeed_kmh	float
REL_MaxDeceleration_ms2	float
REL_MaxAcceleration_ms2	float
REL_FullLoadDrivingtimePct	float
REL_GearShiftCount	int
REL_CO2_gkm	float
REL_CO2_gm3km	float
REL_CO2_gtkm	float
REL_FuelConsumption_gkm	float
REL_FuelConsumption_gm3km	float
REL_FuelConsumption_gtkm	float
REL_FuelConsumption_l100km	float
REL_FuelConsumption_lm3km	float
REL_FuelConsumption_ltkm	float
REL_FuelConsumption_mjkm	float
REL_FuelConsumption_mjm3km	float
REL_FuelConsumption_mjtkm	float
RER_Mission	nvarchar(120)
RER_Distance_km	float
RER_TotalVehicleMass_kg	int
RER_Payload_kg	int
RER_FuelType	nvarchar(20)
RER_AverageSpeed_kmh	float
RER_MinSpeed_kmh	float
RER_MaxSpeed_kmh	float
RER_MaxDeceleration_ms2	float
RER_MaxAcceleration_ms2	float
RER_FullLoadDrivingtimePct	float
RER_GearShiftCount	int
RER_CO2_gkm	float
RER_CO2_gm3km	float
RER_CO2_gtkm	float
RER_FuelConsumption_gkm	float
RER_FuelConsumption_gm3km	float
RER_FuelConsumption_gtkm	float
RER_FuelConsumption_l100km	float
RER_FuelConsumption_lm3km	float
RER_FuelConsumption_ltkm	float
RER_FuelConsumption_mjkm	float
RER_FuelConsumption_mjm3km	float
RER_FuelConsumption_mjtkm	float
LEL_Mission	nvarchar(120)
LEL_Distance_km	float
LEL_TotalVehicleMass_kg	int
LEL_Payload_kg	int
LEL_FuelType	nvarchar(20)
LEL_AverageSpeed_kmh	float
LEL_MinSpeed_kmh	float
LEL_MaxSpeed_kmh	float
LEL_MaxDeceleration_ms2	float
LEL_MaxAcceleration_ms2	float
LEL_FullLoadDrivingtimePct	float
LEL_GearShiftCount	int
LEL_CO2_gkm	float
LEL_CO2_gm3km	float
LEL_CO2_gtkm	float
LEL_FuelConsumption_gkm	float
LEL_FuelConsumption_gm3km	float
LEL_FuelConsumption_gtkm	float
LEL_FuelConsumption_l100km	float
LEL_FuelConsumption_lm3km	float
LEL_FuelConsumption_ltkm	float
LEL_FuelConsumption_mjkm	float
LEL_FuelConsumption_mjm3km	float
LEL_FuelConsumption_mjtkm	float
LER_Mission	nvarchar(120)
LER_Distance_km	float
LER_TotalVehicleMass_kg	int
LER_Payload_kg	int
LER_FuelType	nvarchar(20)
LER_AverageSpeed_kmh	float
LER_MinSpeed_kmh	float
LER_MaxSpeed_kmh	float
LER_MaxDeceleration_ms2	float
LER_MaxAcceleration_ms2	float
LER_FullLoadDrivingtimePct	float
LER_GearShiftCount	int
LER_CO2_gkm	float
LER_CO2_gm3km	float
LER_CO2_gtkm	float
LER_FuelConsumption_gkm	float
LER_FuelConsumption_gm3km	float
LER_FuelConsumption_gtkm	float
LER_FuelConsumption_l100km	float
LER_FuelConsumption_lm3km	float
LER_FuelConsumption_ltkm	float
LER_FuelConsumption_mjkm	float
LER_FuelConsumption_mjm3km	float
LER_FuelConsumption_mjtkm	float
MUL_Mission	nvarchar(120)
MUL_Distance_km	float
MUL_TotalVehicleMass_kg	int
MUL_Payload_kg	int
MUL_FuelType	nvarchar(20)
MUL_AverageSpeed_kmh	float
MUL_MinSpeed_kmh	float
MUL_MaxSpeed_kmh	float
MUL_MaxDeceleration_ms2	float
MUL_MaxAcceleration_ms2	float
MUL_FullLoadDrivingtimePct	float
MUL_GearShiftCount	int
MUL_CO2_gkm	float
MUL_CO2_gm3km	float
MUL_CO2_gtkm	float
MUL_FuelConsumption_gkm	float
MUL_FuelConsumption_gm3km	float
MUL_FuelConsumption_gtkm	float
MUL_FuelConsumption_l100km	float
MUL_FuelConsumption_lm3km	float
MUL_FuelConsumption_ltkm	float
MUL_FuelConsumption_mjkm	float
MUL_FuelConsumption_mjm3km	float
MUL_FuelConsumption_mjtkm	float
MUR_Mission	nvarchar(120)
MUR_Distance_km	float
MUR_TotalVehicleMass_kg	int
MUR_Payload_kg	int
MUR_FuelType	nvarchar(20)
MUR_AverageSpeed_kmh	float
MUR_MinSpeed_kmh	float
MUR_MaxSpeed_kmh	float
MUR_MaxDeceleration_ms2	float
MUR_MaxAcceleration_ms2	float
MUR_FullLoadDrivingtimePct	float
MUR_GearShiftCount	int
MUR_CO2_gkm	float
MUR_CO2_gm3km	float
MUR_CO2_gtkm	float
MUR_FuelConsumption_gkm	float
MUR_FuelConsumption_gm3km	float
MUR_FuelConsumption_gtkm	float
MUR_FuelConsumption_l100km	float
MUR_FuelConsumption_lm3km	float
MUR_FuelConsumption_ltkm	float
MUR_FuelConsumption_mjkm	float
MUR_FuelConsumption_mjm3km	float
MUR_FuelConsumption_mjtkm	float
COL_Mission	nvarchar(120)
COL_Distance_km	float
COL_TotalVehicleMass_kg	int
COL_Payload_kg	int
COL_FuelType	nvarchar(20)
COL_AverageSpeed_kmh	float
COL_MinSpeed_kmh	float
COL_MaxSpeed_kmh	float
COL_MaxDeceleration_ms2	float
COL_MaxAcceleration_ms2	float
COL_FullLoadDrivingtimePct	float
COL_GearShiftCount	int
COL_CO2_gkm	float
COL_CO2_gm3km	float
COL_CO2_gtkm	float
COL_FuelConsumption_gkm	float
COL_FuelConsumption_gm3km	float
COL_FuelConsumption_gtkm	float
COL_FuelConsumption_l100km	float
COL_FuelConsumption_lm3km	float
COL_FuelConsumption_ltkm	float
COL_FuelConsumption_mjkm	float
COL_FuelConsumption_mjm3km	float
COL_FuelConsumption_mjtkm	float
COR_Mission	nvarchar(120)
COR_Distance_km	float
COR_TotalVehicleMass_kg	int
COR_Payload_kg	int
COR_FuelType	nvarchar(20)
COR_AverageSpeed_kmh	float
COR_MinSpeed_kmh	float
COR_MaxSpeed_kmh	float
COR_MaxDeceleration_ms2	float
COR_MaxAcceleration_ms2	float
COR_FullLoadDrivingtimePct	float
COR_GearShiftCount	int
COR_CO2_gkm	float
COR_CO2_gm3km	float
COR_CO2_gtkm	float
COR_FuelConsumption_gkm	float
COR_FuelConsumption_gm3km	float
COR_FuelConsumption_gtkm	float
COR_FuelConsumption_l100km	float
COR_FuelConsumption_lm3km	float
COR_FuelConsumption_ltkm	float
COR_FuelConsumption_mjkm	float
COR_FuelConsumption_mjm3km	float
COR_FuelConsumption_mjtkm	float
Axle1_AxleNumber	int
Axle1_TyreDimension	nvarchar(120)
Axle1_TyreCertificationNumber	nvarchar(120)
Axle1_TyreRRCDeclared	float
Axle1_TwinTyres	bit
Axle2_AxleNumber	int
Axle2_TyreDimension	nvarchar(120)
Axle2_TyreCertificationNumber	nvarchar(120)
Axle2_TyreRRCDeclared	float
Axle2_TwinTyres	bit
Axle3_AxleNumber	int
Axle3_TyreDimension	nvarchar(120)
Axle3_TyreCertificationNumber	nvarchar(120)
Axle3_TyreRRCDeclared	float
Axle3_TwinTyres	bit
Axle4_AxleNumber	int
Axle4_TyreDimension	nvarchar(120)
Axle4_TyreCertificationNumber	nvarchar(120)
Axle4_TyreRRCDeclared	float
Axle4_TwinTyres	bit
AdvCO2Tech1_AdvancedCO2Technology	nvarchar(120)
AdvCO2Tech1_Category	nvarchar(100)
AdvCO2Tech2_AdvancedCO2Technology	nvarchar(120)
AdvCO2Tech2_Category	nvarchar(100)
AdvCO2Tech3_AdvancedCO2Technology	nvarchar(120)
AdvCO2Tech3_Category	nvarchar(100)
AdvCO2Tech4_AdvancedCO2Technology	nvarchar(120)
AdvCO2Tech4_Category	nvarchar(100)
AdvCO2Tech5_AdvancedCO2Technology	nvarchar(120)
AdvCO2Tech5_Category	nvarchar(100)
AdvCO2Tech6_AdvancedCO2Technology	nvarchar(120)
AdvCO2Tech6_Category	nvarchar(100)
Meta_OEM_fileId	bigint	Reporting file ID for manufacturer files (added by the EEA)
Meta_MS_fileId	bigint	Reporting file ID for MS files (added by the EEA)
CO2v	float	Specific CO2 (in g/km) calculated as per Regulation (EU) 2019/1242, Annex I, point 2.1. (added by the EEA)
VehicleSubgroup	nvarchar(5)	Vehicle subgroup as defined in Regulation (EU) 2019/1242 (added by the EEA)
Match	nvarchar(8)	Flag to indicate if vehicle is available in both MS and OEM data ("Match"), only reported by one of the countries ("MS_only"), or only reported by manufacturer ("OEM_only") (added by the EEA)
Baseline	bit	Flag to indicate if the vehicle was used in the baseline calculation (Regulation (EU) 2019/1242) Annex I) (valid only for the Baseline dataset)
RegDate_Corrected	int	Registration date as reported by the country, converted to the same integer format for ease of use, regulated vehicles (added by the EEA)
UniqueData	nvarchar(4)	Flag to indicate if only the first registration is included (“YES”) or if all MS registrations are displayed (“NO”). The latter might include the same vehicles several times. (added by the EEA)
Corrected	int	Flag to indicate whether data for the vehicle has been re-simulated (added by the EEA)