Help

What is TranStats?

TranStats is a central access point to a broad collection of intermodal transportation data. These data have been collected by various agencies within the U.S. Department of Transportation or by other federal agencies, such as the U.S. Bureau of the Census.

To view data for a specific transportation mode or subject, click the mode or subject listed under TranStats Library.
To search for databases containing specific content, such as Passenger or Freight, type the word in the Search this site box and click Go.
To find more details about flight on-time statistics, click more on the Airport Congestion heading bar. To drill down to monthly statistics, click the bar in the chart representing the month you are interested in.
To find more details about recreational boating statistics, click more on the Recreational Boating heading bar. To drill down to statistics of a specific year, click the bar in the chart that represents the year you are interested in.
To view a line chart of a listed Transportation Indicator, click the indicatr name. To view the complete list of indicators in charts or tables, click Complete list of indicators located at the bottom of the In Focus box.
To use the Mapping Center tools, click Mapping Center.

Clicking help on the top of a page displays relevant help on that page.
The status bar at the bottom of a page displays the destination of a hypertext link when the cursor is moving over the link.

Information Page

This is an information page. From here you can get to the data using the side bar.

To view data for a specific transportation mode or subject, click the mode or subject listed under Data Finder.
To search for databases containing specific content, such as Passenger or Freight, type the word in the Search this site box and click Go.
You can also locate databases using the subject or mode lists under Data Finder
To return to the Homepage, click home on the top bar.

Data Providers

This page lists all agencies and organizations that provide data to TranStats. You can read data profiles for all databases whether TranStats has actually loaded the data on its site or only established a link.

To visit the website maintained by each agency, click the agency name on the left side of the page.
To view the databases provided by a specific agency, click Databases on the right side.
To search for databases containing specific content, such as Passenger or Freight, type the word in the Search this site box and click Go.
You can also locate databases using the subject or mode lists under Data Finder
To return to the Homepage, click home on the top bar.
To obtain other information about the site, click any item on the left sidebar.

Data Tables

This page lists all tables within a selected database. If more than one table exists, these tables are inherently related to each other. The relationship is often described in the Description.

To display all the fields in a table, click the name of the table.
You can retrieve support tables for coded fields and perform interactive analysis on the fields.
To display a detailed description of a specific table, click Profile on the rightthe of thetable name.
To selectively download data from a table, click Download.
To search for data bases containing specific content, such as Passenger or Freight, type the word(s) in the Search this site box and click Go.

Table Description

This page contains the documentation for the data table you have selected.

To find out information about other tables, click the Data Tables link below the Table header.
To display data fields in this table, click the Table Contents link below the Table header.
You can retrieve support tables for coded fields and perform interactive analysis on the upcoming page.
To navigate to databases, tables in the specific database, click on the links under Data Tools on the sidebar.
To search for data tables containing specific content, such as Passenger or Freight, type the keyword in the Search this site box and click Go.

Table Description

This page contains the documentation for the data table you have selected.

To search for data tables containing specific content, such as Passenger or Freight, type the keyword in the Search this site box and click Go.
To display data fields in this table, click the Table Contents link below the Data Tools header on the sidebar.
You can retrieve support tables for coded fields and perform interactive analysis on the upcoming page.
To download data from this selected table, click the Download link below the Data Tools header on the sidebar . You can selectively download data on the upcoming page.
To find out information about other tables of the specific database, click the Data Tables link below the Data Tools header on the sidebar.
To find out information about the database the specific table belongs to, click the Data Profile link below the Data Tools header on the sidebar.
To navigate to databases, click theDatabases link below the Data Tools header on the sidebar.

Note: The Databases, Database Profile, Data Tables, Table Contents links, which have the same functions as the links on the sidebar, can be seen under the Table header.

TranStats Databases

This page lists all databases and summary tables available for a chosen transportation mode, subject, or agency.

