AndreaBozzo/ceres-open-data-index huggingface dataset:
Unsheltered Point in Time (PIT) Count 2014-2018

**No longer updated: see current data at https://data.mesaaz.gov/Community-Services/Unsheltered-Point-in-Time-PIT-Count-Phoenix-Metro-/jagk-fkkw ** Unsheltered Street Count by Municipality (2014‐2018), also known as Regional Homeless Point in Time Count. All communities participate in the unsheltered homeless count conducted during the last week of January. Numbers for all communities with the exception of Phoenix are a direct census of individuals interviewed by volunteers, law enforcement, and outreach workers. The City of Phoenix conducts a survey using an extrapolation method by which areas are designated “high density” or “low density” areas. Direct counts in those areas are then extrapolated to estimate the number of individuals experiencing homelessness in unsheltered situations within the City of Phoenix geographic boundaries.
Tree Inventory

Information about trees owned and maintained by the City of Mesa and includes trees maintained by Parks, Recreation and Community Facilities (PRCF), Transportation and Transit departments. PRCF data is updated semi-annually (first week January & July); Transportation and Transit data updated on-going as changes are made. This dataset also includes other vegetation in city owned parks, open basins, and rights of way including cacti, bushes, etc. City owned/maintained trees are managed by 3rd parties such as West Coast Arborists (WCA). See also [Mesa Trees Are Cool].
Transportation Graffiti

Graffiti abated with location, date of abatement and square footage abated. Data is from October 2015 to present. Days to abatement information is calculated based on receipt during normal workday. See attachment for how "normal workday" information is calculated. Calculated workday request was received by the city staff. Normal workday is generally defined as M-Th excluding holidays. Go to https://citylink.mesaaz.gov/Create to report graffiti or find the link to download an app for your mobile device that you can use to report graffiti.
Transportation Graffiti

Graffiti abated with location, date of abatement and square footage abated.Data is from October 2015 to present. Days to abatement information is calculated based on receipt during normal workday. See attachment for how "normal workday" information is calculated. Calculated workday request was received by the city staff. Normal workday is generally defined as M-Th excluding holidays. Go to https://citylink.mesaaz.gov/Create to report graffiti or find the link to download an app for your mobile device that you can use to report graffiti.
Transit Services RideChoice Trips and Cost/Trip

In the City of Mesa, RideChoice provides taxi service to those certified as ADA Paratransit eligible at a deeply discounted rate. Service is available 24 hours a day, 365 days a year, and you can choose your own taxi provider. There is no requirement to book your trip in advance, and you do not have to share your ride. The amount and cost of service varies by community of residence, but in most cases, shorter trips cost less than or equal to a comparable ADA Paratransit trip
Transit Services Park and Rides Utilization

Park-and-Rides (PnR) are designated for daily transit use and free to use; parking for more than 24 hours is not permitted. There are 7 PnR’s within the City of Mesa. 4 are owned and maintained by the city; they are located at Gilbert Rd/McDowell, Power Rd/202, Superstition Springs Mall/60 and W. Juanita Ave/W. Jerome Ave. The other 3 PnR’s are owned and maintained by Valley Metro, and are located at Sycamore/Main St., Mesa Dr./Main St., and Gilbert Rd/Main St.
Transit Services Paratransit Trips and Cost/Trip

Paratransit is a shared-ride, door-to-door, or curb-to-curb transportation (provided in vans and/or taxicabs) provided to people with disabilities who are unable, or have limited ability because of their disability, to use fixed-route buses or trains. All public transit agencies providing fixed-route bus and rail service are required by the ADA to provide this service.
Traffic Counts

The Average Weekday Traffic Volume is a count of the number of vehicle axle pairs (a car has 2 axles) passing through a given location on an average weekday. This is the traffic volume over a one-day weekday period and is a summary of the data that is collected in 15-minute intervals. The 15-minute interval traffic volumes for a particular location are available through Mesa’s Interactive Traffic Count Map application at https://gis.mesaaz.gov/TrafficCounts
Total Employees and Businesses

