datahub-transportation-gov/consumer-airfare-report-table-2-top-1000-citypair-wqw2-rjgd
Icon for Socrata external plugin
 
Readme
Updated 25 days ago
Indexed 27 minutes ago

Consumer Airfare Report: Table 2 - Top 1,000 City-Pair Markets

Data summarized by city, includes the number of city-pair markets in the top 1,000 in either comparison period that involve each city, the number of passengers traveling to and from each city, the average fare, average fare per mile (yield), and average distance traveled. All records are aggregated as directionless city pair markets. All traffic traveling in both directions is added together. https://www.transportation.gov/policy/aviation-policy/competition-data-analysis/research-reports

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
citymarketidcitymarketidcitymarketidNumberCity market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market
ly_farely_farely_fareNumberLast year fare
Geocoded_Citylocation_1location_1PointGeocoded - City is used to consolidate airports serving the same city market with Latitude and Longitude
US States:@computed_region_28hd_vqqn:@computed_region_28hd_vqqnNumber
Geocoded_City (state)location_1_statelocation_1_stateText
tbl2pkunique_idunique_idTextPrimary Key for Table 2; Unique Id
marketsmarketsmarketsNumberNumber of Markert
distancedistancedistanceNumberCurrent year distance
cur_farecur_farecur_fareNumberCurrent year fare
quarterquarterquarterNumberData Quarter
tbltbltblTextName of the data table
cur_passengerscur_passengerscur_passengersNumberCurrent year passengers
ly_passengersly_passengersly_passengersNumberLast year passengers
YearyearyearNumberData Year
citycitycityTextCity is used to consolidate airports serving the same city market
cur_yieldcur_yieldcur_yieldNumberCurrent year yield in Cents
ly_yieldly_yieldly_yieldNumberLast year yield in Cents
ly_distancely_distancely_distanceNumberLast year distance
Geocoded_City (city)location_1_citylocation_1_cityText
Geocoded_City (address)location_1_addresslocation_1_addressText
Geocoded_City (zip)location_1_ziplocation_1_zipText
 
Preview
  • consumer_airfare_report_table_2_top_1000_citypair
     
Upstream Metadata