USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

U.S. Department of Transportation U.S. Department of Transportation Icon United States Department of Transportation United States Department of Transportation

Table 3: Database Fields

Thursday, September 6, 2012

Table 3: Database Fields

Excel | CSV

The following fields identify the facility:

Facility ID A unique nine digit facility identifi er consisting of the state code for the facility, the zip code, and a sequential two digit number assigned to facilities within that zip code.
Facility name Facility name
Facility type Rail station, airport, bus station, etc.
Website URL of website for the facility (when one exists)
Data Source Public and other external data sources used by the Bureau of Transportation Statistics to find information on modes serving this location.
Notes Listing of modes serving the facility and other factors relevant to the fi ndings in regard to service status of the various modes.
Date updated Date that this record was last updated.

The following fields are included so that records can be correlated with those in other publicly available databases:

Airport code The three-letter IATA code assigned to this facility where applicable.
Airport code2 The FAA airport code used for this facility when it differs from the IATA code.
Amtrak station code The three-letter code used by Amtrak for this terminal.
Ferry terminal code The terminal identifier used in the BTS National Census of Ferry Operators.

The following are location information fields:

Address Street address
City City where the facility is located
State Postal state abbreviation
Zip code Postal fi ve-digit zip code
Metro area Name of Census Bureau Core Based Statistical Area (Metro Area) where the facility is located.
CBSA type Indicates whether CBSA is a Metropolitan Statistical Area (population at least 50,000+) or a Micropolitan
Statistical Area (population 10,000-50,000)
CBSA code Census Bureau Core Based Statistical Area Code

The following fields indicate the status of service for each of the modes at this terminal facility (see table 4 for a definition of each mode):

Ferry transit Indicates whether transit ferry serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Ferry intercity Indicates whether intercity ferry serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Bus transit Indicates whether transit bus serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Bus intercity Indicates whether intercity bus serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Bus code share Indicates whether code share bus serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Bus supplemental Indicates whether supplemental bus serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Rail intercity Indicates whether intercity rail serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Rail commuter Indicates whether commuter rail serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Rail heavy Indicates whether heavy rail serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Rail light Indicates whether light rail serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Air service Indicates whether airline service serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).

The following fields contain statistical data based on the services provided by the various modes:

Intercity service Indicates whether service at this location is provided by at least one intercity mode (Rail Intercity, Bus Intercity, Bus CodeShare, Bus Supplemental, Ferry Intercity, or Air Service) (0="no"/1="yes")
Transit service Indicates whether service at this location is provided by at least one transit mode (Rail Commuter, Rail Heavy, Rail Light, Bus Transit or Ferry Transit) (0="no"/1="yes")
Modes serving Count of the number of modes
Mode air Indicator of whether the air mode serves this location (0="no"/1="yes")
Mode rail standard Indicator of whether Rail Commuter or Rail Intercity serves this location (0="no"/1="yes")
Mode rail transit Indicator of whether Rail Heavy or Rail Light serves this location. (0="no"/1="yes")
Mode ferry Indicator of whether Ferry Intercity or Ferry Transit serves this location (0="no"/1="yes")
Mode bus Indicator of whether at least one of the four bus modes serves this location (0="no"/1="yes")