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

Annual Database (Excel)

Legacy ID
1181

2022 Annual Database Agency Mode Service

Contains modes and types of service operated by public transportation agencies reporting to the NTD. 

Last Updated April 12, 2024

Keywords: 5307,  full, ssw, small system, reduced reporter, rr, rail, fixed route, capital use only,  reported separately, vehicles operated in maximum service voms, vehicles available for maximum service, vams, peak service, peak, modes, bus, demand response, commuter, directly operated, purchased service

2022 Annual Database Agency Information

Contains basic contact and agency information for each NTD reporter.

Update 7/17/24: Version 1.3. Updated the number of counties served in Hawaii from 4 to 5. 

Update 4/12/24: Version 1.2. Due to a software error, the report for NTD ID 91004 Port Authority of Administration was marked inactive and was therefore excluded from 2022 publications. The missing records (rows) from this report were added to the respective files.

2021 Database Files

2021 Database Files Zip

Zip file containing all 2021 Annual National Transit Database Files. The Database files contain data from the NTD without manipulation (other than formatting for Excel) and are therefore intended for users comfortable who may intend to perform their own analyses on the data or use the data in their own databases. 

2021 NTD Database File Dictionary

Defines terms found on NTD Reporting Forms and identifies the 2021 Database File in which they are included. Please note that this does not include terms in the 2021 Data Tables and Time Series files - each of those files includes its own data dictionary.

Keywords: annual, data, ntd, data element, data point, data description, data glossary, data dictionary

2021 Annual Database Vehicle Maintenance

Contains data on mechanical system failures for revenue vehicles. Categorized by other mechanical failures or major mechanical failures. Reported by mode and type of service.

Keywords: urban, 5307, full, revenue vehicle system failures, interrupted service, system malfunctions, vehicle malfunctions, failure statistics

2021 Annual Database UZA Sums

Presents allocation service data for each urbanized and rural areas.  Organized by UZAs or non-UZAs.

Keywords: urban, 5307, allocation, federal funding allocation, vehicle revenue hours, vrh, vehicle revenue miles, vrm, passenger miles traveled, pmt, unlinked passenger trips, upt, operating expenses, fixed guideway, directional route miles, passenger miles, 7 years, high intensity, drm, hib, state of good repair, sgr, service allocation, urbanized areas, uza, service across uza, segment age

2021 Annual Database Transit Way Mileage

Contains data on transit right-of-way mileage for non-rail mode operators as well as construction and asset condition information for track and special trackwork for rail mode operators.

2021 Annual Database Transit Stations

Contains data on transit stations (boarding/deboarding facility with platform in a separate right of way), organized by mode and type of service (TOS).

Keywords: urban, 5307,  full, ssw, small system, ada accessible, non-ada accessible, stations, multi-modal, elevators, escalators, stops, passenger stations, metro stops, transit centers, transit hubs

2021 Annual Database Transit Facilities

Contains data on transit facilities (garages or buildings where mechanics perform routine maintenance and repairs).

Keywords: facility type, general purpose, heavy maintenance, ownership type, size, capacity, number of revenue vehicles, maintenance facilities, leased facilities, transit building, vehicle garages, transit garages, maintenance garages

2021 Annual Database Transit Agency Employees

Contains employee resources reported by Labor object class, mode and type of service.

Keywords: urban, 5307, full, small system, salaries, salary, wages, wage, employees, work hours, overtime, vehicle maintenance, vehicle operations, non-vehicle maintenance, general administration, full time, part time, employee statistics, employee count, transit workers, transit operators, agency administration, agency workforce