Government Transportation Financial Statistics (GTFS) Data

Government Transportation Financial Statistics is no longer being updated by the Bureau of Transportation Statistics as of June 2024!

It is being replaced by our new product, Transportation Public Financial Statistics (TPFS) which provides more granularity by expanding the categories of revenues and expenditures. The new dataset can be found:

https://data.bts.gov/Research-and-Statistics/Transportation-Public-Financial-Statistics-TPFS-/6aiz-ybqx/about_data

Further information about the TPFS can be found at: https://www.bts.gov/tpfs

The government plays an important role in the U.S. transportation system, as a provider of transportation infrastructure and as an administrator and regulator of the system. The government spends a large amount of funds on building, rehabilitating, maintaining, operating, and administering the infrastructure system. Government revenue generated from several sources including user fees, taxes from transportation and non-transportation-related activities, borrowing, and grants from federal, state, and local governments primarily supports these activities.

Government Transportation Financial Statistics (GTFS) provides a set of maps, charts, and tables with information on transportation-related revenue and expenditures for all levels of government, including federal, state, and local, and for all modes of transportation.

Related tables can be found in National Transportation Statistics, Section 3.D - Government Finance (https://www.bts.gov/topics/national-transportation-statistics).

For further information, data definitions, and methodology, see https://www.bts.gov/gtfs

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bts-gov/government-transportation-financial-statistics-nu8j-7gmn\".\"government_transportation_financial_statistics\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.