Refer to the below for a list of field names and their corresponding description in the Emissions Status table.
|
Field Name |
Name in Database |
Type |
Description |
|
Carrier Code |
CARRIER_CODE |
VARCHAR (16777216) |
This field contains a carrier designator code assigned by either: · IATA (International Air Transport Association) · ICAO (International Civil Aviation Organization) · OAG (Controlled duplicate designators) |
|
Service Suffix |
SERVICE_SUFFIX |
VARCHAR (16777216) |
A code assigned by the administrating carrier for operational purposes. |
|
Flight Number |
FLIGHT_NUMBER |
VARCHAR (16777216) |
The four-digit flight number of the leg. |
|
Departure Airport |
DEPARTURE_AIRPORT |
VARCHAR (16777216) |
The departure port code as assigned by IATA e.g. JFK.
|
|
Arrival Airport |
ARRIVAL_AIRPORT |
VARCHAR (16777216) |
The arrival port code as assigned by IATA e.g. LAX.
|
|
Schedule Departure Date |
SCHEDULED_DEPARTURE_DATE |
VARCHAR (16777216) |
The schedule departure date that the operation departs in YYYY-MM-DD |
|
Aircraft Type |
AIRCRAFT_TYPE |
VARCHAR (16777216) |
IATA 3-character designator for the aircraft/equipment type code. E.g. CR1
|
|
Aircraft Registration Number |
AIRCRAFT_REGISTRATION_NUMBER |
VARCHAR (16777216) |
The registration number of the aircraft e.g. N153PQ |
|
Estimated Fuel Burn Taxi Out Tonnes |
ESTIMATED_FUEL_BURN_TAXI_OUT_TONNES |
FLOAT |
An estimation in of the m the terminal |
|
Estimated Fuel Burn Takeoff Tonnes |
ESTIMATED_FUEL_BURN_TAKEOFF_TONNES |
FLOAT
|
An estimation of the amount of fuel consumed in tonnes when the aircraft is taking off from the runway |
|
Estimated Fuel Burn Climb Out Tonnes |
ESTIMATED_FUEL_BURN_CLIMBOUT_TONNES |
FLOAT
|
An estimation of the amount of fuel consumed in tonnes when the aircraft is climbing to cruising altitude after take-off |
|
Estimated Fuel Burn Cruise Tonnes |
ESTIMATED_FUEL_BURN_CRUISE_TONNES |
FLOAT
|
An estimation of the amount of fuel consumed in tonnes when the aircraft is at cruising altitude after climbing out |
|
Estimated Fuel Burn Approach Tonnes |
ESTIMATED_FUEL_BURN_APPROACH_TONNES |
FLOAT
|
An estimation of the amount of fuel consumed in tonnes when the aircraft is dropping from cruising altitude to landing |
|
Estimated Fuel Burn Taxi in Tonnes
|
ESTIMATED_FUEL_BURN_TAXI_IN_TONNES |
FLOAT
|
An estimation of the amount of fuel consumed in tonnes when the aircraft is taxing from the runway to the terminal |
|
Estimated Fuel Burn Total Tonnes |
ESTIMATED_FUEL_BURN_TOTAL_TONNES |
FLOAT
|
The total estimated fuel consumed in tonnes during the flight operation |
|
Estimated CO2 Taxi Out Tonnes |
ESTIMATED_CO2_TAXI_OUT_TONNES |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is taxing out to the runway from the terminal |
|
Estimated CO2 Take Off Tonnes |
ESTIMATED_CO2_TAKEOFF_TONNES |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is taking off from the runway |
|
Estimated CO2 Climb Out Tonnes |
ESTIMATED_CO2_CLIMBOUT_TONNES |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is climbing to cruising altitude after take-off |
|
Estimated CO2 Cruise Tonnes |
ESTIMATED_CO2_CRUISE_TONNE |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is at cruising altitude after climbing out |
|
Estimated CO2 Approach Tonnes |
ESTIMATED_CO2_APPROACH_TONNES |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is dropping from cruising altitude to landing |
|
Estimated CO2 Taxi in Tonnes |
ESTIMATED_CO2_TAXI_IN_TONNE |
FLOAT |
An estimation of the amount of CO2 in tonnes emitted when the aircraft is taxing in from the runway to the terminal |
|
Estimated CO2 Total Tonnes |
ESTIMATED_CO2_TOTAL_TONNES |
FLOAT |
The total estimated CO2 emitted in tonnes during the flight operation
|
|
Missing Reference Flight Times |
MISSING_REFERENCE_FLIGHT_TIMES |
BOOLEAN |
Indicates when the flight instance is missing the historic flight times on this route needed for the fuel burn consumption and CO2 emission calculation. |