Recently, the Federal Transit Administration added Historical Data Files to the National Transit Database. These files include operating and capital expenses, trips, passenger miles, and other data for all federally funded transit agencies from 1991 through 2007.
I downloaded the files and put all the ones that were important to me — operating expenses, capital expenses, fare, vehicle revenue miles, vehicle revenue hours, directional route miles, trips, and passenger miles — on separate worksheets of a single spreadsheet (4.4 MB Excel file). All of the years in the columns of all of the worksheets are identical, and the agencies and modes in all of the rows are also identical unless you resort them.
