Local Development Corporations Loans

Public authorities are required by Section 2800 of Public Authorities Law to submit annual reports to the Authorities Budget Office that includes loans data. Local Development Corporations are required to report information on the projects they support and how those approved projects are financed (either through grants, loans, or bonds). The dataset consists of loans data reported by Local Development Corporations that covers 8 fiscal years, which includes fiscal years ending in the most recently completed calendar year.

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/local-development-corporations-loans-vp83-gfyz\".\"local_development_corporations_loans\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.