Deutsche Bundesbank — Securities holdings (BBSAP)

DatasetExecutable4/7Query nowOpen workbench Subscribe🇩🇪Germany

Securities holdings (BBSAP) — official time series from the Deutsche Bundesbank, published as the BBSAP dataflow over SDMX 2.1 REST. One endpoint serves XML (SDMX-ML), CSV (?format=csv) and JSON (?format=json); extract exactly the series you need with a key path and startPeriod / endPeriod / lastNObservations filters.

economyprices

Run verified request Dataflow structure Fetch observations (JSON)Read the docs Visit homepage

Data schema (26 fields)

Filterable via the API (16)

BBK_STD_FREQBBK_SEH_SHS_SOURCEBBK_SEH_AMOUNT_TYPEBBK_SEH_CUSTODIANBBK_SEH_HOLDER_SECTORBBK_SEH_HOLDER_AREABBK_SEH_ISS_SECTORBBK_SEH_ISS_AREABBK_SEH_ESA_INSTRBBK_SEH_MATURITY_ORIGBBK_SEH_MATURITY_RESTBBK_SEH_ISS_CURRENCYBBK_SEH_VALUATIONBBK_SEH_STOCK_TYPEBBK_SEH_UNITTIME_PERIOD

Click a field to see example values.

Field	Type	Description
BBK_STD_FREQ	dimension	1 codes (e.g. M)
BBK_SEH_SHS_SOURCE	dimension	1 codes (e.g. _X)
BBK_SEH_AMOUNT_TYPE	dimension	1 codes (e.g. LE)
BBK_SEH_CUSTODIAN	dimension	9 codes (e.g. BG01, BG06, BG07)
BBK_SEH_HOLDER_SECTOR	dimension	9 codes (e.g. 1000, 1100, 1200)
BBK_SEH_HOLDER_AREA	dimension	3 codes (e.g. A1, U6, Z9)
BBK_SEH_ISS_SECTOR	dimension	4 codes (e.g. S_1, S_11, S_12)
BBK_SEH_ISS_AREA	dimension	5 codes (e.g. A1, U5, U6)
BBK_SEH_ESA_INSTR	dimension	4 codes (e.g. F_3, F_51, F_52)
BBK_SEH_MATURITY_ORIG	dimension	1 codes (e.g. _X)
BBK_SEH_MATURITY_REST	dimension	1 codes (e.g. _X)
BBK_SEH_ISS_CURRENCY	dimension	1 codes (e.g. Z01)
BBK_SEH_VALUATION	dimension	2 codes (e.g. M, N)
BBK_SEH_STOCK_TYPE	dimension	1 codes (e.g. B)
BBK_SEH_UNIT	dimension	2 codes (e.g. EUR, PURE_NUMB)
TIME_PERIOD	time	Time dimension — filter with startPeriod / endPeriod query params.
OBS_VALUEObservation value	number	The observed numeric value for each cell.
TIME_FORMAT	attribute	—
BBK_DECIMALS	attribute	—
BBK_ID	attribute	—
BBK_UNIT	attribute	—
BBK_UNIT_MULT	attribute	—
BBK_TITLE_ENG	attribute	—
WEB_CATEGORY	attribute	—
BBK_DIFF	attribute	—
BBK_DIFF_Y	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.

Where=

Sort by

Sample data (5 records)

Record 1OBS_VALUE: 754772 · TIME_PERIOD: 2013-01

{
  "OBS_VALUE": "754772",
  "TIME_PERIOD": "2013-01",
  "BBK_SEH_UNIT": "EUR",
  "BBK_STD_FREQ": "M",
  "BBK_SEH_ISS_AREA": "A1",
  "BBK_SEH_CUSTODIAN": "BG01",
  "BBK_SEH_ESA_INSTR": "F_3",
  "BBK_SEH_VALUATION": "M",
  "BBK_SEH_ISS_SECTOR": "S_1",
  "BBK_SEH_SHS_SOURCE": "_X",
  "BBK_SEH_STOCK_TYPE": "B",
  "BBK_SEH_AMOUNT_TYPE": "LE",
  "BBK_SEH_HOLDER_AREA": "A1",
  "BBK_SEH_ISS_CURRENCY": "Z01",
  "BBK_SEH_HOLDER_SECTOR": "1000",
  "BBK_SEH_MATURITY_ORIG": "_X",
  "BBK_SEH_MATURITY_REST": "_X"
}

Record 2OBS_VALUE: 763915 · TIME_PERIOD: 2013-02

