Data Structure

The Statistical Data Warehouse (SDW) is a fully metadata driven application based on the Statistical Data and Metadata eXchange (SDMX) data model. For additional information, please refer to the SDMX documentation.

The SDW provides access to a vast quantity of statistical data and metadata available at the ECB.

Data in the SDW is organised into datasets, such as Balance of Payments (BOP), Balance Sheet Items (BSI) and Exchange rates (EXR). A dataset is a logical grouping of data, which consists of a collection of time series belonging to the same "set" and sharing both a common business meaning and dimensional structure. Such information is accessible by the users when browsing the data in the SDW.

For an overview of the data content, please refer to the list of datasets.To learn more about structure of data cubes please check the Self Learning Tutorial: Data Structure Definition.

The Dataset Concept

SDW datasets typically consist of more than three dimensions. The number and type of dimensions vary according to the dataset. Most datasets share several common dimensions such as Frequency and Geographic Area. The Balance Sheet Items (BSI) dataset, for instance, has eleven dimensions, while the BPM6 Balance of Payments (BP6) dataset is associated with the following fifteen dimensions:

  1. Frequency
  2. Adjustment indicator
  3. Reference area
  4. Counterpart area
  5. Reference sector
  6. Counterpart sector
  7. Flows and stocks indicator
  8. Accounting entries
  9. International accounts item
  10. Functional category
  11. Instrument and assets classification
  12. Maturity
  13. Unit of measure
  14. Currency denominator
  15. Valuation
  16. Compiliation methodology

The structure of the series keys follows the BOP Data Structure Definition (DSD) maintained by the IMF. Such information is accessible by the users when browsing the data in the SDW Each dimension can be constrained by assigning a specific value to it. A selected dataset with constraints applied to all of its dimensions is identical with a single time series. A dataset without any constraints represents the largest possible collection of time series available for a chosen economic concept.

For instance, a BP6 time series can be represented by the following notation: BP6.M.N.DE.W1.S1.S1.T.N.FA.F.F7.T.EUR._T.T.N,

while the entire BP6 dataset can be described as: BP6.%.%.%.%.%.%.%.%.%.%.%.%.%.%.%.%, where "%" indicates that there is no value specified for a dimension.

There are a multitude of possible combinations of dimensional constraints. For example: BP6.%.Q.%.%.%.%.%.%.%.%.%.%.%.%.%

denotes all quarterly BP6 time series;

BP6.%.%.DE.%.%.%.%.%.%.%.%.%.%.%.%.% denotes all BP6 time series for Germany;

BP6.%.N.DE.W1.S1.S1.T.N.FA.F.F7.T.EUR._T.T.N denotes all Financial Derivatives and Employee Stock Options that are Neither seasonally nor working day adjusted, from Germany, etc.

BP6.Q.%.DE.%.%.%.%.%.CA.%.%.%.%.%.%.% denotes all quarterly BP6 time series for Germany belonging to current account.

In addition to time series data, the SDW provides access to:

  • Data explanations (metadata) on various levels, including observation-level attributes (e.g. status and confidentiality), series/sibling-level information (e.g. title and compilation method), dimension descriptions and others.

The SDW also enables users to perform simple data transformations such as year-to-year percentage changes or frequency conversion.

The meaning of the different euro area codes

Data relating to the euro area can refer to either a fixed composition of countries for all periods, or a changing composition. Statistical series referring to a changing composition are based on the composition of the euro area at the time to which the statistics relate:

  • Data prior to 2001 refer to the Euro 11, i.e. the following 11 European Union (EU) Member States: Belgium, Germany, Ireland, Spain, France, Italy, Luxembourg, the Netherlands, Austria, Portugal and Finland.
  • Data from 2001 to 2006 refer to the Euro 12, i.e. the Euro 11 plus Greece.
  • Data for 2007 refer to the Euro 13, i.e. the Euro 12 plus Slovenia.
  • Data for 2008 refer to the Euro 15, i.e. the Euro 13 plus Cyprus and Malta.
  • Data for 2009 and 2010 refer to the Euro 16, i.e. the Euro 15 plus Slovakia.
  • Data from 2011 to 2013 refer to the Euro 17, i.e. the Euro 16 plus Estonia.
  • Data as of 2014 refer to the Euro 18, i.e. the Euro 17 plus Latvia.
  • Data as of 2015 refer to the Euro 19, i.e. the Euro 18 plus Lithuania.