Historical information about the total Employees and Businesses Dataset is a snapshot of the total number of businesses that are currently in Mesa, as well as the total number of employees that work in Mesa. Source: ESRI Community Analyst. It is important to note that in this dataset, a “Full-Time Employee (FTE)” in Mesa is someone who may not necessarily live in Mesa, however, they are employed at a business that is located in Mesa. This is a distinct difference between the “Employment” number in Mesa, which is stated in the “Employment Dataset.” Employment refers to the total number of Mesa residents that are employed, within or outside of the City of Mesa.
Stakeholder Satisfaction with Services and Quality of Training Provided

This dataset represents the average satisfaction results of trainings provided by the Operations group within the Office of Management and Budget. The data is derived from the surveys provided by the Operations group in which the success of the survey is based on a rating between Strongly Disagree and Strongly Agree. If the responses are Agree or Strongly agree the training is considered successful, otherwise they are assigned a partial or total percentage of failure.
Shareholder Ratings of OMB Services

Historical information about the annual Stakeholder Ratings of OMB Services survey is distributed by the Management Assistant in OMB at the direction of the Operations Budget Coordinator and OMB Department Director. The number of participants in the survey is dependent on the individuals who participate in the budget process with OMB. Larger departments will have multiple individuals involved in the budget process to fulfill different roles of the process such as Year End Estimates, operational budget construction, budget requests and other elements based on need. Smaller departments will only involve one person in the creation of the budget. The results from the survey are defined by a percentage of respondents that answer Strongly Agree or Agree that the OMB staff was responsive, the quality of instructions, the clarity of communication, and the ease of tools such as PB, FIN and Sharepoint Site. Respondents who do not answer Strongly Agree or Agree count as a partial percentage towards failure.
Ratio of Household Hazardous Materials Sent to Swap Shop - Summarized By Week

Ratio of Household Hazardous Materials (HHM) sent to Swap Shop for Reuse - Summarized by Week. Everything that comes through the Household Hazardous Materials facility is assessed for reuse first, recycling next, and disposal or destruction last. Accepted HHM items that are dropped off at the facility and in usable condition will be made available to Mesa residents at no charge in the Swap Shop, which is located inside the Household Hazardous Materials Facility. Adjusted Weight (A) is derived from taking the Total Weight of HHM (T), less the Electronic item weight (E). The ratio (R) and percentage (P) is derived from dividing the Swap Shop item weight (S) by the Adjusted Weight (A). For more information see also the [HHM Management] dataset. Formulae: T - E = A; S / A = R; (S / A) * 100 = P;
Police Homeless Contacts - Calls for Service

Information about contacts with individuals experiencing homelessness by Mesa Police in response to incidents. Does not include police proactive outreach contacts (HOP). Each row represents offense(s) related to an incident. Unique go_numbers represent a single incident. More than one an offense may be reported per incident. The "Involved Parties" field per go_number represents the number of individuals experiencing homelessness involved in the incident. More than one person may be reported per incident. The same individual may have multiple offenses.
Police Forensics Lab Completion Rate

Number of forensic lab requests completed as a percentage of the total number of lab requests received. Our goal is to complete greater than 90% of the incoming requests each quarter. The Laboratory Information Management System (LIMS) is used to automate this process. Data from the LIMS application is queried two separate times to find all the new requests in that quarter, and then queried a second time for the completed requests by quarter. This is necessary due to how the backend data is constructed by the vendor. The query results are then used in an application to create a report that shows the count of New Requests, and the count of Completed Requests in the same report. It shows the Actual Goal. To determine if they met or did not meet the goal Socrata is used to create a calculated field to divide the completed by the new counts.
Police Dispatch Events 2017-2020

