Airport Index

Snowflake table name : CYBERSYN.AIRPORT_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
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	34987SRV
AIRPORT_DOT_CODE	Unique identifier assigned by the US DOT to each airport, used for administrative and reporting purposes.	NUMBER	34987
AIRPORT_NAME	Name of the airport.	VARCHAR	Stony River Airport
AIRPORT_ALPHA_CODE	Code assigned to airports by the International Air Transport Association (IATA), which are widely used in the aviation industry for ticketing, baggage handling, and flight planning.	VARCHAR	SRV
AIRPORT_WORLD_AREA_CODE	US DOT identifier for the geographical area where the airport is based.	NUMBER	1
LOCATION	Full location name of the airport.	VARCHAR	Stony River, AK: Stony River Airport
AIRPORT_CITY_NAME	Name of the city where the airport is located.	VARCHAR	Stony River
STATE_GEO_ID	A unique identifier for a state, joinable to the GEOGRAPHY_INDEX table, representing the primary geography for the variable.	VARCHAR	geoId/02
COUNTRY_GEO_ID	A unique identifier for a country, joinable to the GEOGRAPHY_INDEX table, representing the primary geography for the variable.	VARCHAR	country/USA