Dataset List

The ECB – assisted by the national central banks (NCBs) and other national (statistical and supervisory) authorities of the European Union – develops, collects, compiles and disseminates statistics. The Statistical Data Warehouse is a platform where euro area statistics, including in some cases national breakdowns are made available.

The ECB statistics: a brief overview provides a brief introduction to the topics covered.

Please find below the complete list of data sets available in the ECB's Statistical Data Warehouse. The time series in the data sets can be found under the 'Economic Concept' navigation hierarchy, and can be accessed also via the search feature.

The list contains:

  • Metadata links direct you to the available dataset descriptions.
  • Data links direct you to the Data Selection pages.
  • Bulk Download entries using the ECB SDMX 2.1 RESTful web services.
Dataset Metadata Data
(in SDW)
Bulk Download
(as SDMX-ML)
AME - AMECO Data Bulk donwload
BKN - Banknotes statistics Data Bulk donwload
BLS - Bank Lending Survey Statistics Data Bulk donwload
BOP - Euro Area Balance of Payments and International Investment Position Statistics Data Bulk donwload
BP6 - Balance of Payments and International Investment Position (BPM6) Data Bulk donwload
BSI - Balance Sheet Items Data Bulk donwload
BSP - Balance Sheet Items Statistics (tables 2 to 5 of the Blue Book) Data Bulk donwload
CBD - Statistics on Consolidated Banking Data Data Bulk donwload
CBD2 - Consolidated Banking data Data Bulk donwload
CCP - Central Counterparty Clearing Statistics Data Bulk donwload
CISS - Composite Indicator of Systemic Stress Data Bulk donwload
CPP - Commercial Property Price Statistics Data Bulk donwload
DCM - Dealogic DCM analytics data Data Bulk donwload
DD - Derived Data Data Bulk donwload
E09 - Government Tax and Social Contributions Receipts Statistics (Eurostat ESA2010 TP, table 9) Data Bulk donwload
E11 - Classification of the Functions of Government Statistics (Eurostat ESA2010 TP, table 11) Data Bulk donwload
EDP - EDP tables Data Bulk donwload
EON - EONIA: Euro Interbank Offered Rate Data Bulk donwload
ESA - ESA95 National Accounts Data Bulk donwload
ESB - European Union Balance of Payments (Source Eurostat) Data Bulk donwload
EXR - Exchange Rates Data Bulk donwload
FM - Financial market data Data Bulk donwload
FVC - Financial Vehicle Corporation Data Bulk donwload
GFS - Government Finance Statistics Data Bulk donwload
GST - Government Statistics Data Bulk donwload
ICP - Indices of Consumer prices Data Bulk donwload
ICPF - Insurance Corporations & Pension Funds Statistics Data Bulk donwload
IDCM - National accounts, Main aggregates in the International Data Cooperation TF context Data Bulk donwload
IEAF - Quarterly non-financial accounts, QSA by country Data Bulk donwload
IEAQ - Quarterly Euro Area Accounts Data Bulk donwload
IFI - Indicators of Financial Integration Data Bulk donwload
ILM - Internal Liquidity Management Data Bulk donwload
IRS - Long-term interest rate statistics Data Bulk donwload
IVF - Investment Funds Balance Sheet Statistics Data Bulk donwload
JVC - Eurostat Job Vacancy Statistics Data Bulk donwload
KRI - EBA Key Risk Indicators Data Bulk donwload
LIG - Large Insurance Groups Statistics Data Bulk donwload
MFI - List of MFIs Data Bulk donwload
MIR - MFI Interest Rate Statistics Data Bulk donwload
MMS - Money Market Survey Data Bulk donwload
MNA - National accounts, Main aggregates (Eurostat ESA2010 TP, table 1) Data Bulk donwload
OFI - Other Financial Intermediaries Data Bulk donwload
PSS - Payments and Settlement Systems Statistics Data Bulk donwload
QSA - Quarterly Sector Accounts (MUFA and NFA Eurostat ESA2010 TP, table 801) Data Bulk donwload
RA - International Reserves of the Eurosystem Data Bulk donwload
RA6 - International Reserves of the Eurosystem (BPM6) Data Bulk donwload
RAI - Risk Assessment Indicators Data Bulk donwload
RDE - Risk Dashboard data Data Bulk donwload
RDF - Risk Dashboard data Data Bulk donwload
RIR - Retail Interest Rates Data Bulk donwload
RPP - Residential Property Price Index Statistics Data Bulk donwload
RPV - Residential Property Valuation Data Bulk donwload
RTD - Real Time Database (research database) Data Bulk donwload
SAFE - Survey on Access to Finance of Enterprises Data Bulk donwload
SEC - Securities Data Bulk donwload
SEE - Securities exchange - Trading Statistics Data Bulk donwload
SHS - Securities Holding Statistics Data Bulk donwload
SPF - Survey of Professional Forecasters Data Bulk donwload
SSI - Banking Structural Financial Indicators Data Bulk donwload
SSP - Structural Financial Indicators for Payments Data Bulk donwload
SST - Securities Settlement Statistics Data Bulk donwload
ST1 - Balance of Payments statistics, national data Data Bulk donwload
ST3 - Euro Area Balance of Payments and International Investment Position Statistics, Geographical Breakdown Data Bulk donwload
STP - STEP data Data Bulk donwload
STS - Short-Term Statistics Data Bulk donwload
TGB - Target Balances Data Bulk donwload
TRD - External Trade Data Bulk donwload
WTS - Trade weights Data Bulk donwload
YC - Financial market data - yield curve Data Bulk donwload

