Eurozone debt crisis: the key charts you need to understand what's happening

Europe is in crisis - but what's going on? Which are the right key numbers to compare each country?
Get the data

Euro crisis
Euro crisis: Newspaper bearing headlines on the Greek crisis on display. Photograph: Louisa Gouliamaki/AFP/Getty Images

How bad are things in Europe - and how does each country compare?

Well, besides the data below, Polly Curtis' Reality Check series is a good place to start, answering key questions such as What would the collapse of the euro mean for the UK? and What happens if Greece leaves the euro?

We wanted to see which key indicators are the best for comparing Europe and might help us understand what's going on a little better. The best source for this info is Eurostat. You can download the full data below. What would you add?

1. Government debt

These are the big scary numbers - although it's still regularly mixed up with the deficit (see below) by journalists and politicians alike. As a whole, Europe owes €10,125,117,000,000 - or €10.1 trillion. But it's more meaningful to look at the number as a percent of gross domestic product, or GDP. So, we want to see how much that debt is as a proportion of the whole economy - kind of equivalent to measuring your mortgage compared to the whole economic value of your household. That gives us a European average of 80.9% in the second quarter of this year. But that figure hides a lot of variation: Greece, at the top, owes 151.9%, followed by Italy 121.4%. The UK is just below average at 80.1%. There's nothing inherently bad about having a huge debt - it depends who you owe it to and whether you can manage the payments. Bigger countries are also in a better position: essentially, if you owe the bank £50,000, you've got a problem; if you owe the bank £50,000,000, the bank's got a problem.

Roll over numbers for data

2. Deficits

If the gross debt is equivalent to your mortgage, the deficit is the overdraft, the running gap between your outgoings and ingoings. Big deficits mean more borrowing, and then running it up all over again to cover the costs of that borrowing.

Again, the best way to look at these is as a percentage of GDP, and Eurstat shows which countries are worst affected, this time from the end of 2010, which is the latest available data. It shows Ireland had the worst deficit then at 31.1% followed by Greece at 10.6% and the UK at 10.3%. Compare that to Germany at 4.3% and you can see the relative strengths of the economies.

Roll over numbers for data

3. Are we still in recession?

If you look at changes in GDP - these figures are from the OECD - it does show things improving, albeit slowly. And, as Polly Curtis writes, that the UK's recovery is sporadic, at best.

4. Bond yields

The way governments borrow money is by selling bonds - the interest rate, or "yield", is set when the debt is auctioned. This matters because as a country the higher the rate you have to sell your bonds at, the more you'll have to pay back. In short, the lower the figure the better. As you can see from the chart below, the UK, outside the Euro, is benefiting from being a safe haven. But for Greece, Portugal and Ireland, are considered less safe than Romania and Cyprus. Italy is also in the the top ten worst rates - but this chart is a monthly average, so it doesn't reflect the huge movements going on in the markets today, which have seen Italian rates go up.

Roll over numbers for data

5. Unemployment

It might not even be part of the agenda at the summit this week, but unemployment is the indicator with the most direct impact on real people's lives of those here. Traditionally, when there's a recession, unemployment lags behind - ie, it goes up at the end of the recession and takes a while to come down again. This recession has not seen huge changes in overall unemployment yet, although the last year has seen a gradual rise.

Youth unemployment has gone up too - but the percentages are even more striking: 49.6% of 15-24-year-olds in Spain are unemployed, for instance.

Data summary

European countries compared

Click heading to sort table. Download this data

geo\time
Deficit, % of GDP, 2010
Oct, 10 yr bond yieldsn (lower = better)
Gov debt, % of GDP, Q2 2011
Latest unemploy- ment
Latest 15-24 unemploy- ment
EU (27 countries) -6.6 4.08 80.9 9.8 22.3
EU (25 countries) -6.6        
Euro area (17 countries) -6.2   87.3 10.3 21.7
Euro area (16 countries) -6.3   87.4   21.6
Belgium -4.1 4.2 98.4 7.2 21.1
Bulgaria -3.1 5.26 15.2 10.9 25.6
Czech Republic -4.8 3.14 40.1 6.7 19
Croatia       12.7 35.1
Denmark -2.6 2.23 47.5 7.8 14.9
Germany -4.3 2 81.1 5.5 8.1
Estonia 0.2   6.2 11.3 21.8
Ireland -31.3 8.1 104.6 14.6 29.3
Greece -10.6 18.04 151.9 18.8 46.6
Spain -9.3 5.26 65.2 22.9 49.6
France -7.1 2.99 86.1 9.8 23.8
Italy -4.6 5.97 121.4 8.6 30.1
Cyprus -5.3 7 66.8 9.1 23.1
Latvia -8.3 5.62 45.2 14.8 29.9
Lithuania -7 5.05 37.9 15.3 31.1
Luxembourg -1.1 2.37 18.7 4.9 14.7
Hungary -4.2 7.88 76.8 10.7 25.9
Malta -3.6 4.26 71.6 6.4 14.3
Netherlands -5.1 2.46 63.8 4.9 8.6
Austria -4.4 2.92 72.5 4 8.3
Poland -7.8 5.71 56 10 27.8
Portugal -9.8 11.72 106.3 13.2 30.7
Romania -6.9 7.48 34.3 7.3 23.4
Slovenia -5.8 5.16 44.4 8.2 15.2
Slovakia -7.7 4.33 42.5 13.5 35.1
Finland -2.5 2.51 45.3 7.4 19.6
Sweden 0.2 1.9 36.8 7.4 23.2
United Kingdom -10.3 2.52 80.1 8.3 22
Iceland -10.1        
Norway 10.6   42.3 3.3 8.6

