t100

Queries

View 8 queries

Tables schema

aircraft_types

ac_typeid, ac_group, ssd_name, manufacturer, name, short_name, begin_date

447 rows

airport_names

code, name

4,360 rows

airport_overrides

code, name, city, country, latitude, longitude

8 rows

airport_year_totals

year, origin, origin_city_name, origin_wac, deps, seats, passengers, freight

>10,000 rows

carriers

airline_id, carrier, carrier_entity, name, unique_carrier, unique_carrier_entity, unique_carrier_name, wac, carrier_group, carrier_group_new, region, start_date_source, thru_date_source

2,876 rows

openflights_airports

id, name, city, country, iata_code, icao_code, latitude, longitude, altitude, timezone, dst, tz, type, source

7,698 rows

t100_domestic

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

>10,000 rows

t100_international

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

>10,000 rows

Views