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

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

Keywords: 5307, full, battery, charging, propulsion power, kilowatt, hours, diesel, fuel, bio-diesel, gasoline, liquefied, petroleum, natural gas, ethanol, methanol, gallons, kerosene, bunker fuel,  hydrogen, other fuel, fuel supply, power, resources, electric, alternative fuels

2019 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, rr, 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

2019 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

2019 Database File Dictionary

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

Keywords: annual, 5307, questionable, data, deleted, ntd id, reporter name and funding type, data point, issue description, agency location

2019 Annual Database Agency Information

Contains basic contact and agency information by NTD reporter.

Keywords: 5307,  full, ssw, small system, reduced reporter, ntd id, fiscal year end, report due date, agency type, organization type, institutional structure description, mailing address, service area information, duns, fta recipient id, urbanized, area, uza, demographic information, website, report required, transit system, volunteer drivers, personal vehicles

2019 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

2018 NTD Database Dictionary

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