Quarterly Canadian property & casualty insurer financial-strength intelligence from OSFI's keyless open-data PC1 core financial statement return and PC4 minimum capital test (open.canada.ca CKAN datastore): a company x quarter panel of IFRS-17 P&L items differenced from year-to-date to quarterly values (insurance revenue, insurance service result, net investment result, net income), balance-sheet anchors (total assets, liabilities, equity via the accounting identity), the PC4 MCT solvency ratio, and derived intelligence — insurance-service margin, quarterly ROA, revenue YoY growth, equity ratio — plus a documented 0-100 strength_score (35% MCT buffer + 30% service margin + 20% ROA + 15% revenue growth, each winsorized p1/p99 and min-max scored within the quarter), strength_rank/percentile, and flags (weak_capital below OSFI's 150% supervisory target, negative_service_result, shrinking_revenue, outlier_mct, data_gap). Primary key: (osfi_company_id, quarter). Cadence: quarterly; as_of is the quarter-end date, so a re-ingest of the same quarter is a no-op. Caveats: figures in CAD thousands; quarterly P&L values come from restated YTD filings and can be negative; the score is peer-relative, not an OSFI rating and not investment advice; compare Canadian vs foreign filers with care. commercial_use = yes (Open Government Licence - Canada; attribution to OSFI required). Sample use: filter watch_flag = 1 for insurers tripping any risk flag, or order by strength_rank within quarter for the strongest peers.

Source: Office of the Superintendent of Financial Institutions (OSFI)
Rows: 1,915
Columns: 37
Source cadence: Quarterly
Last refreshed: Sep 27, 2026
Theme: finance

