Query data from a BFS STAT-TAB table
query_bfs_tableFetch labelled figures from STAT-TAB tables by mapping variables to values; omitted variables default to totals or latest periods, and selections can use ranges or all values.
Instructions
Fetch labelled figures from any STAT-TAB table. 'selection' maps variables (code or label, case/accents ignored) to values (codes or labels); '' = all values, 'latest' / 'latest:5' = last period(s), '2015-2020' = year range. Unspecified variables default to their total (e.g. 'Schweiz', 'Total') or the latest period, and the response lists every default applied. Max 5000 cells per query. Returns rows like {Kanton:'Zürich', value:1605508} plus 'fixed' for single-valued dimensions. Example: {table_id:'px-x-0102010000_101', selection:{Jahr:['latest'], Kanton:['Zürich','Bern'], Geschlecht:['']}}.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table_id": "<table_id>"
},
"name": "query_bfs_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| lang | No | Language of titles/labels: de, fr, it or en (default en) | en |
| limit | No | Max rows returned | |
| table_id | Yes | Table id like 'px-x-0102010000_101' | |
| selection | No | Map variable → values, e.g. {"Jahr": ["latest"], "Kanton": ["*"]} | |
| include_codes | No | Also return value codes next to labels |