`destatis_table`

Pack: destatis · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/destatis_table for the schema, then POST the same URL with its arguments for the data.

Fetch a Destatis GENESIS statistical table’s data by its code (get codes from destatis_search), e.g. “12411-0001” (population) or “61111-0001” (consumer price index). Returns the table content (values across its dimensions) plus title. Germany-wide and by Land where the table provides it. A table can offer only a coarse level (e.g. 48112-0001 is WZ sections A-S only; the 4-digit industry rows are in the sibling 48112-0002): call with structure:true to see its dimensions, then filter with classifying_key1 (e.g. WZ08-9200 for gambling and betting) and start_year/end_year. A filtered call takes 12-20s.

Parameters

Name	Type	Required	Description
`table_code`	string	yes	GENESIS table code, e.g. “12411-0001”.
`structure`	boolean	no	true = return the table’s dimensions (variables, time range, classification levels) instead of data. Use it to learn which classification keys a table offers before filtering.
`classifying_key1`	string	no	Filter the table’s 1st classifying variable to these keys (comma-separated, e.g. “WZ08-92” for lotteries/betting in an industry table). Without a filter GENESIS may return only the top level (e.g. WZ sections).
`classifying_key2`	string	no	Same, 2nd classifying variable.
`classifying_key3`	string	no	Same, 3rd classifying variable.
`classifying_variable1`	string	no	Name of the 1st classifying variable (from structure:true), e.g. “WZ08”. Optional.
`classifying_variable2`	string	no	Name of the 2nd classifying variable. Optional.
`classifying_variable3`	string	no	Name of the 3rd classifying variable. Optional.
`start_year`	string	no	First year, e.g. “2022”.
`end_year`	string	no	Last year, e.g. “2024”.
`area`	string	no	GENESIS area: free (default), public, all, user.

Example call

Arguments

{
  "table_code": "12411-0001",
  "_apiKey": "your-destatis-api-key"
}

curl

curl -X POST https://gateway.pipeworx.io/destatis/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"destatis_table","arguments":{"table_code":"12411-0001","_apiKey":"your-destatis-api-key"}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('destatis_table', {
  "table_code": "12411-0001",
  "_apiKey": "your-destatis-api-key"
});

More examples

{
  "table_code": "61111-0001",
  "_apiKey": "your-destatis-api-key"
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the destatis pack

{
  "mcpServers": {
    "destatis": {
      "url": "https://gateway.pipeworx.io/destatis/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

destatis_table