CARES Dashboard

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

$100,000

$100,000

$10,000

Not Reported Received

$100,000

$10,000

Not Reported Spent

100

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.