A few days ago, the Federal Transit Administration posted the 2012 National Transit Database. Data are downloadable in three formats. First, you can download profiles for every transit agency (21.3 MB). These give basic data such as trips, passenger miles, fares, and costs broken down by type of transit. If you don’t want to download the whole book, you can also download profiles for individual agencies by entering the agency name, city, or ID number in a search box (scroll down and look for “Individual Profiles” on the righthand column).
Second, you can download data tables, which present the data for all transit agencies in fairly user-friendly spreadsheets. All of the tables at once can be downloaded in a self-extracting exe file (4.1 MB), but my Macintosh doesn’t want to extract the spreadsheets. One problem with the data tables is that there are separate tables for trips, fares, operating costs, capital costs, and other data, so comparing the numbers is difficult.
Third, you can download database spreadsheets. These are more difficult to read than the data tables, but are easier to manipulate on a computer because every row on each spreadsheet follows a consistent format. Like the data tables, these spreadsheets can also be downloaded as one self-extracting exe file (5.1 MB).
