Canadian open-data catalog freshness intelligence (monthly)

Commercial use OKFresh

The full snapshot isn't published yet — check back after the next refresh.Download sample CSV Download sample JSONSample rows only (up to 20) — not the complete dataset.

Freshness intelligence for every dataset on Canada's Open Government Portal (open.canada.ca): one row per dataset package with days since its last metadata update, resource counts and formats, datastore/validation health, and a documented 0-100 freshness_score (75% recency decay + 15% datastore liveness + 10% validation health) tiered as fresh/aging/stale/dormant, plus per-row license and provenance URL. Built from the keyless CKAN package_search API with entity-resolved bilingual publisher names and a loud PII screen on titles. Caveats: metadata_modified is a maintenance proxy, not data vintage — archival datasets score dormant by design. Open Government Licence - Canada (commercial reuse allowed); source: Government of Canada Open Government Portal.

Source: Government of Canada — Open Government Portal
Rows: 47,940
Columns: 24
Source cadence: Monthly
Last refreshed: Sep 26, 2026
Theme: government

Column	Type	Description
as_of	string	Snapshot reference date (UTC). Day granularity: same-day re-runs are idempotent. (unit: ISO date)
country_code	string	ISO alpha-3 country code (CAN for every row). (unit: ISO 3166-1 alpha-3)
dataset_id	string	CKAN package UUID; primary key of the dataset-level panel.
dataset_name	string	CKAN package slug (URL name).
title	string	Provider-verbatim dataset title (PII-screened).
org_code	string	Publisher organization code from the portal (e.g. statcan, nrcan-rncan). Primary join key with the org ranking.
org_name_en	string	Publisher name, English side of the portal's bilingual org title.
org_name_fr	string	Publisher name, French side (null when the portal gives no French side).
metadata_created	string	When the package record was created on the portal. (unit: ISO date)
metadata_modified	string	Last time the package record was touched (metadata or data). A maintenance proxy, not the data's vintage. (unit: ISO date)
days_since_update	integer	Full days between as_of and metadata_modified, clamped at 0. (unit: days)
n_resources	integer	Number of resources (files/links/services) attached to the package. (unit: count)
formats_csv	string	Sorted unique resource formats, pipe-joined (capped at 8 with a +n tail).
n_datastore_active	integer	Resources loaded into the portal's CKAN datastore (queryable). (unit: count)
n_validated_ok	integer	Resources with a passing validation_status. (unit: count)
n_validated_bad	integer	Resources with a failing validation_status. (unit: count)
has_en	integer	1 when at least one resource declares English content. (unit: binary)
has_fr	integer	1 when at least one resource declares French content. (unit: binary)
freshness_score	float	Documented 0-100 freshness score: 100 * (0.75 * exp(-days_since_update / 365.25) + 0.15 * datastore_active_share + 0.10 * validation_ok_share). 100 = touched today with live datastore resources and clean validation. (unit: score 0-100)
freshness_tier	string	fresh (<90d) / aging (90-365d) / stale (365-1095d) / dormant (>1095d) since the last update.
stale_flag	integer	1 when days_since_update exceeds 365. (unit: binary)
license_id	string	Portal license id for the dataset (ca-ogl-lgo and the provincial -ogl variants all permit commercial reuse with attribution).
provenance_url	string	Canonical portal page for the dataset package.
row_hash	string	Deterministic 16-hex row hash of dataset_id/org_code + as_of (idempotency).

First 10 sample rows — a preview, not the complete dataset.

