Tag Archives: stats

Waiting for an Ambulance in North Wales? Find the figures here

Of all things, an Ambulance is the one thing you would want to turn up without delay. That goes without saying.

It’s also the one story that comes out every month, with new stats, that mean a lot to a lot of people.

How long you wait for an Ambulance can literally mean the difference between life and death in some cases. In others, it can mean suffering or prolonged agony. In any case, genuine reasons to call an ambulance mean the person needs medical attention quite quickly.

So, how do we measure the data for the public to dissect, and tell the story in a way that matters to them, and at the same time, help any future journalists who are going to come back to the story with future figures.

Easy – you make charts.

This chart shows how the percentage of ambulances which managed to arrive at the scene of the incident within 8 minutes. 8 minutes is the target figure, and the headline figure. Class A emergencies are generally where somebodies life is in serious risk. It is vitally important an ambulance turns up quickly, with a paramedic in tow.

As you can see from the chart, it shows the different areas of North Wales. The ambulances are all from the North Wales Ambulance Services Trust.

The big red bit is North Wales as a whole. The other lines are for the different counties. You can hover over the line and it will tell you the details. This way, you can see who is above and below the North Wales average. Click it, and find out.

To get this data, it’s all freely available as a news release from the Welsh Government news service. It’s not up-to-date, but it’s a release. It’s good. We would love up-to-date stats, but that’s a story for another day though.

So, if you take a look, you see charts of things in PDF format. The evil file format, as it’s more commonly known. Good for locking things down. We know that small charts mean you can’t exactly see all the data though. So, we need to get it ourselves.

Luckily, Wales has a resource for this. It’s called StatsWales, and houses historical data on many things. The one thing we want is the last few years of how the ambulances have been doing.

Whilst we’re there, though, why not pick up some context. How many calls did each area put through to get a response rate like that?

This way, stacked up on each other, you can see which county made the most calls, and which month was the quietest. You can also see which month was the busiest. So, if you were going to move to North Wales, and may have need to call an ambulance to get their quickly, where should you move to? This data is all important. Click it and find out.

The result of this data, done online with Google docs, and worked through by journalists with access to the numbers? An informed piece in the Daily Post.

Ogwen Valley Mountain Rescue: Data with Interactive Charts

Ogwen Valley from the Glyders | Photo: Phil Rogers (erase) on Flickr

Ogwen Valley Mountain Rescue team are one of the teams of volunteers that respond to 999 calls within the mountains of the Ogwen Valley – including North West Wales from Llandudno onwards.

Their website states the dangers of the mountains they respond to incidents in and try and keep safe:

The mountains that surround the valley are about 1000 metres high and the terrain varies quite considerably. With eleven of the Welsh 3000-feet peaks and cliffs that reach about 300-400 metres in height our area is very popular with both walkers and climbers.

They publish data on the website going back to 1961. I decided to map the data with injured and non-injured patients separated to see just how often the team give up their day-to-day life to go risking their safety for those in the dangerous and unpredictable weather of Snowdonia.

The chart below shows the dramatic increase in incidents over the past few years, which in turn takes up more man-hours and costing more in fuel for the vehicles and equipment used.

I am waiting for data for the past four years to show the injured and non-injured, but accurate data up to 2011 is available for call outs. Recent data has not yet been collated correctly so would be unfair to guesstimate from what’s available through the OVMRT.

Hover over each point or bar to see the data for this chart.

Below, this chart shows how many call outs there were and how many people were involved in it. The number tends to rise steadily with the number of call outs. Indeed, the average tends to be between 1 and 2 people per call out. The majority of cases will be just one person. Click interact to see the chart properly.

The different types of injuries sustained are interesting to see. As the years move on, more and more people are not actually injured, rather they are lost. This may be attributed to more people being on the mountains, or more people without a map or a lack of orientation skills. The total amount of incidents rising in recent years does point to an increase in people climbing these mountains not being prepared enough.

It could be attributed to a rise in people attempting to become fitter and healthier, and in the process it is natural that more call outs will be needed, as people have accidents. It can also be linked to the rise in mobile phone use, and the ease of which emergency services can be contacted. That in itself is a good thing – but used badly. The emergency services reaching stranded rescuers are volunteers in the vast majority of mountain rescue cases.

They may be reimbursed petrol money, but a recent report into the cost of the volunteers says they shelled out thousands of their own pounds on vehicle maintenance. If the RAF needs to be called out for search and rescue, thats a expensive.

If the RAF need to attempt a landing or winch rescue in the mountains, with unpredictable winds and low visibility, that is also challenging and dangerous. The injuries sustained by people, ordered by year (1961-2007) and also including one page for total injuries, is below.

And here, you can compare two years worth of data to see how it compares for that year.

All the data used for this does not outright suggest any of the reasons I have mentioned in the text. It is simply gleamed from the Ogwen Valley Mountain Rescue team website, and visualised here for you to see. I would be interested to know what you make of this.