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

2021 Annual Database Operating Expenses

Sums expenses incurred during day-to-day operations. Organized by mode, type of service, function, and object class.

Keywords: 5307, vehicle operations, vehicle maintenance, non-vehicle maintenance, general administration object classes include labor, fringe benefits, services, materials and supplies, utilities, casualty and liability costs, taxes, purchased transportation expenses, miscellaneous, salaries, wages, cost, fuel costs, tires and tubes, vehicle upkeep, agency operations, operation statistics

2021 Annual Database Operating Expenses Reconciling

Provides an overall operating expense total consistent with locally-published reports.

Keywords: 5307, full, interest expenses, leases and rentals, purchase lease payments, related parties lease agreements, depreciation,amortization of intangibles, other reconciling items expenses classified as funds applied or not applied, balancing costs, expenditure reconciliation, ada-related expenses, financial records, finance reports, reconcile, expenditures

2021 Annual Database Group Plan Sponsors

Contains group plan participants and sponsors of their FTA Transit Asset Management (TAM) Group Plans.

Keywords: Sponsor, group, plan, transit asset management, tam, aim, asset inventory module, title 49 part 625

2021 Annual Database Fare Revenues

Contains data on revenues a transit agency earns from carrying passengers, organized by mode and type of service. Reported as funds earned, funds expended on operations, and funds expended on capital.

Keywords: 5307, full, ssw, small system, reduced reporter, rr, fares, base, special transit, discounted, reduced fare, earned, expended, operations, capital, fare box, payment, passes, tickets, earnings, total fares, fare earnings

2021 Annual Database Facility Inventory

Contains address, facility information and condition assessment for administration offices, parking facilities, maintenance facilities and transit stations.

Keywords: maintenance, facility, station, administration, office, transfer center, terminal, parking, overhaul, inspection, washing, blow down, fueling, testing, revenue collection, elevated, at grade, underground, platform, transit asset management, tam, asset inventory module, aim, title 49 part 625

2021 Annual Database Energy Consumption

Contains data on consumption of fuel and energy used by public transportation agencies to operate revenue vehicles. Organized by mode, type of service (TOS), and fuel type.

Update 12/19/23: Version 1.1 contains updated values for diesel fuel consumed by NTD ID 50118 for Commuter Rail modes.

2021 Annual Database Capital Use

Presents capital expenses for public transportation agencies, by mode, type of service (TOS), capital use type (existing vs. expanding) and function.

Keywords: 5307,  full, ssw, small system, reduced reporter, administrative buildings, passenger stations, guideway, revenue vehicles, service vehicles, communications, information systems, fare revenue collection equipment, maintenance buildings, fare office, administration, stops, metro stations, buildings, offices, transit vehicles, vehicles, new, track, rail, expenditures, cost

2021 Annual Database Agency Mode Service

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

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