2022 NTD Annual Data - Employees (by Mode and Employee Type)

This dataset contains data on transit agency employees as reported to the National Transit Database in Report Year 2022. It is organized by agency, mode, type of service, and Employee Type (Full Time or Part Time Employee).

The 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 annual NTD database file Employees which is published to the NTD at https://transit.dot.gov/ntd/ntd-data.

Only Full Reporters report data on employees, and only for Directly Operated modes. Other reporter types, and Purchased Transportation service, do not appear in this file.

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-employees-by-mode-and-uyv8-9jek\".\"2022_ntd_annual_data_employees_by_mode_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.