All datasets

Monthly average retail prices for food and other selected products

Monthly average retail prices for food and other selected products by geography. Statistics Canada table 18-10-0002-01.

Source: Government of Canada Open Data18,516 rowsUpdated: 9/20/2026License: OGL-Canada-2.0
foodpricesstatcangovernment-of-canada

Quality

98

Attribution

Contains information licensed under the Open Government Licence – Canada

Schema

ColumnTypeDescription
ref_datestringReference date — the time period the observation refers to (Statistics Canada table field REF_DATE).
geostringGeography the observation covers (Statistics Canada table field GEO).
dguidstringDissemination geography unique identifier (Statistics Canada table field DGUID).
productsstring
uomstringUnit of measure for the estimate (Statistics Canada table field UOM).
uom_idintegerUnit of measure identifier (Statistics Canada table field UOM_ID).
scalar_factorstringScalar factor applied to the value, e.g. units, thousands or millions (Statistics Canada table field SCALAR_FACTOR).
scalar_idintegerScalar factor identifier (Statistics Canada table field SCALAR_ID).
vectorstringVector number — Statistics Canada's unique identifier for the time series (table field VECTOR).
coordinatefloatTable coordinate locating the estimate within the source table (Statistics Canada table field COORDINATE).
valuefloatEstimate value as published in the Statistics Canada table.
terminatedstringWhether the series has been terminated (Statistics Canada table field TERMINATED).
decimalsintegerNumber of decimals published for the estimate (Statistics Canada table field DECIMALS).

Sample rows

ref_dategeodguidproductsuomuom_idscalar_factorscalar_idvectorcoordinatevalueterminateddecimals
1995-01Canada2016A000011124Round steak, 1 kilogramDollars81units0v7351651.110.172
1995-01Canada2016A000011124Sirloin steak, 1 kilogramDollars81units0v7351761.211.252
1995-01Canada2016A000011124Prime rib roast, 1 kilogramDollars81units0v7351871.312.082
1995-01Canada2016A000011124Blade roast, 1 kilogramDollars81units0v7351981.47.232
1995-01Canada2016A000011124Stewing beef, 1 kilogramDollars81units0v7352091.57.122

Use with an LLM

Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).

cURL

curl "https://datazimuts.com/v1/datasets/ckan_canada/food_prices_monthly" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/ckan_canada/food_prices_monthly").json()
print(ds["title"], ds["rows"], "rows")

# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
    print(row)

API endpoint: https://datazimuts.com/v1/datasets/ckan_canada/food_prices_monthly

Tip: fetch /llms.txt for the full machine-readable catalog.