Panel graph with country names attached

[Vladimir Arcabic]

Hi all,

I'm using panel data on public debt from 1980 to 2015. What I would like to do is a xtline overlay graph with attached country names for the highest debt in the first and in the last period.
I did it manualy, and it looks like this:

I did it using the following commands

* identifying countries with highest debt
summarize debt_snde if year==2015 
local max = r(max)
tabulate countryWDI if debt_snde == r(max) & year ==2015 
summarize debt_snde if year==1980
tabulate countryWDI if debt_snde == r(max) & year ==1980
sort country year

* plotting the data
xtline debt_snde if year>=1980 , overlay  legend(off) note("All Countries") ytitle("Debt to GDP ratio") ///
   tlabel(1980(5)2015) ylabel(,format(%14.0fc)) ttext(`max' 2015 "JPN" 318.93 1980 "GUY", place(n))
graph export "fig1-a.png", as(png) replace

I use summarize to identify maximum, and then tabulate to identify a country name. As you can see, I hard coded country name in the ttext option. What I would like to do is automate it in a way that the first and the last period are selected automatically (1980 and 2015) and that I can automatically select the country name.

Any help would be appreciated!

Thank you,

Vladimir

[Phil Bromiley]

You'll increase your chances of a helpful answer by following the FAQ on asking questions. You provide code, but providing sample data with dataex would let someone test their solution to your problem.
I don't know if this would work, but I'd try to load the country into locals that you can then put in the xtline statement. Since this looks like a modest sized data set,
you could sort by debt_snde declining year
gsort debt_snde -year
local maxcty=country[1]

gsort -debt_snde year
local mincty=country[1]
Then you can put `maxcty' and `mincty' into the xline statement.

I could have the signs wrong on the sorts.

[Vladimir Arcabic]

Hi Phil,

Thank you for your suggestion. I put a sample of my data using dataex at the end of this post.

Unfortunately, gsort won't work, because my sample does not start with 1980 and does not end with 2015.

I have tried if command to compute local macro, but it won't work properly. Any idea on how to fix it?

summarize debt_snde if year==2015 
local max2 = r(max)
if debt_snde==`max2' {
   local maks=countryWDI
}

My idea is to save country name into local macro named maks when debt_snde variable is equal to r(max).

Thank you,

Vladimir

Data example:

* Example generated by - dataex -. To install: ssc install dataex
clear
input double(debt_snde year) str3 countryWDI
                 . 1950 "AUT"
                 . 1951 "AUT"
                 . 1952 "AUT"
                 . 1953 "AUT"
                 . 1954 "AUT"
                 . 1955 "AUT"
                 . 1956 "AUT"
                 . 1957 "AUT"
                 . 1958 "AUT"
                 . 1959 "AUT"
                 . 1960 "AUT"
                 . 1961 "AUT"
                 . 1962 "AUT"
                 . 1963 "AUT"
                 . 1964 "AUT"
                 . 1965 "AUT"
                 . 1966 "AUT"
                 . 1967 "AUT"
                 . 1968 "AUT"
                 . 1969 "AUT"
                 . 1970 "AUT"
                 . 1971 "AUT"
                 . 1972 "AUT"
                 . 1973 "AUT"
                 . 1974 "AUT"
                 . 1975 "AUT"
                 . 1976 "AUT"
                 . 1977 "AUT"
                 . 1978 "AUT"
                 . 1979 "AUT"
  33.9746588233349 1980 "AUT"
  36.0808641720718 1981 "AUT"
  38.8837099430304 1982 "AUT"
  43.9663236170145 1983 "AUT"
  42.3496502831039 1984 "AUT"
  45.3561581778088 1985 "AUT"
  48.2794628881463 1986 "AUT"
  54.5725997566524 1987 "AUT"
  58.8843765674479 1988 "AUT"
  58.9279896995295 1989 "AUT"
    56.20161187525 1990 "AUT"
  56.4038714979149 1991 "AUT"
  56.3706926928905 1992 "AUT"
  60.8955228633004 1993 "AUT"
  64.1884713835598 1994 "AUT"
  68.3943643339841 1995 "AUT"
  68.3292282494739 1996 "AUT"
  64.3537834452337 1997 "AUT"
  64.7759767133567 1998 "AUT"
  67.2069717655358 1999 "AUT"
   66.554732084424 2000 "AUT"
  67.3251371233254 2001 "AUT"
  66.5909480797305 2002 "AUT"
  65.7401041575737 2003 "AUT"
  65.3724389015894 2004 "AUT"
  68.3145118833623 2005 "AUT"
  67.0441837600102 2006 "AUT"
  64.8082199592062 2007 "AUT"
  68.5176780089782 2008 "AUT"
  79.7258308603112 2009 "AUT"
   82.389797286404 2010 "AUT"
   82.193134571319 2011 "AUT"
  81.6244075571532 2012 "AUT"
  80.7988644637933 2013 "AUT"
  84.2537829233066 2014 "AUT"
  86.1926755378667 2015 "AUT"
                 . 2016 "AUT"
                 . 2017 "AUT"
                 . 1950 "BEL"
                 . 1951 "BEL"
                 . 1952 "BEL"
                 . 1953 "BEL"
                 . 1954 "BEL"
                 . 1955 "BEL"
                 . 1956 "BEL"
                 . 1957 "BEL"
                 . 1958 "BEL"
                 . 1959 "BEL"
                 . 1960 "BEL"
                 . 1961 "BEL"
                 . 1962 "BEL"
                 . 1963 "BEL"
                 . 1964 "BEL"
                 . 1965 "BEL"
                 . 1966 "BEL"
                 . 1967 "BEL"
                 . 1968 "BEL"
                 . 1969 "BEL"
                 . 1970 "BEL"
                 . 1971 "BEL"
                 . 1972 "BEL"
                 . 1973 "BEL"
                 . 1974 "BEL"
                 . 1975 "BEL"
                 . 1976 "BEL"
                 . 1977 "BEL"
                 . 1978 "BEL"
                 . 1979 "BEL"
              53.6 1980 "BEL"
              63.5 1981 "BEL"
  98.7942858112688 1982 "BEL"
  109.358111132576 1983 "BEL"
  113.646017683677 1984 "BEL"
  118.380672918105 1985 "BEL"
  123.617980996676 1986 "BEL"
  128.137961472676 1987 "BEL"
  128.592667052419 1988 "BEL"
  127.716529004042 1989 "BEL"
  125.558286910796 1990 "BEL"
  126.926151847272 1991 "BEL"
  128.506906160812 1992 "BEL"
  134.068497252521 1993 "BEL"
  132.067325928957 1994 "BEL"
  130.181701006137 1995 "BEL"
  127.479538479027 1996 "BEL"
  122.667600922201 1997 "BEL"
  117.402644905922 1998 "BEL"
  113.571419600882 1999 "BEL"
  107.778508129341 2000 "BEL"
  106.483373941025 2001 "BEL"
  103.386580993898 2002 "BEL"
  98.3636060777242 2003 "BEL"
  94.0251572327044 2004 "BEL"
   91.967637220492 2005 "BEL"
   91.038109410305 2006 "BEL"
  87.0212133299489 2007 "BEL"
   92.528537766557 2008 "BEL"
  99.5635944722922 2009 "BEL"
  99.7103537245224 2010 "BEL"
  102.336996246172 2011 "BEL"
  104.115401590411 2012 "BEL"
  105.186222703253 2013 "BEL"
    106.5680505884 2014 "BEL"
  106.052412391581 2015 "BEL"
                 . 2016 "BEL"
                 . 2017 "BEL"
                 . 1950 "CHE"
                 . 1951 "CHE"
                 . 1952 "CHE"
                 . 1953 "CHE"
                 . 1954 "CHE"
                 . 1955 "CHE"
                 . 1956 "CHE"
                 . 1957 "CHE"
                 . 1958 "CHE"
                 . 1959 "CHE"
                 . 1960 "CHE"
                 . 1961 "CHE"
                 . 1962 "CHE"
                 . 1963 "CHE"
                 . 1964 "CHE"
                 . 1965 "CHE"
                 . 1966 "CHE"
                 . 1967 "CHE"
                 . 1968 "CHE"
                 . 1969 "CHE"
                 . 1970 "CHE"
                 . 1971 "CHE"
                 . 1972 "CHE"
                 . 1973 "CHE"
                 . 1974 "CHE"
                 . 1975 "CHE"
                 . 1976 "CHE"
                 . 1977 "CHE"
                 . 1978 "CHE"
                 . 1979 "CHE"
  43.9317713815716 1980 "CHE"
  40.7835878215061 1981 "CHE"
  40.0379836826372 1982 "CHE"
  34.3830790288153 1983 "CHE"
  34.0606583162158 1984 "CHE"
  33.4541675428698 1985 "CHE"
  32.1344222456919 1986 "CHE"
  31.2081600631615 1987 "CHE"
  29.9094122184744 1988 "CHE"
  27.8119255879431 1989 "CHE"
  34.3135657245129 1990 "CHE"
  36.0414459186348 1991 "CHE"
  40.9804848331668 1992 "CHE"
  46.6512830229812 1993 "CHE"
  49.9740257360118 1994 "CHE"
  52.8378537766442 1995 "CHE"
  54.2866681907084 1996 "CHE"
  56.9465284822211 1997 "CHE"
   59.351269476313 1998 "CHE"
  55.7704050259396 1999 "CHE"
  54.5631931436234 2000 "CHE"
  53.5386423941274 2001 "CHE"
  60.3475995601935 2002 "CHE"
  59.4474273701248 2003 "CHE"
  60.7680805982618 2004 "CHE"
   58.256448541204 2005 "CHE"
  51.6669780168441 2006 "CHE"
  49.5263954948369 2007 "CHE"
  49.3975828531467 2008 "CHE"
  47.3368469098084 2009 "CHE"
  46.1319735975155 2010 "CHE"
  46.0271815637004 2011 "CHE"
  46.6317637581022 2012 "CHE"
   46.352315609622 2013 "CHE"
  45.6611298832054 2014 "CHE"
  45.6563528843152 2015 "CHE"
                 . 2016 "CHE"
                 . 2017 "CHE"
                 . 1950 "CYP"
                 . 1951 "CYP"
                 . 1952 "CYP"
                 . 1953 "CYP"
                 . 1954 "CYP"
                 . 1955 "CYP"
                 . 1956 "CYP"
                 . 1957 "CYP"
                 . 1958 "CYP"
                 . 1959 "CYP"
                 . 1960 "CYP"
                 . 1961 "CYP"
                 . 1962 "CYP"
                 . 1963 "CYP"
                 . 1964 "CYP"
                 . 1965 "CYP"
                 . 1966 "CYP"
                 . 1967 "CYP"
                 . 1968 "CYP"
                 . 1969 "CYP"
                 . 1970 "CYP"
                 . 1971 "CYP"
                 . 1972 "CYP"
                 . 1973 "CYP"
                 . 1974 "CYP"
                 . 1975 "CYP"
                 . 1976 "CYP"
                 . 1977 "CYP"
                 . 1978 "CYP"
                 . 1979 "CYP"
           20.4908 1980 "CYP"
           22.4488 1981 "CYP"
           22.0422 1982 "CYP"
           25.9375 1983 "CYP"
           26.1452 1984 "CYP"
           26.9815 1985 "CYP"
           28.6274 1986 "CYP"
           32.6539 1987 "CYP"
           33.4088 1988 "CYP"
           29.2855 1989 "CYP"
           31.9606 1990 "CYP"
           35.1547 1991 "CYP"
           36.6683 1992 "CYP"
           39.1924 1993 "CYP"
           35.0848 1994 "CYP"
  46.8089823170414 1995 "CYP"
  48.9085271707066 1996 "CYP"
  53.6955322669608 1997 "CYP"
  55.1611117262762 1998 "CYP"
  55.9199727461365 1999 "CYP"
  56.2618577824998 2000 "CYP"
  57.8741441147701 2001 "CYP"
  61.3741466637305 2002 "CYP"
  63.4146914789422 2003 "CYP"
  65.1066673446114 2004 "CYP"
  64.4293433986857 2005 "CYP"
  59.4818248230345 2006 "CYP"
  53.5675025467772 2007 "CYP"
  44.5659334820954 2008 "CYP"
  53.3726862998653 2009 "CYP"
  56.3327753949158 2010 "CYP"
  65.8370508308095 2011 "CYP"
   79.259635930309 2012 "CYP"
   102.51430975499 2013 "CYP"
  108.194393340079 2014 "CYP"
  108.868185549375 2015 "CYP"
                 . 2016 "CYP"
                 . 2017 "CYP"
                 . 1950 "DEU"
                 . 1951 "DEU"
                 . 1952 "DEU"
                 . 1953 "DEU"
                 . 1954 "DEU"
                 . 1955 "DEU"
                 . 1956 "DEU"
                 . 1957 "DEU"
                 . 1958 "DEU"
                 . 1959 "DEU"
                 . 1960 "DEU"
                 . 1961 "DEU"
                 . 1962 "DEU"
                 . 1963 "DEU"
                 . 1964 "DEU"
                 . 1965 "DEU"
                 . 1966 "DEU"
                 . 1967 "DEU"
                 . 1968 "DEU"
                 . 1969 "DEU"
                 . 1970 "DEU"
                 . 1971 "DEU"
                 . 1972 "DEU"
                 . 1973 "DEU"
                 . 1974 "DEU"
                 . 1975 "DEU"
                 . 1976 "DEU"
                 . 1977 "DEU"
                 . 1978 "DEU"
                 . 1979 "DEU"
  31.2544326842856 1980 "DEU"
  34.8624771735362 1981 "DEU"
  37.7918339020268 1982 "DEU"
  39.3761576398246 1983 "DEU"
  40.0943358666309 1984 "DEU"
  40.6866950434749 1985 "DEU"
  40.5392916458218 1986 "DEU"
  41.5980762416802 1987 "DEU"
  42.0304267727267 1988 "DEU"
  40.6493894594412 1989 "DEU"
  42.2496575356031 1990 "DEU"
  38.8925699246766 1991 "DEU"
  41.5205279508578 1992 "DEU"
  45.1186369442772 1993 "DEU"
  47.4212670185972 1994 "DEU"
  54.8200518200202 1995 "DEU"
  57.5975435026372 1996 "DEU"
  58.7725523489012 1997 "DEU"
  59.3846092863549 1998 "DEU"
  59.9624191236295 1999 "DEU"
  58.7576542183248 2000 "DEU"
  57.5823565841686 2001 "DEU"
  59.2195682775914 2002 "DEU"
  62.9207506035819 2003 "DEU"
  64.6893799931296 2004 "DEU"
  66.9093730170458 2005 "DEU"
  66.3334795779797 2006 "DEU"
  63.5422941792037 2007 "DEU"
  64.9260658770992 2008 "DEU"
  72.4302518412538 2009 "DEU"
  81.0037751060053 2010 "DEU"
  78.3106928290272 2011 "DEU"
  79.5159992168976 2012 "DEU"
  77.0575039628623 2013 "DEU"
  74.4797242068039 2014 "DEU"
  70.9881562374292 2015 "DEU"
                 . 2016 "DEU"
                 . 2017 "DEU"
                 . 1950 "DNK"
                 . 1951 "DNK"
                 . 1952 "DNK"
                 . 1953 "DNK"
                 . 1954 "DNK"
                 . 1955 "DNK"
                 . 1956 "DNK"
                 . 1957 "DNK"
                 . 1958 "DNK"
                 . 1959 "DNK"
                 . 1960 "DNK"
                 . 1961 "DNK"
                 . 1962 "DNK"
                 . 1963 "DNK"
                 . 1964 "DNK"
                 . 1965 "DNK"
                 . 1966 "DNK"
                 . 1967 "DNK"
                 . 1968 "DNK"
                 . 1969 "DNK"
                 . 1970 "DNK"
                 . 1971 "DNK"
                 . 1972 "DNK"
                 . 1973 "DNK"
                 . 1974 "DNK"
                 . 1975 "DNK"
                 . 1976 "DNK"
                 . 1977 "DNK"
                 . 1978 "DNK"
                 . 1979 "DNK"
  27.1212025316456 1980 "DNK"
  36.5176811594203 1981 "DNK"
  47.9272040302267 1982 "DNK"
  54.1666666666667 1983 "DNK"
  63.5573451327434 1984 "DNK"
  68.3934959349593 1985 "DNK"
  66.2138138138138 1986 "DNK"
  60.5817142857143 1987 "DNK"
  57.1453551912568 1988 "DNK"
   56.583963494133 1989 "DNK"
  57.6899874843554 1990 "DNK"
  58.8394927536232 1991 "DNK"
  63.8421856639248 1992 "DNK"
  66.9946162657503 1993 "DNK"
  66.1340932642487 1994 "DNK"
  68.7221010901883 1995 "DNK"
  69.2342130065976 1996 "DNK"
54.559192354417405 1997 "DNK"
   60.279497161436 1998 "DNK"
  56.7640821218489 1999 "DNK"
  52.3543025869859 2000 "DNK"
  48.5083038892445 2001 "DNK"
  49.0809574323251 2002 "DNK"
  46.1500983816959 2003 "DNK"
  44.1787988748504 2004 "DNK"
  37.3991908162243 2005 "DNK"
  31.5408916785621 2006 "DNK"
  27.3393803355902 2007 "DNK"
  33.3859050060471 2008 "DNK"
  40.3676318314797 2009 "DNK"
  42.8785954783815 2010 "DNK"
  46.4088656946314 2011 "DNK"
   45.189325973401 2012 "DNK"
  44.6508808160045 2013 "DNK"
  44.7651169782105 2014 "DNK"
  45.5274569130736 2015 "DNK"
                 . 2016 "DNK"
                 . 2017 "DNK"
                 . 1950 "ESP"
                 . 1951 "ESP"
                 . 1952 "ESP"
                 . 1953 "ESP"
                 . 1954 "ESP"
                 . 1955 "ESP"
                 . 1956 "ESP"
                 . 1957 "ESP"
                 . 1958 "ESP"
                 . 1959 "ESP"
                 . 1960 "ESP"
                 . 1961 "ESP"
                 . 1962 "ESP"
                 . 1963 "ESP"
                 . 1964 "ESP"
                 . 1965 "ESP"
                 . 1966 "ESP"
                 . 1967 "ESP"
                 . 1968 "ESP"
                 . 1969 "ESP"
                 . 1970 "ESP"
                 . 1971 "ESP"
                 . 1972 "ESP"
                 . 1973 "ESP"
                 . 1974 "ESP"
                 . 1975 "ESP"
                 . 1976 "ESP"
                 . 1977 "ESP"
                 . 1978 "ESP"
                 . 1979 "ESP"
  17.2143562726375 1980 "ESP"
   22.192114978903 1981 "ESP"
  24.5192435542764 1982 "ESP"
  29.6263444604595 1983 "ESP"
  36.1577024698074 1984 "ESP"
   41.018504660905 1985 "ESP"
  42.2302546321995 1986 "ESP"
  42.0714797495158 1987 "ESP"
  38.6455177262744 1988 "ESP"
  40.0183820387058 1989 "ESP"
  41.4583319134769 1990 "ESP"
  42.0198982825371 1991 "ESP"
  44.2975976392867 1992 "ESP"
   54.770805992485 1993 "ESP"
  57.2316328565121 1994 "ESP"
  61.8161918538602 1995 "ESP"
  65.8556341056123 1996 "ESP"
  64.5684440852559 1997 "ESP"
  62.6231048247661 1998 "ESP"
   60.913463030346 1999 "ESP"
  57.9585677369439 2000 "ESP"
  54.1627241511419 2001 "ESP"
  51.2680500688654 2002 "ESP"
  47.6401218710795 2003 "ESP"
  45.2610734601008 2004 "ESP"
  42.2838452081851 2005 "ESP"
   38.906585586533 2006 "ESP"
  35.5103594813875 2007 "ESP"
  39.3987242509678 2008 "ESP"
  52.7045727011382 2009 "ESP"
  60.0657865156585 2010 "ESP"
  69.4619949496129 2011 "ESP"
  85.4108429414156 2012 "ESP"
  93.6746787462474 2013 "ESP"
  99.2870917054055 2014 "ESP"
  99.2599490376345 2015 "ESP"
                 . 2016 "ESP"
                 . 2017 "ESP"
                 . 1950 "FIN"
                 . 1951 "FIN"
                 . 1952 "FIN"
                 . 1953 "FIN"
                 . 1954 "FIN"
                 . 1955 "FIN"
                 . 1956 "FIN"
                 . 1957 "FIN"
                 . 1958 "FIN"
                 . 1959 "FIN"
                 . 1960 "FIN"
                 . 1961 "FIN"
                 . 1962 "FIN"
                 . 1963 "FIN"
                 . 1964 "FIN"
                 . 1965 "FIN"
                 . 1966 "FIN"
                 . 1967 "FIN"
                 . 1968 "FIN"
                 . 1969 "FIN"
                 . 1970 "FIN"
                 . 1971 "FIN"
                 . 1972 "FIN"
                 . 1973 "FIN"
                 . 1974 "FIN"
                 . 1975 "FIN"
                 . 1976 "FIN"
                 . 1977 "FIN"
                 . 1978 "FIN"
                 . 1979 "FIN"
 14.81360960101055 1980 "FIN"
  11.6987387379459 1981 "FIN"
  14.0250311159047 1982 "FIN"
  15.6021880861164 1983 "FIN"
  15.4151493168385 1984 "FIN"
  16.1063551809363 1985 "FIN"
  16.7307577635658 1986 "FIN"
  17.9620419905384 1987 "FIN"
  16.8313008225773 1988 "FIN"
  14.5467378540435 1989 "FIN"
  13.8477531529176 1990 "FIN"
  21.8778000486898 1991 "FIN"
  39.2551996475634 1992 "FIN"
  54.1082998587387 1993 "FIN"
  56.1180658136378 1994 "FIN"
  55.1473274077682 1995 "FIN"
  55.3184401332549 1996 "FIN"
   52.247647600643 1997 "FIN"
  46.8624877473376 1998 "FIN"
  44.0085721264073 1999 "FIN"
  42.4861112130397 2000 "FIN"
  40.9465718617806 2001 "FIN"
  40.1695338157247 2002 "FIN"
  42.7382908114456 2003 "FIN"
   42.647829022508 2004 "FIN"
  39.9374646413646 2005 "FIN"
  38.0594853256399 2006 "FIN"
  33.9926740807483 2007 "FIN"
  32.6537424342569 2008 "FIN"
  41.6960216356625 2009 "FIN"
  47.1191293462445 2010 "FIN"
    48.50428000692 2011 "FIN"
  52.8881847746533 2012 "FIN"
  55.4282254211328 2013 "FIN"
  59.3008954864645 2014 "FIN"
  62.5135625830499 2015 "FIN"
                 . 2016 "FIN"
                 . 2017 "FIN"
                 . 1950 "FRA"
                 . 1951 "FRA"
                 . 1952 "FRA"
                 . 1953 "FRA"
                 . 1954 "FRA"
                 . 1955 "FRA"
                 . 1956 "FRA"
                 . 1957 "FRA"
                 . 1958 "FRA"
                 . 1959 "FRA"
                 . 1960 "FRA"
                 . 1961 "FRA"
                 . 1962 "FRA"
                 . 1963 "FRA"
                 . 1964 "FRA"
                 . 1965 "FRA"
                 . 1966 "FRA"
                 . 1967 "FRA"
                 . 1968 "FRA"
                 . 1969 "FRA"
                 . 1970 "FRA"
                 . 1971 "FRA"
                 . 1972 "FRA"
                 . 1973 "FRA"
                 . 1974 "FRA"
                 . 1975 "FRA"
                 . 1976 "FRA"
                 . 1977 "FRA"
                 . 1978 "FRA"
                 . 1979 "FRA"
  20.7629558858898 1980 "FRA"
  21.9671548039471 1981 "FRA"
  25.2741720412551 1982 "FRA"
  26.5924854782971 1983 "FRA"
  28.9862016098122 1984 "FRA"
    30.58477940432 1985 "FRA"
  31.1791591164193 1986 "FRA"
   33.530000802487 1987 "FRA"
  33.4823830160827 1988 "FRA"
  34.2749803622528 1989 "FRA"
  35.4137954161381 1990 "FRA"
  36.2952916384107 1991 "FRA"
  40.0143907547318 1992 "FRA"
  46.2990376209069 1993 "FRA"
  49.6145724894529 1994 "FRA"
  55.8055849667787 1995 "FRA"
  59.6846578497955 1996 "FRA"
  61.0968817585685 1997 "FRA"
  61.0402303249395 1998 "FRA"
  60.2204722620102 1999 "FRA"
  58.6546987382372 2000 "FRA"
  58.1563598767083 2001 "FRA"
   60.078067616366 2002 "FRA"
  64.2100647474897 2003 "FRA"
  65.7368654866843 2004 "FRA"
  67.2073806785412 2005 "FRA"
   64.448349860004 2006 "FRA"
  64.4045495896015 2007 "FRA"
  68.0612270461207 2008 "FRA"
   78.998791655772 2009 "FRA"
  81.6970489086461 2010 "FRA"
  85.2092280617924 2011 "FRA"
  89.5813896879098 2012 "FRA"
  92.3954358243163 2013 "FRA"
  95.3427253916421 2014 "FRA"
  96.1411494573291 2015 "FRA"
                 . 2016 "FRA"
                 . 2017 "FRA"
                 . 1950 "GBR"
                 . 1951 "GBR"
                 . 1952 "GBR"
                 . 1953 "GBR"
                 . 1954 "GBR"
                 . 1955 "GBR"
                 . 1956 "GBR"
                 . 1957 "GBR"
                 . 1958 "GBR"
                 . 1959 "GBR"
                 . 1960 "GBR"
                 . 1961 "GBR"
                 . 1962 "GBR"
                 . 1963 "GBR"
                 . 1964 "GBR"
                 . 1965 "GBR"
                 . 1966 "GBR"
                 . 1967 "GBR"
                 . 1968 "GBR"
                 . 1969 "GBR"
                 . 1970 "GBR"
                 . 1971 "GBR"
                 . 1972 "GBR"
                 . 1973 "GBR"
                 . 1974 "GBR"
                 . 1975 "GBR"
                 . 1976 "GBR"
                 . 1977 "GBR"
                 . 1978 "GBR"
                 . 1979 "GBR"
  42.7739187085356 1980 "GBR"
  45.0873214703279 1981 "GBR"
  43.3913093624823 1982 "GBR"
  42.1844248579752 1983 "GBR"
  42.5932269923081 1984 "GBR"
  41.5364337065022 1985 "GBR"
  41.5154237699307 1986 "GBR"
  39.6151343236912 1987 "GBR"
  37.3416126108951 1988 "GBR"
  32.8084169869794 1989 "GBR"
  28.8210002262955 1990 "GBR"
  28.8008675745447 1991 "GBR"
  33.6616096861161 1992 "GBR"
  38.5309415976109 1993 "GBR"
  41.4241589385363 1994 "GBR"
  44.4455600098488 1995 "GBR"
  44.5512375405981 1996 "GBR"
  43.8667312843836 1997 "GBR"
  41.6417085242597 1998 "GBR"
  39.5527832315745 1999 "GBR"
   36.980357362589 2000 "GBR"
  34.3043526760815 2001 "GBR"
  34.2348795721152 2002 "GBR"
  35.7559948134692 2003 "GBR"
  38.6611274345262 2004 "GBR"
   40.013715541695 2005 "GBR"
  41.0167595923179 2006 "GBR"
  42.2101522643691 2007 "GBR"
  50.2670285861869 2008 "GBR"
  64.2034434624429 2009 "GBR"
  75.7370556186917 2010 "GBR"
  81.3242734330954 2011 "GBR"
   84.817533151368 2012 "GBR"
  85.9951033679148 2013 "GBR"
  87.9353408542206 2014 "GBR"
  88.9843599563534 2015 "GBR"
                 . 2016 "GBR"
                 . 2017 "GBR"
                 . 1950 "GRC"
                 . 1951 "GRC"
                 . 1952 "GRC"
                 . 1953 "GRC"
                 . 1954 "GRC"
                 . 1955 "GRC"
                 . 1956 "GRC"
                 . 1957 "GRC"
                 . 1958 "GRC"
                 . 1959 "GRC"
                 . 1960 "GRC"
                 . 1961 "GRC"
                 . 1962 "GRC"
                 . 1963 "GRC"
                 . 1964 "GRC"
                 . 1965 "GRC"
                 . 1966 "GRC"
                 . 1967 "GRC"
                 . 1968 "GRC"
                 . 1969 "GRC"
                 . 1970 "GRC"
                 . 1971 "GRC"
                 . 1972 "GRC"
                 . 1973 "GRC"
                 . 1974 "GRC"
                 . 1975 "GRC"
                 . 1976 "GRC"
                 . 1977 "GRC"
                 . 1978 "GRC"
                 . 1979 "GRC"
  22.5262225909015 1980 "GRC"
  26.6814152653896 1981 "GRC"
  29.3098874513469 1982 "GRC"
  33.5906882434887 1983 "GRC"
  40.0606007538189 1984 "GRC"
  46.6212670562757 1985 "GRC"
  47.1419595042172 1986 "GRC"
  52.4127219085322 1987 "GRC"
  57.0691157864057 1988 "GRC"
  59.8213856302527 1989 "GRC"
  73.1545328244661 1990 "GRC"
  74.6827922572712 1991 "GRC"
  79.9677107169005 1992 "GRC"
  100.288476706442 1993 "GRC"
   98.295613094589 1994 "GRC"
  98.9899424052265 1995 "GRC"
  101.335442607995 1996 "GRC"
  99.4516702698933 1997 "GRC"
  97.4246186024604 1998 "GRC"
  98.9064870804027 1999 "GRC"
  104.934618080384 2000 "GRC"
  107.081093867038 2001 "GRC"
  104.862933666134 2002 "GRC"
  101.456080042481 2003 "GRC"
  102.870181089843 2004 "GRC"
  107.392015739653 2005 "GRC"
  103.573821960691 2006 "GRC"
  103.102774017491 2007 "GRC"
  109.415678333815 2008 "GRC"
  126.744802849276 2009 "GRC"
  146.249850684198 2010 "GRC"
  172.096179762256 2011 "GRC"
  159.564653459133 2012 "GRC"
  177.677131088924 2013 "GRC"
  180.062964986286 2014 "GRC"
  176.938241025321 2015 "GRC"
                 . 2016 "GRC"
                 . 2017 "GRC"
                 . 1950 "HUN"
                 . 1951 "HUN"
                 . 1952 "HUN"
                 . 1953 "HUN"
                 . 1954 "HUN"
                 . 1955 "HUN"
                 . 1956 "HUN"
                 . 1957 "HUN"
                 . 1958 "HUN"
                 . 1959 "HUN"
                 . 1960 "HUN"
                 . 1961 "HUN"
                 . 1962 "HUN"
                 . 1963 "HUN"
                 . 1964 "HUN"
                 . 1965 "HUN"
                 . 1966 "HUN"
                 . 1967 "HUN"
                 . 1968 "HUN"
                 . 1969 "HUN"
                 . 1970 "HUN"
                 . 1971 "HUN"
                 . 1972 "HUN"
                 . 1973 "HUN"
                 . 1974 "HUN"
                 . 1975 "HUN"
                 . 1976 "HUN"
                 . 1977 "HUN"
                 . 1978 "HUN"
                 . 1979 "HUN"
          86.10145 1980 "HUN"
           85.2457 1981 "HUN"
           87.3018 1982 "HUN"
           84.9011 1983 "HUN"
           85.5903 1984 "HUN"
           96.4301 1985 "HUN"
           104.648 1986 "HUN"
           112.755 1987 "HUN"
           101.824 1988 "HUN"
           101.329 1989 "HUN"
           117.244 1990 "HUN"
           127.635 1991 "HUN"
           119.576 1992 "HUN"
 78.00896176836835 1993 "HUN"
  66.8388410857154 1994 "HUN"
  84.4562324261401 1995 "HUN"
  71.5616911105966 1996 "HUN"
  62.1159910608342 1997 "HUN"
  60.0371306922271 1998 "HUN"
  59.8793323028866 1999 "HUN"
  55.1416614896205 2000 "HUN"
  51.7425564494378 2001 "HUN"
  54.9941226424875 2002 "HUN"
  57.6020541563176 2003 "HUN"
  58.5187076448641 2004 "HUN"
  60.4862906960177 2005 "HUN"
  64.6739216440896 2006 "HUN"
   65.615688007831 2007 "HUN"
  71.6474206874259 2008 "HUN"
  77.9584861398317 2009 "HUN"
  80.5818304546166 2010 "HUN"
   80.759531248967 2011 "HUN"
  78.2944596438808 2012 "HUN"
  76.7545024522697 2013 "HUN"
  76.1790970732884 2014 "HUN"
  75.3258787954025 2015 "HUN"
                 . 2016 "HUN"
                 . 2017 "HUN"
end