MTA Headcount: Beginning 2024

This dataset provides actual and projected monthly headcount data, obtained from the MTA’s annual budgeting process, for each month of a fiscal year, categorized by budget scenario, Agency, function, occupational group, and segmented by non-reimbursable (NREIMB) or reimbursable (REIMB) positions.

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 \"ny-gov/mta-headcount-beginning-2024-ui26-n8p4\".\"mta_headcount_beginning_2024\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.