Name: Commercial Aviation - Involuntary Denied Boarding
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Commercial Aviation - Involuntary Denied Boarding

Number of air travel passengers boarded and denied boarding by month
Organization: Department of Transportation
Last updated: 2022-02-26T08:32:03.481384
Tags: air-carriers, airlines, passengers

Tables

Table 1

@usgov.dot_gov_commercial_aviation_involuntary_denied_boarding.table_1

61.51 kB
899 rows
29 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "month" BIGINT,
  "quarter" BIGINT,
  "mkt_carrier" VARCHAR,
  "mkt_carrier_airline_id" DOUBLE,
  "mkt_carrier_name" VARCHAR,
  "mkt_unique_carrier" VARCHAR,
  "mkt_unique_carrier_name" VARCHAR,
  "op_carrier" VARCHAR,
  "op_carrier_airline_id" DOUBLE,
  "op_carrier_name" VARCHAR,
  "op_unique_carrier" VARCHAR,
  "op_unique_carrier_name" VARCHAR,
  "pax_alt_trans" BIGINT,
  "pax_no_alt_trans" BIGINT,
  "pax_no_comp_1" BIGINT,
  "pax_no_comp_2" BIGINT,
  "pax_no_comp_3" BIGINT,
  "tot_den_boarding" BIGINT,
  "pax_comp_1" BIGINT,
  "pax_comp_2" BIGINT,
  "pax_upgrade" DOUBLE,
  "pax_downgrade" DOUBLE,
  "tot_boarding" BIGINT,
  "comp_paid_1" DOUBLE,
  "comp_paid_2" DOUBLE,
  "comp_paid_3" BIGINT,
  "code_share" VARCHAR,
  "op_carrier_source" VARCHAR
);