as_of	country_code	dataset_id	dataset_name	title	org_code	org_name_en	org_name_fr	metadata_created	metadata_modified	days_since_update	n_resources	formats_csv	n_datastore_active	n_validated_ok	has_en	has_fr	freshness_score	freshness_tier	stale_flag	license_id	provenance_url	row_hash
2026-09-26	CAN	000183ed-8864-42f0-ae43-c4313a860720	000183ed-8864-42f0-ae43-c4313a860720	Principal Mineral Areas, Producing Mines, and Oil and Gas Fields (900A)	nrcan-rncan	Natural Resources Canada	Ressources naturelles Canada	2019-06-07	2026-02-27	211	12	esri rest\|fgdb/gdb\|html\|mxd\|pdf\|shp\|wms	0	0	1	1	47.09	aging	0	ca-ogl-lgo	https://open.canada.ca/data/en/dataset/000183ed-8864-42f0-ae43-c4313a860720	86dec7101f2b7819
2026-09-26	CAN	0002555a-9d30-43b0-baab-a61603431a9d	0002555a-9d30-43b0-baab-a61603431a9d	Cadastral Information for Orford Bay 4	nrcan-rncan	Natural Resources Canada	Ressources naturelles Canada	2016-09-23	2020-09-25	2,192	2	other\|shp	0	0	1	1	5.19	dormant	1	ca-ogl-lgo	https://open.canada.ca/data/en/dataset/0002555a-9d30-43b0-baab-a61603431a9d	1ce8f3d2e4274b51
2026-09-26	CAN	0004129a-b50e-4a99-a10d-35c386903cbb	0004129a-b50e-4a99-a10d-35c386903cbb	Local Government Statistics - Assets - Regional District - 2006	bc-cb	Government of British Columbia	Gouvernment de la Colombie-Britannique	2023-04-13	2026-04-17	162	2	html\|xls	0	0	1	0	53.13	aging	0	bc-oglbc	https://open.canada.ca/data/en/dataset/0004129a-b50e-4a99-a10d-35c386903cbb	fbf71b0d44f1cd68
2026-09-26	CAN	0005301b-624e-4000-8dad-a1a1ac6b46c2	0005301b-624e-4000-8dad-a1a1ac6b46c2	Land Surface Evapotranspiration for Canada's Landmass	nrcan-rncan	Natural Resources Canada	Ressources naturelles Canada	2021-09-14	2024-10-29	697	7	geotif\|json\|wms	0	0	1	1	16.13	stale	1	ca-ogl-lgo	https://open.canada.ca/data/en/dataset/0005301b-624e-4000-8dad-a1a1ac6b46c2	75bfe7187b278c60
2026-09-26	CAN	000a51f1-3781-a262-35f2-ff83df4898d9	000a51f1-3781-a262-35f2-ff83df4898d9	Licensed Lenders in Nova Scotia	ns-ne	Government of Nova Scotia	Gouvernment de la Nouvelle-Écosse	2022-04-14	2025-11-19	311	12	csv\|geojson\|html\|kml\|kmz\|rss\|shp\|xml	0	0	1	0	37.01	aging	0	ns-oglns	https://open.canada.ca/data/en/dataset/000a51f1-3781-a262-35f2-ff83df4898d9	aeddb37cd1085aa3
2026-09-26	CAN	000bb94e-d929-4214-8893-bb42b114b0c3	000bb94e-d929-4214-8893-bb42b114b0c3	COVID-19: How to care at home for someone who has or may have been exposed	phac-aspc	Public Health Agency of Canada	Agence de la santé publique du Canada	2021-11-05	2021-11-05	1,786	2	html	0	0	1	1	5.56	dormant	1	ca-ogl-lgo	https://open.canada.ca/data/en/dataset/000bb94e-d929-4214-8893-bb42b114b0c3	7f41cf07bf4f66af
2026-09-26	CAN	000cd057-9652-4db0-8a15-9c3d34a82ef2	000cd057-9652-4db0-8a15-9c3d34a82ef2	Major Field of Study - Classification of Instructional Programs (CIP) 2011 (82), Immigrant Status and Period of Immigration (11), Labour Force Status (8), Highest Certificate, Diploma or Degree (10B), Age Groups (8B) and Sex (3) for the Population Aged 15 Years and Over, in Private Households of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2011 National Household Survey	statcan	Statistics Canada	Statistique Canada	2016-09-23	2022-02-23	1,676	1	xml	0	0	1	1	5.76	dormant	1	ca-ogl-lgo	https://open.canada.ca/data/en/dataset/000cd057-9652-4db0-8a15-9c3d34a82ef2	ea720b04fa68bfcc
2026-09-26	CAN	000ec033-1a78-661d-d432-6eb8cf840361	000ec033-1a78-661d-d432-6eb8cf840361	ThinkFARM GF2 External Workshops and Locations by Year	ns-ne	Government of Nova Scotia	Gouvernment de la Nouvelle-Écosse	2022-05-03	2026-04-17	162	8	csv\|html\|other\|rdf\|rss\|xml	0	0	1	0	53.13	aging	0	ns-oglns	https://open.canada.ca/data/en/dataset/000ec033-1a78-661d-d432-6eb8cf840361	2fad668272f9116b
2026-09-26	CAN	000fe5aa-1d77-42d1-bfe7-458c51dacfef	000fe5aa-1d77-42d1-bfe7-458c51dacfef	Historical Border Wait Times – Land Mode	cbsa-asfc	Canada Border Services Agency	Agence des services frontaliers du Canada	2016-09-23	2025-12-18	282	55	csv\|txt	2	2	1	1	45.2	aging	0	ca-ogl-lgo	https://open.canada.ca/data/en/dataset/000fe5aa-1d77-42d1-bfe7-458c51dacfef	7abb17079e1c27bf
2026-09-26	CAN	001022b1-3992-4e17-9d2b-37eb12986650	001022b1-3992-4e17-9d2b-37eb12986650	2025—Report of the Auditor General of Canada—Canada-Wide Early Learning and Child Care System	oag-bvg	Office of the Auditor General of Canada	Bureau du vérificateur général du Canada	2025-11-25	2026-04-09	170	4	html\|pdf	0	0	1	1	52.09	aging	0	ca-ogl-lgo	https://open.canada.ca/data/en/dataset/001022b1-3992-4e17-9d2b-37eb12986650	d37b6deaed696925

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

