[]
{ if (configuration.isSticky) { fragmentElement.style.height = ‘100%’; // Set the height of the fragment element if sticky configuration is enabled } const parentRow = fragmentElement.closest(‘.row, .ecl-row’); // Find the closest parent row element const selector = buildSelector(configuration); // Build the CSS selector based on configuration const headings = Array.from(parentRow.querySelectorAll(selector)); // Get all headings within the parent row const tableOfContents = buildTableOfContents(headings); // Build the table of contents from the headings const navList = fragmentElement.querySelector(‘.estat-inpage-nav__list’); // Get the navigation list element generateList(navList, tableOfContents); // Generate the navigation list from the table of contents const topMargin = document.querySelector(‘.has-control-menu’) ? 120 : 66; // Determine the top margin based on the presence of a control menu const observeHeadings = new IntersectionObserver( (entries) => observeScrolling(entries, topMargin, headings), { rootMargin: `-${topMargin}px 0px 0px 0px` } // Set the root margin for the intersection observer ); headings.forEach(heading => observeHeadings.observe(heading)); // Observe each heading for intersection changes setupEventListeners(fragmentElement, headings); // Set up event listeners for the navigation elements document.getElementById(‘skip-inpage-navigation’).href = `#${headings[0]?.id}`; // Set the href for the skip navigation link const spinner = fragmentElement.querySelector(‘.ecl-spinner.ecl-spinner–visible’); // Get the spinner element spinner.classList.remove(‘ecl-spinner–visible’); // Hide the spinner fragmentElement.querySelector(‘.estat-inpage-nav’).classList.remove(‘ecl-u-d-none’); // Show the navigation element }); /** * Builds a CSS selector string based on the configuration object. * @param {Object} configuration – Configuration object containing heading levels and other settings. * @returns {string} – The CSS selector string. */ function buildSelector(configuration) { let selector = ”; const deepestLevel = configuration.headingLevel.slice(-1); // Get the deepest heading level from the configuration const topLevel = 2; // Define the top level heading for (let i = topLevel; i topLevel) { selector += ‘, ‘; // Add a comma separator for multiple selectors } selector += `h${i}`; // Add the heading level to the selector if (!configuration.includeNonECLHeadings) { selector += `.ecl-u-type-heading-${i}`; // Add the ECL heading class if non-ECL headings are not included } if (configuration.selectorToExclude) { selector += `:not(${configuration.selectorToExclude})`; // Exclude specific selectors if defined in the configuration } } return selector; } /** * Builds a table of contents array from the provided headings. * @param {Array} headings – Array of heading elements. * @returns {Array} – The table of contents array. */ function buildTableOfContents(headings) { let tableOfContents = []; headings.forEach((heading, i) => { if (!heading.id) { heading.id = ‘estat-inpage-nav-heading-‘ + i; // Assign a unique ID to the heading if it doesn’t have one } const objEl = { ‘id’: heading.id, ‘content’: heading.innerText, level: heading.nodeName.slice(-1) – 1, // Determine the heading level children: [] }; addHeadingToTableOfContents(objEl, tableOfContents); // Add the heading to the table of contents }); return tableOfContents; } /** * Adds a heading object to the table of contents array. * @param {Object} objEl – Heading object to add. * @param {Array} tableOfContents – The table of contents array. */ function addHeadingToTableOfContents(objEl, tableOfContents) { if (objEl.level === 1) { tableOfContents.push(objEl); // Add level 1 headings directly to the table of contents } else if (objEl.level === 2) { tableOfContents[tableOfContents.length – 1].children.push(objEl); // Add level 2 headings as children of the last level 1 heading } else if (objEl.level === 3) { const childrenArr = tableOfContents[tableOfContents.length – 1].children; childrenArr[childrenArr.length – 1].children.push(objEl); // Add level 3 headings as children of the last level 2 heading } } /** * Generates a nested list of navigation links from the table of contents array. * @param {HTMLElement} ulElement – The unordered list element to populate. * @param {Array} headingArray – Array of heading objects. */ function generateList(ulElement, headingArray) { headingArray.forEach((heading, i) => { const li = document.createElement(‘li’); li.className = ‘estat-inpage-nav__list-item’; ulElement.appendChild(li); const link = `${heading.content}` if (heading.children.length > 0) { const containerDiv = document.createElement(‘div’) const button = `
Printing can have negative environmental impacts due to paper waste. We encourage you to explore eco-friendly alternatives. Bookmarking this page in your browser allows you to access it anytime.
This publication can also be converted to PDF, if you have a PDF printer installed on your computer. PDF printers function as virtual printers, enabling you to create digital copies of web pages and access the content offline.
{ const buttonPrintPage = document.getElementById(‘estat-print-page-modal-toggle’); const cookieSkipModal = ‘skipModalBeforePrinting’; if (configuration.displayInPageHeader) { const headerElement = document.querySelector(‘.ecl-page-header .ecl-page-header__meta’) || document.querySelector(‘.ecl-page-header .ecl-page-header__title-container ‘) if (headerElement) { headerElement.prepend(buttonPrintPage); headerElement.classList.add(‘ecl-u-width-100’) } } buttonPrintPage.addEventListener(‘click’, () => { const skipModal = readCookie(cookieSkipModal); if (skipModal == ‘true’) { window.print(); } else { const eclModalElement = document.getElementById(‘estat-print-page-modal’); const eclModal = ECL.components.get(eclModalElement); eclModal.openModal(); } }); document.getElementById(‘print-submit’).addEventListener(‘click’, () => { const skipModal = document.getElementById(‘checkbox-skip-modal’).checked if (skipModal) { writeCookieWithMaxAgeValue(cookieSkipModal, ‘true’, 15768000); } else { deleteCookie(cookieSkipModal); } window.print(); }); });;}());]]>
81.0% of GDP in EU
Overview
At the end of the fourth quarter of 2024, the general government gross debt to GDP ratio in the euro area (EA20) stood at 87.4%, compared with 88.1% at the end of the third quarter of 2024. In the EU, the ratio also decreased from 81.6% to 81.0%.
Compared with the fourth quarter of 2023, the government debt to GDP ratio slightly increased in both the euro area (from 87.3% to 87.4%) and the EU (from 80.8% to 81.0%).
At the end of the fourth quarter of 2024, the general governmentdebt was made up of 84.0% debt securities in the euro area and 83.4% in the EU, 13.5% loans in the euro area and 14.1% in the EU and 2.5% currency and deposits in the euro area and 2.4% in the EU.
Due to the involvement of EU Member States’ governments in lending to certain Member States, quarterly data on intergovernmental lending (IGL) are also published. The IGL as percentage of GDP at the end of the fourth quarter of 2024 stood at 1.4% in the euro area and at 1.2% in the EU.
These data are released by Eurostat, the statistical office of the European Union.
|
Euro area and EU general government gross debt |
||||
|---|---|---|---|---|
|
2023Q4 |
2024Q3 |
2024Q4 |
||
|
Euro area |
||||
|
(million euro) |
12 753 756 |
13 229 645 |
13 258 117 |
|
|
(% of GDP) |
87.3 |
88.1 |
87.4 |
|
|
(million euro) |
351 660 |
337 144 |
327 793 |
|
|
(% of total debt) |
2.8 |
2.5 |
2.5 |
|
|
(million euro) |
10 623 666 |
11 118 508 |
11 138 996 |
|
|
(% of total debt) |
83.3 |
84.0 |
84.0 |
|
|
(million euro) |
1 778 430 |
1 773 993 |
1 791 329 |
|
|
(% of total debt) |
13.9 |
13.4 |
13.5 |
|
|
(million euro) |
225 388 |
224 314 |
217 391 |
|
|
(% of GDP) |
1.5 |
1.5 |
1.4 |
|
|
EU |
|
|
|
|
|
(million euro) |
13 901 073 |
14 481 033 |
14 543 529 |
|
|
(% of GDP) |
80.8 |
81.6 |
81.0 |
|
|
(million euro) |
375 185 |
363 901 |
354 010 |
|
|
(% of total debt) |
2.7 |
2.5 |
2.4 |
|
|
(million euro) |
11 516 711 |
12 104 395 |
12 135 398 |
|
|
(% of total debt) |
82.8 |
83.6 |
83.4 |
|
|
(million euro) |
2 009 177 |
2 012 738 |
2 054 121 |
|
|
(% of total debt) |
14.5 |
13.9 |
14.1 |
|
|
(million euro) |
225 388 |
224 314 |
217 391 |
|
|
(% of GDP) |
1.3 |
1.3 |
1.2 |
Government debt at the end of the fourth quarter of 2024 by Member State
The highest ratios of government debt to GDP at the end of the fourth quarter of 2024 were recorded in Greece (153.6%), Italy (135.3%), France (113.0%), Belgium (104.7%) and Spain (101.8%), and the lowest were recorded in Estonia (23.6%), Bulgaria (24.1%) and Luxembourg (26.3%).
Compared with the third quarter of 2024, eight Member States registered an increase in their debt to GDP ratio at the end of the fourth quarter of 2024, eighteen registered a decrease, and the ratio remained stable in Finland. The largest increases in the ratio were observed in Poland (+2.0 percentage points – pp), Romania and Sweden (both +1.6 pp), Malta (+1.5 pp), and the Netherlands (+1.2 pp). The largest decreases were recorded in Greece (-4.7 pp), Cyprus (-4.1 pp), Spain (-2.5 pp), Denmark (-2.3 pp), Portugal (-2.2 pp), Hungary (-2.1 pp) and Croatia (-2.0 pp).
Compared with the fourth quarter of 2023, sixteen Member States registered an increase in their debt to GDP ratio at the end of the fourth quarter of 2024, eleven Member States registered a decrease. The largest increases in the ratio were recorded in Romania (+5.9 pp), Poland (+5.7 pp), Finland (+4.5 pp), Slovakia (+3.6 pp), Estonia (+3.4 pp), Austria (+3.3 pp), and France (+3.2 pp). The largest decreases were observed in Greece (-10.3 pp), Cyprus (-8.6 pp), Croatia (-4.3 pp), Spain (-3.3 pp), Portugal (-2.8 pp), Denmark (-2.5 pp), and Ireland (-2.4 pp).
Tables
|
General government gross debt by Member State |
|||||||||
|---|---|---|---|---|---|---|---|---|---|
|
General government gross debt |
|||||||||
|
Millions of national currency |
% of GDP |
Difference in pp of GDP 2024Q4 compared with: |
|||||||
|
2023Q4 |
2024Q3 |
2024Q4 |
2023Q4 |
2024Q3 |
2024Q4 |
2023Q4 |
2024Q3 |
||
|
EUR |
12 753 756 |
13 229 645 |
13 258 117 |
87.3 |
88.1 |
87.4 |
0.1 |
-0.7 |
|
|
EUR |
13 901 073 |
14 481 033 |
14 543 529 |
80.8 |
81.6 |
81.0 |
0.2 |
-0.6 |
|
|
EUR |
615 573 |
642 689 |
642 875 |
103.2 |
105.7 |
104.7 |
1.5 |
-0.9 |
|
|
BGN |
42 393 |
48 736 |
48 846 |
22.9 |
24.6 |
24.1 |
1.2 |
-0.5 |
|
|
CZK |
3 234 077 |
3 449 352 |
3 491 908 |
42.5 |
43.7 |
43.6 |
1.1 |
-0.1 |
|
|
DKK |
942 073 |
961 615 |
920 586 |
33.6 |
33.4 |
31.1 |
-2.5 |
-2.3 |
|
|
EUR |
2 632 103 |
2 672 337 |
2 688 879 |
62.9 |
62.4 |
62.5 |
-0.4 |
0.1 |
|
|
EUR |
7 708 |
9 356 |
9 327 |
20.2 |
24.0 |
23.6 |
3.4 |
-0.4 |
|
|
EUR |
220 721 |
218 070 |
218 178 |
43.3 |
42.3 |
40.9 |
-2.4 |
-1.4 |
|
|
EUR |
369 110 |
370 824 |
364 885 |
163.9 |
158.3 |
153.6 |
-10.3 |
-4.7 |
|
|
EUR |
1 575 378 |
1 635 732 |
1 620 602 |
105.1 |
104.4 |
101.8 |
-3.3 |
-2.5 |
|
|
EUR |
3 102 542 |
3 301 444 |
3 305 287 |
109.8 |
113.6 |
113.0 |
3.2 |
-0.6 |
|
|
EUR |
48 262 |
49 966 |
49 283 |
61.8 |
59.6 |
57.6 |
-4.3 |
-2.0 |
|
|
EUR |
2 869 648 |
2 962 625 |
2 966 597 |
134.6 |
136.2 |
135.3 |
0.7 |
-0.9 |
|
|
EUR |
23 081 |
22 901 |
21 828 |
73.6 |
69.2 |
65.0 |
-8.6 |
-4.1 |
|
|
EUR |
17 579 |
18 853 |
18 800 |
44.6 |
47.2 |
46.8 |
2.1 |
-0.5 |
|
|
EUR |
27 558 |
29 513 |
29 972 |
37.3 |
38.4 |
38.2 |
0.9 |
-0.1 |
|
|
EUR |
20 268 |
21 795 |
22 654 |
25.0 |
25.8 |
26.3 |
1.3 |
0.5 |
|
|
HUF |
55 139 767 |
60 608 244 |
59 875 234 |
73.0 |
75.6 |
73.5 |
0.5 |
-2.1 |
|
|
EUR |
9 831 |
10 170 |
10 648 |
47.9 |
45.9 |
47.4 |
-0.5 |
1.5 |
|
|
EUR |
482 228 |
470 240 |
491 585 |
45.2 |
42.2 |
43.3 |
-1.8 |
1.2 |
|
|
EUR |
371 520 |
398 349 |
394 131 |
78.5 |
83.2 |
81.8 |
3.3 |
-1.4 |
|
|
PLN |
1 691 243 |
1 897 166 |
2 011 840 |
49.5 |
53.2 |
55.3 |
5.7 |
2.0 |
|
|
EUR |
261 849 |
272 221 |
270 723 |
97.7 |
97.1 |
94.9 |
-2.8 |
-2.2 |
|
|
RON |
784 235 |
916 404 |
963 941 |
48.9 |
53.2 |
54.8 |
5.9 |
1.6 |
|
|
EUR |
43 739 |
44 245 |
44 895 |
68.4 |
66.7 |
67.0 |
-1.4 |
0.3 |
|
|
EUR |
68 896 |
77 439 |
77 648 |
55.6 |
59.8 |
59.3 |
3.6 |
-0.6 |
|
|
EUR |
211 539 |
225 175 |
226 701 |
77.5 |
82.0 |
82.1 |
4.5 |
0.0 |
|
|
SEK |
1 964 555 |
2 036 868 |
2 158 987 |
31.6 |
31.9 |
33.5 |
1.9 |
1.6 |
|
|
NOK |
2 270 665 |
2 194 602 |
2 863 030 |
44.5 |
42.4 |
55.1 |
10.6 |
12.6 |
|
General government gross debt by Member State |
|||||
|---|---|---|---|---|---|
|
Components of government debt, in % of GDP |
IGL (assets) |
||||
|
Currency and deposits |
Debt Securities |
Loans |
% of GDP |
||
|
2024Q4 |
2024Q4 |
2024Q4 |
2024Q4 |
||
|
EUR |
2.2 |
73.5 |
11.8 |
1.4 |
|
|
EUR |
2.0 |
67.6 |
11.4 |
1.2 |
|
|
EUR |
0.3 |
90.0 |
14.4 |
1.3 |
|
|
BGN |
– |
20.7 |
3.4 |
0.0 |
|
|
CZK |
0.6 |
39.4 |
3.6 |
0.0 |
|
|
DKK |
0.6 |
28.0 |
2.4 |
0.0 |
|
|
EUR |
0.3 |
49.5 |
12.6 |
1.5 |
|
|
EUR |
0.1 |
13.3 |
10.2 |
1.2 |
|
|
EUR |
4.8 |
27.2 |
9.0 |
0.0 |
|
|
EUR |
3.2 |
39.9 |
110.5 |
0.0 |
|
|
EUR |
0.3 |
91.2 |
10.2 |
1.7 |
|
|
EUR |
1.4 |
101.0 |
10.6 |
1.6 |
|
|
EUR |
0.1 |
41.5 |
16.0 |
0.0 |
|
|
EUR |
8.1 |
113.4 |
13.7 |
1.9 |
|
|
EUR |
0.5 |
38.1 |
26.4 |
1.0 |
|
|
EUR |
1.5 |
41.0 |
4.3 |
0.0 |
|
|
EUR |
0.1 |
30.9 |
7.2 |
0.0 |
|
|
EUR |
0.4 |
22.3 |
3.6 |
0.7 |
|
|
HUF |
0.7 |
63.7 |
9.1 |
0.0 |
|
|
EUR |
1.9 |
41.0 |
4.5 |
0.9 |
|
|
EUR |
0.1 |
36.8 |
6.4 |
1.2 |
|
|
EUR |
0.4 |
72.5 |
8.9 |
1.3 |
|
|
PLN |
0.4 |
40.4 |
14.4 |
0.0 |
|
|
EUR |
16.5 |
54.2 |
24.3 |
0.2 |
|
|
RON |
1.1 |
44.6 |
9.0 |
0.0 |
|
|
EUR |
0.3 |
58.2 |
8.5 |
1.6 |
|
|
EUR |
0.1 |
52.6 |
6.6 |
1.5 |
|
|
EUR |
0.3 |
61.7 |
20.2 |
1.5 |
|
|
SEK |
2.3 |
19.5 |
11.7 |
0.0 |
|
|
NOK |
– |
16.0 |
39.0 |
– |
Notes for users
Methods and definitions
Quarterly data on government debt are collected from the Member States according to European System of Accounts (ESA 2010), see Annex B, ESA 2010 transmission programme, and refer to the Maastricht debt definition, used in the context of the Excessive Deficit Procedure (EDP). Annual EDP data, last notified in April 2025, are the subject of a thorough verification by Eurostat.
The general government gross debt is defined as the consolidated gross debt of the whole general government sector outstanding at the end of the quarter (at face value). General government debt consists of liabilities of general government in the following financial instruments: currency and deposits (AF.2), debt securities (AF.3) and loans (AF.4), as defined in ESA 2010.
The debt to GDP ratio is calculated for each quarter using the sum of quarterly GDP for the four last quarters. Quarterly data on GDP are the most recent ones transmitted by the EU Member States. While quarterly debt figures are consistent with annual debt figures at coinciding publications, differences between quarterly and annual data occur at non-coinciding publications. Differences between annual and quarterly GDP figures also occur. For this release, the quarterly GDP for the EU and euro area aggregates and France, Poland and Slovakia have been adjusted to the annual GDP transmitted in the context of the Excessive Deficit Procedure.
For the purpose of proper consolidation of general government debt and to provide users with information, Eurostat publishes data on government loans (IGL) to other EU governments. The concepts and definitions are based on ESA 2010 and on the rules relating to the statistics for the EDP. The data covered is the stock of loans related to claims on other EU Member States, including loans made through the European Financial Stability Facility (EFSF). The valuation basis is the stock of loans at face value outstanding at end of each quarter. From the first quarter of 2011 onwards, the intergovernmental lending figures relate mainly to lending to Greece, Ireland and Portugal and include loans made by the EFSF.
For stock data such as general government debt, end of period exchange rates are used in the compilation of the EU aggregates. For flow data, such as GDP, average exchange rates are used. The EU aggregates, denominated in euro, can fluctuate as a result of exchange rate movements between the euro and other EU currencies.
Geographical Information
Euro area (EA20): Belgium, Germany, Estonia, Ireland, Greece, Spain, France, Croatia, Italy, Cyprus, Latvia, Lithuania, Luxembourg, Malta, the Netherlands, Austria, Portugal, Slovenia, Slovakia and Finland.
European Union (EU27): Belgium, Bulgaria, Czechia, Denmark, Germany, Estonia, Ireland, Greece, Spain, France, Croatia, Italy, Cyprus, Latvia, Lithuania, Luxembourg, Hungary, Malta, the Netherlands, Austria, Poland, Portugal, Romania, Slovenia, Slovakia, Finland and Sweden.
For more information
Share the release
Share component will be rendered here.
* Here the title * … *
… * * Here the logo and notes * */ function tableConfiguration() { /** Retrieves the list of table elements (images) */ const tables = document.getElementsByTagName(‘table’); /** We go through the list of tables */ for (let table of tables) { /** We create a section to wrap the table */ let section = document.createElement(‘section’); /** Add table-wrapper class to section element */ section.classList.add(‘table-wrapper’); /** We create a caption element to place the title */ let caption = document.createElement(‘caption’); /** We create thead element to place the headers */ let tHead = document.createElement(‘thead’); /** We create a footer to place notes, datasource and logo */ let footer = document.createElement(‘footer’); /** Retrieves the tBody */ let tBody = table.tBodies[0]; /** Retrieves the table rows */ let rows = tBody.rows; let datalabels = []; let captionContent = []; /** Stores the indexes of the rows to be removed after processing the whole table */ let rowsToRemove = []; /** We go through the rows within the table and extract caption, headers and footnotes */ buildTable(rows, captionContent, datalabels, footer, rowsToRemove); deleteRows(table, rowsToRemove); addTableCaption(caption, captionContent); addTableHeaders(table, tHead, datalabels); wrapInSection(section, table, caption, tHead, tBody, footer); linkHeaders(table); } } /** * Builds a table with the expected format: adding caption, datalabels and footer * @param {*} rows – The table rows * @param {*} captionContent – The content of the caption (title) * @param {*} datalabels – The list of datalabels (table headers) * @param {*} footer – The footer element * @param {*} rowsToRemove – Array containing the index of the rows to be removed */ function buildTable(rows, captionContent, datalabels, footer, rowsToRemove) { let rowIndex = 0; for (let row of rows) { let cells = row.cells; /** We check the first cell in order to guess the cell type: th, td; and cell classes: title, datalabel… */ let firstCell = row.firstElementChild; /** If the th class name is title, we convert this th into a caption */ if (isCaption(firstCell)) { addCaption(cells, captionContent, rowIndex, rowsToRemove) } /** If the th class name is datalabel, we add the header to the tHead component */ else if (isDatalabel(firstCell)) { addDatalabels(row, datalabels, rowIndex, rowsToRemove); } /** If the th class name is title, we convert this th into a caption */ else if (isFooter(firstCell)) { addFooter(row, footer, rowIndex, rowsToRemove); } else { row.setAttribute(‘initial-position’, rowIndex); } rowIndex++; } } /** * Checks whether the given cell has the given tagName and className * @param {*} cell – The cell to be checked * @param {*} tagName – The tag name to be checked * @param {*} className – The class name to be checked * @returns true if the cell’s tagName and className matches the given ones, false otherwise */ function checkCell(cell, tagName, className) { return cell.tagName.toLowerCase() === tagName && cell.className.indexOf(className) > -1; } /** * Whether a cell is a caption (title) * @param {*} cell – The cell to be checked * @returns true if the cell is a caption, false otherwise */ function isCaption(cell) { return checkCell(cell, ‘th’, ‘title’); } /** * Whether a cell is a datalabel * @param {*} cell – The cell to be checked * @returns true if the cell is a datalabel, false otherwise */ function isDatalabel(cell) { return checkCell(cell, ‘th’, ‘datalabel’); } /** * Whether a cell is a vertical header * @param {*} cell – The cell to be checked * @returns true if the cell is a vertical header, false otherwise */ function isVerticalHeader(cell) { return checkCell(cell, ‘th’, ‘vertical-header’); } /** * Whether a cell is a footer * @param {*} cell – The cell to be checked * @returns true if the cell is a footer, false otherwise */ function isFooter(cell) { return checkCell(cell, ‘td’, ‘footer’); } /** * Adds the content of the caption cells: paragraphs * @param {*} cells – The cells belonging to the row * @param {*} captionContent – The content of the caption * @param {*} rowIndex – The index of current row * @param {*} rowsToRemove – Array containing the index of the rows to be removed */ function addCaption(cells, captionContent, rowIndex, rowsToRemove) { for (let cell of cells) { /** We must add all the Child Nodes of each th title Cell */ for (let childNode of cell.childNodes) { captionContent.push(childNode); } } /** We remove the row from within the tables as now it’s out in the caption */ rowsToRemove.push(rowIndex); } /** * Adds the row as a datalabel * @param {*} row – The current row * @param {*} datalabels – List of datalabels * @param {*} rowIndex – The index of current row * @param {*} rowsToRemove – Array containing the index of the rows to be removed */ function addDatalabels(row, datalabels, rowIndex, rowsToRemove) { datalabels.push(row); /** We remove the row from within the tables as now it’s out in the caption */ rowsToRemove.push(rowIndex); } /** * Adds the notes and logo * @param {*} row – The current row * @param {*} footer – The footer of the table * @param {*} rowIndex – The index of current row * @param {*} rowsToRemove – Array containing the index of the rows to be removed */ function addFooter(row, footer, rowIndex, rowsToRemove) { /** We create a div element for notes and logo */ const notes = document.createElement(‘div’); notes.classList.add(‘footer-element’, ‘notes’); /** We add the content to the new note element */ notes.innerHTML = row.firstElementChild.innerHTML; /** We create a footer to place notes, datasource and logo */ footer.appendChild(notes); /** We remove the row from within the tables as now it’s out in the footer */ rowsToRemove.push(rowIndex); } /** * Deletes the rows which data has been moved to either caption, tHead or footer * @param {*} table – The current table * @param {*} rowsToRemove – Array containing the index of the rows to be removed */ function deleteRows(table, rowsToRemove) { /** We go through the title rows and append them to the caption element */ for (let j = rowsToRemove.length – 1; j >= 0; j–) { table.deleteRow(rowsToRemove[j]); } } /** * Adds the caption to the table. * @param {*} caption – The caption dom element * @param {*} captionContent – The content of the caption */ function addTableCaption(caption, captionContent) { /** We go through the Caption Content and append the nodes to the caption element */ for (let node of captionContent) { caption.appendChild(node); } } /** * Adds the headers to the table * @param {*} table – The table to make sortable * @param {*} tHead – The thead dom element * @param {*} datalabels – The datalabels to be added (headers) */ function addTableHeaders(table, tHead, dataLabels) { let sortable = false; /** We go through the header rows and append them to the tHead element */ for (let dataLabelRow of dataLabels) { let cells = dataLabelRow.cells; for (let th of cells) { if (th.classList.contains(‘sortable’)) { sortable = true; let button = createNewSortButton(); th.appendChild(button); } } tHead.appendChild(dataLabelRow); } if (sortable) { table.classList.add(‘sortable’); } } function createNewSortButton() { // creates sort button const button = document.createElement(‘button’); button.classList.add(‘ecl-table__arrow’); // creates a generic svg element for the two arrows const svgIconUp = document.createElementNS(‘http://www.w3.org/2000/svg’, ‘svg’); svgIconUp.setAttribute(‘xml:space’, ‘preserve’); svgIconUp.setAttribute(‘viewBox’, ‘0 0 24 24’); svgIconUp.setAttribute(‘enable-background’, ‘new 0 0 24 24’); svgIconUp.setAttribute(‘focusable’, ‘false’); svgIconUp.setAttribute(‘aria-hidden’, ‘true’); svgIconUp.setAttribute(‘class’, ‘ecl-table__icon ecl-icon ecl-icon–m’); // adds path element of the arrow to the arrow svg const pathIconArrow = document.createElementNS(‘http://www.w3.org/2000/svg’, ‘path’); pathIconArrow.setAttribute(‘d’, ‘M7.4 13 11 9.4c.5-.5 1.4-.5 2 0l3.6 3.6c.9.9.2 2.4-1 2.4H8.4c-1.3 0-1.9-1.5-1-2.4’); svgIconUp.appendChild(pathIconArrow); // clones the generic arrow svg including the child path also const svgIconDown = svgIconUp.cloneNode(true); // seups the arrow directions to up and down by extra css classes svgIconUp.classList.add(‘ecl-table__icon-up’); svgIconDown.classList.add(‘ecl-table__icon-down’); // insert the two arrow svg elements into the button button.appendChild(svgIconUp); button.appendChild(svgIconDown); return button; } /** * Places all the elements in their places and wraps the table into a section. * @param {*} section – The section (dom element) which will wrap table and footer * @param {*} table – The table to be wrapped * @param {*} caption – The caption (dom element) to be added to the table * @param {*} tHead – The thead (dom element) to be added to the table * @param {*} tBody – The tbody (dom element) to be added to the table * @param {*} footer – The footer (dom element) to be added to the section */ function wrapInSection(section, table, caption, tHead, tBody, footer) { /** We insert caption and thead before tbody */ table.insertBefore(caption, tBody); table.insertBefore(tHead, tBody); /** We wrap the table into a section */ table.parentNode.insertBefore(section, table); section.appendChild(table); section.appendChild(footer); } /** * Adds ids and header attributes to link every cell to all related headers so that machines can correctly read the figures. * @param {*} table – The table to be wrapped */ function linkHeaders(table) { const headers = getHeaders(table.tHead); const tBody = table.tBodies ? table.tBodies[0] : null; addHeaderLinks(tBody, headers); } function getHeaders(tHead) { const headers = []; if (tHead) { let i = 0; for (let row of tHead.rows) { /** We add a new row in the headers array */ headers.push([]); /** Stores the header ids and colSpan so we can guess to which cells (td) we must add the headers */ let j = 0; for (const cell of row.cells) { cell.setAttribute(‘id’, ‘h_’ + i + ‘_’ + j); headers[i].push({ id: cell.id, colSpan: cell.colSpan ? cell.colSpan : 1 }); j++; } i++; } } return headers; } function addHeaderLinks(tBody, headers) { if (tBody) { let i = 0; for (let row of tBody.rows) { let j = 0; for (const cell of row.cells) { /** If the cell is a vertical header we add its id */ if (cell.className.indexOf(‘vertical-header’) > -1) { cell.setAttribute(‘id’, ‘vh_’ + i + ‘_’ + j); } const headerLinks = getHeaderLinks(headers, j, cell.colSpan, row.cells[0]); cell.setAttribute(‘headers’, headerLinks); j++; } i++; } } } /** * Retrieves the header (ths) ids in order to link them to a specific cell (td) * @param {*} rows – The rows containing all headers * @param {*} index – The index of the specific cell * @param {*} colSpan – The colspan of the specific cell * @param {*} firstCell – The first cell of the row. Used to reference possible vertical headers * @returns A string containing the list of header ids split by spaces */ function getHeaderLinks(rows, index, colSpan, firstCell) { /** It will contain the header ids */ let links = ”; /** We add the reference of the vertical header if there is */ if (index > 0 && firstCell.className.indexOf(‘vertical-header’) > -1) { links = firstCell.id; } /** We go through the list of header rows */ for (const headers of rows) { /** Accumulates the colspan of the checked headers */ let sumColSpan = 0; /** We go through the list of headers for the specific header row */ for (const header of headers) { /** We check that the index of the cell belongs to a specific column */ if (index >= sumColSpan && index chartObj.resize()).observe(chartDiv); } } /** * Customizes the chart by applying custom events, axis formats, tooltips, and axis labels. * @param option – The chart options object. */ function customChartOptions(option) { setClickableDatasourceLinks(option); setAxisFormatter(option); setTooltipFormatter(option); } /** * Attaches event handlers to a chart: ‘legendselectchanged’. * * @param {Chart} chart – The chart object. */ function addEventHandlers(chart) { /** Attach an event handler for the ‘legendselectchanged’ event */ chart.on(‘legendselectchanged’, (event) => { /** Call the onChartLegendSelected function with the event and chart object */ onChartLegendSelected(event, chart); }); } /** * Handles the legend selected changed event of the chart. * @param {any} event – The event object containing the selected legend items. * @param {any} chart – The chart object. */ function onChartLegendSelected(event, chart) { /** Get the selected legend items */ const selected = event.selected; /** Count the number of selected legend items */ const selectedCount = Object.values(selected).filter(Boolean).length; /** If all legend items are deselected, keep the selection on the last clicked item */ if (selectedCount === 0) { selected[event.name] = true; } /** Update the legend selection */ chart.setOption({ legend: { selected: selected } }); } /** * Attaches custom events to the provided option object. * * @param {object} option – The option object to attach custom events to. */ function setClickableDatasourceLinks(option) { /** If the table has datasource link */ if (option.graphic && option.graphic.length >= 3) { /** Attach an onclick event handler to the third element of the graphic array (datasource links) */ option.graphic[2].onclick = function (event) { /** If the element has a link defined in its style */ if (this.style?.link) { /** Open the link in a new tab/window */ window.open(this.style.link, ‘_blank’); } }; } } /** * Sets the default axis formatter for axis labels. * @param {object} option – The option object to update the axis formatter * */ function setAxisFormatter(option) { /** The default unit used in axis labels */ const defaultUnit = ‘%’; /** If the yAxis are used as values */ if (option.yAxis.type === ‘value’) { /** If the yAxis unit is not defined, set % as default */ option.yAxis.axisLabel.unit = option.yAxis.axisLabel.unit ? option.yAxis.axisLabel.unit : defaultUnit; /** If the yAxis label padding is not defined, set 15 as default suffix */ option.yAxis.axisLabel.padding = option.yAxis?.axisLabel?.padding ? option.yAxis.axisLabel.padding : 15; /** Use the custom formatter */ option.yAxis.axisLabel.formatter = (value) => customAxisFormatter(option.lang, value, option.yAxis.axisLabel.unit, parseInt(option.yAxis.axisLabel.decimals)); // Use the custom formatter } /** If the xAxis are used as values */ if (option.xAxis.type === ‘value’) { /** If the xAxis unit is not defined, set % as default */ option.xAxis.axisLabel.unit = option.xAxis.axisLabel.unit ? option.xAxis.axisLabel.unit : defaultUnit; /** Use the custom formatter */ option.xAxis.axisLabel.formatter = (value) => customAxisFormatter(option.lang, value, option.xAxis.axisLabel.unit, parseInt(option.xAxis.axisLabel.decimals)); } /** If xAxis type is category */ else if (option.xAxis.type === ‘category’) { boldCountries(option); } } /** * Formats a numeric value with a specified unit and decimal precision. * * @param {number} value – The numeric value to be formatted. * @param {string} unit – The unit to be appended to the formatted value. * @param {number} decimals – The number of decimal places to round the value to. * @returns {string} The formatted string representation of the value with unit. */ function customAxisFormatter(lang, value, unit, decimals) { /** * Check the language and format the value accordingly. * For French (fr) and German (de), use commas instead of dots. * For other languages (en), use the default format with dots. */ const formattedValue = lang === ‘fr’ || lang === ‘de’ ? `${value.toFixed(decimals).replace(‘.’, ‘,’)}${unit}` : `${value.toFixed(decimals)}${unit}`; return formattedValue; } /** * Enriches the x-axis labels with formatting based on certain values. * If EU and Euro Area are included, those must be written in bold * @remarks * This function enriches the x-axis labels with formatting based on certain values, such as making “EU” and “Euro Area” bold. * @param {object} option – The option object to set bold countries to. */ function boldCountries(option) { option.xAxis.axisLabel.formatter = function (v) { /** Convert input string to lowercase for case-insensitive comparison */ const lowerCaseV = v ? v.toLowerCase() : ”; /** Check for specific label values and format them accordingly, check for “EU” or “UE” */ if (lowerCaseV === “eu” || lowerCaseV === “ue”) { // return `{eu|${v}}`; } /** Check for “Euro Area”, “Euroraum”, or “Zone Euro” */ else if (lowerCaseV === “euro area” || lowerCaseV === “euroraum” || lowerCaseV === “zone euro”) { return `{euroArea|${v}}`; } return v; }; /** Set the rich property of the axis label to apply the bold formatting */ option.xAxis.axisLabel.rich = { eu: { fontWeight: “bold”, }, euroArea: { fontWeight: “bold” } }; } /** * Handles formatting the tooltip decimal convention in the graphic. * @remarks * This function formats the tooltip based on the language and decimal convention. * * @param {object} option – The option object to add custom tooltip. */ function setTooltipFormatter(option) { /** * Tooltip formatter for ECharts. * @param {object[]} params – Parameters for the tooltip formatter. * @param {string} params[].name – Name of the x-axis value. * @param {string} params[].seriesName – Name of the series. * @param {number} params[].value – Value of the data point. * @param {string} params[].color – Color of the series. * @param {string} ticket – Ticket for the callback. * @param {Function} callback – Callback function. * @returns {string} – Formatted tooltip content. */ option.tooltip.formatter = function (params, ticket, callback) { /** Retrieve the x-axis value for the tooltip */ const xAxisValue = params[0].name; /** If xAxisValue is empty, return null to hide the tooltip */ if (!xAxisValue) { return null; } /** Create the tooltip content container with a white background and padding */ let tooltipContent = ”; /** Add the x-axis value to the tooltip content */ /** @type {string} XAxis */ tooltipContent += ” + xAxisValue + ‘]]>‘; /** Retrieve the order from the tooltip option */ const sortOrder = option.tooltip.order; /** Sort the ‘params’ array based on the ‘sortOrder’ parameter. */ switch (sortOrder) { /** Sort by series name in ascending order. */ case ‘seriesAsc’: params = params.sort((a, b) => a.seriesName.localeCompare(b.seriesName)); break; /** Sort by series name in descending order. */ case ‘seriesDesc’: params = params.sort((a, b) => b.seriesName.localeCompare(a.seriesName)); break; /** Sort by numerical value in ascending order. */ case ‘valueAsc’: params = params.sort((a, b) => parseFloat(a.value) – parseFloat(b.value)); break; /** Sort by numerical value in descending order. */ case ‘valueDesc’: params = params.sort((a, b) => parseFloat(b.value) – parseFloat(a.value)); break; /** Reverse the current order. */ case ‘reverse’: params.reverse(); break; default: break; } /** Iterate over each series in the tooltip parameters */ for (const param of params) { /** Retrieve the name and value of the current series */ let seriesName = param.seriesName; let value = param.value; /** Replace every specific apostrphe by simple one. */ seriesName = seriesName.replaceAll(“’”, “‘”); /** Convert the numeric value to its string representation. */ const strValue = String(value); /** Retrieve the axis used as value */ const axis = option.yAxis.type === ‘value’ ? option.yAxis : option.xAxis; /** Initialize the number of decimal places */ let decimals = option.tooltip.decimals; /** Check if decimals configuration is set to default and the value contains decimal places */ if (!decimals && strValue.indexOf(‘.’) > -1) { /** Calculate the number of decimal places */ decimals = strValue.substring(strValue.indexOf(‘.’), strValue.length – 1).length; } else { /** If there are no decimal places, format the value with 1 decimal place */ decimals = decimals || 1; /** Convert the value to a fixed-point notation string with a specified number of decimal places. */ value = Number(value).toFixed(decimals); } /** Convert -0 value to 0 with the specified or calculated number of decimal places.*/ if (Number(value) == -0) { value = (Number(value) + 0).toFixed(decimals); } /** Extract the unit from within the axis label */ const unit = axis.axisLabel.unit ? axis.axisLabel.unit : ”; /** Format the value using the appropriate number of decimal places */ if (isNaN(value)) { value = ‘N/A’; } else { value = Number(value).toLocaleString(option.lang ? option.lang : ‘en’, { minimumFractionDigits: decimals }) + unit; } /** Retrieve the color of the current series */ const color = param.color; /** * Add the series name and value to the tooltip content * Use a circle icon with the series color */ tooltipContent += ‘
‘ + ” + ” + ” + seriesName + ” + ” + ” + value + ” + ‘
‘; } /** Close the tooltip content container */ tooltipContent += ”; /** Return the formatted tooltip content */ return tooltipContent; } } /* * This content is licensed according to the W3C Software License at * https://www.w3.org/Consortium/Legal/2015/copyright-software-and-document * * File: sortable-table.js * * Desc: Adds sorting to a HTML data table that implements ARIA Authoring Practices */ class SortableTable { constructor(tableNode) { this.tableNode = tableNode; this.columnHeaders = tableNode.querySelectorAll(‘thead th.sortable’); this.sortColumns = []; for (let i = 0; i b.value ? -1 : 1; } } else if (isNumber) { return a.value – b.value; } else { return a.value
Subscribe to receive the latest Eurostat Euro indicators releases
{ if (document.querySelector(selector)) { return resolve(document.querySelector(selector)); } const observer = new MutationObserver(mutations => { if (document.querySelector(selector)) { resolve(document.querySelector(selector)); observer.disconnect(); } }); observer.observe(document.body, { childList: true, subtree: true }); }); } waitForElm(‘div.chart’).then((elm) => { // Has to be run after cool-ngx-editor.js script that is tweeking the charts const elements = document.getElementsByClassName(“chart”); for (let i = 0; i < elements.length; i++) { let div = document.createElement('div'); div.id = "share-chart-" + i; div.style = "position: absolute; right: 0; z-index: 50;"; elements[i].prepend(div); let script = document.createElement('script'); script.type = "application/json"; let url = new URL(window.location.href); url.searchParams.set('item', 'chart'); url.searchParams.set('id', i); let code = '{"service": "sbkm", "version": "2.0", "popup": false, "icon": true, "more" : ["facebook", "x", "linkedin", "email"], "renderTo": "' + div.id + '", "to": ["more"], "target": true, "link": "' + url.href + '", "via": "EU_Eurostat", "title": "' + getJournalArticleTitle() + '"}'; try { script.appendChild(document.createTextNode(code)); } catch (e) { s.text = code; } elements[i].parentNode.insertBefore(script, elements[i].nextSibling); } }); // Add share button to tables $(document).ready(function() { // Has to be run after cool-ngx-editor.js script that is tweeking the tables const tables = document.getElementsByTagName("table"); for (let i = 0; i position) { await new Promise(r => setTimeout(r, 500)); // Wait a bit so that it doesn’t scroll too far allItems[position].scrollIntoView(true); } } });;}());]]>