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.
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 sixteen dimensions:
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:
while the entire BP6 dataset can be described as:
where "*" indicates that there is no value specified for a dimension.
There are a multitude of possible combinations of dimensional constraints.
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:
The SDW also enables users to perform simple data transformations such as year-to-year percentage changes or frequency conversion.
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:
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 datasets available in the ECB's Statistical Data Warehouse. The time series in the datasets can be found in the data nodes of the navigation hierarchy, and can be accessed also via the search feature.
The list contains:
Metadata links: these direct you to the available dataset descriptions.
Data links: these direct you to the Data Selection pages.
Bulk Download: entries using the ECB SDMX 2.1 RESTful web services.
|AME - AMECO||Data||Bulk download|
|BKN - Banknotes statistics||Data||Bulk download|
|BLS - Bank Lending Survey Statistics||Data||Bulk download|
|BOP - Euro Area Balance of Payments and International Investment Position Statistics||Data||Bulk download|
|BP6 - Balance of Payments and International Investment Position (BPM6)||Data||Bulk download|
|BSI - Balance Sheet Items||Data||Bulk download|
|BSP - Balance Sheet Items Statistics (tables 2 to 5 of the Blue Book)||Data||Bulk download|
|CBD - Statistics on Consolidated Banking Data||Data||Bulk download|
|CBD2 - Consolidated Banking data||Data||Bulk download|
|CCP - Central Counterparty Clearing Statistics||Data||Bulk download|
|CISS - Composite Indicator of Systemic Stress||Data||Bulk download|
|CPP - Commercial Property Price Statistics||Data||Bulk download|
|DCM - Dealogic DCM analytics data||Data||Bulk download|
|DD - Derived Data||Data||Bulk download|
|E09 - Government Tax and Social Contributions Receipts Statistics (Eurostat ESA2010 TP, table 9)||Data||Bulk download|
|E11 - Classification of the Functions of Government Statistics (Eurostat ESA2010 TP, table 11)||Data||Bulk download|
|EDP - EDP tables||Data||Bulk download|
|EON - EONIA: Euro Interbank Offered Rate||Data||Bulk download|
|ESA - ESA95 National Accounts||Data||Bulk download|
|ESB - European Union Balance of Payments (Source Eurostat)||Data||Bulk download|
|EXR - Exchange Rates||Data||Bulk download|
|FM - Financial market data||Data||Bulk download|
|FVC - Financial Vehicle Corporation||Data||Bulk download|
|GFS - Government Finance Statistics||Data||Bulk download|
|GST - Government Statistics||Data||Bulk download|
|ICP - Indices of Consumer prices||Data||Bulk download|
|ICPF - Insurance Corporations & Pension Funds Statistics||Data||Bulk download|
|IDCM - National accounts, Main aggregates in the International Data Cooperation TF context||Data||Bulk download|
|IEAF - Quarterly non-financial accounts, QSA by country||Data||Bulk download|
|IEAQ - Quarterly Euro Area Accounts||Data||Bulk download|
|IFI - Indicators of Financial Integration||Data||Bulk download|
|ILM - Internal Liquidity Management||Data||Bulk download|
|IRS - Long-term interest rate statistics||Data||Bulk download|
|IVF - Investment Funds Balance Sheet Statistics||Data||Bulk download|
|JVC - Eurostat Job Vacancy Statistics||Data||Bulk download|
|KRI - EBA Key Risk Indicators||Data||Bulk download|
|LIG - Large Insurance Groups Statistics||Data||Bulk download|
|MFI - List of MFIs||Data||Bulk download|
|MIR - MFI Interest Rate Statistics||Data||Bulk download|
|MMS - Money Market Survey||Data||Bulk download|
|MNA - National accounts, Main aggregates (Eurostat ESA2010 TP, table 1)||Data||Bulk download|
|OFI - Other Financial Intermediaries||Data||Bulk download|
|PSS - Payments and Settlement Systems Statistics||Data||Bulk download|
|QSA - Quarterly Sector Accounts (MUFA and NFA Eurostat ESA2010 TP, table 801)||Data||Bulk download|
|RA - International Reserves of the Eurosystem||Data||Bulk download|
|RA6 - International Reserves of the Eurosystem (BPM6)||Data||Bulk download|
|RAI - Risk Assessment Indicators||Data||Bulk download|
|RDE - Risk Dashboard data||Data||Bulk download|
|RDF - Risk Dashboard data||Data||Bulk download|
|RIR - Retail Interest Rates||Data||Bulk download|
|RPP - Residential Property Price Index Statistics||Data||Bulk download|
|RPV - Residential Property Valuation||Data||Bulk download|
|RTD - Real Time Database (research database)||Data||Bulk download|
|SAFE - Survey on Access to Finance of Enterprises||Data||Bulk download|
|SEC - Securities||Data||Bulk download|
|SEE - Securities exchange - Trading Statistics||Data||Bulk download|
|SHS - Securities Holding Statistics||Data||Bulk download|
|SPF - Survey of Professional Forecasters||Data||Bulk download|
|SSI - Banking Structural Financial Indicators||Data||Bulk download|
|SSP - Structural Financial Indicators for Payments||Data||Bulk download|
|SST - Securities Settlement Statistics||Data||Bulk download|
|ST1 - Balance of Payments statistics, national data||Data||Bulk download|
|ST3 - Euro Area Balance of Payments and International Investment Position Statistics, Geographical Breakdown||Data||Bulk download|
|STP - STEP data||Data||Bulk download|
|STS - Short-Term Statistics||Data||Bulk download|
|TGB - Target Balances||Data||Bulk download|
|TRD - External Trade||Data||Bulk download|
|WTS - Trade weights||Data||Bulk download|
|YC - Financial market data - yield curve||Data||Bulk download|
The SDW comprises a set of 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. For more options see the 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.|
|Currency Converter||View foreign exchange rates by using this currency exchange rate calculator for more than 50 foreign currencies.|
The point of contact for additional information or help.
The Browse, My Reports 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 navigation hierarchy. Note that this is only necessary for accessing the My Reports and My Data Groups functions.
To choose an action, click on the relevant button from the "data toolbar" available at the top of most of the pages:
The Site Directory can be accessed via the navigation hierarchy and it 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. The hierarchy can be expanded/collapsed as per your needs. Click on one of the links to be directed to the relevant part of the Site Directory, where more details are provided. As each item within the Site Directory is a hyperlink, clicking on an item will lead you to a relevant node (page) of the SDW.
The Site Directory 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 the text box and press the "Highlight words" button. All matches will be highlighted in yellow. Please scroll down the page to check all results. The text box can be reseted by clicking "Clear terms".
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 available in the navigation menu, it will launch within the same browser window.