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.

Les titres et les descriptions proviennent des sources de données, en anglais.

Source: Office of the Superintendent of Financial Institutions (OSFI)
Lignes: 1 915
Colonnes: 37
Cadence de la source: Trimestrielle
Dernière actualisation: 27 sept. 2026
Thème: finance

Colonne	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.

10 premières lignes d’exemple — un aperçu, pas le jeu de données complet.

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

27 sept. 2026Actuelle
20260927T235819Z-110d76c9e162 · sha256 110d76c9e162…
1 915 lignes · premier instantané

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/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)

Point d’accès API : https://datazimuts.com/v1/datasets/osfi_pc_insurer_intel/osfi_pc_insurer_quarterly

Astuce : récupérez /llms.txt pour le catalogue complet lisible par machine.

D’où viennent ces données et ce qui en a été fait. Le travail des autres apparaît sous forme de décomptes ; seuls les projets partagés sont nommés.

Citer cet instantané

Épinglé à l’instantané 20260927T235819Z-110d76c9e162 et à son empreinte, pour que vos lecteurs obtiennent exactement les données utilisées.

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/fr/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/fr/datasets/osfi_pc_insurer_intel/osfi_pc_insurer_quarterly?snapshot=20260927T235819Z-110d76c9e162}},
  note         = {Snapshot 20260927T235819Z-110d76c9e162, sha256 110d76c9e1626b97e7f56950b3f1ece1eba9f7cfc52962aec5807d01c64ac543; accessed 2026-09-28}
}

Intégrer un tableau ou un graphique

Collez ce code dans n’importe quelle page. L’intégration est épinglée au même instantané, suit le thème clair ou sombre du lecteur et affiche toujours la source, la licence et un lien de retour.

Type

Axe X

Valeur

Agrégat

Thème

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=osfi_pc_insurer_intel%2Fosfi_pc_insurer_quarterly&lang=fr&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>

Connectez-vous pour commenter

Posez une question sur ce jeu de données. Les réponses viennent uniquement de sa fiche, de son profil mesuré et de son historique, et citent les faits utilisés.

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

Suivre ce jeu de données

Citer cet instantané

Intégrer un tableau ou un graphique

Utiliser votre propre clé d’IA