MTA Subsidies: Beginning 2019

This dataset provides a detailed breakout of the dedicated taxes and subsidies received from the State of New York and businesses, individuals and localities in the MTA region. This data is obtained from the MTA’s annual budgeting process and is available for each month of a fiscal year, on both an accrual (represented as NREIMB) and a cash basis. Data is categorized by budget scenario, Agency, Financial Plan Year, and subcategories for types of subsidies.

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-subsidies-beginning-2019-dfg9-c5rx\".\"mta_subsidies_beginning_2019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.