2022 NTD Annual Data - Funding Sources (Directly Generated)

This dataset details directly generated funding for each agency. Examples include Fares, Concessions and Advertising.

NTD Data Tables organize and summarize data from the 2022 National Transit Database in a manner that is more useful for quick reference and summary analysis. This dataset is based on the 2022 Revenue Sources database file.

In years 2015-2021, you can find this data in the "Funding Sources" data table on NTD Program website, at https://transit.dot.gov/ntd/ntd-data.

If you have any other questions about this table, please contact the NTD Help Desk at NTDHelp@dot.gov.

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 \"datahub-transportation-gov/2022-ntd-annual-data-funding-sources-directly-yuaq-zdvc\".\"2022_ntd_annual_data_funding_sources_directly\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.