ARC Travel Demand - Sample

ARC’s data is the world’s most comprehensive source of global air travel intelligence. Global coverage spans flights from more than 4,600 airports in 234 countries and territories. This dataset contains global air travel tickets issued for the previous, rolling 6 months, for travel from the United States to Mexico.

SAMPLES/TABLES INCLUDED:
a single secure view that contains air travel data from United States to Mexico for the prior rolling six months which include the following:
• Daily air travel purchases, cancellations, and departures for passengers traveling from/to specific countries/airport destinations.
• Daily breakdown of air travel volume and total fares paid by point of sale country, class of service and stop over destination airports.

FIELDS INCLUDED:
LOAD_DT: The record load date in ARC’s systems
TRAN_CD: A code that identifies the type of transaction.
DATE_OF_ISSUE : Date when the ticket was issued
DATE_OF_DEPARTURE : The scheduled date of departure
FARE_TOTAL : Sum of total fares paid
CABIN_CLASS : Service class categories(i.e. First-F, Business-C, Economy-Y, Discount Economy-DY, All Others -AO)
POS_COUNTRY_CD : The 2-letter country code for the origin of the ticket issuance
ORIGIN_COUNTRY_NAME : The country name for the origin of the travel segment
ORIGIN_AIRPORT_CODE : Origin airport code of the travel segment
DESTINATION_COUNTRY_NAME : The Country Name for the destination of the travel segment
DEST_AIRPORT_CODE: Destination airport of the travel segment
TRUE_OND: Origin-Destination pair based on stop over of the itinerary derived based time on ground logic
SEGMENT_PAX_COUNT: Count of travel/passenger segments

搜集汇总

背景与挑战

背景概述

该数据集提供了全球航空旅行需求的样本，涵盖从美国到墨西哥的过去六个月滚动数据，包括每日购票、取消和出发信息，并按销售国家、服务等级等维度细分旅行量和总票价。数据字段涉及交易类型、日期、票价、舱位等级和行程细节，如出发地和目的地机场代码。