cURL

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

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/ca_opendata_freshness_signals/ca_opendata_dataset_freshness_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/ca_opendata_freshness_signals/ca_opendata_dataset_freshness_monthly

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

Cite this snapshot

Pinned to snapshot 20260926T132105Z-62d5364ea1fd and its content hash, so readers get exactly the data you used.

APA

Government of Canada — Open Government Portal. (2026). Canadian open-data catalog freshness intelligence (monthly) [Data set, snapshot 20260926T132105Z-62d5364ea1fd, sha256 62d5364ea1fd]. Datazimuts. Retrieved 2026-09-26, from https://datazimuts.com/en/datasets/ca_opendata_freshness_signals/ca_opendata_dataset_freshness_monthly?snapshot=20260926T132105Z-62d5364ea1fd

BibTeX

@misc{dz_ca_opendata_freshness_signals_ca_opendat_62d5364e,
  title        = {{Canadian open-data catalog freshness intelligence (monthly)}},
  author       = {{Government of Canada — Open Government Portal}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/ca_opendata_freshness_signals/ca_opendata_dataset_freshness_monthly?snapshot=20260926T132105Z-62d5364ea1fd}},
  note         = {Snapshot 20260926T132105Z-62d5364ea1fd, sha256 62d5364ea1fd8a3e1d1ceba02e91780570f071b520f38bcd455600a61a05b9fb; accessed 2026-09-26}
}

Embed a table or a chart

Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.

Type

X axis

Value

Aggregate

Theme

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=ca_opendata_freshness_signals%2Fca_opendata_dataset_freshness_monthly&lang=en&theme=auto&snapshot=20260926T132105Z-62d5364ea1fd&x=days_since_update&y=days_since_update&agg=avg" title="Canadian open-data catalog freshness intelligence (monthly)" width="100%" height="380" style="border:0" loading="lazy"></iframe>

Canadian open-data catalog freshness intelligence (monthly)

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key