ARPA Dashboard

Background

This dashboard tracks receipt and expenditures of funds from the American Rescue Plan Act of 2021 (ARPA) State and Local Fiscal Recovery Fund by Utah's local governments. All 29 Utah counties and 16 metropolitan cities received payment directly from the U.S. Department of the Treasury (Treasury). For local governments serving populations less than 50,000, the Treasury sent payment to the State and required that the State distribute those funds to those local governments. Each local government in Utah that received payment of these funds, regardless of who distributed the funds, is a prime recipient of the Treasury and is required to report on the expenditure of those funds directly to the Treasury. 50% of each local government's allocation was made available in June 2021 and the remaining 50% of the funds is expected to be made available during the summer of 2022.

Non-entitlement units of local government (NEUs) are local governments typically serving populations of less than 50,000. NEUs received ARPA State and Local Fiscal Recovery Fund payments through the Governor's Office of Planning and Budget instead of directly from the Treasury.

Dashboard Layout

Statewide Report - Compares all local government entities reported amounts against official state disbursements.
Entity Report - Examine a single entity with detailed visualizations and tables
View Raw Data - Access raw database tables yourself for custom analysis

Statewide Report

Entity Report

View Raw Data

Filter Date(s)

FINET Distribution Dates

Transparent Utah Receive/Spent Dates

Re-Query with Custom Date Parameters

This bar chart displays the total distributed, total received, and total spent for each group. The goal is to have the "Reported Received" and the "Reported Spent" match the "Total Distributed" bars.

Data

Search

Select an Entity

Quick Summary

Batch Summary

A submission to the Transparent Utah website is called a batch. Below are details on batches that were detected to have CARES money. We have tried to flag any duplicate batches or concerns of data quality below:

Amount Distributed

Cumulative Sum - Time Series Bar Chart

For each transaction distributed, the amount is added to create a cumulative sum. The total amount distributed (last cumulative sum), is what we will use to compare against transparent utah (reported received and reported spent)

Each bar represents the date's cumulative sum.
The total amount distributed is represented by the bar farthest to the right.

Amount Received

Cumulative Sum - Time Series Bar Chart

For each transaction received, the amount is added to create a cumulative sum. The cumulative sum received should match the amount distributed by the State. If an entity has correctly reported their data, then we would want the farthest right green bar to touch the dashed line.

Each bar represents the date's cumulative sum.
The amount distributed is represented by a dashed line.
Green bar - If the cumulative sum is equal to or less than the amount distributed, the bar is green
Red Bar - If the cumulative sum is greater than the amount distributed then the bar is red.

Amount Spent

Cumulative Sum - Time Series Bar Chart

For each transaction spent, the amount is added to create a cumulative sum. The cumulative sum spent should match the amount distributed by the State. If an entity has correctly reported their data, then we would want the farthest right green bar to touch the dashed line.

Each bar represents the date's cumulative sum.
The amount distributed is represented by a dashed line.
Green bar - If the cumulative sum is equal to or less than the amount distributed, the bar is green
Red Bar - If the cumulative sum is greater than the amount distributed then the bar is red.

Fund Analysis

Fund Treemap

A treemap is similar to a pie chart, in that each rectangle, represents a piece of the whole. The plot below shows relative size/amount for each Fund Level. You can use your mouse to hover over a given rectangle to get more information. You can click a rectangle to zoom in a level. Click the "Zoom Out" button to zoom out a level.

Org Analysis

Organization Treemap

A treemap is similar to a pie chart, in that each rectangle, represents a piece of the whole. The plot below shows relative size/amount for each Organization Level. You can use your mouse to hover over a given rectangle to get more information. You can click a rectangle to zoom in a level. Click the "Zoom Out" button to zoom out a level.

Category Analysis

Category Treemap

A treemap is similar to a pie chart, in that each rectangle, represents a piece of the whole. The plot below shows relative size/amount for each Category Level. You can use your mouse to hover over a given rectangle to get more information. You can click a rectangle to zoom in a level. Click the "Zoom Out" button to zoom out a level.

Get raw Transparent Utah Data

- This query takes about 20 seconds to get results.

Get raw State Database Data