Eurostat Bulk Download Facility
Continuous Integration framework
for Data Scientist (v0.2)
ibeleni (contact)
1 Retrieve data series from Eurostat
Three steps:
- Search in Eurostat’s TOC to retrieve time series codes.
- Fetch data-sets or time-series.
- Retrieve related information from dictionaries.
Methods used from library eurostat. Rpubs document with code https://rpubs.com/IbelenI/codemacrofcts.
1.1 Search
Available time series related to public debt are:
| code | title |
|---|---|
| gov_10dd_edpt1 | Government deficit/surplus, debt and associated data |
| gov_10dd_edpt3 | Transition from the deficit/surplus to the change in debt |
| gov_10dd_cgd | Central government debt |
| gov_10dd_ggd | General government debt |
| gov_10dd_slgd | State government debt |
| gov_10dd_logd | Local government debt |
| gov_10dd_ssfd | Social security funds debt |
| gov_10dd_acd | Apparent cost of general government gross debt |
| gov_10dd_mggd | Market value of general government gross debt |
| gov_10dd_rmd | Average remaining maturity of general government gross debt |
| gov_10q_ggdebt | Quarterly government debt |
| ilc_mded05 | Financial burden of the repayment of debts from hire purchases or loans - EU-SILC survey |
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.
| 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.
| 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
4 Annex
Time series considered:
| na_item | lab_na_item | sector | |
|---|---|---|---|
| 1 | B1GQ | Gross domestic product at market prices | S1 |
| 36 | B9 | Net lending (+) /net borrowing (-) | S13 |
| 71 | D41PAY | Interest, payable | S13 |
| 101 | GD | Government consolidated gross debt | S13 |
| 136 | GD_F3 | Government consolidated gross debt at face value - Debt securities | S13 |
| 171 | GD_F31 | Government consolidated gross debt at face value - Short-term debt securities | S13 |
| 206 | GD_F32 | Government consolidated gross debt at face value - Long-term debt securities | S13 |
| 241 | GD_F4 | Government consolidated gross debt at face value - Loans | S13 |
| 276 | GD_F41 | Government consolidated gross debt at face value - Short-term loans | S13 |
| 311 | GD_F42 | Government consolidated gross debt at face value - Long-term loans | S13 |
| 346 | P51G | Gross fixed capital formation | S13 |
| 376 | B9 | Net lending (+) /net borrowing (-) | S1311 |
| 406 | GD | Government consolidated gross debt | S1311 |
| 436 | B9 | Net lending (+) /net borrowing (-) | S1312 |
| 447 | GD | Government consolidated gross debt | S1312 |
| 458 | B9 | Net lending (+) /net borrowing (-) | S1313 |
| 488 | GD | Government consolidated gross debt | S1313 |
| 518 | B9 | Net lending (+) /net borrowing (-) | S1314 |
| 545 | GD | Government consolidated gross debt | S1314 |