U.S. Airline Traffic Data (2003-2023)

Monthly data from 2003 to 2023 for all commercial U.S. air carriers

@kaggle.yyxian_u_s_airline_traffic_data

Table List

1 table(34.8 KB)

Air Traffic

@kaggle.yyxian_u_s_airline_traffic_data.air_traffic

34.8 KB
249 rows
17 columns

year Year	month Month	dom_pax Dom Pax	int_pax Int Pax	pax Pax	dom_flt Dom Flt	int_flt Int Flt	flt Flt	dom_rpm Dom RPM	int_rpm Int RPM	rpm RPM	dom_asm Dom ASM	int_asm Int ASM	asm ASM	dom_lf Dom LF	int_lf Int LF	lf LF
2003	1	43032450	4905830	47938280	785160	57667	842827	36211422	12885980	49097402	56191300	17968572	74159872	64.44	71.71	66.2
2003	2	41166780	4245366	45412146	690351	51259	741610	34148439	10715468	44863907	50088434	15587880	65676314	68.18	68.74	68.31
2003	3	49992700	5008613	55001313	797194	58926	856120	41774564	12567068	54341633	57592901	17753174	75346075	72.53	70.79	72.12
2003	4	47033260	4345444	51378704	766260	55005	821265	39465980	10370592	49836572	54639679	15528761	70168440	72.23	66.78	71.02
2003	5	49152352	4610834	53763186	789397	55265	844662	41001934	11575026	52576960	55349897	15629821	70979718	74.08	74.06	74.07
2003	6	52209516	5411504	57621020	798351	58225	856576	44492972	13918185	58411157	56555517	17191579	73747096	78.67	80.96	79.2
2003	7	55810773	6191120	62001893	831619	62957	894576	48321924	15516794	63838718	59617048	18701759	78318807	81.05	82.97	81.51
2003	8	53920973	6272332	60193305	830737	63760	894497	46982527	15906430	62888957	59634190	19144885	78779075	78.78	83.08	79.83
2003	9	44213408	4824596	49038004	781804	54017	835821	36819820	13570889	50390709	54973852	17820478	72794329	66.98	76.15	69.22
2003	10	49944931	4920822	54865753	818308	54272	872580	41480412	13447446	54927858	58001020	17694417	75695437	71.52	76	72.56


CREATE TABLE air_traffic (
  "year" BIGINT,
  "month" BIGINT,
  "dom_pax" BIGINT,
  "int_pax" BIGINT,
  "pax" BIGINT,
  "dom_flt" BIGINT,
  "int_flt" BIGINT,
  "flt" BIGINT,
  "dom_rpm" BIGINT,
  "int_rpm" BIGINT,
  "rpm" BIGINT,
  "dom_asm" BIGINT,
  "int_asm" BIGINT,
  "asm" BIGINT,
  "dom_lf" DOUBLE,
  "int_lf" DOUBLE,
  "lf" DOUBLE
);