To display a detailed description of a specific database, click Database Name in the first column.
To display all the data tables in a specific database, click Data Tables in the third column.
To display all summary tables and related links to the dadabases, click Summary Tables on the top.
To produce a more focused database/summary table list, make a selection from the drop-down list box on the top. You can display items under a subject within a mode (or agency).
To navigate the list of databases or summary tables, click Prev or Next.
To navigate to a new mode or subject, click the appropriate link located on the sidebar under Data Finder.
To search for data bases containing specific content, such as Passenger or Freight, type the keyword in the Search this site box and click Go.

Database Profile

This page describes the database you selected on the Database page. The profile provides essential information about the database including background, summary, coverage, and availability. Use the hypertext links in the document to go to the website or web pages of interest to you.

To search for databases containing other content, such as Passenger or Freight, type the keyword in the Search this site box and click Go.
To return to the list of database names for the mode or subject, click the Databases link under the database header.
To see a list of the data tables in this database, click the Data Tables link under the data profile header.
To print the database profile, click the Acrobat icon under the data profile header.

Search Results

This page lists all tables available for the transportation mode or the subject you have chosen.

To display a detailed description of a specific table, click the table name in the first column.
To display the metadata that describes data fields in a table, select the table and click Details.
You can retrieve support tables for coded fields and perform interactive analysis from the upcoming page.
To download data from a table, select the table and click Download. You can selectively download data on the upcoming page.
To further limit the table list, make a selection from the drop-down list on the top.
You can display tables on one subject within a mode or on one mode within a subject.
To navigate to a new mode or a new subject, use the Data Finder on the sidebar.
To search for data tables containing specific content, such as Passenger or Freight, type the keyword in the Search this site box and click Go.

Table Contents

This page describes all the fields in the table you selected on the Data Tables page. The field descriptions help interpret interactive analysis and determine selective download.

To obtain a table of code description, click the field name. Only categorical fields (fields with discrete values) have hypertext links for support tables.
To view data and perform interactive analysis, click Analysis for the selected field.
If the selected field is categorical, the initial result sumarizes a default dependent variable (for example, Passengers in Aviation data) by the selected category using the latest year of the data.
If the selected field is a continuous variable, the initial result sumarizes the variable itself with no categorization.
For more data exploration, you can change selected variables (continuous and/or categorical) in the result table.

Lookup Table

This page contains the lookup table (also known as support table) that describes the code scheme for the selected categorical field.

To search for specific codes or descriptions in the lookup table, type the codes or descriptions in the Search the results box and click Go. A focus table of reduced size appears.
Note: Separate the codes or descriptions by a comma.
To sort or resort the Codes or Descriptions, click the column heading.
To view code description of another category field, click the Table Contents link.
To print the lookup table, select Format results for printing.
To download the lookup table in comma-delimited format, select Download lookup table and save the results in a file. You can open the file in Excel or Word.
To navigate to another table, click the Data Tables link.
To navigate to a new mode or a new subject, use the Data Finder on the sidebar.

Table Analysis

This page allows you to perform interactive analysis on the field you have selected.
The default view is a table showing distribution of the sum of values of a default dependent variable by the selected categorical field. By default, the latest year of data is used.
The default variable is chosen by pooling the actual usage of the data table. You can change the variable, the year, and/or the categorical field and produce new analyses.

To perform a new table analysis, make new selections in the filter boxes and click Recalculate

To apply Rate (if rates are available for the data), select the rate from the Apply Rate list. The web page automatically refreshes to display the rates.

To display percentage or sort the results, click one of the items under Anlysis Summary on the sidebar.

To view the results in a chart, click Chart under Analysis Type on the sidebar.

To produce a map (if mapping information is available), click Map under Analysis Type on the side bar.

To analyze data distribution across years, click Time Series under Analysis Type on the sidebar.

To produce a crosstabs analysis, click Crosstabs under Analysis Type on the sidebar.

Time Series

This page allows you to perform interactive analysis of a dependent variable by the selected category field across years. The default analysis uses the selected continuous and categorical variables of the Table Analysis.

