Good afternoon. I am working with Fire and Emergency Medical Services response data for my dissertation. I am trying to determine 911 call concurrency. Concurrent calls are those that occur simultaneously. That is, when two or more 911 incidents are active within the same emergency medical services (EMS) response area at the same time. The attached sample shows the incident number, dispatch time, available time, and EMS Area.
Column "F" or "dispatch time" is the time of day when a specific truck was dispatched to an incident, which could also be considered the incident start time. Column "H" or "Available" time is when that same truck is back in service and no longer dedicated to the 911 incident, which could also be considered the incident stop time. It would be nice if an incident or line could be flagged if it occurred during the same time another incident was already in progress within the same "EMS Area" or Column "I."
An example of a concurrent incident would be line 11, where incident number 8000010 occurred while incident 8000007 was still taking place. Both were occurring at the same time within the "SP4" EMS area. I hope that makes sense.
The data set seems to contain "=" signs in front of the characters which is how report is generated. Thank you for your help.
Bookmarks