← Agent Data Hub · Search endpoints · /llms.txt

Any Statistics Canada Table — All ~5,000 Active Tables, Filter by Region and Dimension

Any active table of Statistics Canada (Canada, provinces, cities): prices, labour, income, housing, health, agriculture, energy, trade, population, business … Pass the table id (pid, e.g. 18100004 or 18-10-0004-01); /api/v1/ask finds it for a question. Filter each dimension by member name or id (e.g. geography=Ontario); dimensions you leave out take their first member (usually the total), listed in defaults_used. The answer lists every dimension with its members for the next call.

Call it (no API key)

GET https://api.agentdatahub.de/api/v1/call/statcan-table?pid=18100004&geography=Ontario&products_and_product_groups=Food&last=6&compact=1

Full metadata: without compact=1 · Markdown: format=llm · Only some fields: add &fields=a,b.c · MCP: tool call_api with {"apiId":"statcan-table"}

Parameters

Example response (live, compact)

{
  "apiId": "statcan-table",
  "data_freshness": "live",
  "data": {
    "table": "18100004",
    "title": "Consumer Price Index, monthly, not seasonally adjusted",
    "selected": {
      "geography": "Ontario",
      "products_and_product_groups": "Food"
    },
    "dimensions": {
      "geography": {
        "label": "Geography",
        "members": [
          "Canada",
          "Newfoundland and Labrador",
          "St. John's, Newfoundland and Labrador",
          "Prince Edward Island",
          "Charlottetown and Summerside, Prince Edward Island",
          "Nova Scotia",
          "Halifax, Nova Scotia",
          "New Brunswick",
          "Saint John, New Brunswick",
          "Quebec",
          "Québec, Quebec",
          "Montréal, Quebec",
          "Ontario",
          "Ottawa-Gatineau, Ontario part, Ontario/Quebec",
          "Toronto, Ontario",
          "Thunder Bay, Ontario",
          "Manitoba",
          "Winnipeg, Manitoba",
          "Saskatchewan",
          "Regina, Saskatchewan",
          "Saskatoon, Saskatchewan",
          "Alberta",
          "Edmonton, Alberta",
          "Calgary, Alberta",
          "British Columbia",
          "Vancouver, British Columbia",
          "Victoria, British Columbia",
          "Whitehorse, Yukon",
          "Yellowknife, Northwest Territories",
          "Iqaluit, Nunavut"
        ]
      },
      "products_and_product_groups": {
        "label": "Products and product groups",
        "members": [
          "All-items",
          "Food",
          "Food purchased from stores",
          "Meat",
          "Fresh or frozen meat (excluding poultry)",
          "Fresh or frozen beef",
          "Fresh or frozen beef hip cuts (202404=100)",
          "Fresh or frozen beef loin cuts (202404=100)",
          "Fresh or frozen beef rib cuts (202404=100)",
          "Fresh or frozen beef chuck cuts (202404=100)",
          "Fresh stewing beef (202404=100)",
          "Fresh or frozen ground beef (202404=100)",
          "Other fresh or frozen beef (202404=100)",
          "Fresh or frozen pork",
          "Fresh or frozen pork loin cuts (202404=100)",
          "Fresh or frozen pork shoulder cuts (202404=100)",
          "Other fresh or frozen pork (202404=100)",
          "Other fresh or frozen meat (excluding poultry)",
          "Fresh or frozen poultry",
          "Fresh or frozen chicken",
          "Fresh or frozen chicken breasts (202404=100)",
          "Fresh or frozen chicken thighs (202404=100)",
          "Fresh or frozen chicken drumsticks (202404=100)",
          "Fresh or frozen whole chicken (202404=100)",
          "Other fresh or frozen chicken (202404=100)",
          "Other fresh or frozen poultry",
          "Processed meat",
          "Ham and bacon",
          "Bacon (2013=100)",
          "Ham excluding deli ham (2013=100)",
          "Other processed meat",
          "Fish, seafood and other marine products",
          "Fish",
          "Fresh or frozen fish (including portions and fish sticks)",
          "Canned and other preserved fish",
          "Canned salmon (2013=100)",
          "Canned tuna (2013=100)",
          "Seafood and other marine products",
          "Shrimps and prawns (2013=100)",
          "Other shellfish (2013=100)"
        ],
        "more": 319
      }
    },
    "source": "Statistics Canada",
    "verification": "Source adapter verified daily against the original; this series is not checked value by value.",
    "vector": "v41691920",
    "scale": "units",
    "latest": {
      "period": "2026-09-01",
      "value": 204.1
    },
    "points": [
      {
        "period": "2026-04-01",
        "value": 203.8
      },
      {
        "period": "2026-05-01",
        "value": 206
      },
      {
        "period": "2026-06-01",
        "value": 204.8
      },
      {
        "period": "2026-07-01",
        "value": 204.9
      },
      {
        "period": "2026-08-01",
        "value": 204.8
      },
      {
        "peri
… (truncated)

Source & license