Spreadsheet of EMS Data
The following is a spreadsheet of EMS data that my supervisor and I created. Included in the spreadsheet are results for the 55 EMS agencies that were surveyed. Because of confidentiality, the agencies are listed by numbers, not names, but their results remain the same. You will see results on past data from 2017 when agencies were asked about a PECC as well as the results from 2018. Notice how agencies have either stayed consistent with their decision or changed their mind the second time around. You will see the call volume for each agency and you will get to compare their call volume to their answer of having a PECC or not. One example is Agency 23 who had over 1000 pediatric calls within the last 3 years, but has no PECC. Another example is agency 47 who did not have an identified PECC in 2017, but in 2018 does. Other information included are qualifications, training, and roles.
In order to have created this spreadsheet, we went back to the first spreadsheet of all of the EMS agencies information of their results in 2017 and 2018, qualification and training data, and the roles associated. We then put the agencies in alphabetical order and replaced their agency name with numbers. That way the information was confidential, as I mentioned above. The most interesting to me was comparing last years data to this year, and how many things are able to change in a matter of time.