To change the default analysis, make new selections in the filter boxes and click Recalculate
Note: When the last year's data is not complete, use Filter Periods to analyze data for a comparable period, for example, from the beginning of the year to the month or quarter that the latest data is available.

To find out what a code stands for, move the mouse over the code.

To search for specific codes or descriptions in the result, type the codes or descriptions in the Search the results box and click Go. A focus table of reduced size appears.
Note: Separate the codes or descriptions by a comma. If you search for codes, there may be more rows than you ask for because TranStats searches the description for partial matching as well.

To apply Rate (if rates are available for the data), select the rate from the Apply Rate list. The web page automatically refreshes to display the rates.
If the last year's rate is not available, the last-year column shows "-".

The default display is the value. To display Value Change (or Rate Change if rate is applied), percentage or percentage change, click one of the items under Anlysis Summary on the sidebar.
When changes are displayed, the first year displays "-".

To sort the Codes in a different, click oen of the sorting items on the sidebar.

To analyze data for one specific year, click Analysis Table under Analysis Type on the sidebar and change parameters when you are on the Analysis Table page.

To perform a crosstabs analysis, click Crosstabs under Analysis Type on the sidebar and change parameters when you are on the Crosstabs page.

Crosstabs

This page allows you to perform interactive analysis of a dependent variable by the selected TWO category fields. The default analysis uses the selected continuous and categorical variables of the Table Analysis or Time Series.

To change the default analysis, make new selections in the filter boxes and click Recalculate

To find out what a code stands for, move the mouse over the code.

To sort the Codes in a different, click oen of the sorting items on the sidebar.

To analyze data for one specific year, click Analysis Table under Analysis Type on the sidebar and change parameters when you are on the Analysis Table page.

To perform a crosstabs analysis, click Crosstabs under Analysis Type on the sidebar and change parameters when you are on the Crosstabs page.

On-Time Performance Details

This page contains more detailed information based on on-time performance data reported by US certificated air carriers that account for at least one percent of domestic scheduled passenger revenues.

To view information for the selected month instead of the default information from the beginning of the year to that month, select One Month from the Filter Time drop-down list and click Recalculate.
To view departure information instead of the default arrival information, select Departure from the Filter Selection drop-down list and click Recalculate.
To view detailed information for another month, click Home to return to the home page and then double-click the bar representing the other month.
To view monthly information for any year, click the bar on the chart for that year or the year link in the table.
To perform interactive analysis on the complete data, click the More Analysis... link

On-Time Performance Details (Monthly)

This page contains monthly detailed information on on-time performance in correspondance with the year selected from the bar chart of the previous page.

To perform additional analysis, click More Analysis... link.
To return to the charts of the previous page, click Previous Chart... link.

Time Series Chart

This page contains a time series chart showing data that are filtered by one group (code) of a selected category, a selected variable, and a selected summary statistic.

To chart another group of this category, make a selection from the Filter Categories Level drop-down list and click Recalculate. To navigate to more items in this Category, click Previous or Next from this drop-down list. To view the chart representing all data collected from this Category, Click All Rows at the bottom of the drop-down list.
To chart another dependent variable, make a selection from the Filter Variables drop-down list and click Recalculate.
To chart another summary statistic, make a selection from the Filter Statistics drop-down list and click Recalculate.
To chart another category, click Time Series under Analysis Type from the sidebar and select the category in Time Series.
To chart Value, Value Change or Percent Change, select the appropriate item under Analysis Tools from the sidebar.

The sidebar provides other display and navigation tool as described below:

To display tabulated analysis, select Time Series, Crosstabs, or Table under Analysis Type from the sidebar and select the category in Time Series.
To apply rate (if available), select the appropriate rate from the Apply Rate drop-down list. The rate is apply when you select.
To change the content of the chart, select Value, Value Change, Percent Change, Rate, Rate Change or Percent Rate Change on the graph, move your mouse over the bar, line or area chart.
To change the breadth of the chart, make a selection from the Time Period drop-down list and click Recalculate.
To change the data point frequency of the chart, make a selection from the Frequency drop-down list and click Recalculate.
To change the chart type, make a selection from the Chart Type drop-down list and click Recalculate.
To produce a companion chart, make a selection from the Lower Chart drop-down list and click Recalculate.

