This filtered view sums and aggregates by issue year the values of all commercial building permits issued since January 1, 2018 by permit type: Other Commercial (job value), Tenant Improvements (job value) and New Construction (ICC value). Combines values from these 3 summary views: New Construction, Tenant Improvements and Other Commercial Projects.

This view shows the number of Mesa residents enrolled in post-secondary school by education level. Based on US Census American Community Survey (ACS) 5-year estimates.

Household Estimates by Year based on Census Data. Do not delete

Information about outgoing calls from Mesa CARES Outreach staff, 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 view redacts the Agent ID field.

Aggregates current, previous and target energy usage for city owned facilities where site type = Drinking Water Treatment & Distribution.

SELECT
month_date,
sum(`kwh`),
sum(`previous_kwh_usage`),
sum(`target_kwh`),
case(`sum_kwh` > 0, (`sum_kwh` - `sum_previous_kwh_usage`) / `sum_previous_kwh_usage`) AS `total_percent_change`,
case(`sum_kwh` > 0, (`sum_kwh` - `sum_target_kwh`) / `sum_target_kwh`) AS `target_percent_change`

WHERE `site_type` IN ('Drinking Water Treatment & Distribution')

GROUP BY
`month_date`

ORDER BY `month_date` desc

Total population based on US Census
American Community Survey (ACS) 5-year
estimates.

This filtered view includes Educational Attainment information (variable concept = Educational Attainment) sourced by the US Census American Community Survey 5-year Estimates. Information can be filtered by Place, County or Census Tract

This filtered view is annual homeless services information for calendar years 2019-2022 and includes demographic information for individuals receiving homeless services from a Mesa-based provider (demographic audience = "provider") or a Mesa resident (demographic audience = "client") from any Maricopa County provider. A Mesa resident is an individual whose last permanent address > 90 days prior to becoming homeless was in Mesa.