CARES Dashboard

Background:

The Coronavirus Aid, Relief, and Economic Security (CARES) Act was an economic stimulus bill in response to the COVID-19 pandemic. This dashboard was built for the Utah Governor's Office of Planning & Budget to help track state disbursements and local government reporting. State disbursements are reported and gathered from the state finance department's database warehouse. Local government revenues (received) and expenes (spent) are reported through the Transparent Utah database.

Parts of the dashboard:

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

$100,000

Total Distributed

$100,000

Reported Received

$10,000

Not Reported Received

$100,000

Reported Spent

$10,000

Not Reported Spent

100

Total Entities

100

Entities' Amount Recieved matches Amount Distributed

100

Entities' Amount Recieved does not match

10

Entities' Amount Spent matches Amount Distributed

10

Entities' Amount Spent does not match

Data

"00AA - FINET Adjustment" is an account tied to the state database system performing corrections and reversals in order to get the General Ledger to balance. Depending on the time range above, it may or may not be balanced.

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