Time-Series Drill-Down Chart

This page contains a time-series chart drilled down to the next level of frequency (monthly or quarterly) of one dependent variable by the category you selected.

To change dependent variable, summary statistic, or analysis summary, click the Top Chart on the top bar to return to the anual level and change make appropriate changes on the Time Series Chart page.
To view exact values or percentage each bar represents, move your mouse over the bar.

Selective Download

This page allows you to selectively download data in comma-delimited format from the table you chose.

To download data from specific time period, make selections from the Filter Year and Filter Period drop-down lists.
To download data for specific geographical location (if available), make your selection from the Filter Geography drop-down list.
To download specific data fields from the table, check the individual data fields.
To download all fields, check Select All Fields on the top.

To show the percentage of missing values in a specific field, click Show Percentage Missing in Table. The displayed value represents the missing percentage in the entire table.
To change your selections, click Reset to return to the default.
To download what you have selected, click Download.

Note: The downloaded file should have a csv extension. After saving it on your workstation, you can double-click it to open it in Excel if you have MS Excel installed. If the file exceeds the size limit for Excel, you can open it in any statistics package such as SAS or SPSS.

Open a Comma-Delimited File into Excel

Follow these steps to upload the file you have saved from File Download:

Start MicroSoft Excel.
From the menu bar, select File > Open.
In the Open dialog box, locate the file you have downloaded and click Open.
Note: Make sure that in the Files of Type box, you have selected Text files (.txt) or All files (*.*).
The File Import Wizard opens.
Keep the default setting (Delimited, Start at row 1 and orgin: Windows Ansi), and click Next.
Deselect Tab and select Comma in the Delimiters box, and click Next.
As the downloaded file includes column headings, you cannot change the column format in the Import Wizard. Click Finish to bring the downloaded data into Excel first.
To format numeric or date columns, select the column by clicking on the column header (A, B, C, etc.) and Ctrl-click the column heading (the first row) so that only the data cells are selected. Then select from the menu bar Format > Cells and format the column on the first tab.

Note: Because of limitations of Microsoft Excel, you may not be able to open large data tables.

What are Transportation Indicators

The Transportation Indicators are a set of time series data which are used as a gauge for monitoring the condition of the transportation system. These statistics have been collected by various agencies within the U.S. Department of Transportation or by other federal agencies, such as the U.S. Bureau of the Census. The original Transportation Indicators report, which contains source material, may be found on the Bureau of Transportation Statistics' www.bts.gov homepage.

Tips for browsing data on this page:

On this page the data has been arranged in alphabetical order according to the main headings; the series associated with the main headings are located under the main headings.

To view the available series for a specific category, use the Filter Categories drop-down list box.
To navigate from one page to another, within a category, use he Next and Previous links.
To view a graph of all of the series under a main heading, click the Chart link located on the same line as the main heading.
To download all of the data under a main heading, click the Download link located on the same line as the main heading.
To download the data for an individual series, click the Download link located next to that series.
To view the data for an individual series, as a table, click the Table link located next to that series.
To view the data for an individual series, as a chart, click the Chart link located next to that series.

Note: It will take some time to download a large file over the internet.

Indicators Chart Page

This page allows you to see a visual description of the data through the use of a time series chart. You can view the data as the original data value (Value), the difference between the current value and the last value (Period Change) or as the percent of the difference between the current value and the last value (Percent Change).

Tips for browsing data on this page:

