Passenger Booking Data
Overview
This release sees Passenger Booking data made available via Snowflake.
Detail
Passenger Booking data is made available via 5 fews as detailed below:
- O&D Booking View Unadjusted – Forward looking MIDT data
- O&D Booking View Adjusted – Historical full market data
- Segment View Unadjusted– Forward looking MIDT data exploded into individual legs. This allows for analysis of total number of passengers on a flight route (local market)
- Segment View Adjusted – Historical full market data exploded into individual legs. This allows for analysis of total number of passengers on a flight route (local market)
- Load Factor Calculation – Based on adjusted data. Shown as a percentage
Features
- Both data sets include history back to 2019.
- A Booking ID column is available to connect each respective pair of Booking and Segment views.
The full list of fields available in Passenger Booking Direct can be found here << change
Locations Master Data
Overview
This update sees the release of the IATA Region data field in the Locations Master Data view.
Detail
The IATA Region field shows the region code/s and name/s that the port belongs to. This can be more than one, an example being ports that belong to both EUR - Europe and SCH - Schengen. This data is held in JSON format