Column	Type	Description
as_of	date	Quarter-end reference date (calendar quarters). (unit: date)
quarter	string	Reference quarter, YYYY-QN. Panel starts 2023-Q1 (IFRS-17 PC1 return launch); the latest quarter is the latest filed release.
osfi_company_id	string	Stable OSFI company identifier (the return's Id field); primary key with quarter.
company_name	string	Latest filed company name for the OSFI Id (entity-resolved across renames).
former_name	string	Prior filed name when the company renamed mid-panel; null otherwise.
industry_group	string	OSFI industry group: 'Canadian Property & Casualty' or 'Foreign Property & Casualty'.
country_code	string	ISO alpha-3 country code; always CAN. (unit: ISO-3166 alpha-3)
insurance_revenue_q_cadk	float	Quarterly insurance revenue (IFRS-17), differenced from the YTD 'Current Period' Total filing; null when the predecessor quarter is missing. (unit: CAD thousands)
insurance_service_result_q_cadk	float	Quarterly insurance service result (IFRS-17 underwriting result analogue), differenced from YTD. (unit: CAD thousands)
net_investment_result_q_cadk	float	Quarterly net investment result, differenced from YTD. (unit: CAD thousands)
net_income_q_cadk	float	Quarterly net income (loss) for the year, differenced from YTD; can be negative. (unit: CAD thousands)
insurance_revenue_ytd_cadk	float	Year-to-date insurance revenue as filed (Current Period Total). (unit: CAD thousands)
insurance_service_result_ytd_cadk	float	Year-to-date insurance service result as filed. (unit: CAD thousands)
net_investment_result_ytd_cadk	float	Year-to-date net investment result as filed. (unit: CAD thousands)
net_income_ytd_cadk	float	Year-to-date net income (loss) for the year as filed. (unit: CAD thousands)
total_assets_cadk	float	Total assets, quarter-end point-in-time (Current Period Total). (unit: CAD thousands)
total_liabilities_cadk	float	Total liabilities, quarter-end point-in-time. (unit: CAD thousands)
equity_cadk	float	Equity proxy = total_assets − total_liabilities (accounting identity; works for foreign branches whose equity section differs). (unit: CAD thousands)
equity_ratio	float	equity_cadk / total_assets_cadk; capital leverage gauge. (unit: fraction)
insurance_service_margin_q	float	insurance_service_result_q / insurance_revenue_q; the IFRS-17 analogue of the underwriting margin. (unit: fraction)
roa_q_pct	float	Quarterly return on assets = 100 * net_income_q / total_assets. (unit: percent)
insurance_revenue_yoy_pct	float	Year-over-year growth of quarterly insurance revenue (same quarter, prior year); null in the first year. (unit: percent)
mct_ratio_pct	float	PC4 Minimum Capital Test ratio (Line 10 or line 25 as a % of line 130), in percent. OSFI's supervisory target is 150%. (unit: percent)
mct_score	float	0-100 peer score of the MCT capital buffer within the quarter (p1/p99-winsorized, min-max; 50 when degenerate).
margin_score	float	0-100 peer score of the quarterly insurance-service margin within the quarter (p1/p99-winsorized, min-max).
roa_score	float	0-100 peer score of quarterly ROA within the quarter (p1/p99-winsorized, min-max).
growth_score	float	0-100 peer score of insurance-revenue YoY growth within the quarter (p1/p99-winsorized, min-max); null in the first year.
strength_score	float	Documented 0-100 financial-strength composite = 0.35mct_score + 0.30margin_score + 0.20roa_score + 0.15growth_score, renormalized over the components present (growth may be absent); null when MCT/margin/ROA is missing. Peer-relative within the quarter — not an OSFI rating, not investment advice.
strength_rank	float	Rank of strength_score within the quarter, 1 = strongest (min-rank ties).
strength_percentile	float	Percentile of strength_score within the quarter, 100*(rank-1)/(n-1).
weak_capital_flag	integer	1 when mct_ratio_pct < 150 (below OSFI's supervisory target). (unit: 0/1)
negative_service_result_flag	integer	1 when the quarterly insurance service result is negative. (unit: 0/1)
shrinking_revenue_flag	integer	1 when quarterly insurance revenue shrank year-over-year. (unit: 0/1)
outlier_mct_flag	integer	1 when mct_ratio_pct is outside the 50–3000% sanity envelope (real but unrepresentative tiny entities). (unit: 0/1)
data_gap_flag	integer	1 when the strength_score could not be computed (missing MCT, margin or ROA). (unit: 0/1)
watch_flag	integer	1 when any risk flag or the data-gap flag is set. (unit: 0/1)
row_hash	string	Deterministic SHA-256 over the natural key plus rounded values; identical input yields an identical snapshot.

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

as_of	quarter	osfi_company_id	company_name	former_name	industry_group	country_code	insurance_revenue_q_cadk	insurance_service_result_q_cadk	net_investment_result_q_cadk	net_income_q_cadk	insurance_revenue_ytd_cadk	insurance_service_result_ytd_cadk	net_investment_result_ytd_cadk	net_income_ytd_cadk	total_assets_cadk	total_liabilities_cadk	equity_cadk	equity_ratio	insurance_service_margin_q	roa_q_pct	insurance_revenue_yoy_pct	mct_ratio_pct	mct_score	margin_score	roa_score	growth_score	strength_score	strength_rank	strength_percentile	negative_service_result_flag	outlier_mct_flag	watch_flag	row_hash
2023-03-31	2023-Q1	28131	CorePointe Insurance Company	CorePointe Insurance Company	Foreign Property & Casualty	CAN	12	7	90	27	12	7	90	27	8,569	478	8,091	0.944	0.583	0.315	—	6,097.02	100	40.734	29.73	—	62.55	1	0	0	1	0	8eebf5d88bd05ddd325fb834b3699d773b296c163644beac4703877ed4f98096
2023-03-31	2023-Q1	27991	Western Assurance Company	Western Assurance Company	Canadian Property & Casualty	CAN	923	5,181	2,758	10,602	923	5,181	2,758	10,602	603,582	286,953	316,629	0.525	5.613	1.757	—	344.98	3.122	100	42.887	—	46.67	2	0.813	0	0	0	1e1efb6f017d02773e68bfefac38c87e1f8ce6463ec93a6d8b9a4a8b8ca2af49
2023-03-31	2023-Q1	28103	American Road Insurance Company (The)	American Road Insurance Company (The)	Foreign Property & Casualty	CAN	1,703	1,089	401	829	1,703	1,089	401	829	32,930	461	32,469	0.986	0.639	2.517	—	1,995.42	39.816	41.579	49.833	—	42.79	3	1.626	0	0	0	d5badaa9901c641bc436a8f0e6abfefd1eeda1a3eca5f3a6a6485c3b20dc6d67
2023-03-31	2023-Q1	179039	Shelter Mutual Insurance Company	Shelter Mutual Insurance Company	Foreign Property & Casualty	CAN	6,760	5,053	337	5,369	6,760	5,053	337	5,369	57,424	19,093	38,331	0.668	0.747	9.35	—	518.7	6.985	43.205	100	—	41.65	4	2.439	0	0	0	2b59633888344918315aa26edb9732b4c98cd26566466973b635e59bfafe03de
2023-03-31	2023-Q1	27963	Petline Insurance Company	Petline Insurance Company	Canadian Property & Casualty	CAN	19,804	3,174	491	2,637	19,804	3,174	491	2,637	28,096	9,690	18,406	0.655	0.16	9.386	—	339.59	3.002	34.364	100	—	36.89	5	3.252	0	0	0	b7c88e658ff004674a1b2c09dfbda6eea242e8ce2a57782f59605d09549d0dc2
2023-03-31	2023-Q1	28282	Sompo Japan Insurance Inc.	Sompo Japan Insurance Inc.	Foreign Property & Casualty	CAN	3,810	1,239	1,612	2,172	3,810	1,239	1,612	2,172	115,888	15,798	100,090	0.864	0.325	1.874	—	1,671.1	32.605	36.847	43.961	—	36.77	6	4.065	0	0	0	cf7c65da616e9a5b666ccd149d05e2cb81014a8b19281e995bdf4601baced746
2023-03-31	2023-Q1	27989	Waterloo Insurance Company	Waterloo Insurance Company	Canadian Property & Casualty	CAN	-1	-12,845	3,673	-6,669	-1	-12,845	3,673	-6,669	224,117	142,315	81,802	0.365	12,845	-2.976	—	353.28	3.307	100	0	—	36.66	7	4.878	1	0	1	d47b4acf2949789eb838a212269e47a65f45c2f7e6dec7ea0be9734f9c6f5186
2023-03-31	2023-Q1	146097	Atradius Crédito y Caución S.A. de Seguros y Reaseguros	Atradius Crédito y Caución S.A. de Seguros y Reaseguros	Foreign Property & Casualty	CAN	8,394	2,951	180	2,593	8,394	2,951	180	2,593	46,868	19,360	27,508	0.587	0.352	5.533	—	633.35	9.533	37.244	77.353	—	35.27	8	5.691	0	0	0	abcc275a90e691bcd8c6e9f3802020144caad0e21d6b84a18524a0c72fd76f78
2023-03-31	2023-Q1	28183	Mapfre Re Compania de Reaseguros, S.A.	Mapfre Re Compania de Reaseguros, S.A.	Foreign Property & Casualty	CAN	6,085	4,318	930	3,906	6,085	4,318	930	3,906	93,215	24,888	68,327	0.733	0.71	4.19	—	678.76	10.543	42.635	65.102	—	34.71	9	6.504	0	0	0	1dea3e971cfb65106627a3aff79e810c1520103f1d03ad73f64c78bc93f50d87
2023-03-31	2023-Q1	28152	Compagnie Française d'Assurance pour le Commerce Extérieur	Compagnie Française d'Assurance pour le Commerce Extérieur	Foreign Property & Casualty	CAN	8,429.67	7,231.12	1,102.09	2,225.97	8,429.67	7,231.12	1,102.09	2,225.97	90,117.75	37,874.43	52,243.32	0.58	0.858	2.47	—	716.21	11.376	44.867	49.4	—	32.14	10	7.317	0	0	0	f9cd3f4af5e6c96efdb528e8bee4bdb5c3480091092ce221086308bd0d572855

Sep 27, 2026Current
20260927T235819Z-110d76c9e162 · sha256 110d76c9e162…
1,915 rows · first snapshot

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

cURL

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

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/osfi_pc_insurer_intel/osfi_pc_insurer_quarterly").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/osfi_pc_insurer_intel/osfi_pc_insurer_quarterly

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

Where this data comes from and what was made from it. Other people's work shows as counts; only shared projects are named.

Cite this snapshot

Pinned to snapshot 20260927T235819Z-110d76c9e162 and its content hash, so readers get exactly the data you used.

APA

Office of the Superintendent of Financial Institutions (OSFI). (2026). OSFI P&C insurer financial-strength intelligence (quarterly) [Data set, snapshot 20260927T235819Z-110d76c9e162, sha256 110d76c9e162]. Datazimuts. Retrieved 2026-09-28, from https://datazimuts.com/en/datasets/osfi_pc_insurer_intel/osfi_pc_insurer_quarterly?snapshot=20260927T235819Z-110d76c9e162

BibTeX

@misc{dz_osfi_pc_insurer_intel_osfi_pc_insurer_qu_110d76c9,
  title        = {{OSFI P\&C insurer financial-strength intelligence (quarterly)}},
  author       = {{Office of the Superintendent of Financial Institutions (OSFI)}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/osfi_pc_insurer_intel/osfi_pc_insurer_quarterly?snapshot=20260927T235819Z-110d76c9e162}},
  note         = {Snapshot 20260927T235819Z-110d76c9e162, sha256 110d76c9e1626b97e7f56950b3f1ece1eba9f7cfc52962aec5807d01c64ac543; accessed 2026-09-28}
}

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=osfi_pc_insurer_intel%2Fosfi_pc_insurer_quarterly&lang=en&theme=auto&snapshot=20260927T235819Z-110d76c9e162&x=as_of&y=insurance_revenue_q_cadk&agg=avg" title="OSFI P&C insurer financial-strength intelligence (quarterly)" width="100%" height="380" style="border:0" loading="lazy"></iframe>

Sign in to comment

Ask about this dataset. Answers come only from its catalog record, measured profile and change history, and list the facts they used.

OSFI P&C insurer financial-strength intelligence (quarterly)

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key