US Department of Transportation Timeseries
Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_TRANSPORTATION_TIMESERIES
Name | Description | Type | Example |
---|---|---|---|
| A unique hash for the combination of the origin and destination airports, aircraft carriers, and aircrafts. Primary key reflecting the flight pattern. | VARCHAR |
|
| ID for the aircraft carrier. | VARCHAR |
|
| ID for the aircraft type, a distinctive model as designated by the manufacturer. | VARCHAR |
|
| 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 |
|
| 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 |
|
| Type of service provided by the airline on a specific flight, breaking out scheduled from non-scheduled service and the type of service. | VARCHAR |
|
| Unique identifier for a variable, joinable to the timeseries table. | VARCHAR |
|
| Human-readable unique name for the variable. | VARCHAR |
|
| Date associated with the value. | DATE |
|
| Value reported for the variable. | FLOAT |
|
| Unit of measurement for the reported value. | VARCHAR |
|
Last updated