Full Join Merge Fill-in Columns

   country iso2 year     sector UNemissions ETSemissions
1  Austria   AT 1990 1 - Energy    14025036           NA
2  Austria   AT 1991 1 - Energy    14791166           NA
3  Austria   AT 1992 1 - Energy    11581928           NA
4  Austria   AT 1993 1 - Energy    11623250           NA
5  Austria   AT 1994 1 - Energy    11915320           NA
6  Austria   AT 1995 1 - Energy    13044941           NA
7  Austria   AT 1996 1 - Energy    14048251           NA
8  Austria   AT 1997 1 - Energy    14077004           NA
9  Austria   AT 1998 1 - Energy    13106015           NA
10 Austria   AT 1999 1 - Energy    12548768           NA
11 Austria   AT 2000 1 - Energy    12263794           NA
12 Austria   AT 2001 1 - Energy    13770417           NA
13 Austria   AT 2002 1 - Energy    13380097           NA
14 Austria   AT 2003 1 - Energy    15965272           NA
15 Austria   AT 2004 1 - Energy    15899196           NA
16 Austria   AT 2005 1 - Energy    16194772     16539659
17 Austria   AT 2006 1 - Energy    15039193     15275065
18 Austria   AT 2007 1 - Energy    13757091     14124646
19 Austria   AT 2008 1 - Energy    13582007     14572511
20 Austria   AT 2009 1 - Energy    12526267     12767555
21 Austria   AT 2010 1 - Energy    13852188     15506112
22 Austria   AT 2011 1 - Energy    13666545     15131551
23 Austria   AT 2012 1 - Energy    12256272     13121434
24 Austria   AT 2013 1 - Energy    11224625      8074514
25 Austria   AT 2014 1 - Energy     9499544      6426135
26 Austria   AT 2015 1 - Energy    10623550      7514263
27 Austria   AT 2016 1 - Energy    10448926      7142937
28 Austria   AT 2017 1 - Energy          NA      7795277
29 Belgium   BE 1990 1 - Energy    29859361           NA
30 Belgium   BE 1991 1 - Energy    30491532           NA
31 Belgium   BE 1992 1 - Energy    29289874           NA
32 Belgium   BE 1993 1 - Energy    28769051           NA
33 Belgium   BE 1994 1 - Energy    29867956           NA
34 Belgium   BE 1995 1 - Energy    29386218           NA
35 Belgium   BE 1996 1 - Energy    28658131           NA
36 Belgium   BE 1997 1 - Energy    27609158           NA
37 Belgium   BE 1998 1 - Energy    30340888           NA
38 Belgium   BE 1999 1 - Energy    26555204           NA
39 Belgium   BE 2000 1 - Energy    28425731           NA
40 Belgium   BE 2001 1 - Energy    26382224           NA
41 Belgium   BE 2002 1 - Energy    27819403           NA
42 Belgium   BE 2003 1 - Energy    28954616           NA
43 Belgium   BE 2004 1 - Energy    29442710           NA
44 Belgium   BE 2005 1 - Energy    29246990     25460856
45 Belgium   BE 2006 1 - Energy    28136794     24099282
46 Belgium   BE 2007 1 - Energy    27435553     23706084
47 Belgium   BE 2008 1 - Energy    25344135     23166180
48 Belgium   BE 2009 1 - Energy    25744709     21185552
49 Belgium   BE 2010 1 - Energy    26341044     22073616
50 Belgium   BE 2011 1 - Energy    22921875     18950876
51 Belgium   BE 2012 1 - Energy    22809482     17463388
52 Belgium   BE 2013 1 - Energy    21242432     16728267
53 Belgium   BE 2014 1 - Energy    20375966     15230243
54 Belgium   BE 2015 1 - Energy    21091059     16053800
55 Belgium   BE 2016 1 - Energy    19792163     15027777
56 Belgium   BE 2017 1 - Energy          NA     15093036