Consumer Airfare Report: Table 7 - Fare Premiums for Select Cities with More Than 20 Passengers per Day

data.transportation.gov | Last Updated 24 Apr 2019

Provides fare premiums for airports in the top 1,000 city pairs, and demonstrates the impact of low-fare service and hub domination on fare levels. All records are aggregated as directionless city pair markets. Air traffic in each direction is combined. https://www.transportation.gov/policy/aviation-policy/competition-data-analysis/research-reports

Tags: aviation, office of aviation analysis, consumer airfare report, airfares, fares, fare levels, aviation policy, city pair, table 7, fare premium

This dataset has the following 28 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
tbltbltextName of the data table
YearyearnumberData Year
quarterquarternumberData Quarter
citymarketidcitymarketidnumberCity market ID is an identification number assigned by US DOT to identify a city makret. Use this field to consolidate airports serving the same city market
citynamecitynametextCity used to consolidate airports serving the same city market
airportidairportidnumberAirport ID is an identification number assigned by US DOT to identify a airport.
aptapttextAirport code
TotalMktstotalmktsnumberCount of all markets
TotalFaredPaxtotalfaredpaxnumberPassengers in all markets
TotalPerLFMktstotalperlfmktsnumberPercent of passengers in markets with Low Cost Carrier service
TotalAvgHubFaretotalavghubfarenumberMarket average fare in all markets
TotalPerPremtotalperpremnumberPercent fare premium (discount) in in all markets
SHMktsshmktsnumberCount of short haul markets
SHPaxshpaxnumberPassengers in short haul markets
SHPerLFMktsshperlfmktsnumberPercent of passengers in short haul markets with Low Cost Carrier service
SHAvgHubFareshavghubfarenumberMarket average fare in short haul markets
SHPerPremshperpremnumberPercent fare premium (discount) in short haul markets
LHMktslhmktsnumberCount of long haul markets
LHPaxlhpaxnumberPassengers in long haul markets
LHPerLFMktslhperlfmktsnumberPercent of passengers in long haul markets with Low Cost Carrier service
LHAvgHubFarelhavghubfarenumberMarket average fare in long haul markets
LHPerPremlhperpremnumberPercent fare premium (discount) in long haul markets
Geocoded_CityNamegeocoded_citynamepointGeocoded - City used to consolidate airports serving the same city market
Geocoded_CityName (address)geocoded_cityname_addresstext
Geocoded_CityName (city)geocoded_cityname_citytext
Geocoded_CityName (state)geocoded_cityname_statetext
Geocoded_CityName (zip)geocoded_cityname_ziptext
tbl7pktbl7pktextPrimary Key for Table 7; Unique Record