Home

Data Tables For the 2007 National Transit Database Report Year

Note: Links to MS Excel and Adobe PDF files for each data table are found directly under the heading for that table. To go directly do a specific data table, click the corresponding link in the Table of Contents.

Complete Set of 2007 Data Tables in MS Excel format:
2007 Data Tables

Data Dictionary

Listing of Questionable Data Item in the 2007 Database MS Excel format

Table of Contents

Chapter 1 – Introduction. 10

Understanding and Using this Report 1

Report Organization. 1

Data Tables Organization. 1

Special Notes on Reporting and the Data Tables. 3

Number of Agencies Reporting Since 1995. 3

Alphabetical by State. 4

Transit Agency Names. 4

Identification Number and Organization Type. 4

Transit Agency Fiscal Year 4

Database Adjustments. 4

Mode and Vehicle Type Codes. 4

Multi-UZA Reports. 5

Purchased Transportation. 5

Deleted, Questionable, Waived, and Not Reported Data. 6

Vehicles Operated in Maximum Service. 7

Vehicles for Directly Operated and Purchased Transportation Services for a Specific Mode. 7

Vehicles Available for Maximum Service. 7

Completeness and Accuracy of the Data. 7

Caution. 8

Further Information on the Reporting System... 8

Industry / Government Cooperation. 8

Data Availability. 9

 

Chapter 2 The Data Tables. 10

Caution. 10

Special Notes on the Desegregated Data Tables. 10

Reporting Changes. 10

Transit Revenues Tables 1 through 11. 12

Table Descriptions. 12

Table 1: Summary of Operating Funds Applied. 12

Table 2: Directly Generated Sources for Transit Operating Funds Applied: Details by Transit Agency. 13

Table 3: Federal Government Sources for Transit Operating Funds Applied. 13

Tables 4 and 5: State Taxes Dedicated at their Source for Transit Operating Funds Applied and Local Taxes Dedicated at their Source for Transit Operating Funds Applied. 13

Table 6: Directly Generated Taxes Dedicated at their Source for Transit Operating Funds Applied. 14

Table 7: Transit Capital Funds Applied Summary and Federal Sources. 14

Tables 8 and 9: State Taxes Dedicated at their Source for Transit Capital Funds Applied and Local Taxes Dedicated at their Source for Transit Capital Funds Applied. 14

Table 10: Directly Generated Taxes Dedicated at their Source for Transit Capital Funds Applied. 14

Table 11: Capital Funds Applied by Type of Expenditure. 14

Potential Data Applications. 15

Transit Expenses Tables 12 through 15. 15

Table Descriptions. 16

Table 12: Transit Operating Expenses by Mode Type of Service and Function. 16

Table 13: Transit Operating Expenses by Mode and Object Class. 16

Table 14: Transit Operating Expenses and Object Class Single Bus Mode Agencies. 17

Table 15: Operators Wages: Details by Transit Agency. 17

Potential Data Applications. 17

Non-Financial Operating Data Tables 16 through 25. 17

Table Descriptions. 17

Resource Module. 18

Table 16: Revenue Vehicle Maintenance Performance. 18

Table 17: Energy Consumption. 18

Table 18: Employee Work Hours and Employee Counts. 18

Service Module 19

Table 19: Transit Operating Statistics: Service Supplied and Service Consumed. 19

Table 20: Transit Operating Statistics; Service Supplied and Consumed Train Statistics. 19

Asset Module 20

Table 21: Passenger Stations. 20

Table 22: Maintenance Facilities. 20

Tables 23 and 24: Transit Way Mileage Rail and Non-Rail 20

Table 25: Age Distribution of Active Revenue Vehicle Inventory. 21

Potential Data Applications. 21

Transit Performance Indicators Tables 26 and 27. 21

Table Descriptions. 22

Table 26: Fare per Passenger and Recovery Ratio. 22

Table 27: Service Supplied and Consumed Ratios. 22

Appendices
.xls     Appendix A - Transit Agency Cross-reference for Fleet Size Categories
.xls     Appendix B - Transit Agencies Receiving Reporting Waivers
.xls     Appendix C - Transit Agency Identification (Alphabetically by State and Transit ID Number)
.xls     Appendix D - 2000 U.S. Urbanized Areas (UZAs), Populations, Square Miles and Densities
.xls     Appendix E - Reports Deleted, Questionable, Waived and Not Reported

..........................................................................
.pdf     Chapter 1: Introduction
.pdf     Chapter 2: Data Tables for Individual Agency Statistics

Back to top

All documents are provided in PDF, PPT and MS Excel format need to download Readers or Viewers to view.
Get Adobe Reader
 Get Excel Viewer Get Power Point Viewer