2022 NTD Annual Data - Stations and Facilities (by Agency and Facility Type)

This dataset details station/facility types and counts for each applicable agency reported to the National Transit Database for Report Year 2022.

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 Transit Facilities and 2022 Transit Stations database files.

In years 2015-2021, you can find this data in the "Facilities and Stations" 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-stations-and-facilities-by-aqct-knjk\".\"2022_ntd_annual_data_stations_and_facilities_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.