For current events see [Police Dispatch Events 2021-present.] Calls for service dispatched to Mesa Police Patrol Officers through Computer Aided Dispatch (CAD) system for the period 1/1/2017 - 12/31/2020. Calls are modified for public use, obfuscating the address number through rounding it to the 100 block. Note that these are calls for service and may not necessarily correspond to the data located in the [Police Incidents] dataset. Crimes reported in this data set have not been adjudicated in a court of law for final determination. Sensitive crimes are listed but the address of their occurrence will NOT be included. In this way aggregate totals of crimes will be accurate, without providing sensitive information. Addresses where the following crime types occur will NOT be captured: Sexual abuse, Sexual assault, Suicide, Incest, Molestation of a child and Homicide. Priority One (P1) Call: Life threatening or confrontations which may threaten life or safety of a person. Priority Two (P2) Call: In progress crime that could result in a threat to injure or possible major property loss or immediate apprehension of a suspect. Accidents with injury or other traffic incidents that create a traffic hazard. Priority Three (P3) Call: Minor in-progress/just occurred calls, where there is no threat of injury or major property loss. Priority Four (P4) Call: Nuisance calls, civil standbys, delayed reports where reporting party (RP) is at public location. Priority Five (P5) Call: Calls where a delay will not result in a crime occurring or the loss of an apprehension or an injured person not receiving aid.
Phoenix Sky Harbor Daily Temps

Max and min daily temp recorded at Phoenix Sky Harbor Airport in °F. Data sourced from Science & Operations Officer, NOAA/NWS Phoenix, AZ. Aggregated data for sub-state, state, regional, and national level monthly temperature and precipitation data can be obtained from the National Centers for Environmental Information (NCEI) at: https://www.ncdc.noaa.gov/cag/statewide/time-series/2/tavg/1/10/1895-2021?base_prd=true&begbaseyear=1901&endbaseyear=2000
PEX Training Follow-up Survey

This dataset represents the average satisfaction of the PEX class trainings provided by the Performance Excellence group within the Office of Management and Budget. The data comes from the surveys provided by the Management Assistant of OMB, who sends them out within 24 hours of each training. The survey is based on a rating of Strongly Agree to Strongly Disagree. If the responses are Agree or Strongly Agree, the training is considered successful. All other data is considered partial percentage of failure.
Paying Skaters - Ice Rink at City Plaza

Aggregated daily counts of number of paid skaters at City of Mesa’s plaza ice rink, part of the seasonal Merry Main Street events during 2015 - 2017. This dataset has been superseded by the Ticket Sales Ice Rink at City Plaza dataset that includes detailed information about each transaction beginning in 2017. https://data.mesaaz.gov/Recreation-Culture/Ticket-Sales-Ice-Rink-at-City-Plaza/bca4-y9b7 Typical hours of operation are M-F 5-10pm, Sa-Su 12-10pm. Hours of operation may vary depending on weather and attendance patterns (i.e. early close, ice conditions, maintenance issues, etc.).
Parks Locations And Amenities

Information about location and amenities available at developed city parks, park open spaces (basins) maintained by the City of Mesa. Pools, Recreation Centers and other public gathering facilities owned and/or maintained by the City of Mesa's Parks Department such as convention center, amphitheater and cemetery are also listed. Additional information available at https://www.mesaparks.com/parks-facilities/parks/park-rules-regulations. A GIS ParkFinder application is also available at http://gis.mesaaz.gov/ParkFinder/. For more information about park open spaces and basins (non-developed city parks) please visit: https://www.mesaparks.com/parks-facilities/parks/park-open-spaces-and-basins
Open Budget Revenues

Listing of the adopted revenue budget, actual collected revenue tied to budgetary accounts, and year end estimates. This includes the accounting string that describes which fund, organizational department and the activity rollup of the department for the corresponding adopted budget, amended budget, and actual expenditures. The data contained on this website is for informational purposes only and represents adopted budget, revenues, and year end estimates of the City of Mesa. The data does not include internal transfers or accounting adjustments. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). 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.
Open Budget Expenses

