State of Vermont Grants Issued

Beginning in SFY2014, the Department of Finance and Management was required by 32 VSA §314 to issue an annual report of all grants issued. (In 2012 to 2013, the Department began a pilot program to include non-federal grants in its database and those reports are available separately.)

Awards included in this dataset have been awarded (authorized) by a State of Vermont department to the grantee during the report year. This funding may or may not have been expended or received by the grantee during that year. In the case of multi-year grants, the grant award is included in the year in which the grant was originally issued, and is not included each year for the duration of the award. If a grant is subsequently amended, it is not updated in this report.

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 \"vermont-gov/state-of-vermont-grants-issued-xifk-zskz\".\"state_of_vermont_grants_issued\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.