About this Dataset

Consumer Airfare Report: Table 6 - Contiguous State City-Pair Markets That Average At Least 10 Passengers Per Day

Available on the internet only, this table is an expanded version of Table 1 that lists all city-pair markets in the contiguous United States that average at least 10 passengers each day. 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
Organization: Department of Transportation
Last updated: 2020-11-12T13:03:00.940784
Tags: airfares, aviation, aviation-policy, city-pair, city-pair-markets, consumer-airfare-report, fare-levels, fares, office-of-aviation-analysis, table-6

Tables

Table 1

@usgov.dot_gov_consumer_airfare_report_6_contiguous_state_cit_79e5f385.table_1

18.98 MB
636,854 rows
20 columns

CREATE TABLE table_1 (
  "tbl" VARCHAR,
  "year" BIGINT,
  "quarter" BIGINT,
  "citymarketid_1" BIGINT,
  "citymarketid_2" BIGINT,
  "city1" VARCHAR,
  "city2" VARCHAR,
  "nsmiles" BIGINT,
  "passengers" BIGINT,
  "fare" DOUBLE,
  "carrier_lg" VARCHAR,
  "large_ms" DOUBLE,
  "fare_lg" DOUBLE,
  "carrier_low" VARCHAR,
  "lf_ms" DOUBLE,
  "fare_low" DOUBLE,
  "table_1_flag" BIGINT,
  "geocoded_city1" VARCHAR,
  "geocoded_city2" VARCHAR,
  "tbl6pk" BIGINT
);