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.

Site Notification

Site Notification

U.S. Department of Transportation U.S. Department of Transportation Icon United States Department of Transportation United States Department of Transportation
BTS> TranStats
transtats logo
 
Advanced Search
Resources
Data Finder
By Mode
By Subject
Transnet : Passenger Connectivity
Databases    Data Tables    Table Contents
Download Instructions
Filter Geography
Filter Year
Filter Period
Select all fields            % Missing in table         Documentation        
Field NameDescriptionSupport Table
Unique record identifier. The identifier is unique to each record; records located at the same location as another will each have a unique FacilityID.
Unique identifier for the transportation facility. The identifier is the same for records of different modes that are located at the same facility
3 Letter Airport CodeGet Lookup Table
Alternate 3 Character Airport Code
3 Character Amtrak Station Code
4 Digit Ferry Terminal Code
Record number for the heavy, light, or commuter rail station found in the U.S. Department of Transportation Bureau of Transportation Statistics National Transportation Atlas Database (2013) Fixed-Guideway Transit Facilities database.
ID assigned by bike share system provider to the bike-share station. Unique within a bike share system
Date on Which Record was Last Updated
Street Address
Name of City Where Facility is Located
Postal State AbbreviationGet Lookup Table
Postal Five Digit Zip Code
Metro Area
Facility Name
Longitude, Decimal degrees for the facility identified by the FacilityID. This is unique to each record.
Latitude, Decimal degrees for the facility identified by the FacilityID. This is unique to each record.
Longitude, Decimal degrees for the facility identified by the point_ID. When two or more records are found at the same location, POINT_LON is the average of the Longitude fields for those records; otherwise same as the Longitude field.
Latitude, Decimal degrees for the facility identified by the point_ID. When two or more records are found at the same location, POINT_LAT is the average of the Latitude fields for those records; otherwise same as the Latitude field.
Facility Mode Identifier That Shows Primary Mode Serving a Facility. Other Modes May Also Provide Service as Shown in the Individual Facility Record.Get Lookup Table
Service Availability Indicator for Transit FerryGet Lookup Table
Service Availabililty Indicator for Intercity FerryGet Lookup Table
Service Availability Indicator for Transit BusGet Lookup Table
Service Availability Indicator for Intercity BusGet Lookup Table
Service Availability Indicator for Code Share Bus Operated as Connecting Service to Rail or Airline ServiceGet Lookup Table
Service Availability Indicator for Supplemental Bus Service operated to provide additional frequencies on a route served by Intercity or Commuter Rail.Get Lookup Table
Service Availability Indicator for Intercity RailGet Lookup Table
Service Availability Indicator for Commuter RailGet Lookup Table
Service Availability Indicator for Heavy RailGet Lookup Table
Service Availability Indicator for Light RailGet Lookup Table
Service Availability Indicator for Scheduled Airline ServiceGet Lookup Table
Service Availability Indicator for Bike ShareGet Lookup Table
Unique ID for bike-share system
Name of bike-share system
Web Address for Official Facility Website
Notes on Service Providers, Connectivity Issues, etc.
Data Sources Used
Indicator that Service at Facility is Provided by at Least One Intercity Transportation Mode (RailIntercity, BusIntercity, BusShare, BusSupplemental, FerryIntercity or AirService)Get Lookup Table
Indicator that service at facility is provided by at least one transit mode (RailCommuter, RailHeavy, RailLight, BusTransit, or FerryTransit)Get Lookup Table
Census Bureau Core Based Statistical Area CodeGet Lookup Table
Indicates whether CBSA is a Metropolitan Statistical Area (at least one urbanized area of 50,000+ population), or Micropolitan Statistical Area (at least one urbanized area of 10,000-50,000 population)Get Lookup Table
Count of the Number of Transportation Modes Serving the Facility (from ModeBus, ModeAir, ModeRailStd, ModeRailTrt, ModeFerry, ModeBike)Get Lookup Table
Indicates if Any Category of Bus Service is Provided at the Facility (BusIntercity, BusTransit, BusCodeShare, BusSupplemental)Get Lookup Table
Indicates if Any Category of Air Service is Provided at the Facility (AirService)Get Lookup Table
Indicates if Any Category of Rail Service is Provided at the Facility (RailIntercity. RailCommuter, RailHeavy, or RailLight)Get Lookup Table
Indicates if Any Category of Ferry Service is Provided at the Facility (FerryIntercity or FerryTransit)Get Lookup Table
Indicates if a Bike-share Station is Located at the Facility (Bike Share Service)Get Lookup Table