t100_international

0 rows where aircraft_type = 1

This data as json

Link rowid ▼ year month origin origin_city_market_id origin_wac origin_city_name dest dest_city_market_id dest_wac dest_city_name carrier carrier_entity carrier_group distance class aircraft_group aircraft_type aircraft_config departures_performed departures_scheduled payload seats passengers freight mail ramp_to_ramp air_time wac none

0 records

CREATE TABLE "t100_international" (
   [year] INTEGER,
   [month] INTEGER,
   [origin] TEXT,
   [origin_city_market_id] TEXT,
   [origin_wac] INTEGER,
   [origin_city_name] TEXT,
   [dest] TEXT,
   [dest_city_market_id] TEXT,
   [dest_wac] INTEGER,
   [dest_city_name] TEXT,
   [carrier] TEXT REFERENCES [carriers]([carrier]),
   [carrier_entity] TEXT REFERENCES [carriers]([unique_carrier_entity]),
   [carrier_group] TEXT,
   [distance] INTEGER,
   [class] TEXT,
   [aircraft_group] TEXT,
   [aircraft_type] TEXT REFERENCES [aircraft_types]([ac_typeid]),
   [aircraft_config] TEXT,
   [departures_performed] INTEGER,
   [departures_scheduled] INTEGER,
   [payload] INTEGER,
   [seats] INTEGER,
   [passengers] INTEGER,
   [freight] INTEGER,
   [mail] INTEGER,
   [ramp_to_ramp] INTEGER,
   [air_time] INTEGER,
   [wac] INTEGER
, "none" TEXT);
CREATE INDEX idx_t100_international_pk_nonunique ON t100_international (year, month, origin, dest, carrier_entity, aircraft_type, class);
CREATE INDEX idx_t100_international_origin_date_dest ON t100_international (origin, year, month, dest);
CREATE INDEX idx_t100_international_origin_dest_year ON t100_international (origin, dest, year);