SDW Functions

The SDW comprises five major functions as described below:

Browse Browse data using a hierarchical navigation system organised either by reference series, economic concept, data providers/datasets or report type.
Search Search for data by submitting a text or series key search.
My Data Groups Compile, store and manage selected data for future use. Notification Service
Reports Browse the PDF versions of the ECB’s printed and on-line statistical publications, and access the data behind the publications.
My Reports Compile, store and manage selected PDF pages of different publications as your own Reports.
Administration Administer application settings. Includes Metadata Maintenance portal used to create and manage SDW metadata (available only to authorized Statistics Producers). You can reset your password to the SDW database, when it is accessed from different applications installed on your computer (using the ODBC connection between your machine and the SDW database). You find here the link to an MS Excel workbook, which has to be opened (and enable macros) before exporting special data formats.

The Browse and My Data Groups modules are accessible at any time through the left-hand-side navigation menu, while the Search option can be accessed by clicking on the "Search" button that appears on the upper header of all SDW pages. You may choose to log in to your SDW account at any time by clicking on the Login link located in the upper right-hand corner of all SDW pages. Note that this is only necessary for accessing the My Data Groups function.

The SDW functions further allow you to make a Data Selection of particular time series, to display Metadata, Data Table or Data Chart, or to Export or save (Add to My Data) the series of your choice.

To choose an action, click on a relevant button from the "data toolbar" available at the top of most of the pages: Data selection menu

Site Map

The Site Map displays a list of all pages available from the SDW navigation menu on the left-hand side. The first-level navigation items are displayed at the top. Click on one of the links to be directed to the relevant part of the Site Map, where more details are provided. As each item within the Site Map is a hyperlink, clicking on an item will lead you to a relevant node (page) of the SDW.

The Site Map page also offers a search functionality. You can look for navigation items containing a specific expression as part of their description. To perform such a search, enter your criteria into a text box located in the top right-hand corner of the page and press the "Highlight words" button. All matches will be highlighted in yellow. Please scroll down the page to check all results.

Glossary

The Glossary contains a definition of key terminology used within the context of the SDW.

The Glossary can be found on the ECB's internet pages. If accessed through SDW by clicking on the link in the top-most menu, it will launch within a separate browser window.

[All glossary entries] ("Glossary entries")