AndreaBozzo/ceres-open-data-index huggingface dataset:
City Revenues

Listing of all City revenues per department. This data includes transactions received by check and cash. Includes record date, customer, amount and the accounting string that describes which fund and organizational department benefited from the transaction. The data contained on this website is for informational purposes only and represents revenue transactions of the City of Mesa. The data includes transactions received by check and cash. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). Certain Mesa customer names have been redacted for confidentiality and safety issues; therefore not all customer names are represented. Certain Activity assignments may change mid-year. This year-to-date information is updated monthly and represents the most current activity assignment regardless of the assignment at the time of the transaction.
City Parcel Polygons

This dataset provides information regarding the location of existing parcel areas, which are defined as Maricopa County Assessor taxable areas within the City of Mesa. Data represents the City’s current parcels and is reconciled monthly with the Maricopa County Assessor’s published parcel numbers. This dataset also shows the floor the parcel occupies, when the parcel was created and the Maricopa County Assessor assigned parcel number (APN). Displays parcel polygons with Maricopa County Assessor parcel number within the City of Mesa. Can be used for a variety of displays and analysis; legally defined areas, taxation purposes, etc.
City of Mesa Population

City of Mesa population figures come from the U.S. Census Bureau’s Population Estimates Program (PEP), released annually (as of July 1 each year). See [Population and Housing Unit Estimates.] Arizona uses these PEP estimates for state revenue sharing under A.R.S. § 42-5033.01. This dataset is the official population base for all per-capita city metrics (e.g., crimes or traffic collisions per 1,000 residents). 2025–2040 population projections are provided by the Maricopa County Association of Governments (MAG) and were adopted June 2023. See [2023 MAG Socioeconomic Projections.] Other population sources not part of this dataset include: • U.S. Census American Community Survey (ACS) 1-year and 5-year estimates: [https://data.mesaaz.gov/d/n5gn-m5c3] and [https://data.mesaaz.gov/Economic-Development/d/9nqf-ygw6] • Arizona Office of Economic Opportunity (OEO) population estimates (method differs slightly from Census PEP): [https://www.azcommerce.com/oeo/population/population-estimates/] • City of Mesa Office of Economic Development demographics (ESRI Community Analyst): [https://www.selectmesa.com/business-environment/demographics]
City Expenditures

Listing of all City expenses per department. This data includes transactions paid by check as well as payroll transactions and transactions paid by wire or electronic draft. Includes record date, payee, amount and the accounting string that describes which fund, organizational department and the activity roll up of the department that benefited from the transaction. The data contained on this website is for informational purposes only and represents expenditure transactions of the City of Mesa. The data includes check payments as well as payroll transactions and transactions paid by wire or electronic draft. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). Certain Mesa vendor and customer names have been redacted for confidentiality and safety issues; therefore, not all vendor or customer names are represented. Payments that are voided in a subsequent Fiscal Year may appear as a negative amount. Certain Activity assignments may change mid-year. This year-to-date information is updated monthly and represents the most current activity assignment regardless of the assignment at the time of the transaction.
CIP Budget

Listing of all financially active City project budgets and expenses from FIN’s budget structure 37 data. This data includes transactions paid by check as well as payroll transactions and transactions paid by wire or electronic draft, and the total project budget associated with projects. The dataset will be pulled once a month for Socrata, and the dataset will represent a point in time as the budget structure will be a live data set. The data contained on this website is for informational purposes only and represents budget and expenditure transactions of the City of Mesa. The data includes check payments as well as payroll transactions and transactions paid by wire or electronic draft. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). Payments that are voided in a subsequent Fiscal Year may appear as a negative amount. Certain Activity assignments may change mid-year. This year-to-date information is updated monthly and represents the most current activity assignment regardless of the assignment at the time of the transaction.
Census Variables (5-year Estimates)

