You can view data and associated explanations (metadata) for up to 50 selected series at a time. To view data and metadata, use the following buttons appearing in the "data functions toolbar" at the top of the page:
The Metadata page contains information grouped according to two levels of detail: dataset and series levels. This type of information is often referred to as metadata.
The most common definition of "metadata" is "data about data". In statistical terms, it provides information about statistical data and about processes of producing and using the data (methodology, compilation methods, data sources, etc.).
The dataset-level metadata represents the highest level of information corresponding to the datasets to which your selected time series belong. A metadata page exists for each of these datasets and provides information about data collection or compilation method, methodology, dissemination policy, etc., as well the contact details for any questions about the dataset content. You will also find a reference to the Data Structure Definition used to describe and store the data under “Statistical concepts and definitions”, information also accessible in the SDW “Data Selection” page under “DSD” when browsing the data.
To generate a printer-friendly version of the dataset-level metadata, use the Print option from the toolbar menu:
The series-level metadata is the lowest level of metadata. Each of your selected series will have an entry under series-level metadata. Typical series-level metadata are, for example, the series title or information about units in which the series is expressed.
The following icons are displayed in the top left-hand corner of each of the two metadata areas:
![]() ![]() |
Expand/Collapse area - click on this to show/hide a metadata area. |
---|
The Data Table page displays your selected data in tabular format. It also enables basic data transformations. It consists of three areas: Parameters and Transformations, Common Description (if applicable) and data area.
The Parameters and Transformations section allows you to change the date range of displayed series and apply one of the pre-selected data transformations.
To restrict the date range of the data displayed, enter a date range in DD-MM-YYYY
format in the date range fields at the top of the Data Table page and the page will refresh the data displayed in accordance with your date range restriction. To remove the date range restriction, click on the "Reset Settings" button. Please note that date settings apply to every page of the portal except Quick View pages. To check your date settings please go to "My Settings" page.
To apply a simple data transformation choose one of the available functions from a dropdown list located at the bottom of the "Parameters and Transformations" section. It is only possible to select one transformation type at a time. A selected transformation applies to all series displayed within the data area, and the transformed values appear on the right-hand side of each time series.
Note that when working with frequency conversion functions it is only possible to convert data from a higher to a lower frequency (for example, monthly data into quarterly data). The conversion method depends on the collection indicator of a selected series (this can be checked using the Metadata tab). The most common collection indicators are: average over a period (A
); beginning of period (B
); and end of period (E
). The respective conversion method acts as follows: (A
) - calculates an average over a specified period; (B
) - retrieves the first observation of a specified period; and (E
) - retrieves the last observation of a specified period.
Other collection indicators include highest and lowest in a period (H
and L
respectively) and summed through period (S
). Note that in case the collection indicator of a selected series has a value of (V
) –“Other” or (U
) – “Unknown” no transformation will be performed.
The example below shows a monthly time series containing values for a year and the annual values resulting from conversions following the different collection indicator values.
Jan 2005 | 1.00 |
Feb 2005 | 1.20 |
Mar 2005 | 1.50 |
Apr 2005 | 1.80 |
May 2005 | 1.00 |
Jun 2005 | 2.30 |
Jul 2005 | 2.10 |
Aug 2005 | 2.00 |
Sep 2005 | 1.80 |
Oct 2005 | 2.10 |
Nov 2005 | 1.70 |
Dec 2005 | 1.60 |
Collection indicator | Annual value for 2005 | Calculation |
---|---|---|
A | 1.68 | Sum of all 12 observations divided by 12 |
B | 1.00 | Beginning of period: January observation |
E | 1.60 | End of period: December observation |
H | 2.30 | Highest value of the period |
L | 1.00 | Lowest value of the period |
S | 20.10 | All values of the period summed |
U | - | No transformation since the collection type is unknown |
V | - | No transformation since the collection type is other than the above |
Other transformations allow you to calculate year-to-year and period-to-period changes and percentage changes. Please note that these transformation options cannot be used if time series contain both negative and positive values. The time series have to be comprised of either negative or positive observations in order for these transformations to work.
It should also be noted that these changes require the existence of both values, i.e. the value of the previous year or period and that of the current one, otherwise the resulting value will be a "null" value. This is often the case when calculating the year-to-year or period-to-period (percentage) changes for data reported on a business frequency, as the same date of the previous year might have fallen on a weekend or a bank holiday.
You can also control the way in which missing values are treated. This is done using the "Ignore missing values" option, available on the My Settings page. The option instructs the SDW to ignore missing values and, accordingly, drop them from the calculation.
Also appearing on the Data Table page is the Common Description from the Data Selection page, which displays all common filter criteria currently applying to your data selection.
Within the data area, time series are displayed by default in time-descending order. To reverse the order, click on the arrow displayed at the top of the period column. Period labels are displayed on the left. The series titles identifying each series appear at the top, while time series keys are shown in the tool tips of the time series titles. Source information is provided for each of the displayed series and is visible right above the table header.
If you have selected time series with different frequencies and have selected to display data by frequency (on the My Settings page), you will have the option of viewing your series grouped together and presented separately by frequency. Select a frequency from the dropdown options directly above the Data Table to view all selected series with the chosen frequency. To view all selected series on the same page, simply select "All" from the Frequency options. To change your frequency display preference, check/uncheck the Display Data by Frequency checkbox (under Data Display) on the My Settings page.
Please note that owing to a restriction on the amount of data that can be displayed, only a limited number of observations can be taken into account in the data table display. If the maximum number of observations is exceeded, older observations will not be displayed in the data table. In order to access all observations, refreshable export options (Excel refreshable, Excel with Populator or Stata Dynamic) or CSV format need to be used.
To generate a printer-friendly version of the data table, use the Print option from the toolbar menu:
On a Data Table page, the relevant button inside the "data functions toolbar" is highlighted in blue:
Click on a button from the toolbar to view Data table, Data Chart or Metadata, to Export or save (Add to My Data) the time series of your choice.
The Data Chart page displays your selected data in graphical format. It consists of three areas: Parameters and Transformations, Common Description (if applicable), and a chart area.
The Parameters and Transformations section allows you to change the date range of displayed series and apply one of the pre-selected data transformations.
To restrict the date range of the data displayed, enter a date range in DD-MM-YYYY
format in the date range fields at the top of the Data Chart page and the page will refresh with data displayed in accordance with your date range restriction. To remove the date range restriction, click on the "Reset Settings" button. Please note that date settings apply to every page of the portal except Quick View pages. To check your date settings please go to "My Settings" page.
To apply a simple data transformation, choose one of the available functions from a dropdown list located at the bottom of the Parameters and Transformations section. It is only possible to select one transformation type at a time. The transformation applies to all series displayed in the chart area, and they are displayed together with the original series.
Note that when working with frequency conversion functions it is only possible to convert data from a higher to a lower frequency (for example, monthly data into quarterly data). The conversion method depends on the collection indicator of a selected series (this can be checked using the Metadata tab). The most common collection indicators are: average over a period (A
); beginning of period (B
); and end of period (E
). The respective conversion method acts as follows: (A
) – calculates an average over a specified period; (B
) – retrieves the first observation of a specified period; and (E
) – retrieves the last observation of a specified period.
Other collection indicators include highest and lowest in a period (H
and L
respectively) and summed through period (S
). Note that in case the collection indicator of a selected series has a value of (V
) –“Other” or (U
) – “Unknown” no transformation will be performed.
The example below shows a monthly time series containing values for a year and the annual values resulting from conversions following the different collection indicator values.
Example time series:
Jan 2005 | 1.00 |
Feb 2005 | 1.20 |
Mar 2005 | 1.50 |
Apr 2005 | 1.80 |
May 2005 | 1.00 |
Jun 2005 | 2.30 |
Jul 2005 | 2.10 |
Aug 2005 | 2.00 |
Sep 2005 | 1.80 |
Oct 2005 | 2.10 |
Nov 2005 | 1.70 |
Dec 2005 | 1.60 |
Collection indicator | Annual value for 2005 | Calculation |
---|---|---|
A | 1.68 | Sum of all 12 observations divided by 12 |
B | 1.00 | Beginning of period: January observation |
E | 1.60 | End of period: December observation |
H | 2.30 | Highest value of the period |
L | 1.00 | Lowest value of the period |
S | 20.10 | All values of the period summed |
U | - | No transformation since the collection type is unknown |
V | - | No transformation since the collection type is other than the above |
Other transformations allow you to calculate year-to-year and period-to-period changes and percentage changes. Please note that these transformation options cannot be used if time series contain both negative and positive values. The time series have to be comprised of either negative or positive observations in order for these transformations to work.
It should also be noted that these changes require the existence of both values, i.e. the value of the previous year or period and that of the current one, otherwise the resulting value will be a "null" value. This is often the case when calculating the year-to-year or period-to-period (percentage) changes for data reported on a business frequency, as the same date of the previous year might have fallen on a weekend or a bank holiday.
You can also control the way in which missing values are treated. This is done with the "Ignore missing values" option, available on the My Settings page.
Also appearing on the Data Chart page is the Common Description from the Data Selection page, which displays all common filter criteria currently applying to your data selection.
All of your selected series appear on a single line chart, each demarcated in a different colour. Period labels are displayed on the x-axis and observation value scales on the y-axis. Colour-coded time series titles identifying each series appear directly beneath the chart. Source information is provided for each of the displayed series and appears at the very bottom of the Data Chart page. Note that you can hide/show all the series by clicking the "Hide/Show All" element of the chart legend.
Please note that owing to a restriction on the amount of data that can be displayed, only a limited number of observations can be taken into account in the data chart display. If the maximum number of observations is exceeded, older observations will not be displayed on the charts. In order to access all observations, refreshable export options (Excel refreshable, Excel with Populator or Stata Dynamic) or CSV format need to be used.
To generate a printer-friendly version of the data chart, use the Print option from the toolbar menu:
On a Data Chart page, the relevant button inside the "data functions toolbar" is highlighted in blue:
Click on a button from the toolbar to view Data table, Data Chart or Metadata, to Export or save (Add to My Data) the time series of your choice..
To view reports based on data contained in the SDW, click on the Publications item in the navigation menu on the left-hand side. Select a publication type from the menu. The selected publication will expand to reveal a list of available reports, and/or further navigation subcategories, which can be expanded to display associated reports.
A navigation item preceded by a plus sign ( +
) indicates that the item contains further sub-items and can be expanded. A navigation item preceded by a minus sign ( -
) indicates that you are currently browsing within that item. The most recently selected item is highlighted in blue. There are more types of leaf node pages available within the navigation menu Publications: "Data" and "Latest". Click on a Data leaf node to view all series used within a chosen data table. Depending on the number of series attached, this leads to a Data Selection or a Data Table page. The Latest leaf node is designated with a PDF icon and displays data tables in PDF format. These pages are generated on the basis of the latest data available in the SDW. Some publications also include explanatory, general and technical notes. See a snapshot below.
On the top level of most publications, the “full report” option is also available. This allows you to see in one PDF file all pages included in the Latest leaf nodes under that publication. For some publications, the full report functionality can be available at chapter level as well.
Moreover you have the option of going directly to a specific report page. This can be simply done by adding &page=3
to the report URL, in case you want to access the third page of the report. See here an example for the Statistics Bulletin report.
To create your own reports use the My Reports functionality.
The series keys displayed on the Data Selection page can offer a more detailed view with a simple click. The displayed list of series show a full description for each series (see the Title column). Click on the link to be redirected to the quickview page where you can view all data and associated explanations (metadata) pertaining to this series/sibling set. The Quick View page opens in a new browser tab and displays the series-level metadata, data table and data chart for the selected time series/sibling.
The Series-Level Information section displays all associated explanations available for the selected series. If the series is used in any of the ECB's regular statistical publications, links to the related publications will also be displayed. Note that owing to space constraints some series-level information may not be visible at first. Use the /
to expand/hide specific areas.
Within the Data Table section the series appears in descending order. A key series attribute (observation status) is displayed on the right-hand side of the series. Source information is provided in the first line of the Data Table area.
It is also possible to perform a simple data transformation by choosing an appropriate option within the Parameters and Transformations section.
The Quick View can be printed by clicking on the Print button located at the top of the page. Please be aware that the printout may be quite long depending on the amount of data appearing within the selected series.
A special feature of the Quickview page. It returns only the chart from the time series. For example for the Overall euro area HICP series this chart is returned.
For example, you can easily create an URL from the Quick View page of this time series. Check it out here
When you add &chartOnly=y
to the URL of the quickview, like in this, example, it will return the Quick Chart of the series.
Quick Chart is the functionality of SDW, where SDW returns a chart for a special GET request.
Please use the Quickview action quickview.do with the parameter of chartOnly=y
.
The following extra parameters can be used:
avg=y
mrkr=MU11
notxt=y
start=1-1-1999
trans=YPC&submitOptions.y=2
width=800&height=150
Let's start with the series ICP.M.U2.N.000000.4.ANR
Euro area (changing composition) - HICP - Overall index, Annual rate of change, Eurostat, Neither seasonally nor working day adjusted
Here is a link to the series Quick View page.
Add &chartOnly=y
to the URL of the quickview like in this example.
You can also try and already embed the image into an HTML page:
Add ¬xt=y
this parameter to the URL of the Quick Chart.
Check it out here.
Add parameter mrkr
with the value of MU11
to the URL.
See an example here.
Other possible values for the vertical markers: MU12
, MU13
, M15
, EU12
, EU15
, EU25
, EU27
.
Add `avg=y to the URL.
See an example here.
HICP/CPI for Euro Area/Germany/UK/France with date range restriction
The image source in the HTML page is here.
In order to display more than one series on the chart, one can add more than one SERIES_KEY
parmater to the URL. Here we should also include the start date (as parameter start
) in the URL.
HICP/CPI for Euro Area with date range restriction (from 1 January 1999)
The image source in the HTML page is here.
In order to change the date range one should also include the start date (as parameter start) in the URL.
Euro area 12 (fixed composition) GDP and its year-to-year percentage changes from 1 January 1999
The image source in the HTML page is here .
Euro area - HICP - Overall index, Annual rate of change, Eurostat, Neither seasonally or working day adjusted (resized)
The image source in the HTML page is here.
The size of the image should be specified with width
and height
parameters, which should be positive integers, and less than the size of the charts on SDW's Data Chart page (width=800
, height ?
).
MU12
enlagement, and an average since 1 Jan. 1999.Check it out here.
For published series, links to publications and the number of publication tables where the respective series is used are also displayed. Click on “Link to publications” to display the full list of publication tables in which the series appears. By selecting one of the items in the list you are directed to the online publication table (e.g. from the Statistics Bulletin online or the ESRB Risk Dashboard) that includes the associated time series.
The Explanatory Items area displays a list of datasets of which the dimension description fields or any other metadata match your search criteria. They are sorted as follows:
Explanatory Items:
To select or unselect an item, check the corresponding checkbox.