Find the latest Coronavirus-related transportation statistics on the BTS Covid-19 landing page

General

BTS> TranStats
transtats logo
 
Advanced Search
Resources
Data Finder
By Mode
By Subject
: Master Coordinate
Databases    Data Tables    Table Contents
Download Instructions
Filter Geography
Filter Year
Filter Period
Select all fields            % Missing in table         Documentation      Term     
Field NameDescriptionSupport Table
An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time.
An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused.
A three character alpha-numeric code issued by the U.S. Department of Transportation which is the official designation of the airport. The airport code is not always unique to a specific airport because airport codes can change or can be reused.
Airport Name
Airport City Name with either U.S. State or Country
Unique Identifier for a World Area Code (WAC) at a given point of time for the Physical Location of the Airport. See World Area Codes support table.
World Area Code for the Physical Location of the AirportGet Lookup Table
Country Name for the Physical Location of the Airport
Two-character ISO Country Code for the Physical Location of the Airport
State Name for the Physical Location of the Airport
State Abbreviation for the Physical Location of the Airport
FIPS (Federal Information Processing Standard) State Code for the Physical Location of the Airport
An identification number assigned by US DOT to identify a city market at a given point of time. City Market attributes may change over time. For example the country associated with the city market can change over time due to geopolitical changes.Get Lookup Table
An identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market.Get Lookup Table
City Market Name with either U.S. State or Country
Unique Identifier for a World Area Code (WAC) at a given point of time for the City Market. See World Area Codes support table.
World Area Code for the City MarketGet Lookup Table
Latitude, Degrees
Latitude, Hemisphere
Latitude, Minutes
Latitude, Seconds
Latitude
Longitude, Degrees
Longitude, Hemisphere
Longitude, Minutes
Longitude, Seconds
Longitude
Time Zone at the Airport
Start Date of Airport Attributes
End Date of Airport Attributes (Active = NULL)
Indicates if the airport is closed (1 = Yes). If yes, the airport is closed is on the AirportEndDate.Get Lookup Table
Indicates if this row contains the latest attributes for the Airport (1 = Yes)Get Lookup Table