Monthly average retail prices for gasoline and fuel oil, by geography

Name: Monthly average retail prices for gasoline and fuel oil, by geography
Creator: Government of Canada Open Data
License: https://open.canada.ca/en/open-government-licence-canada
Keywords: gasoline, prices, energy, statcan, government-of-canada

Monthly average retail prices for gasoline and fuel oil by geography. Statistics Canada table 18-10-0001-01.

Source: Government of Canada Open Data46,192 rowsUpdated: 9/20/2026License: OGL-Canada-2.0

gasolinepricesenergystatcangovernment-of-canada

Quality

98.4

Attribution

Contains information licensed under the Open Government Licence – Canada

Schema

Column	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).
type_of_fuel	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).

Sample rows

ref_date	geo	dguid	type_of_fuel	uom	uom_id	scalar_factor	vector	coordinate	value	terminated	decimals
1979-01	St. John's, Newfoundland and Labrador	2011S0503001	Regular unleaded gasoline at full service filling stations	Cents per litre	57	units	v735046	2.1	26	t	1
1979-01	Charlottetown and Summerside, Prince Edward Island	—	Regular unleaded gasoline at full service filling stations	Cents per litre	57	units	v735056	3.1	24.6	t	1
1979-01	Halifax, Nova Scotia	2011S0503205	Regular unleaded gasoline at full service filling stations	Cents per litre	57	units	v735057	4.1	23.4	t	1
1979-01	Saint John, New Brunswick	2011S0503310	Regular unleaded gasoline at full service filling stations	Cents per litre	57	units	v735058	5.1	23.2	t	1
1979-01	Québec, Quebec	2011S0503421	Regular unleaded gasoline at full service filling stations	Cents per litre	57	units	v735059	6.1	22.6	t	1

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/gasoline_prices_monthly" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/ckan_canada/gasoline_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/gasoline_prices_monthly

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