Download the data

DATA: download the full spreadsheet

More open data

Data journalism and data visualisations from the Guardian

World government data

Search the world's government data with our gateway

Development and aid data

Search the world's global development data with our gateway

Can you do something with this data?

Flickr Please post your visualisations and mash-ups on our Flickr group
• Contact us at data@guardian.co.uk

Get the A-Z of data
More at the Datastore directory

Follow us on Twitter
Like us on Facebook


Your IP address will be logged

Comments

11 comments, displaying oldest first

or to join the conversation

  • This symbol indicates that that person is The Guardian's staffStaff
  • This symbol indicates that that person is a contributorContributor
  • Roquentin

    7 November 2011 5:36PM

    So Norway is laughing then?

    Also can someone knowledgeable tell me a bit more about how the employment figures work. i.e. 15-24 yr olds ... I'd expect most 15 yr olds to be unemployed.

  • philprism

    8 November 2011 11:47AM

    Could someone explain the relationship between inflation to growth in these figures.

    When I see a 1.1% growth figure quoted with inflation running at 5.5% we in fact contracting at 4.4%

    Are the growth figures inflation adjusted?

  • DixiesMayor

    8 November 2011 12:11PM

    Very interesting as it shows that Norway has done very well largely because their governments kept North Sea oil, kept Europe at arms length while Maggie flogged ours to the highest bidder and signed away more of our sovereignty.

    How different things may have been today in the UK had we taken such a step in the early days of the North Sea bonanza. History will recall than Tony Benn was right and Maggie wrong on these key decisions.

  • dbezas

    8 November 2011 3:11PM

    «United States of Europe» - The only solution for the European Union survival

    http://dbezas.blogspot.com/2011/11/united-states-of-europe-only-solution.html

  • pikeman

    8 November 2011 3:55PM

    DixiesMayor
    8 November 2011 12:11PM

    Very interesting as it shows that Norway has done very well largely because their governments kept North Sea oil, kept Europe at arms length while Maggie flogged ours to the highest bidder and signed away more of our sovereignty.

    How different things may have been today in the UK had we taken such a step in the early days of the North Sea bonanza. History will recall than Tony Benn was right and Maggie wrong on these key decisions

    You win the prize as the first person to blame Maggie on this thread, it gives you a completely spurious sense of having added something to the debate, when in fact she stopped being PM in 1991 - you amy as well blame Jim Callaghan (he who brought in the IMF in when we were the Greece of the 1970's)

  • Nuffs

    8 November 2011 5:40PM

    Real unemployment figures for Spain are lower, a lot lower I'd dare say. Unfortunately plenty Spaniards think nothing of signing on (collecting el paro) while working en B or en negro - as they say.

    I don't think the system helps, it's way too generous and you can live fairly decently while collecting el paro. Government should definitely look at changing the benefit system, as it currently stands it doesn't push people to find another job in a great rush.

    Another problem in Spain is that large numbers of well prepared young adults refuse to leave their places of birth and move to larger cities where they would be more likely to find work.

  • BillTuckerUS

    10 January 2012 12:25AM

    Regardless of who's responsible, the point is important. Norway seems to have made the right decisions. If we forget Iceland for the moment, the other Nordic countries also seem to be doing well.

    I think it's hard to escape the conclusion that the Nordic people know something about government that the people of most other countries don't know. If so, then the question is "what" do they know?

    I don't know "what." However, my guess is that the answer lies largely in their better education systems. I think your Mr Gove should spend more time studying the Nordic countries and less time looking at the U.S. and the Far East.

or to join the conversation

Latest from the data blogosphere

Datablog weekly archives

Jan 2012
M T W T F S S
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

Bestsellers from the Guardian shop

Guardian Bookshop

This week's bestsellers

  1. 1.  Bigger Message

    by Martin Gayford £18.95

  2. 2.  Stop What You're Doing and Read This!

    £4.99

  3. 3.  Send Up the Clowns

    by Simon Hoggart £8.99

  4. 4.  Why It's Kicking Off Everywhere

    by Paul Mason £14.99

  5. 5.  100 Simple Things You Can Do to Prevent Alzheimer's

    by Jean Carper £10.99

Section classified