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

2019 Annual Database Reporting Waivers

Lists agencies that failed to complete an NTD report or that received a waiver from FTA allowing them not to report for the current year.

Keywords: reporting waiver, agency name, organization type, failure to report, did not report

2019 Database Files

2019_Database_Files_Zip

Zip file containing all 2019 Annual National Transit Database Files. The Database files contain raw data from the NTD 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. 

2019 Annual Database Service

Contains operating statistics reported by mode and type of service. Categorized by vehicles operated and vehicles available in maximum service by day and time period.

2019 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

2019 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

2019 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.

2019 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

2019 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

2019 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