1 Retrieve data series from Eurostat

Three steps:

  1. Search in Eurostat’s TOC to retrieve time series codes.
  2. Fetch data-sets or time-series.
  3. Retrieve related information from dictionaries.

Methods used from library eurostat. Rpubs document with code https://rpubs.com/IbelenI/codemacrofcts.

1.2 Fetch selected data

We decide to use the data set “Government deficit/surplus, debt and associated data” which code is “gov_10dd_edpt1”.

Table below shows the first six rows of the data set.

Government deficit/surplus, debt and associated data
unit sector na_item geo time values
MIO_EUR S1 B1GQ AT 2019 398521.9
MIO_EUR S1 B1GQ BE 2019 473638.9
MIO_EUR S1 B1GQ BG 2019 60675.3
MIO_EUR S1 B1GQ CY 2019 21943.6
MIO_EUR S1 B1GQ CZ 2019 220200.7
MIO_EUR S1 B1GQ DE 2019 3435760.0

2 Present relevant summary information.

At this point we are interested on the time window and geography that we can cover.

Therefore we want to know, per each EU country, what period is covered.

Time series with not enougth data.
code_name full_name
B5GQ Gross national income at market prices
AF_81L Trade credits and advances - liabilities
IGL_F4_EA19 Intergovernmental lending within EA19 (from 2015)
IGL_F4_EA18 Intergovernmental lending within EA18 (2014)
IGL_F4_EA17 Intergovernmental lending within EA17 (2011-2013)
IGL_F4_EU27_2020 Intergovernmental lending within EU27 (from 2020)
IGL_F4_EU28 Intergovernmental lending within EU28 (2013-2020)
IGL_F4_EU27_2007 Intergovernmental lending within EU27 (2007-2013)
IGL_F4_EU25 Intergovernmental lending within EU25 (2004-2006)
B5GQ Gross national income at market prices
GD_F2 Government consolidated gross debt at face value - Currency and deposits
AF_81L Trade credits and advances - liabilities

3 Simple plots