American Rescue Plan Funding Expenses

In March 2021, Congress passed President Biden's American Rescue Plan, which included funding to local governments. As part of the law, Macoupin County will receive $8,713,121 in funding. The money can only be spent based on the rules from the U.S. Treasury Department. As of August 1, 2021, the main objectives for the funding is 1) Support urgent COVID-19 response efforts to continue to decrease spread of the virus and bring the pandemic under control, 2) Replace lost revenue for eligible state, local, territorial, and Tribal governments to strengthen support for vital public services and help retain jobs, 3)Support immediate economic stabilization for households and businesses, and 4) Address systemic public health and economic challenges that have contributed to the inequal impact of the pandemic. This dataset will show how Macoupin County is choosing to spend the American Rescue Plan funding. You can see a short description of the expense, how much has been spent as of today on that item, and how much the county expects to spend for that item. The County has until December 2024 to budget all of their funds and until 2026 to spend it.

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 \"macoupincountyil-gov/american-rescue-plan-funding-expenses-n9j5-zhzt\".\"american_rescue_plan_funding_expenses\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.