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 fifteen 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 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 linksdirect you to the available dataset descriptions.
Data linksdirect you to the Data Selection pages.
Bulk Downloadentries using the ECB SDMX 2.1 RESTful web services.
|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|
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.|
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.
To choose an action, click on a relevant button from the "data toolbar" available at the top of most of the pages:
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.
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")