This version redacts all sensitive information including who the case was submitted to, who was dispatched, actual location of the incident, and the geocoded location of the incident. The data documented in the table below is the information related to each emergency call that is received by Energy Resources. The data serves as the official record for each call and is used for various things such as determining response time, tracking call volume and ultimately serving as the official record of a response if any questions should arise about how Energy Resources handled an emergency call.
This dataset has the following 21 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| ID | id | number | The unique response Identifier | 1524973 1591967 1417447 1459036 1422378 view top 100 |
| Date Time Initiated | date_time_initiated | calendar_date | The data and time the response was initiated | 2015-12-11T07:21:29.000 2023-03-29T09:21:45.000 2017-09-27T10:45:54.000 2022-09-13T12:06:54.000 2024-05-23T11:42:27.000 view top 100 |
| Month Initiated | month_initiated | text | The name of the month the response was initiated | Dec Jan Nov Oct Feb view top 100 |
| Year Initiated | year_initiated | text | The year the response was initiated | 2017 2019 2018 2022 2023 view top 100 |
| Description | description | text | Category of call received. | Gas Leak Odor Gas Pressure Issue Fire Or Explosion Gas Line Hit Damage Carbon Monoxide Check view top 100 |
| Reason Code | reason_code | text | The reason for the incident if known | No Problem Found Customer Leak City Leak Unknown BLOWING GAS view top 100 |
| Status | status | text | The status of the incident - Closed, Complete, or Open | COMPLETE CLOSED OPEN INPROG CANCEL view top 100 |
| Incident City | incident_city | text | The city of the incident | MESA SAN TAN VALLEY AREA QUEEN CREEK PINAL CO SAN TAN VALLEY view top 100 |
| Magma | magma | checkbox | Whether this is a Magma service | false true view top 100 |
| Time Call Received | time_call_received | text | The time the call was received | 10:30 10:00 11:00 16:00 15:00 view top 100 |
| Site Arrival Time | site_arrival_time | text | The time when service arrived at the incident site | 11:00 10:30 11:30 14:00 12:00 view top 100 |
| Response Minutes | response_minutes | number | The number of minutes it took to respond to the incident | 15 20 30 25 10 view top 100 |
| Site Finish Time | site_finish_time | text | The time service finished at the incident site | 11:00 10:00 12:00 10:30 12:30 view top 100 |
| Over 30 Minutes | over_30_minutes | checkbox | Whether the service response took over 30 minutes | false true view top 100 |
| Problem Type | problem_type | text | The name of the CMMS service request custom fields associated with the service request. | _GAS_LEAK_ODOR _GAS_PRESSURE_NO_GAS _FIRE_EXPLOSION _GAS_LINE_HIT _CO_CHECK view top 100 |
| Date Time Closed | date_time_closed | calendar_date | The date and time the service request was closed | 2018-11-28T12:36:43.000 2018-11-28T14:21:54.000 2018-11-28T14:22:02.000 2018-11-28T14:21:51.000 2018-11-28T14:21:49.000 view top 100 |
| Month Closed | month_closed | text | The name of the month the service request was closed. | Nov Mar Aug Jun Feb view top 100 |
| Year Closed | year_closed | text | The year the service request was closed | 2018 2019 2017 2015 2016 view top 100 |
| Gas Electric Indicator | gas_electric_indicator | text | GAS view top 100 | |
| Public Address | public_address | text | Location of the incident rounded to the hundred block. | 300 S VAL VISTA DR 3300 E UNIVERSITY DR 4000 E UNIVERSITY DR 500 S ALMA SCHOOL RD 6200 E MCKELLIPS RD view top 100 |
| Public Location | public_location | point | Geocoded location of incident rounded to the hundred block | {"coordinates":[-111.56,33.14],"type":"Point"} {"coordinates":[-111.56,33.15],"type":"Point"} {"coordinates":[-111.76,33.42],"type":"Point"} {"coordinates":[-111.75,33.41],"type":"Point"} {"coordinates":[-111.55,33.22],"type":"Point"} view top 100 |