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.
foodpricesstatcangovernment-of-canada
Qualité
98
Attribution
Contains information licensed under the Open Government Licence – Canada
Schéma
| Colonne | Type | Description |
|---|---|---|
| ref_date | string | Reference date — the time period the observation refers to (Statistics Canada table field REF_DATE). |
| geo | string | Geography the observation covers (Statistics Canada table field GEO). |
| dguid | string | Dissemination geography unique identifier (Statistics Canada table field DGUID). |
| products | string | |
| uom | string | Unit of measure for the estimate (Statistics Canada table field UOM). |
| uom_id | integer | Unit of measure identifier (Statistics Canada table field UOM_ID). |
| scalar_factor | string | Scalar factor applied to the value, e.g. units, thousands or millions (Statistics Canada table field SCALAR_FACTOR). |
| scalar_id | integer | Scalar factor identifier (Statistics Canada table field SCALAR_ID). |
| vector | string | Vector number — Statistics Canada's unique identifier for the time series (table field VECTOR). |
| coordinate | float | Table coordinate locating the estimate within the source table (Statistics Canada table field COORDINATE). |
| value | float | Estimate value as published in the Statistics Canada table. |
| terminated | string | Whether the series has been terminated (Statistics Canada table field TERMINATED). |
| decimals | integer | Number of decimals published for the estimate (Statistics Canada table field DECIMALS). |
Exemple de lignes
| ref_date | geo | dguid | products | uom | uom_id | scalar_factor | scalar_id | vector | coordinate | value | terminated | decimals |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1995-01 | Canada | 2016A000011124 | Round steak, 1 kilogram | Dollars | 81 | units | 0 | v735165 | 1.1 | 10.17 | — | 2 |
| 1995-01 | Canada | 2016A000011124 | Sirloin steak, 1 kilogram | Dollars | 81 | units | 0 | v735176 | 1.2 | 11.25 | — | 2 |
| 1995-01 | Canada | 2016A000011124 | Prime rib roast, 1 kilogram | Dollars | 81 | units | 0 | v735187 | 1.3 | 12.08 | — | 2 |
| 1995-01 | Canada | 2016A000011124 | Blade roast, 1 kilogram | Dollars | 81 | units | 0 | v735198 | 1.4 | 7.23 | — | 2 |
| 1995-01 | Canada | 2016A000011124 | Stewing beef, 1 kilogram | Dollars | 81 | units | 0 | v735209 | 1.5 | 7.12 | — | 2 |
Utiliser avec un LLM
Dirigez n’importe quel LLM vers le point d’accès des métadonnées — la documentation ci-dessus est aussi lisible par machine (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)Point d’accès API: https://datazimuts.com/v1/datasets/ckan_canada/food_prices_monthly
Astuce : récupérez /llms.txt pour le catalogue complet lisible par machine.