Listing of the adopted budget, amended budget, and City expenditures tied to budgetary accounts. This includes the accounting string that describes which fund, organizational department and the activity rollup of the department for the corresponding adopted budget, amended budget, and actual expenditures. The data contained on this website is for informational purposes only and represents adopted budget, amended budget, expenditures, and year end estimates of the City of Mesa. The data does not include internal transfers or accounting adjustments. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). 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.
NIBRS Crimes Lookup Table

2025 version of National Incident-Based Reporting System (NIBRS) Offense Categories and Descriptions. See Source link and notes. Lookup table is used to join with Police Incidents 2020-present dataset to identify unique NIBRS offenses. Incident defined as one or more offenses committed by the same offender, or group of offenders acting in concert, at the same time and place. For counting purposes, agencies should count one offense for each victim of a Crime Against Person, one offense for each distinct operation of a Crime Against Property (except for Motor Vehicle Theft, where one offense is counted for each stolen vehicle), and one offense for each "Crime Against Society".
Municipal Court - Service Call Management

This dataset provides information regarding the number of telephone calls that are handled by the Court’s IVR (Interactive Voice Response) system and the Court’s Resources (Agents). Includes automatic Call Distribution Inbound Services (queue) Call Detail Data. Information includes call totals, duration and service level statistics. Information in this dataset is used for calculation of Court performance measures. See Municipal Court - Telephone IVR Activity at https://citydata.mesaaz.gov/dataset/Municipal-Court-Telephone-IVR-Activity/rhh7-97hu for additional information.
MPSS Agent Speed of Answer Reporting

The Agent Speed of Answer Report is representative of the caller's answer time experience for 911 Calls to the Mesa Police Department. Seizure-to-Answer Time is measured from the time of call seizure to the time of agent answer. Times shown include Setup and may include Queue Seconds and/or Ring Seconds depending on PSAP configuration. Includes abandoned calls. Unknown Agent will show on the report if there are calls that do not have an agent associated with them. Typically, this occurs if the caller hung up before the call could be routed to a station. Number of agents may vary per month.
Misdemeanor Jail Inmate Housing

**Updates to this dataset are paused due to technical difficulties in Police** Misdemeanor jail inmate housing (incidents by location, month, fiscal year) beginning from fiscal year 2011/2012, and includes information relating to those individuals housed at CoreCivic beginning July 2017. No individually identifiable information is included in this data extract. This data will be posted one month behind when the period closes due to the data collection process.
Mesa High School Dropout Rate

