Deutsche Bundesbank — Direct investment transactions (publication level) (BBFFDITV)

DatasetExecutable4/7Query nowOpen workbench Subscribe🇩🇪Germany

Direct investment transactions (publication level) (BBFFDITV) — official time series from the Deutsche Bundesbank, published as the BBFFDITV 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 (29 fields)

Filterable via the API (19)

BBK_STD_FREQBBK_ES_MEASURE_PRINCIPLEBBK_ES_AREA_REFERENCEBBK_ES_AREA_COUNTERPARTBBK_ES_SECTOR_REFERENCEBBK_ES_LEVEL_COUNTERPARTBBK_ES_FLOW_STOCK_ENTRYBBK_ES_ACCOUNTING_ENTRYBBK_ES_ACCOUNTING_ITEMBBK_ES_FUNCTIONAL_CATBBK_ES_INSTR_ASSETBBK_ES_TYPE_ENTITYBBK_ES_MEASURE_UNITBBK_ES_FDI_RELATIONSHIPBBK_ES_VALUATIONBBK_ES_STAT_UNITBBK_ES_ACTIVITYBBK_ES_ACTIVITY_ALLOCTIME_PERIOD

Click a field to see example values.

Field	Type	Description
BBK_STD_FREQ	dimension	1 codes (e.g. A)
BBK_ES_MEASURE_PRINCIPLE	dimension	3 codes (e.g. A, DI, DO)
BBK_ES_AREA_REFERENCE	dimension	1 codes (e.g. DE)
BBK_ES_AREA_COUNTERPART	dimension	254 codes (e.g. W1, A1, A2)
BBK_ES_SECTOR_REFERENCE	dimension	1 codes (e.g. S1)
BBK_ES_LEVEL_COUNTERPART	dimension	1 codes (e.g. IMC)
BBK_ES_FLOW_STOCK_ENTRY	dimension	1 codes (e.g. T)
BBK_ES_ACCOUNTING_ENTRY	dimension	8 codes (e.g. A, AD, AI)
BBK_ES_ACCOUNTING_ITEM	dimension	1 codes (e.g. FA)
BBK_ES_FUNCTIONAL_CAT	dimension	1 codes (e.g. D)
BBK_ES_INSTR_ASSET	dimension	6 codes (e.g. F51A___ES, F51A___UA, F)
BBK_ES_TYPE_ENTITY	dimension	1 codes (e.g. ALL)
BBK_ES_MEASURE_UNIT	dimension	1 codes (e.g. EUR)
BBK_ES_FDI_RELATIONSHIP	dimension	1 codes (e.g. I)
BBK_ES_VALUATION	dimension	1 codes (e.g. _X)
BBK_ES_STAT_UNIT	dimension	1 codes (e.g. _X)
BBK_ES_ACTIVITY	dimension	43 codes (e.g. A, B, C)
BBK_ES_ACTIVITY_ALLOC	dimension	3 codes (e.g. 1, 2, _Z)
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_Y	attribute	—
OBS_STATUS	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: 18.702 · TIME_PERIOD: 2008

{
  "OBS_VALUE": "18.702",
  "TIME_PERIOD": "2008",
  "BBK_STD_FREQ": "A",
  "BBK_ES_ACTIVITY": "A",
  "BBK_ES_STAT_UNIT": "_X",
  "BBK_ES_VALUATION": "_X",
  "BBK_ES_INSTR_ASSET": "F51A___ES",
  "BBK_ES_TYPE_ENTITY": "ALL",
  "BBK_ES_MEASURE_UNIT": "EUR",
  "BBK_ES_ACTIVITY_ALLOC": "1",
  "BBK_ES_AREA_REFERENCE": "DE",
  "BBK_ES_FUNCTIONAL_CAT": "D",
  "BBK_ES_ACCOUNTING_ITEM": "FA",
  "BBK_ES_ACCOUNTING_ENTRY": "A",
  "BBK_ES_AREA_COUNTERPART": "W1",
  "BBK_ES_FDI_RELATIONSHIP": "I",
  "BBK_ES_FLOW_STOCK_ENTRY": "T",
  "BBK_ES_SECTOR_REFERENCE": "S1",
  "BBK_ES_LEVEL_COUNTERPART": "IMC",
  "BBK_ES_MEASURE_PRINCIPLE": "A"
}

Record 2OBS_VALUE: 31.113 · TIME_PERIOD: 2009

