Distribution of Funds to Non-Entitlement Units of Local Government in Iowa

The U.S. Department of the Treasury through Coronavirus Local Fiscal Recovery Fund provided a critical source of relief for smaller local governments, many of which have not received direct fiscal assistance from the federal government since the onset of the COVID-19 pandemic. Non-entitlement units of local government (NEUs) are cities serving populations less than 50,000. The State of Iowa is responsible for distributing these funds to NEUs within Iowa. Award amounts are based on the population of the NEU.

Distributions from the Local Fiscal Recovery Fund to state, then subsequently NEUs are being done in two tranches. The first tranche was done in 2021, and the second in 2022.

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 \"mydata-iowa-gov/distribution-of-funds-to-nonentitlement-units-of-yp54-t3rh\".\"distribution_of_funds_to_nonentitlement_units_of\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.