Selected American Community Survey (ACS) variables from Mesa and other nearby municipalities. Visit https://www.census.gov/data/developers/data-sets/acs-5year.html for more information about the US Census Bureau's ACS ongoing survey. See https://www.census.gov/programs-surveys/acs/news/data-releases.html for data annual release schedules. This dataset uses 5-year estimates. Disclaimer: The centroid, internal point, and geometry columns are not consistent across years. 2023 data uses the last geometries from [Mesa Census Tracts to City Boundary v2022] and calculated centroids and internal points.
Census Variables (1-year Estimates)

Selected American Community Survey (ACS) variables from Mesa and other nearby municipalities. Visit https://www.census.gov/data/developers/data-sets/acs-1year.html for more information about the US Census Bureau's ACS ongoing survey. See https://www.census.gov/programs-surveys/acs/news/data-releases.html for data annual release schedules. #This dataset uses 1-year estimates.
Capital Projects Explorer Project Details

Information about Capital Improvement Projects (CIP) planned, in progress or completed by the City of Mesa. A Capital Project is a project that helps maintain or improve a City asset, often called infrastructure. For example, total capital project budget, current year budgeted amount, project spent to date, project milestone dates and geographical information system (GIS) data. A geographic information system (GIS) is a framework that provides the ability to capture and analyze spatial and geographic data. This dataset is used as part of Capital Projects Explorer (https://cip.mesaaz.gov).
Business Services – Support Issues Resolved

Information about Customer Information System (CIS) support tickets. The CIS System Functional Support team (CIS Admin “Help desk”) receive system issues (ex. billing issues, information requests, or system processing questions) affecting internal and external customers via email or phone call and number of tickets resolved same day as reported. Source data and published data updates monthly, however the dataset update job looks every week for the most recent monthly information. For this reason the Max Expected Data Age is 60 days.
Business Services - Inventory Accuracy

The percent of inventory value/level stored in the warehouse is accurate and is verified by using daily blind physical counts. This is calculated by annualizing the gross amount of discrepancies and dividing it by the inventory value: Inventory Accuracy Rate =1-(Gross Discrepancies*12/Inventory value). This dataset is used in combination with "Business Services - Warehouse Inventory" (https://citydata.mesaaz.gov/Business-Services/Business-Services-Warehouse-Inventory-Turnover-Det/ghh3-25pq) to create the view "Inventory Accuracy by Month" (https://citydata.mesaaz.gov/Business-Services/Inventory-Accuracy-by-Month/vqxg-fftr).
Business Services - Discounted Rate Mailing

The percent of outgoing mail that is billed at a discounted rate. Examples of full rate mail are handwritten addresses and foreign addresses. Mail that is not USPS compliant is billed at the full rate and does not qualify for a discount. The discounts vary based on the type of mail, but the goal is to not pay full rate. Data changes and publishing interval is monthly, however the automated job runs weekly to look for the most current monthly data.
Bus Ridership

***NOTE: There are problems with data accuracy on bus ridership counts for June 2019, July 2019, and August 2019 as Phoenix and Valley Metro attempt to integrate new hardware with the existing system. For Mesa this is clearly impacting routes 156, 531, and 541, however, there are minor anomalies with some of the other routes. Breakdown of bus service ridership on a monthly basis per route in Mesa (data lags for approximately 30 days) and data is provided by Valley Metro, an external agency who is responsible for both bus service and light rail in Mesa. For a regional view of both bus service and light rail ridership, please go to their website, under their Publications/Reports section. Valley Metro tracks bus riders as they board. Bus service expands the scope and range of light rail, in addition to being a geographically more flexible means of public transportation in comparison to light rail. The data set captures information starting in July 2013. Effective October 24, 2016, AZ Link has been consolidated with route 112, and the Main Street Link consolidated with route 40. Data reporting can be delayed up to 60 days.
Building Permits (RETIRED)

Building permits issued by City of Mesa. Included: All building permits applied. Not Included: Applications for Documents or Services, Code Compliance Complaints, Planning Cases, Engineering Projects or Signs. To see a dataset that includes Sign Permits see https://data.mesaaz.gov/Development-Services/Building-Permits-Commercial-Residential-and-Signs-/m2kk-w2hz It is assumed that all permits have been issued based on meeting all building and zoning codes.
Arts & Culture - IDEA Point of Sale

Information about participation at the Mesa i.d.e.a. museum generated by the Point of Sale system and includes on-site admission of visitors at various price level, member participation. Point of sale refers to transactions that are handled in Audience view at the front desk of the Museum. Visit https://www.ideamuseum.org/ for more information about the museum. Additional museum participation information is available in https://citydata.mesaaz.gov/Arts-Culture/Arts-Culture-IDEA-Non-Point-of-Sale/hhgz-d3zt and total participation information is at https://citydata.mesaaz.gov/Arts-Culture/Arts-Culture-IDEA-Monthly-Participation/kaam-svck.
Arts & Culture - IDEA Non Point of Sale

Information about participation at the Mesa i.d.e.a. museum generated by the Non-Point of Sale system and includes Birthday parties, workshops, Group tours and other events. Non-point of sale refers to transactions that are usually completed in desktop version of Audience view by the staff members. Visit https://www.ideamuseum.org/ for more information about the museum. Additional museum participation information is available in https://citydata.mesaaz.gov/Arts-Culture/Arts-Culture-IDEA-Point-of-Sale/j6sf-wemi and total participation information is at https://citydata.mesaaz.gov/Arts-Culture/Arts-Culture-IDEA-Monthly-Participation/kaam-svck.
Arts & Culture - IDEA Monthly Participation

Participation for IDEA museum captures the onsite and offsite engagement done through various programs offered by the museum to engage families in creating, experiencing art through imagination and creativity. The tracking of participation data helps us to continuously follow our mission and serve the community. Visit https://www.ideamuseum.org/ for more information about the museum. More detailed information about participation and sales is available in https://citydata.mesaaz.gov/Arts-Culture/Arts-Culture-IDEA-Point-of-Sale/j6sf-wemi (IDEA Point of Sale) and https://citydata.mesaaz.gov/Arts-Culture/Arts-Culture-IDEA-Non-Point-of-Sale/hhgz-d3zt (IDEA Non Point of Sale).
Arts & Culture - AZMNH Non-Point of Sale Program Sales

Historical information that describes total number of participants in Cultural Programming Special Events and Programs at the Arizona Museum of Natural History and Mesa Grande Cultural Park. Special events and programs include: Mesa K Ready, Early Learning Network, Homeschool Science Fair, Dino Egg Hunt, Summer Camps, I Love Science Day, Pottery Workshop, Sensory Gentle Day, Museum Discovery Day, Lectures, Storytelling, and Explore More school programs. For upcoming events, please visit: https://www.arizonamuseumofnaturalhistory.org
Arts & Culture - AzMNH Admissions

Describes total number of participants at the AzMNH and Mesa Grande Cultural Park generated by the Point-of-Sale system (AudienceView) and checked-in by Visitor Services. It includes on-site admissions of visitors at various price levels, member participation, group field trips, discount programs, and programming. For additional information, please visit: https://www.arizonamuseumofnaturalhistory.org
Arts and Culture Downtown Visitation

Number of visits to the Mesa Arts Center, Arizona Museum of Natural History, and i.d.e.a. Museum. The term visits refers to the number of distinct admissions to a program or facility. For example, if an individual were to attend a particular program on ten separate occasions this would be counted as ten visits. This is an industry term and is used for reporting internally to the City of Mesa as well as external agencies that Arts and Culture is affiliated with.The three facilities represented by the dataset are the i.d.e.a. Museum, AzMNH (Arizona Museum of Natural History) and the MAC (Mesa Arts Center) Fiscal year specifies fiscal year by the two year designation e.g. 2009/2010. The City of Mesa fiscal year for all departments is from July 1 - June 30.
Air Quality Weather: Mesa - Brooks Reservoir Station

Hourly air quality and weather data is collected at Mesa - Brooks Reservoir (Weather Station). Data aggregated by Synoptic Data at [https://synopticdata.com] and is for use by residents and partners of the City of Mesa only. sourced from the Synoptic Weather Data API. The table contains various environmental metrics, including wind direction and speed, temperature, humidity, ozone concentration, particulate matter levels (PM2.5 and PM10), carbon monoxide concentration, and dew point. These measurements provide valuable insights into the local atmospheric conditions and air quality. Mesa - Brooks Reservoir- 310 S Brooks, Mesa, AZ 85202 (https://maps.app.goo.gl/aFSbHTfhKZ5CAHZS9 )
Age and Population Demographics

Demographic information of Mesa residents sourced by US Census American Community Survey (ACS) 1-Year Estimates. Race estimates includes survey responses for "One Race" and "Not Hispanic or Latino"). This dataset is manually updated. Sources include: [https://data.census.gov/table?q=dp05&g=160XX00US0446000] Number of Households and Veteran Status Only: [https://data.census.gov/cedsci/table?text=dp02&g=1600000US0446000]
2023-2025 Heat Related Deaths by Zip Code

Number of heat related deaths, by place of injury, reported by Maricopa County Public Health Department during heat seasons 2023, 2024, and 2025. Heat season is generally identified as May-October. Unless otherwise specified in the column metadata, counts include only injury locations occurring within the city boundary and excludes injury locations in unincorporated county islands. Counts are sourced from county Public Health Department. See column metadata for more details. The "Total-All" column includes individuals whose injuries occurred in areas known as unincorporated county islands—these are neighborhoods or communities that are not officially part of any city, even though they may appear to be within city boundaries. Because death certificates listed the nearest city as the place of injury, some of these deaths may be recorded under a city name even if they technically happened outside that city’s jurisdiction. This dataset reports the number of heat-related deaths by location of injury, as recorded by the Maricopa County Public Health Department during the 2023, 2024, and 2025 heat seasons (typically May through October). Unless otherwise noted in the column metadata, counts reflect injuries that occurred within official city boundaries and exclude incidents in unincorporated county islands—areas not formally part of any city. The "Total-All" column includes deaths from both city areas and unincorporated county islands, where the death certificate listed Mesa as place of initial injury. These islands are neighborhoods that may appear to be inside a city but are not under city jurisdiction. See also [Public Health Heat Related Deaths Dashboard]. Zip code centroids sourced from [Mesa Zip Codes].
Energy Resources - Outage Duration

This dataset allows for the monthly computation of the System Average Interruption Duration Index (SAIDI) for the City of Mesa’s electric utility. The System Average Interruption Duration Index is commonly used as a reliability indicator by electric power utilities. It measures the average outage duration for each customer served and is calculated by taking the sum of the total customer minutes of service interruptions and dividing that by the total number of customers served. Data reporting may have a lag of 14 days.
Wifi Activity - City Owned Access Points

Wifi Activity as connected to city-owned access points. Note: only devices that connected to an SSID is listed. Note that SSID @mesa generally reflects WiFi sessions by members of the public (non city employees or city devices). Other devices that may have been in the area but did not connect are not included. Sensitive fields such as device MAC address have been scrambled and are not actual addresses. However, although these have been changed, the uniqueness and mobility of the device has been maintained for listed sessions.
Weather Data: Mesa Airports & Sky Harbor

Weather observations collected at Phoenix Sky Harbor International Airport, Falcon Field Airport and Phoenix-Mesa Gateway Airport. Data aggregated by Synoptic Data at [https://synopticdata.com/] and is for use by residents and partners of the City of Mesa only. The dataset provides a diverse range of meteorological measurements, including temperature, wind attributes, humidity levels, precipitation amounts, atmospheric pressure, and cloud cover details, offering valuable insights into weather conditions.
Vendor Payments

Listing of payments made to vendors. Includes Paid Date, Payee, Amount and the accounting string that describes which fund and organizational department benefited from the transaction. The data contained on this website is for informational purposes only and represents vendor payments for the City of Mesa. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). Certain Mesa vendor names have been redacted for confidentiality and safety issues; therefore not all vendor names are represented. Any payments referenced as Personal Services are benefits relevant to payroll but are not specific to employee wages. Prior to May 1, 2014, debt service payments were not recorded as a check payments and are not represented in this data. ASRS and Utility payments are not recorded as check payments and are not represented in this data. Information of a sensitive or secure nature has been flagged as “Redacted”.
Velocity Individual Traffic Match

Data contains each traffic data "match" generating by the host sensor in one of approximately 100 locations throughout the city. These sensors include Bluetooth/WiFi readers are deployed to collect data from devices that are within range of the sensor usually cellphones. Data is encrypted and then any identifiable information from each read is removed. The system then produces a match and timestamp if a specific device crosses between two readers. Each match is a single traffic data record containing an individual vehicle's travel time and speed along a roadway segment.
Utilization Rate of Housing Choice Vouchers and Voucher Budget Authority

This dataset describes information related to the City of Mesa Housing Authority (MHA) which administers the Section 8 Housing Choice Voucher Program. The program assists low-income individuals or families living in Mesa with rental assistance according to their income. Information in this dataset is used to calculate the Utilization Rate (the percentage of vouchers that are leased up of the number of allocated vouchers from US Department of Housing & Urban Development (HUD) to MHA) and the Voucher Budget Authority (the percentage of the allocated funding dollars for rent payments on behalf of current housing voucher participants).
Unsheltered Point in Time (PIT) Count Phoenix Metro Area

Aggregated and summarized information collected from the Point in Time count of the number of persons experiencing homelessness in the Phoenix-Mesa metro area as of the survey date. Detailed results for Mesa Only at [https://data.mesaaz.gov/Community-Services/Unsheltered-Point-In-Time-PIT-Count-Details-Mesa-O/efjd-c5mi]. Due to the unprecedented COVID-19 pandemic, the US Department of Housing and Urban Development (HUD) approved the Maricopa Regional Continuum of Care to opt out of the unsheltered Point In Time (PIT) Homeless Count for 2021. Every January, volunteers and outreach teams from local communities collaborate to survey and count the number of homeless. persons in their respective locations. With the information provided by the PIT Count, the Maricopa Regional Continuum of Care and local communities can determine how best to address homelessness. For more information see [https://www.azmag.gov/Programs/Homelessness/Point-In-Time-Homeless-Count]. NOTE: The HUD definition of chronic homelessness is: (1) a person who lives in a place not meant for human habitation, Safe Haven, or Emergency Shelter, (2) has a disability, and (3) has been homeless continuously for one year OR four or more times homeless in the last three years, where the combined length of time homeless is at least 12 months. **Mesa 2025 Data: 6 interactions documented in cities outside of Mesa. Geolocation confirmed interactions occurred in Mesa, versus documented city. Dataset manually updated to reflect correct interaction location and correct PIT counts reflected in [Maricopa Regional Continuum of Care ].
Unsheltered Point-In-Time (PIT) Count 2022 Details Mesa Only

Detailed results from the 2022 Point-in-Time (PIT) count of unsheltered individuals identified and/or interviewed in Mesa on the morning of January 25, 2022. Aggregated and summarized regional data available at https://data.mesaaz.gov/Community-Services/Unsheltered-Point-in-Time-PIT-Count-Phoenix-Metro-/jagk-fkkw The PIT count is conducted annually in January. See the attached 2022 PIT Unsheltered Count Form for more information about questions asked. See also the Maricopa Association of Governments to learn more about the Point-in-Time Homeless Count program: https://azmag.gov/Programs/Homelessness/Point-In-Time-Homeless-Count