Skip to main content

Data Dictionary

Aircraft Carrier IndexView Source Documentation

PUBLIC_DATA.AIRCRAFT_CARRIER_INDEX: List of airline carriers, including their unique identification codes, names, and key operational details.

PUBLIC_DATA.AIRCRAFT_INDEX: Various aircraft models used by carriers.

PUBLIC_DATA.AIRPORT_INDEX: Airports tracked by the US DOT Domestic Segment data.

US Department of Transportation AttributesView Source Documentation

PUBLIC_DATA.US_DEPARTMENT_OF_TRANSPORTATION_ATTRIBUTES: Monthly domestic non-stop segment data reported by both US and foreign air carriers.

US Department of Transportation Attributes Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.US_DEPARTMENT_OF_TRANSPORTATION_ATTRIBUTES_PIT: Tracks history of the us_department_of_transportation_attributes table with start and end timestamps to indicate row validity periods.

US Department of Transportation TimeseriesView Source Documentation

PUBLIC_DATA.US_DEPARTMENT_OF_TRANSPORTATION_TIMESERIES: Monthly domestic non-stop segment data reported by both US and foreign air carriers.

US Department of Transportation Timeseries Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.US_DEPARTMENT_OF_TRANSPORTATION_TIMESERIES_PIT: Tracks history of the us_department_of_transportation_timeseries table with start and end timestamps to indicate row validity periods.