Aircraft Carrier Index

Snowflake table name : CYBERSYN.AIRCRAFT_CARRIER_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
AIRCRAFT_CARRIER_ID	Unique ID for the aircraft carrier.	VARCHAR	16853_41
CARRIER_NAME	Name of the airport carrier.	VARCHAR	Sunworld International Airlines (1996 - 2005)
CARRIER_WORLD_AREA_CODE	US DOT identifier for the geographical area where the carrier is based.	NUMBER	10
CARRIER_TYPE	Type of carrier based on its primary operational characteristics.	VARCHAR	Domestic Carrier
OAI_CARRIER_TYPE	Operating Air Carrier (OAC) type that provides a detailed classification of the type of operations conducted by the carrier.	VARCHAR	Medium Regional Carrier - Under $20M in revenue
STATE_GEO_ID	A unique identifier for a state, joinable to the GEOGRAPHY_INDEX table, representing the primary geography for the variable.	VARCHAR	geoId/15
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