Dropout rates reported by Mesa area high schools by cohort year sourced from [https://www.azed.gov/accountability-research/data] Dropout rates cover grades 7–12 and are measured from the first day of summer recess through the last day of the following school year. A dropout is a student who was enrolled at some point during the school year but did not finish — and did not transfer, graduate, or pass away. The dropout rate is calculated using each school's total enrollment.
Mesa Falcon Field Daily Temps - RETIRED

**This dataset is no longer updated - see instead[ Weather Data Mesa Airports and Sky Harbor]**. Daily high/low air temperature recorded at KFFZ1M High Frequency ASOS weather station located at Falcon Field Airport. 2016 data is missing. Location information: Latitude 33.46667, Longitude -111.73333; Elevation (ft)1,391; Elevation from DEM 1,355.
Light Rail Ridership

Breakdown of light rail ridership on a monthly basis per station in Mesa (data lags for approximately 30 days) and is provided by Valley Metro, an external agency who is responsible for both light rail and bus services in Mesa. For a regional view of both light rail and bus ridership, please go to their website, under their Publications/Reports section. Valley Metro uses APC (Automatic People Counter) technology to generate the number of riders that they report on. Data reporting can be delayed up to 60 days.
Licensed Preschools

Provider & Facility Databases. Arizona Department of Health Services Licensing Services is providing citizens with dataset of various health care facilities and providers. Data sourced from [https://www.azdhs.gov/licensing/index.php#databases] (select "Child Care", then "Child Care Centers". These source data tables below are updated on the first business day of the month, and provide a snapshot of licensed providers on the first day of the month. The exact date is contained within each file as the run date.
Library Materials Circulation

Library materials checked out is the number of physical items checked out by library cardholders. These materials include books, DVDs, audio books, et al. In 2015 auto renewals were introduced. In 2016 DVD check out period changed from 1 week checkout to 2 weeks. Descriptions of Materials: -Audio CD - Compact Disc (CD) recording of a reading of a book, typically a novel. -Audio Kit - A book accompanied by a Compact Disc (CD) recording of a reading of the book. The CD recording is contained in a pocket in the front or back of the book. -Board Book - a book for very small children, with the pages pasted to heavy cardboard. -Book - A written or printed work consisting of pages glued or sewn together along one side and bound in covers. -Book bucket - A zippered bag that contains multiple titles about a specific subject, designed for educators to use with elementary students. -Book club kit - Designed for book groups, the kit is a plastic bin with a lid that contains 10 copies of a book and a binder with information about the book to facilitate discussion in a group setting. -Culture pass - A Culture Pass gives library users two free tickets to participating local cultural institutions and theater performances. Each household can check out one pass at a time (maximum of two a month). -DVD - A type of compact disc able to store large amounts of data, especially high-resolution audiovisual material. -Equipment - Other items available for checkout like SRP TrickleStar Plug-In Energy monitors and engraver kits. -Express checkout - Copies of current popular titles that only check out for seven (7) days, are specific to each location and cannot be renewed or reserved. -Interlibrary Loan - A system in which one library borrows a book from another library for the use of an individual. -Magazine - A periodical publication containing articles and illustrations, typically covering a particular subject or area of interest. -Periodical - a magazine or newspaper published at regular intervals. -Playaway - Solid-state prerecorded audio player that can store up to 80 hours of audio in high definition. -Stuffbrary - Library card holders can check out household items, play equipment and more. Stuff is available at all locations, though some items are branch specific.
Library In-House Visits

Total number of patrons entering and exiting the library. In-house library visits are collected and calculated monthly using electronic gate counters. All libraries gather patron counts using the 3M / Bibliotheca security gates which count patrons as they enter and exit the library. Due to technical issues with the gate counters,Due to technical issues with the gate counters, the following numbers have been removed from the dataset. - 1/8/2019 Express Library removed a count of 8,392,559 - 3/7/2019 Main Library removed in count 62089 and out count 61916 - 7/3/2019 Dobson Ranch Library removed in count 276404 and out count 163364
ITD Application and Enterprise Availability

Historical information about zabbix, an open-source monitoring software tool, is reporting the availability of applications and infrastructure. Applications include Advantage, CIS, Kronos, Accela, Judicial Services, GIS, CMMS, and more. It is a roll up of 91 monitors. Infrastructure reports the enterprise platforms, which includes server, storage, network, IVR/ACD and UC platforms. It is a roll up of 57 monitors. The monitors include scheduled down time, which includes scheduled maintenance and upgrades. It also includes the routine downtime for Advantage The available time is converted to a percentage rounded to four 9s. The data set is coming from on ITD dashboard that is currently pulling the monitors’ data from Zabbix.
Injury Accidents Per 1,000 Residents

**Updates to this dataset or paused due to technical difficulties in Police** Traffic collision related injuries per 1,000 residents. Summary totals based on traffic collisions dataset found at https://citydata.mesaaz.gov/Public-Safety/Traffic-Collisions-Reported/24df-s3cy. Population is based on dataset found at https://data.mesaaz.gov/Neighborhoods/City-of-Mesa-Population/89tz-2g4j
Information Technology - Project Schedule and Budget Variance

New dataset replacing https://citydata.mesaaz.gov/Information-Technology/Information-Technology-Project-Schedule-and-Budget/spka-r4fd. This data set lists projects currently in process and managed by the Department of Information Technology. Projects are noted if they are in an implementation phase, which would make their schedule and budget adherence applicable. Budget is listed and determined by project manager if they are within budget, at or under budget, to date. Schedule is determined by project start date, project manager original go live estimate and current go live estimate and /or actual go live date.