{
  "OBS_VALUE": "31.113",
  "TIME_PERIOD": "2009",
  "BBK_STD_FREQ": "A",
  "BBK_ES_ACTIVITY": "A",
  "BBK_ES_STAT_UNIT": "_X",
  "BBK_ES_VALUATION": "_X",
  "BBK_ES_INSTR_ASSET": "F51A___ES",
  "BBK_ES_TYPE_ENTITY": "ALL",
  "BBK_ES_MEASURE_UNIT": "EUR",
  "BBK_ES_ACTIVITY_ALLOC": "1",
  "BBK_ES_AREA_REFERENCE": "DE",
  "BBK_ES_FUNCTIONAL_CAT": "D",
  "BBK_ES_ACCOUNTING_ITEM": "FA",
  "BBK_ES_ACCOUNTING_ENTRY": "A",
  "BBK_ES_AREA_COUNTERPART": "W1",
  "BBK_ES_FDI_RELATIONSHIP": "I",
  "BBK_ES_FLOW_STOCK_ENTRY": "T",
  "BBK_ES_SECTOR_REFERENCE": "S1",
  "BBK_ES_LEVEL_COUNTERPART": "IMC",
  "BBK_ES_MEASURE_PRINCIPLE": "A"
}

Record 3OBS_VALUE: 3.278 · TIME_PERIOD: 2010

{
  "OBS_VALUE": "3.278",
  "TIME_PERIOD": "2010",
  "BBK_STD_FREQ": "A",
  "BBK_ES_ACTIVITY": "A",
  "BBK_ES_STAT_UNIT": "_X",
  "BBK_ES_VALUATION": "_X",
  "BBK_ES_INSTR_ASSET": "F51A___ES",
  "BBK_ES_TYPE_ENTITY": "ALL",
  "BBK_ES_MEASURE_UNIT": "EUR",
  "BBK_ES_ACTIVITY_ALLOC": "1",
  "BBK_ES_AREA_REFERENCE": "DE",
  "BBK_ES_FUNCTIONAL_CAT": "D",
  "BBK_ES_ACCOUNTING_ITEM": "FA",
  "BBK_ES_ACCOUNTING_ENTRY": "A",
  "BBK_ES_AREA_COUNTERPART": "W1",
  "BBK_ES_FDI_RELATIONSHIP": "I",
  "BBK_ES_FLOW_STOCK_ENTRY": "T",
  "BBK_ES_SECTOR_REFERENCE": "S1",
  "BBK_ES_LEVEL_COUNTERPART": "IMC",
  "BBK_ES_MEASURE_PRINCIPLE": "A"
}

Record 4OBS_VALUE: 25.973 · TIME_PERIOD: 2011

{
  "OBS_VALUE": "25.973",
  "TIME_PERIOD": "2011",
  "BBK_STD_FREQ": "A",
  "BBK_ES_ACTIVITY": "A",
  "BBK_ES_STAT_UNIT": "_X",
  "BBK_ES_VALUATION": "_X",
  "BBK_ES_INSTR_ASSET": "F51A___ES",
  "BBK_ES_TYPE_ENTITY": "ALL",
  "BBK_ES_MEASURE_UNIT": "EUR",
  "BBK_ES_ACTIVITY_ALLOC": "1",
  "BBK_ES_AREA_REFERENCE": "DE",
  "BBK_ES_FUNCTIONAL_CAT": "D",
  "BBK_ES_ACCOUNTING_ITEM": "FA",
  "BBK_ES_ACCOUNTING_ENTRY": "A",
  "BBK_ES_AREA_COUNTERPART": "W1",
  "BBK_ES_FDI_RELATIONSHIP": "I",
  "BBK_ES_FLOW_STOCK_ENTRY": "T",
  "BBK_ES_SECTOR_REFERENCE": "S1",
  "BBK_ES_LEVEL_COUNTERPART": "IMC",
  "BBK_ES_MEASURE_PRINCIPLE": "A"
}

Record 5OBS_VALUE: 11.408 · TIME_PERIOD: 2012

{
  "OBS_VALUE": "11.408",
  "TIME_PERIOD": "2012",
  "BBK_STD_FREQ": "A",
  "BBK_ES_ACTIVITY": "A",
  "BBK_ES_STAT_UNIT": "_X",
  "BBK_ES_VALUATION": "_X",
  "BBK_ES_INSTR_ASSET": "F51A___ES",
  "BBK_ES_TYPE_ENTITY": "ALL",
  "BBK_ES_MEASURE_UNIT": "EUR",
  "BBK_ES_ACTIVITY_ALLOC": "1",
  "BBK_ES_AREA_REFERENCE": "DE",
  "BBK_ES_FUNCTIONAL_CAT": "D",
  "BBK_ES_ACCOUNTING_ITEM": "FA",
  "BBK_ES_ACCOUNTING_ENTRY": "A",
  "BBK_ES_AREA_COUNTERPART": "W1",
  "BBK_ES_FDI_RELATIONSHIP": "I",
  "BBK_ES_FLOW_STOCK_ENTRY": "T",
  "BBK_ES_SECTOR_REFERENCE": "S1",
  "BBK_ES_LEVEL_COUNTERPART": "IMC",
  "BBK_ES_MEASURE_PRINCIPLE": "A"
}

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

Verification Status

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.