US Department of Transportation Timeseries

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_TRANSPORTATION_TIMESERIES

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
FLIGHT_TYPE_ID	A unique hash for the combination of the origin and destination airports, aircraft carriers, and aircrafts. Primary key reflecting the flight pattern.	VARCHAR	e62249f9802ddec9cf6fb5d67c7a1f71
AIRCRAFT_CARRIER_ID	ID for the aircraft carrier.	VARCHAR	06700_31
AIRCRAFT_ID	ID for the aircraft type, a distinctive model as designated by the manufacturer.	VARCHAR	3161
ORIGIN_AIRPORT_ID	ID for the origin airport that is part of the flight route being measured, combination of the DOT unique code and official 3 letter OAG code issued for that airport.	VARCHAR	30685BMI
DESTINATION_AIRPORT_ID	ID for the destination airport that is part of the flight route being measured, combination of the DOT unique code and official 3 letter OAG code issued for that airport.	VARCHAR	30397ATL
SERVICE_CLASS	Type of service provided by the airline on a specific flight, breaking out scheduled from non-scheduled service and the type of service.	VARCHAR	Scheduled Passenger/Cargo Service
VARIABLE	Unique identifier for a variable, joinable to the timeseries table.	VARCHAR	AIRBORNE_IN_MINUTES
VARIABLE_NAME	Human-readable unique name for the variable.	VARCHAR	Airborne Time
DATE	Date associated with the value.	DATE	2018-12-31
VALUE	Value reported for the variable.	FLOAT	78.0
UNIT	Unit of measurement for the reported value.	VARCHAR	Minutes