Schedule of State Grant Awards, 2015-Present

The dataset is a summary of the state grant awards for all Metro departments. The detail is provided annually by each department in an excel format and then reviewed and summarized by the Finance Department. The excel file is provided to Metro’s external auditors and is the source of Metro’s Single Audit report which is published annually and available on Metro’s website in a pdf format.

The detail included in this dataset includes fiscal year, program title, contract number, grant period, program award, (accrued) deferred grant revenue balance at the beginning of the fiscal year, amount of state grant money received, revenue adjustments made if any, expenditures/distributions made, expenditure/payment adjustments made if any, (accrued) deferred grant revenue balance at the end of the fiscal year, grantor name, department code, and department full name.

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 \"nashville-gov/schedule-of-state-grant-awards-2015present-nd5q-spq9\".\"schedule_of_state_grant_awards_2015present\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.