Use the Filter Series drop-down list box to select the chart that you would like to view.
Use the Return to Indicators Page link to navigate back to the main indicators page.
Use the links located on the sidebar under Analysis Type to select the type of analysis you would like to view (chart or table).
Use the links located on the sidebar under Analysis Summary to select how you would like the data represented.
Value � the original data value
Period Change � the difference between the current value and last value
Percent Change � the difference between the current value (C) and the last value (L) all divided by the last value (L) and then multiplied by 100, i.e. ((C-L)/L)*100

Indicators Table Page

This page allows you to view the data in a table format. You can view the data as the value, the period change or as a percent change.

Tips for browsing data on this page:

Use the Filter Series drop-down list box to select the chart that you would like to view.
Use the Return to Indicators Page link to navigate back to the main indicators page.
Use the links located on the sidebar under Analysis Type to select the type of analysis you would like to view (chart or table).
Use the links located on the sidebar under Analysis Summary to select how you would like the data represented.
Value � the original data value
Period Change � the difference between the current value and last value
Percent Change � the difference between the current value (C) and the last value (L) all divided by the last value (L) and then multiplied by 100, i.e. ((C-L)/L)*100

Recreational Boating Page

This page allows you to view Recreational Boating data through the use of charts and tables.

Tips for browsing data on this page:

Use the Filter Time, Filter Rate, and Filter Selection drop-down list boxes to select the charts and the tables you would like to view.
To perform additional analysis, click the More Analysis... link.
To perform the sort of the data in table, click State or Total Accidents of table header.

Important: To perform the new analysis, you must press Recalculate.

Mapping Page

This page provides a visual description of data through the use of the United States map. States on the map are outlined and color-coded according to the legend at the bottom of the page.

Tips for browsing data on this page:

Use the Filter Map Areas, Filter Variables, Filter Statistics, and Filter Years drop-down list boxes to filter the data shown on the map.
Use the links under Analysis Type on the sidebar to return to the table, chart, crosstabs or time series page.

Important: To perform the new analysis, you must press Recalculate.

Note: Maps break data in quantile using equal distance. There is an additional group for null values (meaning no data available). The breakpoints of the two consecutive groups are overlaping to accommodate rounding. There is an implied > sign before the bottom breakpoint of the upper group and a <= sign before the top breakpoint of the lower group.

Data Index

This page provides a complete list of databases/data tables in TranStats Library.

To display a complete list of Databases, select Databases radio button on the top.
To display a complete list of Data Tables, select Data Tables radio button on the top.

The list is in the alphabetical order. Use the alphabetical letters on the top or the bottom of the page to navigate to database or data table names beginning with the letter. Use the Prev and Next tool to navigate within that list.

Note: If you do not know the database name or table name, it is much easier to explore TranStats Library via mode, subject, or agency or search keywords.

Data Release Information

This page provides TranStats data release information. You can access the information in 4 ways:

45-Day All Data shows new and update releases for all data in the last 45 days. This is the gateway to release details.

Click the database name to go to the database and data tables to download new or updated data.
Click the table name to view release details of the last 6 data periods of the selected table.
Click Carriers in the latest data column to view reporting carriers of the latest data of the selected table. From there you will also be able to obtain a list of missing carriers.

Detail by Data shows current data status with carrier filing and revision information for the last 6 data periods. From this view, you can search for individual carrier(s) and navigate to other views using the sidebar menu.
In addition to the legends used on this page, some cells are blank and other contain N/A or Foreign, where data for the carriers do not exist &emdash for a reason:

A blank cell indicates that the carrier in question is required to file less frequently than major carriers (for example, semi-annual filing vs quarterly filing).
N/A indicates that the carrier started or dropped from the requirement at certain point.
Foreign, in T100_Market and T100_Segment tables, indicates foreign carriers whose data are embargoed for those months.

Detail by Release shows what actually happened in each TranStats release. You search for individual carriers or navigate to other views using the sidebar menu.
For new releases, missing carriers are listed. To view all reporting carriers, click View reporting carriers. For update releases, carriers that inserted or modified records are listed, with the data period of these records.

Note: Release details are available only after 3/15/2004 releases. On Time Performance and DB1B data do not have re-filing or revision activities.