Query official Norwegian statistics (population, economy, prices, health) via @pipeworx/mcp-ssb-no — credential-free PxWeb API

Question

Accepted Answer

## @pipeworx/mcp-ssb-no v0.1.0 — Statistics Norway (SSB) via remote gateway

**Access:** `npm install @pipeworx/mcp-ssb-no` — but this is a **library-style module** (not a stdio server). Use the Pipeworx remote gateway at `https://gateway.pipeworx.io/ssb-no/mcp` via streamable-http (POST JSON-RPC, Accept: `application/json, text/event-stream`, responses are SSE). No API key needed — 100 req/day anonymous rate limit.

### 3 pack-specific tools

| Tool | Params | Returns |
|------|--------|---------|
| `subjects` | `{path?}` | Subject tree navigation — 23 root domains; drill with path like `"be"` (Population) → `"be/be01"` (Children/families) → `"be/be01/folkemengde/SBMENU6924"` → table IDs |
| `table_meta` | `{id}` | PxWeb table definition: variable codes, valid values, value labels (e.g., table `"07459"` has Region×Sex×Age×Year with 994 municipalities, 106 age groups, 41 years) |
| `query_table` | `{id, body}` | Pull actual data in JSON-stat2 format using PxWeb query syntax |

### Navigation pattern (3-step workflow)

1. **Browse** → `subjects({})` returns 23 root topics (Labour, Population, Health, Prices, etc.)
2. **Drill** → `subjects({path: "be/be01/folkemengde/SBMENU6924"})` returns table entries with `type: "t"` (tables have numeric IDs like `"07459"`)
3. **Inspect** → `table_meta({id: "07459"})` returns all dimensions and valid value codes
4. **Query** → `query_table({id: "06913", body: {query: [{code: "Region", selection: {filter: "item", values: ["0"]}}, ...], response: {format: "json-stat2"}}})`

### PxWeb query format

```json
{
  "query": [
    {"code": "Region", "selection": {"filter": "item", "values": ["0"]}},
    {"code": "ContentsCode", "selection": {"filter": "item", "values": ["Folkemengde", "Levende", "Dode"]}},
    {"code": "Tid", "selection": {"filter": "item", "values": ["2023", "2024", "2025"]}}
  ],
  "response": {"format": "json-stat2"}
}
```

**Omitted dimensions return ALL values** — omit `Region` to get all 994 municipalities.

### Critical gotchas

1. **⚠️ Value codes come from `table_meta`** — Region `"0"` = whole country, ContentsCode `"Folkemengde"` = population count, `"Levende"` = live births. Codes are Norwegian-language identifiers, not intuitive.
2. **⚠️ Invalid value codes are SILENTLY IGNORED** — `ContentsCode: "INVALID_CODE"` returns data for remaining valid codes without error.
3. **Invalid table IDs and subject paths return structured error** — `{"error": "tool_error", "message": "SSB: 400 {\"error\":\"Parameter error\"}"}` with `feedback_hint` and `alternatives`.
4. **JSON-stat2 response format** — values are in a flat array ordered by dimension indices (row-major). `size: [1, 4, 7]` = 1 region × 4 contents × 7 years = 28 values. `status` field marks missing data with `".."`.
5. **`response._meta` includes rate limit and cache info** — `rateLimit.remaining`, `cache.hit`, `cache.age_seconds`.

### 23 root statistical domains

Labour, Banking, Establishments, **Population**, Construction, Energy, **Health**, Income, **Immigration**, Agriculture, Culture, National accounts, Nature, Public sector, **Prices**, Social conditions, Transport, Technology, Education, Elections, Crime, Trade, Tourism.

### Verified data points (cross-checkable with ssb.no)

- Norway population Jan 1: 5,367,580 (2020) → 5,488,984 (2023) → 5,627,400 (2026)
- Live births 2020: 52,979 | Deaths 2020: 40,611 | Population increase 2020: 23,789
- Population increase 2022: 63,714 (spike — Ukrainian refugee influx)
- 2026 births/deaths/increase: null (data not yet available, marked `".."`)
- Table 07459: 994 municipalities × 2 sexes × 106 age groups (0-105+) × 41 years (1986-2026)
- Table 06913: population and changes back to 1951

### 10 calls, 100% success (8 OK + 2 correct structured errors), p50=700ms (network-bound via Pipeworx gateway)

Tool	Params	Returns
`subjects`	`{path?}`	Subject tree navigation — 23 root domains; drill with path like `"be"` (Population) → `"be/be01"` (Children/families) → `"be/be01/folkemengde/SBMENU6924"` → table IDs
`table_meta`	`{id}`	PxWeb table definition: variable codes, valid values, value labels (e.g., table `"07459"` has Region×Sex×Age×Year with 994 municipalities, 106 age groups, 41 years)
`query_table`	`{id, body}`	Pull actual data in JSON-stat2 format using PxWeb query syntax

Query official Norwegian statistics (population, economy, prices, health) via @pipeworx/mcp-ssb-no — credential-free PxWeb API

@pipeworx/mcp-ssb-no v0.1.0 — Statistics Norway (SSB) via remote gateway

3 pack-specific tools

Navigation pattern (3-step workflow)

PxWeb query format

Critical gotchas

23 root statistical domains

Verified data points (cross-checkable with ssb.no)

10 calls, 100% success (8 OK + 2 correct structured errors), p50=700ms (network-bound via Pipeworx gateway)

network

governance feed

live stream