Ground Microsoft 365 Copilot, Claude & ChatGPT in 25+ Official National Statistical Offices.
Connect directly to Statistics Finland (StatFin, Paavo & Municipal Key Figures), Natural Resources Institute Finland (Luke), Statistics Sweden (SCB), Statistics Norway (SSB), Swiss Federal Statistical Office (BFS STAT-TAB), Statistics Estonia, and more — with < 2 ms RAM caching, automatic municipality/postal code resolution, and mandatory CC BY 4.0 source attribution.
| Municipality | Population | Households | | Stockholm | 995 574 | Verified | | Tampere | 263 337 | 64 197 | Provenance: Region=['0180'] | Alue=['KU837'] (Fail-Closed Verified) Source: Official Statistical Offices (StatFin / SCB), CC BY 4.0
3 High-Impact Use Cases Across M365 Copilot, Claude & Antigravity
Interactive Live API Playground (Real-Time Query from Hamina Cloud Run RAM Cache)
Click any preset below to execute a real POST /api/v1/query request against official national statistical APIs:
Engineered by Enterprise Software Architects — Built for Real-World Planning & Next-Gen Agentic Processes
When official statistics drive urban planning, environmental impact assessments (EIA), municipal budgets, economic research, or new multi-step agentic processes, lightweight wrapper scripts are not enough. PxBridge is designed and maintained by senior software architects whose mission-critical business systems have processed over 300 million EUR in revenue volume — and continue to process tens of millions of EUR annually. We bring the exact same audit-grade engineering discipline to connecting official statistics and AI agents, verifying every source and every filter deterministically.
Even when an organization needs only a single country's statistics, raw API calls and simple scripts fail or hallucinate due to technical constraints: PxWeb requires internal codes (KU837 for Tampere, 0180 for Stockholm), 300+ municipalities or 3,000 postal codes overflow the LLM context window, and naive wrappers silently drop unrecognized filters or misread suppressed cells (..) as zeros. PxBridge solves this with four architectural guarantees:
Instead of a single base endpoint, PxBridge unifies all national PxWeb instances (e.g., StatFin, Paavo postal codes, Municipal Key Figures, Luke, and ÅSUB in Finland, plus SCB, SSB, BFS, Statistikaamet and 20+ countries) in RAM (/tmp/app_cache in Google Cloud Hamina)—saving 70–95% of LLM context tokens.
Our word-boundary semantic resolver strictly separates municipality, province, and postal code hierarchies, auto-fills missing totals (SSS / Total), and preserves statistical suppression symbols (..). PxBridge never silently drops invalid filters (Fail-Closed) and appends a deterministic Query Provenance Audit Trail + CC BY 4.0 citation to every table.
Works out of the box in Microsoft 365 Copilot, Claude, and ChatGPT, as well as inside automated multi-step agentic workflows, PowerBI, and Excel (Markdown, CSV, JSON, JSON-stat2)—shielding all integrations from the ongoing PxWeb v1 to PxWebApi 2.0 (v2) transition. All 25+ offices are unlocked in every tier, including 0 EUR Free Explorer.
Architectural Comparison: Why Web Search, Raw PxWeb APIs & Lightweight Local Scripts Fall Short
| Ratkaisutapa | Pääsy PxWeb POST -kuutioihin | Koodinratkaisu & Kontekstisäästö | Audit Trail (Query Provenance) | Toimivuus M365 Copilot / Claude.ai / Lukitut työasemat |
|---|---|---|---|---|
Tavallinen verkkohaku (web_search) |
Ei pääsyä (hakukoneet eivät indeksoi POST-tauluja; löytää vain vanhoja tiedotteita) | Korkea hallusinaatio- ja vanhentuneen tiedon riski | Ei parametrijalanjälkeä | Toimii selaimessa, mutta antaa epäluotettavia tai puutteellisia lukuja |
| Raaka PxWeb REST API | Kyllä, mutta suorat tekoälykutsut kaatuvat herkästi 400 Bad Request -virheeseen |
Vaatii sisäiset koodit (KU837); JSON-Stat2 ja 8 000 solun rajoitukset tukkivat muistin |
Ei automaattista tarkistusta | Katkeaa virastojen 10 req / 10 s rajoituksiin |
Kevyt lokaali R / Python / stdio -skripti |
Yleensä vain 1 kanta (ei yhdistä StatFinia, Paavoa ja Lukea tai v1/v2-murrosta) | Naiivi tekstihaku voi sekoittaa aluehierarkiat tai pudottaa rajauksen hiljaisesti | Ei automaattista Query Provenance -varmennusta | Ei toimi lukituilla kuntien/yritysten työasemilla eikä pilvi-Copilotissa |
| PxBridge MCP & Semanttinen REST Pilvisilta | 100 % suora yhteys 25+ virastoon (Suomessa 5 kantaa: StatFin, Paavo, Kuntien avainluvut, Luke, ÅSUB) | < 2 ms RAM-haku, adaptiivinen selectable_values & aluehierarkiasuoja |
Automaattinen Query Provenance + Fail-Closed + CC BY 4.0 | Valmis pilvipalvelu (Hamina EU, Zero PII) — ihmisten työpöydälle ja agenttiprosesseihin |
Verified Live Catalog Snapshot (Available Across All Tiers Including Free Explorer)
Virasto / Agency (agency_id) | Virallinen Rajapinta | Esimerkkitauluja (table_uid) & Sisältö | Saatavuus |
|---|---|---|---|
Tilastokeskus StatFin & Kuntien avainluvut (fi_statfin, fi_kuntien_avainluvut) |
pxdata.stat.fi |
fi_kuntien_avainluvut:142h.px (Kuntien avainluvut 1987–2025), fi_statfin:11ra.px (Väestörakenne, työllisyys, aluetalous) |
Kaikki tasot (myös 0 € Free) |
Tilastokeskus Paavo (fi_paavo) |
pxdata.stat.fi |
fi_paavo:12ey.px / postinumeroalue_4_20260101 (Postinumeroalueiden väestö, ikärakenne, tulot, asuntokanta, työpaikat) |
Kaikki tasot (myös 0 € Free) |
Luonnonvarakeskus Luke (fi_luke) |
statdb.luke.fi |
fi_luke:0200_yrirak.px (Maatalous- ja puutarhayritysten rakenne ELY-keskuksittain), fi_luke:0100_yrirak.px (Kunnittain), metsävarat, hakkuut, kalastus & riista |
Kaikki tasot (myös 0 € Free) |
SCB, SSB, BFS & Statistikaamet (se_scb, no_ssb, ch_bfs, ee_stat) |
api.scb.se, data.ssb.no, andmed.stat.ee |
se_scb:BE0101N1 (Ruotsin kunnat), no_ssb:07459 (Norjan kunnat), ee_stat:RV021 (Viron väestö) + 20 muuta maata |
Kaikki tasot (myös 0 € Free) |
Copy-Paste Grounding System Prompt (For Claude Projects, Custom GPTs & Copilot Agents)
Käytä virallisten tilastojen hakuun aina PxBridge MCP -palvelinta: 1. Etsi sopiva taulu (px_search_tables) ja tarkista sen valintavaihtoehdot (px_get_table_metadata). Käytä metadata-vastauksen valmiita 'selectable_values'-vaihtoehtoja arvaamisen sijaan. 2. Suorita kysely (px_execute_query). PxBridge palauttaa datan ohella kyselyjalanjäljen (provenance), joka erittelee sekä pyydetyt parametrit että todelliset suoritetut rajaukset. 3. Esitä loppukäyttäjälle aina tilastotaulukon yhteydessä suoraan PxBridgen tuottama virallinen lähdeviite (CC BY 4.0) ja kyselyparametrijalanjälki, jotta tulos on täysin auditoitavissa ja toistettavissa yhdellä silmäyksellä.
Vendor Stability, 10-Year Continuity Commitment (2026–2036) & Answers to Critical Questions
When an organization adopts an external statistical gateway for decision-making and agentic workflows, vendor continuity, security architecture, and cost structure must be verifiable without marketing hype:
Positive Productions Oy (founded 2010, Business ID 2355279-9, Helsinki & Joensuu, Finland) is a profitable software architecture firm with ~0.5M EUR in annual company revenue, while the production ERP, ordering, contracting, and marketplace systems we engineer and maintain process ~20M EUR annually (and over 300M EUR cumulatively) in our clients' core business revenue. This ratio proves both high system reliability and fair pricing: we do not extract bloated revenue-share fees from our clients.
We operate with a 6-person team where everyone codes and work is led by senior software architects, available every business day under our maintenance agreements (with stricter SLAs available when required). Over more than a decade of operations, our systems stay up during holiday seasons without requiring massive 24/7 firefighting shifts—because stability is built through proactive software architecture.
We give the exact same 10-year continuity commitment to all our maintenance and ERP clients. Our specialists have supported our current core clients for more than 5 years prior to our company's founding in 2010—meaning our longest client relationships span over two decades. We are a member of Code from Finland (Koodia Suomesta ry), and CEO & Chief Architect Pekka Nurmela (HHJ) serves on the Board of Helsinki Entrepreneurs and as Chairman of South Helsinki Entrepreneurs (EHY).
As workflows move to AI-to-AI (A2A) agents, humans evaluate the final conclusions—but when the first step is fetching demographic or industry figures, that initial retrieval dictates the direction of the entire analysis. Subscription fees (from 8.90 EUR/mo) are not a toll on open data; they cover ongoing development, RAM caching, and schema maintenance so the service remains operational for decades.
When staff changes in an organization and IT deprovisions a predecessor's account, custom scripts and connectors often break. Likewise, statistical agencies experience staff turnover, budget shifts, and only maintain their own national silo. PxBridge provides a permanent, version-agnostic (PxWeb v1 & v2) bridge across 25+ agencies for both human analysts and AI agents.
No. Under the Model Context Protocol (MCP), your prompts and documents stay inside your AI client (Claude, Copilot, ChatGPT). Only structured statistical parameters (e.g., table_uid, Alue, Vuosi) are sent to PxBridge.
Connect in 60 Seconds — Choose Your Environment
Microsoft 365 Copilot Declarative Agent & Copilot Studio:
- Option A (1-Click M365 Package): Download
pxbridge-copilot.zipand upload in M365 Admin Center or Teams (Upload custom app). - Option B (Copilot Studio Streamable HTTP): Connect directly to
https://mcp.pxbridge.eu/mcpor import OpenAPI spechttps://mcp.pxbridge.eu/openapi.json.
ChatGPT Custom MCP Server (chatgpt.com/plugins):
Kytke PxBridge suoraan ChatGPT Plus-, Pro-, Team- tai Enterprise -työtilaasi Add custom MCP server -toiminnolla.
- Server URL:
https://mcp.pxbridge.eu/mcp - Authentication:
No authentication(vapaa aloituskäyttö heti valmiina) - Tietoturva: 100 % Vain luku (Read-Only), Zero PII, konesali Suomen Haminassa (europe-north1).
Designed for Municipal, Government & Enterprise IT Governance:
- 100% EU / Finland Residency: Hosted in Google Cloud
europe-north1(Hamina, Finland). - Zero PII & Zero Prompt Logging: Only target
agency_idandtable_uidare logged—no DPIA required. - Annual E-Invoice (1,800 EUR/yr): Instant 14-day provisional access via Peppol / Finvoice / OVT (
px_order_enterprise_einvoice).
Option A — Claude.ai (Web / Pro / Max / Team / Enterprise Custom Integration, 15 sec):
- Open Claude.ai Settings → Integrations (or Connectors) → Add Custom Integration.
- Name:
PxBridge· Server URL:https://mcp.pxbridge.eu/mcp(No authentication required for free tier; all 25+ agencies including StatFin, Paavo & Luke enabled immediately). - Enable PxBridge in your chat tools menu to query official tables with RAM caching.
Option B — Claude Desktop, Cursor, Windsurf & Antigravity (mcp_config.json):
{
"mcpServers": {
"pxbridge": {
"url": "https://mcp.pxbridge.eu/mcp"
}
}
}
50 Years of Nordic Statistical Architecture — Built with Respect for Our Predecessors (AXIS → PC-Axis → PxWeb → PxBridge)
The prefix Px stands for PC-Axis, originating at Statistics Sweden (SCB) in the 1970s–1990s. We have been part of this field for a long time — collaborating with statistical practitioners and deploying PX-Web instances for clients ourselves — so we know firsthand the dedication behind every official .px cube. Now, as agentic AI workflows advance, we enter a new stage where AI systems must be backed by factual, verified statistical data rather than guesswork:
SCB database theorist Prof. Bo Sundgren pioneered multidimensional statistical hypercubes where every variable (Region, Age, Sex, Year) is a pivotable Axis on IBM mainframes.
For Sweden's 1990 census, Lars Nordbäck and the Nordic statistical community democratized statistical cubes for personal computers. MS-DOS's 3-letter extension limit gave birth to the .px format.
Launched in 2000 (and evolving today via PxTools / PxWeb 2.0), PxWeb brought .px cubes to web browsers and open REST APIs (CC BY 4.0) across 25+ national statistical offices.
The deterministic Bridge that connects decades of statistical engineering to AI agents and Microsoft 365 Copilot — translating natural language into exact Px axis codes (Tampere → KU837, Stockholm → 0180) with zero cell alteration.
We are not a publicly funded institution, and no public-sector cost center pays for our salaries, tokens, or cloud hosting. We are an independent consulting software company dedicated to advancing the sector because real-time access to authentic statistical data is vital for how societies function. Catalog search, metadata inspection, and baseline weekly usage remain open to the community at zero cost, while fees from broader professional and institutional usage go directly toward development costs and maintaining the service infrastructure.
Pricing (Excl. VAT / ALV 0 %): From 0 EUR Free Explorer & 8,90 EUR/mo Specialist to Team (max 10) & M365 Org
All listed prices are excl. VAT (ALV 0 %). All 25+ official statistical offices (including Statistics Finland StatFin, Paavo, Municipal Key Figures, Luke, Sweden SCB, Norway SSB, and Switzerland BFS) are 100% included in every tier — including the 0 EUR Free Explorer community tier. Usage fees go directly toward development costs and maintaining the service infrastructure.
| Tier / Paketti | Price / Hinta (ALV 0 %) | Quota, Coverage & Kohderyhmä | Billing / Maksutapa |
|---|---|---|---|
| Free Explorer | 0 EUR / mo (excl. VAT) | All 25+ statistical offices included (StatFin, Paavo, Kuntien avainluvut, Luke, SCB, SSB, BFS). 5 queries/wk anonymous; 20 queries/wk via work email OTP. Unlimited < 2 ms catalog search. | Free |
| Professional / Specialist (1 user) | 8,90 EUR / mo (excl. VAT) | 1 user, 1,000 queries/wk, all 25+ agencies + RAM cache. For consultants, planners, CFOs / finance managers, municipal managers, controllers, data journalists, journalists, analysts, and researchers. | Instant Card (Stripe) |
| Team (max 10 users) | 49 EUR / mo (excl. VAT) | Up to 10 users, 5,000 queries/wk across all 25+ countries (StatFin, Paavo, Luke, SCB, SSB, BFS) + shared team key. | Instant Card (Stripe) |
| Municipality / M365 Organization | 1,800 EUR / yr (excl. VAT) | 50,000 queries/wk, M365 Admin Center / Claude Team / ChatGPT Team deployment, 14-day instant start. | Peppol / OVT E-Invoice |