Dataset: DD – Derived Data

Data Structure Definition: Derived Data

[ECB_DD1 agency: ECB] Download SDMX 2.1 Data Structure Definition of the DD Dataflow

Click on the name of the codelist to see the full list of available codes.

Cube dimensions and attributes
  Concept description Concept Codelist Usage on SDW portal
1. dimension Frequency FREQ CL_FREQ Frequency dimension: used in Dimension Filters on Data Selection, Data Table and Quick View pages.
2. dimension Reference area REF_AREA CL_AREA_EE Country codes: used in Georgraphic Area filters on Data Selection pages.
3. dimension Derived data economic concept DD_ECON_CONCEPT CL_DD_ECON_CONCEPT
4. dimension Derived data transformation DD_TRANSF CL_DD_TRANSF
5. dimension Derived data suffix DD_SUFFIX CL_DD_SUFFIX
Observation-level attribute Observation value OBS_VALUE
Observation-level attribute Observation status OBS_STATUS CL_OBS_STATUS Observation status: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Observation-level attribute Observation confidentiality OBS_CONF CL_OBS_CONF Observation confidentiality: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Observation-level attribute Pre-break observation value OBS_PRE_BREAK Observation pre-break value: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Observation-level attribute Observation comment OBS_COM Observation comment: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Time Series-level attribute BoP data collection basis BOP_BASIS CL_BOP_BASIS
Time Series-level attribute Breaks BREAKS
Time Series-level attribute Collection indicator COLLECTION CL_COLLECTION Collection attribute: used on the Data Table, Data Chart and Quick View pages, displayed on the Metadata page.
Time Series-level attribute Compiling organisation COMPILING_ORG CL_ORGANISATION
Time Series-level attribute Data dissemination organisation DISS_ORG CL_ORGANISATION
Time Series-level attribute Domestic series ids DOM_SER_IDS
Time Series-level attribute Source publication (ECB only) PUBL_ECB
Time Series-level attribute Source publication (Euro area only) PUBL_MU
Time Series-level attribute Source publication (public) PUBL_PUBLIC
Time Series-level attribute Unit index base UNIT_INDEX_BASE Unit index base: displayed on the Data Table, Metadata and Quick View pages, downloadable in CSV and SDMX format.
Sibling-level attribute Aggregation equations AGG_EQUN
Sibling-level attribute Compilation COMPILATION
Sibling-level attribute Decimals DECIMALS CL_DECIMALS Number of decimals: used on the Data Table and Quick View pages.
Sibling-level attribute Source agency SOURCE_AGENCY CL_ORGANISATION Source Agency: displayed on the Data Table, Data Chart and Quick View pages.
Sibling-level attribute Title TITLE Short title: used in the Search and displayed on Data Selection, Metadata and Quick View pages.
Sibling-level attribute Title complement TITLE_COMPL Long title/description: used in the Search and displayed on Data Selection, Metadata and Quick View pages.
Sibling-level attribute Unit UNIT CL_UNIT Unit: displayed on the Data Table, Metadata and Quickview pages, downloadable in CSV and SDMX format.
Sibling-level attribute Unit multiplier UNIT_MULT CL_UNIT_MULT Unit Multiplier: displayed on the Data Table, Metadata and Quick View pages, downloadable in CSV and SDMX format.


Code List Description

Code Code Description
3MOR 3-month percentage change (Mt/Mt-3)
3YR 3-year percentage change
5YR 5-year percentage change
6MOR 6-month percentage change (Mt/Mt-6)
ANN Annualisation
ANR Annual percentage change (Mt/Mt-12, Qt/Qt-4, Yt/Yt-1)
AV Average
AVDE Average - difference from the Germany average
AVG Average
AVIR3M Average - difference from the 3-month interest rate
AWI2M3 Average weighted by monetary contributions over the euro area 12 (fixed composition)
AWI3M3 Average weighted by monetary contributions over the euro area 13 (fixed composition)
AWU2M3 Average weighted by monetary contributions M3 over the euro area (moving composition)
BUR Business on business percentage change (Bt/Bt-1)
CH Period-on-period percentage change
CHMA12M Period-on-period percentage change, moving average over the last 12 months
CS12M Cumulative sum of the last 12 months
CTG Contribution to growth rate
D0W EU (changing composition) country weights
D2W EU 15 (fixed composition) country weights
D3W EU 25 (fixed composition) country weights
D80W Euro area 12 (fixed composition) and new EU Member States 2004 (CY,CZ,EE,HU,LV,LT,MT,PL,SK,SI) country weights
END End of period
I1W Euro area 11 (fixed composition) country weights
I2W Euro area 12 (fixed composition) country weights
I2WM3 Weight within the euro area 12 (fixed composition) by monetary contributions M3
I3W Euro area 13 (fixed composition) country weights
I3WM3 Weight within the euro area 13 (fixed composition) by monetary contributions M3
I4W Euro area 15 (fixed composition) country weights
I5W Euro area 16 (fixed composition) country weights
I6W Euro area 17 (fixed composition) country weights
I7W Euro area 18 (fixed composition) country weights
I8W Euro area 19 (fixed composition) country weights
INW Sub-index weight
INX Index
LEV Level
LEVE Level (estimates)
MA12M Moving average over the last 12 months
MA3M Moving average over the last 3 months
MAVC3M Centered moving average over the last 3 months
MC12M Centered moving average over the last 12 months
MOR Month on month percentage change (Mt/Mt-1)
PEMP Percentage of labour force
PGDP Percentage of GDP
PGDP1Q 1 quarter - percentage gdp
PGDP4Q 4 quarters up to - percentage gdp
PGDPAV3Y 3-year average, percentage of GDP
PGDPAV5Y 5-year average, percentage of GDP
PGDPMA3Y Moving average over the last 3 years, percentage of gdp
PLF Percentage of the labour force
PM3 Percentage of M3
QCTG Quarterly contribution to growth rate
QUR Quarter on quarter percentage change (Qt/Qt-1)
RO Ratio
U2W Euro area (changing composition) country weights
U2WM3 Euro area (changing composition) country weights by monetary contributions M3
V1W EU 27 (fixed composition as of 1 January 2007) country weights
V3W EU 28 (fixed composition as of 1 July 2013) country weights
V5W EU 27 (fixed composition as of 31 January 2020, brexit) country weights