{
  "OBS_VALUE": "763915",
  "TIME_PERIOD": "2013-02",
  "BBK_SEH_UNIT": "EUR",
  "BBK_STD_FREQ": "M",
  "BBK_SEH_ISS_AREA": "A1",
  "BBK_SEH_CUSTODIAN": "BG01",
  "BBK_SEH_ESA_INSTR": "F_3",
  "BBK_SEH_VALUATION": "M",
  "BBK_SEH_ISS_SECTOR": "S_1",
  "BBK_SEH_SHS_SOURCE": "_X",
  "BBK_SEH_STOCK_TYPE": "B",
  "BBK_SEH_AMOUNT_TYPE": "LE",
  "BBK_SEH_HOLDER_AREA": "A1",
  "BBK_SEH_ISS_CURRENCY": "Z01",
  "BBK_SEH_HOLDER_SECTOR": "1000",
  "BBK_SEH_MATURITY_ORIG": "_X",
  "BBK_SEH_MATURITY_REST": "_X"
}

Record 3OBS_VALUE: 758594 · TIME_PERIOD: 2013-03

{
  "OBS_VALUE": "758594",
  "TIME_PERIOD": "2013-03",
  "BBK_SEH_UNIT": "EUR",
  "BBK_STD_FREQ": "M",
  "BBK_SEH_ISS_AREA": "A1",
  "BBK_SEH_CUSTODIAN": "BG01",
  "BBK_SEH_ESA_INSTR": "F_3",
  "BBK_SEH_VALUATION": "M",
  "BBK_SEH_ISS_SECTOR": "S_1",
  "BBK_SEH_SHS_SOURCE": "_X",
  "BBK_SEH_STOCK_TYPE": "B",
  "BBK_SEH_AMOUNT_TYPE": "LE",
  "BBK_SEH_HOLDER_AREA": "A1",
  "BBK_SEH_ISS_CURRENCY": "Z01",
  "BBK_SEH_HOLDER_SECTOR": "1000",
  "BBK_SEH_MATURITY_ORIG": "_X",
  "BBK_SEH_MATURITY_REST": "_X"
}

Record 4OBS_VALUE: 756419 · TIME_PERIOD: 2013-04

{
  "OBS_VALUE": "756419",
  "TIME_PERIOD": "2013-04",
  "BBK_SEH_UNIT": "EUR",
  "BBK_STD_FREQ": "M",
  "BBK_SEH_ISS_AREA": "A1",
  "BBK_SEH_CUSTODIAN": "BG01",
  "BBK_SEH_ESA_INSTR": "F_3",
  "BBK_SEH_VALUATION": "M",
  "BBK_SEH_ISS_SECTOR": "S_1",
  "BBK_SEH_SHS_SOURCE": "_X",
  "BBK_SEH_STOCK_TYPE": "B",
  "BBK_SEH_AMOUNT_TYPE": "LE",
  "BBK_SEH_HOLDER_AREA": "A1",
  "BBK_SEH_ISS_CURRENCY": "Z01",
  "BBK_SEH_HOLDER_SECTOR": "1000",
  "BBK_SEH_MATURITY_ORIG": "_X",
  "BBK_SEH_MATURITY_REST": "_X"
}

Record 5OBS_VALUE: 758866 · TIME_PERIOD: 2013-05

{
  "OBS_VALUE": "758866",
  "TIME_PERIOD": "2013-05",
  "BBK_SEH_UNIT": "EUR",
  "BBK_STD_FREQ": "M",
  "BBK_SEH_ISS_AREA": "A1",
  "BBK_SEH_CUSTODIAN": "BG01",
  "BBK_SEH_ESA_INSTR": "F_3",
  "BBK_SEH_VALUATION": "M",
  "BBK_SEH_ISS_SECTOR": "S_1",
  "BBK_SEH_SHS_SOURCE": "_X",
  "BBK_SEH_STOCK_TYPE": "B",
  "BBK_SEH_AMOUNT_TYPE": "LE",
  "BBK_SEH_HOLDER_AREA": "A1",
  "BBK_SEH_ISS_CURRENCY": "Z01",
  "BBK_SEH_HOLDER_SECTOR": "1000",
  "BBK_SEH_MATURITY_ORIG": "_X",
  "BBK_SEH_MATURITY_REST": "_X"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Distribution check returned HTTP 413

Using the API

Query examples

curl -s 'https://api.statistiken.bundesbank.de/rest/metadata/dataflow/BBK' -H 'Accept: application/vnd.sdmx.structure+xml;version=2.1'

All dataflows (datasets) published by this agency, as SDMX-ML.

Full API documentation ↗

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.