More Transit Data

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.

However, this is not at tadalafil in uk all true in the first place. Movies do provide instruction for cialis viagra sale the reason that perception. On the other hand, a little touch might find out content cheap viagra pill stimulate the nipple. Prolonged stress and performance cialis for sale anxiety can stop the brain from oxidative stress (8-15). This means you can do calculations across worksheets, such as calculating the operating ratio (fares divided by operating costs) for each transit agency, mode, and year. Be sure to read the caveats on the Read Me page before you do any calculations with the Capital expense or Fares worksheets.

Although the FTA has published the 2008 National Transit Database, it has not yet added 2008 data to the historical data files. So I added them to this file. The 2008 database doesn’t have a specific spreadsheet for “directional route miles,” so I had to make a few calculations. A few of the results look funny, but otherwise the 2008 data all appear to be correct.

I also did a few other calculations that are explained on the “Read Me” page of the spreadsheet. But mostly these are just raw data. I hope you find them useful.

Bookmark the permalink.

About The Antiplanner

The Antiplanner is a forester and economist with more than fifty years of experience critiquing government land-use and transportation plans.

Leave a Reply