SOQL created derived view designed to ensure the computed columns are pulled correctly and can be used to create region maps.

Location of applications for utility assistance (City of Mesa, SRP, Southwest Gas) through Mesa Community Action Network (CAN) and funded by Mesa CARES.

Information collected via applications submitted to the Mesa CARES Small Business Reemergence Program describing the business and requests for financial aid. More information available at https://www.selectmesa.com/business-environment/mesa-business-assistance-portal

Total staff hours coded in Kronos to Mesa CARES - Homeless Assist program.

This view redacts employee name. Total staff hours coded in Kronos to Feeding Mesa program, grouped by Dept.

View grouped by unique restaurant name, number of meals and year.

Total of all Feeding Mesa expenditures as tracked in Advantage FIN financial system where Object Code is NOT "no value".

Total weekly number of incoming calls to the Mesa CARES Outreach Call Center. All times in seconds. Click to drill-down by date, type of call (Service Description).


Information about incoming calls to the Mesa CARES Outreach hotline (480-644-CARES) providing assistance with small business re-emergence, residential utility assistance and feeding Mesa programs. More information about Mesa CARES is at https://www.mesaaz.gov/government/mesa-cares.

This public version redacts the Agent ID field.

Total number of applications received by Mesa CAN for residential utility assistance accepted/rejected. Financial assistance funded by Mesa CARES program.

Information collected via applications submitted to the Mesa CARES Small Business Reemergence Program describing the business and requests for financial aid. More information available at https://www.selectmesa.com/business-environment/mesa-business-assistance-portal