Register record·DATASET·EU·REGULATORVERIFIED · checked 15h ago
E
European Central Bank — Securities Holding Statistics (SHS)
Securities Holding Statistics (SHS) — official time series from the European Central Bank Data Portal, published as the SHS dataflow over SDMX 2.1 REST. One endpoint serves XML (SDMX-ML), CSV (?format=csvdata) and JSON (?format=jsondata); extract exactly the series you need with a key path and startPeriod / endPeriod / lastNObservations filters. Browse and chart the same series on the ECB Data Portal.
economyprices
Trust score
How is this computed?79
good
Weighted across five axes. Tap a ring for what it measures.
Data schema (37 fields)
Filterable via the API (20)
FREQHOLDER_AREAISSUER_AREAHOLDER_SECTORISSUER_SECTORFUNCTIONAL_CATSTOINSTR_ASSETMATURITYUNIT_MEASUREVALUATIONSECURITY_TYPEMA_FLAGIS_IN_EADBSECURITISATION_TYPDEBT_TYPETPHNOM_CURRCOMPILING_ORGTIME_PERIOD
Click a field to see example values.
| Field | Type | Description |
|---|---|---|
| FREQFrequency | dimension | 1 codes (e.g. Quarterly) |
| HOLDER_AREAHolder country | dimension | 1 codes (e.g. Euro area 19 (fixed composition) as of 1 January 2015) |
| ISSUER_AREAIssuer domicile country | dimension | 55 codes (e.g. All European Community Institutions, Organs and Organisms, including ECB, ESM and EFSF, Argentina, Austria) |
| HOLDER_SECTOR | dimension | 8 codes (e.g. Non financial corporations, Other financial institutions (Financial corporations other than MFIs, insurance corporations and pension funds), Insurance corporations and Pension Funds) |
| ISSUER_SECTORIssuer ESA 2010 sector | dimension | 8 codes (e.g. Not sectorised, Total economy, Non financial corporations) |
| FUNCTIONAL_CATFunctional category | dimension | 1 codes (e.g. Not allocated/unspecified) |
| STOStocks, Transactions, Other Flows | dimension | 1 codes (e.g. Closing balance sheet/Positions/Stocks) |
| INSTR_ASSETInstrument and assets classification | dimension | 3 codes (e.g. Debt securities, Listed shares, Investment fund shares/units) |
| MATURITY | dimension | 3 codes (e.g. Long-term original maturity (over 1 year or no stated maturity), Short-term original maturity (up to 1 year), Not applicable) |
| UNIT_MEASUREUnit of measure | dimension | 1 codes (e.g. Euro) |
| VALUATION | dimension | 1 codes (e.g. Market value) |
| SECURITY_TYPE | dimension | 1 codes (e.g. All) |
| MA_FLAGMacro-adjustment flag | dimension | 1 codes (e.g. All) |
| IS_IN_EADB | dimension | 1 codes (e.g. All) |
| SECURITISATION_TYPAsset securitisation type | dimension | 1 codes (e.g. Unspecified) |
| DEBT_TYPE | dimension | 1 codes (e.g. Unspecified) |
| TPHThird party holdings flag | dimension | 1 codes (e.g. R and Y combined) |
| NOM_CURRNominal currency of the security | dimension | 1 codes (e.g. All currencies) |
| COMPILING_ORGCompiling organisation | dimension | 1 codes (e.g. Unspecified (e.g. any, dissemination, internal exchange etc)) |
| TIME_PERIODTime period or range | time | Time dimension — filter with startPeriod / endPeriod query params. |
| OBS_VALUEObservation value | number | The observed numeric value for each cell. |
| TIME_FORMATTime format code | attribute | — |
| COMMENT_TSSeries comment including brief description of the underlying statistic | attribute | — |
| DATA_COMPUnderlying compilation | attribute | — |
| DECIMALS | attribute | — |
| DISS_ORGData dissemination organisation | attribute | — |
| REF_PERIOD_DETAILReference period detail | attribute | — |
| TIME_PER_COLLECTTime period collection | attribute | — |
| TITLE | attribute | — |
| TITLE_COMPLTitle complement | attribute | — |
| UNIT_MULTUnit multiplier | attribute | — |
| OBS_STATUSObservation status | attribute | — |
| CONF_STATUSConfidentiality status | attribute | — |
| PRE_BREAK_VALUE | attribute | — |
| COMMENT_OBSComments to the observation value | attribute | — |
| EAPLUS_FLAG | attribute | — |
| ESCB_FLAG | attribute | — |
Schema captured from sdmx 1 month ago.
Query the data
Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.
=
Sample data (5 records)
Record 1STO: LE · TPH: V
{
"STO": "LE",
"TPH": "V",
"FREQ": "Q",
"MA_FLAG": "A",
"MATURITY": "L",
"NOM_CURR": "_T",
"DEBT_TYPE": "_X",
"OBS_VALUE": 1111.097119,
"VALUATION": "M",
"IS_IN_EADB": "A",
"HOLDER_AREA": "I8",
"INSTR_ASSET": "F3",
"ISSUER_AREA": "4Y",
"TIME_PERIOD": "2022-Q1",
"UNIT_MEASURE": "EUR",
"COMPILING_ORG": "ZZZ",
"HOLDER_SECTOR": "S11",
"ISSUER_SECTOR": "S1N",
"SECURITY_TYPE": "A",
"FUNCTIONAL_CAT": "_X",
"SECURITISATION_TYP": "_X"
}Record 2STO: LE · TPH: V
{
"STO": "LE",
"TPH": "V",
"FREQ": "Q",
"MA_FLAG": "A",
"MATURITY": "S",
"NOM_CURR": "_T",
"DEBT_TYPE": "_X",
"OBS_VALUE": 45.04535,
"VALUATION": "M",
"IS_IN_EADB": "A",
"HOLDER_AREA": "I8",
"INSTR_ASSET": "F3",
"ISSUER_AREA": "4Y",
"TIME_PERIOD": "2021-Q4",
"UNIT_MEASURE": "EUR",
"COMPILING_ORG": "ZZZ",
"HOLDER_SECTOR": "S11",
"ISSUER_SECTOR": "S1N",
"SECURITY_TYPE": "A",
"FUNCTIONAL_CAT": "_X",
"SECURITISATION_TYP": "_X"
}Record 3STO: LE · TPH: V
{
"STO": "LE",
"TPH": "V",
"FREQ": "Q",
"MA_FLAG": "A",
"MATURITY": "_Z",
"NOM_CURR": "_T",
"DEBT_TYPE": "_X",
"OBS_VALUE": 0,
"VALUATION": "M",
"IS_IN_EADB": "A",
"HOLDER_AREA": "I8",
"INSTR_ASSET": "F511",
"ISSUER_AREA": "4Y",
"TIME_PERIOD": "2019-Q4",
"UNIT_MEASURE": "EUR",
"COMPILING_ORG": "ZZZ",
"HOLDER_SECTOR": "S11",
"ISSUER_SECTOR": "S1N",
"SECURITY_TYPE": "A",
"FUNCTIONAL_CAT": "_X",
"SECURITISATION_TYP": "_X"
}Record 4STO: LE · TPH: V
{
"STO": "LE",
"TPH": "V",
"FREQ": "Q",
"MA_FLAG": "A",
"MATURITY": "_Z",
"NOM_CURR": "_T",
"DEBT_TYPE": "_X",
"OBS_VALUE": 0,
"VALUATION": "M",
"IS_IN_EADB": "A",
"HOLDER_AREA": "I8",
"INSTR_ASSET": "F52",
"ISSUER_AREA": "4Y",
"TIME_PERIOD": "2019-Q4",
"UNIT_MEASURE": "EUR",
"COMPILING_ORG": "ZZZ",
"HOLDER_SECTOR": "S11",
"ISSUER_SECTOR": "S1N",
"SECURITY_TYPE": "A",
"FUNCTIONAL_CAT": "_X",
"SECURITISATION_TYP": "_X"
}Record 5STO: LE · TPH: V
{
"STO": "LE",
"TPH": "V",
"FREQ": "Q",
"MA_FLAG": "A",
"MATURITY": "L",
"NOM_CURR": "_T",
"DEBT_TYPE": "_X",
"OBS_VALUE": 40171.8228,
"VALUATION": "M",
"IS_IN_EADB": "A",
"HOLDER_AREA": "I8",
"INSTR_ASSET": "F3",
"ISSUER_AREA": "4Y",
"TIME_PERIOD": "2022-Q1",
"UNIT_MEASURE": "EUR",
"COMPILING_ORG": "ZZZ",
"HOLDER_SECTOR": "S12P",
"ISSUER_SECTOR": "S1N",
"SECURITY_TYPE": "A",
"FUNCTIONAL_CAT": "_X",
"SECURITISATION_TYP": "_X"
}Live sample captured at profiling time — values may have changed upstream.
Verification Status
Using the API
Query examples
curl -s 'https://data-api.ecb.europa.eu/service/dataflow/ECB' -H 'Accept: application/vnd.sdmx.structure+xml;version=2.1'All dataflows (datasets) published by this agency, as SDMX-ML.
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.